Problem connecting to SQL with ASP

[Trmbne2000]

Hi,

I am making a pressroom application, which will serve up limited numbers of news articles on our site. I am using a brand new development server which was just installed. It has both the web server and the SQL server running on the same box. For some reason, none of my ASP scripts can connect to the SQL server on that box, but I can connect to databases on other boxes just fine. Is this a problem in the SQL or the IIS confiruration?

Thanks,
Andrew

[christopherpond]

Sounds like SQL Server security issue, can you log into Enterprise Manager (0r 2005 SQL Server Management Server) using the credentials specified in your connection string?

[christopherpond]

Actually, what is the error message you receive upon connection failure? Is it the usual uninformative one saying something about "Remote connections"

[Trmbne2000]

I can log in using SQL Server Manager using the same credentials. The error I get when executing the script is:

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user 'ASteenbuck'.

/www/com/pressroom/includes/news.asp, line 14

[jhardman]

I can log in using SQL Server Manager using the same credentials. The error I get when executing the script is:

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user 'ASteenbuck'.

/www/com/pressroom/includes/news.asp, line 14

this is a SQL server problem. You need to go into the db manager, turn off windows user authentication, and add a specific user to the db you need to access, then the connection statement needs to reflect that, like this:

set connect = server.createobject("ADODB.connection")
   connect.open "DSN=myDBTable;UID=myUserID;PWD=myPwd"

It took me months to recover from this last time I changed servers.

Jared