I'm installing SQL7 on an NT4 SP5 server. It tells me it needs to check the ODBC drivers but then says they are
being held by an application. There are no ODBC drivers installed on this machine to be held.
What do I do? Install some drivers?
Hallo, my problem is to upgrade instance of SQL7 to SQL7 SP4.
Server is WIN2K SP4 + MDAC 2.8 SP1
Installing the SQL7 Server from CD is OK.
When i try to apply the SQL7 SP4 the first fase, when SP4 checks all conditions to start is OK, when start to copy file i receive an error -113 like this
--------------------------------------------------------------
Error occurred during the move data process: -113
Component Server: base server base server files
File Group: Base Server Files
File: C:70SP4X86Setup.....SQLIMAGE.DLL
--------------------------------------------------------------
On server is installed the library SQLDMO.DLL for SQL2000 but only the library used by an application VB6.
In need to install SQL7 and i can't install SQL2000 or SQL2005 because we work with an application written for SQL7. I've tried to migrate application SQL2000 but not work properly.
Somebody can help me ?
Thanks in advance.
Aragorn
does anyone know where i can find an ODBC sql7.0 vers. 3.70.06.23 installation routine?
View 1 Replies View RelatedAre there any well known articals/sites on this topic?
View 1 Replies View RelatedI have been asked to install Sql 7 on a Win2K server. I am looking for White papers, articles, postings etc which identify potential issues or known issues. I have looked through MSDN, Win2K, Microsoft Sql7 and TechNet for specifics. Any suggestions?
Thank you,
Troy
We have multiple NT machines which have/require Service Pack 3 installed and run an application which makes an ODBC connection to an SQL 7 DB. Some of them are experiencing ODBC issues.
Question: Are there any known ODBC compatability issues with machines runnings service pack 3 ODBC connecting to SQL 7 running NT Service Pack 4?
hi ,
i have a problem here..
we are having sql 6.5 and 7.0 ...
One of my user is trying is using ACCESS AND POWERBUILDER applications to connect to sql server.
I gave a select permissions to the particular user on one database.
With access he is able to connect both versions(6.5 and 7.0) databases..
With powerbuilder he is only able to connect to 6.5 only, he is getting problem with 7.0.
when he tried to connect to 7.0 thru powerbuilder it is saying
unable to connect to database
LOGIN INCORRECT.
is it requires any new drivers with 7.0( i am using sp2)..
Pls help me in this regard..
Thank u
---Venkat
Hi everyone
I have just installed SQL Server 2005, default settings. I have attempted to add a new ODBC driver using Control Panel - Administrative Tools - Data Sources (ODBC) - System DSN tab - Add - SQL Server - default settings, but it fails.
I did all this for MySQL some months ago, but I must have forgotten something.
Please can someone tell me what to do next.
Thanks in advance.
Jonathan
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?
I'm attemting to replicate from a SQL7 box to SQL2000.
The snapshot works fine, but it fails when it tries to push the subscription to the SQL2000 box with a trust error (I don't recall the exact message). I noticed that it fails when Enterprise Mgr is configured as: "Tools/Replication/Configure Publishing, Subscribers and Distribution", Subscriber Tab, "Impersonating SQL Service Agent". It works if I change to "SA".
This is only the case when we replicate from SQL7 to SQL2K. SQL7 to SQL7 works fine with "Impersonating". Has anybody seen this behavior? Any workarounds, other than using SA?
Hi,
I am running SQL7 SP2 on a Compaq Proliant 5500 (NT4 Server SP6a) with dual processor.
When trying to schedule any jobs with DTSRUN I get the following error:
DTSRun.exe - Application Error
The instruction at "0x77f64d7b" referenced memory at "0x00000010". The memory could not be read.
Has anyone seen this error before ??
Regards,
Tim
I have a SQL6.5 sp5a, NT4 sp5, BDC, IE5 server that I have installed SQL7
on. My installation is set to mixed security.
Everytime I try to run the upgrade wizard I get the following error/problem
right after the "Checking 6.x syscomments for corruption and Verifying 6.x
data base logins etc.
Summary of warnings (if any) and choices:
=============================================
The following syscomments entries are invalid on your 6.x SQL Server. It is
recommended that you fix these problems before you continue.
=============================================
********************************
master
********************************
********************************
Inconsistency Report For Database: master.
********************************
dbo.sp_db_upgrade2
Procedure
Occurs 28 times
[Microsoft][ODBC SQL Server Driver][SQL Server]Ad-hoc updates to system
catalogs not enabled. System Administrator must reconfigure system to allow
this.
--------------------------------
dbo.sp_fallback_activate_svr_db
Procedure
Occurs three times
[Microsoft][ODBC SQL Server Driver][SQL Server]Ad-hoc updates to system
catalogs not enabled. System Administrator must reconfigure system to allow
this.
--------------------------------
dbo.sp_password
Procedure
[Microsoft][ODBC SQL Server Driver][SQL Server]Ad-hoc updates to system
catalogs not enabled. System Administrator must reconfigure system to allow
this.
--------------------------------
dbo.sp_recompile
Procedure
[Microsoft][ODBC SQL Server Driver][SQL Server]Ad-hoc updates to system
catalogs not enabled. System Administrator must reconfigure system to allow
this.
--------------------------------
dbo.sp_rename
Procedure
Occurs 11 times
[Microsoft][ODBC SQL Server Driver][SQL Server]Ad-hoc updates to system
catalogs not enabled. System Administrator must reconfigure system to allow
this.
--------------------------------
=============================================
The following script will be created as upgrade.ini and run into the script
interpreter when you press finish.
=============================================
[Options]
Method=1
Perform a CRC Check=0
Source=CCIDEV
Destination=CCIDEV
Export Server Startup Options=
Import Server Startup Options= -T1808
SQLServer70Path=C:MSSQL7SourcePassword=066ce2f9c0e 4ba
DestinationPassword=00
MasterPath=C:MSSQLDATAMASTER.DAT
VerswitchOldVer=65
Code Page=1252
Override Server Code Page=0
QuotedIdentifiers=0
ObjectDumpPath=c:mssql7upgradeCCIDEV_071399_163117 Ansi Nulls=0
[Tasks]
Export and Import via Named Pipe=0
Marking database upgrade status=0
Export Logins=0
Export Database Owners=0
Import Logins=0
Creating Databases=0
Setting Database Options=0
Export Database Objects=0
Import Database Objects=0
Export SQL Executive Settings=0
Preparing MSDB for Upgrade=0
Import SQL Executive Settings=0
Export Server Settings from Master=0
Modifying Scripts=0
Import Server Settings from Master=0
Preparing SQL-DMO for upgrade=0
[Databases]
006CCIDATA=0
003model=0
005msdb=0
001master=0
I don't find anything about this anywhere except the upgrading to SQL7 white
paper, it mentions that the text for objects must be intact in the
syscomments system table and that logins must exist for every database user,
but that doesn't really tell me how to fix this.
Has any one seen these errors or can point me
to where on Microsoft's site you can now EASILY get KB info for SQL Server
7?
In SQL 7 DTS I'm creating a Data Driven Query Tasks. When I get to writing the transformations in VB Script and try using the Test button to test the script, I get the following message:
Error Source: Microsoft Data Transformation Services Flat File Rowset
Provider
Error opening datafile. The system cannot find the file specified.
The documentation says:
[The transformation is tested] by executing it against a part of the
source data and copying the results to a temporary text file, for
preview purposes.
I can find no place to specify what temporary file is used for the test result and, because it is temporary, have assumed the system creates and
deletes it as needed.
Is this true?
I get this test error for every transformation. even those that work correctly when the DTS package is actually executed.
What can I do to get the transformations to test properly?
Any help or hints will be greatly appreciated.
===============================
William J Brown
Systems Analyst
College of Human Medicine
A114 East Fee Hall
Michigan State University
East Lansing, MI 48824
Voice: (517) 432-7490
Fax: (517) 355-0342
Email: brownwj@msu.edu
I'm attemting to replicate from a SQL7 box to SQL2000.
The snapshot works fine, but it fails when it tries to push the subscription to the SQL2000 box with a trust error (I don't recall the exact message). I noticed that it fails when Enterprise Mgr is configured as: "Tools/Replication/Configure Publishing, Subscribers and Distribution", Subscriber Tab, "Impersonating SQL Service Agent". It works if I change to "SA".
This is only the case when we replicate from SQL7 to SQL2K. SQL7 to SQL7 works fine with "Impersonating". Has anybody seen this behavior? Any workarounds, other than using SA?
Hi,
I have backup of data from SQL Server 7.0 and now when i'm trying to restore it into SQL Express 2005, I'm getting following error......
--------------------
Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'GOSLDW' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
--------------------
Here is SQL i'm using to restore database,
RESTORE DATABASE GOSLDW
FROM DISK = 'C:sqlserverDataGOSLDW'
WITH MOVE 'GOSLDW' TO 'C:sqlserverDataGOSLDW.mdf',
MOVE 'GOSLDW' TO 'C:sqlserverDataGOSLDW.ldf'
GO
Why i'm getting this error? Am i missing anything here?
Thanks in advance for your HELP.
- R
Hi Everybody,
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application.
--------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.]
Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838
Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
The following (VB.Net) code causes exceptions at seemingly random times.
Any suggestions?
Not sure if the problem is in .Net's ODBC support or in Sql Native Client.
If MARS is off, usually after less than 100 loops:
Code Snippet
System.Data.Odbc.OdbcException was unhandled
ErrorCode=-2146232009
Message="ERROR [HY000] [Microsoft][SQL Native Client]Connection is busy with results for another command"
Source="SQLNCLI.DLL"
Turning MARS is on bypasses that error, so it will sometimes survive a thousand or so runs before hitting:
Code Snippet
System.Data.Odbc.OdbcException was unhandled
ErrorCode=-2146232009
Message="ERROR [23000] [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'Number', table 'tempdb.dbo.#TempTable___..(shortened to fit).. _________000000002F3F'; column does not allow nulls. INSERT fails.
Source="SQLNCLI.DLL"
Code here:
(Console Application, empty database,
Visual Studio 2005, .Net 2.0, Windows XP,SQL Server 2005 or SQL Express 2005, Local or Remote)
Code Snippet
Module Module1
Sub Main()
'Dim connection As New SqlClient.SqlConnection("database=TestDB;server=.sqlexpress;Integrated Security=SSPI;") 'Doesn't crash
'Dim connection As New OleDb.OleDbConnection("Provider=SQLNCLI;database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Doesn't crash
'Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Crashes
Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;MARS_Connection=yes") 'Crashes
VBMath.Randomize()
Dim run_count As Integer = 1
connection.Open()
Console.WriteLine("Connected!!")
While True
'connection.Open()
Dim testcmd As New Odbc.OdbcCommand("CREATE TABLE [#TempTable] (Number int PRIMARY KEY)", connection)
testcmd.ExecuteNonQuery()
testcmd.Dispose()
testcmd = Nothing
Dim dtTemp As New DataTable
Dim daTemp As New Odbc.OdbcDataAdapter("SELECT * FROM [#TempTable]", connection)
daTemp.MissingSchemaAction = MissingSchemaAction.AddWithKey
daTemp.Fill(dtTemp)
Dim cbTemp As New Odbc.OdbcCommandBuilder(daTemp)
Dim viewTemp As New DataView(dtTemp, Nothing, "Number", DataViewRowState.CurrentRows)
Dim i As Integer
For i = 1 To 1000
Dim test_number As Integer = CInt(Rnd() * 2000)
If viewTemp.Find(test_number) = -1 Then 'Keep it unique
Dim new_temp_row As DataRowView = viewTemp.AddNew()
new_temp_row("Number") = test_number
new_temp_row.EndEdit()
End If
Next
daTemp.Update(dtTemp)
'daTemp.Dispose()
'daTemp = Nothing
'cbTemp.Dispose()
'cbTemp = Nothing
'dtTemp.Dispose()
'dtTemp = Nothing
'viewTemp.Dispose()
'viewTemp = Nothing
Dim testcmd2 As New Odbc.OdbcCommand("DROP TABLE [#TempTable]", connection)
testcmd2.ExecuteNonQuery()
testcmd2.Dispose()
testcmd2 = Nothing
'connection.Close()
'GC.Collect()
'Console.Write(".")
run_count += 1
End While
End Sub
End Module
Usually the ".Update" triggers the exception, but sometimes the other sql commands do it.
Have tried various experiments with disposing of objects immediately when finished, but no effect.
Opening and closing the connection each loop seems to delay the errors, but it still happens eventually.
I have an application that connects to SQL 2000 thru ODBC.
When our administrators login on the workstation the application
works well. But when ordinary users login they get the following error.
SQLState: 28000
SQL Server Error: 18452
Login failed for user ". The user is not associated with a trusted SQL Server connection.
I have restarted SQL Server and IIS to no avail. We are using SQL and Windows auth mode.
Any ideas? This just started this morning.
We have an application that connects to SQL 2005 thru ODBC with the following string:
driver=SQL Server;server=server1;database=db2005;uid=serveruser;pwd=pwd1;
When our administrators login on the workstation the application works well. But when ordinary users login they get the following error. (We only have 1 domain)
SQLState: 28000
SQL Server Error: 18452
Login failed for user ". The user is not associated with a trusted SQL Server connection.
Then the standard SQL Server Login window pops up asking for the Login ID and Password. On the window the 'Use Trusted Connection' is checked and the name of the user on the workstation appears on the LoginID. What we do is uncheck the 'Use Trusted Connection' then login using the credentials above.
Need help on this one please. Thanks.
I keep getting this error:
OLE DB error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000
I do not want to add the login account to sysadmin role on my production server and giving the logon account db_reader rights to my database is not working. Is there another way around it.
I have tried installing SQL Express using the latest download. I've also intalled the latest Windows Installer (3.1) but I have the following error message (taken from log). All contributions gratefully accepted
View 3 Replies View RelatedWhen I run some code through an odbc driver onto a SQL server 6.5 database, from vb an error is being returned along the lines of
22005 Syntax error converting 'string' to INT4
if I copy this code, either from vb or from sql trace, and run it in isql the code runs without any errors.
The only thing I have found is about NULLs so I have removed these from the code that is passed through?
Any more suggestions?
I have been searching high and low for days and I am perplexed and appalled at the lack of information regarding what can not be an isolated incident.
We are trying to get an Analysis Services 2005 to process on a x64 server. We have both versions of the Oracle client installed and .ora file in both places. I have seen a couple of posts regarding this issue, but they are 2 years old and MS was supposed to have resolved the 'parentheses' issue long ago.
The test connection succeeds, and I can explore the data in the datasource view, but I cannot process the cube. All I get is the "OLE DB error: OLE DB or ODBC error: Class not registered"
Microsoft Windows Server 2003 R2
Enterprise x64 Editon
Service Pack 2
Installed Oracle Client 10g and ODAC home
I tried a few things that were suggested in posts, but nothing has worked. I tried the cmd line starting SSMS from progra~2 instead of (x86). I tried renaming the directory with no parentheses. This is the second time we've tried to get it to work in 2 years. We'll probably give up again and stay with x86, um, because it works without all these silly mickey-mouse tricks. Most of our relational DBs are ORACLE so this is a showstopper for us as far as trying to go x64.
Sorry for the attitude, but I'm really frustrated!
If anyone can tell me a way to resolve this (or that it can't be resolved), I'd really appreciate it!
How can I copy a SQL 7 database from one server to another? Please tell me all the ways because I've tried the obvious and it doesn't work. (backup and restore - won't go from one server to another, DTS transfer object Wizard - does a whole pile of errors and doesn't do stored proceedures and trigures). Thanks for help in advance. Also, what is the email address to post to the listserv and where is the FAQ for SQL7? Most of my listserv's tell you where to post right at the bottom of the digest I get - any chance you guys would do that with this list? Thanks again.
View 6 Replies View RelatedOracles ( ;) )
I'm trying to install SQL Svr 2K EE 64-bit on Win 2K3 R2 EE 64-bit (fully patched), and I get the error:
The image file setup.exe is valid, but is for a machine type other than the current machine.
I've googled, but no one I know has had the issue with Win 2K3 R2, let alone in a 64-bit environment.
Has anyone come across this, or do I need to refer it to MS?
Geoff
Hey!
I need install ms SQL server 2000.... Everything is fine, but when I finish installing then hop one bullshit !screen! (http://www.danger.lv/bitbucket/sqlmsinstallerror2.jpg)
and here are sqlstp.log (http://yy.lv/upload/down.php?f=1724)
How i can fix it?
Thanx!
Dear All,
i'm using sql server 2005 client tools till yesterday. today i got the powers to take the server tools, and while installing i'm getting error(while installing database services.....i think i've chosen the right one) like......ADhelper is disabled for your system hardware configuration. so please provide me guidance to solve this problem....
i'm using 2000 professional with service pack4. i've 2000 client tools also in my machine.
how can i install sql server 2005 server tools...
and one more doubt...
there are several tools like...
1)analysis services
2)reporting services
3)integration services
4)database services
like that....
when should we use these
thank you very much
Vinod
Even you learn 1%, Learn it with 100% confidence.
I started getting this after installing sp1 on my workstation and trying to deploy to rtm machines. The components giving this error are the data readers in the data flow.
TITLE: Microsoft Visual Studio
------------------------------
Component with name "<name>" and class ID "{BF01D463-7089-41EE-8F05-0A6DC17CE633}" could not be created because an error was encountered during its upgrade to the current version.
Contact information:
Extracts data from a relational database by using a .NET provider.;Microsoft Corporation;Microsoft SqlServer v9; © 2004 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;2
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=ComponentUpgradeFailed&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Iv'e searched other forums and websites for this, but I cant solve it.
When I try to install SQL 2000 I get an error about Low Registry Quota.
Any idea on how to solve this?
When installing SQL Server 2005 the first component to be installed by the setup it is it (.NET Framework 2.0), but it happens the following mistake
" Error 193 installing .NET Framework 2.0 "... what is doing wrong and which would be solution
i installed an service pack 2
Quick Details
Version:
9.00.3042
Knowledge Base (KB) Articles:
KB921896
Date Published:
3/6/2007
Language:
English
Download Size:
282.4 MB - 392.4 MB*
*Download size depends on selected download components.
the above installation , i was success. but the version is 9.00.3042. so what i did was i stalled the hot fix , http://support.microsoft.com/kb/933097
but this hox fis installation is success for all, but it failed for database services with below error message :
product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3152
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB933097_sqlrun_sql.msp.log
Error Number : 29537
Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.
now i don't know what to do...
i don't want to uninstall sqlserver 2005 and redo the whole thing...
because thisd is my first assinment in the new job and if i redo the whole thing then it won't be good since it'll take 1 week..
is there any way i can solve this issue??
i'm trying to install MS server 2000 components and I continuously get the same error. "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup." I've rebooted 100 times, turned the machine on and off, installed other programs, etc. and stil I get the error ONLY when I try to install the components.
View 4 Replies View RelatedI'm getting this bizarre error installing SP2 despite the fact that I'm an adminstrator on the box. Any ideas?
Product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB933097_sqlrun_sql.msp.log
Error Number : 1304
Error Description : MSP Error: 1304 Error writing to file: Microsoft.SqlServer.MaintenancePlanTasks.dll. Verify that you have access to that directory.
From the log file :
MSI (s) (94:3C) [21:17:15:468]: File: C:MSSQL90DTSTasksMicrosoft.SqlServer.MaintenancePlanTasks.dll; Overwrite; Won't patch; Existing file is a lower version
MSI (s) (94:3C) [21:17:15:468]: Source for file 'SDK.Sql.MaintPl.Tasks.dll.9FE6A645_715C_4D0E_B93D_E8A237639877' is compressed
MSI (s) (94:3C) [21:17:15:468]: Re-applying security from existing file.
MSI (s) (94:3C) [21:17:15:468]: Verifying accessibility of file: Microsoft.SqlServer.MaintenancePlanTasks.dll
MSI (s) (94:3C) [21:17:15:468]: SOFTWARE RESTRICTION POLICY: Verifying object --> 'C:WINDOWSInstaller35ba74.msp' against software restriction policy
MSI (s) (94:3C) [21:17:15:483]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (94:3C) [21:17:15:483]: SOFTWARE RESTRICTION POLICY: C:WINDOWSInstaller35ba74.msp is not digitally signed
MSI (s) (94:3C) [21:17:15:483]: SOFTWARE RESTRICTION POLICY: C:WINDOWSInstaller35ba74.msp is permitted to run at the 'unrestricted' authorization level.
MSI (s) (94:3C) [21:17:15:515]: Note: 1: 2318 2: C:MSSQL90DTSTasksMicrosoft.SqlServer.MaintenancePlanTasks.dll
MSI (s) (94:3C) [21:17:15:515]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:515]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:515]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:515]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:515]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:530]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:530]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:530]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:530]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:530]: Executing op: SetTargetFolder(Folder=C:MSSQL90DTS)
MSI (s) (94:3C) [21:17:15:530]: Executing op: SetSourceFolder(Folder=1PFilesMICROS~190DTS|Program FilesMicrosoft SQL Server90DTS)
MSI (s) (94:3C) [21:17:15:530]: Executing op: AssemblyCopy(SourceName=MaintPl.dll|Microsoft.SqlServer.MaintenancePlanTasks.dll,SourceCabKey=MS.Sql.MaintPl.Tasks.dll.9FE6A645_715C_4D0E_B93D_E8A237639877,DestName=Microsoft.SqlServer.MaintenancePlanTasks.dll,Attributes=20480,FileSize=292208,PerTick=32768,,VerifyMedia=1,,,,,ComponentId={25B1696A-C007-43B9-9C08-299794B2095D},IsManifest=1,,,AssemblyMode=0,)
MSI (s) (94:3C) [21:17:15:530]: Source for file 'MS.Sql.MaintPl.Tasks.dll.9FE6A645_715C_4D0E_B93D_E8A237639877' is compressed
MSI (s) (94:3C) [21:17:15:561]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:561]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:561]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:561]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:561]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:561]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:561]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:561]: Note: 1: 2360
MSI (s) (94:3C) [21:17:15:561]: Note: 1: 2360
MSI (s) (94:18) [21:17:15:593]: Assembly Error:Version %d.%d is not a compatible version.
MSI (s) (94:18) [21:17:15:593]: Note: 1: 1935 2: 3: 0x80131107 4: IStream 5: Commit 6:
MSI (s) (94:3C) [21:17:15:593]: Note: 1: 1304 2: Microsoft.SqlServer.MaintenancePlanTasks.dll
MSI (s) (94:3C) [21:17:15:593]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:593]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:608]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:608]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:608]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:608]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:608]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:608]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:608]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:624]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:624]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:624]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:624]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:624]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:624]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:640]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:640]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:640]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:640]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:640]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:640]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:640]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:640]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:640]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:640]: Transforming table Error.
MSI (s) (94:3C) [21:17:15:640]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (94:3C) [21:17:15:640]: Product: Microsoft SQL Server 2005 -- Error 1304. Error writing to file: Microsoft.SqlServer.MaintenancePlanTasks.dll. Verify that you have access to that directory.
Error 1304. Error writing to file: Microsoft.SqlServer.MaintenancePlanTasks.dll. Verify that you have access to that directory.
MSI (s) (94:3C) [21:17:15:686]: User policy value 'DisableRollback' is 0
MSI (s) (94:3C) [21:17:15:686]: Machine policy value 'DisableRollback' is 0
Action ended 21:17:15: InstallFinalize. Return value 3.
MSI (s) (94:3C) [21:17:15:702]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=924953128,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (94:3C) [21:17:15:702]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (94:3C) [21:17:15:702]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005)
MSI (s) (94:3C) [21:17:15:702]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (94:3C) [21:17:15:702]: Executing op: RegisterBackupFile(File=C:Config.Msi35ba79.rbf)
MSI (s) (94:3C) [21:17:15:702]: Executing op: ActionStart(Name=InstallFiles,Description=Copying new files,Template=File: [1], Directory: [9], Size: )
MSI (s) (94:3C) [21:17:15:702]: Executing op: SetTargetFolder(Folder=C:MSSQL90DTS)
MSI (s) (94:3C) [21:17:15:702]: Executing op: ProductInfo(ProductKey={EB76B218-8FC5-41DF-9F1F-7FF3E0448383},ProductName=Microsoft SQL Server 2005,PackageName=SqlRun_SQL.msi,Language=1033,Version=151129058,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=Setup,PackageCode={A6BDF070-B4CF-4DD8-A75B-727F96DDBFDC},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0)
MSI (s) (94:3C) [21:17:15:702]: Executing op: SetTargetFolder(Folder=C:MSSQL90DTSTasks)
MSI (s) (94:3C) [21:17:15:702]: Executing op: FileCopy(SourceName=C:Config.Msi35ba79.rbf,,DestName=C:MSSQL90DTSTasksMicrosoft.SqlServer.MaintenancePlanTasks.dll,Attributes=32800,FileSize=296304,PerTick=0,,VerifyMedia=0,ElevateFlags=3,,,,,,,InstallMode=4194308,,,,,,,)
MSI (s) (94:3C) [21:17:15:702]: File: C:MSSQL90DTSTasksMicrosoft.SqlServer.MaintenancePlanTasks.dll; Overwrite; Won't patch; REINSTALLMODE specifies all files to be overwritten
MSI (s) (94:3C) [21:17:15:702]: Executing op: ActionStart(Name=CreateFolders,Description=Creating folders,Template=Folder: [1])
MSI (s) (94:3C) [21:17:15:702]: Executing op: FolderRemove(Folder=C:MSSQL90DTSConnections,Foreign=0)
MSI (s) (94:3C) [21:17:15:702]: Executing op: FolderRemove(Folder=C:MSSQL90DTSLogProviders,Foreign=0)
MSI (s) (94:3C) [21:17:15:702]: Executing op: FolderRemove(Folder=C:MSSQL90DTSPackages,Foreign=0)
MSI (s) (94:3C) [21:17:15:702]: Executing op: FolderRemove(Folder=C:MSSQLMSSQL.1MSSQLBinn,Foreign=0)
MSI (s) (94:3C) [21:17:15:702]: Executing op: FolderRemove(Folder=f:MSSQLMSSQL.1MSSQL
epldata,Foreign=0)
MSI (s) (94:3C) [21:17:15:702]: Executing op: FolderRemove(Folder=f:MSSQLMSSQL.1MSSQLJOBS,Foreign=0)
MSI (s) (94:3C) [21:17:15:718]: Executing op: FolderRemove(Folder=C:Program FilesMicrosoft SQL Server90SharedASConfig,Foreign=0)
MSI (s) (94:3C) [21:17:15:718]: Executing op: FolderRemove(Folder=C:Program FilesMicrosoft SQL Server90SharedErrorDumps,Foreign=0)
MSI (s) (94:3C) [21:17:15:718]: Executing op: FolderRemove(Folder=C:MSSQL,Foreign=0)
MSI (s) (94:3C) [21:17:15:718]: Executing op: FolderRemove(Folder=C:MSSQL,Foreign=0)