General discussion

Locked

SQL Server Connection Error

By mypc83 ·
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,

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by saurabhambekar In reply to SQL Server Connection Err ...

make sure the user 'THUY' has permissions to connect to the database.

Collapse -

by joseph_pelish In reply to SQL Server Connection Err ...

Make sure that the password is correct as well. Can you login as anyone else, specifically sa?

Collapse -

by prashant.ayyappa In reply to SQL Server Connection Err ...

chk whether the authentication is windows r sql

Collapse -

Easiest fix for SQL Server Connection Error

by farbab2001 In reply to SQL Server Connection Err ...

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.

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums