Wednesday, March 21, 2012

MSDE 2000 and ODBC (Connection failed)

Hi
I Installed MSDE 2000 and try to connect with it via ODBC.
I want the connection with SQL Server authentication using a login ID "sa" and blank password
But it is dispaly this message:
====================
Connection failed:
SQLState:'28000'
SQL Server Error:18456
[Microsoft][ODBC Sql Server Driver][SQL Server]Login failed for user 'sa'
====================check what authentication method your msde is using and make sure that standard security is available.|||Thanks ms_sql_dba

My MSDE use both WINDOWS/SQL Server authentication
I check "LoginMode" value in REGISTRY it's = Zero which mean both|||Thanks ms_sql_dba

My MSDE use both WINDOWS/SQL Server authentication
I check "LoginMode" value in REGISTRY it's = Zero which mean both|||Up 4 Help|||I found the Solution in Archive which guide me to this link:
http://www.dbforums.com/showthread.php?threadid=711306

The Solution is very simple:
Change "SA" password

use this command line in DOS:
osql -Q"exec sp_password null,'newpassword','sa'" -E

No comments:

Post a Comment