How to connect to MSSQL 2008 from SQL Management Studio


MSSQL can be defined as a relational database management system which has been developed by Microsoft. As it is a database server it can be called as a software product with its main function is of storing as well as retrieving the data being requested by other software applications. It can run on the same computer as well as on other computer across the network.

There are different editions MSSQL dedicated server which is aimed for different audiences as well as for the workloads which ranges from single machine application to large applications.

Here you will be guided on how to connect the MS SQL Server 2008 from the SQL Server Management studio in Windows Dedicated Server.

The login details can obtained from Client Area

Step 1: You need to go to the Start and then Click on All Programs.

Step 2: After clicking the all programs you need to locate the Microsoft SQL Server 2008 R2 and then you need to click on SQL Server Management Studio.

Step 3: Now you need to enter the following details for connecting to Windows Dedicated Server:

  • Server Type i.e. the database engine
  • Server Name i.e. the dedicated server
  • Authentication i.e. SQL Server Authentication
  • Then you are required to add the Login Id
  • And then lastly the password provided in the login details

Step 4: Now you need to click on connect

Now you will be connected to the MSSQL dedicated server.

Choose our Windows Dedicated Server solutions for you business. Contact us today and get the best 24*7 Guaranteed Support.