Microsoft SQL Server Login Error

Problem:
When I create a data source of my SQL Server, it throws the following error
---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '01000'
SQL Server Error: 1326
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Solution:
After search in many sites, I got the solution for this problem.


In SQL Server 2008, we have to enable the TCP/IP protocol of the server instance.


To Enable,
* . Goto Start, Then All Programs
* . Select Microsoft SQL Server 2008, Then Configuration Tools,
* . Select SQL Server Configuration Manager
* . Select SQL Server Network Configuration,
* . Then Select the Instance of your SQL Server
* . Select The TCP/IP protocol, Right click and Enable It


After Enable, Restart your SQL Server services. Now if you create the connection, it works fine.

In SQL Server 2005,
* . Go to Surface Area Configuration Manager,
* . Here Remote connections are disabled by default. Look at the Database Engine -> Remote Connections option
* . Set local and remote connections to using both TCP/IP and Named pipes


After Set this option, Restart your SQL Server services, then create your connection


Hope it Helps!