The system cannot connect to the MSSQL database. Please check

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

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

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

8/3/2010 6:59:26 AM

blochaou

Total Posts 7

View Posts

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

Sometime i get this error. Does anybogy know how to fix it?

Welcome to mojoPortal Setup

Probing system...
File system permissions ok.
The system cannot connect to the MSSQL database. Please check your connection string.

System.Data.SqlClient.SqlException: Une erreur liée au réseau ou spécifique à l'instance s'est produite lors de l'établissement d'une connexion à SQL Server. Le serveur est introuvable ou n'est pas accessible. Vérifiez que le nom de l'instance est correct et que SQL Server est configuré pour autoriser les connexions distantes. (provider: Fournisseur de mémoires partagées, error: 40 - Impossible d'ouvrir une connexion à SQL Server) à System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) à System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) à System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) à System.Data.SqlClient.SqlConnection.Open() à mojoPortal.Data.DBPortal.DatabaseHelperGetConnectionError(String overrideConnectionInfo)

Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

thanks

8/3/2010 7:08:48 AM

Joe Audette

Total Posts 18439

View Posts

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

Hi,

The message is very clear, your connection string is not correct to connect to your sql server database.

Possibly you are using an incorrect host name or instance name. For example SQL EXpress usually installs with an instance name of SQLExpress, so if it is on your local machine you would specify the server=localhost\SQLExpress or on another server it would be serverhostname\SQLExpress

Or possibly your SQL server is not configured to allow remote connections.

Hope it helps,

Joe

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