Knowledgebase
(28)Applications (16)DNS (23)Domains (9)Downloads (61)eMail (5)File Transfer Protocol (144)Flash Tutorials (18)General (11)IIS (4)Migrations (30)MSSQL Server (10)MySQL Server (74)Plesk Panel (2)Security and Hack (9)SEO (3)Server Settings (10)Services (3)SSL Certificates (9)Your Account
SEARCH
Knowledgebase
How can I connect to my Database using SQL Server Management Studio Express 2008?
Posted by on 02 October 2012 12:53 PM

MS SQL 2008 is the latest version of Microsoft's SQL database. It has many benefits and features that are not available on earlier versions of MS SQL.

Once you have installed SQL Server Management Studio Express 2008 you can use this tool to connect to, and administer, your MS SQL database.

Before you connect to your database you will need the following details.

  • Database IP address

  • Database username

  • Database password.

 
 

Step 1
Open SQL Server Management Studio Express 2008. The Connect to Server box will appear. Enter the following:

  • Server type: Select Database Engine from the drop down menu.

  • Server name: Enter the IP address of your database. This information is shown within your DNN4Less control panel.

  • Authentication: Select SQL Server Authentication from the drop down menu.

  • Login: Enter your database username. This is the username you chose when you created your database.

  • Password: Enter your database password. This is the password you chose when you created your database.
 
 

Step 2
Click Connect to connect to the database server. A list of all databases on the server will be displayed in the left hand window.

While you will see other databases listed, you will only have permissions to view and administer your own database. Expand the menus to navigate to your database from the list.
 
(3 vote(s))
Helpful
Not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).