SQL Server does not exist or access denied
Hi everyone,
this isnt the first time i install ASP.NET (2003) and SQL Server (2000) on a PC however i always suffer a lot at the beginning cz it never works from the first time.
This time I made sure (or at least i believe so) that I installed the two software correctly however i still get this error page whenever i try to connect to my SQL Database through my ASP.NEt (c#) coded web page:
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 100:
Line 101: int result = 0;
Line 102: dbConnection.Open();
Line 103: try
Line 104: {
Source File: C:\Inetpub\wwwroot\WYW\Login.aspx.cs Line: 102
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
WYW.WebForm1.ValidateUser(String userName, String pass) in C:\Inetpub\wwwroot\WYW\Login.aspx.cs:102
WYW.WebForm1.Button1_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\WYW\Login.aspx.cs:127
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
I made sure that the user name and password and database name and data source are all correct in my configuration of connection string in web.config but still I get this error. Can someone gimme some advice on what to check thanks a lot?
Regards,
Susan
|