Problem registering sql server

I am attempting to connect to a SQL Server across the Internet, when I
attempt to register the server through the Enterprise Manager using the IP
provided by the web hosting provider, I get the following error :"SQL Server
does not exist or access denied" , I was told by them that I should change
the default port from 1433 to 4000. I don't know where in SQL Servre i could
make this modification. Anybody knows how?
I have 2 instances of SQL Server, the default one and another named
instance, I am using the named instance, the default one has problems & is
not working, so changing this port thing would be related to the instance I
am working on or to the SQL Server as a whole?
Thanks in advance.You can use the Client Network Utility to specify ports -
select properties for the TCP IP protocol and define the
port. The named instance would normally go through the
resolution service to determine what port it is listening
on.
Either way, you can always just create an alias using the
Client Network Utility and specify the ports when setting up
the alias.
-Sue
On Wed, 26 Jan 2005 04:19:03 -0800, JessyEzzy
<JessyEzzy@.discussions.microsoft.com> wrote:

>I am attempting to connect to a SQL Server across the Internet, when I
>attempt to register the server through the Enterprise Manager using the IP
>provided by the web hosting provider, I get the following error :"SQL Serve
r
>does not exist or access denied" , I was told by them that I should change
>the default port from 1433 to 4000. I don't know where in SQL Servre i coul
d
>make this modification. Anybody knows how?
>I have 2 instances of SQL Server, the default one and another named
>instance, I am using the named instance, the default one has problems & is
>not working, so changing this port thing would be related to the instance I
>am working on or to the SQL Server as a whole?
>Thanks in advance.sql