Online Members

Cannot open user default database. login failed.

Posted Date: 30 Nov 2009 Posted By:: L Sagar

Member Level: Gold Member Rank: 651 Points: 1 Responses: 2

HI ,
I am using sql server 2000 database, In which I am getting error like this
cannot open user default database. login failed.
When ever my perticular databse is opening,Other databases are opening normally by username and password ,So plz tel what is the problem?

Thanks & Regards,
Sagar

Responses

#448560 Author: Asheej T K Member Level: Diamond Member Rank: 2 Date: 30/Nov/2009 Rating: Points: 2
You will get this error when someone changes the default database to a different one and you don't have sufficient privilege to access the same. Go to Enterprise manager--> Database-->security-->Login and see what is the default database for the user id you are using. Refer attached scren shot for more details. Regards, Asheej T K Microsoft MVP[ASP.NET/IIS] DotNetSpider MVM Dotnet Galaxy

#448566 Author: L Sagar Member Level: Gold Member Rank: 651 Date: 30/Nov/2009 Rating: Points: 2
yes ,i checked in login default is master only .Even though i am getting same error . Actually local system databases are opening properly ,while opening remote server by username & password displaying error. Thanks & Regards, Sagar

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Support different languages
	Previous : Cannot resolve the collation conflict ??? What is this ERROR
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription

Talk to Webmaster Tony John