Connecting to SQL Server using SSMS on Windows
Prerequisites
- SQL Server Management Studio (SSMS) installed - download from Microsoft
- Active connection to PJATK VPN or campus network
- Valid student account
SQL Server Management Studio Configuration
Launch SSMS
Open SQL Server Management Studio. The Connect to Server dialog will appear.
Enter Server Details
Fill in the basic connection information:
| Field | Value |
|---|---|
| Server type | Database Engine |
| Server name | db-mssql.pjwstk.edu.pl |
| Authentication | Windows Authentication |
Configure Options
- Click Options ».
- Go to the Connection Properties tab.
Important Security Settings Ensure these settings are correct to establish a connection:
- Trust server certificate: ✅ Checked
- Encrypt connection: ❌ Unchecked
Connect
Click Connect.
Note: The first connection may take a few seconds.
Troubleshooting
Authentication Issues
If you receive an authentication error:
- Check if you are connected to the PJATK VPN.
- Verify Windows Authentication is selected.
- Try running SSMS as Administrator.
Server Connection Error
If you cannot connect:
- Verify Trust server certificate is Checked.
- Verify Encrypt connection is Unchecked.
- Check server address:
db-mssql.pjwstk.edu.pl. - Ensure VPN connection is active.
Summary
You should now be able to connect to the PJATK SQL Server, access your database, and execute queries.