Need
DNN Support
?
DeskPal.com
Learn DNN / DotNetNuke
Login
Subscribe to DNNCreative
Home
Subscribe
Training & Tutorials
Tutorials for Beginners
Tutorials for Administrators
Tutorials for Core Modules
Tutorials for Advanced Users
How to Build a Website in DotNetNuke
Skinning Tutorials
Module Development
Third Party Modules
Forum
Search
Search
Home
Subscribe
+
Training & Tutorials
Tutorials for Beginners
Tutorials for Administrators
Tutorials for Core Modules
Tutorials for Advanced Users
How to Build a Website in DotNetNuke
Skinning Tutorials
Module Development
Third Party Modules
Forum
You need to
Register
for free and
Login
to post a message in the forum.
Forum
Forums
Search Forum
Search
Advanced Search
Topics
Posts
Unanswered
Active Topics
Forums
>
Users Lounge
>
Everything Else
Need some HELP on SQL Server configuration for DNN
Last Post 11/21/2012 10:21 AM by
Joseph Craig
. 2 Replies.
Sort:
Oldest First
Most Recent First
Check this box to subscribe to this topic.
Prev
Next
You are not authorized to post a reply.
Author
Messages
Greg Anderson
Nuke Newbie
Posts:6
11/19/2012 11:53 AM
Background:
I was running SQL Server 2012 and could install DNN automatically with SQL Express or by creating a database and installing DNN with SQL Server 2012. I jumped to SQL 2012 without checking if my hosting provider had a SQL 2012 option. That was a big whoops as downgrading a database from SQL 2012 to SQL 2008 isn't supported. Not wanting to switch hosting providers I uninstalled 2012 via the uninstall wizards for it and its components. Then I installed SQL 2008 R2. This is where my problems started.
I am able to create a SQL Server 2008R2 database via SSMS and install DNN6 or DNN7 to that database. When I run the DNN install DNN is unable to connect to SQL Express. On DNN 6 it disables the auto install and then is unable to install to .\SQLEXPRESS on typical. DNN7 says: No valid default database connection detected. Standard Database setup option is unavailable.
If I try to attach to the database.mdf file with SSMS I get the following error: Directory lookup failed for the file "____" failed with the operating system error 3(The system cannot find the path specified.). Microsoft SQL Server Error 5133.
Both SQL Server and SQL Server Express log on as NT AUTHORITY\Local Service.
I have somehow messed up the ability to connect with SQLEXPRESS. I have tried setting authentication on SQL Express to either Windows Authentication mode or SQL Server and Windows Authentication mode, with no apparent difference.
I'm concerned that I have some underlying installation or configuration issue that will show up sometime in the future, probably when I'm not current on what led up to the issue. I've googled and checked everything I can think of on the SQL Server and SQL Express installation, though I'm just a novice at it. On the other hand I could be hopeful that when I eventually update to SQL Server 2012 these problems would go away.
Questions:
Is there an obvious problem from my description that I can address?
What could I do to further investigate this issue on the road to resolution?
Should SQLEXPRESS be set to Windows Authentication Mode or SQL Server and Windows Authentication mode?
Should I have my SQL Server Express log on as NT AUTHORITY\Local Service?
Thanks!
Greg Anderson
Nuke Newbie
Posts:6
11/20/2012 4:01 PM
I'm up and running with 2008R2, 2012 and 2008R express instances. I'm able to create an SQL Express database through SSMS and connect to it from dotnetnuke. My conclusion is that when I setup windows and SQL Server authentication on the full SQL server installation then that required SQL Server authentication for the SQL Express installation, hence the auto install wouldn't work. Afer several installations and uninstalls I've had a sufficient dose of SQL Server education for now and I will be glad to get back to dotnetnuke.
Joseph Craig
DNN MVP
Posts:11667
11/21/2012 10:21 AM
Well, congratulations on that hard won education!
You should be able to use either Windows or Server authentication methods and the installer should handle either.
I find it much better to create an empty database via SSMS than to use the "Attach" method with the Express database that comes with DotNetNuke.
Joe Craig,
Patapsco Research Group
Complete DNN Support
You are not authorized to post a reply.
Special Bonuses
--Subscriber Bonuses
--Readers Offers
Users Lounge
--Announcements
--DNN Creative Articles
--Everything Else
--Feedback, Suggestions and More
--Membership
--Site Review Please!
--Testimonials
--Podcasts
DotNetNuke®
--DotNetNuke® Questions
--Modules
--Modules - What's needed?
--Quick Tips
Hosting
--DotNetNuke® Hosting Providers
Skinning Toolkit
--Skinning Toolkit
UK DotNetNuke User Group
Forums
>
Users Lounge
>
Everything Else
Latest Forum Posts
Can you Run Xcode in Linux?
by Aman Singh
Can you Run Xcode in Linux?
Can you Run Xcode in Linux?
by Aman Singh
Can you Run Xcode in Linux?
Billed for subscription that was canceled
by Ryan
I was just billed for a subscription that was canc eled / inactivetive how do I get a refund for th
Meta Title and Meta Description are not showing properly
by DNN User
Hi, On my site the meta title and meta descriptions are not showing properly. It's showing the m
Search is not functioning properly
by DNN User
Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea
Search is not functioning properly
by DNN User
Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea
DNN Platform import site optio
by Melanie Weaver
Is it possible to import site template in DNN Platform 8.0? We have internal Evoq Content 8.1 tha
Events Module for DNN V5?
by Tugboat
Would anyone have a download link for the version 5.0.3 Events Module? Thanks!
"Ghost" TabID Number?
by Tugboat
Hi! I have a portal instance with multiple child portals and on one of the child portals, there i
RE: DNN Load Testing
by ayman sharkawy
Hi. Have you already implemented a site using the DNN . And how the performance of the site and its
Publish All Pages
by NSUOK
I'm using DNN Evoq Content Basic 8.2.0. When I make the HTML Pro module display on all pages, I h
Simpler profile needed in 9.2.2
by Donald
We are upgrading a DNN 4.8.4 site to DNN 9.2.2. On 4.8.4, the top bar shows the user’s name. If yo
How to link from dnnmodal popup to web site page?
by Donald
Hello all. I am using a dnnmodal.show popup. The popup works correctly, showing the content that I
RE: Document Collaboration
by Nick Davern
That feature would be super beneficial for our needs as well! Does anyone have an update as to if th
RE: DNN 9.2, how to set default theme?
by Andy Stephenson DNN Creative
you do that under "Manage/Themes". Note the highlight blue border around the default container and d
DNN 9.2, how to set default theme?
by Donald
Please disregard, found Manage Themes I cannot find how to set a default portal theme in DNN 9.2
RE: Looking for DataSprings Dynamic Forms
by Andy Stephenson DNN Creative
Your best chance would be to contact Chad Nash @ http://www.datasprings.com/
Looking for DataSprings Dynamic Forms
by Jakir HM
Looking for DataSprings Dynamic Forms 3.4 for DNN 4.x 5.x for my site (https://themasters2018s.com/)
RE: Help with Cycle Image Carousel not displaying images
by peter
I had the same problem with the Will Strohl Content Slider after upgrading to DNN 9.1 The above an
RE: Object reference not set to an instance of an object
by Andy Stephenson DNN Creative
Check this one might be useful: http://www.dnnsoftware.com/answers/im-tryin-to-move-my-site-to-pr
Used
By
Testimonials