I just reinstalled SQL2005 Express on my laptop after unsuccessfully attempting to install SP2 for it (SP2 worked for all components except the database engine).  There are many issues without resolution in the installation of SQL2005 SP2, if you have not installed it yet, make sure you have a good backup before proceeding.

After doing the whole installation using the SQL 2005 Exp package with Advanced Services, which went flawlessly, I tried to run a recent installation of 4.4.1 I had done and it did not work, gave me the error below:

DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

ERROR: Could not connect to database.

Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.

I did unselect the User Instances feature during installation thinking that none of my databases was setup that way.  I had forgotten that I did not modify the setup of the 4.4.1 database because it was supposed to be a quick and dirty test configuration on this machine.

Anyway, the recommended remedy in the error message is not correct, instead of using the recommendation to "Use sp_configure 'user instances enabled' to generate user instances" the correct command sequence is below:

Mbiro:

I don't think so.  There has not been a service pack for SQL 2000 recently.  But the service pack for 2005 will be installed automatically if your WindowsUpdate settings are doing unattended updates.

First thing I would do is to reboot the server(s).  Is SQL 2000 running on the same box as DNN?  If not, reboot both and see if you can connect to SQL with Query Analyzer on the same box and from a separate one.

Edited to add that if you are indeed using SQL 2000, then the error message by DNN is also misleading/incorrect.

Carlos