Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Security

Login failed for user 'sa'.

Hi,

I am running Ms SQL Server Standard Ed. with IIS 6.0 on a Windows 2003 Server.

Currently having some problems relating to access to database. IIS seem to work fine, as the welcome page which doesn't require access to the SQL database can be opened without a problem. The page which authenticates the login, which contains a fileDSN info to access the SQL via ODBC gives me an error. It says :

Microsoft OLE DB Provider for ODBC Driverserror '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.

But when i created the DSN file under ODBC, the test completed succesfully, using SQL Server authentication with user login and password.

On the other side, At the SQL Enterprise Manager, I check the authentication method, and it is set to Windows and SQL server (Mixed mode).

When i start my server, I receive this message in the event viewer,

SuperSocket info: (SpnRegister) : Error 1355

Does this has anything to do with the problem i m facing?

I tried reinstalling SQL Server, but i still receive this message. I even copied the database and the www pages to publish from my desktop, but no difference...

I m lost. Please help.

Thank you.

[1453 byte] By [Kannanku] at [2007-12-22]
«« automatically saving SAPI output with C#
»» missing Interop.TAPI3Lib
# 1
Do you include the password in the DSN file ?
Andoko at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Security...
# 2

The SuperSocket error does normally not come alone. There has to be another error beside this. Normally SuperSockets Errors are related to the reservation for services. make sure that if you have more than one SQL Server instance installed, that the the instances are using different ports. One port can only be occupied by one instance.

HTH, Jens SUessmeyer.


http://www.sqlserver2005.de

JensSuessmeyer at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Security...
# 3

Hi all,

Nothing seem to work.. I even tried reinstalling MS SQL and IIS.. but still the same results. I created a new user account called user1 for SQL with all the right to access the database, the include the account with the login info into the DSN file, and i'm getting error like Login failed for user 'user1'. I feel that ODBC is not saving or holding the password to be used to login when called by the IIS... I m really confused.... Looks like i have to format the entire HD. What if it doesn't solve the problem... My system is down for three days already... Anyone can help me ? Please

Kannanku at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Security...
# 4

Can you connect manually using the new user account? Also, what is the actual error message from the errorlog? Also, I assume this is SQL Server 2005, right?

Thanks
Laurentiu

LaurentiuCristofor at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Security...
# 5

I'm still using SQL 2000 Standard Edition.

It was running fine for the past one year, suddenly this error occurs.

The error from IE looks like this :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'user1'.

I tried manually test the connection when i create the File DSN, it was succesful. But when run automatically when called by IIS, got this error.

I tried removing the dsn file, and i get this message :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
General error: Invalid file dsn ''

means that fo the earlier case, The dsn file is found but couldn't use the info to log on, rite?

How else can i stream down the problem?

Thanks

Kannanku at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Security...
# 6

Make sure that the password you specify for user1 is correct and that you can actually connect with it using osql or Query Analyzer.

Thanks
Laurentiu

LaurentiuCristofor at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Security...
# 7

Hi I am getting a similar error:

Cannot open database "XXX" requested by the login. The login failed.

Login failed for user 'DAN\Daniel Vasquez '

This is my connection sting:

"Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=XXX;server=(local)";

I am using SQL 2005 Express Edition.

Please help.

Thanks

Dan

DanCR82 at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Security...
# 8
Hi Dan, have a look also here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=611190&SiteID=1&mode=1

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

JensSuessmeyer at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Security...
SQL Server
SQL Server Security

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified