Re: Connecting to SQL Without Windows Authentication

From: Denny (mrdenny@gamespy.com)
Date: 02/05/03 

From: "Denny" <mrdenny@gamespy.com>
Date: Tue, 4 Feb 2003 16:13:06 -0800

no problem. Let me know. If I'm not I can probally come up with something
else. 

--
Denny Cherry
Database Administrator
GameSpy Industries
"Steve Thomas" <sTHomas@ic-group.net> wrote in message
news:0ab701c2ccab$2e80c4a0$89f82ecf@TK2MSFTNGXA01...
> I will try this first thing in the morning and see what
> happens.  Thanks
>
> >-----Original Message-----
> >This doesn't sound like a liscence problem.  It sounds
> like an
> >authentication problem.  Are you connecting to the SQL
> Server via named
> >pipes or via TCP/IP?  I beleive that going through named
> pipes requires that
> >you log into the machine.  I'd disable Names Pipes on the
> SQL Server,  and
> >restart the SQL Service and then have your workstations
> try again.  That
> >should force TCP/IP connections to port 1433.
> >
> >--
> >Denny Cherry
> >Database Administrator
> >GameSpy Industries
> >
> >"Steve Thomas" <sThomas@ic-group.net> wrote in message
> >news:10b8901c2cca7$4d3ad060$8bf82ecf@TK2MSFTNGXA05...
> >> I just spent about an hour with Microsft Sales on this
> >> issue and I know as much as before the call.
> >>
> >> I have a Windows 2000 server(5 Client Licenses)
> >> Running SQL Server2000 (Per Processor License).  I have
> >> several PC's running win95, Win98, win2000.
> >>
> >> Question 1:  If I connect using SQL Authentication, do I
> >> need to have a license for each user on the WIndows 2000
> >> machine.
> >>
> >> Question #2: if the answer to Question1 is no(I do not
> >> need more CALS on Windows 2000) then I am having
> >> difficulty on some PC's.  I wrote a basic program that
> >> opens an ADO connection to the SQL server.
> >>
> >> Problem1:  Windows 2000 PC's.  Some of them come back
> with
> >> a message "Access Denied".  If I go into network
> >> neighborhood and doubleclick on the server, it will ask
> me
> >> for a name and password.  If I supply it with a valid
> user
> >> name and password on the Windows 2000 server, it will
> >> connect.  Then when I run my program, it will work fine.
> >> WHY??
> >>
> >> Problem2: Windows 98 PC's.  Unless I create a user ID on
> >> the Windows 2000 server that is identical to the UserID
> on
> >> their PC they always get "Access Denied".  Once I create
> >> the user, everything works fine.
> >>
> >> This make me think I need Licenses for each user on
> >> Windows 2000 even though I am using SQL authentication??
> >>
> >>
> >> Any help on this issue would be appreciated.
> >>
> >> thanks
> >
> >
> >.
> >

Relevant Pages

  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.office.developer.web.components)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.inetserver.iis)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.windowsservices)