Wanpulse's proVconnect - Wiki

Inventory, monitor and manage your devices !

User Tools

Site Tools


requirements:sqlserver

Microsoft SQL Server

You can download a free Microsoft SQL Server version or evaluation from this page.

Once the proVconnect Management Server is installed, the configuration of the SQL Server must not be updated, because lots of settings are encrypted and stored for making upgrade easier.

Log in to the SQL Server using Windows Authentication mode

Launch the Microsoft SQL Server Management Studio with the Administrator account.

Use the Windows Authentication for logging in to the database server.

Set the SQL Server authentication mode

Log in to the SQL Server using Windows Authentication mode.

Right-click on your instance of SQL Server.

Click on Properties.
In the Server Properties dialog, open the Security menu.

Set the Server authentication to SQL Server and Windows Authentication mode.

Validate by clicking on the button OK.
A dialog box indicating you must restart SQL Server might be prompted to you.

Close it by clicking on the button OK.

Restart the SQL Server

Log in to the SQL Server using Windows Authentication mode.

Right-click on your instance of SQL Server.

Click on Restart.
A dialog box asking you a confirmation for restarting SQL Server is prompted to you.

Close it by clicking on the button Yes to accept the restart of the SQL Server.
Wait during the restart of the SQL Server is processing.

Allow the remote connections to SQL Server

Log in to the SQL Server using Windows Authentication mode.

Right-click on your instance of SQL Server.

Click on Properties.
In the Server Properties dialog, open the Connections menu.

Check the Allow remote connections to this server checkbox in the Remote server connections section.

Validate by clicking on the button OK.

Set up the SA password

Log in to the SQL Server using Windows Authentication mode.

Go to Security > Logins from your instance of SQL Server.
Right-click on the sa login.

Click on Properties.
In the Login Properties dialog, open the General menu.

Set a secured password.

Validate by clicking on the button OK.

Prevent the login of the SA user

Log in to the SQL Server using Windows Authentication mode.

Go to Security > Logins from your instance of SQL Server.
Right-click on the sa login.

Click on Properties.
In the Login Properties dialog, open the Status menu.

Set the Login setting to Disabled.

Validate by clicking on the button OK.

Enable the TCP/IP Protocol

Launch the Sql Server Configuration Manager.

Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.

Where SQLEXPRESS is the name of your instance of your SQL Server.
Right-click on the TCP/IP protocol name in the right panel.

Click on the Enable item.
A dialog box indicating you must restart SQL Server is prompted to you.

Close it by clicking on the button OK.

Restart the SQL Server for finishing to enable the TCP/IP Protocol.

Change the TCP port

Launch the Sql Server Configuration Manager.

Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.

Where SQLEXPRESS is the name of your instance of your SQL Server.
Right-click on the TCP/IP protocol name in the right panel.

Click on the Properties item.
Go to the IP Addresses tab.

In the IPAll section, set the TCP Port to the desired port.

For your information, the default SQL Server port is 1433.
A dialog box indicating you must restart SQL Server is prompted to you.

Close it by clicking on the button OK.

Restart the SQL Server for finishing to change the TCP port.
Last modified: 2018/01/03 14:28 by wpwiki

Page Tools