Monday, March 19, 2012

I cannot connect to SQLSERVER Database

In SQLserver Admin, ANDON\ASPNET is setup as a 'Server Admin'

****************************************************************************

Connection string is set in the web.config file.

<configuration>

<connectionStrings>

<add name="SqlServerEx"

connectionString="Data Source=LOCALHOST\SQLEXPRESS;Initial Catalog=DB2;Integrated Security=SSPI;"

providerName="System.Data.SqlClient;"></add>

</connectionStrings>

<appSettings/>

<system.web>

.......................................................................

protected void Button2_Click(object sender, EventArgs e)

{

string connStr = WebConfigurationManager.ConnectionStrings["SqlServerEx"].ConnectionString;

SqlConnection con = new SqlConnection(connStr);

TextBox3.Text = connStr;

try

{

con.Open();

TextBox2.Text = "<b> Server Verison::</b>" + con.ServerVersion;

TextBox2.Text += "<br /><B>Connection Is::</B> " + con.State.ToString();

}

catch (Exception err)

{

TextBox2.Text = "Error reading Database. ";

TextBox2.Text += err.Message;

}

finally

{

con.Close();

TextBox2.Text += "<BR><B>CONNECTION::" + con.State.ToString() + "</B>";

}

}

****************************************************************************

This is the error message I am getting:

"Error reading Database. Instance failure."

Do you have a SQL Server Express instance installed on Localhost ? Are remote connections enabled on the machine (See the Screencast on my site for more information about that) Please post the stakc of the exception (should be a SQLExeption) and the erronumber, error message and state here.

Jens K. Suessmeyer

http://www.sqlserver2005.de

No comments:

Post a Comment