So.. everythings going good, installed and running for a week. I start working on some additional tables i need
for my application. I've setup a duplicate DB that i create my tables/procs etc. So yesterday I use MSSQL
import/export to transfer my tables to my 'running/Live' DB, copy the tables no problem, attempt to fire up the site
and the following error msg's occur. (this has happened to me before, it seems as soon as you attach to the DB
using MS's SQLMS, it looks like it alters or changes something in the DB).. am I missing something silly
Dev System: VS2005 pro, SQL Express 2005, DNN 4.0.3 (Note: I have SQL Server 2005 enterprise runnng on my Dev System, so the SQL Mgmt
studio is from the Ent Software, not the Express Mgmt version, not sure if this would make a difference.)
ERROR: Could not connect to database specified in connectionString for
SqlDataProviderSystem.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'VENUS\ASPNET'
....
DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database.
Cannot open user default database. Login failed. Login failed for user 'VENUS\ASPNET'.
Any insight appreciated
Johnny