Bosch Appliances D5500CU manual Install SQL Server Management Studio Express

Page 65

RPS	Maintenance en 65

5.When the Backup Completed Successfully dialog opens, click OK.

6.7	Install SQL Server Management Studio Express

NOTICE!

Networking protocols are disabled by default in SQL Server Express. If someone simply installs SQL Server Express and chooses all the defaults, SQL Server Express can only have connections originating on the local machine where SQL Server is installed.

To enable SQL Server Express to accept remote connections, configure SQL Server Express to listen on TCP/IP:

–Launch the SQL Server Configuration Manager from the Microsoft SQL Server 2005

program menu.

–Click the Protocols for SQLEXPRESS node.

–Right-click TCP/IP in the list of protocols, then select Enable.

–In the SQL Server Configuration Manager, click the SQL Server 2005 Services node.

–Right-clickSQL Server Browser and select Properties.

–Select the Service tab, and set Sart Mode to Automatic.

–Click Apply. The Start button is now active.

–Click Start to start the SQL Server Browser.

Bosch Security Systems, Inc.

Installation Guide

4998141259 12 2011.10

Image 65

Contents RPS Page Table of Contents Log into RPS MaintenanceRPS Operation and Control Panel Account Notes IndexSoftware License Agreement 1Legal1Trademarks En Legal RPS RPS Minimum System Requirements IntroductionRelease Notes Browser Minimum System Requirements for SQL Express OnlyMinimum 500 MHz PC with Vista RPS and SQL Express on the Same PC Minimum RequirementsMinimum System Requirements for RPS and SQL Express on a Bit 2 GB PC with WindowsBit 1 GB 1Overview Install RPSInstall RPS with a Local SQL Database Install RPS en Use an Existing SQL Instance, Create a New SQL Instance, Prepare the Installation of the SQL Database and RPSRPS Install the SQL Database Install the SQL Database and RPSRPS En Install RPS RPS Install RPS with a Network SQL Database Then click Next En Install RPS Install the SQL Database and RPS En Install RPS RPS En Install RPS Use an Existing SQL Instance En Install RPS SQL Instance Name Boschsql User Name sa Password sql12345 RPS Database Name RpsdbCreate a New SQL Instance Overview Automatic Installation of RPSGenerate the RPSInstallation.ini File Customize the RPSInstallation.ini File Use the RPSInstallation.ini FileKnown Issues View the Installation Log FileBefore You Upgrade RPS Upgrade RPSUpgrade RPS with a SQL Database Select Start Run… Upgrade RPSUpgrade RPS en En Upgrade RPS RPS En Upgrade RPS RPS with a SQL Database, page 33 for upgrade instructions Upgrade RPS with a Microsoft Access DatabasePrepare the Upgrade for a Local SQL Database Prepare the Upgrade for a Network SQL Database En Upgrade RPS Upgrade RPS En Upgrade RPS RPS 3Share the SQL Database Click Upgrade Database Select ConfigSystemFile LocationsIntegrate the RPS Database Files into the SQL Database Automatic IntegrationConversion Log File 3Upgrade from RPS 5.11 or LowerCreate a New Database First Time Log-In Log into RPSChange the Password Set Security Levels by Panel Type for Networked Users MaintenanceModify RPS Modify, Repair, or Remove RPS2Repair RPS 3Known Issues4Remove RPS Revert to a Previous SQL Database Revert to Previous RPS Installation After SQL UpgradeEn Maintenance RPS En Maintenance RPS Revert to a Microsoft Access Database Select Config System File Locations Recover Old Database FilesSelect Config System Switch from a Client to a Network InstallationRPS Back Up the SQL or SQL Express Database Right-clickSQL Server Browser and select Properties Install SQL Server Management Studio ExpressClick the Protocols for Sqlexpress node En Maintenance RPS En Maintenance RPS RPS Operation and Control Panel Account Notes Installation and AdministrationRPS Notes General OperationD6412/D4412 and DS7240/DS7220 Control Panel Account NotesSeries D9112B1, D7212B1 D7024 and DS9400D8112 6DS7400XiV4-EXP Numerics IndexRPS En Index Page Bosch Security Systems, Inc