By default, SixBit will set the proper SQL Server Configuration Manager settings during installation, but if you had an existing installation or if you are having trouble connecting to your database either locally or remotely, you should double-check your settings.
Opening Configuration Manager
On Windows 10 or 11, SQL Server Configuration Manager is not in the Start menu. Press Windows key + R, type SQLServerManager16.msc (the number matches your SQL Server version - 16 for SQL Server 2022), and press Enter.
Services Configuration
Select SQL Server Services and verify these two services show a Running status:
- SQL Server Browser
- SQL Server (SIXBITDBSERVER)
The state of SQL Server Agent (SIXBITDBSERVER) is not important.
If either service is not running, open its Properties and set Start Mode to Automatic, then start it manually if needed.
Protocol Settings
For databases only accessed over your LAN, both Named Pipes and TCP/IP should be enabled.
For databases accessed over the internet, Named Pipes should remain disabled while TCP/IP must be enabled.
After making any changes, restart the running SQL Server services for the changes to take effect.
