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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 User Connectivity

Author  Topic 

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2009-06-08 : 22:27:10
Hi Patrons,

I have a user who connected from the Intranet based application and enter a record and stored in the database successfully.

However, this user when checking the record from the database is not visible and the application redirects this record back to the user normally, but now it is not.

When checked the user has the login failure problem which when toured to see its 18456 Error and Severity 14 and State 16

Which states the Target database couldnot be determined.

However when correcting the user authentication, its says:

try logging the user into some other database and then try using the USE DATABASE command to switch to the target database, you will get a better error message as to the root cause of the failure

But uanble to do it .

Can anyone direct me as to what I need to do, may be this is very small but I admit I couldn't find after getting the solution as mentioned above.

Thanks for your answers in advance.
   

- Advertisement -