How to configure Microsoft SQL Server 2005/2008/2008 R2/2012/2014 Express?

There are 3 ways of connection to MS SQL. You can do it through :

1. TCP/IP
2. IPX/SPX
3. PIPE

Our DBConvert and DBSync software uses TCP/IP protocol for conversion process by default. You should open this protocol through SQL Configuration Tools.

Here is the list of our SQL Server migration software:

• DBConvert/DBSync for MSSQL & MySQL
• DBConvert/DBSync for MSSQL & PostgreSQL
• DBConvert/DBSync for FoxPro/DBF & MSSQL
• DBConvert/DBSync for Oracle & MSSQL
• DBConvert/DBSync for Access & MSSQL
• DBConvert/DBSync for MSSQL & DB2
• DBConvert/DBSync for SQLite & MSSQL
• DBConvert/DBSync for Firebird & MSSQL
• DBConvert for Excel & MSSQL

If you still unable to connect to the server check firewall settings or reconfigure your SQL server using one of the ways described above. Also make sure that password field is empty if you log in as super administrator.

All SQL Server 2005/2008/2008 R2/2012/2014 Express editions could be specified both as source and target database. Follow step-by-step instructions with screenshots:

Check your MS SQL Express settings. Here is our local SQL Express configuration

Make sure that TCP/IP enabled.

Finally restart SQL Express services and check connection to SQL Server.

"Refresh" button pulls down list of Databases.

Now let’s synchronize two databases. Choose Source Database:

Select Destination DB:

Customization step:

Execution step: