Clients Area

SQL Server Management Studio Settings for SixBit Print

  • Installation, SSMS, SQL Server Management Studio, SIXBITDBSERVER, Remote Connections, Concurrent Connections, Server Properties
  • 12

If SixBit needs to connect to your database from more than one computer, SQL Server Management Studio (SSMS) is where you confirm the SIXBITDBSERVER instance is set to accept those remote connections. SSMS has been redesigned recently and now looks quite different from older versions, but the settings below are the same ones that have always needed to be checked.

Step 1 - Launch SQL Server Management Studio

SSMS now installs as its own standalone program rather than being nested under a SQL Server version folder. Search for SQL Server Management Studio from the Start menu to launch it.

Start menu search showing SQL Server Management Studio as a standalone app

Step 2 - Connect to SIXBITDBSERVER

In the Connect dialog, enter your server name (for example, SIXBITDBSERVER if you are on the same machine, or SERVERNAME\SIXBITDBSERVER from another computer) and choose the appropriate Authentication method, then click Connect.

SSMS Connect dialog

Step 3 - Open Properties for the instance

In Object Explorer, right-click the SIXBITDBSERVER instance and choose Properties.

Object Explorer right-click menu with Properties selected

Step 4 - Check the Connections settings

On the Connections page, confirm Maximum number of concurrent connections is set to 0 (unlimited), and check Allow remote connections to this server. Click OK to save.

Server Properties Connections page with concurrent connections set to unlimited and remote connections allowed


Was this answer helpful?

« Back

© 2024 SixBit Software. All rights reserved.