I'm just trying to get past that infamous error message:

DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database specified in connectionString for SqlDataProvider

This is a clean install of DNN 3.0.9 on a W2K3 server running MSDE 2000 SP3. I created the virtual directory DotNetNuke and made sure that NetworkService had control of it. My connection string in web.config is "Server=(local);Database=DotNetNuke;uid=MyUser;pwd=MyPassword;". Using the Web Data Administrator I created a database called DotNetNuke and assigned MyUser to it with role db_owner.

What am I missing?

Depending on how you installed MSDE, it may need a Server name (instead of local).

Try the following

1. Use the actual ServerName instead of (local)

2. Try ServerName\VSDOTNET (sometimes MSDE installs and gives itself the VSDOTNET Instance Name)


Also I am assuming that MyUser/MyPassword is an MSDE User not a Windows User.

Thanks, it now works! You gave me the right idea. It was the MSDE User issue (i'm still learning about MSDE). Since everything I've read on the forums so far emphasized mixed mode, I assumed that both Windows and SQL users would work.

Since MSDE doesn't have an Enterprise Manager like SQL Server, is there a more convenient way to manage MSDE Users other than doing it through a command line query? The Microsoft Web Data Administrator helps, but it has its limitations.

I use DbaMgr2k from Andrea Montanari at http://www.asql.biz/DbaMgr.shtm. Very nice tool but haven't tried it under W2K3.

I use that tool under xp pro .. nice tool ... (even though I have EM too)