can someone tell me what the proper connection string for 4.9.2 is?

 the listed strings in the 4.9.1 and 4.5.5 release.config are
 <!-- Connection String for SQL Server 2000/2005   -->
    <add
      name="SiteSqlServer"
      connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
      providerName="System.Data.SqlClient" />
 

I am using (in a 4.5.5 install that is currently in production)
     <add
      name="SiteSqlServer"
   connectionString="
Data Source=172.21.1.13;
Initial Catalog=dbname;
User ID=dbusername;
Password=dbpassword"
   providerName="System.Data.SqlClient" />

I found instructions on installation that still refer to the old strings as correct.

I have tried both and neither is working and I am only getting the error message:

Server Error in '/' Application.
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
(tried setting the customErrors tag but the results do not change)

Hello guys, Ive got the exact same error on version 04.09.00. My connection string looks identical. I tried to follow that list Sebastian gave. However I am unable to stop or start the IIS service as I am on a shared hosting server.... Any sugestions on how to get the service to restart?

Thank you,

Jacob Bushnell

Hi Sebastian,

I can see that I wasn't very clear on my initial post; I am doing a fresh install of dnn 4.9.2 on IIS 6.0, (a new virtual server instance there as well).

I tried the connection string syntax in the release.config file that came with 4.9.2 zip but got the install error, and as far as I could tell nothing happened in the db (my sql server is a second machine). So I tried the syntax for the connection string from my current working installation of DNN. That did not work either.

and I can not get the change for getting error messages to work either. I make the change but the error message remains the same.

<configuration>
    <system.web>
        <customErrors mode="Off"/>
    </system.web>
</configuration>