Home > IT Answers > SQL Server > SQL Server enterprise manager
Cslaybec
5 pts.
 SQL Server enterprise manager
SQL Server Enterprise Manager, SQL Server Enterprise Manager Database Connection
how to register enterprise manager to connect to database

Software/Hardware used:
ASKED: April 24, 2009  2:34 PM
UPDATED: June 1, 2010  6:38 PM
RELATED QUESTIONS
Answer Wiki:
Right click on the folder and select Register Server. Fill in the connection details.
Last Wiki Answer Submitted:  April 26, 2009  3:59 am  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What do you mean registering? Normally you should select the SQL server, the Auth type and type in the correct credentials…that’s all

Alessandro Panzetta
 0 pts.
 

Will it affect the already registered server in the local administrator profile?

wrathyimp
 50 pts.
 

will this help my case.

sp_addsrvrolemember [@loginame =] ‘admin1′, [@rolename =] ‘sysadmin’

This command should be executed from administrator account which is currently having the access to the sql server?

wrathyimp
 50 pts.
 

No, that SQL Code will add another user to the sysadmin role.

Registering additional servers in Enterprise Manager won’t change the other registrations that you have setup already.

Denny Cherry
 64,505 pts.