I have an existing Mojo Website that quit on me after updating to the latest release. The error I am getting is:

The system cannot connect to the MSSQL database. Please check your connection string.

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at mojoPortal.Data.DBPortal.DatabaseHelperGetConnectionError(String overrideConnectionInfo)
 

My connection string is:

Server=FEDWEB\SQLEXPRESS;Database=TTW;User ID=DNNUser;Password=●●●●●●●●

I can log into my SQlExpress as DNNUser, the server is set to accept remote logins, DBNNUSer has read/write/ownership rights to TTW?

Any Ideas?

Wayne

Wayne,

I"m having the exact same error. You just re-unzipped the source files and recreated the database and user? Did you use SQL SErver Management Studio?

Thanks!