Welcome to MSDN Blogs Sign in | Join | Help

December 2008 - Posts

Friday, December 19, 2008 11:13 AM

Oracle and SQL Server Tools don't go well on an x64 SQL Server installation?

Consider this scenario: - You have made a SQL Server x64 installation. - You want to connect to Oracle from SQL Server Management Studio (SSMS) or Business Intelligence Development Studio (BIDS). - You get an error like this: ORA-12154:TNS:could not resolve
Posted by John Daskalakis | 0 Comments
Thursday, December 11, 2008 12:10 PM

How to overcome a SQL Server installation error

Consider this scenario. You are trying to create a new installation of SQL Server and it is failing. The first step in identifying what went wrong is to examine the setup logs of SQL Server. During installation there will be created some setup log files
Posted by John Daskalakis | 0 Comments
Tuesday, December 09, 2008 12:38 PM

MOM 2005 Onepoint size issues

Suppose that the Onepoint database has reached a huge size for any reason. Normally you would check that all grooming jobs and the DTS tasks are running as they are supposed to. But these operations need a lot of additional disk space to be performed.
Posted by John Daskalakis | 2 Comments
Tuesday, December 09, 2008 7:21 AM

Possible causes for errors reported in the cluster.log

Note: I will be adding any new explanations/causes I find for cluster log errors in this post. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error: ERR IP Address <orafssrvIP>: WorkerThread: GetClusterNotify failed with status 6.
Posted by John Daskalakis | 0 Comments
Tuesday, December 09, 2008 6:23 AM

MOM 2005 error - event id 9158

Recently we came across this error: Event ID : 9158 Source : Microsoft Operations Manager Type : Error Message : Failed to send SMTP message. The server rejected one or more recipient addresses. hr=-2147220977. We checked the email addresses and they
Posted by John Daskalakis | 0 Comments
Thursday, December 04, 2008 11:28 AM

How to change the collation of TEMPDB

How to change the collation of TEMPDB Consider this scenario: - During installation of SQL Server you defined a certain collation e.g. (A). - You then attached a user database with a different collation e.g. (B). - You then noticed that some queries were
Posted by John Daskalakis | 5 Comments
Thursday, December 04, 2008 10:40 AM

MODIFY FILE failed. Specified size is less than current size.

Consider this scenario: - You are installing SQL Server 2005 x64 on Windows 2003 x64. - Setup fails at some point with this error: "SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL
Posted by John Daskalakis | 0 Comments
Thursday, December 04, 2008 10:32 AM

Message Queuing objects cannot be created in Active Directory (Error: 0xc00e0025)

We recently stumbled upon this error while bringing online a newly created MSMQ resource, on a Windows 2003 cluster: "Message Queuing objects cannot be created in Active Directory (Error: 0xc00e0025)" This issue is usually resolved by making the cluster
Posted by John Daskalakis | 0 Comments
Thursday, December 04, 2008 10:08 AM

Error HRESULT E_FAIL has been returned from a call to a COM component

Consider this scenario: -You are setting up a SQL Server 2005 x64 failover instance on a Windows x64 cluster. - During the setup you get error: "Error HRESULT E_FAIL has been returned from a call to a COM component" (Screenshot is saved here: http://i139.photobucket.com/albums/q289/p3990013/BLOG/comerror.jpg
Posted by John Daskalakis | 0 Comments

Attachment(s): com error.jpg
Wednesday, December 03, 2008 11:57 AM

Common Auditor questions and answers about SQL server

So it is this time period of the year again, when Auditors knock on your door and examine your SQL Server Security to find loopholes. In this thread I will be gathering all the strange questions Auditors ask you and what is the truth behind them... Q.
Posted by John Daskalakis | 1 Comments
Wednesday, December 03, 2008 11:31 AM

Windows, SQL Server and the Antivirus don't go well?

Recently I was asked how to configure the Antivirus to not affect the SQL Server services. Well, most people think that the Antivirus keeps their servers safe, but if you haven't configured it appropriately it can do so much more, like crashing your SQL
Posted by John Daskalakis | 1 Comments
Wednesday, December 03, 2008 10:21 AM

Should I partition my SQL Server table and how? (SQL Server 2005)

At first, you need to identify if the table needs partitioning. In order to do that, you can run this query to see which tables of the database are the biggest and if there is e.g. a table that takes half the space of the database by itself: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Posted by John Daskalakis | 2 Comments
 
Page view tracker