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 Server2. Cause 2 - TCP/IP protocol is not enabled for SQL Server2. Cause 3 - SQL Server Browser service is not running on SQL Server3. Cause 4 - Firewall on SQL Server is blocking TCP port of SQL Server4. 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.
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.
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)
If you do not see an option to Restart the SQL Server Services:
Looks like the client version is the issue, try using SQL Server Native Client 10.0.
When I have gotten this error before, using SQL Server Native Client 10.0 has solved the problem.
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.