- 1). Open Microsoft SQL Server Management Studio.
- 2). Click on the "Connect" button.
- 3). Click on "Database Engine" in the pop-up menu.
- 4). Click on the "Server Name" combo box field and choose the SQL Server instance to connect to.
- 5). If your authentication type is "Windows Authentication" then you can click "Connect" now. If not, continue the next step.
- 6). Click on the "Authentication" combo box and choose "SQL Server Authentication."
- 7). Click in the "Login" text box and enter your login ID.
- 8). Click in the "Password" text box and enter your password.
- 9). Click on the "Connect" button.
SHARE