Re: Why is it so hard to connect SQL2000 over Static IP?
- From: ARTMIC <ARTMIC@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 13 Feb 2006 16:45:29 -0800
Hello Andrew,
i figured it out,... lol
My connection string looks like this right now, and it WORKS:
data source=12.12.12.12,5000;persist security info=True;initial
catalog=POTrax2;User ID=TheID;Password=ThePASS;Alias
Name=ServName;Protocol=TCP/IP;Server=12.12.12.12;Port No=5000;
Yeah i know, lol, the above connection string is probably overkill... but it
worked. i was pasting and copying stuff together and boom it worked.
I also had to enable Routing / Remote access in Win2000 Server... damn noboy
said that had to be done... everything else was setup..
At least i learned something.
"Andrew J. Kelly" wrote:
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?
- References:
- Re: Why is it so hard to connect SQL2000 over Static IP?
- From: Andrew J. Kelly
- Re: Why is it so hard to connect SQL2000 over Static IP?
- From: Andrew J. Kelly
- Re: Why is it so hard to connect SQL2000 over Static IP?
- Prev by Date: Re: Specifying Port SQL Server 2000 Listens On
- Next by Date: Re: There are multiple accounts with name MSSQLsvc/ad.domain of type DS_SERVICE_PRINCIPAL_NAME
- Previous by thread: Re: Why is it so hard to connect SQL2000 over Static IP?
- Next by thread: There are multiple accounts with name MSSQLsvc/ad.domain of type DS_SERVICE_PRINCIPAL_NAME
- Index(es):
Relevant Pages
|
