Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2006
    Posts
    4

    Unanswered: MSSQL 2000 - cant connect to DB from remote computer

    Please bare with me as I do not have much knowledge in this area with MSSQL.

    I have installed MSSQL 2000 Developer and I have setup a database which I am able to connect to and work fine with from the actual server MSSQL is installed on.

    The problem comes in when i try to connect to that same database from a different remote server. It will not connect to the DB from this remote server but I know all the connection information is correct so its something on the MSSQL DB server causing this and not on this remote server.

    Someone I know has had this problem and has fixed it but they wont tell me how. All I know is they said something about manually opening the ports on the MSSQL server and he also said when you set it to dynamicly determine the port that MSSQL is listening on it errored out. however if you set it staticly to 1433 it worked fine.

    Ive also installed SP4 in attempt to fix this but no luck with that either. And I can also get the same exact remote server to connect to completely different DB server without issues.


    If anyone can please help walk me through this I would be greatly appreciate and I am also willing to pay some money if it will make my life easier.

  2. #2
    Join Date
    Dec 2004
    Posts
    46
    Can "Developer Version" be connected from a remote client?

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    While these directions are specifically for SQL 2005, I'm pretty sure that they'll work for SQL-2000 too.

    -PatP

  4. #4
    Join Date
    Jun 2006
    Posts
    4
    Ronin- Yes it can be done.

    Pat- The firewall is completely disabled. It says Windows Firewall and ICS(internet connection sharing) is disabled when I try to go to the firewall settings so I dont think thats the problem unless I have to enable it and then do this but that doesnt make much sense.

  5. #5
    Join Date
    Jun 2006
    Posts
    4
    can anyone help?

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Which SQL network libraries did you select?

    -PatP

  7. #7
    Join Date
    Jun 2006
    Posts
    4
    named pipes, tcp/ip, nwlink ipx/spx, VIA giganet

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •