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 MSDE instance remotely

I have a named instance of MSDE running on my windows 2k3 web server. I can connect just fine using ODBC to that DB whailst I am on the server.

I would like to be able to create an ODBC connection from my local machine (running Windows XP pro) to the MSDE database on my server but I can't get it going.

I have heard that I need to edit the registry but a Google search warns that this could be a vulnerability...

How do I do it without compromising the security of my web server?

TIAMostly, when you install MSDE by default settings, net library are not installed. Have a look to the Readme.html, or install Network client ton activate Named pipes or TCP/IP.|||I have the SQL server network utility installed as I can see it when I use the command svrnetcn.exe

Do I need to add a new pipe? I'm a noob at this sort of thing I'm afraid so an idiot proof answer will probably be needed! :D|||Next to what you said above, it seems that there is no net library installed. So install Named pipes and TCP/IP. Confirm, and try aggain to connect to the named instance from your machine.|||I'm sorry but I don't follow you. How do I do this?|||ok progress "I think"

I'm now connecting to the server but I get this:
http://www.openmindhosting.com/odbc.jpg

I'm using the same login I use for RDC connections to the server so I know its the admin account...|||Good ! Now, I think the problem is the authentication (I can see login failed for 'Administrator').

Try to use the account sa with its password (you must have configured it at install). If not, it must be empty (that is a bad thing :D )|||ok I finally managed to login through ODBC. I had to log off on my local machine and then logon using the same username and password as the server. I then adjusted the ODBC connection so that it used windows authentication and itc reated the datasource!

Marvellous I thought! :)

Logged back off and then back on as my normal user, which is also an admin account and then tried to set the datasource in the ColdFusion adminstrator and was told it was not a trusted connection for user NULL. Grrrrrrr :mad:|||So, good ! :)|||It would be if I didn't want to use CF to connect to the database! ;)

I'll figure it out... Thanks for your help...|||Sorry, I don't know how ineract Coldfusion with SQL. Maybe you would ask to r937 (http://www.dbforums.com/member.php?u=7592) ? I think he knows CF !