Linked Server Using SQL Native Client

May 28, 2007

We have a SQL 2005 SP2 64 bit server that needs to communicate with our 32 bit AS400 server. We have stored procedures in databases that query the AS400 (generally just select statements). I am not understanding the procedure to connect to the AS400 now that the OLE DB for ODBC provider no longer exists.

I know how to create a system DSN (and that it will be located in C:WINDOWSSysWOW64odbcad32.exe). I called the System DSN 'ConnectMe'. The server I am trying to access is 'ServerA'. I have filled out the following to create a linked server:
Linked Server: AS400
Provider: SQL Native Client
Product Name: AS400 (from what I understand, this holds no value and only serves as a description)
Data source: ServerA
Provider String: dsn::=ConnectMe (same as system DSN)
Catalog:<I left it blank>
Under the security tab I have the remote username and password that should be used.

When I try to create the linked server, I get the error:
"OLE DB provider "SQLNCLI" for linked server "AS400" returned message "An error has occured while establishing a connection to the server. ..may be be caused by the fact that under the default settings SQL Server does not allow remote connections"

Remote connections for both TCP/IP and named pipes is enabled and SQL services have restarted to enable that. What am I missing?

View 3 Replies


ADVERTISEMENT

Client Unable To Establish Connection Encryption Not Supported On SQL Server. (Microsoft SQL Native Client)

May 2, 2006

On Windows XP systems I get the following issue when trying to browse the MSDB folder in SSIS

Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)

I have noticed another post where several others have noticed the same issue. It appears to only occur on Windows XP installations. Is there a workaround or fix for this?

View 2 Replies View Related

Install SQL Server2005 Error:[Native Client]Encryption Not Supported On The Client

May 10, 2006

Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

View 78 Replies View Related

SQL Server 2005 Native Client...

Jun 19, 2007

Do I need to install SQL Server 2005 Native client drivers on the servers that contain applications that make connections to the new SS2005 db server? My understanding is that this driver is backward compatible with SS 2000... Can I have both installed on the same server, and then create and ODBC driver for either?



Thank-Dave

View 3 Replies View Related

Setup Error : [SQL Native Client] Encryption Not Supported On The Client

Nov 1, 2006

Hi,

I have SQL2000 installed as the default instance, and now I'm trying to install SQL 2005 standard edition as a named instance.

I receive this error :
SQL Server could not connect to database service for server configuration.. [SQL Native client] Encryption not supported on the client. However I'm able to install client tools

The setup works fine on other box with the same config : SQL 2000/Windows XP, is there any work around for this issue ?

In my SQL 2000 client network utilty "Force proctocol encryption " is desabled and did not find the setting for SQL 2005 !

Thank you

View 1 Replies View Related

Multiple SQL Server Native Client Versions

Nov 24, 2006

One of the big problems with the old MDAC was different versions on different client machines. You would test your app with the latest version say, but when you deployed it, it might fail as the client has a different version.

My company develops software for Municipal Government clients. These clients use other SQL Server applications as well as ours, but they can only use one version of the client software (MDAC) on a given desktop. That means if we require a particular MDAC version, but the clients other applications from other vendors don't officially support that MDAC version, the client is in a real jam.

Our software also supports Oracle, which allows our software to specify a particular Oracle Home which points to a directory with a particular version of the Oracle client dlls (along with corresponding registry entries for that Oracle Home), such that we control the exact client version of the Oracle software that the client uses with our applications. This will not interfere with, and is completely seperate, from the default Oracle home installed when you install the Oracle client software.

What I would like to see for the Native Client is the ability to have our applications use the version of the Native Client that we wish to support and deploy without interfering with the Native Client version used by other applications. Have a default Native Client, but allow applications to somehow specify a different Native Client version/set of DLLs.

Is there any such functionality with the Native Client? (I didn't see any mention of such in the documentation, but I thought I'd ask)

If not, are there any future plans to support multiple Native Client versions on the same desktop?

View 1 Replies View Related

SQL Server Native Client - SDK Doesn't Include X64 Libs

Jul 19, 2007

I've installed the SQL Server Native Client, and I included the optional SDK components. Only the x86 versions of opends60.lib and sqlncli.lib get installed, not the x64 (or amd64) versions. Any idea where I can get ahold of these?



View 4 Replies View Related

?? SQL Server 2005 Express SP2 Install Fails On Native Client ??

Jun 11, 2007

Hello all,



I'm trying to install "SQL Server 2005 Express Edition SP2" on a newly installed XP Pro SP2 machine. I downloaded "SQLEXPR32.EXE" (38,220,656 bytes) from the Microsoft site.



At the beginning of the setup the installation program scans my system -- no problems or warnings. Everything looks fine and ready to go.



During installation I uncheck, "Hide advanced configuration options" simply because I want to change the default instance name. Aside from changing the default instance name I make no other changes to the default installation configuration.



The installation begins but when it tries to comes to the "SQL Native Client" portion of the installation I get the following error dialog message:



"An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'."



Below I've included the setup log file of the SQL Native Client portion of the setup. I've looked through the log file but didn't see anything obviously wrong until the error occurs toward the end.



Does anyone have an idea of what might be causing this to happen? I've install SSE many times in the past with no problems.



Thanks












Code Snippet

