Login problem

Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
we are experiencing som strange problems. If we login to a klient with a
local account, open query analyzer and try to login using 'sql server
authentication', it does not work 'access denied or server does not exist'.
When looking in the security log on the sql server, we can see logon attempts
by the local account from the client computer?! If logon to the same client
with a domain account, everything works fine. My belief was that when using
'sql server auth', windows security had nothing to do with it.. am I wrong.
Thanks for Your help!Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
> we are experiencing som strange problems. If we login to a klient with a
> local account, open query analyzer and try to login using 'sql server
> authentication', it does not work 'access denied or server does not exist'.
> When looking in the security log on the sql server, we can see logon attempts
> by the local account from the client computer?! If logon to the same client
> with a domain account, everything works fine. My belief was that when using
> 'sql server auth', windows security had nothing to do with it.. am I wrong.
> Thanks for Your help!|||Hi Tibor,
Thanks for your your reply.
The server is set up in mixed mode.
Strangly enough, if I connect to a share on the sql server with a domain
account (still logged on with a local account), I have no problem connecting
with the sql login I used earlier...
I've heard rumors that others are also experiencing this problem after
applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
with their reply.
By the way Tibor, I'm attending one of your classes at cornerstone on nov
4th, see you there :-)
Regards,
Erik
"Tibor Karaszi" wrote:
> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Erik" <Erik@.discussions.microsoft.com> wrote in message
> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> > Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
> > we are experiencing som strange problems. If we login to a klient with a
> > local account, open query analyzer and try to login using 'sql server
> > authentication', it does not work 'access denied or server does not exist'.
> > When looking in the security log on the sql server, we can see logon attempts
> > by the local account from the client computer?! If logon to the same client
> > with a domain account, everything works fine. My belief was that when using
> > 'sql server auth', windows security had nothing to do with it.. am I wrong.
> >
> > Thanks for Your help!
>|||Hej Erik,
Perhaps IPC$ has anything to do with it? If you are using Named Pipes, you need to be able to use
IPC$ (at least this is how it used to work, not sure whether it changed). And perhaps you don't get
this validation at the Windows level when you login locally? You can check Client Network Utility on
the client whether you are using NP or IP Sockets.
See you in Nov :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:046970B4-5E32-42CA-812C-7183D197E76B@.microsoft.com...
> Hi Tibor,
> Thanks for your your reply.
> The server is set up in mixed mode.
> Strangly enough, if I connect to a share on the sql server with a domain
> account (still logged on with a local account), I have no problem connecting
> with the sql login I used earlier...
> I've heard rumors that others are also experiencing this problem after
> applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
> with their reply.
> By the way Tibor, I'm attending one of your classes at cornerstone on nov
> 4th, see you there :-)
> Regards,
> Erik
> "Tibor Karaszi" wrote:
>> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Erik" <Erik@.discussions.microsoft.com> wrote in message
>> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
>> > Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
>> > we are experiencing som strange problems. If we login to a klient with a
>> > local account, open query analyzer and try to login using 'sql server
>> > authentication', it does not work 'access denied or server does not exist'.
>> > When looking in the security log on the sql server, we can see logon attempts
>> > by the local account from the client computer?! If logon to the same client
>> > with a domain account, everything works fine. My belief was that when using
>> > 'sql server auth', windows security had nothing to do with it.. am I wrong.
>> >
>> > Thanks for Your help!
>>