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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-03 : 08:19:21
|
| Vishwanath writes "We had a mdf(SQL SERVER DATABASE) file in a remote location. We got the hard disk to our office. When we try to attach the mdf file by copying the hard disk it is prompting with a error 5173 ."Cannot Associate with different Database".What we suspect is some one has changed the password or has played with the .mdf file of the .mdf and as we dont know how to crack the password nor we have the password, the question is how to attach to a sql server sucessfully and retrieve the data." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-03 : 13:03:36
|
| You don't need a password to attach an MDF file. What is the command that you ran to attach the MDF? Hint, use sp_attach_single_file_db.Tara |
 |
|
|
|
|
|
To remove password from mdf file and attach it.ERROR 5173