Microsoft SQL Server 2005 Management Studio Express

The Bentley SELECTserver application comes bundled with SQL Server 2005 Express edition for use with the SELECTserver database. There may come a time when administrators will need to manage the SELECTserver database by performing common tasks such as Backups and Restores. These processes can be performed using the command line tool called SQLCMD or OSQL, but there's an easier way.

Microsoft offers a free download of the SQL Server Management Studio Express (SSMSE), an easy-to-use graphical management tool for managing, and administering components within MicroSoft SQL Server 2005 Express. To connect to a SQL Server Database Engine Instance using the (SSMSE), go to the file menu and click on Connect Object Explorer. Then in the Connect to Server Dialog specify your Server name and SELECTserver Instance and enter the account login credentials. If using the SQL Server Authentication, enter the 'sa' System Administrator account that was entered during the SQL Server 2005 Express installation, otherwise use the Windows Authentication. You can download the (SSMSE) from the MicroSoft link provided below.