locked
64 bit odbc connection successfull but 32 bit ODBC connection not working in windows 10 RRS feed

  • Question

  • Hi all experts,

    I am getting error while making connection to sql server 2000 on windows server 2003 

    Error 8001 Sql Server does not exists or access denied

    The error is coming on 32 bit ODBC DSN

    On the other hand, I made connection using 64 bit ODBC DSN it successfull!!

    Why this happens?? Can anyone tell me please?? I will appreciate your suggestions

    Windows server 2003 is configured as RRAS role. Does it make any problem?? I'm not able to open server firewall also!! to check the firewall configurations

    Tuesday, November 17, 2015 8:05 AM

Answers

  • Hi Chaitanya,

    windows server 2003 family does not support SQL server 2000 SP2 or earlier versions of SQL server 2000, because windows server 2003 blocks both the TCP/IP network ports and the UDP network ports that are required to connect to an instance of SQL server 2000. If we try to connect to SQL server 2000 that is installed on windows server 2003, we are supposed to receive error "SQL server does not exit or access denied".

    You may click the KB for detailed information:

    https://support.microsoft.com/en-us/kb/884012

    Besides, windows server 2003 RRAS with firewall is also a known issue, if we are running RRAS on windows 2003, we are not able to turn on firewall. If we want to turn on firewall, we could only stop RRAS.

    And it seems no work around for the above issues on windows server 2003.

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Wednesday, November 18, 2015 7:29 AM