Access to SQL Server 2000 remotely

I have installed SQL Server at my home computer. I can access from another
computer over internet. But from my company, I can't.
I talk to IT administrator, but he doesn't understand a lot abou this issue.
Any help?
What th IT should do to I have access?
Thanks,
Jose
You will need to allow the appropiate ports on your firewall. SQL
Server uses by default 1433 (which you might have changed during
install or configuration) unless you dont allow this port on the
firewall you wont be able to access the Server.
Most companies do not open these ports and do not even consider doing
it (which is recommended)
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||IT probably has the port blocked on the firewall, as they should. Let them
know the port your SQL Server is using (viewable in the SQL Server Errorlog
if you are not sure)
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jos" <Jos@.discussions.microsoft.com> wrote in message
news:2830F020-B38D-45A1-A490-5BF48A26269A@.microsoft.com...
>I have installed SQL Server at my home computer. I can access from another
> computer over internet. But from my company, I can't.
> I talk to IT administrator, but he doesn't understand a lot abou this
> issue.
> Any help?
> What th IT should do to I have access?
> Thanks,
> Jose
>
|||I'm just testing...
My SQL Server is configured to port 1433, is it possible to configure to
another port? For example port 80 only to tensting
Thanks
"Jens" wrote:

> You will need to allow the appropiate ports on your firewall. SQL
> Server uses by default 1433 (which you might have changed during
> install or configuration) unless you don′t allow this port on the
> firewall you won′t be able to access the Server.
> Most companies do not open these ports and do not even consider doing
> it (which is recommended)
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
|||How can i see the ports available?
Thanks
"Kevin3NF" wrote:

> IT probably has the port blocked on the firewall, as they should. Let them
> know the port your SQL Server is using (viewable in the SQL Server Errorlog
> if you are not sure)
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "José" <Jos@.discussions.microsoft.com> wrote in message
> news:2830F020-B38D-45A1-A490-5BF48A26269A@.microsoft.com...
>
>
|||Most likely through the firewall configuration utility...I'm not a network
guy, so I can't really assist you much there
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:2980F9B4-FA99-4D1F-925A-42C95F039AE4@.microsoft.com...[vbcol=seagreen]
> How can i see the ports available?
> Thanks
> "Kevin3NF" wrote:
|||You can use a microsoft telnet tool to find out whether you can telnet into
the destination server on a particular port. On the destination server side,
do a netstats to find out the list of portnumbers that are already being
used.
By default, 1433 is the port no that sql server listens on. You can change
it using server network utility. However
when the client tries to connect, make sure that the client network uility
is also configured with the port number changes.
thks,
Mani
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:2980F9B4-FA99-4D1F-925A-42C95F039AE4@.microsoft.com...[vbcol=seagreen]
> How can i see the ports available?
> Thanks
> "Kevin3NF" wrote:
|||Where Can I find microsoft telnet tool? I tried to find microsoft downloads
but I didn't find.
Could you help me?
Thanks
"Manikanth" wrote:

> You can use a microsoft telnet tool to find out whether you can telnet into
> the destination server on a particular port. On the destination server side,
> do a netstats to find out the list of portnumbers that are already being
> used.
> By default, 1433 is the port no that sql server listens on. You can change
> it using server network utility. However
> when the client tries to connect, make sure that the client network uility
> is also configured with the port number changes.
> thks,
> Mani
>
> "Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
> news:2980F9B4-FA99-4D1F-925A-42C95F039AE4@.microsoft.com...
>
>
|||You can use the hyperterminal software to check if you can telnet into that
remote host server on tcp/ip 1433. YOu can find that hyperterminal under
accessories-->communication
thks,
Manikanth
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:95A1ADE8-C3EE-4878-A81C-3A8AE2075E64@.microsoft.com...[vbcol=seagreen]
> Where Can I find microsoft telnet tool? I tried to find microsoft
> downloads
> but I didn't find.
> Could you help me?
> Thanks
> "Manikanth" wrote: