Hello,
Follow the below mentioend steps to configure MS SQL database in Microsoft enterprise manager:
1) Open the "Client Network Utility".
2) Click on "General" Tab.
3) Select TCP/IP from the "Enabled protocols by order" List.
4) Click "Properties" button.
5) No change with the "Default Port"
6) Click OK.
7) Click "Apply" button.
8) Click on "Alias" tab.
9) Click on "Add" button.
10) Enter any suitable name in "Server alias" box.
11) Select option "TCP/IP"
12) In the Server name field enter your MS SQL server IP address
13) If option "Dynamically determine port" is checked then uncheck it.
14) In "Port number" field enter value 1433
15) Click OK.
16) Click "Apply" button.
17) Click OK.
Linear Mode
