Error: Server Agent Cant Find Dts File
Apr 17, 2006
Im trying to schedule an integration sevice package with no anvile. I have tried both running it in Agent under Integration services and operation system (CmdExec) and still wont work. Under CmdExec, the command is /FILE "C:Documents and SettingsebuahMy DocumentsVisual Studio 2005ProjectsSwamp_SolutionFIRSTTIME_DOWNLOADSSIS_ACT.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF. In the advance tab, I checked outfile to a log.txt file so as to read the log if there was any errors. The account running the job is the same account that sql server agent services is running which would only mean I really dont need any proxy account to run the job. When i run the job under CmdExec, i get the error
Message
Executed as user: CYPRESSAdministrator. The process could not be created for step 1 of job 0x529C255F20199B40A83858B1CCC875F2 (reason: The system cannot find the file specified). The step failed.
when I run the same package under integeration system, the error I get in the logg file is
<record>
<event>OnError</event>
<message>System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction)
at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)</message>
<computer>SPIDERMAN</computer>
<operator>CYPRESSAdministrator</operator>
<source>ACT TABLE 250</source>
<sourceid>{99b92f4c-686d-47a6-b136-4d1ec698c837}</sourceid>
<executionid>{CD95BB1A-7FE4-468B-904D-C02B3FEBF1B0}</executionid>
<starttime>4/17/2006 1:20:47 PM</starttime>
<endtime>4/17/2006 1:20:47 PM</endtime>
<datacode>-1073450910</datacode>
<databytes>0x</databytes>
</record>
If you ask me, I dont know whats going on but I am very fustrated. Have been working on this for 4 days now. I really really need help.
View 7 Replies
ADVERTISEMENT
Jun 8, 2007
I am able to run SSIS packages as SQL Server Agent jobs with a Control Flow items "File system task", if I move a file (test.txt) from a drive (c on the server (where SQL Agent jobs run) to a subdirectory on the same drive. But, if I try to move a file on a network drive, the package fail.
What I can do to solve this issue.
Bye!
Daniel
View 1 Replies
View Related
Jan 10, 2008
Hi,
I have an SSIS package designed to copy across a file from local machine to a location on the network.
The SSIS package works fine when I run it directly run it in the Designer, ie, it copies over the file to the network.
But when I run the package through the Job server agent, it fails giving me a validation error on the network path..
Does it have to do with the permissions of the User account used here? Could anyone please provide any information on this....
Thanks
View 14 Replies
View Related
Jul 31, 2006
Dear All,
I have installed SQL Server 2005 Express Edition, Iam not able to find SQL Agent, So anybody help me............................
Regards,
Vinayak
View 12 Replies
View Related
Jan 31, 2007
Hi,
I use the DTS 2000 Migration Wizard to migrate one of the DTS 2000 packages to SSIS. The migration failed with the following error message:
LogID=17
#Time=6:31 PM
#Level=DTSMW_LOGLEVEL_ERR
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: Failed to save package file "C:Documents and SettingsfuMy DocumentsVisual Studio 2005ProjectsKORTONKORTONProcessCubesMF.dtsx" with error 0x80070002 "The system cannot find the file specified.".
---> System.Runtime.InteropServices.COMException (0xC001100E): Failed to save package file "C:Documents and SettingsfuMy DocumentsVisual Studio 2005ProjectsKORTONKORTONProcessCubesMF.dtsx" with error 0x80070002 "The system cannot find the file specified.".
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToXML(String FileName, IDTSPersist90 pPersistObj, IDTSEvents90 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)
at Microsoft.SqlServer.Dts.MigrationWizard.DTS9HelperUtility.DTS9Helper.SaveToXML(Package pkg, String sFileLocation)
at Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework.StartMigration(PackageInfo pInfo)
Looking at the call stack, it looks like COM wrapper fails on SaveToXML. Can someone tell me how I should workaround this problem?
Thanks,
Bobby Fu
View 1 Replies
View Related
May 29, 2013
When I give job Id in filter of this query this will give job status of "Success" but actually my job is currently in executing stage. I want to get all jobs that are currently in executing status.
Use msdb
go
select distinct j.Name as "Job Name", --j.job_id,
case j.enabled
when 1 then 'Enable'
when 0 then 'Disable'
[Code] ....
View 4 Replies
View Related
May 13, 2004
Windows 2000 Server SP4 + SQL Server 2000 Enterprise Editon SP3,RAID5.
the windows event log give the following error information:
I/O error 2(The system cannot find the file specified) detected during write at offset 0x0000010c6c4000 in file 'D:Program FilesMicrosoft SQL ServerMSSQLdataGJSZBANK_Data.MDF'.
I have searched microsoft knowledge base and got this article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;828339
but don't understand some contents in the topic:
For example, if you encounter the following error message in the SQL Server Errorlog file, SQL Server encountered operating system error 2 when it uses a Windows API call to write to the tempdb primary database file:
Error: 823, Severity: 24, State: 4
I/O error 2(The system cannot find the file specified.) detected during write at offset 0x00000000284000 in file 'D:Program FilesMicrosoft SQL ServerMSSQLdata empdb.mdf'
Because SQL Server has already successfully opened the file and did not receive an “Invalid Handle” error, the error is likely being raised in a lower-level kernel software component, such as the file system or a device driver. This problem does not indicate a problem in SQL Server, and it must be investigated as an issue with the file system or a device driver that is associated with the file.
Does that mean this is not a SQL Server error?
Does that mean something wrong with my operating system? or something wrong with my hard disk?
View 1 Replies
View Related
Feb 28, 2007
I created an assembly to access my SSRS web service in a Script task. The package runs fine on my machine but gets the following error from the production box.....
The script threw an exception: Could not load file or assembly 'Microsoft.SqlServer.ReportingServices2005, Version=0.0.0.0, Culture=neutral, PublicKeyToken=3bd4760abc5efbcb' or one of its dependencies. The system cannot find the file specified.
I followed the exact same procedures for creating the .dll on the production box as I did developing on my machine...strong name, load to gac etc....but it still cannot find it.
My production SQL Server is 64 bit so perhaps there is another step I need to take? Anyone have a clue as to what I may be missing?
TIA
View 1 Replies
View Related
May 27, 2008
Hi,
I have a SQL Server Agent job set up to run a job that calls a dts package on the server.
When I run the DTS Package manually, everything works fine and does what it is supposed to do.
When I run the job, The job fails. If somebody had this error can you please help me out
I am getting following error in my job...
DTSRun: Loading...Error: -2147287038 (80030002);
Provider Error: 0 (0)
Error string: The system cannot find the file specified. Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 713.
Process Exit Code 1. The step failed.
could you please let me know what is the possible cause for the above error.
Many Thanks,
Madhu
View 1 Replies
View Related
Sep 13, 1999
when I put a Visual Basic Exe file in SQL Agent Job...It won't work at all.
What is the problem...?
Pl response immediately.
View 4 Replies
View Related
Jun 2, 2008
In Management Studio i highlight my query and then click on 'Analyse query in Database Engine Advisor' but i get the following error message: "Failed to connect to an IPC Port: The system cannot find the file specified". Seems like if I reboot my computer it works one time then get the same error on the second time.I'm running developer edition with service pack 2.
View 8 Replies
View Related
Mar 8, 2007
Hi,
I have a package which calls another package. It had been working fine for a while. Recently I changed the connection managers' names. Everything in the parent package works fine. Database has been updated correctly. But when it comes to calling the child package it generates :
OnError,CRPRCHMSQCZ,,Execute AMSClientAgentMaintenance,,,3/8/2007 5:49:38 PM,3/8/2007 5:49:38 PM,-1073602332,0x,Error 0x80070002 while preparing to load the package. The system cannot find the file specified.
. (there is a period here instead of a file name)
I tested the child package on the server. It works fine. I connected the child package to the Execute Package Task by selecting from the packages on the server. So it is there for sure. Connection manager's name is read from the .dtsConfig. Child package is executed from my development machine but not on the server. I made a small test package just to call this child package, it generates the same error...
Any help is appreciated
Gulden
View 6 Replies
View Related
Jan 16, 2008
I know there are already several bug submissions on this error, and I am sure the cryptoAPI team is working to resolve this issue.. However... Is it possible that the CAPICOM update (KB931906) could have contributed to this issue? In my instance, I installed SQLServer 2005 Express w/ Adv Tools SP2 after a freash XP install. I checked it out, and everything worked fine. I updated windows (online) and now it gives this error. In fact, I cannot even run the un-install because the setup utility also hits the following error (as taken from the log file):
Microsoft SQL Server 2005 Setup beginning at Wed Jan 16 12:47:35 2008
Process ID : 576
d:97352a1d146f8bca5542016500a05210setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2008/0/16 12:47:35
Complete: LoadResourcesAction at: 2008/0/16 12:47:35, returned true
Running: ParseBootstrapOptionsAction at: 2008/0/16 12:47:35
Loaded DLL:97352a1d146f8bca5542016500a05210xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2008/0/16 12:47:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "576"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2008/0/16 12:47:35
Complete: ValidateWinNTAction at: 2008/0/16 12:47:35, returned true
Running: ValidateMinOSAction at: 2008/0/16 12:47:35
Complete: ValidateMinOSAction at: 2008/0/16 12:47:35, returned true
Running: PerformSCCAction at: 2008/0/16 12:47:35
Complete: PerformSCCAction at: 2008/0/16 12:47:35, returned true
Running: ActivateLoggingAction at: 2008/0/16 12:47:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00E2CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "576"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
Since the Microsoft.SqlServer.Express.SQLEditors utilizes a crypto wrapper, givin the error above... would the CAPICOM update have affected things?
Brian Nichols
View 1 Replies
View Related
Jun 28, 2007
I want to execute a vbs file through SQL server agent using following command using operating system command exec .
wscript E:website est.jewelexonline.comReadFile.vbs F:sqlbackDiffljewelexgroupcom,,3
It does not execute and the status remains executing only .
What could be the problem .
View 1 Replies
View Related
Dec 5, 2007
I'm trying to get a SSIS package to run as a SQL Server Agent job. The package uses a config file. When I try to add the config file to the job under the Configurations tab. When I click on the 'Add' button, I get the following error:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The EXECUTE permission was denied on the object 'xp_availablemedia', database 'mssqlsystemresource', schema 'sys'.
The user does not have permission to perform this action.
The statement has been terminated. (Microsoft SQL Server, Error:229)
Any suggestions?
View 2 Replies
View Related
Mar 19, 2008
Hello,
I have created a package that runs without problem.
I run the package with the command dtexec /F "package_name.dtsx" > package_name.txt.
Then I run the same package from SQL Server Agent, everything is OK
Then, I tried to edit the command line to have the output file, but I got an error.
The command line is:
dtexec /F "package_name.dtsx" MAXCONCURRENT "-1" / CHECKPOINTING OFF /REPORTING E > package_name.txt.
(MAXCONCURRENT "-1" / CHECKPOINTING OFF /REPORTING E are created by default)
How can I do?
Thank
View 4 Replies
View Related
May 8, 2006
We are not certain if this has happened due to the SSIS FTP Task, but incidently the Excel file that is being copied from the FTP site using an SSIS FTP Task got corrupted a couple hours after the package was scheduled as a SQL Server Agent Job on SQL Server 2005.
I had a SQL Server 2000 DTS package doing the same thing, but it was never an issue then. I was using the FTP Task there along with an Excel Data source in that and has been working for a couple years atleast with never any corruption related issues.
In the SSIS SQL Server 2005 package I am using an FTP Task with an Excel Connection Manager and Excel source and the Excel file got corrupted within a couple hours of the package being scheduled as a SQL Server Agent job.
Has anyone experienced this issue? Any inputs will be appreciated.
Just as an fyi, the excel file has a lot of vlookups.
Thanks,
MShah
View 1 Replies
View Related
May 29, 2008
I'm setting up a Maintenance Plan to do a backup for me in the night of my SQL Databases but before the backup starts I have created a SQL Server Agent Job that runs a DOS batch (.bat) file using CmdExec. The problem is I need this process to finish processing before the rest of the tasks run in the Maintenance Plan. It seems like SQL Server Agent Job Task tells the batch file to start running (and it runs fine) but it just continues to the next task and does not wait for it to finish.
Is there any way I can configure this to wait before proceeding?
Thanks, Mark
View 7 Replies
View Related
Jun 22, 2007
When adding an SSIS step to a SQL Server Agent job, when selecting the location of a config file, the dialog lets you select from the database server you're working with. If selecting the location of the package itself (when the source is File System), the dialog lets you select from the machine where Management Studio is sitting instead of from the database server. Is that intentional? And if so, why? Should I just use a fully qualified file name for the package location rather than one using a drive letter?
View 3 Replies
View Related
May 15, 2001
Hello,
When i try to stop or Start SQLServer Agent I get the
following error:
" An Error 1060(the specified service does now exist as an installed service)
occured while performing this service operation on the SQLServerAgent service "
I use SQL Server 7.0 on windows 2000.
Does anyone have a solution to this problem.
Thank you,
Ran
View 4 Replies
View Related
Nov 15, 2000
hi, I am doing the following: I am testing the email or the pager for an operator under ms sql server agen. when I click test, it ask me to confirm test pager address I clik oK,then get a message that the mail was sent successfully then I get an error message then sql server enterprise close.
any idea what is going on
Ahmed
View 2 Replies
View Related
Oct 15, 1999
Anyone seen this in 7.0 SQL:
The 'SQLAgentCmdExec' proxy account does not exist or has an incorrect password. I am not running a proxy.
View 1 Replies
View Related
Jun 17, 2004
I am getting the following error when I try to create a maintenance plan on one of my servers:
Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.
Thanks in a dvance for the help.
View 1 Replies
View Related
Nov 12, 2004
Can someone help me troubleshoot this error:
Error 22022: SqlServerAgent error: Undable to get the default MAPI Message store due to MAPI error 273: The information store could bot be opened.
Thanks
Lystra
View 4 Replies
View Related
Oct 2, 2007
Can anyone figure out what is causing the error below. It seems like a permission error certainly. Here is some information, first I am not a DBA so bear with me. I am using the client version of SMO and SS BI. I have a package that will execute in BI manually but will not execute from the scheduled job. I have permission to remote to the server and I have tried to run the job from the server and still get this error. If anyone understands the error; please provide some info.
Executed as user: NT AUTHORITYNETWORK SERVICE. ...Connection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.Odbc.OdbcConnection.Open() at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction) at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction) at Microsoft.SqlServer.D... The package execution fa... The step failed.
View 1 Replies
View Related
Apr 30, 2015
I recently installed standalone version of SQL 2014 Standard on my work computer. I used Access before but I want to use a SQL server instead.
We have a shared drive that a file gets deposited every day at midnight. I want to be able to get this file and import it to the server (its basically a list of names).
Here what I have done so far:
I created the database
Created the file and successfully imported data into it using the Import Data feature.
I saved the SSIS package
Scheduled an Agent Job for this package to run at certain time,daily
At first the jobs would fail with a Access is Denied. I added a user under Credentials with my network account ( have admin rights on the work computer).Also added a Proxy for the Credential user I made.
Jobs fail with a “Cannot open data file” error. I tried changing things here and there, but I can’t get it to work.
View 9 Replies
View Related
Oct 15, 2007
Hi,
I want to generate a new snapshot using stored procedures. I want to wait for the snapshot files to be created and then execute a stored procedure. What's the best way to determine that the snapshot has completed successfully? I thought of doing something like:
exec msdb.dbo.sp_help_job
@job_name = @job_name
@job_aspect = 'job',
@execution_status = 1
however I can't put the results of that proc into a temp table because I get this error:
Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 72
An INSERT EXEC statement cannot be nested.
Any ideas? I'd like a T-SQL solution.
Thanks,
Mark.
View 3 Replies
View Related
Aug 10, 2015
Is there a way to find out who enabled or disabled a SQL server agent job?
View 3 Replies
View Related
Jun 6, 2001
I get the following error in the SQL Agent log file
Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: Logon failure: the user has not been granted the requested logon type at this computer)
Does anhbody know why this happens.
Let me know.
Thanks
Cynthia
View 6 Replies
View Related
Jun 15, 2001
Hi,
I have question. My SQL Server Agent Log has the following error messages logged. Does anyone know why this happens. It happens everyday when I back up a 40 GB Database. Let me know. I Appreciate the help.
Thanks,
Cynthia
6/14/01 9:30:58 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:30:59 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:01 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:30:58 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:30:59 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:00 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:01 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:02 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:03 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
View 1 Replies
View Related
Jul 20, 2000
There is a stored procedure (sp_cycle_errorlog) which can be
executed to cause the SQL Server error log to cycle.
Is there anything similiar for the SQL Server Agent Error log?
View 1 Replies
View Related
Mar 18, 2007
I have been having a problem with an attempted install of sp2 (the updated one) and don't have a clue on how to get past it. Here is the error that I get
MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]SQL Server blocked access to procedure 'dbo.sp_is_sqlagent_starting' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server.
What is strange is that I have ensured that the Agent XP's are enabled prior to the sp install by checking the agent xp's configuration option but it seems as though during the sp install it disables them and encounters problems when trying to start the SQL Agent resulting in a failure of the sp install with the message shown above.
When I check the database after the failure, it does show the AgentXP's as being disabled. I've re-enabled them multiple times with the same result.
The sp is being installed on a 2 node cluster but only one node is having the problem, the other upgraded fine. I have also had this problem on a single non-clustered server with 3 instances where two of them installed fine but one didn't, it too had the same error message.
My basic configuration is as follows:
x64 Windows 2003 Standard Edition R2
SQL Server 2005 Standard Edition (for the clustered server) Dev Edition for the standalone server
Any thoughts on how to get past this problem or is this a bug?
View 1 Replies
View Related
Jan 30, 2007
While I was out of the office the Lan Team moved one of my SQL Server2000 servers to a new network domain. Since then the maintenance jobhas not ran.The error log for the SQL Agents has the message listed in the subjectline. I have not found any useful articles on the MS SQL Serversite. Anyone know what might be wrong and how to fix it.HTH -- Mark D Powell --
View 4 Replies
View Related
