Hi all,

I have a problem with my installation of DNN. (I'm a novice !). I can't make a connexion with DNN and SQL database for to continue installation. this is my error :

Error Installing DotNetNuke
Current Assembly Version: 04.03.07
ERROR: Could not connect to database specified in connectionString for SqlDataProvider

but i d'ont understant really..... I checked all issues, but no.... i d'ont understand....  normally this error can be in the web config file, this is my string : 

<add key="SiteSqlServer" value="Server=tfr1Dotnet\DNN;Database=DotNetNuke;uid=dnn;pwd=toto;"/> 

the server is tfr1dotnet\DNN where DNN is my SQL instance, and DotNetNuke my database, the user "dnn" is owner of this base and is also in security modul. (SQL 2000 for version)

for me this file is ok..... ! I make a DSN configuration in ODBC, but nothing.....it's same error

solution found on internet don't resolv my problem

can you help me ?

thanks very much

Florence

thanks for your answer and your information

I checked for the comment markers, because I d'ont know this information, but the connection with database is always not Ok,  so, with an other tool, the connexion to dotnetnuke database is ok !

this is my webconfig file : (a part of)

what do you think ? Really I don't see where there is an error.... checked with server = Local, with server=tfr1dotnet and with Trf1dotnet\DNN (where DNN is instance), and with server= @ip, but it's doesn't work.

<connectionStrings>
<!-- *************** CONNECTION POUR SQL 2000 *********************** -->
<!-- Connection String for SQL Server 2000/2005 -->
    <add
      name="SiteSqlServer"
      connectionString="Server=tfr1dotnet;Database=DotNetNuke;uid=dnn;pwd=toto;"
      providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings> 
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->
    <add key="SiteSqlServer" value="Server=tfr1dotnet;Database=DotNetNuke;uid=dnn;pwd=toto;"/>
    <add key="InstallTemplate" value="DotNetNuke.install.config" />
    <add key="AutoUpgrade" value="true" />
    <add key="InstallMemberRole" value="true" />
    <add key="ShowMissingKeys" value="false" />
    <add key="EnableWebFarmSupport" value="false" />
    <add key="EnableCachePersistence" value="false"/>
    <add key="HostHeader" value="" /><!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->
    <add key="RemoveAngleBrackets" value="false" /><!--optionally strip angle brackets on public login and registration screens-->
    <add key="PersistentCookieTimeout" value="0" /><!--use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure-->
  </appSettings>

thanks for your help

Florence

Yes, of course, I also tried to log into the database DotNetNuke with login dnn and pass toto, with enterprise manager, and it's all rights ! and really I don't understand why it's ok with enterprise manager and also with ODBC DNS File !  I reinstall SQL server also ..... and same error....

I'm desesperate really .......