Hi Newbie here

Im unable to install dnn on our test server(win 2003 standard sp2 ) Ive installed IIS,dotnet fremework v2,SQL 2005 express and created a user account in SQL 2005 express and can connect to it when i try manually to connect. When i get to the install od DNN and type in the IP for my server for the install via the browser sometime it starts the install procedure but usually i get the dreaded 'could not connect to the database specified in the connection string for SQL data provider’ . Ive edited the webconfig file, here is a copy of it....

<!-- Connection String for SQL Server 2005 Express
  <add
    name="SiteSqlServer"
    connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
    providerName="System.Data.SqlClient" />
   Connection String for SQL Server 2000/2005 -->

    <add name="SiteSqlServer"
     connectionString="Server=(local);Database=AVVTestPortal;uid=wilcotn;pwd=strategy;"
     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=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>
   Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules  -->
   
    <add key="SiteSqlServer" value="Server=(local);
     Database=AVVTestPortal;uid=wilcotn;pwd=strategy;" />

Is there something stupid im missing here ? Ive tried to change the Server=(local) to the acutal server name but again no difference(just a guess really).Sometimes the install does start but i get an error message 'named pipes provider error 40,could not open a connection to sql server' on the screen after i test the connection.

Any Suggestion would be greatfully appreciated

Thanks

Hi Mitch

I tried that,i named the server to the actual win 2003 server name and both TCP/IP and named pipes were already enabled in the surface area connection wizard.Ive tried a restart of the database. I forgot to mention that i am installing DNN using vmware server consovle v 1-0-6 build 91891 as thats what is used on the live server (which i didnt configure). I either get the same message after i start the DNN install or the 'this site is currently unavailable 'please check back later message.

Any other suggestions ? or do i need a new build from scratch (IIS etc etc)

Thanks

Hi Brandon

Im using SQL server authentication. Im not sure what a default catalogue is ?
I will check the MSSQL logs to see if there is anything there.
 

Thanks for the advice