Space2host Knowledgebase
Search:     Advanced search
Browse by category:
Knowledgebase / Plesk Web Control Panel - Windows / Connecting to SQL Server with the Management Studio

Connecting to SQL Server with the Management Studio
Print
Email to friend
Views: 804
Votes: 0
Posted: 09 Feb, 2008
by: Admin A.
Updated: 23 May, 2009
by: Admin A.

SQL Server  Management studio is a graphical tool that allows for easy, enterprise-wide configuration and management of your SQL Server database and database objects. Administrators running the Management studio, can:

  • Manage database objects
  • Back up databases and transaction logs
  • Manage tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types

Notes: SQL Server Management studio ships with SQL Server 2005. In order to use the Management studio, you must have your own copy running on your local workstation. does not provide customers with a copy of the Management studio.

Although Management studio can perform nearly every tasks associated with database server management, customer accounts on our shared servers do have some limitations. Generally, a customer account can perform all functions associated with their particular database on the server.

 

Once the connection is made, you can choose your database from the list of databases shown on the server and begin managing your data store. Note that your database is the only one for which you are granted permissions.

 
NOTE
 
We do not support Crystal Reports or SQL Server Reporting Services
 
Reason:

Crystal Reports: ASP.NET Framework includes a small number of shared concurrent licenses for Crystal Reports, however if we enable them the following things can happen:

-The webserver can be heavily taxed by a few Crystal Reports users, and slow down hosting performance for all the other customers on the same server.

-The Crystal Reports user has to wait until another user has ended their session because all the licenses .NET are in use.

SQL Server Reporting Services: This cannot securely be run on a shared SQL Server. Your data is potentially accessible by other reporting services users and websites/reports connecting to it.
Others in this Category
document Creating Autoresponder for your email id
document How can i create Virtual directory
document Creating Backup
document Creating Database
document Create Mail Forwarding (or) Redirection for an email account
document How can i configure my email Account in Outlook Express
document Creating mail alias for your mail account
document How to give write permission for a folder using Plesk control panel
document How can i Create Cron???
document Creating custom buttons
document Creating domain alias
document Managing Your Dns Zone
document Using File manager
document Refer the link for Frontpage Admin
document Managing Database using PHPmyadmin
document How can i create a new email id in my domain ?
document Changing your domain password
document Creating Subdomains
document Creating webusers
document Monitoring site resources and statistics
document Creating mailing list
document Customer Control Panel Guide
document Cdosys Component - Mail Code
document Mailenable Component - Mail Code
document code for Conecting to Mysql database
document Code for Conecting to MS-Sql database
document Code for Conecting to MS-Access database
document Shrinking MS-SQL database Logs
document where can i upload my java files ?
document Reseller Guides
document How can i change my ftp password
document How can i change my email id password
document How can i change my client password
document Enable parent path
document Sample code for php to my sql connection
document upload files using a ftp sotware filezilla
document I cannot able to open the control panel why ?
document Php mail component


Powered by KnowledgebasePublisher (Knowledgebase software)