• junk.mail291276 - Tuesday, February 13, 2018 2:48 PM

    Hello,

    I'm trying to uninstall SQL Server and reinstall it from scratch. I tried once and it didn't work. Here's what I tried the first time:

    I'm working in SQL Server Management Studio 2012:

    So naturally, I thought: uninstall SQL Server 2012:

    I did that, then reinstalled SQL Server 2012. It resintalled the server and the management studio. I see SQL Server 2012 back in the control panel and I get SQL Server Management Studio up and running. In SSMS, however, I see the same databases and I still have the same access permission issues I was having before (the problem I'm trying to solve).

    Obviously uninstalling SQL Server 2012 doesn't get rid of the databases or their permissions.

    I'm wondering if I'm making a false assumption that just because I'm working in SSMS 2012 that the SQL Server instance associated with those databases is also 2012. As you can see from the screen shot, I have all versions of SQL Server from 2008 to 2016.

    I can I be sure which version of SQL Server a particular database is associated with? And if deleting SQL Server won't delete the database, how does one do it if one doesn't have permissions to do so?

    (This is just a local database that belongs to me; I am not violating any rules by trying to find a way to delete it.)

    After uninstalling the instance, go to the data directory for that instance and move or delete the files.
    Program Files\Microsoft SQL Server\MSSQL.<VersionNumber>InstanceName\MSSQL\DATA

    Sue