Results 1 to 11 of 11
  1. #1
    Join Date
    Jan 2002
    Location
    Monterrey, Mexico
    Posts
    172

    Question SQL 2000 and WIN 2003 Problem

    I can not connect to the sql server even with the correct user and pass for me looks like the port 1433 is blocked,connection string gives an error that SQL Server does not exist or Access Denied

    Could somebody tell me how to open this port on win 2003?

  2. #2
    Join Date
    Dec 2003
    Posts
    141
    Firstly, you'll need to make sure your firewall is accepting the ports needed to access SQL remotly.

    Secondly, do you have SQL Server configured and running properly? I say this because I seem to remember you need to have so many service packs installed before SQL 2000 will run on Server 2003. Perhaps I am thinking of something else, but if memory serves, they wont work together right outa the box.

    WinApp

  3. #3
    Join Date
    Jan 2002
    Location
    Monterrey, Mexico
    Posts
    172
    Thanks

    The conection works fine internaly but i can nnot access the sql server froom a remote looks like the port 1433 is closed but i have no idea how to open it

  4. #4
    Join Date
    Dec 2003
    Posts
    141
    what firewall are you running?

    btw. Default installations of SQL Server monitor TCP port 1433 and UDP port 1434

  5. #5
    Join Date
    Jan 2002
    Location
    Monterrey, Mexico
    Posts
    172
    just windows, nut it is admiting just conections on the dns and ftp ports

  6. #6
    Join Date
    Dec 2003
    Posts
    141
    I'm assuming you mean IPSec Policies? or internet connection firewall, or whatever MS calls it. or nothing at all?

  7. #7
    Join Date
    Jan 2002
    Location
    Monterrey, Mexico
    Posts
    172
    I just installed win 2003 enterprise out of the box

    i checked netstat and myserver is just listening

    tcp domain
    http
    epmap
    microsoft-ds
    1025
    1026
    1029
    1962
    3389
    5631
    8086
    43958
    ftp
    netbios-ssn
    5631

  8. #8
    Join Date
    Dec 2003
    Posts
    141
    hmm... rebooting dosnt do anything for ya?

  9. #9
    Join Date
    Jan 2002
    Location
    Monterrey, Mexico
    Posts
    172
    no i already did it

  10. #10
    Join Date
    Dec 2003
    Posts
    141
    Last edited by WinApp; 05-31-2004 at 01:33 AM.

  11. #11
    Join Date
    Dec 2003
    Posts
    141

Posting Permissions

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