how to connect sql 2000 enterprise manager using SQL Authentication.

• srivivek84

  Mr or Mrs. 500

  Points: 531

  More actions

  March 3, 2011 at 7:25 am

  #100356

  Hi, Iam new to SQL 2000

  I tried to connect using run as and enter my id and password but i am unable to connect to enterprise manager ( id & password which are working for to connect query analyzer).where do we need to supply the id and password if i want to connect using SQL Authentication.

• danschl

  SSCertifiable

  Points: 5770

  More actions

  March 3, 2011 at 9:15 am

  #1294082

  in enterprise manager

  right click on sql server group and choose new server registration

  you can enter it there

• srivivek84

  Mr or Mrs. 500

  Points: 531

  More actions

  March 7, 2011 at 12:35 pm

  #1295534

  I tried as you said ,but i am getting error msg "server already exists"...

• KumarVelayutham

  SSCrazy

  Points: 2204

  More actions

  June 1, 2011 at 1:31 am

  #1332391

  Hi ,

  Go to Enterprise manager->Right Click SQL server Group->Fill All details

  Then Register SQL server by expand SQL server Group and choose New sql server registration.

  Fill with sql authenticated credentails.

  thats's it.

  http:\\sqldbataskwithkumar.blogspot.com

  Regards,
  Kumar