Error:An error has occurred while establishing a connection to the server
-
how do i clear this 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) i'm using sql2005...in online exam quiz.. plz help me..
-
how do i clear this 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) i'm using sql2005...in online exam quiz.. plz help me..
-
What are the details of your connection string?
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
mycon.ConnectionString = "Server=(local);DataBase=im;Integrated Security=True" mycom = New SqlCommand("INSERT INTO quiz1(Result,Email) values('" + strResult + "','" + TextBox1.Text + "')", mycon) mycon.Open() mycom.ExecuteNonQuery() mycon.Close() i'm using Vb script and Asp.net... db is Sql 2005.. this program is running on localhost but didnt run external... what can i do?
-
mycon.ConnectionString = "Server=(local);DataBase=im;Integrated Security=True" mycom = New SqlCommand("INSERT INTO quiz1(Result,Email) values('" + strResult + "','" + TextBox1.Text + "')", mycon) mycon.Open() mycom.ExecuteNonQuery() mycon.Close() i'm using Vb script and Asp.net... db is Sql 2005.. this program is running on localhost but didnt run external... what can i do?
mananth wrote:
mycon.ConnectionString = "Server=(local);DataBase=im;Integrated Security=True"
You are using Integrated Security to connect to SQL Server. Does the account that your ASP.NET web app is running under have the required permissions to access the SQL database?
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush