|
SQL Server 2005 Express Guide |
  
|
|
SQL Server 2005 Express Guide |
|
Some ClearCanvas products can make use of a SQL Server 2005 Express database. Below are a few common configuration items and how to perform them:
Restart SQL Server
| 1. | Run SQL Server Configuration Manager |
| 2. | Under SQL Server 2005 Services, Locate SQL Server (SQLEXPRESS) and select Restart Service |
Enable TCP/IP Protocol Support
| 1. | Run SQL Server Configuration Manager |
| 2. | Under Protocols for SQLEXPRESS, Enable TCP/IP by right-clicking on the TCP/IP entry and selecting Enable. |
3. Restart SQL Server
Enable SQL Server Authentication
The easiest method to enable SQL Server Authentication is to enable it during install time. However if SQL Server Express has already been installed it is possible to enable SQL Server Authentication by following option b).
a) At install time
1. During the installation of SQL Server 2005 Express, on the Authentication Mode dialog change the mode to Mixed Mode.
b) After install time
Note: Requires SQL Server Management Studio Express
| 1. | Sign into SQL Server Management Studio Express using Windows Authentication |
| 2. | Access the Properties of the Database Server, change the Server Authentication mode to SQL Server and Windows Authentication mode |
3. Restart SQL Server
Enabling the sa Account
Note: Requires SQL Server Management Studio Express
| 1. | Sign into SQL Server Management Studio Express |
| 2. | Under Security/Logins in the tree, access the properties on the sa account |
| 3. | In Login Properties for the sa account, on the Status page, set the Login to Enabled |
Setting sa Account Password
Note: Requires SQL Server Management Studio Express
| 1. | Sign into SQL Server Management Studio Express |
| 2. | Under Security/Logins in the tree; access the properties on the sa account |
| 3. | Under General properties set a password using the fields, Password and Confirm Password |
Using IP Instead of Hostname for Connection
| 1. | Run SQL Server Configuration Manager |
| 2. | Under SQL Server 2005 Services, access the properties of the SQL Server Browser Service |
| 3. | On the properties dialog, under the Service tab set Start Mode to Automatic and Apply the change |
| 4. | Back on Log On tab, Start the Browser Service |
