In Enterprise Manager, Server is not logging in

• kalmazz

  SSC Journeyman

  Points: 97

  More actions

  March 16, 2005 at 6:48 am

  #87011

  hello

  I Detached the user default database from the server (Using EM) and when i was attaching the database,there is a problem. Enter prise Manager is working but In a servergroup, a particular server is not opened(Expand). It shows the error as  cannot open user default database, Login failed, i entered in EM using sa login.

  Please any one can help me in this regards.

  thanx in advance.

  by

  yas

• Kishore-132325

  Hall of Fame

  Points: 3784

  More actions

  March 17, 2005 at 2:36 am

  #547481

  You may connect using QA and change the default database for the login using sp_defaultdb.

  EXEC sp_defaultdb 'login', 'database'

  --Kishore