Hi All,
I have recently installed Sql server 2005 on my machine and i am trying to connect to database for retreiving table information.
but it is giving me below error :
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) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: 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)
Source Error:
Line 18:
Line 19: SqlConnection cnn = new SqlConnection(ConnectionString);
Line 20: cnn.Open();
Line 21: SqlCommand cmd = new SqlCommand();
Line 22: cmd.CommandType = CommandType.Text;
My Code is this :
-
string ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];SqlConnection cnn = new SqlConnection(ConnectionString);
-
cnn.Open();
-
-
SqlCommand cmd = new SqlCommand();
-
-
cmd.CommandType = CommandType.Text;
-
cmd.Connection = cnn;
-
-
DataSet ds = new DataSet();
-
cmd.CommandText = "select Title from HumanResources.Employee";
-
-
SqlDataReader reader = cmd.ExecuteReader();
-
and in the webconfig File i have the ConnectionString like this:
-
<appSettings>
-
<add key="ConnectionString" value="server=BBMATRIXONE\SQLSERVER2005NEW;Database=AdventureWorks;UID=sa;PWD=*******;pooling=true"/>
-
-
</appSettings>
-
How to solve this error, please help me.
Thanks
-john
