Error connecting to SQL Server

[johpr01]

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

[Anon Anon]

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.

[gilta03]

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)

 

[gilta03]

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

 

[Steven Borriello]

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

[gilta03]

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

[johpr01]

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.