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 …

Continue reading 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 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. …

Continue reading 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 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 …

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

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 …

Continue reading Send login expiration notification alerts in sql server