By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,574 Members | 1,968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,574 IT Pros & Developers. It's quick & easy.

can not open user default database , login failed

P: 6
hi ,
i use VS2005 and i have sqlserver 2000 and SQL Express 2005...

my problem :
i have one database that it is built in sql server2005 (.ldf & .mdf) i want to connect to it from VS2005 , i did it :

in window of ServerExplorer ,
i right click on Data connection and selected addConnection

in box of addConnection for data source i selected Microsoft SQL Server Database File (SqlClient)

for database file name i get path of .mdf file

when i select TestConnection button display this message:
can not open user default database , login failed.login failed for user ' XX/XXXX'.

please help to me for solve this problem step by step...

thanks..
Oct 22 '08 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
I don't think you connect to SQL Server by pointing to the FileGroup.

Try this.

Happy coding!

-- CK
Oct 22 '08 #2

P: 6
hi

at first thanks for your answer...
i couldn't open your link but when i copy files of this data base and paste them on other path and connect to this database in new path it do successful...

please help me if can you...

thanks
Oct 22 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.