I get this error on my windows xp sp2 machine. Im running both SQL2005 och SQLexpress on that comp but I would like to use sql express to start with. I haven't change anything but the filename to web.config. Is there any other step I must do?

Im running it via VS2005 and IIS.

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

I have given up using the SQL express and tried using standard SQL server 2005.
I have a user 'dotnetnuke' that is dbo in the database 'DotNetNuke' and that database have are using both SQL and Windows authentication.

And I still get :

Error Installing DotNetNuke

Current Assembly Version: 04.03.00

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

Here's what I have in my web.config amd yes the pwd is correct

<connectionStrings>

<!-- Connection String for SQL Server 2005 Express -->

<!--

<add name="SiteSqlServer" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=\App_Data\Database.mdf;Integrated Security=True;"/>

-->

<!-- Connection String for SQL Server 2000/2005 -->

<add

name="SiteSqlServer"

connectionString="Server=(local);Database=DotNetNuke;uid=dotnetnuke;pwd=nukem;" />

<!-- -->

</connectionStrings>

<appSettings>

<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->

<!--

<add key="SiteSqlServer" value="Data Source=.Data Source=.\SQLEXPRESS;AttachDbFilename=App_Data\Database.mdf;Integrated Security=True;User Instance=True;"/>

-->

<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->

<add key="SiteSqlServer" value="Server=;Database=DotNetNuke;uid=dotnetnuke;pwd=nukem;"/>

<!-- -->

I note that the Server= parts are different (local) in one and an empty string in the other.  I sometimes find that I need to use the machinename explicitly on my local computer.

---

Charles Nurse Chief Architect Evoq Content Team Lead, DNN Corp. Want to contribute to the Platform project? - See here

MVP (ASP.NET) and ASPInsiders Member