Tuesday, December 22, 2009

Configuring OCS Archive Viewer with SQL 2008 Express


Trying to connect to SQL Server 2008 Express remotely without enabling remote connection first, may result in the following warning messages:

“Cannot connect to SQL-Server-Instance-Name
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 28 – Server doesn’t support requested protocol) (Microsoft SQL Server)”
“Cannot connect to SQL-Server-Instance-Name
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQLServer does not allow remote connections.(provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQLServer)”
“Cannot connect to SQL-Server-Instance-Name
Login failed for user
username‘. (Microsoft SQL Server, Error: 18456)”

To enable remote connection on SQL Server 2008 Express, follow steps below:

1. Open SQL Server Configuration Manager. Click Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager.

2. On SQL Server Configuration Manager, select SQL Server Services on the left window. If the state on SQL Server Browser is not running, you have to configure and start the service. Otherwise, you can skip to step 6.

3. Double-click on SQL Server Browser, the Properties window will show up. Set the account for start SQL Server Browser Service. In this example, I set to Local Service account.

4. On SQL Server Browser Properties, move to Service tab and change Start Mode to Automatic. Therefore, the service will be start automatically when the computer starts. Click OK to apply changes.

5. Back to SQL Server Configuration Manager, right-click on SQL Server Bowser on the right window and select Start to start the service.

6. On the left window, expand SQL Server Network Configuration -> Protocols for SQLEXPRESS. TCP/IP protocol status is disabled.

7. Right-click on TCP/IP and select Enable to enable the protocol.

8. There will be a pop-up message stating that you have to restart the SQL Service to apply changes.

9. On the left window, select SQL Server Services. Select SQL Server (SQLEXPRESS) on the right window -> click Restart.

The SQL Server service will be restarted.

10. Now OCSAV can remotely connect to the SQL Server Express 2008.

11.Test the connection in Database Settings tab on the... itimarchiveviews/Admin/index.aspx Page

and Save.

No comments: