Monday, December 21, 2009

Microsoft SQL Server Login Error

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.

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!

No comments:

Post a Comment