Friday, March 23, 2012

How to register local server in sql server 2005?

How to register local server ? In management studio?
thanks very much for any help...

Hi,

You are correct - you would need to register the local default instance in SQL Management Studio.
In Management Studio goto View Menu and select "Registered Servers". You should see the Registered Servers Window. Next Right Click on the Database Engine within this window and select "New Server Registration".

In the Server Name textbox, u can type in one of the following:
1. Machine Name
2. (local)
3. IP Address of Machine

Next click Save to register the server.
Regards,
Vikram|||Hi,Vikram.
thank you...
I try follow your steps...
but
"an error has occurred while establishing a connection to the server. when connecting to sql server 2005, this failure may be caused by the fact that under the default settings sql server does not allow remote connections."
...
How to "allow remote connections"?.....Tongue TiedTongue TiedTongue Tied|||

Hi,

In order to enable remote connections you need to use the "SQL Server Surface Area" configuration tool. This is available under:Configuration Tools submenu within the SQL Server 2005 menu.

Start "SQL Server Surface Area" tool, and select the option - "Surface Area Configuration for Services and Connections."

There select the Remote Connections node within the Database Engine node. Select the radio button which says Local and Remote Connections and Apply the configuration.

Regards,
Vikram

No comments:

Post a Comment