Web Development

Ask something
Discussion Locked

SQL Server Connection Error

0 helpful
4 replies

by mypc83

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i am trying to connect to the sqlserver,i've created step by step a dsn and i've chosen SQL server authentication,but i received this error

*****************************
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ?THUY?

please help me as soon as possible
Thanks
Thuy,

4 replies

by dr. soft

You didn't mention the tool you are using for administrating you SQL server. Something like 'Enterprise Manager' that only ships with a full blown lisnced version of SQL Server 2000.
If you don't have any thing to manage the sql server then proceed as follow;
Un-install your current server installation and restart the PC. Re-install the SQL Server and at its step-7 titled 'Services Accounts' check the Radio-button 'use the same account for each service' and under the 'Service Settings' heading, check the radio-button 'Use the local system account'. Thats all what is needed.

This discussion is closed to new replies.