You have probably reached this page after receiving the following error message: Server ‘SERVERNAME’ is not configured for RPC. [SQLSTATE 42000] (Error 7411). This article will explain why you are receiving this error, and what can you do resolve it.
Archive for month: October, 2011
your SQL Server Collation choice for your database (or server) will control how characters will be sorted and compared within the database or SQL Server in general.
DBAs must choose a collation carefully that matches the type of characters encountered in a particular database. It is important to take into account as well how this database will interact with other database in the same instances, or through a linked SQL Server instances.