Help need on connection string

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Help need on connection string

Author

Topic

Ambikaa
Starting Member

43 Posts

Posted - 2008-08-25 : 03:32:23

Hi,

i am using console application in C#, in that i have used database connection string like
public static string ConnectionString = "Data Source=.\\SQLEXPRESS;initial catalog=RealEstate;UID=sa;PASSWORD=sa;integrated security=SSPI;persist security info=False;Trusted_Connection=Yes;connect timeout=30";

but, i am getting this error while at the execution time.

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)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-25 : 03:36:47

Have you enable remote connection in SQL Server Suraface Area Configuration manager?