I Could Not Install SQL Successfully, Gave An Error Log

Mar 22, 2007

2007-03-22 09:36:52.39 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: )

2007-03-22 09:36:52.45 server Copyright (C) 1988-2000 Microsoft Corporation.
2007-03-22 09:36:52.45 server All rights reserved.
2007-03-22 09:36:52.45 server Server Process ID is 1516.
2007-03-22 09:36:52.45 server Logging SQL Server messages in file 'd:Program FilesMicrosoft SQL ServerMSSQLlogERRORLOG'.
2007-03-22 09:36:52.57 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2007-03-22 09:36:53.26 server SQL Server configured for thread mode processing.
2007-03-22 09:36:53.48 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2007-03-22 09:36:54.31 server Attempting to initialize Distributed Transaction Coordinator.
2007-03-22 09:36:56.46 spid3 Warning ******************
2007-03-22 09:36:56.46 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2007-03-22 09:36:56.60 spid3 Starting up database 'master'.
2007-03-22 09:36:57.26 spid3 Server name is 'PRECISE'.
2007-03-22 09:36:57.26 server Using 'SSNETLIB.DLL' version '8.0.194'.
2007-03-22 09:36:57.26 spid5 Starting up database 'model'.
2007-03-22 09:36:57.60 spid5 Clearing tempdb database.
2007-03-22 09:36:57.74 spid7 Starting up database 'msdb'.
2007-03-22 09:36:57.85 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:57.89 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:57.89 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:57.89 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:58.31 server SQL server listening on TCP, Shared Memory, Named Pipes.
2007-03-22 09:36:58.31 server SQL server listening on 195.195.195.2:1433, 127.0.0.1:1433.
2007-03-22 09:36:58.31 server SQL Server is ready for client connections
2007-03-22 09:36:58.35 spid7 Starting up database 'pubs'.
2007-03-22 09:36:58.64 spid7 Starting up database 'Northwind'.
2007-03-22 09:37:00.18 spid5 Starting up database 'tempdb'.
2007-03-22 09:37:00.32 spid3 Recovery complete.
2007-03-22 09:37:00.32 spid3 Warning: override, autoexec procedures skipped.
2007-03-22 09:37:07.95 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

View 1 Replies

Completed Successfully, But Not Sending And No Error.

Sep 6, 2006

hi, i have a message queue system using sql 2005 service broker.
the code and setup is the same on both dev and live database. but
soon after i restored a live backup to dev. the queue stopped
working on dev, live is ok thou. after some trouble shooting, i
found that the server is not sending the message at all, but it says
"Command(s) completed successfully" without any error messages.

setup:

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

create message type TestQueryMessage validation = none

create contract TestQueryContract (TestQueryMessage sent by initiator)

create queue TestSenderQueue

create service TestSenderService on queue TestSenderQueue

create queue TestQueueReceiver

create service TestServiceReceiver on queue TestQueueReceiver (TestQueryContract)

send message:

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

declare @conversationhandle uniqueidentifier;

begin dialog @conversationhandle

from service [TestSenderService]

to service 'TestServiceReceiver'

on contract [TestQueryContract]

with encryption = off;

send on conversation @conversationhandle

message type [TestQueryMessage] ('blah blah blah');

result:

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

Command(s) completed successfully.

but when i do "select * from TestQueueReceiver", there's nothing. and i sure nothing else had picked up the messages.

please advise. thanks a lot.

View 1 Replies View Related

SQL Server 2005 SP1 Error--No Passive Nodes Were Successfully

Oct 16, 2007

Hello All,

I have a database cluster which I am trying to upgrade to SP1+hotfixes. I was able to successfully upgrade to SP1, however when I try to apply the hotfix "sql2005-kb918222-x86-enu.exe". The install fails and generates the following error log; Can anyone please help? Thanks a lot.

