The following procedure allows you to clean up the SQL Server 2014 database by using Microsoft SQL Server Management Studio options.
-
In Microsoft SQL Server Management Studio, on the Connect to Server dialog box, do the following:
-
From the Server type box, select Database Engine.
-
Connect as SA to open the Object Explorer.
-
-
In the <server name> > Databases folder, do the following:
-
Expand the Security > Users hierarchy of the target SmartPlant Instrumentation database to display the database user login names.
-
Remember the Admin schema login name (you will need to delete the Admin schema login).
-
In the Databases folder, right-click the target SmartPlant Instrumentation database and click Delete.
When deleting the database, the software also deletes the appropriate filegroups, the INTOOLS_ENGINEER role, and the SmartPlant Instrumentation database schemas (database users).
-
-
In the <server name> > Security folder, expand the Logins folder of the target SmartPlant Instrumentation database and do one of the following:
-
If your SmartPlant Instrumentation database is the only database in the current instance, right-click and delete the following logins: SPI_login, SPIsuper, and the Admin schema login.
-
If you have other SmartPlant Instrumentation databases in the current instance, right-click and delete only the Admin schema login.
The SPI_login and SPIsuper logins are shared for all SmartPlant Instrumentation databases created in the current SQL Server instance.
-