New Posts New Posts RSS Feed: Relocate ASP.NET mbr db from SQL Svr Express to my db
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Relocate ASP.NET mbr db from SQL Svr Express to my db
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
rowek View Drop Down
Newbie
Newbie
Avatar

Joined: 03-Jul-2010
Location: Tallahassee
Posts: 8 		Post Options Post Options   Quote rowek Quote  Post ReplyReply Direct Link To This Post Topic: Relocate ASP.NET mbr db from SQL Svr Express to my db
    Posted: 27-Oct-2010 at 12:04pm
That did the trick. Thank you very much.
Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1391 		Post Options Post Options   Quote kimj Quote  Post ReplyReply Direct Link To This Post Posted: 27-Oct-2010 at 9:29am

The post you referenced also mentions how to re-point the connection string.  By default, ASP.NET has defined a connection string named "LocalSqlServer" in your machine.config, so in your web.config you must first remove the existing one, and then add your own.  Something like this:

<connectionStrings>
          <remove name="LocalSqlServer" />
          <add name="LocalSqlServer" connectionString="data source=.;Integrated Security=SSPI;Initial Catalog=aspnetdb;" providerName="System.Data.SqlClient"/>
       </connectionStrings>
 
You'll probably need to change the data source and Initial Catalog, and add a user id and password if using SQL security.
 
If the connectionStrings element isn't in your web.config yet, add it anywhere after any configSections defintions. 
Back to Top
rowek View Drop Down
Newbie
Newbie
Avatar

Joined: 03-Jul-2010
Location: Tallahassee
Posts: 8 		Post Options Post Options   Quote rowek Quote  Post ReplyReply Direct Link To This Post Posted: 27-Oct-2010 at 9:00am
Hi, after more digging I found a great post under "Getting Started" called "New Silverlight "Business Application" templates shipped with v6.0.6 ". 
 
I ran the Aspnet_regsql.exe wizard the the required objects were quickly built in my db.    My last issue is simple:  How do I tell DevForce to use my db instead of SQL Server Express?  I have read everything I can find and cannot find an entry in the web.config file.
 
Many thanks!
Back to Top
rowek View Drop Down
Newbie
Newbie
Avatar

Joined: 03-Jul-2010
Location: Tallahassee
Posts: 8 		Post Options Post Options   Quote rowek Quote  Post ReplyReply Direct Link To This Post Posted: 27-Oct-2010 at 8:29am
I really like DevForce v6.0.6.0, particularly the addition of the "DevForce SilverLight Business Application" template.   I am using the "Windows 7 Theme".   The good news this is a fresh, Proof of Concept app that only has one table in an existing database.   I read the docs and it indicated the ASP.NET Membership stuff will be hosted in SQLServer Express.   I don't want to do that.   I want all that good stuff in my existing db.   I also plan to add many more small tables to this db, but share the same ASP.NET Membership stuff.   What is my best approach?  Shall I run the command to create ASP.NET Membership stuff in my existing db then tell DevForce to use those resources (tables, views, SPROCs, etc.) instead?
 
I will gladly read any docs you can point me to.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down