Nov
8
2011

Error: 18456, Severity: 14, State: 58

Today while troubleshooting a SQL authentication issue, came across following error: Login failed for user ‘sa’. (Microsoft SQL Server, Error: 18456, Severity: 14, State: 58) When I use SQL Server Authentication to connect server. This was authentication issue, hence first checked the authentication mode and found that it is configured as Windows Authentication instead of Mixed mode (SQL + Windows) authentication Once I modified the authentication mode to mixed mode, it requested me to restart […]

Nov
7
2011

SQL Server 2012 Licensing Changes

The upcoming SQL server will get a major overhaul in terms of licencing, a very good article from Mr. Denny on same is as below, http://itknowledgeexchange.techtarget.com/sql-server/sql-server-2012-licensing-changes/ In short, SQL Server is reducing the number of editions from 6 down to 4 (I’m excluding all the different appliances here). Those editions will be Express, Standard, BI, and Enterprise Edition. The express edition will still be a free edition with limited functionality. BI is a new introduction […]

Nov
6
2011

/3GB /PAE and AWE on 32-bit Systems

I was reading the relationship between, /3GB, PAE and AWE and found several good articles pertaining to that, mostly from MSDN blog site where MS engineers share their brilliant knowledge. First of all I will start with how to determine PAE settings on your server if yours is a 32 bit system with more than 4GB of RAM, later I will share the article which tells exactly how settings should be done in order to […]

Nov
5
2011

SQL 2005 Maintenance plan multiple errors: System.MissingMethodException: Method not found: ‘Boolean Microsoft.SqlServer.

Today while fixing SQL 2005 SP2 (9.00.3042) maintenance plan issues, came across three errors, first error is due to dts dll not registered properly, whereas second one is occuring when trying to create/edit schedule or creating a maintenance plan thorugh Wizard mode. Read below to understand the issue and how it is fixed. 1. While trying to open maintenance plan, recieved following error, To fix this error, I have used the technique which I have […]

Nov
2
2011

How to insert a simple (Tick) Checkbox into office 2007?

Today I was struggling to insert a checkbox in Excel 2007, found a good tip as below, This can be done via Developer ribbon bar. If you do not see Developer as one of the tab options along the top (in the ribbon bar), do the following: 1. Click the Office logo in the top left corner 2. Down below besides Exit Excel you will find ‘Excel Options’, click it 3. In the ‘Popular’ window, […]

Oct
31
2011

SQL Server Upcoming version (code name ‘Denali’) announced: SQL Server 2012!

Since last few months SQL Server Denali (code name) is going under testing and recently during SQL Pass Summit 2011 Microsoft announced the name of upcoming SQL server as SQL Server 2012 (Source: http://www.sqlmag.com/article/sqlserverdenali/sql-server-2012-name-upcoming-sql-server-release-140882), it will be released in first half of next year and below are few significant features of SQL server 2012, Source: http://www.sqlmag.com/content1/tabid/461/catpath/sqlserverdenali/topic/sql-server-denali-new-features-140115 The next release of Microsoft SQL Server, code-named Denali, is right around the corner. Microsoft has just released Denali […]

Oct
28
2011

SQL Server 2005 Maintenance plan error: Unable to cast COM object

Today while configuring maintenance plan on one of SQLServer 2005 SP1, I recieved following error, “Unable to cast COM object of type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass’ to interface type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}’ failed due to the following error: Interface not registered (Exception from HRESULT: 0x80040155). (Microsoft.SqlServer.ManagedDTS)” Resolution was pretty straight, found at following fourm link Resolution: 1. Find the path where DTS.dll is […]

Oct
27
2011

SQL Server Compatibility List (SCL) for Veritas Cluster Server 5.1 Service Pack 2 (SP2) for Windows

I was trying to find out which version of SQL Servers are supported by Veritas Cluster Services in order to prepare an upgrade plan, I got a useful link from Symantec site, it was last updated on 07-Feb-2011. Link: http://www.symantec.com/business/support/index?page=content&id=TECH142798 SQL Server Compatibilty in short, Software Compatibility List (SCL)Veritas Cluster Server 5.1 Service Pack 2 for Windows Microsoft Microsoft SQL Server 2000 SP4 S x86 Microsoft Microsoft SQL Server 2000 SP4 C IA64, x64 Microsoft […]

Oct
27
2011

ACO5424E Could not connect to SQL server 2005

While connecting to SQL Server 2005 via tdp you may recieve following error: ACO5424E Could not connect to SQL server To fix it, go to following IBM technote, https://www-304.ibm.com/support/docview.wss?uid=swg21445251 Please find excerpt below, Problem(Abstract): There are several possible reasons why the ACO5424E error may be observed when using MS SQL Server 2005 Cause: The connection to the SQL server methodology changed with SQL Server 2005 and some administration is required to ensure remote connections are […]

Oct
26
2011

ACO5422E SMO error when connecting to SQL Server 2008 – tdpsql 5.5.1

While configuring TDP for SQL Server (v5.5.1) on a SQL Server 2008 R2, received following error: Error: While opening SQL Server using TDPSQL GUI (V5.5.1) ACO5422E Received the following from the MS SQL server:Could not load file or assembly ‘Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified. To Resolve the Issue found following IBM article, https://www-304.ibm.com/support/docview.wss?uid=swg21455220 One more user article available at: http://www.sqldbadiaries.com/2010/12/20/could-not-load-file-or-assembly-error-while-using-tdp-makes-a-come-back/ Problem is: Tivoli Data […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 263 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2020
M T W T F S S
« Nov    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: