Making Sql Server public?

8 Sep 2006 9:31 PM

VMI

How can I make my SQL Server 2000 public? I'm moving a web application
to another domain and I need to connect to it via my SQL Server IP
Address. In Query Analyzer in my PC (where the DB is located), I enter
my IP address and my user/password, but it doesn't connect. I have two
instances: COMPUTER_NAME\LOCAL_2000 (the one I need to connect to) and
the Sql server 2005 default instance.
What am I doing wrong?

Thanks.

9 Sep 2006 5:55 PM

Warren Brunk

Do you have a firewall on? Perhaps you need to let in Port 1433. Another
issue might be that you do not have TCP/IP enabled on your SQL 2005
Configuration Manager.
Here are some detailed steps to set allow remote connections for SQL 2005.
http://support.microsoft.com/default.aspx?scid=kb;en-us;914277

--
Warren Brunk - MCITP - SQL 2005, MCDBA

Show quote

"VMI" <mye***@excite.com> wrote in message
news:1157751095.331906.293160@e3g2000cwe.googlegroups.com...
> How can I make my SQL Server 2000 public? I'm moving a web application
> to another domain and I need to connect to it via my SQL Server IP
> Address. In Query Analyzer in my PC (where the DB is located), I enter
> my IP address and my user/password, but it doesn't connect. I have two
> instances: COMPUTER_NAME\LOCAL_2000 (the one I need to connect to) and
> the Sql server 2005 default instance.
> What am I doing wrong?
>
> Thanks.
>