How to connect to SQL 2000 on SBS 2003 via ODBC on Win XP SP2 Client?

Discussion in 'Windows Small Business Server' started by Mark, Jun 23, 2005.

  1. Mark

    Mark Guest

    Hi All,

    Has anyone here successfully connected to SQL server 2000 on SBS 2003 via
    ODBC on a Windows XP (or 2000) client machine?

    I've been trying all sorts of combinations and can't add the SQL server as
    an ODBC data source to my XP SP2 client machine.

    I get lots of errors like:

    Connection failed:
    SQL State: '01000'
    SQL Server Error: 11001
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
    (Connect()).
    Connection failed:
    SQL State: '08001'
    SQL Server Error: 6
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not
    found.

    Also seen SQL Server Error: 2, 17, 53 at different stages, but have yet to
    find a good reference to what these errors mean.

    If anyone has a step by step guide on how to connect to Sharepoint or
    whatever, that would be great!

    Thanks,

    Mark
     
    Mark, Jun 23, 2005
    #1
    1. Advertisements

  2. Mark

    Mark Guest

    Hi All,

    Nevermind, just worked out that:

    SQL Enterprise Manager / SQL Server Group / Server\Sharepoint - properties

    General tab / Network Configuration button

    ...had no protocols enabled. Enabling TCP IP fixed the problem

    Thanks,

    Mark
     
    Mark, Jun 23, 2005
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.