Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI Manual Logger

TABLE OF CONTENTS

Configure SQL Server Management Studio Express

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedNov 21, 2022
  • 2 minute read

To manage basic database administration tasks, you need to download and configure SQL Server Management Studio Express.

  1. Obtain the free download of SQL Server Management Studio Express from Microsoft’s website. SQL Server Management Studio Express is available as its own download or included in the database installation kit. Refer to Microsoft’s download site for the appropriate installation kit.

    For SQL Server 2008, 2012, 2014, and 2016 installation kits that include SQL Server Management Studio Express, select New SQL Server stand-alone installation or add features to an existing installation on the Installation page to install the SQL Server Management Studio Express component, which is listed as a feature called Management Tools.

  2. As Administrator, choose Start > All Programs > Microsoft SQL Server 2005 (2008, 2012, 2014, or 2016) > SQL Server Management Studio Express.

  3. In the Connect to Server window, specify the SQL Server path, which is the server name and instance name you want to connect to (as specified in Configure SQL Server connection information). For example, if the default instance name, SQLExpress, was selected, then the server path would be: <Your SQL Server Name>\SQLExpress

    If you specified a named instance, for example, PIMLSQLExpress, the server path would be: <Your SQL Server Name>\PIMLSQLExpress

  4. Select the authentication mode (Windows or SQL Server).

  5. Click Connect to log in to the SQL Server database.

    Note: To attach or manage the PI Manual Logger SQL Server database, you must have administrative permissions on the server.

  6. Attach the PI Manual Logger database. Refer to Attach template files for SQL Server for steps to attach the PI Manual Logger database template file.

  7. After you attach the database file, refer to the Microsoft SQL Server documentation for information on how to add users to access the PI Manual Logger database.

  8. Right-click on the Server name and select Properties.

  9. Select Connections.

  10. Verify Allow remote connections to this server is checked.

  11. Click OK.

TitleResults for “How to create a CRG?”Also Available in