Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.
If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.
When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:
You may also want to review the installation or upgrading documentation.
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 (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: 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)
Using: mojoportal-2-3-6-5-mssql-net40-deploymentfiles
Application pool mode: Integrated
.NET Version: 4.0
Database type: MSSQL
The error is very clear, either your database connection string is incorrect or the database server is offline.
If you have a user.config file in the root you should check the connection string there, otherwise check in Web.config
Hope it helps,
Joe
Solved it.
<!-- IMPORTANT: Note that changes made to this file are not automatically detected by the ASP.NET runtime It does detect changes to Web.config, so when you make a change in this file you need to touch Web.config (ie type a space in it and save it) to make it reload settings -->
<add key="MSSQLConnectionString" value="server=IP,PORT;UID=USERNAME;PWD=PASSWORD;database=DBNAME" />
I had to fill in the IP,PORT and such.
Fixed ;)
Glad you got it working. You shouldn't need to specify the port unless your sql server is running on a non-standard port, ie only if the port is something other than the default 1433.
Best,
Ah oke, my webhost did tell me to use a port and i did and it worked. :P
Also when i register and i make a mailbox on my website its control panel and i fill in noreply@email.com as a email, i won't get the confirmation email to use my new made account.
System.Data.SqlClient.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: 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)
I got the same error but the problem is i use an mysql database how can i fixs this problem ?
Cheers
Hi,
Have you read the Using MySQL document?
You need to download the MySQL Data Layer zip file from codeplex.
HTH, Joe D.