Please enable JavaScript to view this site.

Navigation: Get Your Software: Installed > Network Install: Windows Authentication

Configure SQL Server for EventPro On-Prem Windows Authentication

Scroll Prev Top Next More

1.After restarting the computer, open the Start menu, and run SQL Server Configuration Manager.

2.The SQL Server Configuration Manager opens.

a.In the left-hand panel, go to SQL Server Network Configuration > Protocols for SQLEXPRESS (or whatever you named this SQL Server Instance earlier).

b.In the right-hand selection grid, you need to enable both TCP/IP and Named Pipes.

c.Right-click TCP/IP and select Enable.

Screenshot of SQL Server Configuration Manager Enable TCP/IP for EventPro Windows Authentication

d.The Warning dialog informs you that changes will not take effect until the service is restarted, which we will do next.

Screenshot of restart warning in SQL Server Configuration Manager for EventPro Windows Authentication

e.Click OK, and you will see that TCP/IP is now Enabled.

f.If necessary, repeat the process with Named Pipes. Right-click Named Pipes and select Enable. Click OK in the Warning dialog that follows.

g.Now, both TCP/IP and Named Pipes should be Enabled.  

If applicable, you may also want to check the Protocols under SQL Native Client Configuration and SQL Native Client Configuration (32bit) to ensure that TCP/IP and Named Pipes are Enabled there, as well.

Screenshot of SQL Server Configuration Manager Named Pipes Enabled for EventPro Windows Authentication

3.In the left-hand panel, go to SQL Server Configuration Manager (local) > SQL Server Services.

In the selection grid to the right, select SQL Server (SQLEXPRESS) and click the Restart button _17_SQLServerRestartIcon above. The service will stop and restart.

Screenshot of SQL Server Configuration Manager Restart Service for EventPro Windows Authentication

4.Check to ensure that the SQL Server Browser is Running. If it is not, you can try to start it by clicking the Start button above.

This may not work, however, as there could be other reasons that the SQL Server Browser is not running.  For example, you may need to go to the Services area to manually enable it there.

If you run into any issues here or any other part of SQL Server Configuration, please contact Support for assistance.

5.You can close the SQL Server Configuration Manager window.

6.Next, proceed to Download EventPro Components.

Copyright Profit Systems Inc. EventPro Software is a wholly owned subsidiary of Profit Systems Inc.