SQL Server Q&A

Symptoms
On a computer that is running Windows Vista, you install a default instance of Microsoft SQL Server 2005 Service Pack 2 or alater version of SQL Server 2005. On the same computer, you install a named instance of Microsoft SQL Server 2008. For example, you install an instance that is named “SQL2008.”
In this scenario, you may receive an error message that resembles the following when you start the SQL Server 2008 Reporting Services Configuration Manager:

No report servers were found. Details: Invalid namespace
Resolution
This problem occurs if the SQL Server 2008 Reporting Services Configuration Manager points to the SQL Server 2005 Reporting Services instance, and it cannot find the SQL Server 2008 instance.

Symptoms
When you modify the group membership of an account in the Windows operating system, the modifications are reflected in
the subsequent execution of the SQL Server IS_MEMBER function only when:
You log off, and then log back on to the Windows 2000 client computer.You open a new connection and connect to SQL Server on a computer that is running Microsoft Windows XP or later versions.
Resolution
The security cache on the Windows 2000 operating system is updated only when you log on to computer. However, the security cache on Windows XP or later versions is rebuilt automatically.