this is what i do to stop users from accessing sims on workstations but it will work on the server
- Click Start.
- All Programs.
- Microsoft SQL Server 2008/2012/2014
- Configuration Tools.
- SQL Server Configuration Manager.
- Expand the SQL Server Network Configuration option.
- Select the correct instance name (I.e. Protocols for SQL2008)
- Double click Named Pipes
- Change enabled to 'No'
- Click Apply and OK.
- Click OK to the message.
- Double click TCP/IP.
- Change enabled to 'No'
- Click Apply and OK.
- Click OK to the message.
The SQL Service will now need to be restarted. This can be done via the following:
- Click Start.
- Click Run and enter the following command 'services.msc'
- This will open the Microsoft Services Menu.
- Locate the SQL Server 2008/2012/2014 service.
- Select the Stop this service option.
- Once complete, select the Start this service option.
This will stop the Users from connecting to the Server outside of the actual box, please now run the specified application as required.
When complete, please do the following:
- Click Start.
- All Programs.
- Microsoft SQL Server 2008/2012/2014.
- Configuration Tools.
- SQL Server Configuration Manager.
- Expand the SQL Server Network Configuration option.
- Select the correct instance name (I.e. Protocols for SQL2008)
- Double click Named Pipes
- Change enabled to 'Yes'
- Click Apply and OK.
- Click OK to the message.
- Double click TCP/IP.
- Change enabled to 'Yes'
- Click Apply and OK.
- Click OK to the message.
The SQL Service will now need to be restarted. This can be done via the following:
- Click Start.
- Click Run and enter the following command 'services.msc'
- This will open the Microsoft Services Menu.
- Locate the SQL Server 2008/2012/2014 service.
- Select the Stop this service option.
- Once complete, select the Start this service option.