Reconfigure domain information in IIS for Plesk

One of our windows servers had some problems with domains getting disappeared from the IIS configuration. Before running the given commands try to run Plesk reconfigurator hopefully that should resolve most of the issues but it the problem still persists Plesk has included a command tool that can be used to resync domain information within the Plesk database, to the server’s IIS configuration. You can use the following command to resync doman information between the Plesk database and IIS for a specific domain (replace xyz.com with your domain name):

C:\Program Files\Parallels\Plesk\admin\bin\websrvmng.exe –reconfigure-vhost –vhost-name=xyz.com

After performing this command, the missing domain should have been readded to IIS. This tool can also be used to globally resync ALL domain configurations between the Plesk database and IIS. To do this, you will use the following command:

C:\Program Files\Parallels\Plesk\admin\bin\websrvmng.exe –reconfigure-all

Similarly you can also do the same method for FTP configuraton.

C:\Program Files\Parallels\Plesk\admin\bin\ftpmng.exe –reconfigure-all

Import and Export SSL certificate in IIS

Importing your Certificate/Private Key in IIS (from .pfx file format)

1.) Start > Run
2.) Type in MMC and click GO
3.) Go into the Console Tab (or File) > select Add/Remove Snap-in
4.) Click on Add > Double Click on Certificates and click on Add > OK
5.) Select Computer Account
6.) Select Local Computer
7.) Click the + to Expand the Certificates Consol Tree
8.) Right click on the Personal Certificates Store (folder)
9.) Choose > ALL TASKS > Import
10.) Follow the Certificate Import Wizard to import your Primary certificate from the .pfx file. When prompted, choose to
automatically place the certificates in the certificate stores based on the type of the certificate.
11.) Close the MMC console. In the case that you are prompted, it is not necessary to save the changes made to the MMC console.
12.) In your IIS manager, right-click on the site that you would like to use the certificate and select properties.
13.) Click on the Directory Security Tab and hit the Server Certificate Button. This will start the server certificate wizard.
14.) If you are asked what you want to do with the current certificate on the site, choose to remove it, finish the wizard, and click the server certificate button to run the wizard again.
15.) Choose to ‘Assign an existing certificate’ to the site and choose the new certificate that you just imported.
16.) Finish the certificate wizard.
17.) Restart the server.

Read the rest of this entry »

How do I change the name of SQL Server?

Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to perform the change.

1. Open SQL Server Management Studio and click New Query.

2. Type Select @@ServerName to verify that the server name is correct or incorrect. In this example, I changed the Windows 2003 from WIN2K3R2EE to SQL Server. I did not change the name in SQL Server 2005. It will still return the old name. Let’s fix it.

3. Next, type sp_dropserver ‘WIN2K3R2EE’

 4. You are now ready to add the correct name by typing sp_addserver ‘SQLSERVER’. local

  5. Restart sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver and net start msssqlserver. To stop and start the sql server agent, type net stop or start sqlserveragent.

6. Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.

Disable DrWeb notification e-mails in Plesk

To Disable DrWeb notification e-mails

“%plesk_dir%\mysql\bin\mysql” -uadmin -padmin_password -P8306 psa

First, make sure that record responsible for antivirus notification exists in table psa.misc. You can check it using this query…………

Read the rest of this entry »