Knowledgebase
20DNS 40Domains 59DotNetNuke 17Downloads 84eMail 14File Transfer Protocol 123Flash Tutorials 23General 11IIS 4Migrations 30MSSQL Server 9MySQL Server 111Parallels Plesk Panel 6Security and Hack 10SEO 23Server Settings 8SSL Certificates 1Video Tutorials 11Your Account
Knowledgebase: MSSQL Server
How can I connect to my Database using SQL Server Management Studio Express 2008?
Posted by , Last modified by on 13 February 2013 07:16 PM

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.

    • Server Port: Specify the port by appending the database name with a colon (or comma) and the port number e.g., mssql.your-domain.com,14330 . (replace your-domain.com with your actual domain name)

  • 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.
 

NOTE:
If your Domain's Name Servers are not set to DNN4Less Name Servers [mssql.your-domain.com,14330] will not work, in this case you can use your website's IP address [184.0.0.111,14330] 


(21 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).