Settings for enabling network access to SQL Server.

Elipse SoftwareLeave a Comment on Settings for enabling network access to SQL Server.
This article illustrates the necessary settings to enable remote access to SQL Server Express 2005.

1. Go to Start–All Programs–Microsoft SQL Server 2005–SQL Management Studio Express and follow the instructions displayed in the figures below:

2. Then, go to Start–All Programs–Microsoft SQL Server 2005–Configuration Tools–SQL Server Configuration Manager and follow the instructions displayed in the figures below:

3. Set the machine’s IP address in the indicated field:

4. Then, go to Start–All Programs–Microsoft SQL Server 2005–Configuration Tools–SQL Server Surface Area Configuration and follow the instructions according to the figures below:

5. In E3Studio, set up your Database object:

6. Set up (or disable) the Windows Firewall and all other programs that may block the access to the machine.
Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Leave a Reply

Your email address will not be published.Required fields are marked *