10/16/2007 09:35:50.058 ================================================================================
10/16/2007 09:35:50.058 Hotfix package launched
10/16/2007 09:35:52.495 Product discovery successfully completed during the install process for MSSQLSERVER
10/16/2007 09:35:52.495 SP Level check successfully completed during the install process for MSSQLSERVER
10/16/2007 09:35:52.527 Product language check successfully completed during the install process for MSSQLSERVER
10/16/2007 09:35:52.542 Product version check successfully completed during the install process for MSSQLSERVER
10/16/2007 09:35:52.558 Command-line instance name check completed during the install process
10/16/2007 09:35:52.573 Baseline build check completed during the install process
10/16/2007 09:36:15.028 Attempting to install instance: MSSQLSERVER
10/16/2007 09:36:15.059 Enumerating passive cluster nodes
10/16/2007 09:36:15.090 Patching available passive node: SNTCCASGDB006
10/16/2007 09:36:15.106 Waiting for first successfully completed passive node
10/16/2007 09:36:15.121 Attempting to patch running passive node: SNTCCASGDB006
10/16/2007 09:36:15.200 Successfully created remote folder for product instance target \SNTCCASGDB006
10/16/2007 09:36:15.809 Successfully transferred payload to remote product instance target \SNTCCASGDB006
10/16/2007 09:36:15.825 Successfully transferred payload to remote product instance target \SNTCCASGDB006
10/16/2007 09:36:16.981 Successfully created new scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:17.840 Successfully saved new scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:17.872 Successfully created scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:17.887 Successfully started scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:17.903 Successfully started scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:20.934 Scheduled task for product instance target has completed
10/16/2007 09:36:20.950 Waiting for exit code from scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:25.966 Received exit code 11201 from scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:25.981 Result code for scheduled task for product instance target has been received
10/16/2007 09:36:25.997 Removed scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:26.169 Successfully removed remote folder for product instance target \SNTCCASGDB006
10/16/2007 09:36:26.185 Remote process completed for product instance target
10/16/2007 09:36:26.200 Exit code for passive node: SNTCCASGDB006 = 11201
10/16/2007 09:36:30.122 The following exception occurred: No passive nodes were successfully patched Date: 10/16/2007 09:36:30.122 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllinstance.cpp Line: 2583
10/16/2007 09:36:30.169
10/16/2007 09:36:30.200 Product Status Summary:
10/16/2007 09:36:30.232 Product: SQL Server Database Services 2005
10/16/2007 09:36:30.263 MSSQLSERVER - Failure
10/16/2007 09:36:30.310 Details: No passive nodes were successfully patched
10/16/2007 09:36:30.341

View 11 Replies View Related

Gave Up

Apr 29, 2008

i tried downloading sql server 2005 on my new laptop compaq c772tu..(windows xp) but after finishing installation i cant open it..before sql i downloaded visual studio 2008 ..does it make any difference..i already download sql 2 times and uninstall it twice ..dont know what to do..

View 5 Replies View Related

Error Access Is Denied.. Occurs After Package Successfully Completes.

Jun 4, 2007

I am getting an 'Access is denied' error:

Error 0x80070005 while loading package file "E:SSISPackagesPackage1.dtsx". Access is denied. .

The package is executed from the main package via an 'Execute Package Task' that is within a 'For Each Loop' container. The 'For each loop' goes through a single iteration as expected. The strange thing is that the error comes after 'Package1' has run successfully. I am logging the PackageStart/PackageEnd and error events and I see that Package1 ends successfully and then the "Access is denied" error occurs. The main package is launched by executing dtsexec via Process.Start() from a web page. The packages have 'SaveCheckpoints' set to True. Any ideas are welcome. Thanks.

View 7 Replies View Related

A Connection Was Successfully Established With The Server, But Then An Error Occurred During The Pre-login Handshake.

Nov 1, 2007

Hi,
I am having such a problem. I have SQL Express installed on the windows 2003 server and originally I installed instance1 of SQL Server 2005. When I installed Instance1, I remember having problems with remotely connecting to that instance1, but somehow I fixed it. Now I installed instance2 and I started having remote connection issues again with that instance2. I am able to connect to instance1 but not instance2. I checked settings for both instances and they look identical.
I turned firewall off for now. I checked TCP settings using surface area configuration (allowing both local and remote connections). I turned off VIA protocol. I specified TCP properties to use dynamic port for that instance2.
In the sql native client configuration I have the following order#: 1. Shared memory, 2. tcp, 3. np, 4. VIA(Disabled). TCP is configured to use 1433.
I have no clue about what is going on. Sometimes I am able to connect remotely and sometimes I get the following error:
"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)."
When I connect locally - everything connects fine. File sharing is also checked, it works etc...
Thanks for help!!!
GK
I just noticed that I was able to connect from different computer on the different network.

View 9 Replies View Related

A Connection Was Successfully Established With The Server, But Then An Error Occurred During The Pre-login Handshake.

Dec 4, 2006

I get the following error when trying to view my page.

Can someone please help me with this error. What does it mean and what is the solution to it? Here is the complete error message. -
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

View 9 Replies View Related

A Connection Was Successfully Established With The Server, But Then An Error Occurred During The Login Process. (provider: Share

Mar 15, 2007

I have just installed MS SQL Server 2005 Express edition along with the SSMSE. I am using windows authentication. When I open SSMSE it connects me to a 'local instance' of the server. From there I right click on Database and select to add a new Database and I get the error above. I think I only need to allow local connections to the engine but I have tried allowing remote conections with all varations of named pipes and TCP/IP. I am running on Windows XP SP2 (home).

View 1 Replies View Related

A Connection Was Successfully Established With The Server, But Then An Error Occurred During The Login Process. (provider: Shared Memory Provider, Error: 0 - No Process Is On The Other End Of The Pipe.)

Apr 7, 2008

i'm going nuts with SQL server notification thing. I have gone throigh this artical which tells how to set user http://www.codeproject.com/KB/database/SqlDependencyPermissions.aspx. This article show how to create new user and setup for sql server notification.But In my case user was alredy existing in database. which is very common senario in most cases. So i did following( check the SQL script below) but then i get this error
"A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)"
this my sql script
use [master]Go
-- Ensuring that Service Broker is enabled ALTER DATABASE [DatabaseName] SET ENABLE_BROKERGO
-- Switching to our databaseuse [DatabaseName]GO
CREATE SCHEMA schemaname AUTHORIZATION usernameGO
ALTER USER username WITH DEFAULT_SCHEMA = schemaname GO
/* * Creating two new roles. We're not going to set the necessary permissions * on the user-accounts, but we're going to set them on these two new roles. * At the end of this script, we're simply going to make our two users * members of these roles. */EXEC sp_addrole 'sql_dependency_subscriber' EXEC sp_addrole 'sql_dependency_starter'
-- Permissions needed for [sql_dependency_starter]GRANT CREATE PROCEDURE to [sql_dependency_starter] GRANT CREATE QUEUE to [sql_dependency_starter]GRANT CREATE SERVICE to [sql_dependency_starter]GRANT REFERENCES on CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] to [sql_dependency_starter] GRANT VIEW DEFINITION TO [sql_dependency_starter]
-- Permissions needed for [sql_dependency_subscriber] GRANT SELECT to [sql_dependency_subscriber] GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [sql_dependency_subscriber] GRANT RECEIVE ON QueryNotificationErrorsQueue TO [sql_dependency_subscriber] GRANT REFERENCES on CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] to [sql_dependency_subscriber]
-- Making sure that my users are member of the correct role.EXEC sp_addrolemember 'sql_dependency_starter', 'username'EXEC sp_addrolemember 'sql_dependency_subscriber', 'username'

View 10 Replies View Related

Server Was Unable To Process Request. ---&> A Connection Was Successfully Established With The Server, But Then An Error Occurred During The Pre-login Handshake.

Apr 16, 2008

I got this message from sql
"Server was unable to process request. ---> A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) "
Does anyone know what happen?
Thanks

View 8 Replies View Related

Failed To Install And Configure Error On Install

Nov 14, 2007

Hi,

I've tried looking for a solution in other threads but I couldn't find anything that was completely the same as my situation. I got a new pc at work and I've tried installing SQL Server 2005 on it but everytime I try to install it, regardless of services included or excluded with the install, I cannot get through the install without this error. Below is the excerpt from the Summary.txt log file.

Error Code: -2147024894
MSI (s) (74!98) [17:10:55:858]: Product: Microsoft SQL Server 2005 Tools -- Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Mon Nov 12 17:10:55 2007
<Func Name='Do_sqlAssemblyRegSvcs'>
Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog.
Error: 2147942402
Error message: The system cannot find the file specified.
Error descrition: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Error Code: -2147024894
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlcasqlassembly.cpp
Compiler Timestamp: Thu Aug 11 01:12:01 2005
Function Name: Do_sqlAssemblyRegSvcs
Source Line Number: 155

I've searched for and found similar problems that deal with the microsoft.sqlserver.notificationservices.dll not being found but I haven't found a fix that worked for me. These are the fixes I've refered to thus far.

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1651162&SiteID=17

http://support.microsoft.com/kb/940971

http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlcasqlassembly.cpp@Do_sqlAssemblyRegSvcs@Do_sqlAssemblyRegSvcs@x80131501

The answer that seems to fix this problem for everyone is to set the MSDTC service login as the NT AUTHORITYNetworkService account. The problem for me is that this is already set to this profile and I've tried resetting the services and rebooting the machine. I did not have a problem with my old machine, which as far as I can tell, is the same configuration, so I know this install should work.

I'm running Windows XP SP2. This is not the upgrade to SQL Server 2005 SP2, this is the original disk that came with Visual Studio 2005.

Has anyone else faced this issue where changing the MSDTC login wasn't the solution? Also, this is my first post, so I apologize if I've left anything out. Just let me know if you want any other information.

Thank you in advance.
Tim

View 7 Replies View Related

Analysis :: Gave Server Name Instead Of Local Server

Nov 18, 2015

Error 4 The project could not be deployed to the 'local' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0 .This causing the deployment error msg when trying to create cube in SSAS and not letting to create the multidimensional table--

View 8 Replies View Related

SQL Server 2005 Install Error (Error 29528. Unexpected Error While Installing Performance Counters. )

Jun 12, 2007

I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.

Extract from log:

<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).

I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.

Any ideas?

View 3 Replies View Related

Job Ends Successfully Even When It's Not True

Apr 23, 2008

Hi,
we've got this problem with some particular jobs: they look as they
ran correctly, but actually they didn't made it all through their
duties.
The problem is that this job is calling a sequence of DTS, where there
is a DTS with an ActiveX control which modifies another DTS before
launching and some other tasks: the error happens there, .
Launched from the DTS we get the error, from the job no...any idea how
we could get the correct job information?
Thank you
Daniele

View 5 Replies View Related

Verifying That A Task Completed Successfully

Oct 4, 1999

How can a tell if a tak completed succesfully from a stored procedure?

I have a task which is executed from a stored procedure. The sp_runtask only returns whether the task started successfully. How can I tell if it completed successfully?

Thanks

View 3 Replies View Related

Job Doesnt Stop After Finish Successfully

Jun 18, 2008

I have a scheduled job to run daily at 4 am. the job imports data from client side from text
files and puts data in our sql table.It takes around 1 hour.
the problem is it doesnt stops after the import process completes.so after one hour
i can see the data is imported into my sql table so thats fine but the job keeps running.
I tried observing that job's spid in activity monitor in sql 2005 but after one hour i cant even see
that spid but still job runs. its weird.and after that when i stop the job manually then it stops
saying job completed succcessfully.
that step is a last step and it uses windows cmd.my understanding is the job step doesnt
understands that it got finished. what should i do in here?? any ideas r appreciated
we are running the same job for another servers and its fine.

View 5 Replies View Related

Mission: Execute Package Task Successfully!!!

Oct 21, 2002

Currently, I'm developing an ETL program using Microsoft DTS on SQL Server 2000.

I've completed unit testing & component testing for all inner packages containing various types of executions - SQL task, ActiveX Script task, Error Handler, Transform Data task, Data Driven Query & Dynamic Properties task.

When unit & component tested, all inner package properties-"Limit the maximum number of tasks executed in parallel" is defaulted to 4.

However, the integration testing is failing because I've yet to successfully execute any of the Package tasks in the outer package, which runs & controls all inner packages from the outer package.

The error message encountered was:
---------------------------------------------------------------
| Error source: microsoft dts |
| Error description: execution was cancelled by another user. |
---------------------------------------------------------------

Please explain what might be the cause to this problem when I'm executing the outer package?

View 1 Replies View Related

A Self-generated Certificate Was Successfully Loaded For Encryption?

May 30, 2007

Log shows (on SS2005)
��A self-generated certificate was successfully loaded for encryption�?

No encryption is used. Properties of Protocol for MSSQLSERVER shows no for Force Encryption, certificates are empty

How, why, where from and what for does it get and load self-generated certificate?

View 1 Replies View Related

Query For Returning The Last Time A Specific Job Ran Successfully

Feb 18, 2008

I have a program that is automatically ran through a job. The program gets the most recent files that have been uploaded to a server. I would like to be able to query the database to see when the last time this job was ran successfully and set this date as the date to look for files newer than the last successful run date.

Could someone point me in the right direction to what tables this data is stored in on a 2005 SQL Server Database?

View 3 Replies View Related

SSIS Pkg Run Successfully But Data Does Not Load Compelety..

Apr 18, 2007

I have this data in a flat file and I'm doing a data dump to a SQL table. I created a SSIS package which ran successfully but only exporting 2 rows out of 4 rows to the SQL table. For some reason my package ignore two other rows where "col4", "col5" and "col6" do not have any data. No conditional component was used in this package to not to load those records.

col1 col2 col3 col4 col4 col5 col6

849833 02/15/06 841 VS 791 49 7
849819 02/15/06 212 NA

949070 02/15/06 230 ABS

700010 02/15/06 820 VS 690 46 6

Any idea? Thanks.

View 8 Replies View Related

11009 No Passive Nodes Were Successfully Patched

Feb 29, 2008

I'm in the process of installing Hotfix kb934458 (9.0.3054) on a Windows 2003 R2 SP2 Server. This is for SQL 2005 on a Active/Passive cluster with 2 instances. I'm only getting this error on the Database Engine and Analysis Services. It was successful for Integration Services, Reporting Services and Notification Services. I've tried taking the 2 instances offline as well as tried installing from the Active then again on the Passive nodes. No luck... Any suggestions? Does this work for R2 release of Windows 2003 SP2? This is the log:

