Friday, May 21, 2010

Dedicated Administrator Connection - SQL 2005

When you try to connect to a SQL server instance using the Dedicated Administrator Connection(DAC), from SSMS - the following error will occur : "Dedicated administrator connections are not supported(Object explorer).

The thing is, dedicated administrator connection only works when there are no concurrent active connections. So, you gotta connect by clicking on "New Query" button - and then connect with

ADMIN:SERVERNAME


From SQLCMD:

sqlcmd -E -S servername -A


When a server level trigger prevents new connections to SQL server, then you might want to connect using the DAC and troubleshoot.

By default, only local dedicated admin connections are enabled - if you want to enable remote DAC, use Surface Area Configuration too.

exec sp_configure 'remote admin connections', 1
reconfigure

Wednesday, May 19, 2010

Install IIS on windows 7

I don't understand why Microsoft makes it extremely difficult to install something as trivial as IIS on one's machine. Installing IIS on XP if u don't have XP setup cd is a nightmare. There are a few workarounds though.

If you are trying to install IIS on your windows 7 machine, here is an easy way. Worked for me, let me know if it works for you!


Type the following command into a script:

start /w pkgmgr /iu:IIS-WebServerRole;IIS-WebServer;IIS-CommonHttpFeatures;IIS-StaticContent;IIS-DefaultDocument;IIS-DirectoryBrowsing;IIS-HttpErrors;IIS-HttpRedirect;IIS-ApplicationDevelopment;IIS-ASPNET;IIS-NetFxExtensibility;IIS-ASP;IIS-CGI;IIS-ISAPIExtensions;IIS-ISAPIFilter;IIS-ServerSideIncludes;IIS-HealthAndDiagnostics;IIS-HttpLogging;IIS-LoggingLibraries;IIS-RequestMonitor;IIS-HttpTracing;IIS-CustomLogging;IIS-ODBCLogging;IIS-Security;IIS-BasicAuthentication;IIS-WindowsAuthentication;IIS-DigestAuthentication;IIS-ClientCertificateMappingAuthentication;IIS-IISCertificateMappingAuthentication;IIS-URLAuthorization;IIS-RequestFiltering;IIS-IPSecurity;IIS-Performance;IIS-HttpCompressionStatic;IIS-HttpCompressionDynamic;IIS-WebServerManagementTools;IIS-ManagementConsole;IIS-ManagementScriptingTools;IIS-ManagementService;IIS-IIS6ManagementCompatibility;IIS-Metabase;IIS-WMICompatibility;IIS-LegacyScripts;IIS-LegacySnapIn;IIS-FTPPublishingService;IIS-FTPServer;IIS-FTPManagement;WAS-WindowsActivationService;WAS-ProcessModel;WAS-NetFxEnvironment;WAS-ConfigurationAPI
And boom!

Source: here

Friday, May 7, 2010

Bitnami Stacks

Want to play around with django without going through the hassle of installation configuration etc., Bitnami django stack lets you perform a super fast django install, your test environment will be up and running in a matter of minutes



Also checkout other stacks too. Wordpress, Drupal, SugarCRM, Alfresco to name a few..