Page History

...

1. Go to Service > Data Export > External Database Configurations reference, and copy pre-set «Microsoft SQL Server» setting. Assign a unique name to it .
2. In Basic > Connection String, press the button at the end of line.
   
3. Click «Build...» and configure connection to the database created in par. 1.
   
   !
   
4. Make sure "Data provider" tab has that the «Provider» tab has the Microsoft OLE DB Provider for SQL Server provider selected. In "Connection" the «Connection» tab, select the server from the list, enter the username and the password, select Databasethe d atabase, and press "Check connection"click «Check connection». If connection is verified successfully, press "ОК"click «ОК». Then, press "ОК" click «ОК» again.

If there is no required server is not on in the list, enter its name manually (it . It is usually the same as the name of the computer where SQL Server is installed (, an IP address may also be used as the name)). Then, it is mandatory to enter "username" and "password" prior to you should fill in the «User name» and «Password» fields before selecting the base!.
Server The server name is displayed on during SQL Server Management Studio launch (see figure below).:!

1. The "Connection string" will now look as follows: "Provider=SQLOLEDB.1;Password=1;Persist Security Info=True;User ID=sa;Initial Catalog=RK7;Data Source=127.0.0.1² "

...