cliconfg.exe on different platforms

I love when people set up alias for their SQL Server installation; and wondering why it is not working (Of course complaining to DBA’s that the SQL Server remote access is not enabled ). Well, remote access is just fine, alias as well… then what can be the problem? Let’s see in a real world scenario: Running an application on Windows Server 2008 R2 can be both 32 and 64 bit application. If the alias created using the 64 bit version of cliconfg.exe and the application is built for 32 bit, it w... [More]

SQL Server custom EventLog logger

I’m active on several forums (TechNet, MSDN, etc.) and found some interesting questions, I’d like to blog about. One of the topic is a custom event logging module for SQL Server. I can use a built in function to log any error to the Application Event Log with the following code snippet: RAISERROR ('Error sample', 16,1) WITH LOG;   Ok, this works if I want to use Application log. What can I do if I have to have my custom Event Log? If I have SQL Server 2005 or later, obvious answer ... [More]

Microsoft Project Server ECF custom view automatic refresh

I'm writing this article as ECF (Enterprise Custom Fields) handling inside the Microsoft Project Server database backend is not really documented, at least hard to find any information about it :) I needed to write custom audit and custom code for MSPS 2007 and 2010. Requirements were relying on ECF's and needed to use them in my custom code. I decided to build a view for my project entity with all custom fields. This view can be created in the ProjectServer_Reporting database. It was also a re... [More]

rsAccessDenied or SSRS prompts for credentials

There are two very interesting error messages I used to get in every implementation of SSRS: It prompts for credentials and/or get the following error message: User %s does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. I got the following error message:The permissions granted to user %s are insufficient for performing this operation. (rsAccessDenied).   The solution is prett... [More]

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' ... etc.

This is a very funny error message . I saw, you guys are looking for this, but it was published in Hungarian. Now I translate the article to English. You got this error message when you are trying to schedule an SSIS package. This occurs because of the different service packs for the SQL Server installation. You should run the service pack 2 setup (download from here: http://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en) and apply the ... [More]