How do I reconfigure SQL network protocols for Business Contact Manager?

Reconfiguring the SQL network protocols for Business Contact Manager for Outlook is an advanced administrative task.

Reconfigure Microsoft SQL Server 2005 to allow users on remote computers to access the shared database

By default, when Business Contact Manager for Outlook installs SQL Server 2005, it is configured to restrict connections only to users on the local computer. The SQL Server configures the Business Contact Manager database to only allow users on the computer where the database is stored to connect to the database.

When the Business Contact Manager database is shared, Business Contact Manager for Outlook automatically activates networking support to allow users on other computers to connect to the shared database by enabling both the TCP/IP protocol and the named pipes protocol.

To manually activate networking support to allow users to connect to this database from a remote computer, complete the following procedure.

  1. Click Start, and then point to All Programs.

  2. Click Microsoft SQL Server 2005.

  3. Click Configuration Tools, and then click SQL Server Surface Area Configuration.

  4. Click Surface Area Configuration for Services and Connections.

  5. On the View by Instance tab, click MSSMLBIZ, click Database Engine, and then click Remote Connections.

  6. Click Local and remote connections, and then click Using both TCP/IP and named pipes.

If the preceding information does not resolve the issue, search either the Microsoft Office Online Web site or the Microsoft Support Web site for advanced help with Microsoft SQL Server.

If you are located outside the United States, go to the Microsoft International Support Web site.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×