Re: Why is it so hard to connect SQL2000 over Static IP?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

How are you attempting to connect? Do you have TCP enabled in the Server
Network Utility and is it set to port 1433? What authentication are you
using, Mixed or Windows? Can you post your connection string?

--
Andrew J. Kelly SQL MVP


"ARTMIC" <ARTMIC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:93E889D7-D61D-46B9-AD19-8FCB14EC6EC7@xxxxxxxxxxxxxxxx
Why did i wait? good question, lol
becuase i'm trying to learn it, so i figure if i do it myself i will
retain
this longer, than asking and forgeting it in 6 months lol

Well the Static IP is working, the router forwards both 1433 and 5000
ports
to the server on the local area network, but still it does not work,
gives me crazy message about server not being there or access denied,...
grrrr

"Andrew J. Kelly" wrote:

SQL Server communicates on port 1433 so make sure that is open all the
way.
If you are connecting directly via an ip address and port 1433 or don't
care
if others see the server you don't need the browser. Why would you spend
2
weeks before asking for help?


--
Andrew J. Kelly SQL MVP


"ARTMIC" <ARTMIC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4B831C83-9C47-4D54-AA5A-BEC2A23A8C1B@xxxxxxxxxxxxxxxx
Why is it so hard to connect SQL2000 over Static IP?
I thought it would be as easy as setting up a static ip with the ISP,
and
forwarding port 5000 from the router to the actual server box, and the
sql2000 instance running on the server would listen to the port and do
its
thing... IT ain't working ... at all.

I expected something like this from Oracle, or someone with some
complicated
DB, not from MS sql, the beauty of ms-sql2000 is that it is so good and
fast,
as well as easy to maintain setup, well NOT THIS TIME.

God we've been doing the setup for that for 2 weeks and no luck...

WE don't even have SQL Browser service running on our Win2000 server in
the
services, and how do you start that process ??? does it even matter? is
it
needed to be able to communicate to the damn server from the outside?





.

Relevant Pages

  • 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)
  • Re: SRV RRs support in Internet Explorer?
    ... The port number could be implicit (i.e. ... At any point in time, a server could fail ... can't effectively LB or backup because NSs cache the records for the TTL ... I still don't see how SRV records would help backup or LB. ...
    (microsoft.public.win2000.dns)
  • Re: Still cant connect to RWW or OWA remotely
    ... I get 'cannot find server or dns error' on both ... TCP [port number]> to open the ports. ... As for error messages when I fail to access RWW with the laptop, ... network, no connection seems possible. ...
    (microsoft.public.windows.server.sbs)
  • Re: cannot send mail from Windows mail
    ... When a username/password combination doesn't work in Windows Mail, ... I mean I dont use it but as outgoing address for my ISP account. ... youir username and password are correct for your mail server". ... Ask your home ISP if they support SMTP on a port other than 25. ...
    (microsoft.public.windows.vista.mail)
  • 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)