Browsing articles in "Sql Server 2008"
Oct
25
2012

Microsoft SQL Server Build chart and links – all versions from 7.0 to 2012

If you are a DBA and you need to track the current release of SQL Server build then this link will come handy, use it at your wish as it’s not official page but a blog community page, http://sqlserverbuilds.blogspot.ca/ Excerpt as of writing this article, Quick summary:   RTM (Gold, no SP) SP1 SP2 SP3 SP4 SQL Server 2012codename Denali 11.00.2100.60 CTP       SQL Server 2008 R2codename Kilimanjaro 10.50.1600.1 10.50.2500 10.50.4000     […]

Jul
3
2012

SSIS package 2k5-> 2k8 R2 upgrade failed with error – Failed to decrypt protected XML node “DTS:Property”…

Scenario is when you are trying to open or upgrade SSIS package created in SQL 2005 to SQL 2008 R2 then you may encounter below error and your package upgrade will fail, please find few tips on resolving this error below.   Error Description: Failed to decrypt protected XML node “DTS:Property” with error 0x8009000B “Key not valid for use in specified state.”. You may not be authorized to access this information. This error occurs when […]

Jun
29
2012

Changing SQL Server Collation / Rebuilding system databases

You may find yourself in situation where you need to change Server level collation or need to rebuild system databases, then following article will be helpful, 1. First detach all user databases 2. Script any logins (if exists) using sp_help_revlogin (get one from MSDN for e.g. http://support.microsoft.com/kb/246133 , http://support.microsoft.com/kb/918992 3. Script Maintenance plans/Jobs (if can’t be created again) 4. Execute following on command line by going to the folder where appropriate setup of SQL Server […]

Jun
7
2012

SQL 2005/2008/R2 N/W connection error troubleshooting steps

You may see 1001 n/w connection error when trying to connect remote sql server from ssms, I have compiled some best troubleshooting steps I am aware and few collected from various references,   First try to use one of five ways to connect SQL Server using SSMS, (for e.g. let’s say server name is ngmssql and instance name is sql001 and domain is ad.in.com and port is 1433 and ip address is 10.26.27.28)   • […]

Apr
8
2012

SQL Server 2008 and R2 Cluster Best Practices

http://blogs.msdn.com/b/pamitt/archive/2010/11/06/sql-server-clustering-best-practices.aspx Read about this in above article, few highlights to remember,

Apr
3
2012

Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider

When you try to connect to SQL Server OLAP services hosted on a server from your desktop or client machine then it will require appropriate drivers to connect to SQL Server Analysis services.

Dec
15
2011

How do I check SQL replication status via T-SQL?

While searching for t-sql script which can check replication agent status came across a good script which works well for all versions of SQL Server i.e. 2000/2005/2008/2008R2 and above…

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

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

Pages:«123»

Subscribe to this blog via Email

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

Join 254 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

August 2020
M T W T F S S
« Nov    
 12
3456789
10111213141516
17181920212223
24252627282930
31  

View Post by Categories

%d bloggers like this: