Server Error in '/NPD_NET' Application.

[garrydawkins]

Hey gang, I get this error when attempting to login to my application. The server has been restarted and SQL Server agent is running fine on my machine. Here is the entire error message.

Server Error in '/NPD_NET' Application.
--------------------------------------------------------------------------------

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:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
NPD_NET.DBAccess.DAOObject.myConnection(Boolean isClose) +87
NPD_NET.LoginMain.Button1_Click(Object sender, EventArgs e) +185
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

:(

[buntine]

Are you on a network? If so, ask your server admin for file permissions.

Also, if you have the authority, you may want to set permissions yourself. MS SQL needs to be able to create temporary files on the server for it to work.

Regards.

[PeOfEo]

Yes you are going to need to give the aspnet system account access to sql server if you have not already done so.