Hi All, I'm new to Sitefinity. We have v10.2.x running on IIS 8 and SQL Server Express. I need to move the project to another server. How to I manage the SQL database using SSMS like I normally do? I cannot see the database when I connect using my user account account with Windows authentication. I know where the mdf file resides in App_Data, and I see the connect string in App_Data\Sitefinity\Configuration\DataConfig.Config.
<add connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Sitefinity.mdf" name="Sitefinity" />
I know the database is there, because the site runs fine. I just cannot see the Sitefinity database in SSMS, what account should I use to connect and manage?