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,
JoseYou 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=B4t allow this port on the
firewall you won=B4t 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 the
m
> know the port your SQL Server is using (viewable in the SQL Server Errorlo
g
> 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 int
o
> the destination server on a particular port. On the destination server sid
e,
> 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:
>|||You can also try by Start -> Run -> cmd
and then write the comand
telnet <server_name> <port_number>
this will run telnet. If screen goes black and cursor will show you have
acces to the serwer.
Mariusz Koprowski
"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:
>

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:

Access Reporting Web Service from a remote computer

I just installed SQL Server 2005 and reporting services in my home
computer (XP). From a different computer in my basement connected via
peer to peer network I am able to connect to SQL Server installed in
the computer upstairs byusing a SQL Server login.
I have installed only the client components of SQL Server 2005 in my
computer at the basement. I am now trying to add a web reference to
the reporting services web services from my computer in the basement
by typing in
URL:http:/servername/reportserver/reportservice2005.asmx?wsdl
but I get the following error...
"The page cannot be displayed
The page you are looking for is currently unavailable. The Web site
might be experiencing technical difficulties, or you may need to
adjust your browser settings. "
What am I doing wrong? I am new to this so it is very likely that I am
doing something wrong.
I am able to access page when I paste the same URL in my computer
upstairs where I instaled the reporting services.
My main objective is to try and call the RS web services from the
computer in the basement.
My question is what do I need to do so that I can add web references
of reporting services from a remote computer?
Any help in this reagrd will be greatly appreciated. Any links
pertaining to this will also be very helpful.
ThanksHey why dont you write some asp.net code using web services. I dont know why
you are using directly URL, moreover to do what ?
To access remote of web services you need to change it in config about the
state server settings.
Amarnath
"shub" wrote:
> I just installed SQL Server 2005 and reporting services in my home
> computer (XP). From a different computer in my basement connected via
> peer to peer network I am able to connect to SQL Server installed in
> the computer upstairs byusing a SQL Server login.
> I have installed only the client components of SQL Server 2005 in my
> computer at the basement. I am now trying to add a web reference to
> the reporting services web services from my computer in the basement
> by typing in
> URL:http:/servername/reportserver/reportservice2005.asmx?wsdl
> but I get the following error...
> "The page cannot be displayed
> The page you are looking for is currently unavailable. The Web site
> might be experiencing technical difficulties, or you may need to
> adjust your browser settings. "
> What am I doing wrong? I am new to this so it is very likely that I am
> doing something wrong.
> I am able to access page when I paste the same URL in my computer
> upstairs where I instaled the reporting services.
> My main objective is to try and call the RS web services from the
> computer in the basement.
> My question is what do I need to do so that I can add web references
> of reporting services from a remote computer?
> Any help in this reagrd will be greatly appreciated. Any links
> pertaining to this will also be very helpful.
> Thanks
>