Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







After Install, &&"Running Sqlcmd -S ServerInstance&&" Fails


I'm trying to figure out how to set up SQL Express so I can start learning SQL. I've installed SQL Express, but when I type "sqlcmd -S ServerSQLExpress," I receive the following error:Microsoft Windows XP [Version 5.1.2600](C) Copyright 1985-2001 Microsoft Corp.C:Documents and SettingsUsername>sqlcmd -S ServerSQLExpressHResult 0xFFFFFFFF, Level 16, State 1SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does notallow remote connections..Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Sqlcmd –S .\%INSTANCENAME%... Fails After Install
I'm new to sql, so go easy ;)

I'm attempting to install sql for a BCM 2007 installation, and I'm using this document: http://www.microsoft.com/downloads/details.aspx?familyid=f24267ee-9ad5-4be5-b888-c9a50ae395ca&displaylang=en

Now, I'm trying to do this on Windows 2003 Standard server, which may be the problem, but perhaps not? Anyway, the command I'm attempting to run is:
sqlcmd S .\%INSTANCENAME% E Q exec sp_grantlogin [%DOMAIN%\%USER%]; grant create database to [%DOMAIN%\%USER%]?

which is basic enough (and I did replace the %%'s with the correct info) but I'm getting this error back:

Sqlcmd: '-S': Unknown Option. Enter '-?' for help.

Any ideas???

edit: I did just notice this from the sql express readme, so I may try reinstalling... advice would still be appreciated!



3.10 Installing SQL Server Express on a Windows Domain Controller
Security Note:
We recommend against running SQL Server Express on a domain controller.
It is possible to install SQL Server Express on a Windows domain controller; however, it cannot run on a Windows Server 2003 domain controller as Local Service or Network Service. SQL Server service accounts should run as Windows domain user accounts. It is also possible to install SQL Server service accounts to run as Local System, but this option is not recommended.
Do not change the role of the server after you install SQL Server Express. For example, if you install SQL Server Express on a member server, do not use the Dcpromo tool to promote the server to a domain controller. Or, if you install SQL Server Express on a domain controller, do not use Dcpromo to demote the server to a member server. Changing the role of a server after you install SQL Server Express can result in loss of functionality and is not supported.

View Replies !   View Related
How Do I Install Sqlcmd.exe In My SQL Server Client
I have SQL Server 2000 client installed in my machine and I need to call stored procedures thru sqlcmd utility. When I tried using this utility, I got an error message from command prompt sqlcmd command does not exist.

I have osql utility in my client version, but i need to have sqlcmd utility.



Please advice how do I install sqlcmd.exe in my SQL Server client?

View Replies !   View Related
Database Services Install Fails When Install SQL Server 2005 SP2
The error I got is:
Hotfix.exe has encountered a problem and needs to close. We are sorry for the inconvenience.

EventType : sqlsesetup P1 : sysdbupg.sql P2 : 0x7361
P3 : odbcstatement__execute_batch@sysdbupg.sql@3 P4 : 0x7361
P5 : lib_odbc_statement.h@91 P6 : unknown P7 : sql9 P8 : hotfix@
P9 : x86 P10 : 3042

Log Location: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

I tried to search internet, however, I couldn't get solution.

My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.

Thanks a lot,

Rex

View Replies !   View Related
Get ServerInstance Name
I can't find this anywhere in the thousands of objects in SSIS. So I thought I would ask.

I have a situtation where I want to retrieve the serverinstance name of the SSIS job is running on. I have multiple servers and instances and I want to send emails like "Failed see serverinstance - job name".

Any ideas?

Thanks

View Replies !   View Related
Standard Edition Fails To Install, Express Edition Fails To Uninstall
We are trying to install the Standard Edition of SQL Server 2005. We already have SQL Express installed. Standard won't install and Express won't uninstall.

We have tried every suggestion we can find and some we made up. When we try to install Standard, we get to the bit where you choose what you want to install and the only thing available is workstation components.

There are so many cases of this on the Internat that I can't believe MS have not solved the issue. And I am stunned that they want to charge us more money to talk to us about how to fix something we just paid them an arm and a leg for!

What do I need to tell you to get some idea of where to go next with this?

View Replies !   View Related
How To Create A New Serverinstance But With Old Datafiles?
Hi groupI want to make a new serverinstance, but based on some old files from aprevious instance I once had from a SQL I scrapped.I only know how to use the SQL Server enterprise manager console, and Ihaven't found any tools in there to do that.Any suggestion will be more than welcome.Adrian

View Replies !   View Related
Specify [serverinstance] In Select Statement
Hi, what is the different when I execute

select count(*) from [servernameinstance].database1.dbo.tablename(nolock)
and
select count(*) from database1.dbo.tablename (nolock)

for the first code, I will get error
Msg 4122, Level 16, State 1, Line 1
Remote table-valued function calls are not allowed.

How can I use nolock with sever name and instance specified in the select statement??

View Replies !   View Related
SQL Server Could Not Configure 'ServerInstance' As A Distributor.
I am working on setting up our new SQL Server 2005 servers. One ofthem will eventually be our Replication Distributor. However when Iattempt to set this up within the wizard, I get the following error:------------------------------TITLE: New Publication Wizard------------------------------SQL Server could not configure 'ServerInstance' as a Distributor.------------------------------ADDITIONAL INFORMATION:Property LoginSecure cannot be changed or read after a connectionstring has been set. (Microsoft.SqlServer.ConnectionInfo)------------------------------BUTTONS: OK------------------------------In the "Specify the Domain or Machine account under which the Snap ShotAgent will run" page, I designate a Windows Auth. domain user; The sameuser that is used to start SQL Service. Any idea as to why I amgetting this error?

View Replies !   View Related
SQL Job Fails Running DTS Job
Hello,
I have a DTS job that retrieves data from a different server. When I manually run the DTS job, it executes fine, but when I run it from an SQL job it fails regardless of the owner I use to run the SQL job under.
I ran the same DTS package from another computer which has SQL client installed and it ran fine.
Does anyone know what could be the reason for failure when running the DTS job from the SQL job from the server?

Thanks,
Adrian.

View Replies !   View Related
Sp2 Install Fails
win2k3 running sql 2k5

The sp2 fails on database services and analysis services, but completes everything else.

Any suggestions would be appreciated.

Andy

Below is an excerpt from the log:
05/18/2007 10:41:13.620 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
05/18/2007 10:41:13.620 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
05/18/2007 10:41:13.620 Registry: Cannot read registry key value "Debug"
05/18/2007 10:41:25.041 MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

05/18/2007 10:41:25.463 MSP returned 1603: A fatal error occurred during installation.
05/18/2007 10:41:25.510 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
05/18/2007 10:41:25.510 Registry: Cannot read registry key value "Debug"
05/18/2007 10:41:26.385 Copy Engine: Error, unable to install MSP file: c:f6dc3a60067184b3ad32b830c4e7b2HotFixSQLFilessqlrun_sql.msp
05/18/2007 10:41:26.385 The following exception occurred: Unable to install Windows Installer MSP file Date: 05/18/2007 10:41:26.385 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 800
05/18/2007 10:41:26.885 Watson: Param1 = SetInstanceProperty
05/18/2007 10:41:26.885 Watson: Param2 = 0x7358
05/18/2007 10:41:26.885 Watson: Param3 = SetInstanceProperty
05/18/2007 10:41:26.901 Watson: Param4 = 0x7358
05/18/2007 10:41:26.901 Watson: Param5 = sqlcasqlcax.cpp@1223
05/18/2007 10:41:26.901 Watson: Param6 = Unknown
05/18/2007 10:41:26.901 Watson: Param7 = SQL9
05/18/2007 10:41:26.901 Watson: Param8 = Hotfix@
05/18/2007 10:41:26.901 Watson: Param9 = x86
05/18/2007 10:41:26.901 Watson: Param10 = 3042
05/18/2007 10:41:26.901 Installed product: SQL9
05/18/2007 10:41:26.901 Installing product: OLAP9
05/18/2007 10:41:26.901 Installing instance: MSSQLSERVER
05/18/2007 10:41:26.916 Installing target: VTHSQLTEST
05/18/2007 10:41:26.916 Stopping service: MSSQLServerOLAPService
05/18/2007 10:41:33.948 Stopped service: MSSQLServerOLAPService
05/18/2007 10:41:33.963 Installing file: sqlrun_as.msp
05/18/2007 10:41:33.963 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
05/18/2007 10:41:33.963 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
05/18/2007 10:41:33.963 Registry: Cannot read registry key value "Debug"
05/18/2007 10:41:38.697 MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

05/18/2007 10:41:39.041 MSP returned 1603: A fatal error occurred during installation.
05/18/2007 10:41:39.072 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
05/18/2007 10:41:39.072 Registry: Cannot read registry key value "Debug"
05/18/2007 10:41:39.963 Copy Engine: Error, unable to install MSP file: c:f6dc3a60067184b3ad32b830c4e7b2HotFixASFilessqlrun_as.msp
05/18/2007 10:41:39.963 The following exception occurred: Unable to install Windows Installer MSP file Date: 05/18/2007 10:41:39.963 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 800
05/18/2007 10:41:40.369 Watson: Param1 = SetInstanceProperty
05/18/2007 10:41:40.369 Watson: Param2 = 0x7358
05/18/2007 10:41:40.369 Watson: Param3 = SetInstanceProperty
05/18/2007 10:41:40.369 Watson: Param4 = 0x7358
05/18/2007 10:41:40.369 Watson: Param5 = sqlcasqlcax.cpp@1223
05/18/2007 10:41:40.369 Watson: Param6 = Unknown
05/18/2007 10:41:40.369 Watson: Param7 = OLAP9
05/18/2007 10:41:40.369 Watson: Param8 = Hotfix@
05/18/2007 10:41:40.369 Watson: Param9 = x86
05/18/2007 10:41:40.369 Watson: Param10 = 3042
05/18/2007 10:41:40.369 Installed product: OLAP9
05/18/2007 10:41:40.369 Installing product: RS9
05/18/2007 10:41:40.369 Installing instance: MSSQLSERVER
05/18/2007 10:41:40.369 Installing target: VTHSQLTEST
05/18/2007 10:41:40.369 Stopping service: ReportServer
05/18/2007 10:41:43.416 Stopped service: ReportServer
05/18/2007 10:41:43.416 Installing file: sqlrun_rs.msp
05/18/2007 10:41:43.463 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log
05/18/2007 10:41:43.463 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
05/18/2007 10:41:43.463 Registry: Cannot read registry key value "Debug"
05/18/2007 10:43:34.572 MSP returned 0: The action completed successfully.
05/18/2007 10:43:34.572 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
05/18/2007 10:43:34.572 Registry: Cannot read registry key value "Debug"
05/18/2007 10:43:34.572 Copy Engine: Installed file: c:f6dc3a60067184b3ad32b830c4e7b2HotFixRSFilessqlrun_rs.msp
05/18/2007 10:43:34.587 Restarting RS Service ReportServer since it was previously running
05/18/2007 10:43:34.587 Starting service: ReportServer

View Replies !   View Related
IS Install After SP1 Fails
Subject says it all; I need to install IS, but the installer says v.2047 of IS is already installed; it it NOT installed. When I go to add/remove programs, under the Sql Server 2005, it allows me to try to install IS, but that also fails, as no components are found for installation. This is SS dev edition, W2003.

I can uninstall SS2005 and start over, but is there a quicker way to fix this?

View Replies !   View Related
Install Fails
I'm having trouble installing SQL Server 2005 Express SP2 on WinXP Home SP2. I've had no troubles installing on another WinXP Professional machine.

As it installs, the setup progress shows that following componenets failed : MSXML6, SQL Server Database Services, and Workstation Components, Books Online.

The other three components succeeded. When I click on Finish, it crashes with the error message "Microsoft SQL Server 2005 Setup was unable to install on your computer", with the option to send an error report which I have done.

Here is the Summary Log and the MSXML6 log. If you want other logs, please specify which ones.

Summary.txt

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Time : Sun Apr 13 12:12:25 2008

Machine : DELL-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : DELL-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : DELL-PC
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : DELL-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : DELL-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SQLNCLI_2.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.

Time : Sun Apr 13 12:20:34 2008

List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SQLSupport_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SQLNCLI_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_SCC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DELL-PC_WI.log


MSXML6

=== Verbose logging started: 4/13/08 12:15:20 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (88:24) [12:15:20:281]: Resetting cached policy values
MSI (c) (88:24) [12:15:20:281]: Machine policy value 'Debug' is 0
MSI (c) (88:24) [12:15:20:281]: ******* RunEngine:
******* Product: {0A869A65-8C94-4F7C-A5C7-972D3C8CED9E}
******* Action:
******* CommandLine: **********
MSI (c) (88:24) [12:15:20:281]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (88:24) [12:15:20:281]: Grabbed execution mutex.
MSI (c) (88:24) [12:15:20:296]: Cloaking enabled.
MSI (c) (88:24) [12:15:20:296]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (88:24) [12:15:20:296]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (44:24) [12:15:20:296]: Grabbed execution mutex.
MSI (s) (44:30) [12:15:20:296]: Resetting cached policy values
MSI (s) (44:30) [12:15:20:296]: Machine policy value 'Debug' is 0
MSI (s) (44:30) [12:15:20:296]: ******* RunEngine:
******* Product: {0A869A65-8C94-4F7C-A5C7-972D3C8CED9E}
******* Action:
******* CommandLine: **********
MSI (s) (44:30) [12:15:20:296]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (44:30) [12:15:20:296]: Warning: Local cached package 'C:WINDOWSInstaller964445.msi' is missing.
MSI (s) (44:30) [12:15:20:296]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (44:30) [12:15:20:296]: User policy value 'DisableMedia' is 0
MSI (s) (44:30) [12:15:20:296]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (44:30) [12:15:20:296]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (44:30) [12:15:20:296]: SOURCEMGMT: Looking for sourcelist for product {0A869A65-8C94-4F7C-A5C7-972D3C8CED9E}
MSI (s) (44:30) [12:15:20:296]: SOURCEMGMT: Adding {0A869A65-8C94-4F7C-A5C7-972D3C8CED9E}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (44:30) [12:15:20:296]: SOURCEMGMT: Now checking product {0A869A65-8C94-4F7C-A5C7-972D3C8CED9E}
MSI (s) (44:30) [12:15:20:296]: SOURCEMGMT: Media is enabled for product.
MSI (s) (44:30) [12:15:20:296]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (44:30) [12:15:20:296]: SOURCEMGMT: Trying source d:5cc926c0a235563173cbebcf29.
MSI (s) (44:30) [12:15:20:296]: Note: 1: 1327 2: d:
MSI (s) (44:30) [12:15:20:296]: ConnectToSource: CreatePath/CreateFilePath failed with: -2147483648 1327 -2147483648
MSI (s) (44:30) [12:15:20:296]: ConnectToSource (con't): CreatePath/CreateFilePath failed with: -2147483648 -2147483648
MSI (s) (44:30) [12:15:20:296]: SOURCEMGMT: net source 'd:5cc926c0a235563173cbebcf29' is invalid.
MSI (s) (44:30) [12:15:20:296]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (44:30) [12:15:20:296]: SOURCEMGMT: Processing net source list.
MSI (s) (44:30) [12:15:20:296]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (44:30) [12:15:20:296]: SOURCEMGMT: Processing media source list.
MSI (s) (44:30) [12:15:21:328]: Note: 1: 2203 2: 3: -2147287037
MSI (s) (44:30) [12:15:21:328]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (44:30) [12:15:21:328]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (44:30) [12:15:21:328]: SOURCEMGMT: Processing URL source list.
MSI (s) (44:30) [12:15:21:328]: Note: 1: 1402 2: UNKNOWNURL 3: 2
MSI (s) (44:30) [12:15:21:328]: Note: 1: 1706 2: -2147483647 3: msxml6.msi
MSI (s) (44:30) [12:15:21:328]: Note: 1: 1706 2: 3: msxml6.msi
MSI (s) (44:30) [12:15:21:328]: SOURCEMGMT: Failed to resolve source
MSI (s) (44:30) [12:15:21:328]: MainEngineThread is returning 1612
MSI (c) (88:24) [12:15:21:328]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (88:24) [12:15:21:328]: MainEngineThread is returning 1612
=== Verbose logging stopped: 4/13/08 12:15:21 ===


View Replies !   View Related
MSDE Install Fails. Please Help Someone
The installation of MSDE fails and I dont find any solution to get itwork. If I start the setup than a windows with the time bar appears andsays it will take 1 minute. After nearly 1 minute it closes the windowand gives no additional information. But I see that it generates firstall the directories and files in c:Programme but after the setup is endeverything is deleted. Nearly everything , I see a service"MSSQLServerADHelper" is still installed.Must everytime delete it via regedit.I am using WindowsXP SP1 with MDAC 2.8I get this at the end of the generated protokollafter I start setup with"setup SAPWD="mypasswort" SECURITYMODE=SQL /L*v D:/MSDELog.log"Property(C): StartupFolder = C:Dokumente und EinstellungenAllUsersStartmenProgrammeAutostartProperty(C): ProgramMenuFolder = C:Dokumente und EinstellungenAllUsersStartmenProgrammeProperty(C): StartMenuFolder = C:Dokumente und EinstellungenAllUsersStartmenProperty(C): DesktopFolder = C:Dokumente und EinstellungenAllUsersDesktopProperty(C): FontsFolder = C:WINDOWSFontsProperty(C): GPTSupport = 1Property(C): OLEAdvtSupport = 1Property(C): ShellAdvtSupport = 1Property(C): Intel = 6Property(C): PhysicalMemory = 448Property(C): VirtualMemory = 805Property(C): AdminUser = 1Property(C): LogonUser = BILOAGAProperty(C): UserSID = S-1-5-21-1606980848-1563985344-1202660629-1003Property(C): UserLanguageID = 1031Property(C): ComputerName = JUSTLERProperty(C): SystemLanguageID = 1031Property(C): ScreenX = 1024Property(C): ScreenY = 768Property(C): CaptionHeight = 19Property(C): BorderTop = 1Property(C): BorderSide = 1Property(C): TextHeight = 16Property(C): ColorBits = 16Property(C): TTCSupport = 1Property(C): MsiNetAssemblySupport = 1.1.4322.573Property(C): MsiWin32AssemblySupport = 5.1.2600.1106Property(C): RedirectedDllSupport = 2Property(C): Time = 19:43:01Property(C): Date = 18.12.2003Property(C): Privileged = 1Property(C): USERNAME = BILOAGAProperty(C): COMPANYNAME = xxxProperty(C): DATABASE = C:DOKUME~1BILOAGALOKALE~1Temp5b2b57.msiProperty(C): OriginalDatabase = C:SQL2ksp3installSetupSqlRun01.msiProperty(C): UILevel = 3Property(C): ACTION = INSTALL=== Protokollierung beendet: 18.12.2003 19:43:01 ===MSI (c) (B0:20): Note: 1: 1708MSI (c) (B0:20): Produkt: Microsoft SQL Server Desktop Engine --Installationsvorgang fehlgeschlagen.MSI (c) (B0:20): Grabbed execution mutex.MSI (c) (B0:20): Cleaning up uninstalled install packages, if any existMSI (c) (B0:20): MainEngineThread is returning 1603=== Verbose logging stopped: 18.12.2003 19:43:01 ===It would be super if anyone can help me. Havent find any informationsabout this.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View Replies !   View Related
SQL Install Into Cluster Fails
I'm trying to install SQL into a new cluster. The cluster service is up and running fine. I can even fail it from Node 1 to Node 2 with no problem.

However, when I try to install SQL, I get a screen that tells me that SQL is performing required operations on the cluster nodes...this may take a few minutes.

After hanging on that message for a looong time, SQL comes up with a generic message that the install failed and that SQL is cleaning up. Then, nothing. No error message, nothing that I can track down.

Some system information:
Node 1. Dell PE2650, 2x 2.8 GHz, 2 GB RAM
- Windows 2000 Advanced Server
- Dell Perc3/DC RAID/SCSI Controller
- Dell Perc3/DI Integrated RAID Controller

Node 2. Dell PE2650, 2x 2.8 GHz, 2 GB RAM
- Windows 2000 Advanced Server
- Dell Perc3/DC RAID/SCSI Controller
- Dell Perc3/DI Integrated RAID Controller

Shared Storage. Dell PV220
- Q: Quorum (1 GB)
- S: Data (136 GB)
- T: Logs (20 GB)


Additional Notes:
1. I am using a checklist from Dell and another from MS.
2. I have also downloaded and read the checklist from sql-server-performance.com.
3. I have ensured that the comclust.exe was run on both nodes prior to starting the SQL installation
4. I am using SQL Enterprise Edition. We used the same CD to install a cluster server two weeks ago.

Questions:
1. Where can I find an installation error log that might point more specifically to where the problem might be?
2. Any thoughts on what the problem might be?
3. Anyone ever experience something similar?

View Replies !   View Related
Publishing Install Fails
SQL 6.5 - Setting up replication: started by running Server/Replication Configuration/Install Publishing. Chose to have Distribution server local and created new devices for the db (30meg) and the log (15meg). Process fails and points me to instdist.out in the SQLhome/install directory. Tons of errors in this file ranging from "Unable to find foreign key constraints for table 'sysobjects'in dbid 9 though table is flagged as having them" to invalid object names in multiple stored procedures. Really stumped and don't know where to go from here......

View Replies !   View Related
MSDE Install In Win XP Fails
I was trying to install the MSDE 2000 from the Office XP CD in Windows XP Pro. In the middle of the installation, it rolls back, does not give any message and the installation fails. :confused: What could be the problem? Please help me with this

I am trying to build a VB6.0 application with the msde as back end

Thank you

View Replies !   View Related
MSXML6 Install Fails
I'm having a hard time installing SQLServer 2005. msxml6 keep on failing.The log looks like this.



Installing: msxml6 on target: GPA-DEMO
Error: MsiOpenDatabase failed with 87
Failed to install package
This action is only valid for products that are currently installed.


If i try to run the MSXML6.msi on the install disk directly i'm getting a permission error. Any ideas?

View Replies !   View Related
SQL2005 Install Fails
I have a Windows 2003 R2x64 server with SP4, and I'm trying to install SQL 2005 Standard (x64). After the install of the Setup files and Native Client, I receive the following error:
The procedure entry point MtxCluGetDtcRegValue could not be located in the dynamic link library MTXCLU.dll

After this message, I receive another one that states:
Failed to load SqlSpars.dll

In the SqlSetup###_ServerName_Core.log file, I find the following error at the bottom:

Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 87
Aborting queue processing as nested installer has completed
Message pump returning: 87

In the SqlSetup###_ServerName_Core(local).log file, I find the following error at the bottom:
Running: PerformDotNetCheck2 at: 2007/9/17 8:51:17
Complete: PerformDotNetCheck2 at: 2007/9/17 8:51:17, returned true
Running: InvokeSqlSetupDllAction at: 2007/9/17 8:51:17
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Unable to load setup helper module : 87
Message displayed to user
Failed to load SqlSpars.dll


Any assistance would be greatly appreciated

Thanks,
John

View Replies !   View Related
SP2 Install Fails With No Error
On a new install of sqlserver 2005 developer edition (on x86 xp sp2) I tried to install sp2 but before anything happens I get the message:

Unexpected Error Occurred
The following unexpected error occurred:

But no error message, and no log created in the hotfix folder.
I downloaded the sp2 file again but got the same error.

When I click on OK to this error I get 7 messages about "hotfix.exe has encountered a problem and needs to close"

I downloaded sp1 and installed that fine, but after that I still have the same error with sp2.
I tried extracting sp2 and replacing hotfix.exe with the one from sp1, which avoided the error but wouldn't install.

Any ideas on how to resolve this would be appreciated.

View Replies !   View Related
Sql Express Install Fails
I have tried multiple times to install SQL Express on a client's machine (Windows XP), every single time the installation fails with and error message "Sql server could not be started". What else can I do to have this install properly? Please help.

ERRORLOG

2007-09-05 15:44:20.14 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-09-05 15:44:20.14 Server (c) 2005 Microsoft Corporation.
2007-09-05 15:44:20.14 Server All rights reserved.
2007-09-05 15:44:20.14 Server Server process ID is 2492.
2007-09-05 15:44:20.14 Server Authentication mode is MIXED.
2007-09-05 15:44:20.14 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-09-05 15:44:20.14 Server This instance of SQL Server last reported using a process ID of 2612 at 9/5/2007 3:44:02 PM (local) 9/5/2007 10:44:02 PM (UTC). This is an informational message only; no user action is required.
2007-09-05 15:44:20.14 Server Registry startup parameters:
2007-09-05 15:44:20.14 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2007-09-05 15:44:20.14 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-09-05 15:44:20.14 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2007-09-05 15:44:20.14 Server Command Line Startup Parameters:
2007-09-05 15:44:20.14 Server -m SqlSetup
2007-09-05 15:44:20.14 Server SqlSetup
2007-09-05 15:44:20.14 Server -Q
2007-09-05 15:44:20.14 Server -q SQL_Latin1_General_CP1_CI_AS
2007-09-05 15:44:20.14 Server -T 4022
2007-09-05 15:44:20.14 Server -T 3659
2007-09-05 15:44:20.14 Server -T 3610
2007-09-05 15:44:20.14 Server -T 4010
2007-09-05 15:44:20.17 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-09-05 15:44:20.17 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-09-05 15:44:20.25 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-09-05 15:44:20.37 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-09-05 15:44:20.37 spid5s Warning ******************
2007-09-05 15:44:20.38 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.
2007-09-05 15:44:20.38 spid5s Starting up database 'master'.
2007-09-05 15:44:20.63 spid5s 13 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2007-09-05 15:44:20.75 spid5s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2007-09-05 15:44:20.75 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-09-05 15:44:20.82 spid5s SQL Trace ID 1 was started by login "sa".
2007-09-05 15:44:20.84 spid5s Starting up database 'mssqlsystemresource'.
2007-09-05 15:44:20.93 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-09-05 15:44:21.15 spid5s Server name is 'S0022882021'. This is an informational message only. No user action is required.
2007-09-05 15:44:21.16 spid7s Starting up database 'model'.
2007-09-05 15:44:21.29 Server Error: 17190, Severity: 16, State: 1.
2007-09-05 15:44:21.29 Server FallBack certificate initialization failed with error code: 1.
2007-09-05 15:44:21.29 Server Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
2007-09-05 15:44:21.29 Server Error: 17182, Severity: 16, State: 1.
2007-09-05 15:44:21.29 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x80.
2007-09-05 15:44:21.29 Server Error: 17182, Severity: 16, State: 1.
2007-09-05 15:44:21.29 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x1.
2007-09-05 15:44:21.30 Server Error: 17826, Severity: 18, State: 3.
2007-09-05 15:44:21.30 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-09-05 15:44:21.30 Server Error: 17120, Severity: 16, State: 1.
2007-09-05 15:44:21.30 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.


Summary:

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Wed Sep 05 15:37:15 2007

Machine : S0022882021
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : S0022882021
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : S0022882021
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : S0022882021
Product : MSXML 6.0 Parser
Product Version : 6.10.1129.0
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : S0022882021
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : S0022882021
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : S0022882021
Product : MSXML 6.0 Parser
Product Version : 6.10.1129.0
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_MSXML6_2.log
--------------------------------------------------------------------------------
Machine : S0022882021
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--------------------------------------------------------------------------------
Machine : S0022882021
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SQL.log
Last Action : InstallFinalize
Error String : Service 'SQL Server Active Directory Helper' (MSSQLServerADHelper) could not be installed. Verify that you have sufficient privileges to install system services.
Error Number : 1923
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.

Time : Wed Sep 05 15:46:56 2007

List of log files:
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_Core(Local).log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SQLSupport_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SQLNCLI_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SqlWriter_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_MSXML6_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SQLSupport_2.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SQLNCLI_2.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_MSXML6_2.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SQL.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_Datastore.xml
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_.NET Framework 2.0.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_Support.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_Core.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_SCC.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0009_S0022882021_WI.log
c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG

View Replies !   View Related
SQL 2K5 Cluster Install Fails


Have SQL 2000 SP4 clustered instance running now. Attempted inplace upgrade to SQL 2K5 standard edition.
Boxes are Windows 32 bit Ent Edition, SP2. Install wizard installed pre-req's just fine, and I got past the "components to install" box of the install wizard. When I clicked next, the current 2000 instance (already installed component) was grayed out and I could not select it. Checking the messages in the install wizard, I saw that my "upgrade was blocked".
I cancelled out of the install wizard to verify all requirements.

Bounced both boxes, and now when I try to run the install wizard, it tried to install the required support files (ASP.net 2.0, SQL Native Client and what not) and then the install wizard hangs..... and never comes back. I have to kill it from taskmgr. Bounced the boxes and tried again, same thing. Install wizard hangs forever.

Yes, I am running from the active node holding the cluster resources. Yes, SQL 2000 instance is cold. Yes, I've checked add/remove programs and there is nothing to uninstall.
Checked event viewer and I see the following errors:

Hanging application setup.exe, version 2005.90.1399.0, hang module hungapp, version 0.0.0.0, hang address 0x00000000.

Fault bucket 238575085.


I've reached out to our TAM, but any help would be appreciated. No matter how many times I try, the install wizard now chokes and never comes back.

View Replies !   View Related
Cluster Install Fails
I'm running into issues installing SQL 2005 Enterprise on a Win2003 server. They seem to be related to missing rights. I've done a lot of research and have come up empty. Does anyone know why I'm getting these log entries? Thanks for any help.

Running: OpenPipeAction at: 2006/0/31 11:35:35
Complete: OpenPipeAction at: 2006/0/31 11:35:35, returned false
Error: Action "OpenPipeAction" failed during execution.

Error: 0x80070005 TaskScheduler::SetTargetComputer for \SERVER
Complete: RunRemoteSetupAction at: 2006/0/31 11:35:35, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Error: 80070005 Access is denied.

Skipped: InstallASAction.11
Waiting for actions from remote setup(s)
Breaking wait state and aborting package due to cancel code received: 1602
Remote setup(s) are ready
Notify package action is determined: 1602
Error Code: 0x800700e9 (233)
Windows Error Text: No process is on the other end of the pipe.

Source File Name: remotemessageliboverlappedpipelistener.cpp
Compiler Timestamp: Fri Jul 29 01:13:51 2005
Function Name: sqls::OverlappedPipeListener::writePipe
Source Line Number: 294
Notification failed to send.

View Replies !   View Related
SQLExpress Install Fails
I have the latest SQLEXPR and the Management Studio.

Management installed no problem.

I cannot install SQLEXPR due to beta versions of Visual Studio, etc. However this machine has been rebuilt with disk format and clean install of Windows XP Pro. No beta's of any kind on the machine.

Have latest version of Net 2, installed without error.

I installed SQLExpress with out error on other machines.

Help!

Geoff

View Replies !   View Related
Install Of SharePointRS.msi Fails
Hi,

I have a problem installing SharePointRS.msi. The MSI is executing just fine, but the step "removing backups" (don't know the exact wording in english, since I'm using a german install) seems to fail.

This is what the msi logfile has to offer:

Aktion 15:59:51: RSSP_CAInstall.28B19132_4741_4761_840F_AC515130EC08.
Aktion 15:59:52: RollbackCleanup. Sicherungsdateien werden entfernt
CA MSG : Running RSCustomAction
CA MSG : Launching C:DOKUME~1ADMINI~1LOKALE~1Temp
sCustomAction.exe with command line parameter /i
CA MSG : rsCustomAction.exe failed to configure, Error code is: 1
Aktion 16:02:48: Rollback. Aktion wird rückgängig gemacht:

Can anyone explain, why the custom-action is not succeeding?

View Replies !   View Related
SQL Agent Job Fails Running SSIS Packages
I need some help from you on a problem with SQL Server Agent that I believe many of you have experienced. When searching on the web I find some loose answers, but it would not solve my problems. So here is my story.

1. I have created two SSIS packages, package 1 and package 2. Both packages have a Execute SQL Task making a select sql statement to a table, say Customer in AdventureWorks DB. Package1 also makes a Execute Pacakge Task to Package 2. Both packages have protectionlevel property set to EncryptSensitiveWithUserKey

2. Then I created two package configuration files per package, one indirect xml configuration and one xml configuration file. The former I created an environment variable called pack1, which was specifying the path and file name of second config file. Likewise, I did for package2. Maybe I could have reused thie first configuration file, but I am not sure since package1 calls package2.

3. Now I build and deploy my packages. Then I run my manifest file, going through the deployment wizard setting the necceccary properties like server name, user, password, I have also create the same environment variables on the deployment machine. I ensure that the package1 and package2 can be run under integration services (file system). And both package works. So far so good

4. Now I want to create a SQL server agent job that runs package1 and package2. Here I found an article that decribed How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005 http://www.codeproject.com/useritems/Schedule__Run__SSIS__DTS.asp

5. I created a job executor account and then Create SQL proxy account and associate proxy account with job executor account as described. I created a new ssis job, specifying type ssis integration services, run as proxy, setting package source to SSIS package store, naming the server and package name (package2).

6. Now, I try running job1 which runs package2. ANd it works. I was aware if I needed to give file permission on users (read and execute) on my dtsx/dtsconfig/log files. So far so good

7. Now, I try to run job testwhich runs package1 (which also runs package2). But now the job fails :-(. The job runs for some seconds, but fails. I have to say that I have some script tasks with message boxes inside!!! hope this doesn't matter. I have created all neccessary accounts, proxies, credentials and so on. here is the view history

Date17.10.2006 00:50:53
LogJob History (test)

Step ID1
ServerABEO-GEIR
Job Nametest
Step Nametest
Duration00:00:07
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0

Message
Executed as user: abeo-geir
as_jobuser. The package execution failed. The step failed.



Continue: This error is well known for you. It has been mentioned in many postings. Well, how do I go from here. Setting logging on the job results in only this information

PackageStart,ABEO-GEIR,ABEO-GEIR
as_jobuser,Package1,{3F5BD166-D24B-4838-B3F1-018B6C2C7523},{8E1B8E45-7F1D-4C24-852C-2694F993E6D2},17.10.2006 00:59:40,17.10.2006 00:59:40,0,0x,Beginning of package execution.

PackageEnd,ABEO-GEIR,ABEO-GEIR
as_jobuser,Package1,{3F5BD166-D24B-4838-B3F1-018B6C2C7523},{8E1B8E45-7F1D-4C24-852C-2694F993E6D2},17.10.2006 00:59:41,17.10.2006 00:59:41,1,0x,End of package execution.



Well, I read some place that I could run the job as type operating system (cmdexec). Here i could not choose Run as, but had to select SQL SErver agent account. NOw I got this message

Date17.10.2006 01:05:21
LogJob History (test)

Step ID0
ServerABEO-GEIR
Job Nametest
Step Name(Job outcome)
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0

Message
The job failed. The Job was invoked by User sa. The last step to run was step 1 (test).



As you see, I can't come any further. I NEED HELP FROM YOU. I AM STUCK. I know many of you have solved this and I hope you can guide me through thise. I don't know how many hours or days I have used on this.



Regards

Geir F



View Replies !   View Related
Accessing MS Access When Running On Server Fails
Hello:

I have a package which runs fine from the client but not the server (see error below). I am logged into the client with my domain account, and the package runs under a proxy using that same domain account (for now). The MS Access db I am trying to pull from is on a non-domain computer, and I have created a Y: mapped drive on both the client and server that access a share on that machine where the Access database lives--I created the mapped drive using the "different user" option, and used a local account on the non-domain computer to create the mapped drives.

On the server, when logged in as my domain account, I can use the y:MyDB.mdb you can see below in Start | Run to hit the Access database. Why can't the package also see this file when running on the server?




Code Snippet
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "'y:Mydb.MDB' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.". End Error Error: 2008-02-05 02:35:56.26 Code: 0xC020801C Source: Cost Cost [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MyDB" failed with error code 0xC0202009. There may be error messages posted before this with more informat... The package execution fa... The step failed.


Thanks,
Kayda

View Replies !   View Related
Running A Query On A Snapshot Database Fails.
Hello!


I'm trying to use mirroring + snapshots for reporting on a large database.

I've set up the mirrored database and created a snapshot.

Everything looks fine unil a run some queries on the snapshot.

Some queries work some don't. the error is this:


Msg 954, Level 14, State 1, Line 1

The database "test" cannot be opened. It is acting as a mirror database.



From what i can tell when he's trying to use an index for the query, the engine tries to use it from the mirror database.

eg.
this query works fine:
select top 10 * from dbo.table1

this query gives the error:
select top 10 * from dbo.table1 order bycol1 desc




What's going on and how can i make this setup work?
thanks.

View Replies !   View Related
SP3a Install Fails On Sp3_serv_uni.sql
Howzit fellows. Been having a problem doing my zillionth sp3a ungrade. This is on a server with 4 instances, 3 of which are already upgraded to sp3a. In a nutshell.

Looking at the sqlsp.log file, I can see that the install fails on the sp3_serv_uni.sql script. Looking in the sp3_serv_uni.out file. The part of the script that fails is the "Creating 'system_function_schema.fn_get_sql'.". The error is as follows "There is already an object named 'fn_get_sql'" in the database.

But, if I run the following (taken from the sp3_serv_uni.sql script)
select * from sysobjects
where xtype = N'TF' and uid = USER_ID('system_function_schema') and
name = 'fn_get_sql'

It does not find the object. Running this on a box that already has sp3 brings back a positive result. Also note, that within the script it first tries to drop the function as follows.

if exists (select * from sysobjects
where xtype = N'TF' and uid = USER_ID('system_function_schema') and
name = 'fn_get_sql')
drop function system_function_schema.fn_get_sql
go

So why the cursed thing fails is a mystery to me. Microsoft have not been particicuarly helpful and a web search has only shown one chap who did a complete rebuild to solve it, this is not an option.

Any ideas would be much appreciated

View Replies !   View Related
Sql Developer Edition Fails To Install
Hi,

I'm installing SQL developer edition using commandline options. Below is the command line I'm using.

setup.exe" /qn INSTANCENAME=MSSQLSERVER ADDLOCAL=All SQLACCOUNT=<my domain account> SQLPASSWORD=<my domain account password> AGTACCOUNT=<my domain account> AGTPASSWORD=<my domain account password> SQLBROWSERACCOUNT=<my domain account> SQLBROWSERPASSWORD=<my domain account password> ASACCOUNT=<my domain account> ASPASSWORD=<my domain account password>

I'm not sure if this is correct but this installs all the components properly except "Microsoft SQL Server 2005". This component failes with the below error.
----------------------------------------------------------------------------------------------------
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 4/8/2008
Time: 3:33:03 PM
User: NT AUTHORITYSYSTEM
Computer: HYDTEST15
Description:
Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
----------------------------------------------------------------------------------------------------

Actually I didn''t know how to install SQL to run the services with Syatem account. I read through some forums and found that I should use domain account for this purpose. If I dont give any account details Installation will fail saying the account details for service are not specified.

I thought of running the installation with any domain account and then use a script to chage the sevice to run with system account so that user can use it.

I have the log file but its a 12 mb file. I couldn't find an option to install attach the file.

Thanks,
Prakash

View Replies !   View Related
Install Of 2005 Tools Fails
I'm trying to install SQL Server 2005 tools, but keep getting this error,

TITLE: Microsoft SQL Server Setup------------------------------None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel.For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28108
Then on the Details, it says the following,

Name: Microsoft SQL Server 2005 ToolsReason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.Build version check:Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.

I uninstalled the Express tools from the system and can't get the tools to install. I've rebooted to no avail. Help!

View Replies !   View Related
SP2 Fails To Install On 64 Bit Itanium Platform


While SQL Server installed into our clustered environment with no significant problems Service Pack 2 will not install with the Error "Unable to install Windows Installer MSP file"during the update to the Database Services.

Subsequently, Integration Services, Native Client and Backwards Compatibilty also fail to upgrade due to suspended installs.

Searching for this returns a number of articles none of which match what we are seeing, including:-

http://support.microsoft.com/kb/918357indicates this is a problem with the Setup Support Files.
This is not the case and the Setup Support files are updated. Also the permissions are correct on the folder and files mentioned,

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=448685&SiteID=1also point to a problem when installing the Setup Support Files. Our install gets past this but fails on the database engine then sets up a chain of suspended installs.

Other finds indicate there may be another msi running, again this is not the case and the server has been failed over and rebooted a number of times.

At the moment we are sitting at RTM having rebuilt the machine completely but would like to move forward onto SP2. Has anyone come across this and provide any further information or resolution?

We have successfully deployed SP2 onto a number of other servers cover both clustered and non clustered, 32 bit and X64 installations with no problems and now wondering if the problem is Itanium edition specific.

extract from the install log from the failed install. The logs mentioned in this log do not exist post install, in fact the Hotfix folder is not there.

Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support FilesENU 9.00.1399.06 IA64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 IA64 ENTERPRISE
Integration Services ENU RTM 9.00.1399.00 IA64 ENTERPRISE
SQL Server Native Client ENU 9.00.1399.06IA64
Client Components ENU RTM9.00.1399.06 IA64 ENTERPRISE
MSXML 6.0 Parser ENU6.00.3883.8 IA64
SQLXML4 ENU 9.00.1399.06 IA64
Backward Compatibility ENU 8.05.1054 IA64
Microsoft SQL Server VSS WriterENU 9.00.1399.06 IA64
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 1601
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 1601
Error Description : MSP Error: 1704 An installation for Microsoft SQL Server 2005 (64-bit) is currently suspended. You must undo the changes made by that installation to continue. Do you want to undo those changes?

View Replies !   View Related
SQL Server Express Fails To Install
I have tried multiple times, and manyhours,to install SQL Server Express without success. I have included (what I think is) the relevant log file below. I would appreciate any help.

Seth

ComponentRegister(ComponentId={1F3316BE-825B-4390-A9D2-AF3EECCAE9F6},KeyPath=<Microsoft.NetEnterpriseServers.ExceptionMessageBox,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0",State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (8C:90) [22:25:17:718]: MSCOREE not loaded loading copy from system32
MSI (s) (8C:90) [22:25:17:734]: Assembly Error:Function not defined in specified DLL.
MSI (s) (8C:90) [22:25:17:734]: Note: 1: 1935 2: 3: 0x8002802F 4: 5: CreateAssemblyNameObject 6: Microsoft.NetEnterpriseServers.ExceptionMessageBox,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0"
MSI (s) (8C:90) [22:25:17:734]: Product: Microsoft SQL Server Setup Support Files (English) -- Error 2908. The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}.
MSI (s) (8C:90) [22:25:17:750]: Executing op: ComponentRegister(ComponentId={52723CBD-3400-458C-988A-4D012E6CAEDB},KeyPath=<Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0",State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
Error 2908. The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}.
MSI (s) (8C:90) [22:25:17:765]: Assembly Error:Function not defined in specified DLL.
MSI (s) (8C:90) [22:25:17:765]: Note: 1: 1935 2: {52723CBD-3400-458C-988A-4D012E6CAEDB} 3: 0x8002802F 4: 5: CreateAssemblyNameObject 6: Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0"
MSI (s) (8C:90) [22:25:17:765]: Product: Microsoft SQL Server Setup Support Files (English) -- Error 1935. An error occurred during the installation of assembly 'Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0"'. Please refer to Help and Support for more information. HRESULT: 0x8002802F. assembly interface: , function: CreateAssemblyNameObject, component: {52723CBD-3400-458C-988A-4D012E6CAEDB}
Error 1935. An error occurred during the installation of assembly 'Microsoft.SqlServer.WizardFrameworkLite,Version="9.0.242.0",processorArchitecture="MSIL",Culture="neutral",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.3042.0"'. Please refer to Help and Support for more information. HRESULT: 0x8002802F. assembly interface: , function: CreateAssemblyNameObject, component: {52723CBD-3400-458C-988A-4D012E6CAEDB}
MSI (s) (8C:90) [22:25:17:765]: User policy value 'DisableRollback' is 0
MSI (s) (8C:90) [22:25:17:765]: Machine policy value 'DisableRollback' is 0
Action ended 22:25:17: InstallFinalize. Return value 3.
MSI (s) (8C:90) [22:25:17:812]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=925152041,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (8C:90) [22:25:17:812]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (8C:90) [22:25:17:812]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server Setup Support Files (English))
MSI (s) (8C:90) [22:25:17:812]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (8C:90) [22:25:17:812]: Executing op: ActionStart(Name=ProcessComponents,Description=Updating component registration,)
MSI (s) (8C:90) [22:25:17:812]: Executing op: ProductInfo(ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},ProductName=Microsoft SQL Server Setup Support Files (English),PackageName=SqlSupport.msi,Language=1033,Version=150997986,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=Setup,PackageCode={BEFE6789-8AE1-4E45-B1F7-E3D6B30A51C8},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0)
MSI (s) (8C:90) [22:25:17:812]: Executing op: ComponentUnregister(ComponentId={63E949F6-03BC-5C40-C01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:843]: Executing op: ComponentUnregister(ComponentId={63E949F6-03BC-5C40-A01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:843]: Executing op: ComponentUnregister(ComponentId={9457ED28-F3FC-BCC8-D01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:859]: Executing op: ComponentUnregister(ComponentId={98CB24AD-52FB-DB5F-B01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={98CB24AD-52FB-DB5F-C01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={98CB24AD-52FB-DB5F-A01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={66332652-9C28-58B1-C01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={66332652-9C28-58B1-A01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={946F6004-4E08-BCAB-D01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:875]: Executing op: ComponentUnregister(ComponentId={97F81AF1-0E47-DC99-B01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:890]: Executing op: ComponentUnregister(ComponentId={97F81AF1-0E47-DC99-C01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:890]: Executing op: ComponentUnregister(ComponentId={97F81AF1-0E47-DC99-A01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={946F6004-4E08-BCAB-E01F-C8B3B9A1E18E},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={059D90B4-0150-436B-B9D8-B261229E6B64},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={87944102-39A6-4E0E-B162-9367A083E257},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={595992AD-43E5-4130-8583-98F9F357FAAC},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={E4B47CED-7E97-45BC-968A-04B752B85120},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={B3C58830-1820-42E5-B115-1B9A521EF462},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={BC55F500-00C5-4198-ACE1-03CEABE11AE5},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={F12F1390-EDC6-4D29-8814-E0E29ADCC8D8},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:906]: Executing op: ComponentUnregister(ComponentId={3E4EDF17-D7EA-4F36-8436-E81D49FFDB95},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:17:984]: Executing op: ComponentUnregister(ComponentId={6746C12E-607A-4270-BE87-473A8033B29C},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={FD324E23-C3C3-413D-91BD-2AD180781C28},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={36FB71AA-9DB6-4F0E-9D67-1A7FA3D6D71B},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={6EF46374-C444-4E0A-AE9B-D54E75BE824F},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={63B0B8BC-D916-4256-A03A-D03C8FC724F2},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={3CE74AA8-ADD6-41CF-AE3B-C261504386D4},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={053A9093-3FB8-4EE0-ADF5-9A6690561F82},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={715A71E2-375D-4FE0-BB44-1CDABB31973D},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={ECC96BE9-D40C-4EF3-B815-1A455D8A793F},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: ComponentUnregister(ComponentId={C3603B13-8645-4D5D-885D-62072C95577D},ProductKey={53F5C3EE-05ED-4830-994B-50B2F0D50FCE},BinaryType=0,)
MSI (s) (8C:90) [22:25:18:015]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (8C:90) [22:25:18:015]: Error in rollback skipped.Return: 5
MSI (s) (8C:90) [22:25:18:281]: No System Restore sequence number for this installation.
MSI (s) (8C:90) [22:25:18:281]: Unlocking Server
MSI (s) (8C:90) [22:25:18:281]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'.
Action ended 22:25:18: INSTALL. Return value 3.
Property(S): ProductCode = {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
Property(S): ProductLanguage = 1033
Property(S): Manufacturer = Microsoft Corporation
Property(S): DesktopFolder = C:Documents and SettingsAll UsersDesktop
Property(S): ProductVersion = 9.00.3042.00
Property(S): UpgradeCode = {3A91FA19-A197-467C-850F-0AFE90899371}
Property(S): SqlPatchLevel = 9.2.3042
Property(S): ReleaseProductVersion = 9.00.3042.00
Property(S): ARPPRODUCTICON = ARPIcon.ico
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52154
Property(S): DefaultUIFont = Tahoma8
Property(S): VersionNT = 501
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1

View Replies !   View Related
SQL Server Express Fails To Install
I have tried several times to install SSEE and SSEE
with Advanced Services. Each time it fails early in the
installation. I am running XP SP2 with 1GB memory. There
was no previous install of SSEE. The error reads, "SQL Server
Setup unexpectedly fialed. For more information, review the Setup
summary log file...". The log file follows:



Microsoft SQL Server 2005 Setup beginning at Thu May 04 20:58:25 2006

Process ID : 2000

c:a9b2b8f496f31ae4f8a6setup.exe Version: 2005.90.2047.0

Running: LoadResourcesAction at: 2006/4/4 20:58:24

Complete: LoadResourcesAction at: 2006/4/4 20:58:24, returned true

Running: ParseBootstrapOptionsAction at: 2006/4/4 20:58:24

Loaded DLL:c:a9b2b8f496f31ae4f8a6xmlrw.dll Version:2.0.3609.0

Complete: ParseBootstrapOptionsAction at: 2006/4/4 20:58:25, returned false

Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:

Could not parse command line due to datastore exception.

Source File Name: utillibpersisthelpers.cpp

Compiler Timestamp: Wed Oct 26 16:38:20 2005

Function Name: writeEncryptedString

Source Line Number: 124

----------------------------------------------------------

writeEncryptedString() failed

Source File Name: utillibpersisthelpers.cpp

Compiler Timestamp: Wed Oct 26 16:38:20 2005

Function Name: writeEncryptedString

Source Line Number: 123

----------------------------------------------------------

Error Code: -2146893813

Windows Error Text: Key not valid for use in specified state.



Source File Name: cryptohelpercryptsameusersamemachine.cpp

Compiler Timestamp: Wed Oct 26 16:37:25 2005

Function Name: sqls::CryptSameUserSameMachine::ProtectData

Source Line Number: 50



2148073483

Could not skip Component update due to datastore exception.

Source File Name: datastorecachedpropertycollection.cpp

Compiler Timestamp: Wed Oct 26 16:37:20 2005

Function Name: CachedPropertyCollection::findProperty

Source Line Number: 130

----------------------------------------------------------

Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2000"} in cache

Source File Name: datastorepropertycollection.cpp

Compiler Timestamp: Wed Oct 26 16:37:21 2005

Function Name: SetupBootstrapOptionsScope.InstallMediaPath

Source Line Number: 44

----------------------------------------------------------

No collector registered for scope: "SetupBootstrapOptionsScope"

Running: ValidateWinNTAction at: 2006/4/4 20:58:25

Complete: ValidateWinNTAction at: 2006/4/4 20:58:25, returned true

Running: ValidateMinOSAction at: 2006/4/4 20:58:25

Complete: ValidateMinOSAction at: 2006/4/4 20:58:25, returned true

Running: PerformSCCAction at: 2006/4/4 20:58:25

Complete: PerformSCCAction at: 2006/4/4 20:58:25, returned true

Running: ActivateLoggingAction at: 2006/4/4 20:58:25

Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:

Datastore exception while trying to write logging properties.

Source File Name: datastorecachedpropertycollection.cpp

Compiler Timestamp: Wed Oct 26 16:37:20 2005

Function Name: CachedPropertyCollection::findProperty

Source Line Number: 130

----------------------------------------------------------

Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache

Source File Name: datastorepropertycollection.cpp

Compiler Timestamp: Wed Oct 26 16:37:21 2005

Function Name: SetupStateScope.primaryLogFiles

Source Line Number: 44

----------------------------------------------------------

No collector registered for scope: "SetupStateScope"

00DECFC0Unable to proceed with setup, there was a command line parsing error. : 2

Error Code: 0x80070002 (2)

Windows Error Text: The system cannot find the file specified.



Source File Name: datastorepropertycollection.cpp

Compiler Timestamp: Wed Oct 26 16:37:21 2005

Function Name: SetupBootstrapOptionsScope.InstallMediaPath

Source Line Number: 44



Class not registered.

View Replies !   View Related
Install Fails On X64 Cluster Nodes.
I can't seem to install SQL Server 2005 (x64 version) on an x64 Win2k3 two node cluster.

I get all the way through the configuration and setup fails because it cannot start a task on the remote node. The error message indicates to check the task scheduler log file, which I have and I cannot find any 'errors' in the file.

Google/MSDN/Technet turn up nothing on multiple searches. Has anyone else run into this problem?

My installation account is a local admin on both machines, so is the sql cluster account. For the life of me I cannot figure out what's different for an x64 install vs 32bit....

View Replies !   View Related
SQL Server 2005 (x64) Sp2 Fails To Install
Hello,


Service Pack 2 fails to install using the Microsoft Update site. After clicking "Find solution", I got directed here.



The only error is with the DatabaseServices (Relevant bits from the logfile):




Code Snippet

----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

----------------------------------------------------------------------------------




This refers to another logfile (yet again, just the interesting bits):




Code Snippet

Property(S): SQL200564Hotfix3042 = d:f13bd9da239b4b5240e6HotFixSQLFilessqlrun_sql.msp
MSI (s) (FC:C0) [16:56:04:243]: Product: Microsoft SQL Server 2005 (64-bit) - Update 'Service Pack 2 for SQL Server Database Services 2005 (64-bit) ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log.

MSI (s) (FC:C0) [16:56:04:243]: Note: 1: 1729
MSI (s) (FC:C0) [16:56:04:243]: Transforming table Error.

MSI (s) (FC:C0) [16:56:04:243]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (FC:C0) [16:56:04:243]: Transforming table Error.

MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.

MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.

MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.

MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.

MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.

MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.

MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (FC:C0) [16:56:04:274]: Transforming table Error.

MSI (s) (FC:C0) [16:56:04:274]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (FC:C0) [16:56:04:274]: Transforming table Error.

MSI (s) (FC:C0) [16:56:04:274]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (FC:C0) [16:56:04:274]: Product: Microsoft SQL Server 2005 (64-bit) -- Configuration failed.

MSI (s) (FC:C0) [16:56:04:274]: Attempting to delete file C:WINDOWSInstaller199c46.msp
MSI (s) (FC:C0) [16:56:04:274]: Unable to delete the file. LastError = 32
MSI (s) (FC:C0) [16:56:04:274]: Cleaning up uninstalled install packages, if any exist
MSI (s) (FC:C0) [16:56:04:274]: MainEngineThread is returning 1603
MSI (s) (FC:0C) [16:56:04:289]: Destroying RemoteAPI object.
MSI (s) (FC:68) [16:56:04:289]: Custom Action Manager thread ending.
=== Logging stopped: 8-5-2007 16:56:04 ===
MSI (c) (9C:8C) [16:56:04:289]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (9C:8C) [16:56:04:289]: MainEngineThread is returning 1603
=== Verbose logging stopped: 8-5-2007 16:56:04 ===





I've checked the locations of the file, and they are all installed in the default folder:



%PROGRAMFILES%Microsoft SQL ServerMSSQL.1MSSQLData



Is there a way toget it to install anyways? Manually trying to install it hasthe exact same resultas Microsoft Update. Everything EXCEPT the DataBase Services is upgraded.



What's the problem in this case?

View Replies !   View Related
SP2 Fails During Full-text Install
Got this error trying to install the service pack on one of my boxes. Any help?

02/19/2007 11:19:59.890 Copy Engine: Error, unable to install MSP file: c:d758bb9ef6e34b2a3f5f9e0f043495cfHotFixSQLFilessqlrun_sql.msp
02/19/2007 11:19:59.937 The following exception occurred: Unable to install Windows Installer MSP file Date: 02/19/2007 11:19:59.937 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 800
02/19/2007 11:20:09.453 Watson: Param1 = Unknown
02/19/2007 11:20:09.500 Watson: Param2 = 0x2b18
02/19/2007 11:20:09.546 Watson: Param3 = Unknown
02/19/2007 11:20:09.578 Watson: Param4 = 0x0
02/19/2007 11:20:09.625 Watson: Param5 = copyengine.cpp@800
02/19/2007 11:20:09.671 Watson: Param6 = Unknown
02/19/2007 11:20:09.703 Watson: Param7 = SQL9
02/19/2007 11:20:09.750 Watson: Param8 = Hotfix@
02/19/2007 11:20:09.812 Watson: Param9 = x86
02/19/2007 11:20:09.921 Watson: Param10 = 3042
02/19/2007 11:20:10.062 Installed product: SQL9

View Replies !   View Related
SQL Server 2005 SP2 Fails On Install
I am trying to install Sql Server 2005 SP2 (KB921896) on a Windows Server 2003 box that has all the other patches installed. However, the service pack fails on Databse Services and Analysis Serrvices. The Summary.txt file is listed below. I have already done some research and tried putting the NT Authority/SYSTEM in the local Administrators group but I still get the same error. Can anyone help?
Thanks
Time: 06/21/2007 15:30:09.610
KB Number: KB921896
Machine: PDSQL
OS Version: Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.2.3042 x86
Database Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 STANDARD
Analysis Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 STANDARD
Reporting Services (MSSQLSERVER) ENU SP2 9.00.3054.00 x86 STANDARD
Notification Services ENU SP2 9.00.3054.00 x86 STANDARD
Integration Services ENU SP2 9.00.3054.00 x86 STANDARD
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU SP2 9.2.3054 x86 STANDARD
MSXML 6.0 Parser ENU 6.10.1129.0 x86
SQLXML4 ENU 9.00.3042.00 x86
Backward Compatibility ENU 8.05.2004 x86
Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86

**********************************************************************************
Products Disqualified & Reason
Product Reason
Reporting Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates.
Notification Services The product instance NS been patched with more recent updates.
Integration Services The product instance Integration Services been patched with more recent updates.
Client Components The product instance SQL Tools been patched with more recent updates.

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
msftesql Database Services Service NT AUTHORITYSYSTEM 3464
SQLBrowser Database Services Service NT AUTHORITYSYSTEM 5276

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29512
Error Description : MSP Error: 29512 SQL Server Setup was unable add user NT AUTHORITYSYSTEM to local group PERSONNELALSQLServer2005SQLAgentUser$PDSQL$MSSQLSERVER.
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 29512
Error Description : MSP Error: 29512 SQL Server Setup was unable add user NT AUTHORITYSYSTEM to local group PERSONNELALSQLServer2005MSOLAPUser$PDSQL$MSSQLSERVER.
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance MSSQLSERVER been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance NS been patched with more recent updates.
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance Integration Services been patched with more recent updates.
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 3054
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance SQL Tools been patched with more recent updates.
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29512

View Replies !   View Related
SQL Server Express Fails To Install
Hi, there!

I tried to install SSE 2005 and I got the following message:

SQL Server Setup unexpectedly failed. For more information, review the Setup summary log file in...

The log file has the content below. Can someone help meto fix this problem, please?

I have no idea about what is going on!

Thank you for the help!

Microsoft SQL Server 2005 Setup beginning at Sun Jul 23 12:52:54 2006
Process ID : 2420
c:97830b63babac24aedb48a81be43976asetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/6/23 12:52:53
Complete: LoadResourcesAction at: 2006/6/23 12:52:53, returned true
Running: ParseBootstrapOptionsAction at: 2006/6/23 12:52:53
Loaded DLL:c:97830b63babac24aedb48a81be43976axmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/6/23 12:52:54, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2420"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/6/23 12:52:54
Complete: ValidateWinNTAction at: 2006/6/23 12:52:54, returned true
Running: ValidateMinOSAction at: 2006/6/23 12:52:54
Complete: ValidateMinOSAction at: 2006/6/23 12:52:54, returned true
Running: PerformSCCAction at: 2006/6/23 12:52:54
Complete: PerformSCCAction at: 2006/6/23 12:52:54, returned true
Running: ActivateLoggingAction at: 2006/6/23 12:52:54
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00E2CFC4Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2420"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

View Replies !   View Related
Install Fails On SQL2k5 Because No IIS On Server
We have a new cluster that we are trying to install SQL 2k5 enterprise on and the security requirements will not allow us to install IIS on the same server as SQL. Is there a way around the requirement of having IIS installed on the server with SQL 2k5?

View Replies !   View Related
SQL Server And Express Install Fails
I have a server version of SQL Server, but I need a local SQL Server Express version as well for dev.

When I install express and the full set of SQL Server management tools, I can see my Express instance in configuration manager, but Management Studio says the instance is broken. I have tried both SA and windows authentication. I turned on all the protocols in both server and client, but no luck.

The error returnedis Error 26Error locating server instance specified, but I am selecting the instance from the dropdown box, so it is not a typo. I have tried quite a few variations with no success.

The install is on XP-pro

Thanks,

Michael

View Replies !   View Related
SQL Express Install Fails With Message About COM+
Hi There

I am trying to install SQL express with the /qb switch. It fails with

To install Microsoft SQL Server 2005, COM+ should work.

However running the install just by double clicking sqlexpr.exe the install is successfull

This is still an issue for me as I will be distributing Express and I need an install that works in /qb mode

Has this issue come up before? Any ideas?

Many thanks

Chris Lennon

View Replies !   View Related
Install Of Express 200 Advanced Sp1 Fails
Had intial release installed; deleted it and associated software, and downloaded advanced, sp1 and mgmt. studio sp1.

Go to install and get just warnings(2-IIS and hardware);install goes on
then fails; look at log and it says my system doesn't meet minimum
hardware requirements.

Look at hardware requirements on readme and at MS and my system DOES
meet 'minumum reuquirements'; he only thing close is the 512 mb minimum
memory which is what my system has, 512mb memory.

1.7 P4, 30 gig of hard drive space,.net2.0,win2k with SP4,etc..

Anyone know what a workaround is or is this a 'bug'?

View Replies !   View Related
SQL Server 2005 Fails To Install
I'm having a problem installing SQL Server 2005 and I hope someone can give me an idea how to proceed. I have two machines and it works fine on one but fails to install on the other. The maddening thing is that the message reporting the failure gives me absolutely no feedback other than that the install failed.

I downloaded VB 2005 Express with MSDN and SQL Server 2005 Express. The .NET framework, VB and MSDN installed fine and then it failed on SQL Server. I have uninstalled and tried again several times with the same results. There's nothing unusual about my PC. It's relatively new with plenty of memory and disk storage. It's a Dell PC with a 2.4GHZ processor. There is another database product running on this system. Is that likely to be an issue?

View Replies !   View Related
SQL Server Express Fails To Install
I'm experiencing a problem installing SQL Server Express 2005. I thought I had the same problem as Tom from a recent thread but his error file is quite different from mine. The Visual Basic Express
package properly installed everything except SQL Server. I've run
it many times, but the service fails
to start. I also downloaded the separate installation package for
SQL Server Express and ran it several times, which also failed.
It gets to a point where the services are installed, but when I try to
manually start the SQL service it says that the service started and
then stopped. The event
viewer shows this error:

Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.

The error log is:

2006-05-02 16:10:58.07 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2006-05-02 16:10:58.08 Server (c) 2005 Microsoft Corporation.
2006-05-02 16:10:58.08 Server All rights reserved.
2006-05-02 16:10:58.09 Server Server process ID is 816.
2006-05-02 16:10:58.09 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2006-05-02 16:10:58.09 Server This instance of SQL Server last reported using a process ID of 2748 at 5/2/2006 4:10:29 PM (local) 5/2/2006 9:10:29 PM (UTC). This is an informational message only; no user action is required.
2006-05-02 16:10:58.15 Server Registry startup parameters:
2006-05-02 16:10:58.15 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2006-05-02 16:10:58.15 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2006-05-02 16:10:58.16 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2006-05-02 16:10:58.28 Server Error: 17311, Severity: 16, State: 1.
2006-05-02 16:10:58.28 Server SQL Server is terminating because of fatal exception c000001d. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
2006-05-02 16:10:58.30 Server Using 'dbghelp.dll' version '4.0.5'
2006-05-02 16:10:58.36 Server **Dump thread - spid = 0, PSS = 0x00000000, EC = 0x00000000
2006-05-02 16:10:58.36 Server ***Stack Dump being sent to c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0005.txt
2006-05-02 16:10:58.36 Server * *******************************************************************************
2006-05-02 16:10:58.36 Server *
2006-05-02 16:10:58.36 Server * BEGIN STACK DUMP:
2006-05-02 16:10:58.36 Server * 05/02/06 16:10:58 spid 0
2006-05-02 16:10:58.36 Server *
2006-05-02 16:10:58.36 Server * ex_handle_except encountered exception C000001D - Server terminating
2006-05-02 16:10:58.36 Server *
2006-05-02 16:10:58.36 Server *
2006-05-02 16:10:58.36 Server * MODULE BASE END SIZE
2006-05-02 16:10:58.36 Server * sqlservr 01000000 02BCEFFF 01bcf000
2006-05-02 16:10:58.36 Server * ntdll 7C900000 7C9AFFFF 000b0000
2006-05-02 16:10:58.36 Server * kernel32 7C800000 7C8F3FFF 000f4000
2006-05-02 16:10:58.36 Server * MSVCR80 78130000 781CAFFF 0009b000
2006-05-02 16:10:58.36 Server * msvcrt 77C10000 77C67FFF 00058000
2006-05-02 16:10:58.37 Server * MSVCP80 7C420000 7C4A6FFF 00087000
2006-05-02 16:10:58.37 Server * ADVAPI32 77DD0000 77E6AFFF 0009b000
2006-05-02 16:10:58.37 Server * RPCRT4 77E70000 77F00FFF 00091000
2006-05-02 16:10:58.37 Server * USER32 77D40000 77DCFFFF 00090000
2006-05-02 16:10:58.37 Server * GDI32 77F10000 77F56FFF 00047000
2006-05-02 16:10:58.37 Server * CRYPT32 77A80000 77B13FFF 00094000
2006-05-02 16:10:58.37 Server * MSASN1 77B20000 77B31FFF 00012000
2006-05-02 16:10:58.37 Server * Secur32 77FE0000 77FF0FFF 00011000
2006-05-02 16:10:58.37 Server * MSWSOCK 71A50000 71A8EFFF 0003f000
2006-05-02 16:10:58.37 Server * WS2_32 71AB0000 71AC6FFF 00017000
2006-05-02 16:10:58.37 Server * WS2HELP 71AA0000 71AA7FFF 00008000
2006-05-02 16:10:58.37 Server * USERENV 769C0000 76A72FFF 000b3000
2006-05-02 16:10:58.37 Server * opends60 333E0000 333E6FFF 00007000
2006-05-02 16:10:58.37 Server * NETAPI32 5B860000 5B8B3FFF 00054000
2006-05-02 16:10:58.37 Server * SHELL32 7C9C0000 7D1D4FFF 00815000
2006-05-02 16:10:58.37 Server * SHLWAPI 77F60000 77FD5FFF 00076000
2006-05-02 16:10:58.37 Server * OCMAPIHK 10000000 1000CFFF 0000d000
2006-05-02 16:10:58.37 Server * comctl32 773D0000 774D1FFF 00102000
2006-05-02 16:10:58.37 Server * comctl32 5D090000 5D126FFF 00097000
2006-05-02 16:10:58.37 Server * psapi 76BF0000 76BFAFFF 0000b000
2006-05-02 16:10:58.37 Server * instapi 48060000 48069FFF 0000a000
2006-05-02 16:10:58.37 Server * sqlevn70 4F610000 4F7A3FFF 00194000
2006-05-02 16:10:58.37 Server * dbghelp 03000000 03112FFF 00113000
2006-05-02 16:10:58.37 Server *
2006-05-02 16:10:58.37 Server * Edi: 0075C528: 000E1068 00000000 00000000 00000000 0075C548 00000000
2006-05-02 16:10:58.37 Server * Esi: 00000000:
2006-05-02 16:10:58.37 Server * Eax: 0075C40C: 000042AC 00000000 00000000 7C81EB33 00000000 0000000C
2006-05-02 16:10:58.37 Server * Ebx: 0000003F:
2006-05-02 16:10:58.38 Server * Ecx: 0075CA7C: 00000000 0001001F 00000000 00000000 00000000 00000000
2006-05-02 16:10:58.38 Server * Edx: 0000003D:
2006-05-02 16:10:58.38 Server * Eip: 7C81EB33: 10C2C95E 0FFF8500 FED0E68E FC558BFF 0F0C5589 7D8B16B7
2006-05-02 16:10:58.38 Server * Ebp: 0075C45C: 0075C4A0 02187744 000042AC 00000000 00000000 00000000
2006-05-02 16:10:58.38 Server * SegCs: 0000001B:
2006-05-02 16:10:58.38 Server * EFlags: 00080246:
2006-05-02 16:10:58.38 Server * Esp: 0075C408: 00000000 000042AC 00000000 00000000 7C81EB33 00000000
2006-05-02 16:10:58.38 Server * SegSs: 00000023:
2006-05-02 16:10:58.38 Server * *******************************************************************************
2006-05-02 16:10:58.38 Server * -------------------------------------------------------------------------------
2006-05-02 16:10:58.38 Server * Short Stack Dump
2006-05-02 16:10:58.50 Server 7C81EB33 Module(kernel32+0001EB33)
2006-05-02 16:10:58.50 Server 02187744 Module(sqlservr+01187744)
2006-05-02 16:10:58.51 Server 0218B600 Module(sqlservr+0118B600)
2006-05-02 16:10:58.51 Server 0218B1AD Module(sqlservr+0118B1AD)
2006-05-02 16:10:58.51 Server 023F4109 Module(sqlservr+013F4109)
2006-05-02 16:10:58.51 Server 7C862CD3 Module(kernel32+00062CD3)
2006-05-02 16:10:58.57 Server 7C83AA6B Module(kernel32+0003AA6B)
2006-05-02 16:10:58.60 Server Stack Signature for the dump is 0xDF483EDE
2006-05-02 16:10:59.33 Server External dump process return code 0x20000001.
External dump process returned no errors.

Any thoughts? Thanks.

View Replies !   View Related
MSDE Install Fails - Rollback Occurs
Hi,

I'm trying to install MSDE (sql2ksp3) on my XP machine. When it gets to the end of the install, it stops and rolls back. Any idea why this would be happening? I also have MDAC 2.8 installed. Following is last few lines of install log:

********************************
Property(C): DATABASE = C:DOCUME~1MLyonLOCALS~1Temp1a89e2.msi
Property(C): OriginalDatabase = C:sql2ksp3MSDESetupSqlRun01.msi
Property(C): UILevel = 3
Property(C): ACTION = INSTALL
=== Logging stopped: 11/11/2003 16:25:06 ===
MSI (c) (70:84): Note: 1: 1708
MSI (c) (70:84): Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.

MSI (c) (70:84): Grabbed execution mutex.
MSI (c) (70:84): Cleaning up uninstalled install packages, if any exist
MSI (c) (70:84): MainEngineThread is returning 1603
=== Verbose logging stopped: 11/11/2003 16:25:06 ===
********************************

Thanks in advance.

View Replies !   View Related
SQL Server Agent Fails To Start. Install ?
Two NT accounts have been created on the server.
MSSQLSERVER
MSSQLSERVERAGENT

These accounts have been given:
a. logon rights
b. unchangeable passwords
c. passwords which never expire
d. NT admin rights

Questions:

a. Do I have to create a login account within SQL Server 7 itself for these accounts?
b. Must the properties for "this account' box on the general tab include the domain name?
c. If the answer to (b) is yes, then can I use ".MSSQLSERVERAGENT" in the "this account"
box on the general tab?
d. Does the SQL Server Agent function require the "BUILTINadministrators" login in order
to work?

Any help in figuring out why I can't get my SQL Server Agent to startup will be appreciated!!

View Replies !   View Related
NT 4.0 Trial Install Fails To Register DLLs
In attempting to perform a "typical desktop" install to an NT 4.0 workstation,
install fails to register about 10 DLLs.

i.e. dtspkg.dll, dtspump.dll, msrpjt40.dll, dbscan.dll

As best as I know, the msrpjt40.dll already existed and had a version date of
11-11-98 9:51 P.M.

While the SQLSTP.LOG shows me they failed to register, I don't know why
they failed to register.

Any ideas, comments, etc. would be appreciated.

Thanks!!

View Replies !   View Related
SQL2005 Workgroup Edition Install Fails


Hi all,

I am trying to install the workgroup edition on Windows SBS 2003 R2. After the removal of an unwanted
SQL Express Edition installation -the standard install of SQL 2005 from CD hangs during setup.

In the log file _WI.log is:
...
MSI (s) (B0:2C) [23:01:14:968]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (B0:2C) [23:01:14:968]: MsiProvideAssembly is returning: 1607
MSI (s) (B0:2C) [23:01:14:968]: No System Restore sequence number for this installation.
MSI (s) (B0:2C) [23:01:14:968]: Unlocking Server
MSI (s) (B0:2C) [23:01:14:968]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'.
MSI (s) (B0:2C) [23:01:15:015]: MainEngineThread is returning 1603
MSI (s) (B0:A0) [23:01:15:109]: Destroying RemoteAPI object.
MSI (s) (B0:80) [23:01:15:109]: Custom Action Manager thread ending.
MSI (c) (B4:54) [23:01:15:125]: Back from server. Return value: 1603
MSI (c) (B4:54) [23:01:15:125]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (B4:54) [23:01:15:125]: PROPERTY CHANGE: Deleting SECONDSEQUENCE property. Its current value is '1'.
Aktion beendet um 23:01:15: ExecuteAction. Rückgabewert 3.
MSI (c) (B4:54) [23:01:15:125]: Skipping action: FatalError (condition is false)
Aktion beendet um 23:01:15: INSTALL. Rückgabewert 3.

Any advice would be great!


THufschmidt

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved