Can not connect to MS SQL Server 2005 from dotnetnuke

Hi guys, im having real trouble at the moment, can someone please help me.

I am using dotnetnuke and I think my connection string it not correct as i cant log into the database from my website. It says "ERROR: Could not connect to database."

Here is my web.config file part:

<connectionStrings>
<add
name="SiteSqlServer"
connectionString="Server=tcp:sql2k508.discountasp.net;Database=SQL2005_381568_gamesbuzz;uid=SQL2005_381568_gamesbuzz_user;pwd=*****;"
providerName="System.Data.SqlClient" />
</connectionStrings>

<appSettings>
<add key="SiteSqlServer" value="Server=tcp:sql2k508.discountasp.net;Database=SQL2005_381568_gamesbuzz;uid=SQL2005_381568_gamesbuzz_user;pwd=*****;"/>

Can someone please tell me if this is correct?

Kind regards,
Jy Morgan

 

What is the error message that you are receiving?

 

The username and password are correct as i can log into the database using SQL SMSE, so i would imagine they are correct?


The error im getting is this:







DotNetNuke Upgrade Error


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

ERROR: Could not connect to database.

PortalAliasID

Any ideas?

 

Try this:
Make the following change(between <appSettings></appSettings>) to the web.config file

<--Change true to false -->
<--Add if doesnt exist-->
<add key='UseDnnConfig' value='false' />

See if this resolves the issue!

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

Nope, that didnt work.

Anymore ideas guys??

 

Best solution is clean installation of the site,including a clean database,if you can afford to do so ,else try the following:

- copy dnn.config from the install directory (set UseDnnConfig is true in web.config instead)
- run the modules install command : http://localhost/dotnetnuke/install/install.aspx?mode=installresources (replace localhost/dotnetnuke with you own location of course).

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

Vikram, it means that i have to buy MS SQL Server 2005 addon??

or i can use just the file??

thanks

ErickG

 

You need the MS SQL 2k5/MS SQL 2k add-on for something data intensive as DNN.What file are you referring to?

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

i was talking about the mdb file... (was dreaming... with SQL Express for free )

anyway , its working now, thanks!

ErickG