Hi all,

I'll give as much info as I can...

I'm trying to install DotNetNuke 4.5.5 on a Windows SBS 2003 machine (We'll call it Server2k3), and  I have a seperate box (FSLATTERY) which I run SQL Server 2005 Express from.

I have other machines that also connect to FSLATTERY for SQL purposes (one is a Blackberry Enterprise Server) and they are fully operational at the moment, so I'm fairly confident that it should be able to accept remote connections.

I've followed the instructions for installation to the extreme and I'm having the worst time understanding how you want me to formulate my connection strings....

Presently this is what I have.....

<connectionStrings>
<add name="SiteSqlServer" connectionString="Data Source=FSLATTERY\MSSQLSERVER;Database=DotNetNuke;User ID=dotnetnuke;Password=******" providerName="System.Data.SqlClient"/>
    <!-- Connection String for SQL Server 2000/2005
    <add
      name="SiteSqlServer"
      connectionString="Server=.\FSLATTERY\MSSQLSERVER;Database=DotNetNuke;uid=dotnetnuke;pwd=fender1f;"
      providerName="System.Data.SqlClient" />
   -->
  </connectionStrings>
  <appSettings>
    <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules   -->
    <add key="SiteSqlServer" value="Data Source=.\FSLATTERY\MSSQLSERVER;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|DotNetNuke.mdf;" />
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
    <add key="SiteSqlServer" value="Server=.\FSLATTERY\MSSQLSERVER;Database=DotNetNuke;uid=dotnetnuke;pwd=fender1f;"/>
    -->

With this setup, I can get into the installation (finally)... it checks my file permissions and everythings cool... on to the next page... then when I try to verify my SQL connection info I get this....

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: SQL Network Interfaces, error: 25 - Connection string is not valid)

I've enabled SQL and Windows Authentication as acceptable login types for the SQL machine, and I know that Windows-based authentication works fine because that's what my Blackberry Enterprise software uses to interact with FSLATTERY.... can anyone help me, I love dotnetnuke, but everywhere I look, I find differing answers on the naming conventions for each of the variables you need the end-user to fill in.

Thanks in advance.