Re: Access to SQL Server 2000 remotely

Tech-Archive recommends: Speed Up your PC by fixing your registry

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:95A1ADE8-C3EE-4878-A81C-3A8AE2075E64@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2980F9B4-FA99-4D1F-925A-42C95F039AE4@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2830F020-B38D-45A1-A490-5BF48A26269A@xxxxxxxxxxxxxxxx
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









.

Relevant Pages

  • Re: SQL2005: Cannot connect error 11001
    ... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • Re: Failed connections to remote 2k SQL Server
    ... It could be a port issue - that would be my first guess. ... you need to open up UDP 1434 for SQL Server name ... TCP Ports Needed for Communication to SQL Server ... >server's network utility, and client network utility, and ensured that they ...
    (microsoft.public.sqlserver.setup)
  • Re: Connecting to an instance in a cluster
    ... Each virtual server has its own IP address so you can reuse port numbers between instances. ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: hack using xp_cmdshell
    ... I'm no security expert, so please forgive if I'm not using the right ... install SQL Server in Windows Only mode and then Switch down to Mixed mode, ... Is the SQL Server instance a default instance? ... > port 65300, which has never been open on my firewall. ...
    (microsoft.public.sqlserver.server)
  • RE: Some technical errors
    ... If the SMTP server is not running on port 25 TCP it is not a public ... Manager - Computer Assurance Services BDO Chartered Accountants & ...
    (Security-Basics)