SQL Server through MMC ?!

[smatanza]

Hey guys !!
Anyone knows where i can activate the access to my SQL server through MMC ?!
I mean, to have access like the MSSQL1.JODOSHARED.COM and how can i give an alias (MSSQL1 in the example) to the server ?.
I already have open the 1433 tcp port for inbound requests in my firewall and active the rpc server to allow connections.
Thanks in advance for your help !!

 

[Inka]

Hi,

I hope I am understanding you

Hey guys !!
Anyone knows where i can activate the access to my SQL server through MMC ?!
I mean, to have access like the MSSQL1.JODOSHARED.COM

Open SQL Server Enterprise Manager
Expand "Microsoft SQL Servers"
Right click on SQL Server Group
Choose New SQL Server Registration
A wizard will be open, check the box "from now on I want to access these options without the wizard"!!
In the server field put MSSQL1.JODOSHARED.COM
Use SQL Server authentication and provide the login name and password you created using H-SPHERE
Uncheck "Show system databases ..."

Press OK and accept the other prompts. You'll be able to access your DBs

and how can i give an alias (MSSQL1 in the example) to the server ?. I already have open the 1433 tcp port for inbound requests in my firewall and active the rpc server to allow connections.
Thanks in advance for your help !!

Go to
Start \ Programs \ Microsoft SQL Server \ Client Network Utility

Click on the "Alias" tab, fill the fields and press OK

Sometimes setting this is not enough (for example for database replication), so if you have any problems, edit the HOSTS file in WINNT\System32\drivers\etc (not sure about the path )

Good Luck