=== Verbose logging started: 6/10/2007 23:03:13 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (C0:8C) [23:03:13:093]: Resetting cached policy values
MSI (c) (C0:8C) [23:03:13:093]: Machine policy value 'Debug' is 0
MSI (c) (C0:8C) [23:03:13:093]: ******* RunEngine:
******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
******* Action:
******* CommandLine: **********
MSI (c) (C0:8C) [23:03:13:093]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (C0:8C) [23:03:13:093]: Grabbed execution mutex.
MSI (c) (C0:8C) [23:03:13:093]: Cloaking enabled.
MSI (c) (C0:8C) [23:03:13:093]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (C0:8C) [23:03:13:093]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (D0:94) [23:03:13:109]: Grabbed execution mutex.
MSI (s) (D0:B4) [23:03:13:109]: Resetting cached policy values
MSI (s) (D0:B4) [23:03:13:109]: Machine policy value 'Debug' is 0
MSI (s) (D0:B4) [23:03:13:109]: ******* RunEngine:
******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
******* Action:
******* CommandLine: **********
MSI (s) (D0:B4) [23:03:13:109]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (D0:B4) [23:03:13:109]: End dialog not enabled
MSI (s) (D0:B4) [23:03:13:109]: Original package ==&gt; C:WINDOWSInstaller1d32b7a.msi
MSI (s) (D0:B4) [23:03:13:109]: Package we're running from ==&gt; C:WINDOWSInstaller1d32b7a.msi
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: looking for appcompat database entry with ProductCode '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'.
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (D0:B4) [23:03:13:125]: MSCOREE already loaded, using loaded copy
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisablePatch' is 0
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: looking for appcompat database entry with ProductCode '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'.
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (D0:B4) [23:03:13:125]: Transforms are not secure.
MSI (s) (D0:B4) [23:03:13:125]: Command Line: STPSETUPTHREADID=2000 STPSETUPPROCESSID=1472 EXTERNALCONTROL=1 ADDLOCAL=ALL SKIPPENDINGREBOOTCHECK=1 APPGUID={2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F} REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=1472
MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{8225F098-4183-422F-B208-3018904DFA0C}'.
MSI (s) (D0:B4) [23:03:13:125]: Product Code passed to Engine.Initialize: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'
MSI (s) (D0:B4) [23:03:13:125]: Product Code from property table before transforms: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'
MSI (s) (D0:B4) [23:03:13:125]: Product Code from property table after transforms: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'
MSI (s) (D0:B4) [23:03:13:125]: Product registered: entering maintenance mode
MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding ProductState property. Its value is '5'.
MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding ProductToBeRegistered property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:125]: Package name retrieved from configuration data: 'sqlncli.msi'
MSI (s) (D0:B4) [23:03:13:125]: Determined that existing product (either this product or the product being upgraded with a patch) is installed per-machine.
MSI (s) (D0:B4) [23:03:13:140]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (D0:B4) [23:03:13:140]: Machine policy value 'DisableMsi' is 0
MSI (s) (D0:B4) [23:03:13:140]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:140]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:140]: Product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D} is admin assigned: LocalSystem owns the publish key.
MSI (s) (D0:B4) [23:03:13:140]: Product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D} is managed.
MSI (s) (D0:B4) [23:03:13:140]: Running product '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}' with elevated privileges: Product is assigned.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '2000'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '1472'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'ALL'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding SKIPPENDINGREBOOTCHECK property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding APPGUID property. Its value is '{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '1472'.
MSI (s) (D0:B4) [23:03:13:140]: TRANSFORMS property is now:
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding PRODUCTLANGUAGE property. Its value is '1033'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '301'.
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoApplication Data
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoFavorites
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoNetHood
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoMy Documents
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoPrintHood
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoRecent
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoSendTo
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoTemplates
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoLocal SettingsApplication Data
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoMy DocumentsMy Pictures
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersDesktop
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuProgramsAdministrative Tools
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuProgramsStartup
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuPrograms
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart Menu
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoDesktop
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersTemplates
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:WINDOWSFonts
MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'Tony'.
MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Installed property. Its value is '00:00:00'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINDOWSInstaller1d32b7a.msi'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'C:WINDOWSInstaller1d32b7a.msi'.
MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:13:187]: Machine policy value 'DisableRollback' is 0
MSI (s) (D0:B4) [23:03:13:187]: User policy value 'DisableRollback' is 0
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'.
=== Logging started: 6/10/2007 23:03:13 ===
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'.
MSI (s) (D0:B4) [23:03:13:187]: Doing action: INSTALL
MSI (s) (D0:B4) [23:03:13:187]: Running ExecuteSequence
MSI (s) (D0:B4) [23:03:13:187]: Doing action: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
Action start 23:03:13: INSTALL.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 23:03:13: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
Action ended 23:03:13: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 23:03:13: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
Action ended 23:03:13: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 23:03:13: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
Action ended 23:03:13: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 23:03:13: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: LaunchConditions
Action ended 23:03:13: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1.
Action start 23:03:13: LaunchConditions.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: FindRelatedProducts
Action ended 23:03:13: LaunchConditions. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: Skipping FindRelatedProducts action: not run in maintenance mode
Action start 23:03:13: FindRelatedProducts.
MSI (s) (D0:B4) [23:03:13:203]: Skipping action: CA_SetRefCountUpgradeFlag (condition is false)
MSI (s) (D0:B4) [23:03:13:203]: Skipping action: CA_SetRefCountNewerFoundFlag (condition is false)
MSI (s) (D0:B4) [23:03:13:203]: Doing action: IsPendingRebootKey
Action ended 23:03:13: FindRelatedProducts. Return value 0.
MSI (s) (D0:44) [23:03:13:218]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIA9.tmp, Entrypoint: IsPendingReboot
MSI (s) (D0:3C) [23:03:13:218]: Generating random cookie.
MSI (s) (D0:3C) [23:03:13:234]: Created Custom Action Server with PID 2372 (0x944).
MSI (s) (D0:70) [23:03:13:312]: Running as a service.
MSI (s) (D0:70) [23:03:13:328]: Hello, I'm your 32bit Impersonated custom action server.
Action start 23:03:13: IsPendingRebootKey.
No PendingFileRenameOperations
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: CA_ErrorDifferentLang (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOW (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWAppendCustomPath (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH_ADD (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_ValidateAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RefCountAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_BackupAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RegisterAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RestoreAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Doing action: AppSearch
Action ended 23:03:13: IsPendingRebootKey. Return value 1.
Action start 23:03:13: AppSearch.
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding REDISTINSTALLEDVERSION property. Its value is '9.00.3042.00'.
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: SkipInstallCA (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: CA_ErrorPendingReboot (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: CCPSearch (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: RMCCPSearch (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Doing action: ValidateProductID
Action ended 23:03:13: AppSearch. Return value 1.
Action start 23:03:13: ValidateProductID.
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: Sqlmsirc_CheckLanguage.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Doing action: CostInitialize
Action ended 23:03:13: ValidateProductID. Return value 1.
MSI (s) (D0:B4) [23:03:13:359]: Machine policy value 'MaxPatchCacheSize' is 10
Action start 23:03:13: CostInitialize.
MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding ROOTDRIVE property. Its value is 'D:'.
MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding CostingComplete property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: MsiPatchHeaders
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: __MsiPatchFileList
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2228 2: 3: PatchPackage 4: SELECT `DiskId`, `PatchId`, `LastSequence` FROM `Media`, `PatchPackage` WHERE `Media`.`DiskId`=`PatchPackage`.`Media_` ORDER BY `DiskId`
MSI (s) (D0:B4) [23:03:13:359]: Doing action: FileCost
Action ended 23:03:13: CostInitialize. Return value 1.
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: TypeLib 3: -2147287038
Action start 23:03:13: FileCost.
MSI (s) (D0:B4) [23:03:13:359]: Doing action: IsolateComponents
Action ended 23:03:13: FileCost. Return value 1.
Action start 23:03:13: IsolateComponents.
MSI (s) (D0:B4) [23:03:13:375]: Doing action: CostFinalize
Action ended 23:03:13: IsolateComponents. Return value 0.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding OutOfDiskSpace property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding OutOfNoRbDiskSpace property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceAvailable property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRequired property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRemaining property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its value is 'C:Program FilesMicrosoft SQL Server90EULA'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying SystemFolder property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'C:WINDOWSsystem32'.
MSI (s) (D0:B4) [23:03:13:375]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:13:375]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding TARGETDIR property. Its value is 'D:'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying SystemFolder property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'C:WINDOWSsystem32'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSINSTALLDIR property. Its value is 'C:Program FilesMicrosoft Visual Studio 8'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSINSTALLROOT property. Its value is 'C:Program FilesMicrosoft Visual Studio 8'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlShared property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding Ver.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDK.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDK'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDKLib.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKLib'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDKLibPlatformTarget.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKLibx86'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlInclude.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKInclude'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding Ver90.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its value is 'C:Program FilesMicrosoft SQL Server90'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its current value is 'C:Program FilesMicrosoft SQL Server90EULA'. Its new value: 'C:Program FilesMicrosoft SQL Server90EULA'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlVer property. Its value is 'C:Program FilesMicrosoft SQL Server90'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlTools property. Its value is 'C:Program FilesMicrosoft SQL Server90Tools'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlToolsBin property. Its value is 'C:Program FilesMicrosoft SQL Server90ToolsBinn'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxs'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsManifests'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPolicies'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxs'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPolicies'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsManifests'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSRetarget property. Its value is 'C:Program FilesMicrosoft SQL Server90ToolsBinn'.
MSI (s) (D0:B4) [23:03:13:375]: Target path resolution complete. Dumping Directory table...
MSI (s) (D0:B4) [23:03:13:375]: Note: target paths subject to change (via custom actions or browsing)
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: TARGETDIR , Object: D:
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder , Object: C:WINDOWS
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder , Object: C:WINDOWSsystem32
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: ProgramFilesFolder , Object: C:Program Files
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSINSTALLDIR , Object: C:Program FilesMicrosoft Visual Studio 8
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSINSTALLROOT , Object: C:Program FilesMicrosoft Visual Studio 8
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlShared , Object: C:Program FilesMicrosoft SQL Server
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: Ver.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDK.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDK
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDKLib.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKLib
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDKLibPlatformTarget.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKLibx86
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlInclude.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKInclude
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: Ver90.84118FFB_F307_45F3_B5BC_3A4F8261108D , Object: C:Program FilesMicrosoft SQL Server90
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D , Object: C:Program FilesMicrosoft SQL Server90EULA
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: INSTALLSQLSHAREDDIR , Object: C:Program FilesMicrosoft SQL Server
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlVer , Object: C:Program FilesMicrosoft SQL Server90
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlTools , Object: C:Program FilesMicrosoft SQL Server90Tools
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlToolsBin , Object: C:Program FilesMicrosoft SQL Server90ToolsBinn
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWS
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSsystem32
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxs
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsManifests
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPolicies
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWS
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSsystem32
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxs
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPolicies
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsManifests
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSRetarget , Object: C:Program FilesMicrosoft SQL Server90ToolsBinn
Action start 23:03:13: CostFinalize.
MSI (s) (D0:B4) [23:03:13:375]: Doing action: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD
Action ended 23:03:13: CostFinalize. Return value 1.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding ARPINSTALLLOCATION property. Its value is 'C:WINDOWSsystem32'.
Action start 23:03:13: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD.
MSI (s) (D0:B4) [23:03:13:375]: Doing action: IsDotNet20Installed
Action ended 23:03:13: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD. Return value 1.
MSI (s) (D0:50) [23:03:13:390]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAA.tmp, Entrypoint: IsDotNetFramework20Installed
Action start 23:03:13: IsDotNet20Installed.
Feature SQL_SNAC_CORE install action does not match 2.
Not all features are being removed.
MSI (s) (D0!90) [23:03:13:421]: PROPERTY CHANGE: Deleting EnableDotNetCheck property. Its current value is '0'.
MSI (s) (D0!90) [23:03:13:421]: PROPERTY CHANGE: Adding DOTNETCOREPATH property. Its value is '1'.
Either there are no .NET Framework assemblies present in MsiAssembly table or they do not require the GAC, no need to check for the .NET Framework
MSI (s) (D0:B4) [23:03:13:421]: Skipping action: CA_ErrorPrereqDotNet (condition is false)
MSI (s) (D0:B4) [23:03:13:421]: Skipping action: CA_SetARPINSTALLLOCATION (condition is false)
MSI (s) (D0:B4) [23:03:13:421]: Doing action: SetODBCFolders
Action ended 23:03:13: IsDotNet20Installed. Return value 1.
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ODBCDriver
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2228 2: 3: ODBCDriver 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCDriver`, `Component` WHERE `ODBCDriver`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2)
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ODBCTranslator
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2228 2: 3: ODBCTranslator 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCTranslator`, `Component` WHERE `ODBCTranslator`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2)
Action start 23:03:13: SetODBCFolders.
MSI (s) (D0:B4) [23:03:13:421]: Doing action: MigrateFeatureStates
Action ended 23:03:13: SetODBCFolders. Return value 0.
MSI (s) (D0:B4) [23:03:13:421]: Skipping MigrateFeatureStates action: not run in maintenance mode
Action start 23:03:13: MigrateFeatureStates.
MSI (s) (D0:B4) [23:03:13:421]: Doing action: InstallValidate
Action ended 23:03:13: MigrateFeatureStates. Return value 0.
MSI (s) (D0:B4) [23:03:13:421]: Feature: SQL_SNAC_CORE; Installed: Local; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Feature: SQL_SNAC_SDK; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: RedistVersionReg.C3E5819B-5744-41E9-BEF2-12652D7B9053; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: Redist_Uninstall_RegKey.E63C6774-A4E8-4A1A-A090-567FE0DA2FBF; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: License_SQLNCLI_ENU.txt.84118FFB_F307_45F3_B5BC_3A4F8261108D; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.dll.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: RedistQFEKey.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlnclir.rll.A0C5BB09_6818_43E8_AF1C_A1C3C70B210C; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.chm.A0C5BB09_6818_43E8_AF1C_A1C3C70B210C; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_manifest.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: nosxs.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_manifest.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: msmd.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: oledbdm.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: srv.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.lib.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: opends60.lib.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: __uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __Redist_Uninstall_RegKey.E63C6774-A4E8-4A65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __RedistVersionReg.C3E5819B-5744-41E9-BEF265; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __RedistQFEKey.9B634CFE_9A39_4508_9CA8_D8D65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __sqlncli.dll.9B634CFE_9A39_4508_9CA8_D8DE65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __sqlnclir.rll.A0C5BB09_6818_43E8_AF1C_A1C65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_payload.98CB24AD_52FB_DB5F_FF165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __nosxs.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_manifest.98CB24AD_52FB_DB5F_FF65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_manifest.63E949F6_03BC_5C40_FF65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: BindImage
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: Class 3: -2147287038
Action start 23:03:13: InstallValidate.
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: _RemoveFilePath
MSI (s) (D0:B4) [23:03:13:437]: PROPERTY CHANGE: Modifying CostingComplete property. Its current value is '0'. Its new value: '1'.
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: BindImage
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2727 2:
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2727 2:
MSI (s) (D0:B4) [23:03:13:437]: Doing action: InstallInitialize
Action ended 23:03:13: InstallValidate. Return value 1.
MSI (s) (D0:B4) [23:03:13:437]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:437]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:437]: BeginTransaction: Locking Server
MSI (s) (D0:B4) [23:03:13:437]: SRSetRestorePoint skipped for this transaction.
MSI (s) (D0:B4) [23:03:13:437]: Server not locked: locking for product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
Action start 23:03:13: InstallInitialize.
MSI (s) (D0:B4) [23:03:13:859]: Doing action: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1
Action ended 23:03:13: InstallInitialize. Return value 1.
MSI (s) (D0:70) [23:03:13:875]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAB.tmp, Entrypoint: Sqlmsirc_ValidateAppGuid
Action start 23:03:13: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1.
&lt;Func Name='Sqlmsirc_ValidateAppGuid'&gt;
&lt;EndFunc Name='Sqlmsirc_ValidateAppGuid' Return='0' GetLastError='0'&gt;
MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_RefCountAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_BackupAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_CheckAppDependency.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:890]: Doing action: SxsInstallCA
Action ended 23:03:13: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1. Return value 1.
MSI (s) (D0:88) [23:03:13:906]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAC.tmp, Entrypoint: CustomAction_SxsMsmInstall
Action start 23:03:13: SxsInstallCA.
1: sxsdelca 2: traceop 3: 1262 4: 0
1: sxsdelca 2: traceop 3: 1263 4: 0
1: sxsdelca 2: traceop 3: 1264 4: 0
1: sxsdelca 2: traceop 3: 1269 4: 0
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: downlevel_manifest.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: downlevel_payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: downlevel_manifest.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 259
1: sxsdelca 2: SxsMsmInstall completed 3: 0 4: 0
MSI (s) (D0:B4) [23:03:14:000]: Skipping action: AllocateRegistrySpace (condition is false)
MSI (s) (D0:B4) [23:03:14:000]: Doing action: ProcessComponents
Action ended 23:03:14: SxsInstallCA. Return value 1.
Action start 23:03:14: ProcessComponents.
MSI (s) (D0:B4) [23:03:14:000]: Doing action: UnpublishComponents
Action ended 23:03:14: ProcessComponents. Return value 1.
MSI (s) (D0:B4) [23:03:14:000]: Note: 1: 2262 2: PublishComponent 3: -2147287038
Action start 23:03:14: UnpublishComponents.
MSI (s) (D0:B4) [23:03:14:000]: Doing action: MsiUnpublishAssemblies
Action ended 23:03:14: UnpublishComponents. Return value 1.
Action start 23:03:14: MsiUnpublishAssemblies.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnpublishFeatures
Action ended 23:03:14: MsiUnpublishAssemblies. Return value 1.
Action start 23:03:14: UnpublishFeatures.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: StopServices
Action ended 23:03:14: UnpublishFeatures. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: ServiceControl 3: -2147287038
Action start 23:03:14: StopServices.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: DeleteServices
Action ended 23:03:14: StopServices. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: ServiceControl 3: -2147287038
Action start 23:03:14: DeleteServices.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterComPlus
Action ended 23:03:14: DeleteServices. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: Complus
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: Complus 4: SELECT `ComponentId`, `FileName`, `Component`.`Directory_`, `ExpType`, `Component`.`Action`, `Component`.`Installed` FROM `Complus`, `Component`, `File` WHERE `Complus`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND `Action` = 0
Action start 23:03:14: UnregisterComPlus.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: SelfUnregModules
Action ended 23:03:14: UnregisterComPlus. Return value 0.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: SelfReg 4: Select `File`.`FileName`,`Component`.`Directory_`,`Component`.`Installed`, `File`.`Component_`,`SelfReg`.`File_` From `SelfReg`, `File`, `Component` Where `SelfReg`.`File_` = `File`.`File` And `File`.`Component_` = `Component`.`Component` And `Component`.`Action` = 0
Action start 23:03:14: SelfUnregModules.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterTypeLibraries
Action ended 23:03:14: SelfUnregModules. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: TypeLib 3: -2147287038
Action start 23:03:14: UnregisterTypeLibraries.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterFonts
Action ended 23:03:14: UnregisterTypeLibraries. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: Font 4: SELECT `FontTitle`, `FileName`, `Directory_`, `Installed`From `Font`, `FileAction` Where `Font`.`File_` = `FileAction`.`File` And `FileAction`.`Action` = 0 ORDER BY `FileAction`.`Directory_`
Action start 23:03:14: UnregisterFonts.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: RemoveRegistryValues
Action ended 23:03:14: UnregisterFonts. Return value 1.
Action start 23:03:14: RemoveRegistryValues.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterClassInfo
Action ended 23:03:14: RemoveRegistryValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2262 2: Class 3: -2147287038
Action start 23:03:14: UnregisterClassInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterExtensionInfo
Action ended 23:03:14: UnregisterClassInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2262 2: Extension 3: -2147287038
Action start 23:03:14: UnregisterExtensionInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterProgIdInfo
Action ended 23:03:14: UnregisterExtensionInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: ProgId 4: SELECT DISTINCT `BinaryType`, `ProgId`, `Class_`, `ProgId`.`Description`, `ProgId`.`Icon_`, `ProgId`.`IconIndex`, null, `Component`.`RuntimeFlags` , `Component`.`Component` FROM `ProgId`, `Class`, `Feature`, `Component` WHERE `ProgId`.`Class_` = `Class`.`CLSID` AND `Class`.`Feature_` = `Feature` AND `Class`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)))
Action start 23:03:14: UnregisterProgIdInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterMIMEInfo
Action ended 23:03:14: UnregisterProgIdInfo. Return value 0.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: MIME
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: MIME 4: SELECT `BinaryType`, `ContentType`, `Extension`.`Extension`, `MIME`.`CLSID`, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `MIME`, `Extension`, `Feature`, `Component` WHERE `MIME`.`Extension_` = `Extension`.`Extension` AND `Feature_` = `Feature` AND `Extension`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)))
Action start 23:03:14: UnregisterMIMEInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveIniValues
Action ended 23:03:14: UnregisterMIMEInfo. Return value 0.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: IniFile
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: IniFile 4: SELECT `FileName`,`IniFile`.`DirProperty`,`Section`,`IniFile`.`Key`,`IniFile`.`Value`,`IniFile`.`Action` FROM `IniFile`, `Component` WHERE `Component`=`Component_` AND `Component`.`Action`=0 ORDER BY `FileName`,`Section`
Action start 23:03:14: RemoveIniValues.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveShortcuts
Action ended 23:03:14: RemoveIniValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: Shortcut 4: SELECT `Name`, null, `Shortcut`.`Directory_`, `Component`.`RuntimeFlags`, `Feature`.`Action`, `Component`.`Action` From `Shortcut`, `Feature`, `Component` WHERE `Target` = `Feature` AND `Shortcut`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)))
Action start 23:03:14: RemoveShortcuts.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveEnvironmentStrings
Action ended 23:03:14: RemoveShortcuts. Return value 0.
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: Environment
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: Environment 4: SELECT `Name`,`Value` FROM `Environment`,`Component` WHERE `Component_`=`Component` AND (`Component`.`Action` = 0)
Action start 23:03:14: RemoveEnvironmentStrings.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveDuplicateFiles
Action ended 23:03:14: RemoveEnvironmentStrings. Return value 1.
Action start 23:03:14: RemoveDuplicateFiles.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveFiles
Action ended 23:03:14: RemoveDuplicateFiles. Return value 1.
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: RemoveFile
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: RemoveFile
Action start 23:03:14: RemoveFiles.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveFolders
Action ended 23:03:14: RemoveFiles. Return value 0.
Action start 23:03:14: RemoveFolders.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: CreateFolders
Action ended 23:03:14: RemoveFolders. Return value 0.
Action start 23:03:14: CreateFolders.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: MoveFiles
Action ended 23:03:14: CreateFolders. Return value 0.
Action start 23:03:14: MoveFiles.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: InstallFiles
Action ended 23:03:14: MoveFiles. Return value 1.
Action start 23:03:14: InstallFiles.
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: Patch 4: SELECT `Patch`.`File_`, `Patch`.`Header`, `Patch`.`Attributes`, `Patch`.`Sequence`, `Patch`.`StreamRef_` FROM `Patch` WHERE `Patch`.`File_` = ? AND `Patch`.`#_MsiActive`=? ORDER BY `Patch`.`Sequence`
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: MsiPatchHeaders
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: MsiPatchHeaders 4: SELECT `Header` FROM `MsiPatchHeaders` WHERE `StreamRef` = ?
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:14:062]: Doing action: DuplicateFiles
Action ended 23:03:14: InstallFiles. Return value 1.
Action start 23:03:14: DuplicateFiles.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: PatchFiles
Action ended 23:03:14: DuplicateFiles. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2228 2: 3: Patch 4: SELECT `File`,`FileName`,`FileSize`,`Directory_`,`PatchSize`,`File`.`Attributes`,`Patch`.`Attributes`,`Patch`.`Sequence`,`Component`.`Component`,`Component`.`ComponentId` FROM `File`,`Component`,`Patch` WHERE `Patch`.`#_MsiActive`=? AND `File`=`File_` AND `Component`=`Component_` ORDER BY `Patch`.`Sequence`
Action start 23:03:14: PatchFiles.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: BindImage
Action ended 23:03:14: PatchFiles. Return value 0.
Action start 23:03:14: BindImage.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterClassInfo
Action ended 23:03:14: BindImage. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2262 2: Class 3: -2147287038
Action start 23:03:14: RegisterClassInfo.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterExtensionInfo
Action ended 23:03:14: RegisterClassInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2262 2: Extension 3: -2147287038
Action start 23:03:14: RegisterExtensionInfo.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterProgIdInfo
Action ended 23:03:14: RegisterExtensionInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2228 2: 3: ProgId 4: SELECT DISTINCT `BinaryType`, `ProgId`, `Class_`, `ProgId`.`Description`, `ProgId`.`Icon_`, `ProgId`.`IconIndex`, null, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `ProgId`, `Class`, `Feature`, `Component` WHERE `ProgId`.`Class_` = `Class`.`CLSID` AND `Class`.`Feature_` = `Feature` AND `Class`.`Component_` = `Component` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND ((`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4))))
Action start 23:03:14: RegisterProgIdInfo.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterMIMEInfo
Action ended 23:03:14: RegisterProgIdInfo. Return value 0.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: MIME
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: MIME 4: SELECT `BinaryType`, `ContentType`, `Extension`.`Extension`, `MIME`.`CLSID`, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `MIME`, `Extension`, `Feature`, `Component` WHERE `MIME`.`Extension_` = `Extension`.`Extension` AND `Feature_` = `Feature` AND `Extension`.`Component_` = `Component` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND ((`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4))))
Action start 23:03:14: RegisterMIMEInfo.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteRegistryValues
Action ended 23:03:14: RegisterMIMEInfo. Return value 0.
Action start 23:03:14: WriteRegistryValues.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteIniValues
Action ended 23:03:14: WriteRegistryValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: IniFile
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: IniFile 4: SELECT `FileName`,`IniFile`.`DirProperty`,`Section`,`IniFile`.`Key`,`IniFile`.`Value`,`IniFile`.`Action` FROM `IniFile`, `Component` WHERE `Component`=`Component_` AND (`Component`.`Action`=1 OR `Component`.`Action`=2) ORDER BY `FileName`,`Section`
Action start 23:03:14: WriteIniValues.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteEnvironmentStrings
Action ended 23:03:14: WriteIniValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: Environment
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: Environment 4: SELECT `Name`,`Value` FROM `Environment`,`Component` WHERE `Component_`=`Component` AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2)
Action start 23:03:14: WriteEnvironmentStrings.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterFonts
Action ended 23:03:14: WriteEnvironmentStrings. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: Font 4: SELECT `FontTitle`, `FileName`, `Directory_`, `Action` From `Font`, `FileAction` Where `Font`.`File_` = `FileAction`.`File` And (`FileAction`.`Action` = 1 Or `FileAction`.`Action` = 2) ORDER BY `FileAction`.`Directory_`
Action start 23:03:14: RegisterFonts.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterTypeLibraries
Action ended 23:03:14: RegisterFonts. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2262 2: TypeLib 3: -2147287038
Action start 23:03:14: RegisterTypeLibraries.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: SelfRegModules
Action ended 23:03:14: RegisterTypeLibraries. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: SelfReg 4: Select `FileAction`.`FileName`,`FileAction`.`Directory_`,`FileAction`.`Action`, `FileAction`.`Component_`,`SelfReg`.`File_` From `SelfReg`, `FileAction` Where `SelfReg`.`File_` = `FileAction`.`File` And (`FileAction`.`Action` = 1 OR `FileAction`.`Action` = 2)
Action start 23:03:14: SelfRegModules.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterComPlus
Action ended 23:03:14: SelfRegModules. Return value 1.
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2205 2: 3: Complus
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2228 2: 3: Complus 4: SELECT `ComponentId`, `FileName`, `Component`.`Directory_`, `ExpType`, `Component`.`Action`, `Component`.`Installed` FROM `Complus`, `Component`, `File` WHERE `Complus`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND (`Action` = 1 OR `Action` = 2)
Action start 23:03:14: RegisterComPlus.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: InstallServices
Action ended 23:03:14: RegisterComPlus. Return value 0.
MSI (s) (D0:B4) [23:03:14:093]: Detected older ServiceInstall table schema
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2205 2: 3: ServiceInstall
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2228 2: 3: ServiceInstall 4: SELECT `Name`,`DisplayName`,`ServiceType`,`StartType`,`ErrorControl`,`LoadOrderGroup`,`Dependencies`,`StartName`,`Password`,`ComponentId`,`Directory_`,`FileName`,`Arguments` FROM `ServiceInstall`, `Component`, `File` WHERE `ServiceInstall`.`Component_` = `Component`.`Component` AND (`Component`.`KeyPath` = `File`.`File`) AND (`Action` = 1 OR `Action` = 2)
Action start 23:03:14: InstallServices.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: StartServices
Action ended 23:03:14: InstallServices. Return value 1.
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2262 2: ServiceControl 3: -2147287038
Action start 23:03:14: StartServices.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: RegisterUser
Action ended 23:03:14: StartServices. Return value 1.
Action start 23:03:14: RegisterUser.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: RegisterProduct
Action ended 23:03:14: RegisterUser. Return value 0.
Action start 23:03:14: RegisterProduct.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: PublishComponents
Action ended 23:03:14: RegisterProduct. Return value 1.
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2262 2: PublishComponent 3: -2147287038
Action start 23:03:14: PublishComponents.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: MsiPublishAssemblies
Action ended 23:03:14: PublishComponents. Return value 1.
Action start 23:03:14: MsiPublishAssemblies.
MSI (s) (D0:B4) [23:03:14:109]: Doing action: PublishFeatures
Action ended 23:03:14: MsiPublishAssemblies. Return value 1.
Action start 23:03:14: PublishFeatures.
MSI (s) (D0:B4) [23:03:14:109]: Doing action: PublishProduct
Action ended 23:03:14: PublishFeatures. Return value 1.
Action start 23:03:14: PublishProduct.
MSI (s) (D0:B4) [23:03:14:109]: Doing action: CreateShortcuts
Action ended 23:03:14: PublishProduct. Return value 1.
MSI (s) (D0:B4) [23:03:14:109]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:14:109]: Note: 1: 2228 2: 3: Shortcut 4: SELECT `Name`, `FileName`, `Component`.`Directory_`, `Arguments`, `WkDir`, `Icon_`, `IconIndex`, `Hotkey`, `ShowCmd`, `Shortcut`.`Description`, `Shortcut`.`Directory_`, `Component`.`RuntimeFlags`, `Component`.`Action`, `Target`, `ComponentId`, `Feature`.`Action`, `Component`.`Installed` From `Shortcut`, `Feature`, `Component`, `File` WHERE `Target` = `Feature` AND `Shortcut`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)))
Action start 23:03:14: CreateShortcuts.
MSI (s) (D0:B4) [23:03:14:109]: Skipping action: SNAC_SetClientSSNLDefaults.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD (condition is false)
MSI (s) (D0:B4) [23:03:14:109]: Doing action: InstallFinalize
Action ended 23:03:14: CreateShortcuts. Return value 0.
MSI (s) (D0:B4) [23:03:14:109]: Running Script: C:WINDOWSInstallerMSIAD.tmp
MSI (s) (D0:B4) [23:03:14:109]: PROPERTY CHANGE: Adding UpdateStarted property. Its value is '1'.
MSI (s) (D0:B4) [23:03:14:109]: Machine policy value 'DisableRollback' is 0
MSI (s) (D0:B4) [23:03:14:125]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionInstallerRollbackScripts 3: 2
MSI (s) (D0:B4) [23:03:14:125]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=919255143,LangId=1033,Platform=0,ScriptType=1,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
Action start 23:03:14: InstallFinalize.
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ProductInfo(ProductKey={F9B3DD02-B0B3-42E9-8650-030DFF0D133D},ProductName=Microsoft SQL Server Native Client,PackageName=sqlncli.msi,Language=1033,Version=150997986,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIco,,PackageCode={8225F098-4183-422F-B208-3018904DFA0C},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server Native Client)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (D0:B4) [23:03:14:125]: Executing op: SetBaseline(Baseline=0,)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: SetBaseline(Baseline=1,)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ActionStart(Name=ProcessComponents,Description=Updating component registration,)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ProgressTotal(Total=6,Type=1,ByteEquivalent=24000)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ComponentRegister(ComponentId={B26AC90F-A196-4D67-A57D-FE81C9202A2C},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludemsmd.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={9E91B830-1D04-4B78-9244-ACA6C7790142},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludeoledbdm.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={A2F6B3E4-9050-4BD3-9C29-17E05509F383},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludesqlncli.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={7372B29A-8237-4C56-9E27-5DB074A8AD07},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludesrv.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={AD0B21CC-B175-4F95-B728-2B5C6C0B65CE},KeyPath=C:Program FilesMicrosoft SQL Server90SDKLibx86sqlncli.lib,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={EE67DC7C-00F8-40A3-A6EB-62F764614040},KeyPath=C:Program FilesMicrosoft SQL Server90SDKLibx86opends60.lib,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: ActionStart(Name=InstallFiles,Description=Copying new files,Template=File: [1], Directory: [9], Size: [6])
MSI (s) (D0:B4) [23:03:14:156]: Executing op: ProgressTotal(Total=193043,Type=0,ByteEquivalent=1)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: SetTargetFolder(Folder=C:Program FilesMicrosoft SQL Server90SDKInclude)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: SetSourceFolder(Folder=1PFilesMICROS~190SDKInclude|Program FilesMicrosoft SQL Server90SDKInclude)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: ChangeMedia(MediaVolumeLabel=SNAC,MediaPrompt=Please insert the disk: ,MediaCabinet=snac.cab,BytesPerTick=32768,CopierType=2,ModuleFileName=1sqlncli.msi,,,,,IsFirstPhysicalMedia=1)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: FileCopy(Source

View 5 Replies View Related

Installing SQL Server Native Client Requires Administrator Rights

Jun 26, 2007

Hi All,
We're deploying an app. using a MSSQL Server 2005 (Std. Ed.).
In order to install an ODBC driver for the DB, we've made the installation of Sqlncli.msi part of the package.
It will not run - unless user has Admin priv.s on the klient PC targeted.
Does any one have any experience w. other ways of installing the sql native client (like MDAC) - og just an idea about circumventing the Admin rights problem?

Regards

View 1 Replies View Related

Cannot Install SQL Server Express On Vista Ultimate - Cannot Find MS SQL Server Native Client

Apr 5, 2007

I am trying to install SQL Server Express - (the non ADV version) and get the following error.

"An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli_x64.msi'".



I have 64 bit Vista Ultimate running on an HP dv9000.

I am using the download from the bottom of the download page for SSX where it says 64 bit version.



Prior to this I got the. "64-bit ASP.net is registered. Required 32-bit ASP.NET to install Microsoft Reporting services 2005(32-bit)." messagd during the pre-install scan. From what I gather in the posts, the reporting issue is different from my installation package problem.



I have been trying to prove a point to friends about how far you can go with SSX but am having no luck installing it. This whole process took 1 hour in XP but I've been stymied for 2 days.



I would appreciate being pointed at the right downloads for what seems to be a simple install.

View 5 Replies View Related

Connect SQL Server 2005 With ODBC Drive “SQL Native Client

Sep 13, 2007



Hi,



When I'm using SQL server 2005, and ODBC drive €œSQL Native Client€? I get an error when executing the below given code. Error Message: €œTransaction cannot start because more than one ODBC connection is in use.€?



But this works well with SQL Server 2000 with ODBC drive "SQL Native Client" and in SQL server 2005 also when I used ODBC drive €œSQL Server€?.



I used aTrgConn.Execute(€œBegin Transaction€?) and it's working properly. But unfortunately I cannot use this method, because I want to run the same code with Oracle ODBC as well.
Is this a known issue in SQL Native client drive with SQL server 2005? Do you know a solution for this?


Please Help..............



Thanks in advance.




Code:

Dim aTrgConn As New ADODB.connection
Dim aCmdIns As New ADODB.Command
Dim aCmdUpd As New ADODB.Command



aTrgConn.Open sConnStr



Set aCmdIns.ActiveConnection = aTrgConn
Set aCmdUpd.ActiveConnection = aTrgConn

aTrgConn.BeginTrans

View 6 Replies View Related

Error [Microsoft][SQL Native Client][SQL Server] Changed Database Context

Mar 2, 2008

Hi try to connect with driver {SQL Sever Client} but i can't
I'm have SQL Server 2005 Express SP2

Error connecting to the ODBC server:[Microsoft][SQL Native Client][SQL Server] Changed database context to..


Please Help me

Thanks

View 10 Replies View Related

This Microsoft Sql Server Native Client Package Is Not Supported On The Current Processor Type

Dec 16, 2007

Hello,I'm trying to install the SQL Server 2005 Standard edition and while I can easily install the first part of the package, the 
document.write(L_LINK_RUNINSTALL_VAR_TEXT)
Server components, tools, Books Online, and samples, when I click
to install the Run the SQL Native Client Installation Wizard  it tells me this:This Microsoft sql server native client package is not supported on the current processor type
I have Windows XP64bit with IIS running on 32bit now.  Why does it do that and how I can get around it  ? :) Thanks.
 

View 3 Replies View Related

Unable To Install Native Client Components In SQL Server 2005 Enterprise Evaluation Version

Dec 14, 2007

Hi all,

I have downloaded Microsoft SQL Server 2005 Enterprise Evaluation Edition ISO from the following site and burned it onto a DVD.
http://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en

Prior to this I have installed Visual Studio 2005 Professional Edtion. During setup I have selected all the native client components i.e. Management Studio, Business Intelligense Studio. But after the install I am not able to see them under All Programs-> Microsoft SQL Server 2005. On further searching I have come across this link

http://channel9.msdn.com/ShowPost.aspx?PostID=142941


First of all, there is no sqlrun_tools.msi under setup folder of the dvd. And also when I tried to change component from Add/Remove programs and following the instructions as specified on clicking Change Installed components all that I see are: Connectivity Components and Software Development kit.

Could someone tell me how can I install Management Studio/ Business Intelligence Studio seperately? I don't want to go through the process of re-installation.

View 4 Replies View Related

Inserting Image Data Fails With Connection Broken (SQL Server 2000 And SQL Native Client)

May 28, 2008

Dear all,

we have tables with many image columns. We fill these image columns via ODBC and SQLPutData as described in MSDN etc (using SQL_LEN_DATA_AT_EXEC(...), calling SQLParamData and sending the data in chunks of 4096 bytes when receiving SQL_NEED_DATA).

The SQLPutData call fails under the following conditions with sqlstate 08S01

- The database resides on SQL Server 2000
- The driver is SQL Native Client
- The table consists e.g. of one Identity column (key column) and nine image columns
- The data to be inserted are nine blocks of data with the following byte size:


1: 6781262
2: 119454

3: 269
4: 7611

5: 120054

6: 269

7: 8172

8: 120054

9: 269
The content of the data does not matter, (it happens also if only zero bytes are written), nor does the data origin (file or memory).

All data blocks including no 7 are inserted. If the first chunk of data block 8 should be written with SQLPutData the function fails and the connection is broken. There are errors such as "broken pipe" or "I/O error" depending on the used network protocol.

If data no 7 consists of 8173 bytes instead of 8172 all works again.
(Changing the 4096 chunk size length does not help)

Has anybody encountered this or a similar phenomenon?

Thank you

Eartha

View 7 Replies View Related

Error 15002 Executing Sp_setapprole Statement Using The SQL Native Client Connected To SQL Server 2005

Oct 16, 2007

Does anyone know if this is a SQL Native Client bug? I've read a previous thread (posted back on Jan. 18th, 2007) about this error, but there are no replies. I am getting this error when I issue the sp_setapprole command using sqlexecdirect() ODBC api call. Is there any way to work around this? Or is there a fix to the SQL Native Client? The error 15002 message text states "The procedure sys.sp_setapprole cannot be executed within a transaction". This is on a new connection so there should be no transactions active at the time. Thanks in advance for any info anyone can provide on this.

View 5 Replies View Related

Sql Native Client Or Sqlserver Client

Mar 3, 2007

Hi,

While using Sql Native Client ,VB Application giving error

"Transcation Cannot Start because more than one ODBC connection is in use"

But when useing SqlServer client then work perfectly ok.

Please guide where to use Sql Native Client.

Thanks

Rizwan



View 1 Replies View Related

SQL NATIVE CLIENT - OLE DB Connection On 64 Bit Client

Apr 23, 2008

I have tried this on several different operating systems (VISTA and XP ) and several versions of SQL NATIVE CLIENT including 2005.90.3042.0

I have a 64 bit "SQL NATIVE CLIENT" connection that fails. The exact same connection and code succeeds on 32 bit.
My customer and I prepend "oledb:" to the connection string and it starts working.

FAILS on 64 bit:
Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Wrigley_Test;Data Source=MONGO;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=RIPTIDE;Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False

WORKS
oledb:Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Wrigley_Test;Data Source=MONGO;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=RIPTIDE;Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False

I debugged my code to the point that I know it is happening when I call CreateAccessor for my SQL statement.


m_hr=m_pIAccessor->CreateAccessor(DBACCESSOR_ROWDATA, GetCols(), (m_pDBBinds+IsBookmarked()), 0, &m_hAccessor, NULL);

Error:

Microsoft SQL Native Client: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Does anyone have any suggestions?

View 6 Replies View Related

SQL Server VARCHAR(MAX) Column Returns Error While Inserting Records Into Table(ODBC Driver: SQL Native Client)

Aug 15, 2007

I created very simple table with 3 columns and one is varchar(max) datatype

When i insert records thru VC++ ADO code i am getting this error



Exception Description Multiple-step OLE DB operation generated errors. Check e
ach OLE DB status value, if available. No work was done. and Error Number:: -2147217887



ODBC Driver: SQL Native Client

SQL server 2005



Table

CREATE TABLE [dbo].[RAVI_TEMP](

[ID] [int] NULL,

[Name] [varchar](max) NULL,

[CITY] [varchar](50) NULL

)



VC++ code

#include "stdafx.h"
#include <string>
#include <strstream>
#include <iomanip>


int main(int argc, char* argv[])
{
try
{
HRESULT hr = CoInitialize(NULL);
_RecordsetPtr pExtRst = NULL;
_bstr_t bstrtDSN, bstrtSQL;
bstrtDSN = L"DSN=espinfo;UID=opsuser;PWD=opsuser;";
bstrtSQL = L"SELECT * FROM RAVI_TEMP";

_variant_t vartValueID,vartValueNAME,vartValueCITY;
_bstr_t bstrtValueID,bstrtValueNAME,bstrtValueCITY;

pExtRst.CreateInstance(__uuidof(Recordset));
hr = pExtRst->Open(bstrtSQL, bstrtDSN, adOpenDynamic, adLockOptimistic, adCmdText);

hr = pExtRst->AddNew();

bstrtValueID = L"1";
vartValueID = bstrtValueID.copy();

bstrtValueNAME = L"RAVIBABUBANDARU";
vartValueNAME = bstrtValueNAME.copy();

bstrtValueCITY = L"Santa Clara";
vartValueCITY = bstrtValueCITY.copy();

pExtRst->GetFields()->GetItem(L"ID")->Value = vartValueID;
pExtRst->GetFields()->GetItem(L"NAME")->Value = vartValueNAME;
pExtRst->GetFields()->GetItem(L"CITY")->Value = vartValueCITY;
pExtRst->Update();
pExtRst->Close();

}
catch(_com_error e)
{
printf("Exception Description %s and Error Number:: %d",(LPTSTR)e.Description(),e.Error());
return e.Error();
}
return 0;
CoUninitialize();
}


if i use regular SQL ODBC driver, no error but its truncating the data



Adv Thanks for your help

View 1 Replies View Related

SP2 Y SQL Native Client

Feb 20, 2007

Hello.

Does anybody knowk if it's necessary to upgrade Sql Native Client to conect to a Server when you has upgrade it to Sql 2005 SP2? That is to say, can you conect to a Sql server 2005 SP1 and to a Sql Server 2005 SP2 from a client with the same Sql Native client or you have also to upgrade it?

Thanks.

View 7 Replies View Related

Sql Native Client, VB6 App

May 14, 2007

We have a VB6 app that we're trying to connect to an SQL2005 server.


We're able to connect from dev machines that have SQLExpress, or SQL 2005 tools installed, but we cannot connect from other machines. We've installed sqlncli.msi from the MS site, but this still doesn't work. When we try to login, we get an error that reads "0[Microsoft][SQL Native Client]Fractional truncation" when we try writing to a smalldatetime field. This problem does not happen on the dev machines.


Connection string:

connectiontype = cnnSQLServer

database name = name

pasword = password

userid = uid

servername = servername

driver = {SQL Native Client}



Driver version on the dev machines is: 2005.90.3042.00

Driver version on the roll out machines is: 2005.90.1399.00



What are we doing wrong?



Zeke.

View 1 Replies View Related

SQL Native Client Driver

Aug 16, 2007

We're upgrading from SQL2K to 05 next week. We want to push the SQL Native Client driver(ODBC) thru the network but IT said it can only be an msi or exe file. Is their anyway we could get this file in this format?

View 4 Replies View Related

Sql Native Client Error

Sep 5, 2007

I'm new in this forum and I 'm Italian, so my English won't be perfect!

If i want to connect to my SQL Server database in prompt i type:

"osql -U sa" and then i type the password.
So, I get an error that says:

"[Sql Native Client] Provider Via: Impossible to find the specified module.
[Sql Native Client] Access timeout expired
[Sql Native Client] An error occured during the attempt to estabilish a connection to the server. During the connection to SQL Server this error may be caused by pre-defined settings that don't ......"


How i can solve this problem?
Who can help me?
Thank you!!

Maxx

View 3 Replies View Related

SQLOLEDB And The SQL Native Client

Mar 11, 2007

Hello,

Can I use the "SQLOLEDB" provider to connect to a SQL Native Client? Follow-up question: does the "SQLOLEDB" provider use the same TDS transport protocol as the SQL Native Client provider?

Thanks as always!

dotBomb

View 6 Replies View Related

SQL Native Client Issue?

Apr 23, 2008

The Clients Environment:
Windows Server 2003 R2
SQL Server 2005 SP1 Standard Edition Version 9.00.2153.00
SQL Native Client Version 2005.90.2047.0

My Development Environment
Windows XP
SQL Server 2005 SP1 Developer Edition Version 9.00.2047.0
SQL Native Client Version 2005.90.3042.0

The Error: [Microsoft] [ODBC SQL Server Driver] Fractional truncation

We have tons of VB 6 legacy code. (I know.. we are trying to get it to .Net.. just not enough time in the day) We recently installed our application at a cleints site (environment listed above) and all of a sudden we are getting errors every time we execute a rs.update using ADODB. I have pasted an example below. The kicker is that it runs fine in my development environment. I can get around this issue by using a command object to do the insert, but we have thousands of these sprinkled throughout the application and would take weeks to change them over; and of course this client demands to start using our application NOW. I am inclined to think that it is an issue with SQL Client since it does not appear to have been updated when the SP1 was installed. I have read some blogs about issues with SQL Native Client and datetime values.

'Broke Code
Dim RS as New ADODB.Recordet
Dim SQL as String
Dim datGetDate as Date

'THis select statement return an empty recordset. ID is an identity column
SQL = "SELECT * FROM table WHERE id is null
RS.Open SQL, gadoConn,adOpenKeySet, adLockOptimistic
RS.AddNew
RS("col1")=Value1
RS("col2")=Value2
RS("starttime")=datGetDate
RS.Update 'This is where it blows
RS.Close

'New and Improved code. Works perfectly
Dim SQL as String
Dim objCMD as new ADODB.Command

SQL = "INSERT INTO table(col1,col2,starttime) values('" & Value1 & "','" & Value2 & "','" & datGetDate & "')"


With objCMD
.ActiveConnection=gadoConn
.CommandText=SQL
.CommandType=adCmdText
.execute
End with

Thanks!

View 8 Replies View Related

Regarding SQL Native Client Driver.

Oct 15, 2007


I have created a table using SQL SERVER 2005 with column datatype as varbinary and with column size as 'MAX':-

i.e:
create table tablename {
column varbinary (MAX)
}

When i try to query for Column precision using SQL Native Client ODBC Driver it returns '0' instead of 2^31-1 (which is the value for MAX), but when i use other driver it works as expected. If i assign some value like varbinary(20) then it works.


Please let me know is there any fix pack available for this. Because one of our client is facing this problem, so we have to provide solution as early as possible:

Version of SQL Native Driver : 2005.90.1399.00

Any help would be appreciated.

View 4 Replies View Related

Sql Native Client Error

Sep 5, 2007

I'm new in this forum and I 'm Italian, so my English won't be perfect!

If i want to connect to my SQL Server database in prompt i type:

"osql -U sa" and then i type the password.
So, I get an error that says:

"[Sql Native Client] Provider Via: Impossible to find the specified module.
[Sql Native Client] Access timeout expired
[Sql Native Client] An error occured during the attempt to estabilish a connection to the server. During the connection to SQL Server this error may be caused by pre-defined settings that don't ......"


How i can solve this problem?
Who can help me?
Thank you!!

Maxx

View 1 Replies View Related

Native Client Confirmation

Sep 9, 2007

Hi

How can I check "Native client" is present on my client? I'm trying to eliminate all the reasons my client won't run a VC++ app which access a sql server.

thanks
Z

View 4 Replies View Related

Can't Find SQL Native Client In ODBC Connection Manager In SQL Server Open Database Connectivity (ODBC)

Feb 13, 2007

I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.

I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?

View 4 Replies View Related

Performace Issue With SQL Native Client

Jun 4, 2008

and TCP as a connection method.

When using Named Pipes the issue is no longer there.

On massive batch inserts we sometimes get a long pause at the end of one insert and before begining the next one. Example:

1000 inserts in the same table and then repeat. This will work fine for 3 or 4 iterations, then pause during the 5th iteration for up to 40 seconds and then simply continue.

When this exact same procedure is done using Named Pipes as the connection method this never happens.

While this is happening neither the server or the workstation is doing anything, 0% CPU, 0% network, it just sits there.

All this using the SQL Native Client 2005 and ADO.

Anyone have any ideas?

View 8 Replies View Related

OLE DB Connection Fails; Native Client Does Not

Feb 4, 2008

I cannot connect to my SQL2005 server using the old SQL ODBC drivers, I have to use the Native client drivers. The database I am trying to connect to is a SQL 2000 db I just attached. Its owner is a SQL user login, which works fine and can connect remotely.

Thoughts?

Possibly related: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96732

View 1 Replies View Related

SQL Native Client Installation Failed

Feb 8, 2008

All,

I was trying to install SQL Server 2005 on Windows 2003 Server and it failed on installing one of the components "SQL native Client",

the Error message is

The Installation Package of the Product Microsoft SQL Server Native Client cana not be found. Try the Installation again using the Valid copy of the installtion package "sqlncli.msi"

Thx

View 2 Replies View Related

Odbc Using Native Client Fail

Aug 26, 2007

I installed sql2005 on server, created odbc connection , sucess connection.
I installed native client on pc. pc ping server sucessfully. I created odbc using sa with valid password (as i do in server), when completing give error " sql server does not exist or access denied" , and can not connect with server.
how can i resolve the problem.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved