Reporting Services Catalog Database File Existence Failed

While installing the Microsoft SQL server 2008 enterprise evaluation edition I got an error as

“Reporting Services Catalog Database File Existence Failed or Temporary Database File Existence failed” as follows

Tried to google around to see if I get any solution on this and found the reason behind the error , It was mainly because someone earlier  had installed SQL server on this machine and that was uninstalled couple of days ago which had left some of its footprints on the machine through the reporting services files under program files

C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLSERVER\MSSQL\DATA

This path showed some files created for reporting services, hence deleted those files (you need to have administrator privileges to delete them) and tried to Re-run the setup it went through with no errors as follows

Hence it worked for me the files deleted were found under C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLSERVER\MSSQL\DATA. Though I forgot to note down the filenames which i deleted , other blogs on the same issue tell you the name of the files also ; ReportServer.mdf,ReportServer_log.LDF,ReportServerTempDB.mdf,ReportServerTempDB_log.LDF etc . But yes it was indeed a learning experience.

Installing OpenFiler

Openfiler is an Open Source Network Attached Storage and Storage Area Network, Open filer supports volume based partitioning on native file systems, Supports quota-based resource allocation and helps allocating shares for various network file systems.

Below procedure helps Installing Open filer using graphical Installation method on virtual machine

To begin installation attach the openfiler iso file  to CD\DVD drive through virtual machine settings

Click on connect at power on and boot the virtual machine It displays

Hit Enter to go for graphical installation 

Select language and keyboard whichever you want and next comes disk partitioning, you can either select automatic partitioning or manual partition and create partitions.

In network configuration step you would configure machine ip address and other settings like hostname,gateway and dns etc.

Set the root password

Once you finish these steps click next and it starts the installation process

Once you get installation complete screen you can click on reboot to boo the machine and you will be presented with screen like this

To access the open filer through the web browser use following

Management Interface: https://<ip of openfiler host>:446

Administrator Username: openfiler

Administrator Password: password

Now you are ready to access your open filer through web browser like this

We will discuss using the Open Filer in coming blogs.

ADRMS Installation Facts

ADRMS (Active Directory Rights Management Server) 

Active directory rights management services is a form of service which helps in protecting  corporate information through policies applied over them selective operations could be authorized for selective users and the access could be streamlined .companies use this technology to protect their information which flows through emails, web services or shares .

Below is the general set up required to enforce this service

Set up key facts

1.       Login to Active directory and create domain users (if active directory already exists)

2.       Install Microsoft server 2008 R2 on a new machine, login as administrator and go to add roles and install active directory rights management role

3.       You need service account to specify while installing if this machine is not there on a domain then the service account has to be a member of enterprise admin group

4.       If you want to use internal database then you can select the same, if you want to use external database server then select the same.

5.       Database server which is selected here should have sql server browser services running and remote connections enabled.

6.       We need to select SSL security for server authentication

7.       You can select the certificates issued by your CA or self-signed certificates.

8.       Service connection point should be registered while installing ADRMS.

9.       After installation you can create ADRMS templates and path has to be specified on server.

10.   Change the registry settings at server as well as at client where this set up need to be tested.

my next blog would cover detailed steps of ADRMS installation with screenshots.

vCenter Single Sign On Password Issues

                    

If you are Unable to login to vSphere Web client and if it says password is incorrect or account locked then you can check the status of the account through various options

1.       You can use any other users  logged in session with administrators privileges

2.       Wait for 15 minutes

3.       You can reset the same through command prompt

Procedure: 

1.      Unlocking administrator’s account using another session which is open is as follows

• Click on Home
• Go to Administration
• Select SSO Users and Groups
• Choose the administrators account right click and click Unlock

2.      Wait for 15 minutes

You can wait for 15 minutes as because by default account lockout policy is set to unlock after 15 minutes this should work fine in most of the cases.

3. Resetting Administrators password through command prompt 

     If SSO server is installed on Windows server then you can reset the password through               command prompt also

• Login to SSO server as admin 
• Go to command prompt Start > Run, type cmd, and click OK
• Navigate to SSOInstallDirectory through default installation directory i.e.
• C:\Program Files\VMware\Infrastructure\SSOServer.
• Run the command :   rsautil reset-admin-password
• Provide the master password which was given during SSO installation it should accept even if it is changed
• Enter the name of the administrator account which needs password reset
•  Type the new password and confirm it again

·         This should fix the issue