IIS 5 & IIS 6
SSPI handshake failed and "Login failed for user ''. ..."
Last post Jan 16, 2008 03:52 PM by Chris55
Jan 14, 2008 11:08 PM|Chris55|LINK
I have seen many articles on this subject, but have yet to resolve the issue.
I have IIS on one server and SQL Server 2005 on a second server. Both are stand alone servers and not part of a domain. The SQL Server is sitting behind a firewall with the proper 1433 port being opened. With the firewall set to passing everything and no
restrictions, the same error occurs.
Here is what I have thus far:
I don't know what I'm missing.
If the servers are added to a domain and a domain user is used, everything works fine. However, the security policies I need to work with prohibit public webservers from being part of the domain and this particular database must also be isolated from our
internal LAN and domain.
I've seen many posts on this and I think that I'm doing everything that is said to do.
iis 6.0 windows impersonation
IIS Authentication Guest account
Security User Rights Assignment
Jan 15, 2008 01:12 PM|tomkmvp|LINK
What does your connection string look like? You may also get better help over at
Jan 15, 2008 02:59 PM|Chris55|LINK
Here's the connection string I have. It is an instanced SQL Server btw.
"Server=SQLSERVERINSTANCE; Integrated Security=SSPI; Persist Security Info=false; Initial Catalog=DBNAME; Pooling=true; Min Pool Size = 12; Connection Timeout = 30; "
Jan 15, 2008 09:20 PM|tomkmvp|LINK
Do you have to use Integrated Security? That always seems to be problematic, especially in non-intranet scenarios.
Jan 15, 2008 11:23 PM|Chris55|LINK
Yes I am. And yes it seems to be.
What do your recommend?
Jan 16, 2008 12:58 AM|tomkmvp|LINK
SQL Server security, and set the username and password in the connection string.
Jan 16, 2008 03:52 PM|Chris55|LINK
I was hoping to not have to do it that way if possible. But I will encrypt the user name and password.