RSS Feed
Knowledgebase : Database (ODBC/MySQL/MSSQL)
   


Below you can find in full detail the differences between the two MS SQL 2005 features. http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx
The standard edition of MS SQL 2005 requires a minimum of 2 GB of RAM (up to 4 GB), to be fully utilized. Please make sure that you order the right amount of RAM should you wish to have MS SQL 2005 Standard Edition on your Dedicated or VPS server.
The application called "Microsoft SQL Server Management Studio Express", which is a database management tool, needs to be setup on your Server. Step BY Step Installing and Configuring Microsoft SQL Server Management Studio Express 2005, 2008 or 2008R2 : ...
Yes, Microsoft® SQL Server™ 2005 was designed to support all local languages (other than English) that are supported by the Microsoft Windows Server® 2003 operating system, including the Arabic language,. Microsoft Windows uses code page 1256 for the Arab...
Please perform the following to setup your ODBC Connection. 1. Log in to your Control Panel . 2. Click on the System Tab. 3. Click ODBC Data Sources icon. 4. Choose Add new ODBC DSN 5. Choose a Connection Name 6. Select your D...
Login into your account, and follow the link to the "system" tab (on top menu). For Plesk 9 Users: The Databases section can be found in the "Applications & Services" Group. For Plesk 10 Users: The Databases section can be f...
This is because the server is attempting to execute an T-SQL query to retrieve a list of databases along with additional information about those databases. One of those pieces of information is collation, which you will not have permission to action for...
You should have MSSQL Server Management Studio installed on your Dedicated Server/VPS/XenVM. 1. Create the database, user id and password in your Plesk control panel . 2. At Enterprise Manger, in your local computer, right click on the "SQL s...
There is no need to create anything on the control panel . The only thing you have to do, is to upload your *.mdb files and use a DSN less or DSN based connection to access it.
To set file permissions you can go to "File manager" within your panel, and locate the file whose permissions you are trying to change. In front of the file, on the right side, click on the yellow lock icon, and check mark Write option for " Plesk IIS Us...
1. Download and install MySQL guide tools from https://dev.mysql.com/downloads/gui-tools/5.0.html [1] 2. Run MySQL administrator application from the installed MySQL gui tools. 3. Connect to your MySQL db created, using your domain.com or IP assigned to y...
Login into your Control Panel, and follow the link to the "system" tab (on top menu). For Plesk 9 Users: The Databases section can be found in the "Applications & Services" Group. For Plesk 10 Users: The Databases section can be found by clicking on ...
1) Log into your Control Panel 2) Choose the domain, or subscription in question 3) Click on the "Databases" icon a) For Plesk 9 Users: The Databases section can be found in the "Applications & Services" Group. b) For Plesk 10 Users: The Databases sect...
If you are using Mysql you would use your DBWeb Admin button in the control panel and for MSSQL you may need to download the SQL Management Studio Express. You can download the SQL Management Studio Express here: https://www.microsoft.com/downloads/de...
You need to use an absolute path to your DB (e.g. C:\Inetpub\vhosts\yourdomain.com\nameprivatexxx.mdb)
Unfortunately we do not provide Enterprise Level on MSSQL server features like periodic maintenance plans on a shared hosting plan. You can use backup feature inside the Plesk to a take a FULL backup of your service, which will include Web/Email/Databa...
Please follow with the instruction below to adjust the object explorer in the Management Studio: 1) Open the Object Explorer Details window by selecting View >> Object Explorer Details in menu (or hitting F7) 2) In Object Explorer window click...
The Next time that you want to delete a database please do it in Plesk , by following the instructions below: Under the "System" tab click on the "Databases" icon >> Click on the database in question and delete it.
ODBC is not a Linux technology and so it is not available on Linux packages, but MySql is supported,
The Next time that you want to delete a database please do it in Plesk , by following the instructions below: Under the "System" tab click on the "Databases" icon >> Click on the database in question and delete it
1) Login to your control panel 2) Select “Databases” 3) Select "Add new database" 4) Type the DB name you would like to be created on the server 5) Press OK 6) Next Set the database Username and password 7) Go to the "BackUp Mana...
1.Run SQL Server management studio, which can be downloaded as follows: Management studio For MSSQL 2005 http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en Management studio Fo...
You need to login into PHPmyadmin as mysql root user as follows: 1) Login into your plesk 2) Click on "Database Servers" >> "Local MySQL server" 3) Go to "Databases" tab >> Click on "Webadmin" button...
This issue usually happens when Plesk can not communicate to the SQL server using proper credentials or your SQL server in inaccessible. To make sure you are using the proper credentials you need need to put your SQL server sa password into: ...
Help Desk Software by Kayako Resolve