Problem connecting to SQL server 2000

• Siddu-916480

  SSC Journeyman

  Points: 86

  More actions

  October 15, 2009 at 8:02 am

  #139542

  HI,

  I have a problem on my SQL server 2000.

  We had a migration from old one to new one. As a part of it, detached all the dbs and moved it and attached them to new one.

  But default database set for old one was not master but was some other user database. When I tried connecting the old server after restarting, it says "could not login to deafult database, login failed".(as that databse is no more in the old server)

  Please let me know how to start the old server now with master databse as the default db.???

  Thanks,

  Siddu

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  October 15, 2009 at 8:33 am

  #1066302

  Siddu-916480 (10/15/2009)

  ---

  HI,

  I have a problem on my SQL server 2000.

  We had a migration from old one to new one. As a part of it, detached all the dbs and moved it and attached them to new one.

  But default database set for old one was not master but was some other user database. When I tried connecting the old server after restarting, it says "could not login to deafult database, login failed".(as that databse is no more in the old server)

  Please let me know how to start the old server now with master databse as the default db.???

  Thanks,

  Siddu

  Not sure I understand the question, the default database has nothing to do with startup, it is the default database that is used by a login. Use a different login to connect to the server and change the login that you were trying to use and change the default database.

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]

• r_prasanna82

  Mr or Mrs. 500

  Points: 516

  More actions

  October 16, 2009 at 3:32 pm

  #1067249

  Hi

  I couldnt understand the question properly. Could you elabrote it. Moreover by seeing the error it shows clearly that the user does not have acces. Hence login with a diferent user and change the user access as mentioned in the above post.

  Thanks