server name in connection string

do i put the full qualified name server name in the connection string like: mssql05.discountasp.net or just mssql05?

 

See anything wrong with this?

the database name, username and password are correct.

'Data Source=mssql05.discountasp.net;Initial Catalog=databasename;User=username;Password=***'

 

Provider=SQLOLEDB;Data Source=mssql05.discountasp.net;database=databasename;uid=username;pwd=****;

 

thats not working either. im trying to install dnn4.

So I've used the search help feature of this site and found something. but it still doesnt work.

I have all the files uploaded and im using the instructions from this page: kb.discountasp.net/article.aspx?id=10382


here is part of my web.config file:



<connectionStrings>
<add name='SiteSqlServer' connectionString='Server=mssql05.discountasp.net;Database=DB_1817764_dotnetnuke;uid=DB_1817764_dotnetnuke_user;pwd=*****;' providerName='System.Data.SqlClient' />
</connectionStrings>
<appSettings>
<add key='SiteSqlServer' value='Server=mssql05.discountasp.net;Database=DB_1817764_dotnetnuke;uid=DB_1817764_dotnetnuke_user;pwd=*****;'/>
<add key='InstallTemplate' value='DotNetNuke.install.config' />
<add key='AutoUpgrade' value='true' />
<add key='InstallMemberRole' value='true' />
<add key='ShowMissingKeys' value='false' />
<add key='EnableWebFarmSupport' value='false' />
<add key='EnableCachePersistence' value='false'/>
<add key='HostHeader' value='' /><!-- Host Header to remove from URL so 'www.mydomain.com/johndoe/Default.aspx' is treated as 'www.mydomain.com/Default.aspx' -->
<add key='RemoveAngleBrackets' value='false' />
<!--optionally strip angle brackets on public login and registration screens-->
</appSettings>

 

The method I successfully use forthe web.configis:

<connectionStrings>
<add name="nameofstring" connectionString="Data Source=datasource.discountasp.net;Initial Catalog=databasename;Persist Security Info=True;User ID=username;Password=password" providerName="System.Data.SqlClient"/>
</connectionStrings>

 

What error message are you getting?

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

I can't help you with this one any further bro, as I don't Nuke.

 

Thanks,

here is the error:


Error Installing DotNetNuke
Current Assembly Version: 04.03.04
ERROR: Could not connect to database specified in connectionString for SqlDataProvider

 

actually i am getting this error now:


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

ERROR: Could not connect to database.

Cannot open database requested in login 'Database=DB_181776_dotnetnuke'. Login fails. Login failed for user 'DB_181776_dotnetnuke_user'.