Time: 02/29/2008 14:02:38.088
KB Number: KB934458
Machine:
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3054
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
SQL Server Database Services 2005 (BIZTALK) ENU SP2 2005.090.3050.00 x64 ENTERPRISE
SQL Server Analysis Services 2005 (BIZTALK) ENU SP2 2005.090.3050.00 x64 ENTERPRISE
SQL Server Reporting Services 2005 (BIZTALK) ENU SP2 9.00.3054.00 x64 ENTERPRISE
SQL Server Database Services 2005 (SHAREPOINT) ENU SP2 2005.090.3050.00 x64 ENTERPRISE
SQL Server Analysis Services 2005 (SHAREPOINT) ENU SP2 2005.090.3050.00 x64 ENTERPRISE
SQL Server Reporting Services 2005 (SHAREPOINT) ENU SP2 9.00.3054.00 x64 ENTERPRISE
SQL Server Notification Services 2005 ENU SP2 9.00.3054.00 x64 ENTERPRISE
SQL Server Integration Services 2005 ENU SP2 9.00.3054.00 x64 ENTERPRISE
SQL Server Tools and Workstation Components 2005 ENU SP2 9.2.3054 x64 ENTERPRISE
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
MSSQL$BIZTALK SQL Server Database Services Service 4756
MSSQL$SHAREPOINT SQL Server Database Services Service 4636
MSOLAP$BIZTALK Analysis Services Service 7976
MSOLAP$SHAREPOINT Analysis Services Service 7148
**********************************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (BIZTALK)
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
----------------------------------------------------------------------------------
Product : SQL Server Analysis Services 2005 (BIZTALK)
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
----------------------------------------------------------------------------------
Product : SQL Server Reporting Services 2005 (BIZTALK)
Product Version (Previous): 3054
Product Version (Final) :
Status : Not Selected
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Database Services 2005 (SHAREPOINT)
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
----------------------------------------------------------------------------------
Product : SQL Server Analysis Services 2005 (SHAREPOINT)
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
----------------------------------------------------------------------------------
Product : SQL Server Reporting Services 2005 (SHAREPOINT)
Product Version (Previous): 3054
Product Version (Final) :
Status : Not Selected
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Notification Services 2005
Product Version (Previous): 3054
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Integration Services 2005
Product Version (Previous): 3054
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Tools and Workstation Components 2005
Product Version (Previous): 3054
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009

View 8 Replies View Related

Recovery :: AlwaysOn Cluster Did Not Fail Over Successfully

Aug 14, 2015

I have had a serious issue with a production AlwaysOn cluster whereby the service did not successfully transition to the secondary node and I cannot find the root cause of the issue.

Some details: It is a 2 node cluster (same datacenter) with a shared disk quorum, Windows Server 2012, both are virtual machines running on VMWare vSphere 5.5. SQL Server version is 2012 Enterprise SP2 CU6

The failover occurred because of a network incident (a spanning tree recalculation caused a connection timeout between both nodes). Initial entries in the SQL Log look normal for this event, for example:

05/08/2015 11:18:06: A connection timeout has occurred on a previously established connection to availability replica 'FIN-IE-PA078' with id [6910F4A9-87E7-4836-BA79-0F41BE90266D]. Either a networking or a firewall issue exists or the availability replica has transitioned to the resolving role.
05/08/2015 11:18:06: AlwaysOn Availability Groups connection with secondary database terminated for primary database 'UserManagement' on the availability replica with Replica ID: {6910f4a9-87e7-4836-ba79-0f41be90266d}. This is an informational message only. No user action is required.

[code]....

My interpretation of this is that the cluster failover attempts failed, because the network condition still persisted. The network interruption lasted approximately 2 minutes, and I would have expected the cluster to come back online at this point, after the restart delay period as suggested in the last entry in the error log. However this did not happen.

View 10 Replies View Related

Rolling Back Transaction After .Commit() Runs Successfully

Jun 10, 2007

I have a page that runs a transaction correctly after a button click.
I want to allow someone to click a button that rolls back the transaction, after the transaction runs on the first button click.
I can also successfully roll back within the first button click.
I'm getting a NullReference error when trying to access SqlTransaction.Rollback() outside the button click.
If SqlTransaction.Commit() completes without error can SqlTransaction.Rollback() be called after?
I tried making 'trans' a more global variable and it still gave me the error.
Button Click 1:
Dim trans As SqlTransaction
trans = connection.BeginTransaction()
try
'run SQL Statement
trans.Commit()
Catch e As Exception
trans.Rollback()
throw e
end try

Button Click 2:
trans.Rollback()

View 4 Replies View Related

SQL 2012 :: How To Make SSIS Package Execute Successfully

Dec 5, 2014

Currently I am running a SSIS package scheduled daily at 7 A.M. It expects two feed files from two different folders. The first step in my package will rename the input files in those folders to names which the package can understand. I have created two variables in my package to read the files with those file names. I used these variables in connection managers.

If any of these folders doesn't have input files when the package runs, the package will fail.how to make the package the run successfully even there is no input feed?

View 3 Replies View Related

Access Is Denied Occurs After Package Successfully Completes.

Apr 21, 2008

I am getting an 'Access is denied' error:

Error 0x80070005 while loading package file "Package.dtsx". Access is denied. .

The package is executed from the main package via an 'Execute Package Task'. The strange thing is that the error comes after 'Package.dtsx' has run successfully. I am logging the PackageStart/PackageEnd and error events and I see that Package.dtsx ends successfully and then the "Access is denied" error occurs. The main package is launched by executing dtsexec via a SQL Server Agent Job. The packages have 'SaveCheckpoints' set to True. Any ideas are welcome. Thanks.

View 7 Replies View Related

Is There Anyone Who Was Able To Successfully Retrieve A Full Result Set In Execute SQL Task?

Jun 6, 2007

Hi guys

Is there anyone who was able to successfully retrieve a full result set? I'm really having troubles getting the result after executing my query. Its really even hard to get sample codes over the net.

Please help guys.

Thanks in advance.

kix

View 6 Replies View Related

SQL Server 2014 :: How To Roll Back All Changes If Not All Statements Executed Successfully

Oct 15, 2015

I have a script contains multiple statements to update multiple tables. How can I make sure that either all statements get executed successfully or no changes apply to the tables (in case one or more errors occur)? I've been searching on Internet and it seems like I need to use Rollback and begin transaction.

View 5 Replies View Related

SQL DTS Query Using WHILE Statement Successfully Executes (only Updating 200 Of 1494 Records)

Jul 23, 2005

I am running a DTS Package.I have a temp table with 1494 records. I am inserting a 'Y' or'N'into a temp table #HasClaims.The TempTable name with the Provider Id's(PRPR_ID) is#TempFACETSNODupesThe @identityID is an identity field counting back from 1494 to 1I count back from the Max value of the identityid (1494) in the Whileloop until I get through all the records. The idea is to check for theexistance of a claims and authorization record and put a 'Y' or 'N'record in the temptable #HasClaims.This is running in the Execute SQL Task object of the DTS Package.The Package runs successfully but only inserts 200 rows into the newtemp table. There should be a row for each provider. Each time itruns, the number of rows it returns is different. Sometimes it is 205,then 185, then 210, before it completes the DTS package.Has anyone run into While looping problems within an Execute SQL taskin a DTS package(SQL 2000)like this--------------------------------------------------------------SELECT @identityID = MAX(IDENTITYID) FROM #TempFACETSNODupesWhile @identityID >= 1BEGIN@PRPRID is the placeholder for the PRPR_ID (Provider)SELECT @PRPRID = PRPR_ID FROM #TempFACETSNODupes WHERE IDENTITYID =@identityIDIF exists( SELECT CLCL_ID FROM dbo.CMC_CLCL_CLAIM CLCL WHERECLCL.PRPR_ID = @PRPRID)BEGININSERT INTO #HasClaims (PRPR_ID, HasClaims, IdentityID)VALUES( @PRPRID, 'Y', @identityID)ENDELSE INSERT INTO #HasClaims (PRPR_ID, HasClaims, IdentityID)VALUES( @PRPRID, 'N', @identityID)------------------------------------------------------------SELECT @identityID = @identityID - 1END

View 7 Replies View Related

SQL Server Admin 2014 :: Scheduled Job Runs Successfully But Table Does Not Update

Jun 25, 2015

I have a job scheduled that imports a table from a Oracle database. The job runs at 3am and reports success. But for some reason when i query the table to see how many records there are, I see the same row count as the day before (it should increase everyday- student enrollment). When i execute the package manually, the table updates fine.

SQL Server 2014/Win7 x64.

View 7 Replies View Related

SQL Server 2005 SP1 Installs Successfully But Microsoft Update Still Showing It As Needed?

Jun 3, 2006

I have successfully installed SQL Server 2005 SP1 but when I go to the "Microsoft Update" site it is still shown as required. I have tried going back to an old image of the PC and installing SQL Server 2005 and SP1 again but still the "Microsoft Update" page is not picking up the fact that SP1 has installed successfully. Anyone had the same problem or know of a fix?

Steve

View 3 Replies View Related

The Logon Page Running Successfully But Redirect To Folder.aspx Not Happening

Apr 27, 2007

Hi everyone,
I use the forms authetification for my report manager and server. But, i have this problem :
The Logon page running successfully but redirect to Folder.aspx not happening

To clarify:

>I get the logon page (UILogon.aspx)

>My user has been registered ok (i have checked the entry in the db to make sure it was created)

>I enter the login & password correctly and page posts back

The redirect never happens - In the browser, it never leaves the UILogon.aspx

Using Win2003, SQL Server 2005, Reporting Services

Any help greatly appreciated.

Thank you.

Shaouk.

