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 ....Net SqlClient Data Provider error.Net SqlClient Data Provider error
Previous
 
Next
New Post
6/6/2011 6:42 AM
 

Hi, I have had nothing but errors when trying to install DNN 5.6.2 and or 5.6.0 ( I have tried both )

I am running SBS 2003 R2, with SP2 installed. I have .NET V2, V3.51 PS1 and V4 installed and working. I originally tried with SQL Express 2008 R2, but I kept

getting .NET SQL ZCLient errors on install ( just like many other people ) so I removed it and installed SQL express 2005. I get the same error(s), it seems

that no matter what I do, the install can not connect to the database. I have tried the link below, to no avail

http://www.dotnetnuke.com/Resources/B...

SQL Express was at least pick up with the auto install option, but Express 2005 have not picked up the auto install option in the 12 times I have tried to

install it. I can connect from a remote XP 32 SP3 machine using visual studio 2008 to the installation of SQL Express 2005 and it works fine, I can even

create a new database from VS 2008, so the logins ( SQL Server authorisation ) are working fine.

This is the error I am getting when I use the 'Typical' install option. I point it to the database I have created in SQL Server management studio express

called sever .\SQLExpress   and filename test.mdf and I have used both a normal user mapped to the test.mdf database as the dbowner and I have used the

master sa login as well, it does not work. I have also used my server name srv-xxx\sqlexpress incase there was an error with it not recognising the SQL

Express 2005 installation, which is why I am not getting the Auto install option. Before I removed the 2005 version, using 2008 R2 express, the auto option

would come up, but I still got the same error.

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 15364

The app pool has been set to use .net 3.51 SP1

Just in case there were differences in the install between 5.6.2, I went back to 5.6.0 and the same thing happened. I have viewed the webnar for the install

and followed it.

I really do know what is going wrong. It should not be this hard.

 
New Post
6/6/2011 9:18 AM
 
DNN should work fine with any SQL Server version 2005 and above, but make sure, you installed TCP/IP protocol for both, SQL Server and client, as well as enabled remote access.Are you using user instance or attached database? how does your connection string look like (please don't post passwords here).

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
6/6/2011 12:42 PM
 
I'm having the same problems as stuman_99 trying to install it on a development server via remote desktop. I can do the web install just fine on my machine, but when I try to install it on this server I start by getting permission problems. I've had a few guys here, who are much more technically knowledgable than I am, look at it and they can get me to the install wizard site, but it stalls out at the database and gives me the connection error with the .Net SqlClient Data Provider, Class: 20, Number: -1.
 
New Post
6/7/2011 6:25 AM
 
out of the 100 things I have tried I get a variety of errors, like the person who also responded to my post ( I am not alone ). How about a nice example of how to install this thing. I cannot confirm that it is even connecting to the db server. I can connect from my remote XP machine, hence the TCP protocol is installed and working correclty , yet I cannot use that connection string becuase it does not work. Am I able to install this thing using remote desktop?
 
New Post
6/9/2011 4:15 PM
 
stuman_99, I followed the instructions on this website: http://www.bestwebsites.co.nz/dotnetnuke/easy-dotnetnuke-installation-guide and actually got it to work instead of getting hung up on the database screen on the install wizard. I created a new database and a new database user and when I got to the database screen I typed in the IP address of the database and the name of the database I had just created, unchecked Integrated Security and entered the username and password for the database user and clicked next and the next screen prompted me for the host login info. I hope you have success on your install as well.
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ....Net SqlClient Data Provider error.Net SqlClient Data Provider error


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