Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...CanCan't connect to SQL 2005 Express (not dynamically attached DB)
Previous
 
Next
New Post
1/7/2010 2:16 AM
 

 Hello,

Note: re create a dedicated SQL Server database (not dynamically attached but manually create DB and put connect info in web.config as per instructions on Michel Seller's site) and install dnn5. I use server 2003/IIS6 and SQL Server Management Studio Express

The first time I tried this it worked fine  but I tried to do this again for another database and DNN install (5.01.00) using the exact same install files and setup and unfortunately when I get to the step of going to the web page to run install/install.aspx I get this error messge:

Installing DotNetNuke
Upgrade Error: ERROR: Could not connect to database specified in connectionString for SqlDataProvider

I have gone through the database settings (for new database and new user) and they are identical to the existing setup which works. The install files, IIS setup and folder permissions are exactly the same in both situations as well (unless I missed something but I have gone over this countless times.) I even tried doing this a 3rd time following Michel's instructions to the letter (http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/276/installing-dotnetnuke-500-locally.aspx) but this ended up with the same error message.

I can connect to SQL Server Management Studio Express using the credentials from the web.config file and gain access to the appropriate database so I think that part is OK. (I tried creating a new table too while logged in with these credentails and that looked like it would work too.)

One note: I do connect to the website via a remote browser, not via localhost - I have about 20 websites on IIS. I don't think that should make a difference as that is the way I completed the installation for that first site that worked properly.

The only possible change I can think of between when I did the first installation this way that worked properly (in June 2009) and now is that I have installed the usual MS patches and updates to my OS - with the exception of "Security Update for SQL Server 2005 SP3" as when I tried to install that it made my DNN sites stop working until I uninstalled it.


I am at a loss as to what to check / try next. Any suggestions would be greatly appreciated. 


Thanks in advance!
Ed

 
New Post
1/7/2010 8:03 AM
 

Please post the entire <connectionStrings> section of your web.config file, replacing user id and password with 'xxxx'.


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
1/7/2010 12:40 PM
 

 Thanks William,

I included the appSettings section too as it mentions the database connection info as well.

much appreciated,

Ed

PS - it seems odd the error message says "Upgrade Error:" when it is actually not an upgrade but an initial installation.

 <connectionStrings>

    <!-- Connection String for SQL Server 2005 Express -->

    <add name="SiteSqlServer" connectionString="Server=MAIL\SQLEXPRESS;Database=DotNetNuke500hc;uid=xxxx;pwd=xxxx);" providerName="System.Data.SqlClient" />

  </connectionStrings>

 <appSettings>

    <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules   -->

    <add key="SiteSqlServer" value="Server=MAIL\SQLEXPRESS;Database=DotNetNuke500hc;uid=xxxx;pwd=xxxx);" />

    <add key="InstallTemplate" value="DotNetNuke.install.config" />

    <add key="AutoUpgrade" value="false" />

    <add key="UseInstallWizard" value="false" />

    <add key="InstallMemberRole" value="true" />

    <add key="ShowMissingKeys" value="false" />

    <add key="EnableWebFarmSupport" value="false" />

    <add key="EnableCachePersistence" value="false" />

    <add key="HostHeader" value="" />

    <!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->

    <add key="RemoveAngleBrackets" value="false" />

    <!--optionally strip angle brackets on public login and registration screens-->

    <add key="PersistentCookieTimeout" value="0" />

    <!--use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure-->

    <!-- set UsePortNumber to true to preserve the port number if you're using a port number other than 80 (the standard)

    <add key="UsePortNumber" value="true" /> -->

    <add key="InstallationDate" value="1/2/2010" />

  </appSettings>

 

 
New Post
1/7/2010 10:29 PM
Accepted Answer 

The connection strings look correct except for the parenthesis character following pwd=xxxx in both the primary and legacy connection strings. Is that just an error in posting to the forum?

Is MAIL the correct computer name and did you install SQL Express using the default named instance of SQLExpress?


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
1/8/2010 2:18 AM
 

  That was it - problem solved

Thank you!!! Much appreciated.

I guess I was staring at it too long to see that.

I will likely have a few more questions soon but I am so happy to have this sorted out.

Ed

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...CanCan't connect to SQL 2005 Express (not dynamically attached DB)


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out