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 |
|
zaty2405
Yak Posting Veteran
58 Posts |
 Posted - 2010-04-15 : 08:03:09
|
| Hi,The installation of a new application using userid americas\XXXX supposed to automatically create a new database . But the database was not created instead sql log showing error messages:Login failed for user 'americas\XXXX'. [CLIENT: <local machine>]Error: 18456, Severity: 14, State: 16.This userid has a Sysadmin access on the server and sql server itself.I tried to remove and add the userid but still encountered same errorKindly helpThank youRegards |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2010-04-15 : 09:32:33
|
| State=16 means that the incoming user does not have permissions to log into the target database.What is the users default database? Is that database online?Try logging the user into some other database, and then switching to the target database. |
 |
|
|
zaty2405
Yak Posting Veteran
58 Posts |
Posted - 2010-04-15 : 21:32:49
|
| Thanks.The default database is master and the userid has an access to master.I tried to use other database but still encountered same error. |
|
|
|
|
|
|
Login failed for user XX [CLIENT: <local machine>]