The report server can not open a connection to the report server database while opening reports in sql server database

Below is the error which I faced at one of my client while opening SQL server reports. Error: While opening reports from browser,faced the below error. Issue Reported: The report server can not open a connection to the report server database.While opening reports from url. Analysis: The report server database or user database which was used for report server that was not present on sql server due to database … Continue reading The report server can not open a connection to the report server database while opening reports in sql server database

User Domain\User Account does not have required permissions error while migrating reports from one server to another server

Below is the error which I faced at one of my client while migrating SQL server reports from one server to another server. Error: While migrating SQL server reports from one server to another server faced the below user permission error. Issue Reported: While Migrating reports from one sql server to another server the Domain\user permission error thrown. Analysis: The old SQL server had twelve reports which needed to … Continue reading User Domain\User Account does not have required permissions error while migrating reports from one server to another server

COM+ error while installing sql server 2005 64-bits during migration from sql server 2005 32-bits on the same machine

Below is the error which I faced at one of my client while installing sql server 2005 64-bits during migration from sql server 2005 32-bits on the same machine. Error: COM+ error while installing SQL Server 2005 64-bits during migration from SQL Server 2005 32-bits on the same machine. Issue Reported: While installing sql server 64-bits during migration from sql server 32-bits on same machine,throws the … Continue reading COM+ error while installing sql server 2005 64-bits during migration from sql server 2005 32-bits on the same machine

Send login expiration notification alerts in sql server

Note:  Best viewed in Internet Explorer 6 and above Implementation: How to send login expiration notification alerts in SQL Server. Scenario: SQL Server login policies are same as the windows login policies.Its inherit the property from windows login/password policies. Now our target is to send mail notification before SQL Server login password get expired on production environment to avoid down time. Infrastructure: Below queries and processes are … Continue reading Send login expiration notification alerts in sql server