View 2 Replies View Related

Database Mail Sends Test Mails Successfully, But Sp_send_dbmail Fails

Apr 15, 2008

Hi all,

I am having a few problems with Database Mail and wondered if anyone could assist. It sends test mails fine, but when I run the following script:

(I've changed my email address in this post to test@test.com they are accurate in the scripts.)

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Test Mail',

@recipients = 'test@test.com',

@body = 'Sent by sp_send_dbmail',

@Subject = 'SQL Server Email Test Email';

It gives the following errors.

(from the above script)

mailitem_id = 16
profile_id = 2
recipients = test@test.com
copy_recipients = NULL
blind_copy_recipients = NULL
subject = SQL Server Email Test Email
body = Sent by sp_send_dbmail
body_format = TEXT
importance = NORMAL
sensitivity = NORMAL
file_attachments = NULL
attachment_encoding = MIME
query = NULL
execute_query_database = NULL
attach_query_result_as_file = 0
query_result_header = 1
query_result_width = 256
query_result_separator =
exclude_query_output = 0
append_query_error = 0
send_request_date = 2008-04-15 10:50:03.827
send_request_user = COMPANYTest.Test
sent_account_id = NULL
sent_status = failed
sent_date = 2008-04-15 10:50:04.000
last_mod_date = 2008-04-15 10:50:04.513
last_mod_user = sa

(from the test mail)

mailitem_id = 11
profile_id = 2
recipients = test@test.com
copy_recipients = NULL
blind_copy_recipients = NULL
subject = Database Mail Test
body = This is a test e-mail sent from Database Mail on UKDEVSQL1
body_format = TEXT
importance = NORMAL
sensitivity = NORMAL
file_attachments = NULL
attachment_encoding = MIME
query = NULL
execute_query_database = NULL
attach_query_result_as_file = 0
query_result_header = 1
query_result_width = 256
query_result_separator =
exclude_query_output = 0
append_query_error = 0
send_request_date = 2008-04-15 09:51:46.530
send_request_user = COMPANYTest.Test
sent_account_id = 4
sent_status = sent
sent_date = 2008-04-15 09:51:46.000
last_mod_date = 2008-04-15 09:51:46.610
last_mod_user = sa

sysmail_event_log gives this error for mail item 16 (the scripted email):

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2008-04-15T10:11:41). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Requested action not taken: message refused). )

View 2 Replies View Related

SP2 Install Error : Error 1625

Mar 9, 2007

Hello,

I'm getting this error:

