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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQL 2005 Connextion String ProblemsSQL 2005 Connextion String Problems
Previous
 
Next
New Post
7/30/2007 4:20 PM
 

Hi Guys...  I have a new SQL 2005 box, and a new IIS 6.0 site pointing to a directory with the Install files for 4.5.5 unzipped.  I have configured the folder w/permissions for the NETWORK SERVICE user, and have altered web.config connection strings.  I've doublechecked, and it does seem that my server, database, uid, and pwd are correct.  I have the server name as the named instance on my sql server, the database as the blank db i created today, the user and pwd correct.  However, I'm still getting this:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 20
Number: 2
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

All computers are on a local Intranet and are on the same domain.  Any ideas where to start on this one?

Oh, by the way, I can get through the file permissions check screen of the install wizard.  I cannot get past the Test Database Connection page.  That's where I get this error.  The application event viewer on the web server produces the exact same message.


Chad Voller -- MCP, DNN Aficionado
Leapwise Media
View my View Chad Voller's profile on LinkedIn
 
New Post
7/30/2007 5:04 PM
 

vollerworld,

I know that you had said it seems that all of your connection string information is correct, but I've been in a simliar situation before and was helped by trying to use the values from the connection string to manually log in through sql server management studio.  Have you tried this? If not, give it a shot.

take care,

Ian


Software Engineer
Co-Founder, dnnGallery
Stack Overflow: Ian Robinson
Twitter: @irobinson
Linked In: Ian Robinson
 
New Post
8/3/2007 2:34 PM
 

Ian,

Thanks for the help... I'm so new that I have problems with even the most basic terminology.  When I log into management studio on the SQL 2005 box, I just click <CONNECT> on the window that pops up when I load the program.  It says 

Server type: Database Engine; 
Server Name: CDCSQL_DEV\SQLDEV1; 
Authentication: Windows Authentication. 

I click <CONNECT> button and I'm in like Flynn.  So, all that to say, I'm not even sure how to "manually log in."  I figured that's what I was doing.  But again, I'm waaayyy new to this whole SQL thing, and to .NET.

In my connection string, I figured I would use the CDCSQL_DEV as the name of the server.  Should I use the whole thing CDCSQL_DEV\SQLDEV1 for the server name, or just the instance name maybe?


Chad Voller -- MCP, DNN Aficionado
Leapwise Media
View my View Chad Voller's profile on LinkedIn
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQL 2005 Connextion String ProblemsSQL 2005 Connextion String Problems


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