SQL Server does not exist or access denied.

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

Development Tools

ASP.NET

SQL Server does not exist or access denied.

Author

Topic

sanjeet
Starting Member

5 Posts

Posted - 2007-05-24 : 23:14:38

I am doing development on my local box.

This is my machine name any ideas?

SQL Server does not exist or access denied.
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: SQL Server does not exist or access denied.

Source Error:

Line 104: txtConnectionString = "data source=local,1620;initial catalog=plumdb6;persist security info=False; user id=PlumDBUser; password=plumtree; packet size=4096";
Line 105: SqlConnection sqlDbConn = new SqlConnection(txtConnectionString);
Line 106: sqlDbConn.Open();
Line 107:
Line 108: // Call ExecuteReader static method of SqlHelper class that returns a SqlDataReader

Source File: c:\inetpub\wwwroot\employeelookup.web\searchform.aspx.cs Line: 106

Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
EmployeeLookup.Web.SearchForm.loadDropdownCountry() in c:\inetpub\wwwroot\employeelookup.web\searchform.aspx.cs:106
EmployeeLookup.Web.SearchForm.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\employeelookup.web\searchform.aspx.cs:42
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2007-05-27 : 16:18:38

see this http://www.connectionstrings.com/

Also try to enclose your local as (local)