Browsing articles tagged with " sql server"
Oct
30
2012

The prelogin packet used to open the connection is structurally invalid; Error: 17828

Found following error in SQL Server 2008 R2 error logs, Error: 17828, Severity: 20, State: 4. The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: <IP Address>] Although various blogs and articles says that this is timeout error and generally be seen if your SQL Server is evaluation copy which got expired, but I didn’t found any of such […]

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

Apr
17
2012

MSDTC and SQL Server 2005 Clustering

While searching for questions, Why MSDTC is required, in which it needs to be configured, is it must for SQL Clustering, etc. Please find below the analysis done by going through several forums and msdn articles,

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
8
2012

Replication failure: Unable to start a DCOM Server

Error: Unable to start a DCOM Server: {08B0B2D9-3FB3-11D3-A4DE-00C04F610189}. The error: “The system cannot find the path specified. ” Happened while starting this command: C:\PROGRA~1\MICROS~3\80\COM\snapshot.exe -Embedding

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.

Mar
22
2012

Event ID: 57860 Source: Backup Exec Type Error Description: SQL error number: “4818”. SQL error message: “Login failed for user ‘domain\userid service account’.

While check Windows errors logs, came across these errors, solution is already provided by Symantec; basically this error is recieved when any type of backup is run by Backup exec agent on a server having Microsoft SQL Server installed. Details of issue are as below, Solution provided by Symantec at following link: http://www.symantec.com/business/support/index?page=content&id=TECH29539 Problem Event ID: 57860 “An error occurred while attempting to log in to the following server…SQL error number: “4818”. SQL error message: […]

Mar
14
2012

Managing and Optimizing Tempdb in SQL Server

We often come across situations where there is contention in tempdb or tempdb is getting oversized, etc. better planning of tempdb may avoid performance issues if it is being used heavily and also reduce administration effort, below article is basically focussed on the planning stage of tempdb to reduce administration effort and avoid performance issues, Source: http://support.microsoft.com/kb/328551, http://www.sqllion.com/2009/05/optimizing-tempdb-in-sql-server-2005/ Tempdb is one of the system database in SQL Server, all user data is lost from tempdb […]

Mar
5
2012

SQL Azure – What is missing?

I was reading few articles around Microsoft’s cloud database SQL Azure and found an interesting article Five things in SQL Server not in SQL Azure Below are those five features, Data encryption Physical SQL Server used TDE for data encryption, if your application depends on TDE then you need to find a workaround or implement encryption logic within application, else need to wait for Microsoft to include TDE in Azure in future Full-text indexing and […]

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 25 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

October 2017
M T W T F S S
« Sep    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

View Post by Categories

%d bloggers like this: