MS SQL Login error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

MS SQL Login error

Author

Topic

zoikina
Starting Member

5 Posts

Posted - 2005-10-14 : 13:18:15

Dear all...

I am not necessarily so new to SQL (MySQL, for example) so much as to SQL server. I have the following situation:

I have a web application which I have developed on a Microsoft Web Server. I connected this application to Data Sources (ODBC) function on the start menu. I have been coding and coding away. When I'm on the web server, I can see my application in all its glory in a browser.

However, when I try to run the web application in a browser on any other machine (including the SQL server), I get an error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I have been all over the Internet and have read a lot that I don't entirely understand about this, and feel like I have tried everything.

There are other web sites hosted on this machine that I know are currently working, and I tried mimicking them. So this is what I think I have going now, which isn't working:

- I have SQL and Windows Authentication checked off.
- I have anonymous user access checked off on the Security Directory tab, using a login IUSR_WEB_SERVER_NAME (although the password MAY be incorrect, but I'm not getting any message to that effect - there is no one around for a while who might be able to confirm whether it's right or wrong)
- I have integrated windows authentication checked off.
- I connect to the database using the following ASP:
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "DB NAME"

If it is simply the password of IUSR_WEB_SERVER_NAME that's holding me back, I guess I'll have to wait, although I'll feel better. It's just odd that something else entirely was there before, and then I changed it, but the error was the same.

Any ideas?

Kristen
Test

22859 Posts

Posted - 2005-10-14 : 13:44:11

Have a look at

http://www.connectionstrings.com/

for how to form a complete connection string.

Kristen