Hi, I running Win XP Pro, MSDE 2000, DDN 2.0.4

I have just done a clean install of DNN

I'm getting this error:

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

Here's my web.config settings:

<appSettings>
<add key="connectionString" value="Server=localhost;Database=DotNetNuke;uid=DNN;pwd=pass123;" />
</appSettings>

*******************************

<providers>
<clear/>
<add name = "SqlDataProvider"
type = "DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
connectionString = "Server=localhost;Database=DotNetNuke;uid=DNN;pwd=pass123;"
providerPath = "~\Providers\DataProviders\SqlDataProvider\"
objectQualifier = ""
databaseOwner = "dbo"

**************************************

I ran this script to setup the db user:

**************************

if not exists (select * from master.dbo.syslogins where loginname = N'DNN')
EXEC sp_addlogin N'DNN', N'pass123', N'DotNetNuke'
GO
USE DotNetNuke
if 'DNN' <> 'sa'
BEGIN
if not exists (select * from dbo.sysusers where name = N'DNN' and uid < 16382)
EXEC sp_grantdbaccess N'DNN', N'DNN'
EXEC sp_addrolemember N'db_owner', N'DNN'
END
GO


*************************************

I can log into the db with the user names specified, and make queries, so it seems that the db is working correctly.

When I browse to my local site for DNN , fttp://localhost\DNN, I get the error.

I have checked and re-checked the installation pocedures, I can't see what I'm doing wrong. I"M NOT USING MS SQL Enterprise GUI, I'm working from the osql command prompt.

Any help would be apreciated.

If you're using MSDE you can't have a default instance such as localhost. It will always take the form of the machinename\instancename . Open a command prompt and type

OSQL -L

This will probe port 1434 for any SQL instances that can be seen. You'll see one with the name of your machine a slash and another name e.g. davidparker\netsdk . Use that in place of localhost.

Cathal

Cathal,

I enterd OSQL -L at the command prompt and got this:

SERVERS:

--------- NONE ---------------


********************************************************
Now, I went and looked at the connection string for the communitySarterKit, which I have installed, and found this:

<add key="connectionString" value="Server=(local);Trusted_Connection=true;database=CommunityStarterKit2" />

I then changed my DNN connection string to this:

<add key="connectionString" value="Server=(local);Database=DotNetNuke;uid=DNN;pwd=pass123;" />

***********************************************************

DNN is now working!!!

Thanks for your help Cathal, this wouldn't have dawned on me for quite some time without your help.

Thanks!!

For anyone following this thread:

There is very goog "How to" setup DNN with MSDE at http://duhnetnuke.net/

You have to be a registered user to get to it. It's under "OtherStuff" in the Discussion forums.

dp