How to connect MySQL Server with MySQL Management Studio?

Connecting to the SQL Server via SQL Management Studio is possible. For example, your domain name is www.domain.com, All you need to do is: Login to Plesk https://www.domain.com:8443 Log in with your domain name, and the password Go to Database, Create a new database & Database user and password Please take note of the username

MSSQL (Microsoft SQLServer) ConnectionString in ASP/ASP.net:

SQL ODBC connection strings: Standard Security “Driver=; Server=Your_Server_Name; Database=Your_Database_Name; Uid=Your_Username; Pwd=Your_Password;” SQL OLE DB connection strings: “Provider=SQLOLEDB; Data Source=127.0.0.1; Initial Catalog=Your_Database_Name; UserId=Your_Username; Password=Your_Password;” SQL SqlConnection .NET strings: “Server=127.0.0.1; Database=Your_Database_Name; UserID=Your_Username; Password=Your_Password; Trusted_Connection=False” SQL SqlConnection for SQL 2008: “Provider=SQLNCLI10; Server=127.0.0.1; Database=database_name; UId=user_id; Pwd=password;”

How to create Databases in Plesk 12.5

You can create and remove databases in Websites & Domains > Databases. You can create a database by specifying its name. If your subscription grants you the corresponding permission, you can choose a database type and the database server on which the database should be created. You can select a website on which the database

How To Backup And Download MySQL Database In Plesk 9

It’s good to perform a backup of your MySQL databases frequently so that you have the latest version of database to restore if and ever your database crashes and requires restoration. Step 1 – Login to your Plesk control panel. Step 2 – Under “Application & Services”, click on “Databases”.   Step 3 – Select

Backup MSSQL database with MSSQLDump

1) Download MSSQLDump from http://www.parallels.com.cn/downloads/Prima/Tools/MsSqlDump.zip 2) Place the MSSQLDump file into C:\X 3) Go to command prompt and change the directory to C:\X 4) Run the command MSSQLDump -S localhost -U database_username -P database_password -D database_name -O database_backup.sql -createtable -insertdata

How to set permission for users in SSRS

Steps 1: Remote desktop into your server and go to the server manager. Go to the local users and groups tab and create the user that you want to allow in SSRS if the user is not existing yet. Steps 2: Open browser in your server and browse to http://localhost/reports. Log into the page using

How to Manage Database User Accounts in Plesk 12.5

When you work with a database in Plesk, Plesk accesses the database on behalf of a user account associated with the database. Therefore, every database should have at least one associated user account; otherwise, you will be unable to access it. Any database user can be set as default for a certain database. Plesk will

How to Add/Edit User in VestaCP

Step 1: First, click the USER tab on top, then click the green coloured “+” to add a new user.   Step 2: Fill in the details for the new user. Click “Add” when you’ve completed the info.   Step 3: This message will pop up if all the info are filled in correctly.   Now we