On the completed project, I am able to get to the dashboard.
However when I choose an item from "Request to Approve" or "My Request"
I get a sql connection 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)
From this block of code:
This is looking for the object PTORequestEO but it is not present becasue the string is empty. I am not able to locate PTORequestEO where is it at in the project?
publicISingleResult<ENTAuditObject> ENTAuditObjectSelectByObjectName([Parameter(Name="ObjectName", DbType="VarChar(255)")] string objectName)
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), objectName);
I have encountered this error before and I believe it was related to the connection string or SQL permissions.
I have already checked to see if my SQL 2005 Server had remote connections turned on in Surface, which it does.
I have also checked that NT Service has access to CRUD rights on the dbo schema.
What has me confused is that I can obviously connect to the db otherwise I would not get to the Home.aspx. Any comments, suggestions are welcomed. Below is my connection string.
<add name="HRPaidTimeOff" connectionString="Data Source=WEB01TOLLOCBRLW;Initial Catalog=HRPaidTimeOff;Integrated Security=True;Network Library=dbmssocn" providerName=""/>