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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Configure Database ConnectionConfigure Database Connection
Previous
 
Next
New Post
5/8/2007 5:55 PM
 

Configure Database Connection

You can configure the database settings used by DotNetNuke on this page. If you are installing DotNetNuke in a "Hosting Account" your hosting provider should have provided you with the information.

There are two options for SQL Server 2005. SQLServer 2005 supports the use of Database Files. In most situations you should choose the Database option, but if you are using SQL Server 2005 Express then you should use the File option.


Select Database:
 

Server: Enter the Name or IP Address of the computer where the Database is located. (if using Oracle enter the Data Source (SID))
Filename: Enter the name of the Database File (located in the App_Data Directory)
Integrated Security: Check this if you are using SQL Server's Integrated Security, which means you will be using your Windows account to access SQL Server. If you are using SQL Server Express then you will most likely need to check this option. If you have been given a UserId/Password to access your Database, leave this unchecked, and provide the UserId/Password combination.
Run as db Owner: Check this if you are running the database as Database Owner - if left unchecked you will be running as the User ID specified
Object Qualifier: Enter an optional "prefix" to use for all your database objects - this helps ensure that there are no object name clashes.

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 20
Number: -1
Message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

 

Can someone please help me. This is my first attempt at installing this and I'm not sure exactly how to allow remote connections.

Thank you for any help you can provide. Andrew

 
New Post
5/9/2007 10:25 AM
 

You can configure the remote connections option from the "Surface Area Configuration" tool within SQL Server.

You should find this tool listed under SQL Server 2005 in your start menu.


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
New Post
4/11/2008 5:56 PM
 

Ok you`re right

but anyway I`m on Sql Server 2000

and i don`t know how this thing because there is no tool as "Surface Area Configuration"

is there?

I could use some help please i`m stuck at this point

Thanks in advance

 

 
New Post
4/13/2008 9:22 AM
 

i switched to Sql Express 2005 is better this way

i installed and works like a charm

thanks though

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Configure Database ConnectionConfigure Database Connection


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