If I change the IP addresson the server that I am running
SQL Server on I can no longer access Enterprise Manager?
How do I fix that?Sounds like a name resolution problem.
Suggest registering the servers IP Address in EM rather than it's name
--
HTH
Ryan Waight, MCDBA, MCSE
"Bryan" <earlyriser@.knology.net> wrote in message
news:34c601c397e8$980dbd70$7d02280a@.phx.gbl...
> If I change the IP addresson the server that I am running
> SQL Server on I can no longer access Enterprise Manager?
> How do I fix that?|||Hi
If EM is using the IP address in the server registration, you will have to
remove the registration and re-register it. If you have not changed your DNS
(or hosts file) to reflect the new IP address then you will not be able to
access the server.
Can you PING the server by name?
John
"Bryan" <earlyriser@.knology.net> wrote in message
news:34c601c397e8$980dbd70$7d02280a@.phx.gbl...
> If I change the IP addresson the server that I am running
> SQL Server on I can no longer access Enterprise Manager?
> How do I fix that?|||Hi
If it is a name resolution problem then it would be better to sort out the
network problem!
John
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:u9qZKn%23lDHA.3256@.tk2msftngp13.phx.gbl...
> Sounds like a name resolution problem.
> Suggest registering the servers IP Address in EM rather than it's name
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "Bryan" <earlyriser@.knology.net> wrote in message
> news:34c601c397e8$980dbd70$7d02280a@.phx.gbl...
> > If I change the IP addresson the server that I am running
> > SQL Server on I can no longer access Enterprise Manager?
> > How do I fix that?
>
No comments:
Post a Comment