Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Configure the Database.mdf to display a SQL2005 DBConfigure the Database.mdf to display a SQL2005 DB
Previous
 
Next
New Post
7/25/2008 11:35 AM
 

Greetings all. I'm a noob with DNN and starting to play around with it. I have gotten modules running but without use the Data Access Layer configuration... I tried but had problems and i just do my DB stuff in the logic layer. I just didnt do it because it was giving me issues with running procedures and reading from it (Exception has been thrown by the target of invocation...) Anyways, i did noticed that i never got the Database.mdf to display my database and its subfolders so maybe i got something wrong with the configuration. I though it was just because im using SQL2005 and not express (i dont even have express installed). So I am wondering if this is actually supose to be like that or rather I should be able to see the DB and its details with that file through VS2005 even though I'm using SQL2005 dev edition? I dont even have express installed (actually uninstalled it cause for some reason my management studio wasnt working with both installed). Thanks in advance. 

This is part of my webconfig just to confirm that my connectionstring is complete well written:

<

connectionStrings> Connection String for SQL Server 2005 Express--> Connection String for SQL Server 2000/2005 -->add name="SiteSqlServer" connectionString="Server=CRM4\SQL2005;Database=FlowCartDNN;uid=flowcartuser;pwd=fc2008;" providerName="System.Data.SqlClient" />connectionStrings>appSettings> Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules--> Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->add key="SiteSqlServer" value="Server=CRM4\SQL2005;Database=FlowCartDNN;uid=flowcartuser;pwd=fc2008;" />add key="InstallTemplate" value="DotNetNuke.install.config" />add key="AutoUpgrade" value="true" />add key="UseInstallWizard" 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-->add key="PersistentCookieTimeout" value="0" />use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure--> set UsePortNumber to true to preserve the port number if you're using a port number other than 80 (the standard)-->appSettings>

<!--

<add name="SiteSqlServer" connectionString="Data Source=CRM4\SQL2005;Initial Catalog=FlowCartDNN;Integrated Security=True" providerName="System.Data.SqlClient" />

<!--

<

</

<

<!--

<add key="SiteSqlServer" value="Data Source=CRM4\SQL2005;Initial Catalog=FlowCartDNN;Integrated Security=True" />

<!--

<

<

<

<

<

<

<

<

<

<!--

<

<!--

<

<!--

<!--

<add key="UsePortNumber" value="true" />

</

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Configure the Database.mdf to display a SQL2005 DBConfigure the Database.mdf to display a SQL2005 DB


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out