SQL Setup for Database Server

SQL Setup for Database Server

Top Previous Next

SQL Setup for Database Server : You have to perform the following steps to setup SQL Databases in LOGIC. These steps have to be performed once only on the SQL Database Server.

Note : LOGIC supports only SQL Server Authentication mode to connect to SQL Server.

1.

Click on the Path Of Data button in Login Details window.

2.

Change Path Of Data window appears select the Backend Database as MS SQL Server from the list.

LogicInstallation_14

Figure 1

3.

Click the MS SQL Setup.. button > Logic SQL Setup dialog box appears .

LogicInstallation_15

Figure 2

4.

Click Connect To SQL Server button .

5.

Connect.. window appears,enter the Server name,User name and Password.

LogicInstallation_20

6.

Click Connect button or press Alt+C.

7.

Now specify the path of LOGICDB.MDF by clicking browse button as shown in figure 2.

8.

This file exists in <Path of LOGIC Installation>\SQLDB. e.g C:\LOGIC\SQLDB.

9.

Select the file from the SQLDB folder as shown in the figure and click open button.

LogicInstallation_21

10.

Click on Create button or press Alt+R .

11.

Click Update button or press Alt+U to update the changes on Login Details window.

12.

Connect To SQL Server button appears in Login Details Window.

LogicInstallation_SQLServer

Back

Copyright 2011, LOGIC ERP Solutions Pvt. Ltd.