SQL Error Messages Archives - Page 99 of 114 - SQL Authority with Pinal Dave

SQL SERVER – FIX : ERROR : is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)

April 30, 2009

Just a day ago, one of my friend sent me email requesting help with following error: is not a valid Win32 application. (Exception from HRESULT: 0x800700C1) In fact this is not SQL Server error but it is of .NET application. The solution of this error is just changing configuration of…

SQL SERVER – FIX : Error: 18486 Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it. – Unlock SA Login

April 23, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server Security

Today, we will riffle through a very simple, yet common issue – How to unlock a locked “sa” login? It is quite a common practice that SQL Server is hosted on a separate server than application server. In most cases, SQL Server ports or IP are exposed to the web,…

SQL SERVER – Fix : SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing

April 19, 2009

Pinal Dave

SQL

SQL Error Messages, SQL Server

It goes without saying that computer running slow is a common problem we all face, a pestering one indeed! Last week, I had to format my computer as it was running at an annoyingly tortoise pace. After formatting it, I installed Visual Studio 2008. When tested Visual Studio 2008 worked all fine. However, when I attempted to install SQL Server 2008, I was confronted with an error about NET Framework 3.5 missing.

SQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)

April 12, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Utility

A couple of days back I had my computer formatted. I reinstalled it with Vista SP1 32bit. Subsequent to installing other indispensable software I tried to install SQL Server 2005 . However, it instantly displayed the following error message. The SQL Server System Configuration Checker cannot be executed due to…

SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible

April 10, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Backup and Restore, SQL Data Storage, SQL Error Messages

This article revolves around a trivial yet common issue. There might be a set of people for whom the current topic might appear to be insignificant. But I have been asked this question innumerable times, particularly from people who are frequenting using forums or have blog related to storage and…

SQL SERVER – Fix Error 9803. Invalid data for type “numeric” – Data Type Mapping

April 9, 2009

Pinal Dave

SQL

Oracle, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

My present article talks about an error that you will encounter when connecting to Oracle database using OPENQUERY. Let us learn about how to fix error 9803.

SQL SERVER – Maximum Columns per Primary Key – Fix : Error : Msg 1904, Level 16, The index on table has column names in index key list. The maximum limit for index or statistics key column list is 16

April 8, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Index, SQL Scripts

My present article covers two fundamental questions. 1) What is the maximum number of columns included in Primary Key Index/Constraint? 2) What is fix/solution for the following error: Msg 1904, Level 16, State 1, Line 1 The index ” on table ‘dbo.Table_2’ has 17 column names in index key list.…