You need to Register for free and Login to post a message in the forum.

Forum

Forums > DotNetNuke® > DotNetNuke® Questions
Subject: Installation: Configure Database Connection
Prev Next
You are not authorized to post a reply.

Author Messages
saintX
DNN Creative Magazine Subscriber
Nuke Master
Nuke Master
Posts:141
14 Feb 2009 11:27 PM  
Hello,

I had SQLExpress 2005 and 2008 installed on my machine and had no problems installing and running DNN on my localhost. As having 2 instances of SQL caused some problems for me, I had to format my hard drive, this time installed VWD without SQLServer by the installation time and after that SQLExpress2008 incl. Managementstudio.


Now, DNN can't stablish a Database connection by the installtion, it accepts neighter the default ./SQLEXPRESS entry nor ./mymachinename and gives me this error messsage:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 20
Number: -1
Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Whereas WVD, which also can't find the SQLServer automatically, accepts mymachinename as I type it myself and also estabilisches the Database connection and retrives the data.

For allowing remote connections the "TCP/IP" is also activated. 

I have no idea what could I do else for DNN (4.9.0) to find the database?

Thanks for your help!
Joseph Craig
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5144
15 Feb 2009 10:22 AM  
How do you connect to the SQL Server using SQL Server Management Studio Express?
Joe Craig
DNN Creative Support
Subscribe to the website
saintX
DNN Creative Magazine Subscriber
Nuke Master
Nuke Master
Posts:141
15 Feb 2009 2:11 PM  
Yes! Besides VWD, Management Studio Express can also find and connect to the databases, just DNN can't find it.
Thanks
Joseph Craig
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5144
15 Feb 2009 11:09 PM  
You should be able to use the same server, database, uid, and password in your connection string. Can you post what you are using? (with appropriate changing of names ...)?
Joe Craig
DNN Creative Support
Subscribe to the website
saintX
DNN Creative Magazine Subscriber
Nuke Master
Nuke Master
Posts:141
16 Feb 2009 5:48 PM  
I am trying to run: DotNetNuke_04.09.00_Install

As I had Express 2005 on my machine, it had always found the server itself under the default name ./SQLEXPRESS and the installation was taking about 2 minutes.

By the time now I just have Express2008 (can't have another server on my machine because then login fails for NT Authority and the other applications don't work). 

B.T.W. This time all applications and programms can connect to this 2008 using ./machine name, but just DNN can't. I have used several combinations like ./machine name, ./machine name/User,  IP Address, Windows shar name, etc. but nothing works.

Could it be that DNN just can connect an run database installation scripts under 2005 at all? Otherwise I have no idea.  I think I Should forget about a localhost installation of DNN ... right?
saintX
DNN Creative Magazine Subscriber
Nuke Master
Nuke Master
Posts:141
17 Feb 2009 12:50 AM  

I have got the idea now: Will make a virtual machine and run the 2005 database there using exactly tutorila 31.

Thanks
saintX
DNN Creative Magazine Subscriber
Nuke Master
Nuke Master
Posts:141
06 May 2009 2:40 AM  
For those who may have the same problem: I entered (local) on the database connection field of DNN, and this time it works!
Lee Sykes
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5079
06 May 2009 9:11 AM  
Thanks for the feedback
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > Installation: Configure Database Connection


ActiveForums 3.7

Latest Forum Posts

Localizing Skins and css dynamically based on language selected by sadabahar83
Hi, I want to dynamically assign a skin and CSS based on the language selected. Different pag...
Recomended DNN version? by lolorn
What version of DNN would be recommended for creating a new site? Has DNN 5.2 turned out to be as st...
query regarding page options by kaustav_kar
Hi,My site will have two Home pages, one for a new visitor and one for a returning visitor.   Is the...
RE: Plz Help. Page_Load_Exception by zaidkhan
URL of My website is www.pafkiet.edu.pk
Few new skins by Rozo
Skins for DNN and other CMS. www.stelg.com
RE: Plz Help. Page_Load_Exception by jncraig
Can you provide a URL?
RE: Custom Textbox Size by jncraig
For the second part, you can switch the editor to source mode and enter unstyled text. For the fi...
RE: Picture size limits by jncraig
The little red x's generally mean that the link to the image is broken.  My guess is that you have a...
RE: Uploading an MP3 file to my website by jncraig
web.config is in the root directory of your DotNetNuke installation.  ALWAYS (!!) make a backup copy...
RE: Customizing registration page by kana
Ok, thank You for answers. I'll try to make it with OWS. Marek
Picture size limits by Doug_s
I'm lost - I've just changed host and a few thing that used to work don't, plus I can't display anyt...
RE: How to Limit Access to Administrator Modules in DotNetNuke 5 - issue 50 by samjst
Hi, Did you manage to solve the problem? I'm facing the same issue: users with access to add and...
Ealo Tab Localization help by sadabahar83
hi, I have installed Ealo Core Api and Ealo tab localization and ealo Menu provider. menu is wor...
Custom Textbox Size by PopeOMalley
Hello everyone,Do you know if there is a way to customize the size of a textbox control on the Manag...
RE: DotNetMushroom RAD by md-pv
That sounds interessting too. I'll check it. Thanks a lot.
RE: Plz Help. Page_Load_Exception by zaidkhan
thanks alot for replying Sir,Well.. my Under Construction Redirect issues are more general and they ...
RE: Uploading an MP3 file to my website by billkidwell
Joseph - I added the mp3 extenison to the list. It still diod not work. No error message but it did ...
RE: Uploading an MP3 file to my website by jncraig
Two things could go wrong.First, mp3 might not be an allowed file type.  You should have received an...
RE: Uploading an MP3 file to my website by billkidwell
Joseph - Thanks, but I see my post was unclear. I tried to upload the MP3 and teh uplaod failed. No ...
RE: What are best tools for localization? by jncraig
The modules from Apollo and the EALO and Magic Content modules are the ones that I would use.  I don...
DNM Rapid Application Developer Trial Version
RSS Feeds