I installed SQL Server 2008 Express to exist alongside SQL Server 2005 express in Vista for DotNetNuke.
When I attached the database to my SQL Server 2008 Express Server and edited the web.config file DotNetNuke stated the user does not exist.
I double checked all settings and could not find the problem on the server.
Of course it was the connection string in the web.config file.
I now have 2 instances of SQL Server and the 08 version I gave a different name to the default name - which was the problem.
The server name was sqlserver08 rather than the default value of sqlserver so the connection string had to be changed to:
< add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress08;Initial Catalog=C:\DOTNETNUKE SITES\DNN_490_SQL08\APP_DATA\DATABASE.MDF;User ID=leesykes;Password=leesykes" providerName="System.Data.SqlClient" / >
These little things can trip us up!
For configurations when attaching databases using Vista check out:
Introduction to SQL Queries with SQL Server Express, DotNetNuke and VistaHow to install DotNetNuke to Vista