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 ...Re: Database Connection HelpRe: Database Connection Help
Previous
 
Next
New Post
4/2/2011 2:35 PM
 
Hi,

I am new to DotNetNuke, i tried installing DotNetNuke referring Webinar but i am getting 'Connection Error(s)'. I am using SQL Server 2008, DotNetNuke_Community_05.06.02_Install.zip,Win XP.

Below are the details from my configuration setup:
web.config
<connectionStrings>
    <!-- Connection String for SQL Server 2005/2008 Express
    <add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" />
   -->
    <!-- Connection String for SQL Server 2005/2008     -->
    <add name="SiteSqlServer" connectionString="Server=.;Database=DotNetNuke;uid=DotNetNuke;pwd=password1-1;" providerName="System.Data.SqlClient" /> 
  </connectionStrings>
  <appSettings>
    <!-- Connection String for SQL Server 2005/2008 Express - kept for backwards compatability - legacy modules 
    <add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" />    -->
    <!-- Connection String for SQL Server 2005/2008 - kept for backwards compatability - legacy modules    -->
    <add key="SiteSqlServer" value="Server=.;Database=DotNetNuke;uid=DotNetNuke;pwd=password1-1;"/>

Configure Database Connection:
server-(.)
Database: DotNetNuke (I created with the Database same name)
UserID: DotNetNuke
Password:passwod1-1

I would be highly thankful, if anybody could please help me on this.
Kindly guide me if i missed any configuration, i am following all configuration' mentioned in WebInar. I am using ASPNET as the username and applied Full Control on the same.

Please help.

Thanks,
Abhishek


 
New Post
4/4/2011 4:38 PM
 
if you are using SQL Server syntax ( not express), you need to create a blank attached database in SQL Server Management Express (or Visual Studio) and grant dbowner permission to your dotnetnuke user.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
4/5/2011 10:37 AM
 
Sebastian can DNN 5.6.2 be installed on a sql server 2000?

I'm trying everything here but keep getting the following errors:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 11
Number: 4060
Message: Invalid Database
Index #: 1
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Sql login failed
 
New Post
4/5/2011 8:23 PM
 
DotNetNuke versions 5.02.00 and later require SQL Server 2005 or 2008 (standard, express, etc. versions) and cannot be installed successfully on SQL Server 2000. The error message that you are receiving does not appear related to that incompatibility but rather indicates that either the server, database name or SQL login credentials are invalid. In your web.config connection strings I did notice that you are using only a dot for the servername. When referencing an instance of SQL Server or SQL Server Express on localhost the server name is most usually of the form:

<machinename>\<instancename> for example P5K-Bill\SQLExpress

A dot can be used to represent the <machinename> for example .\SQLExpress

As Sebastian already asked, please indicate if are you using SQL Server or SQL Server Express and did you first create a blank database using SQL Server Management Studio (or othre similar tool) or are you using the existing database file in the App_Data folder of the DotNetNuke install package?

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
4/6/2011 4:55 AM
 
Hi William.
I think I made the mistake of coming in on someone else's thread while I was thinking of grouping setup questions together.

I did setup a blank db on sql server 2000.   I tried everything I could think of, I looked up and added permissions etc but never got a "I cannot install on sql2000" error which lead me to the question. Only variations around can't log in errors.

But anyway the main question was answered - I need 2008.   Oh boy this upgrade will be a tough one.

Thanks again.
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Re: Database Connection HelpRe: Database Connection Help


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