Groups | Blog | Home
all groups > iis security > august 2004 >

iis security : Problem With Login Null


Tom Kaminski [MVP]
8/31/2004 10:02:53 AM
[quoted text, click to view]

http://www.aspfaq.com/show.asp?id=2009

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsserver2003/community/centers/iis/
http://mvp.support.microsoft.com/
http://www.iisfaq.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://www.tryiis.com

Riane de Oliveira Torres Santos
8/31/2004 10:03:52 AM
Hi,
I have a problem. My web server is a Windows 2k Server and my database
server a Windows 2003. I use windows authentication to login at SQL Server,
but when I access from a client machine that uses Win 2k Professional I
always receive this message: "[Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.".
When I access from a client machine that uses Windows XP everything it´s
ok.

This problem only occurs at the web site. When I try to access the Query
Analyzer or the Enterprise Manager I still have the connection.

Can anyone help me?!

Thanks,

Riane Santos
riane@cpunet.com.br

Riane de Oliveira Torres Santos
8/31/2004 11:43:59 AM
Thanks Tom,

But in this link there isn´t any problem like mine.

Riane

[quoted text, click to view]

Tom Kaminski [MVP]
9/1/2004 9:31:21 AM
Hmmm, this snippet from that page looks exactly like your problem ...

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed- User:
Reason: Not defined as a valid user of a trusted SQL Server connection.
If you are trying to use Windows Authentication to connect to SQL Server,
make sure the account being used has been mapped to a valid SQL user or
role, and that the user has been authenticated correctly (see Article #2126
and KB #306586).


[quoted text, click to view]

Riane de Oliveira Torres Santos
9/1/2004 11:13:30 AM
Tom,

I have a trusted connection and the accounts are mapped on SQL Server.
I can connect using windows XP, but I can´t connect using Windows 2000
Pro...

Thanks,

Riane

[quoted text, click to view]

AddThis Social Bookmark Button