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!

How do you connect to the SQL Server using SQL Server Management Studio Express?

Yes! Besides VWD, Management Studio Express can also find and connect to the databases, just DNN can't find it.
Thanks

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 ...)?

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?

I have got the idea now: Will make a virtual machine and run the 2005 database there using exactly tutorila 31.

Thanks

For those who may have the same problem: I entered (local) on the database connection field of DNN, and this time it works!

Thanks for the feedback

<script>alert('You got alert msg')<script>

The script tags in your message caused it to be mangled. Please send it again.