Problem Connecting to Sql Express 2005

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.
5/13/2009 10:47:14 AM
Gravatar
Total Posts 6
// todo: Signature.. something clever...

Problem Connecting to Sql Express 2005

Windows 2003 Standard SP2
SQL Express 2005
Version 2.3.0.1

I have installed and run setup/default.aspx without any problem but when I go to the root I get couldn't connect to the sql 2005 server standard error, Doesn't it use the same connectionstring as in user.config?

5/13/2009 11:58:51 AM
Gravatar
Total Posts 18439

Re: Problem Connecting to Sql Express 2005

Are you using the release package or source code?

Are you using a sql user in your connection string or a windows user. I recommend use a sql user.

Best,

Joe 

5/13/2009 12:18:12 PM
Gravatar
Total Posts 6
// todo: Signature.. something clever...

Re: Problem Connecting to Sql Express 2005

I'm currently using a sql user (tested with a windows one didn't help)
I downloaded mojoportal-2-3-0-1-mssqlreleasefiles.zip from codeplex

 

5/13/2009 12:22:07 PM
Gravatar
Total Posts 18439

Re: Problem Connecting to Sql Express 2005

There is only 1 connection string used. Make sure your sql user is a dbo for the db. If you are running in a virtual directory beneath another .NET app/site the config settings from above cvould be interfering.

Hope it helps,

Joe

5/13/2009 12:28:20 PM
Gravatar
Total Posts 6
// todo: Signature.. something clever...

Re: Problem Connecting to Sql Express 2005

Removed the dummt connection string from web.config gave it it's own App pool.. didn't help...  

Oh, it's setup as a website btw 

5/13/2009 12:32:22 PM
Gravatar
Total Posts 18439

Re: Problem Connecting to Sql Express 2005

Did you make the db user a dbo on the db (database owner)

please post the stack trace of the error. 

Is this a clean install or did you move the db from another installation?

5/13/2009 4:18:01 PM
Gravatar
Total Posts 6
// todo: Signature.. something clever...

Re: Problem Connecting to Sql Express 2005

Yup user is dbo, it was a clean install and il see if I can get a trace that isn't regular "under default bla bla..."

5/14/2009 5:53:46 AM
Gravatar
Total Posts 18439

Re: Problem Connecting to Sql Express 2005

Make sure there are no other default documents configured in IIS except for Default.aspx, maybe there is some other file like Default.asp showing a db error.

What happens if you visit yoursiteroot/Default.aspx or yoursiteroot/home.aspx instead of just yoursiteroot/ 

Hope it helps,

Joe

5/14/2009 6:05:11 AM
Gravatar
Total Posts 6
// todo: Signature.. something clever...

Re: Problem Connecting to Sql Express 2005

Sorry to say it didn't help, Default.aspx and Home.aspx both show the error...
I'm going to try and install Express 2008 and see if that will help...

5/14/2009 6:10:50 AM
Gravatar
Total Posts 18439

Re: Problem Connecting to Sql Express 2005

Find this in your Web.config file:

<customErrors mode="RemoteOnly" ...

and change it to this:

<customErrors mode="Off" ...

Then visit yoursiteroot/Default.aspx and post any error you see with all details. 

5/14/2009 6:33:40 AM
Gravatar
Total Posts 6
// todo: Signature.. something clever...

Re: Problem Connecting to Sql Express 2005

Found it, was the SessionStateManager that was wrong, thanks for all the Help!

Great support for this  

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