=== Verbose logging started: 09-03-2007 11:22:01 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: c:2615800be9b170361adff8bc7a52ebhotfix.exe ===
MSI (c) (68:50) [11:22:01:246]: Resetting cached policy values
MSI (c) (68:50) [11:22:01:246]: Machine policy value 'Debug' is 0
MSI (c) (68:50) [11:22:01:246]: ******* RunEngine:
******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (c) (68:50) [11:22:01:246]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (68:50) [11:22:01:246]: Grabbed execution mutex.
MSI (c) (68:50) [11:22:01:246]: Cloaking enabled.
MSI (c) (68:50) [11:22:01:246]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (68:50) [11:22:01:246]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (A8:D0) [11:22:01:277]: Grabbed execution mutex.
MSI (s) (A8:3C) [11:22:01:277]: Resetting cached policy values
MSI (s) (A8:3C) [11:22:01:277]: Machine policy value 'Debug' is 0
MSI (s) (A8:3C) [11:22:01:277]: ******* RunEngine:
******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (s) (A8:3C) [11:22:01:402]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (A8:3C) [11:22:01:402]: File will have security applied from OpCode.
MSI (s) (A8:3C) [11:22:01:996]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi' against software restriction policy
MSI (s) (A8:3C) [11:22:01:996]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi has a digital signature
MSI (s) (A8:3C) [11:22:02:121]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (A8:3C) [11:22:02:121]: End dialog not enabled
MSI (s) (A8:3C) [11:22:02:121]: Original package ==> C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
MSI (s) (A8:3C) [11:22:02:121]: Package we're running from ==> C:WINDOWSInstaller1e413d.msi
MSI (s) (A8:3C) [11:22:02:136]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (A8:3C) [11:22:02:136]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (A8:3C) [11:22:02:136]: MSCOREE not loaded loading copy from system32
MSI (s) (A8:3C) [11:22:02:136]: Opening existing patch 'C:WINDOWSInstaller3d37f8c.msp'.
MSI (s) (A8:3C) [11:22:02:136]: SequencePatches starts. Product code: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}, Product version: 9.00.3042.00, Upgrade code: {3A91FA19-A197-467C-850F-0AFE90899371}, Product language 1033
MSI (s) (A8:3C) [11:22:02:136]: PATCH SEQUENCER: Setting patch {EE92F683-5F5C-4970-BB0B-9AC591B60268} to be unregistered, because the patch doesn't have any transform that targets this product.
MSI (s) (A8:3C) [11:22:02:136]: SequencePatches returns success.
MSI (s) (A8:3C) [11:22:02:136]: Final Patch Application Order:
MSI (s) (A8:3C) [11:22:02:136]: Other Patches:
MSI (s) (A8:3C) [11:22:02:136]: UnknownAbsent: {EE92F683-5F5C-4970-BB0B-9AC591B60268} -
MSI (s) (A8:3C) [11:22:02:136]: Machine policy value 'DisablePatch' is 0
MSI (s) (A8:3C) [11:22:02:136]: Machine policy value 'AllowLockdownPatch' is 1
MSI (s) (A8:3C) [11:22:02:136]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (A8:3C) [11:22:02:152]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (A8:3C) [11:22:02:152]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (A8:3C) [11:22:02:152]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (A8:3C) [11:22:02:152]: Transforms are not secure.
MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 2205 2: 3: Control
MSI (s) (A8:3C) [11:22:02:152]: Command Line: REBOOT=ReallySuppress REINSTALLMODE=vomus REINSTALL=ALL CURRENTDIRECTORY=c:2615800be9b170361adff8bc7a52eb CLIENTUILEVEL=3 CLIENTPROCESSID=5736
MSI (s) (A8:3C) [11:22:02:152]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{BEFE6789-8AE1-4E45-B1F7-E3D6B30A51C8}'.
MSI (s) (A8:3C) [11:22:02:152]: Product Code passed to Engine.Initialize: ''
MSI (s) (A8:3C) [11:22:02:152]: Product Code from property table before transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'
MSI (s) (A8:3C) [11:22:02:152]: Product Code from property table after transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'
MSI (s) (A8:3C) [11:22:02:152]: Product registered: entering maintenance mode
MSI (s) (A8:3C) [11:22:02:152]: PROPERTY CHANGE: Adding ProductState property. Its value is '5'.
MSI (s) (A8:3C) [11:22:02:152]: PROPERTY CHANGE: Adding ProductToBeRegistered property. Its value is '1'.
MSI (s) (A8:3C) [11:22:02:152]: Entering CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 1402 2: UNKNOWNNet 3: 2
MSI (s) (A8:3C) [11:22:02:152]: Specifed source is not already in a list.
MSI (s) (A8:3C) [11:22:02:152]: Policy value 'SearchOrder' is 'nmu'
MSI (s) (A8:3C) [11:22:02:152]: Machine policy value 'DisableBrowse' is 1
MSI (s) (A8:3C) [11:22:02:152]: Adding new sources is not allowed.
MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 1729
MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 2729
MSI (s) (A8:3C) [11:22:02:199]: Note: 1: 2729
MSI (s) (A8:3C) [11:22:02:199]: Product: Microsoft SQL Server Setup Support Files (English) -- Configuration failed.

MSI (s) (A8:3C) [11:22:02:199]: MainEngineThread is returning 1625
This installation is forbidden by system policy. Contact your system administrator.
C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
MSI (c) (68:50) [11:22:02:308]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (68:50) [11:22:02:308]: MainEngineThread is returning 1625
=== Verbose logging stopped: 09-03-2007 11:22:02 ===

Time: 03/09/2007 11:22:35.028
KB Number: KB921896
Machine: CEPHEUS
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (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: Failed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x86
Database Services (MSSQLSERVER) ENU SP1 2005.090.2153.00 x86 ENTERPRISE
Analysis Services (MSSQLSERVER) ENU SP1 2005.090.2153.00 x86 ENTERPRISE
Reporting Services (MSSQLSERVER) ENU SP1 9.00.2153.00 x86 ENTERPRISE
Notification Services ENU SP1 9.00.2153.00 x86 ENTERPRISE
Integration Services ENU SP1 9.00.2153.00 x86 ENTERPRISE
SQL Server Native Client ENU 9.00.2047.00 x86
Client Components ENU SP1 9.1.2153 x86 ENTERPRISE
MSXML 6.0 Parser ENU 6.00.3890.0 x86
SQLXML4 ENU 9.00.2047.00 x86
Backward Compatibility ENU 8.05.1704 x86
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x86

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
MSSQLSERVER SQL Server Native Client Service 1168
SQLSERVERAGENT SQL Server Native Client Service 2776
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4276
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4280
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4288
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4300
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4308
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4324
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4364
msftesql Database Services Service 296
ReportServer Database Services Service 1660
MSSQLServerOLAPService Analysis Services Service 1148
MsDtsServer Integration Services Service 352

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 1625
Error Description : Unable to install Windows Installer MSI file
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

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

View 2 Replies View Related