troubleshooting Question

Migrating Web site which uses SQLEXPRESS database

Avatar of Tony Davidson
Tony DavidsonFlag for Australia asked on
SQLMicrosoft IIS Web ServerWindows Server 2008
51 Comments1 Solution279 ViewsLast Modified:

I'm attempting to migrate a web site from a Windows 2008 Server to Windows Server 2012 R2.

I have migrated the Web site using EMT7 which migrates the Web site settings.

However the site appears to be using a SQLEXPRESS database, here is the connection string for the site
data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

Open in new window

There don't appear to be any SQL Express Management tools on the source server (like Management Studio for instance) - at least not in the Start Menu, which I find surprising.

I'm a novice in this area and am wondering how to proceed

Thank you
Dan McFadden
Technical Lead - Active Directory

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 51 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 51 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros