Hi,

I installed a copy of DNN on a win xp pro computer with sql server express and created my site just fine.   Upon migrating this site, my plan was to zip up my entire public directory, which includes the database.mdf and database_log.ldf files and extract it on the public directory of a server running IIS 6 ans SQL Server 2005.   After extracting those files, I imported the Database.mdf file using a CREATE TABLE FOR ATTACH command, and I updated the web.config file and altered the query string in the <connectionString> tag as well as in the <appSettings> tag.  Finally I updated the PortalAlias table so that the host ip would reflect the new server.

Now, I'm getting the following error:  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.... Error Locating Server: Instance Specified

I used the connection string in another application, and it works fine, so I'm not sure what the problem can be.   Can anyone help?

Note: here's my connection string:


    <add
      name="SiteSqlServer"
      connectionString="Server=S6;Initial Catalog=dnn;User Id=dnnuser;Password=******;"
      providerName="System.Data.SqlClient" />



thanks!

Well the problem is that none of these explain why that connection string works on other applications on that server.   I've been searching around on google and I really couldn't find anything.  Am I migrating my information the wrong way?   Are there other settings that need to be modified that is normally automated in the installation process?

thanks for your reply,
Greg