The website runs on local machine with the same web.config file as on WinHost. When I try to open the Manage.asxp page from the WinHost, the error is received: Exception Details: System.ComponentModel.Win32Exception: The system cannot find the file specified Source Error: Line 29: If Not IsPostBack Then Line 30: ' Determine the sections to render Line 31: Dim hasLocalPassword = OpenAuth.HasLocalPassword(User.Identity.Name) Line 32: setPassword.Visible = Not hasLocalPassword Line 33: changePassword.Visible = hasLocalPassword Source File: E:\web\wcswanso\DEIG1\Account\Manage.aspx.vb Line: 31 [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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)] System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling) +970 The connection strings on my local machine is the same as the WinHost. I am using the WinHost SQL Server engine from both locations. I have changed the trust level to full in the web.config file and on the iis server. <system.web> <securityPolicy> <trustLevel name="Full" policyFile="internal" /> </securityPolicy> <trust level="Full" originUrl="" processRequestInApplicationTrust="false" /> On WinHost iis I am getting an error while performing this operation when trying to change the .NET Trust Levels. What can be done for the Manage.aspx file to display from the Accounts file (Using Website Template in VS2012)?
Yeah, this error: is a pretty misleading error, but fortunately, I've seen it enough to know what needs to be fixed.
I have tried a few more combinations of connection strings and I am still getting an error when trying to open the Accounts\Manage.aspx page. These connection strings work from my computer but not WinHost. HTML: Accounts/Manage.aspx Line 31: Dim hasLocalPassword = OpenAuth.HasLocalPassword(User.Identity.Name) [SqlException (0x80131904): CREATE DATABASE permission denied in database 'master'.] This works from my machine but not on WinHost: Code: <connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="Data Source=s10.winhost.com;Integrated Security=false; Initial Catalog=DB_85207_aspnetdb;User ID=DB_85207_aspnetdb_user; Password=****" providerName="System.Data.SqlClient" /> <add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="Data Source=s10.winhost.com;Initial Catalog=DB_85207_aspnetdb;User ID=DB_85207_deig_user;Password=*****"f"/> <add name="cnDEIG" connectionString="Data Source=s10.winhost.com;Initial Catalog=DB_85207_deig;User ID=DB_85207_deig_user;Password=*****" providerName="System.Data.SqlClient"/> </connectionStrings>
It now works! The default connection string had the wrong user id 'User ID=DB_85207_deig_user' should be ' User ID=DB_85207_aspnetdb_user. The change to the connection string consist of removing the attachment of the attached data files and replacing it with the connection string to the aspnetdb. Many thanks for your help!