CODEWITHSUNDEEP
sql-server
Arun Kumar
Arun Kumar

Reputation: 877

ODBC Connection failur in SQL Server 2008 R2

When I am trying to create the ODBC connection form my client machine I am getting an error as in the screen shot.

My server machine is 64 bit and my client machine is 32 bit.Will you have any ideaenter image description here

Upvotes: 0

Views: 1163

Answers (1)

Mark Kremers
Mark Kremers

Reputation: 1789

Have you made your server to accept remote connections? After a standard installation it is not accepting remote connections, you can change that on the server with the "SQL Server Configuration Manager"

When you open that you will have to enable TCP/IP Client and the TCP Protocol. After that you have to restart the SQL Server service and open port 1433 in your firewall. If it is a standard installation that will do.

You also can look into the sql server properties (through SQL Server Management Server) and then on the connections tab enable remote access.

Hope it helps :)

Upvotes: 1

Related Questions