SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 User Connectivity
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dbalearner
Posting Yak Master

238 Posts

Posted - 06/08/2009 :  22:27:10  Show Profile  Reply with Quote
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.
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000