Test Data Manager

Expand all | Collapse all

Error connecting to SQL Server

Jump to Best Answer
  • 1.  Error connecting to SQL Server

    Broadcom Employee
    Posted 01-14-2016 06:45 AM

    Hi All,

     

    When I create a connection profile for Test Data Repository I choose Microsoft SQL server and added the new data source .

    After that when I enter my  credentials ( valid) , I get the error as stated below . I have attached the screen shots too for reference .

    Kindly help me fix this issue .

     

    Note : I checked and saw that SQL Server service & SQL Server Browser service is  running on SQL Server .TCP/IP protocol is also  enabled for SQL Server.

     

     

    Error Message 1 :

    CA Test Data Manager - Datamaker has experienced a problem connecting to your SQL Server Test Data Repository using the information supplied.

    The error message returned from the SQL Server client software is given below:

    SQLSTATE = 08001
    [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Server doesn't support requested protocol [xFFFFFFFF].

    Please rule out the following common causes of this connectivity issue before contacting support:

    1. Cause 1 - SQL Server service is not running on SQL Server
    2. Cause 2 - TCP/IP protocol is not enabled for SQL Server
    2. Cause 3 - SQL Server Browser service is not running on SQL Server
    3. Cause 4 - Firewall on SQL Server is blocking TCP port of SQL Server
    4. Cause 5 - Firewall on SQL Server is blocking UDP port (1434) of SQL Server browser service

     

    Error Message 2:

    Please check the connection details and try again.

    SQLSTATE = 08001
    [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Server doesn't support requested protocol [xFFFFFFFF].



  • 2.  Re: Error connecting to SQL Server

    Posted 01-14-2016 10:58 AM

    What SQL Server version are you using ?

     

    Have you tried using SQL Server Native Client 10.0 ?

     

    Also - re-check SQL Services are running on all the expected IP's, make sure ports are open (telnet), etc.



  • 3.  Re: Error connecting to SQL Server
    Best Answer

    Posted 01-14-2016 05:05 PM

    If you are using EXPRESS/DEVELOPER EDITION of SQL Server, then you need to manually enable TCP IP Protocol for the SQL Server.

     

    Instructions for SQL Server 2012 Express Editions:
    (steps for SQL Server 201 will be quite similar)

     



  • 4.  Re: Error connecting to SQL Server

    Posted 01-14-2016 05:06 PM

    If you do not see an option to Restart the SQL Server Services:

    • Go to your Start Menu
    • Open "Services"
    • Search for SQL Server (SQLEXPRESS)
    • Right click on that program and choose "Restart"
    • (It is okay to restart all the SQL Services listed)
    • See screenshot below

     



  • 5.  Re: Error connecting to SQL Server

    Broadcom Employee
    Posted 01-14-2016 03:01 PM

    Looks like the client version is the issue, try using SQL Server Native Client 10.0.



  • 6.  Re: Error connecting to SQL Server

    Posted 01-14-2016 05:08 PM

    When I have gotten this error before, using SQL Server Native Client 10.0 has solved the problem.



  • 7.  Re: Error connecting to SQL Server

    Broadcom Employee
    Posted 01-14-2016 11:32 PM

    Looks like I didn't restart SQL server after enabling TCP protocol . After the restart am able to connect to my  repository .

     

    Thanks matan08 , gilta03 , borst04.