I was under the impression that to register a server remotely in Enterprise Manager you would need to specify its IP address. I have not been able to get this to work and have tried a number of variations of the IP address/server name. Can anyone tell me how this is to be done? Also, what security issues need to be considered when running queries or administering a server remotely? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Registering a Server via IP Address
- Thread starter mdr227
- Start date
You should be able to register in SEM using the IP address. I just tried this again to make sure I wasn't dreaming and it works fine.
You don't need to use the hard IP address though, you can use the system name of the server where SQL server is running, assuming that DNS resolves the name or it's coded in your hosts file, etc.
I'm assuming you can otherwise reach the target server? Have you tried pinging the IP or server name? Lloyd Freiday
You don't need to use the hard IP address though, you can use the system name of the server where SQL server is running, assuming that DNS resolves the name or it's coded in your hosts file, etc.
I'm assuming you can otherwise reach the target server? Have you tried pinging the IP or server name? Lloyd Freiday
I have SQL servers registered both ways, by IP and by server name.
As Lloyd says, have you tried PING against the server? Maybe, you aren't on the same domain. Is SQL 'listening' on a visible port or has the HIDE PORT been checked? Do you have proper permissions?
-SQLBill
As Lloyd says, have you tried PING against the server? Maybe, you aren't on the same domain. Is SQL 'listening' on a visible port or has the HIDE PORT been checked? Do you have proper permissions?
-SQLBill
To Register a SQL Server via IP the using Enterprize Manager follow these steps.
1. On the Start Menu ->Programs-> Microsoft SQL , Click Client Network Library.
2. General Tab add TCP/IP to the enabaled protocols list (if its not already there)
3. on the Alias Tab Click Add
4. Select TCP/IP in the default network library list.
5. Type the Server name in the server alias.
6.Type the IP in the Server name.
7. Overwrite the port number if provided by the host else use the default port number 1433.
Now to add the registered server to the enterprize manager , click on the SQL Server Enterprise Manager , Right Click on the SQL Server Group and select New SQL Server Registration.
Click Next.
Select the server from the list AND Click the Add button.
Now you can connect to the by providing the username and passowrd much like to use to connect to your local SQL Server.
Thats all Folks.
1. On the Start Menu ->Programs-> Microsoft SQL , Click Client Network Library.
2. General Tab add TCP/IP to the enabaled protocols list (if its not already there)
3. on the Alias Tab Click Add
4. Select TCP/IP in the default network library list.
5. Type the Server name in the server alias.
6.Type the IP in the Server name.
7. Overwrite the port number if provided by the host else use the default port number 1433.
Now to add the registered server to the enterprize manager , click on the SQL Server Enterprise Manager , Right Click on the SQL Server Group and select New SQL Server Registration.
Click Next.
Select the server from the list AND Click the Add button.
Now you can connect to the by providing the username and passowrd much like to use to connect to your local SQL Server.
Thats all Folks.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question