SQL Server Enable Remote Connections

How to Enable Remote Connections in SQL Server

Download Contact Management Software     Reached the Final for a CRM Award in the Software Satisfaction Awards 2011 Reached the Final for a CRM Award in the Software Satisfaction Awards 2012

CRM Testimonials

SQL Server Enable Remote Connections

You can enable Remote Connections in SQL Server in SQL Server Management Studio.

Right click on the Server name and select Properties.

Select Connections.

SQL Server Enable Remote Connections

Enable TCP-IP Protocol on the Server

You will need to go into the SQL Server Configuration Manager and enable the TCP-IP protocol on the server.

SQL Server Remote Connections Enable TCP-IP

Configure the Windows Firewall to allow SQL Server Access

You will need to configure the Windows Firewall to allow SQL Server Access - see Configure Windows Firewall for SQL Server Access

Further Information

For information on installing Microsoft SQL Server Express, see Install SQL Server Express 2012

For information on configuring SQL Server Authentication so your users can access the database, see SQL Server Authentication

For detailed instructions on upgrading your Amphis Customer database to SQL Server Upgrade to SQL Server

IT Support Needed

Please note that setting up and maintaining Microsoft SQL Server is an advanced topic and we would suggest consulting an IT Professional to help you with this. The IT Professional needs to have a full understanding of Microsoft SQL Server including SQL Logins, SQL Users, networking and security, and SQL Server backups.