cannot connect to the MSSQL database

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.

Post here for help with installation of mojoPortal pre-compiled release packages

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.

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.

This thread is closed to new posts. You must sign in to post in the forums.
8/8/2009 3:35:30 PM
wfederation
Gravatar
Total Posts 11
View Posts

cannot connect to the MSSQL database

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

8/9/2009 4:03:42 PM
wfederation
Gravatar
Total Posts 11
View Posts

Re: cannot connect to the MSSQL database

Please ignore this request for assistance as I reinstalled the app and recreated my website.

|
Wayne

11/19/2009 9:19:41 PM
amihlfried
Gravatar
Total Posts 1
View Posts

Re: cannot connect to the MSSQL database

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!

9/13/2010 5:07:05 PM
amr.shah
Gravatar
Total Posts 1
View Posts

Re: cannot connect to the MSSQL database

I was having same problem with deployment of mojoportal-2-3-3-9 version on my local machine; it took almost whole day before i figured this out :s

I copied the connections string for ms sql server to web.config and it worked :)

~Amr

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