Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ...ERROR: Could not connect to database specified in connectionString for SqlDataProviderERROR: Could not connect to database specified in connectionString for SqlDataProvider
Previous
 
Next
New Post
1/12/2007 8:42 PM
 
Frank K

Joined: 11/6/2006
Posts: 185

I am running Assembly Version: 04.03.05

I have DNN up and running on my PC with no problems.

Now, after installing it on my laptop, I continuously get the error dtatbase connection error.

My instance of SQL Server 2005 server name is 'EMACHINE\EMACHINE'

Database is called 'DOTNETNUKE'

I created and added DOTNETNUKEUSER and assigned db_owner as role

In the web.config file I have :

<add name="SiteSqlServer" connectionString="Server=127.0.0.1;Database=DOTNETNUKE;uid=DOTNETNUKEUSER;pwd=mavanhalla;" providerName="System.Data.SqlClient"/>

<add key="SiteSqlServer" value="Server=127.0.0.1;Database=DOTNETNUKE;uid=DOTNETNUKEUSER;pwd=mavanhalla;"/>

I have tried using EMACHINE\EMACHINE, EMACHINE, (local) and everything else I could think of as the server name.

I have also tried it without uid & pwd.

 I am pulling out my hair!! Please help. Should I unistall DNN and try again? If so, how does one un-install DNN?

Should I uninstall and re-install SQL Server? It works fine for my other non-DNN apps. And like I said, I have DNN up and running on my PC. I am losing it here.
 
New Post
1/12/2007 11:12 PM
 
William Severance


www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253

Here's a few more things to check/try:

1. Is the instance of SQL Server 2005 running on the laptop or on your network? If it's on the laptop as I gather from your use of the 127.0.0.1 loopback address, you might also try "Server=.\SQLServer . . ." or even "Server=EMACHINE\SQLServer . . .

2. Can you access the database using SQL Server Management Studio, etc. with the same userid and password?  If not, perhaps the instance is set up for Windows authentication only and not SQL Server and Windows authentication. You should also see the name of the SQL server instance that you are using in the SSMS connection dialog.

3. Check the comment tags <-- and --> that the default .config file places around the SQL Server nodes as the default is to use the SQL Express connection string. The Express version should be deleted or commented out and the SQL Server version uncommented.

4. Post the exact database connection error you are receiving. Sometimes a bit more detail will be given as to the reason the connection failed.

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/16/2007 9:36 AM
 
Frank K

Joined: 11/6/2006
Posts: 185

I kept trying different stuff and here is what finally worked: 

<add name="SiteSqlServer" connectionString="Server=EMACHINE\EMACHINE;Initial Catalog=DOTNETNUKE;Integrated Security=True" providerName="System.Data.SqlClient"/>

<add key="SiteSqlServer" value="Server=EMACHINE\EMACHINE;Initial Catalog=DOTNETNUKE;Integrated Security=True"/>

Can anyone enlighten me as to why this worked and not the original strings in web.config?
 
New Post
1/16/2007 7:55 PM
 
William Severance


www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
I suspect the problem is that of my #2 item above - the instance of SQL server is set up for windows authentication only and not mixed mode (both windows authentication and SQL authentication).  It needs to be mixed mode to accept a uid and pwd in the connection string.
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/17/2007 10:01 AM
 
Frank K

Joined: 11/6/2006
Posts: 185

Hey Bill, thanks for your interest. I appreciate it.

I believe I do have Mixed Mode Authentication set up.

Here is are my authentication properties:         http://home.comcast.net/~bengal7/images/Auth_Mode.gif

Any other ideas?
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...ERROR: Could not connect to database specified in connectionString for SqlDataProviderERROR: Could not connect to database specified in connectionString for SqlDataProvider


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