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:142
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:5354
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:142
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:5354
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:142
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:142
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:142
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:5307
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

RE: How to do links? by Guy..L
It's really hard to tell quite how awesome DNN Nav v2 is given the documentation and search results ...
Regarding Editor by prithviraj
Pls let me know whar folders we need to upload when we are changing editors. Suppose i have cute edi...
RE: Change Registration Redirect? by leesykes
It would be best to use Dynamic Registration to avoid 2 registrations.With Dynamic Registration you ...
Indexing DNN pages by Google by Jake Vizner
I have two different DNN web sites. Using Google Webmaster Tools I can see the Google indexed 12 out...
Query Regarding RAD EDitor by prithviraj
Hi, I'm using R.A.D editor in my site. At the time of adding images through the editor I'm unabl...
RE: while installing bulk emailer module in my website by jncraig
Yes, this definitely is a file permissions issue. The default ASP.NET worker task needs to have ful...
RE: Background Music by jncraig
That will work.
RE: Auto create pages and content by dhassall
Hi Joe DNN Out of the box version 4.9 Login as Host with Firefox to create and IE8 to monitor, CTR...
RE: while installing bulk emailer module in my website by dub
Agiline, We have seen this problem before. It is caused by the Security on IIS. Please have a loo...
RE: Change Registration Redirect? by ollep
Probably still want to do it with Dynamic Forms now.My reason for changing (except from getting Aweb...
RE: Change Registration Redirect? by ollep
YES!http://www.dnncreative.com/Subscribe/tabid/81/Default.aspx
RE: Change Registration Redirect? by ollep
Yes I noticed that we where talking about 2 different Modules as soon as I dug into the tutorials.Ab...
RE: Change Registration Redirect? by leesykes
If you are check out the links that I have placed in there:http://www.dnncreative.com/Subscribe/tabi...
RE: Change Registration Redirect? by leesykes
Are you referring to when subscribing there is a link to register and after they register it sends t...
RE: Change Registration Redirect? by leesykes
The method I use on here for managing my email list is complicated and involves SQL queries, it is b...
Ecommerce module needed by vishalranaut
Infyecommerce is providing ecommerce packages for the clients to develop their ecommerce sites.They ...
RE: DS Dynamic Forms / AWeber by leesykes
If you are getting time out issues when installing I would use the auto install method by using FTP,...
RE: Change Registration Redirect? by ollep
Oooops Helps reading your responses before posting here Lee. I referred to Issue 40 / 41 and ...
DS Dynamic Forms / AWeber by ollep
Thanks for a great Tutorial Lee!  - As usual.(I still can't install the module in Firefox though, Fi...
while installing bulk emailer module in my website by agiline
Hi all,i have downloaded bulk e mailer trial version and when i am installing it in my website it wa...
DNN Creative Subscribe
RSS Feeds