Connecting to SQL Server using SSMS on Windows

Prerequisites

• SQL Server Management Studio (SSMS) installed - the latest version available on Microsoft’s website
• Active connection to the PJATK network or configured PJATK VPN
• Valid student account with database permissions

SQL Server Management Studio Configuration

Adding a New Connection

1. Launch SQL Server Management Studio (SSMS)

2. The Connect to Server dialog box will appear. Enter the following information:

   Field	Value	Description
   Server type	Database Engine	Type of server we are connecting to
   Server name	db-mssql.pjwstk.edu.pl	PJATK database server address
   Authentication	Windows Authentication	We use Windows authentication

3. Click the Options » button to expand additional configuration options

4. Go to the Connection Properties tab and configure the following settings:

   Field	Value	Description
   Connect to database	<default>	Keep the default setting
   Network protocol	TCP/IP	Recommended communication protocol
   Trust server certificate	✅ Checked	Required for proper connection
   Encrypt connection	❌ Unchecked	Required for proper connection

5. Click the Connect button to establish a connection to the database

   Note: The first connection may take a few seconds - please be patient

Troubleshooting

Authentication Issues

If you receive an authentication error:

1. Check if you are properly connected to the PJATK network or VPN
2. Make sure you are using the Windows Authentication option
3. Try running SSMS as administrator (right-click → Run as administrator)

Server Connection Error

If you cannot connect to the server:

1. Check the Trust server certificate setting (must be checked)
2. Check the Encrypt connection setting (must be unchecked)
3. Verify that the server address is correctly entered: db-mssql.pjwstk.edu.pl
4. Make sure your connection to the PJATK network or VPN is active

Summary

After completing the steps above, you should be able to:

• Connect to the PJATK SQL Server using Windows Authentication
• Access your student database
• Create and execute SQL queries
• Browse the database structure (tables, views, procedures)