Hi,

Most of the application works fine. Its just that when I try to

Home ->View My Requests -> "Make Another Request", -> as soon as I click the Save button, I get the following error. Most other database operations workfine.

Could anyone please advice?


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:


Line 1525: public ISingleResult<ENTAuditObject> ENTAuditObjectSelectByObjectName([Parameter(Name="ObjectName", DbType="VarChar(255)")] string objectName)
Line 1526: {
Line 1527: IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), objectName);
Line 1528: return ((ISingleResult<ENTAuditObject>)(result.ReturnValu e));
Line 1529: }


Source File: C:\university\PaidTimeOffSolution\V2.PaidTimeOffDA L\HRPaidTimeOff.designer.cs Line: 1527

Stack Trace:


[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +4846887
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4860189
System.Data.SqlClient.SqlInternalConnectionTds.Att emptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) +433
System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +499
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
System.Data.Linq.SqlClient.SqlConnectionManager.Us eConnection(IConnectionUser user) +44
System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe () +45
System.Data.Linq.SqlClient.SqlProvider.InitializeP roviderMode() +20
System.Data.Linq.SqlClient.SqlProvider.System.Data .Linq.Provider.IProvider.Execute(Expression query) +57
System.Data.Linq.DataContext.ExecuteMethodCall(Obj ect instance, MethodInfo methodInfo, Object[] parameters) +69
V2.PaidTimeOffDAL.HRPaidTimeOffDataContext.ENTAudi tObjectSelectByObjectName(String objectName) in C:\university\PaidTimeOffSolution\V2.PaidTimeOffDA L\HRPaidTimeOff.designer.cs:1527
V2.PaidTimeOffDAL.Framework.ENTAuditObjectData.Sel ect(HRPaidTimeOffDataContext db, String objectName) in C:\university\PaidTimeOffSolution\V2.PaidTimeOffDA L\Framework\ENTAuditObjectData.cs:77
V2.PaidTimeOffBLL.Framework.ENTAuditObjectEO.Load( HRPaidTimeOffDataContext db, String objectName) in C:\university\PaidTimeOffSolution\V2.PaidTimeOffBL L\Framework\ENTAuditObjectEO.cs:155
V2.PaidTimeOffBLL.Framework.ENTAuditObjectEO.Load( String objectName) in C:\university\PaidTimeOffSolution\V2.PaidTimeOffBL L\Framework\ENTAuditObjectEO.cs:148
V2.PaidTimeOffBLL.Framework.ENTBaseEO.StorePropert yValues() in C:\university\PaidTimeOffSolution\V2.PaidTimeOffBL L\Framework\ENTBaseEO.cs:204
V2.PaidTimeOffBLL.PTORequestEO.Load(Int32 id) in C:\university\PaidTimeOffSolution\V2.PaidTimeOffBL L\PTORequestEO.cs:78
PTORequest.Page_Load(Object sender, EventArgs e) in c:\University\SIRSSolution\SIRSUI\PTORequest.aspx. cs:68
System.Web.Util.CalliHelper.EventArgFunctionCaller (IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Cal lback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
BaseEditPage`1.OnLoad(EventArgs e) in c:\University\SIRSSolution\SIRSUI\App_Code\BaseEdi tPage.cs:75
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Almost Done! Please someone reply to this above post!!!