Hello,
I have been trying to find the solution to my issue for a while now, so hopefully I came to the right place. I followed the installation videos (found here http://www.dnnsoftware.com/community/learn/video-library/view-video/video/515/view/details/dnn-7-0-installation-part-1-file-system-configuration) step by step several times now and still come across the same problem every time. Here is the DB Connection Error I receive when I try to connect to a SQL Server Express 2014 and install DNN:
ERROR:Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 15372
Message:
The last time I installed SQL it was recommended that I selected "Mixed Windows Authentication and SQL (or something like that) over just going with the default "Windows Widows Authentication". That is the only thing that I have done differently and get this thing to work. If anyone can help me with this I would be forever in your debt!
More details:
Windows 8.1 X64
If I have the "SQL Server Express file" radio selected, I get the error I pasted above.
If I change it to "SQL Server/SQL Server Express Database" and give the database the name of "dnndev.me", I get the following error:
ERROR:Index #: 0
Source: .Net SqlClient Data Provider
Class: 11
Number: 4060
Message: Invalid Database
Index #: 1
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Sql login failed
If I leave it on "SQL Server Express File" as well as if I change it to "SQL Server/SQL Server Express Database" but also change the server name to local with a "." (period), I get this error:
ERROR:Index #: 0
Source: .Net SqlClient Data Provider
Class: 20
Number: 2
Message:
If you haven't noticed, I have really put a lot of effort into figuring this out, but no luck... I am an intern and this is a big project for my boss to assign to me, so I am very determined to figure this out! Thanks in advance!