C
craig.holdheide
Guest
Looks like this post is about six months old, but I will post an answer to it anyways. Hope this helps. To connect to a SQL Express database you will need SSMS installed and setup. Also, the SQL Express database can NOT be located inside your local user profile, such as your documents or download folder. First, open SSMS and in the Object Explorer, select the Connect drop-down, and then select Database Engine... Second, in the Connect to Server dialog, select your local SQL Express instance on the Server name drop-down. You are looking for the instance name "{YOURMACHINENAME}\SQLEXPRESS" where {YOURMACHINENAME} is the name of your pc. If you don't see this an option in your drop-down list, then select . Under the Local Servers tab, you should be able to locate your SQL Express database engine. If you do not see it then you do not have SQL Express installed. Once you found it, select it and click OK. Third, once you are connected, then right-click on the "Databases" node and select Attach... You should then be able to find your SQL Express database file (.mdf) and connect to it. Also, if you're running this site on a different hosting environment, first make sure they support SQL Express. Second, you may need to modify the connection string to get your Sitefinity instance to connect to it. Hope this helps. Craig
Continue reading...
Continue reading...