Re: Connecting to SQL Without Windows Authentication

From: Steve Thomas (sTHomas@ic-group.net)
Date: 02/05/03 

From: "Steve Thomas" <sTHomas@ic-group.net>
Date: Tue, 4 Feb 2003 16:11:51 -0800

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: Beginners Questions
    ... We do use Windows form on the presentation layer which is on ... terminal server and call web services on the business logic side. ... of using "proxy" authentication on SQL Server. ... > I have written an app with a Windows Forms UI that is deployed to clients ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Windows Authentication and software in a hosted environment.
    ... What type of authentication are you using for the VPN? ... If you are using something like ISA server then the user is passing windows ... In my experience with hosted DB solutions almost always SQL auth is used. ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing SQL Server w/ Forms on Intranet
    ... Windows Integrated Authentication as that is what our network runs on. ... > of authentication are you using on SQL Server - Windows? ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: SQL / IIS Application Pool Identity
    ... Set the authentication tag in web.config to "windows" (this way it actually ... to sql, which will obviously be different for each user. ... I want to use the application pool identity to make the> connection to the SQL server database. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Need help configuring Wireless Connection profile
    ... and I can only use the intel OR windows utility, not both at the same time. ... Windows authentication for all users,4129,LRG\ryanv,4149,Wireless WPA2 ... SMALL BUSINESS SERVER: ... STEP #1 Install Certificate Services ...
    (microsoft.public.windowsxp.general)