Skip to Content

Setting up SQL Server media on the Manager

Microsoft SQL Server media resides on the Manager and should be prepared by using the BMC Database Automation Media Preparation Tool (mediaprep). Mediaprep can be used to prepare SQL Server 2008, 2005, and 2000 media, as well as SQL Server 2000 SP4 media. SQL Server patches downloaded from Microsoft as .zip or .exe files need not be prepared with mediaprep (see Managing SQL Server patch packages). After the media has been prepared, it can be uploaded to the Manager by using mediaprep or stored locally so it can be copied manually.

Warning

Note

If your media resides on a network share, you need to map the share to a drive letter and specify the drive letter and location by using the mediaprep tool. Mediaprep does not accept network locations as a path to SQL Server media.

To use mediaprep to place the SQL Server media on the Manager, do the following:

Warning

Note

If you are using mediaprep to prepare SQL Server 2000 SP4, it must be uploaded manually to the Manager by using the patch repository after these steps. If your installation media consists of multiple disks, you must run mediaprep (SQL Server Media Uploader Tool) for each disk and then upload all of the files generated.

  1. From the command prompt, run mediaprep.exe.
  2. When prompted to prepare Microsoft SQL server media?, type y.
  3. When prompted to prepare Oracle media, type n.
  4. When prompted for the path to your SQL Server media, enter the path (such as the CD-ROM drive) and press Enter.
    The tool searches the media for versions of SQL Server and reports what it found.
  5. To prepare the media for uploading to the Manager, press Enter.
  6. When prompted to copy files up to the Manager, type y and press Enter.
  7. When prompted for the host name or IP address of the Manager, type the IP address and press Enter.
  8. When prompted to use SSL version 1, type y and press Enter.
    If n is entered, SSL version 2 is used. (Version 1 is faster but less secure than version 2).
  9. When prompted to enter the root password of the Manager, type the password and press Enter.
Warning

Note

If you do not have the root password of the Manager, mediaprep enables you to save the prepared media files locally on your workstation, so that someone with root access can copy the files to /app/clarity/var/media.

 

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Database Automation 8.2