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

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
8/25/2009 9:10:14 PM
Gravatar
Total Posts 34

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

So, I was just editing a page in the WYSIWYG, nothing serious just adding CSS classes, I hit "update" and the page warped into a completely different skin (some green skin), giving me the error "you do not have permission to do this change". Then when I refreshed I get a grey setup page with this error:

 

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) 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 user.config connection string has not changed, and I have done nothing different aside from adding a couple CSS classes and some header tags!

 

I try to take changes very slow, so I wasn't doing anything major when this happened out of the blue.

 

I tried restoring the database, same error.

 

Anyone have a clue whats going on?

 

How do I get to that particular HTML content page to change it manually if there is something there messing everything up?

 

Thanks.

8/26/2009 4:46:37 AM
Gravatar
Total Posts 34

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

btw It was fixed by recycling the application pool, still wondering what kind of odd bug it was, caused me to lose a couple hours of editing :(

8/26/2009 5:00:50 AM
Gravatar
Total Posts 18439

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

The error says it was a network error. My guess is someone rebooted the database server right about when you went to save your changes or some network issue between the web server and the db server at that time.

You must sign in to post in the forums. This thread is closed to new posts.