Problem med at connecte til en MS SQL database
Jeg har i VS2005 forsøgt at oprette en database og at tilgå denne. Men jeg får fejl.Dette er koden:
----------------------------------------------
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
namespace DB_test
{
public partial class _Default : System.Web.UI.Page
{
protected SqlConnection VisitConnection;
protected void Page_Load(object sender, EventArgs e)
{
try
{
VisitConnection = new SqlConnection();
VisitConnection.ConnectionString = "Data Source=BOB/SQLEXPRESS;Initial Catalog=bob;Integrated Security=True";
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
try
{
VisitConnection.Open();
SqlCommand cmd = new SqlCommand("select * from navn", VisitConnection);
SqlDataReader result = cmd.ExecuteReader();
if (result.Read())
{
Response.Write("Virker");
}
else
{
Response.Write("FEJL!!!");
}
}
finally
{
VisitConnection.Close();
}
}
}
}
------------------------------------
Dette er fejlen:
----------------------
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
----------------------
Fejlen kommer efter denne linje:
VisitConnection.Open();
Hilfe, bitte