- Go to Start -> All Programs -> Locate Microsoft SQL Server 2008 R2 , Click on SQL Server Management Studio.
- Enter followng details in Connect to Server Window:
- Server type: Database Engine
- Server name: VPS_IP_address, 1533
- Authentication: SQL Server Authentication
- Login: sa
- Password: #Password provided in login details#
- Click on Connect.
- You are now connected to MSSQL Server.
- How do I connect to MS SQL Server 2012 from SQL Server Management Studio?
- MS SQL Server knowledgebase