Fog Creek Software
Discussion Board




SQL Login for Web Server

How do I get the web site to login to SQL Server with an ID other than the web service one?

Graeme Hood
Tuesday, July 16, 2002

Start->Settings->Control Panel->Admin->Internet services manager.  Open up the default web site, right click on the fogbugz virtual directory and choose properties.  Hit the Directory Security Tab.  Hit Edit. Make sure the anonymous access is checked at the top and windows authentication at the bottom is NOT.  Hit Edit.  Set the username and password there.

Michael H. Pryor
Tuesday, July 16, 2002

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.
/bugz/preheader.asp, line 926


I get the above error, even though my ODBC data source is correctly setup. This uses a SQL ID rather than trusted connection. What am I doing wrong?

Graeme Hood
Wednesday, July 17, 2002

OK, forget it, I got it working.

Graeme Hood
Wednesday, July 17, 2002

I am getting the same error message when trying to access the login screen.  Other machines in the office can access it fine.  This is a new PC with windows XP and IE6.0 with the security patch installed.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.
/bugz/preheader.asp, line 926



What did you do to correct it?

David Breitag
Tuesday, August 13, 2002

Sorry, I just got back from 4 weeks hols and haven't a clue what I did to fix this!!
Think it was something to do with the security.

Graeme Hood
Monday, August 19, 2002

*  Recent Topics

*  Fog Creek Home