AnsweredAssumed Answered

Error connecting to SQL Server

Question asked by Praveen John Kumar Employee on Jan 14, 2016
Latest reply on Jan 15, 2016 by Praveen John Kumar

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].

Outcomes