Browsing articles from "November, 2011"
Nov
30
2011

T-SQL Script to check SQL Server up time and SQL agent status

While searching for a script which can help in checking SQL server up time and SQL server agent status, came across following good article by Vidhya Sagar…

Nov
18
2011

Installing tdp v5.5.1 on SQL Server 2000

Today after installing TDP for SQL server v5.5.1 on one server, we found TDP GUI is not opening up, also there are no clear instructions for SQL server 2000, after initial troubleshooting we figured out additional configuring that needs to be done for configuring TDP on SQL server 2000, Analysis: After installing TDP, TDP GUI will not open and if you execute batch script for backups then you will receive following error, It reflects that […]

Nov
16
2011

Issues with SQL Server Login Failures having dependency on Windows Password Policy Check!

Today users reported unique accessibility issues where all SQL logins are found locked out in all SQL servers (2005, 2008) where Windows enforce password policy is enabled, on further investigation it was found for each SQL login there are more than 20 failed attempts in SQL server error log. It took lot of effort in finding a root cause as on first attept it looked like a SQl server virus injection, but later found that […]

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, […]

Subscribe to this blog via Email

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

Join 35 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

November 2011
M T W T F S S
« Oct   Dec »
 123456
78910111213
14151617181920
21222324252627
282930  

View Post by Categories

%d bloggers like this: