Hi Experts,

I am new to this topic. Actually, While run the page , getting error like below..

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Can anyone tell me the reason..

is there any settings orproperties i need to mention?

Reply as early as possible...

Thanks in Advance,

Laxmi.M.

Check your local server... give correct name.... still error?

 post your connection string code...

sample connection string...

<add name="MyConnectionString" connectionString="Server=MyPCName\SQLEXPRESS;Initial Catalog=MyDateBase;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>

laxmi.m:

Hi Experts,

I am new to this topic. Actually, While run the page , getting error like below..

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Can anyone tell me the reason..

is there any settings orproperties i need to mention?

Reply as early as possible...

Thanks in Advance,

Laxmi.M.

Hi Laxmi.M,

According to the error message, there are two main reasons.

First, your SQL Server didn't deploy correctly. Please check out your SQL Server's username and password for logining.

Second, you may not build your connection string properly. You can get help to learn how to do it from the site below.

http://msdn.microsoft.com/en-us/library/ms254978.aspx

By the way, your issue is not belong to this forum (It's a Webparts Forum here). If you post your issue to a correct forum, you will get more helpful suggestion.

This forum link could help you more:Data Access.

Hope it helpful for you.

Probably the connection string could be wrong .

This error usually comes when the sever instance is not properly specified or the service is not turned on on the server.

I think this will solve the problem

Also,be sure that you have installed Sql Express in your machine for you to able to use WebParts personalization.

Or If you are accessing sql server in different machine then be sure that Remote connection is enabled... Take a look at this

http://support.microsoft.com/kb/914277 

Or You have to enable TCP/IP in SQL Server Configuration Manager, enable remote connections in SQL Server Surface Area Configuration, and then restart SQL Server (assuming you have no firewalls).

PS: for more information about remote connection just google for it...