467,917 Members | 1,397 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

can not open user default database , login failed

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...

Oct 22 '08 #1
  • viewed: 6025
2 Replies
Expert 2GB
I don't think you connect to SQL Server by pointing to the FileGroup.

Try this.

Happy coding!

-- CK
Oct 22 '08 #2

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...

Oct 22 '08 #3

Post your reply

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

Similar topics

2 posts views Thread by PA | last post: by
1 post views Thread by Gopalan | last post: by
2 posts views Thread by dennist685 | last post: by
4 posts views Thread by Brett | last post: by
3 posts views Thread by David C | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.