SQL Server: Enforce Password Policies and Password Expiration for Logins

Error: 18487, Severity: 14, State: 1
Login failed for user ‘loginname’. Reason: The password of the account has expired.
Condition : The password for the login used in your application has expired.  SQL Server 2005 introduced ‘Enforce password policy’ and  ’Enforce password expiration’ configurations which use the local policies for password length, complexity and expiration…!

Advertisements

Report Services instance could not be found

If you are getting this error message when trying to connect to Reporting Services from Management Studio.

“The Report Services Instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)”

Installing SQL Server 2008

Steps to Install SQL Server 2008
By Amit Vaid

Microsoft SQL Server 2008 Release to Manufacturing (RTM) was released in the August 2008. There are different versions of SQL Server 2008 available such as Enterprise, Standard, Workgroup, Web, Express, Compact and Developer editions.