pbm while connecting to a remote server

Hi,
I have a pbm while connecting to the remote SQL server.
Recently we hired one win2003 based Dedicated server and installed SQl
server 2000. I have the sa password and the ip of the server, and when i
connect to this server from my local machine by configuring client n/w
utility, its giving me the error. like SQL server Does not exists ?
What shall i do ? i've disabled the firewall also, but not successful yet.
Also one more problem. The version i've installed is Enterprise Edition, and
will there be any problem if i uninstall it and reinstall the Standard
edition?
Thanking u in advance LaraHi
You should have no problems with un-installing Enterprise Edition and
re-installing Standard if you are not using any of the additional features
that it has. You may want to look at
http://support.microsoft.com/defaul...b;en-us;Q314546 for
transferring logins and dealing with Orphaned users if you have them. Make
sure that the new version is service packed and patched to the same level.
Backing up your database before un-installation will make sure that you have
a safe copy.
When you install the new system make sure that the correct protocols are
listed on the server's server network utilities. Check that you can ping the
server from your client and that the client also has the correct network
protocols. You may want to try SQLPing or SQLRecon to see if the server is
contactable.
John
"lara" <lara@.l.com> wrote in message
news:eOx2EApZFHA.1088@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a pbm while connecting to the remote SQL server.
> Recently we hired one win2003 based Dedicated server and installed SQl
> server 2000. I have the sa password and the ip of the server, and when i
> connect to this server from my local machine by configuring client n/w
> utility, its giving me the error. like SQL server Does not exists ?
> What shall i do ? i've disabled the firewall also, but not successful yet.
> Also one more problem. The version i've installed is Enterprise Edition,
> and
> will there be any problem if i uninstall it and reinstall the Standard
> edition?
>
> Thanking u in advance Lara
>|||I missed out the link for SQLPing and SQLRecon!
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23nvI0tqZFHA.1404@.TK2MSFTNGP09.phx.gbl...
> Hi
> You should have no problems with un-installing Enterprise Edition and
> re-installing Standard if you are not using any of the additional features
> that it has. You may want to look at
> http://support.microsoft.com/defaul...b;en-us;Q314546 for
> transferring logins and dealing with Orphaned users if you have them. Make
> sure that the new version is service packed and patched to the same level.
> Backing up your database before un-installation will make sure that you
> have a safe copy.
> When you install the new system make sure that the correct protocols are
> listed on the server's server network utilities. Check that you can ping
> the server from your client and that the client also has the correct
> network protocols. You may want to try SQLPing or SQLRecon to see if the
> server is contactable.
> John
>
> "lara" <lara@.l.com> wrote in message
> news:eOx2EApZFHA.1088@.TK2MSFTNGP14.phx.gbl...
>|||Thanks John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eNJEsvqZFHA.3572@.TK2MSFTNGP12.phx.gbl...
> I missed out the link for SQLPing and SQLRecon!
> http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26
> John
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23nvI0tqZFHA.1404@.TK2MSFTNGP09.phx.gbl...
features
Make
level.
i
Edition,
>