MS SQL Server configuration manual for DBConvert
General FAQ Section
1.First of all enable TCP/IP protocol for MSSQL Express server the way displayed below:
2.After clicking right mouse button on TCP/IP protocol please specify the following settings shown in the picture:
3.Find MS SQL 2008 service in the list of SQL Server Configuration Manager and select MSSQLEXPRESS2008 service in the list of right window:
4.After right mouse clicking on the MSSQLEXPRESS2008 item pay attention to “Log on as” parameter. Desirably, it should be set into “Network Service” value. But it also can work with predefined account connection information as well.
5.Check connection with MS SQL server in DBConvert and enjoy!
-
Necessary permissions for MSSQL clients (machines) connections.
1.First of all open “Login Properties” window, choose “General” tab and set the parameters that are indicated at the picture bellow.
2.Then, in the same window, select ”User Mapping” tab and choose the database you need and it’s role membership.
3.Then open “Server Properties” window and choose “Permissions” tab. And the last thing you need to do is to set permissions for the user you indicated earlier. We recommend you to check “Connect SQL” and “View any database” checkboxes. Please see the picture below.
Please, check your MS SQL Express settings. Here is our local MSSQL Express configuration.
Make sure that TCP/IP enabled.
After all configuration actions, do not forget to restart MS SQL Express services.
Lets check connection. Here we use trusted connection.
For testing we require Database list.
It`s work. Let’s try to synchronize two databases.
Source:
Destination:
Customization:
Execution:
Be sure, that “DBSync for Access & MS SQL” support MS SQL Express 2005.
DBConvert Product Line
