Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tocroi72
Yak Posting Veteran
89 Posts |
 Posted - 2006-02-13 : 13:58:33
|
| hi all,I create a new SQL login using sp_addlogin and then use sp_grantdbaccess to give database access -For some reason my login fail when i try to connect . Error Message as below: Unable to connect to server [server name]Server: Msg 18456, level 16, state 1[microsoft][odbc sql server driver][sql server] login fail for user 'test'Please help. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-13 : 14:18:50
|
| Is this for a SQL account or a Windows account? Did you check Security\Logins in Enterprise Manager to ensure that the login is there?Tara Kizeraka tduggan |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-02-13 : 14:19:17
|
| Your password is wrong.Use sp_password to reset it for the login.rockmoose |
|
|
|
tocroi72
Yak Posting Veteran
89 Posts |
Posted - 2006-02-13 : 16:04:56
|
| Thank you both.I used the password generator software for the password and it gives one with the semi column in it. I am not sure if that is the reason but it work after i took the semi column out...Thank again |
|
|
|
|
|
|
Need help with SQL login