CREATING A MICROSOFT SQL SERVER ACCOUNT Before you can use SQL Server Management Studio, you must first create a SQL Server account in Plesk. To do this, follow these steps: Log in to Plesk. In the le...
To install a new ODBC driver, creating a connection to an external database: Go to Server > ODBC Data Sources. Click Add New ODBC DSN. Specify the ODBC connection name and description in the corresp...
Getting Started:- 1. Create an MS SQL 2014 database and database user using Plesk under the domain that needs the DB. Click on the databases in the toolbar then select to Add Database Then put all ...
The following article explains how to configure SQL Express Server to allow remote connections. Remote connections allow users to access their SQL database without needing direct access to the Windows...
This is a sample connection string which you can use with MS SQL 2005 / 2008 under ASP: <% dim conn dim rs strConn = Driver={SQL Server};Server=YYYY;Database=XXXX;uid=XXXX;pwd=XXXX Set cnt = Server.Cr...
We do include support for MS SQL Reporting Services. For more information please check the following tutorials: http://msdn.microsoft.com/en-us/library/ms170246.aspx...
If you receive Microsoft SQL Server, Error: 916, when you connect with Microsoft SQL Studio: The server principal XXXXX is not able to access the database XXX under the current security context. (Micr...
If the database already exists and you only need to restore its content: If you do not have the backup file on your server, you can upload the backup file to the server repository from your local mach...
The remote MS SQL is activated by default. You need to create a database, and database user and password through your Plesk panel. 1. Create an MS SQL 2005 database and database user using Plesk under...
We allow remote management/connections for our MS SQL database (Business and Mocha plans only) for applications such as SQL query analyzer, SQL Management Studio, MS SQL Enterprise Manager, etc. Pleas...