Register | Log In
Download Contact
Resources > Forums
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...sql express to MS sqlsql express to MS sql
Previous
 
Next
New Post
5/18/2012 5:34 PM
 
User is offline Paul Turner


Joined: 5/19/2007
Posts: 93

Hi Guys,

A client wishes to move their DNN site to my hosting services but the site was originally sqlexpress so the database is in the app_data folder. I have MS SQL Web Edition installed on my server and do not want to be really messing around with installing sql express.

Is it possible to attach the database in MS SQL Studio and add the network services user to it and change the we.config for now just to get him up and running. if yes what do I change the web.config strings to. I know how to attach the database.


Thanks in advance

Paul
 
New Post
5/18/2012 6:28 PM
 
User is offline cathal connolly


cathal connolly's Avatar

cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 7382
yes, this is entirely possible - see http://stackoverflow.com/questions/302690/how-to-move-a-sql-server-express-mdf-file-to-a-different-sql-sever-express-serve for some tips. You can either create a new standrd user (make sure they're a dbo) or use the networkservice user -depending on the approach you use standard security or trusted connection - http://www.connectionstrings.com/sql-server-2008
 
 Page 1 of 1
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...sql express to MS sqlsql express to MS sql


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

Attend A Webinar
Start Professional Edition Trial
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

Sponsors

DotNetNuke Corporation

DotNetNuke (DNN) provides a suite of solutions that make designing, building and managing feature-rich sites and communities fast, easy and cost-effective. The DotNetNuke Platform CMS is the foundation for more than one million websites worldwide. DNN Social, our newest solution, enables businesses to create immersive, interactive communities. Thousands of organizations like True Value Hardware, Bose, Cornell University, Glacier Water, Dannon, Delphi, USAA, NASCAR, Northern Health and the City of Denver have leveraged DNN to deploy highly engaging business- critical websites. Our rapid growth in product sales and deployments resulted in DotNetNuke Corp. being named one of the fastest growing private companies in America by Inc. Magazine in 2011 and 2012.
Copyright © 2002-2013 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP