Problem connecting SQL Database

Problem connecting SQL Database, login faild... help

[RobE]

Hi, proggs...

I think I have a problem with the dsn-link. I made the dsn connection in SYSTEM-DSN in windows 2000. I´m using a simple connection on my ASP page:

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=dsn-name"

..and Explorer Says:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'computername\IUSR_'computername'.
/connections/dbConn.asp, line 5

Is there somthing wrong with the dsn-link?

Thanx...

[Xoc]

No. Something is wrong with the permissions. In IIS, each user who hits a web page is logging into the server as IUSR_<computername>, where <computername> is the name of your computer. You need to give this user permissions to access your your SQL Server database.

[ralnikov]

or set SQL Server login and password in DSN

[truecomp]

Hello everyone,

I have the same problem here:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
/ConnStr.Asp, line 3

Any suggestion?
Many thanks.

Tim

[jatar_k]

Welcome to WebmasterWorld [webmasterworld.com] truecomp

Have you tried correcting/checking the permissions as mentioned by Xoc above?