|
|
You're in the
sql server connect
group:Why is it so hard to connect SQL2000 over Static IP?
sql server connect:
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
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 [quoted text, click to view] "ARTMIC" <ARTMIC@discussions.microsoft.com> wrote in message news:4B831C83-9C47-4D54-AA5A-BEC2A23A8C1B@microsoft.com... > 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?
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 [quoted text, click to view] "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@discussions.microsoft.com> wrote in message > news:4B831C83-9C47-4D54-AA5A-BEC2A23A8C1B@microsoft.com... > > 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? > >
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 [quoted text, click to view] "ARTMIC" <ARTMIC@discussions.microsoft.com> wrote in message news:93E889D7-D61D-46B9-AD19-8FCB14EC6EC7@microsoft.com... > 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@discussions.microsoft.com> wrote in message >> news:4B831C83-9C47-4D54-AA5A-BEC2A23A8C1B@microsoft.com... >> > 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? >> >> >>
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. [quoted text, click to view] "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@discussions.microsoft.com> wrote in message > news:93E889D7-D61D-46B9-AD19-8FCB14EC6EC7@microsoft.com... > > 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@discussions.microsoft.com> wrote in message > >> news:4B831C83-9C47-4D54-AA5A-BEC2A23A8C1B@microsoft.com... > >> > 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? > >> > >> > >> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
August 2008
| home · blog · groups | Questions? Comments? Contact the dn |