SQL 2005 Agent Configuration Problems
Apr 26, 2006
Hello,
I've got two problems when attempting to set up SQL Server 2005 Agent. Any help on either of these would be greatly appreciated.
1.) When I go into properties of SQL Server Agent and then to history. I check the Automatically remove agent history checkbox and set the time delay, but it doesn't stay checked when I exit and look again. Does anyone know how to fix this or even better the specific registry key I can change to force it? I believe it is in HKLMSoftwareMicrosoftMicrosoft SQL Server(Instance)SQLServerAgent
2.) On SQL Server Agent properties in General I have changed the location of the log file so instead of D:Program FilesMicrosoft SQL ServerMSSQLLOGSQLAGENT.OUT it is E:SQLLogsSQLAGENT.OUT However when I go through Management Studio to view them it says "Unicode File Expected", even though SQL Server is creating the files and automatically rolling them over (I do have Write OEM error log and include execution trace messages checked and am logging Errors, Warnings and Information).
Any help would be greatly appreciated.
Thanks,
Aaron Lowe
View 4 Replies
ADVERTISEMENT
Sep 22, 2007
I am getting following error when trying to install SQL express 2005 on XPSP2.
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SIGMA-805539A79 Error:2147944122 (0x800706ba).
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342
I tied re-installing WMI using http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx link but could not get it working.
Do i need IIS installed? Its not installed on this box...
please suggest something... i am stuck...
Thanks,
View 3 Replies
View Related
Nov 15, 2006
I am deploying a new website (hosted at Godaddy.com) and want to take advantage of some of the power VWD 5005 offers. Specificaly the 'ASP.NET Configuration' under the 'Website' menu item. How do I go about using the ASP.NET Configuration on a site that is hosted? Is it possible? I want to be able to add new rolls, create some users manually and set permissions on directories. If I cant use ASP.NET Configuration how do i go about this task in a hosted environment. My host is GoDaddy.com
Thank you,
View 1 Replies
View Related
Oct 5, 2007
I'm a Network Administrator that has to do everything from desktop to server, to routing, and DBA so I need a bit of advice. Stretched thin for time and knowledge in the SQL area and trying to do the best I can.
I currently have a MS SQL 2000 database that is 60GB in size for MS Dynamics 8.0 and one that is 2GB that I want to move to a new server.
I've setup and tested it and it all works, now I'm looking for some Best Practices information for best performance. Currently doing about 3,000 transactions a day.
Server is HP ML350-G5 2 Xeon Dual Core 2.0GHz CPUs w/16GB RAM w/external drive bays running 72GB 15K SAS drives with SMART ARRAY P800.
OS is Windows Server 2003 Enterprise w/SP2 - MS SQL 2005 Standard
I have the following drive configurations setup.
C:(RAID1+0)OS - SQL 2005
D:(RAID1+0)Dynamics Application Shared dictionary files for clients
G:(RAID0)BACKUPS (see note below about TEMPDB) I also have a 25GB swap file on this drive maybe better to put in on the D: volume if I put TEMPDB here
H:(RAID1+0)LOGS (2 user db logs and the tempdb log)
I:(RAID1+0)DATA (2 user db - [model, msdb, master]
Recently found that my G: drive (RAID0) only has space for 2 backups (poor space planning on my part) before I need to move the files. Normally I backup the DB with BackupExec 10.1d just fine in about 2 hours over the wire at night since no one is in the DB at night.
Was wondering if putting my TEMPDB there on (RAID0) would be advisable or not. In SQL 2005 it gets rebuilt each time SQL is restarted so it would seem that ensuring it's on a RAID1 or RAID1+0 might not be as necessary as say the DATA files.
Then if I really wanted to I could actually do backups on the I:DATA drive at night and then use TAPE to back that up, and use an automated script to move them off to offline storage once the TAPE backup is done.
For the [model, msdb, master] should they need to be on the I:DATA drive or just leave them on C:OS ? Not sure how much they're actually used.
Also doing some brief testing the Microsoft Dynamics was much slower on the new Server than it was on the original. Odd to me since the new Server is like a McLaren F1 racing a Ford Pinto. The old server is running a single P4 CPU and 6GB RAM
I've set MS SQL 2005 to use 12GB of RAM on the new server so as to leave 4GB for other Server tasks.
I ran the Maintenance Wizard and had it do checks and defrag and index rebuild etc... so not really sure why the speed would be noticeably slower. One thing I did notice is that once a screen query was ran then the next time it was a bit faster but overall I was expecting to see the screens fly by on this new hardware and SQL 2005 but it doesn't really do that.
I've read some of the white papers etc for tuning, but wow I just don't have unlimited hours to do all this analysis, there seem to be hundreds of pages to read on that type of stuff.
Thanks in advance for the advice.
View 20 Replies
View Related
May 31, 2007
I am working on creating a configeration database based on the information pulled from a large number (over 40) of servers. I am newly out of college and don't have a lot of experience with things like this, but I am trying to create a configuration database. I need to know the best way to create a connection to all of the SQL servers on my network and then automate the pulling of data from these SQL servers. The types of data I would need are things like Instance ID, DBMS Version, Database Properties, Database Name, Modification Date, Last full backup, last transaction log backup, etc. I have been pointed towards either working with OSQL/SQL CMD, in which case could someone please point me towards a guide, and SSIS, I am reposting this thread in the SSIS area. I need to take all of the gathered data and place it into a central repository database after formatting it. Any help is greatly appreciated.
-Kyle Schlapkohl
View 3 Replies
View Related
Nov 22, 2007
Hi,
I have a requirement sql server 2005 in which i need to send a mail when ever there is an error in the procedure or job.
The mail should fire with the error attached to it.
could you please suggest the ways to handle this.
Please tell me the list of steps to configure and send the mail.
Thanks in advance.
View 1 Replies
View Related
Feb 27, 2006
Hi,
A couple of small questions for anyone who can help. I am writing an application and am a newbie with SQL Server 2005 Express Edition and Visual C# (using Visual Studio 2005 pro).
My application will need to run on 6 different PC's at one time with our office server hosting the database. Since the server is hosting the database, is it necessary for the individual PC's to have SQL Server 2005 Express Edition installed on their hard drives also to communiucate back to the server?
Also, where can I find some nice example code for connecting and performing some simple tasks under C#?
View 1 Replies
View Related
Jun 28, 2006
I'm getting an error when the SQL install program checks the system - "The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine DI-ERP2 Error:2148007941 (0x80080005).
I've tried a bunch of stuff as suggested by some of the other threads, but nothing is working so far...
Any ideas would be greatly appreciated.
View 7 Replies
View Related
Mar 28, 2007
I have got a backup maintenance plan, and I want to output to a file if it has been a success or fail. I was using sp_help_jobhistory and relying on the run_status to determine if it succeeded(1) or failed(0). I have found this to be unreliable compared with the report which is in the SQL Agent Log File Viewer.
I assume this has to be stored some where, how do I access the table where this is stored? So i can return the results of my maintenance plan from SQL Agent.
Any help would be great.
Cheers
View 4 Replies
View Related
Apr 27, 2006
How do I install the SQL client on another machine? I've done this in previous versions but things have changed a bit. I'm using the developer edition.
View 1 Replies
View Related
Sep 25, 2006
Hello,I am trying to connect to a DB, which is hosted on an SQL Server 2005 by a provider, using ASP.NET Configuration Tool. The result is the following error when I click on the Security Tab:---There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---The hosting provider checked that my connection string is correct. They do not know why I get the error, though. Here is a relevant snippet from my web.config:<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer"connectionString="Data Source=ABC;Integrated Security=false;Initial Catalog=ABC;User ID=ABC;Password=ABC"providerName="System.Data.SqlClient" /></connectionStrings>ABC is a mock :)Could anyone pls help? It is much appreciated.
View 4 Replies
View Related
Mar 15, 2007
Hi!I have installed Sql Server 2005 Express on my machine. I want to access this server from another machine in LAN.Also installed Sql Server 2005 on another machine. Allow Remote Connections is selected with Sql Server Surface Area Configuration.Please suggest the correct solution. (in detail) Thanks in advancemilind
View 2 Replies
View Related
Mar 20, 2007
Does anyone have a good starter's tutorial on authorization advice & configuration for SQL Server 2005?I need to know what is adviced what web users can specifically do and dont in my db, and how to configure that...Thanks!
View 1 Replies
View Related
Jun 20, 2007
Hi,
I've encountered this error when opening up http://localhost/ReportServer/
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerRSReportServer.config' is denied.
Here is the log info:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Daylight Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFilesReportServerService__06_20_2007_10_08_12.log</Path>
<SystemName>CSD060266</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!9!6/20/2007-10:08:13:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!9!6/20/2007-10:08:13:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!9!6/20/2007-10:08:13:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 57106 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!9!6/20/2007-10:08:13:: i INFO: SQM timer timer enabled: Next Event: 60706 seconds. Cycle: 86400 seconds
ReportingServicesService!library!e!6/20/2007-10:08:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
ReportingServicesService!library!e!6/20/2007-10:08:44:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
ReportingServicesService!library!e!6/20/2007-10:08:44:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!e!6/20/2007-10:08:44:: Attempting to start service again...
I've been doing all I could think of: reinstall the whole SQL server and its services; stop and restart SQL server service and Reporting service.
It could be my SQL version has a problem...not sure....
I could not think of anything else.
If you have any thoughts about it, please do reply.
Any suggestion is highly appreciated. Thank you...
View 3 Replies
View Related
Mar 9, 2007
I have SQL 2005, and Reporting Service has been uninstalled and reinstalled,
go through each step of confiugration until Encryption Key, for some reason,
the backup button is grayed out, only "restore" button is clickable, as well
as Delete, but we never backup the key before, so this is really strange
since we do not have backupkey, so we cannot restore.
we tried "Delete", then we got the following error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted
value for the "LogonCred" configuration setting cannot be decrypted.
(rsFailedToDecryptConfigInformation)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()
Browse report manager and reportserver also got the same error, run
rskeymgmt -d, does not help either
Any suggestion?
Thanks
Don
View 10 Replies
View Related
May 3, 2007
Hi All -
I am trying to configure reporting services on virtual machine but unable to succeed. I never touched this topic before SQL Server 2005. The left hand side options in Reporting Services Configuration Manager such as Server Status, Virtual Directories, Web Identity works fine but it fails in Database Setup section
Here are the details:
AppServer: SQL Server 2005 Reporting Services & Client components build# 2153 (with SP1 & SP1 hotfix)
going to apply SP2 and Add-on component after the configuration
DBServer: SQL Server 2005 Database Services & Client components build# 2153 (with SP1 & SP1 hotfix)
OS: Windows 2003 Server with SP1
IIS version on AppServer: 6
I have SQL 2005 Reporting services and 2005 Database Engine on 2 different machines.
Here is the error message I am receiving when I try to apply the script in "Database Setup" section of Reporting Services Configuration Manager
It did not log any errors in SQL Server however it shows a warning message in Event Log
Event Log message - "The RSReportServer.config file has been modified."
Configuration Manager error message - It shows me "Create a Grants Rights Script" task failed
"System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)"
I have captured the screenshot, let me know if I can send this.
One of my friends suggested the following and I have tried the first option but could not work - Option I)
Our account that is used for database connection should have
1) public and RSExecRole roles for the ReportServerDatabase.
2) RSExecRole roles for the master, msdb , and ReportServerTempDB databases.
Else - Option II)
we can run the Reporting Service Windows Service under the local System Account and then the credentials type for the database set up would be Service credentials. This way we would have more permission.
Did anyone face this problem? how should I resolve this?
Anyone have steps to follow as I feel of missing something in the configuration steps?
Any information/ suggestions/ pointer on this are higly appreciated.
Thanks in advance !!
-Satya
View 2 Replies
View Related
Aug 12, 2007
Hi,
I've installed SQL 2005 on a Windows 2003 R2 Server, I also installed another Web Server (Another Windows 2003 R2 Server) on a different machine.
I've installed the Reporting Services on the Web Server.
When I am trying to configure the report server, I successfully created the Virtual Directories, but when trying to do the "Database Setup" step, I am getting an error on the "Create a Grants Rights Script", with this message:
System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer)
at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)
As a result, I cannot run the reports nor get to the folder.aspx page on the manager side of the application.
I am getting this HTML msg:
The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Get Online Help
When installing the Reporing Server on the SQL Server machine, it works with no problems, and I am doing everything the same.
Would appreciate your help, I've been working on this for few days with no luck.
Thank you!
Yaniv.
View 4 Replies
View Related
Nov 9, 2006
Sorry for the annoying. I would like to the configuration settings for the surface area. There's an option which able to let us change computer (whether is local computer or remote computer). Let say I put my own computer's name (Hans as example) for configuration as the remote compute, it's work fine to me. However, if I put my remote computer's name, it displays this error message to me.
Error :
Computer Tomato does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
I am sure that the remote computer is working since I am able to ping the remote computer and test on telnet as well. But why it seems that surface area can't detect my remote computer. Hope can get some resistance from everyone here. Thanx alot.
Best Regards,
Hans
View 1 Replies
View Related
May 17, 2006
Hello everybody,
Can someone tell me if there are any limitation in SQL Server Agent of SQL Server 2005?
I have a Windows 2003 Enterprise R2 with 16GB RAM and SQL Server 2005. However my SQL Agent log say:
"Message
[310] 4 processor(s) and 4096 MB RAM detected"
Any KB related?
thanks a lot
View 1 Replies
View Related
Jun 18, 2007
Hi,
I m using SQL Server Job Agent to execute my SQL Server Integration Package. When I execute this job, the status of the job is shown as 'Between tries' and the job get hanged. I searched through the msdn. The solution provided is specific to SQL Server 2000. I am not able to get the solution for SQL Server 2005. Could someone please tell me the reason behind this problem?
Regards
AKRAO
View 3 Replies
View Related
Sep 29, 2006
Hi,
I created an RMO script to generate a republishing replication (A to B then B to C). Because I don't want to start the B to C replication until the A to B replication is complete, I start the Snapshot and the Merge processes synchronously (vs. asynchronously). If I ran them asynchronously, I'd need to put in logic to loop-check the completion status of the Merge agent job before kicking off the B to C process.
In the Snapshot agent, this means running .GenerateSnapshot(); (vs. StartSnapshotGenerationAgentJob)
and in Merge agent this means running .SynchronizationAgent.Synchronize(); (vs. SynchronizeWithJob)
I notice that the Snapshot agent never shows a LastRun or LastRun Outcome even though the snapshots are being generated. I haven't tested the other scenario (asynchronous), but I presume they would register the LastRun columns because, as I read it, they use the SQL Agent jobs to accomplish their work.
Does anyone have RMO code that I could add to plug this information into whatever system table (?) somehow?
I'll put this in the SMO/RMO forum too.
Paul
View 3 Replies
View Related
Jan 30, 2007
Hi.I have an ancient preCambrian app that uses the db library to interface withsql server databases.It is written in c++.When testing it I noticed on one machine with sql server 2005 installed itruns fine, but on another it has some problems, notably.. it gets as a resultof a select statement with an order by clause the error:only fully keyset ddriven cursors can have 'order by', 'group by', or 'having'phrases.Error code 10080Can someone suggest a 'configuration' parameter that might be causing theotherwise identical systems to have this problem on one machine and not theother?ThanksJeffthanksJeffJeff Kish
View 1 Replies
View Related
Mar 14, 2007
I plan to migrate a SQL 2000 instance with everything in it to another SQL2000 server, and eventually in the future to SQL 2005.
I've pretty much figured out how to migrate everything execept the linked server configuration (there're many linked servers configured in the old server with different security credentials). I'm wondering if there's way I can save the linked server configuration and restore it to the other server.
Thanks much.
Ed
View 4 Replies
View Related
May 17, 2006
Hi,
I'm the following encountering WMI error message when invoking SQL2005 setup.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine CAPRICORN Error:2147942405 (0x80070005).
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=70342
I'ver found other postings related to WMI errors and tried the WMI fix batch, but to no avail. I noted the error code I have is 2147942405 which is different from other postings. And from examining setup log generated, this seems to be security related, but cannot find much help combing thru msdn/google, etc
Any help is greatly appreciated.
-James Lin
SCC LOG
================================================================
SCCOpenPerformer Added machine: CAPRICORN
RegisterAddCheckArticleCallbackFunction registered callback function
Calling add article callback function for article: WMIServiceWin32OSWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32OSWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 2
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_OperatingSystem
Property name: OSLanguage
Property type: 2
Value: 2
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_OperatingSystem
Property name: SystemDirectory
Property type: 2
Calling add article callback function for article: WMIServiceWin32CompSystemWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32CompSystemWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_ComputerSystem
Property name: NumberOfProcessors
Property type: 2
Calling add article callback function for article: WMIServiceWin32ProcessorWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32ProcessorWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_Processor
Property name: CpuStatus
Property type: 2
Calling add article callback function for article: WMIServiceReadRegWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceReadRegWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_REGISTRY
DefKey: 0x80000002
Subkey name: SOFTWAREMicrosoftWindowsCurrentVersion
Value name: ProgramFilesDir
Registry type: 4
Calling add article callback function for article: WMIServiceWin32DirectoryWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32DirectoryWorking
Article type: 3, ARTICLE_WMI_TYPE_CLASS
Namespace: cimv2
WQL Query: Select * from Win32_Directory where name='C:\'
Calling add article callback function for article: WMIServiceCIMDataWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceCIMDataWorking
Article type: 3, ARTICLE_WMI_TYPE_CLASS
Namespace: cimv2
WQL Query: Select * from CIM_DataFile where name='C:\'
Calling add article callback function for article: XMLDomDocument
Callback function returned TRUE
Adding Article...
Article Id: XMLDomDocument
Article type: 1, ARTICLE_TYPE_GENERIC_FUNCTION
RegisterCallbackFunction registered callback function
Callback filter = 0x6
Performing check on local machine CAPRICORN
Connecting to CAPRICORN machine
ConnectServer returned 0 (0x0)
ConnectServer returned 0 (0x0)
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Creating class instance Win32_ComputerSystem
CreateInstanceEnum Win32_ComputerSystem returned 0 (0x0)
Enumerating the first class of Win32_ComputerSystem
EnumClass of Win32_ComputerSystem returned 2147942405 (0x80070005)
Creating class instance Win32_OperatingSystem
CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0)
Enumerating the first class of Win32_OperatingSystem
EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005)
Creating class instance Win32_OperatingSystem
CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0)
Enumerating the first class of Win32_OperatingSystem
EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005)
Creating class instance Win32_Processor
CreateInstanceEnum Win32_Processor returned 0 (0x0)
Enumerating the first class of Win32_Processor
EnumClass of Win32_Processor returned 2147942405 (0x80070005)
Openning namespace \rootdefault
GetNamespace \rootdefault returned 0 (0x0)
Getting method EnumValues in StdRegProv class
GetMethod returned 0 (0x0)
Executing method EnumValues in StdRegProv class
ExecMethod returned 2147942405 (0x80070005)
Processing article WMIServiceWin32OSWorking
Scc Error: 50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article WMIServiceWin32CompSystemWorking
Scc Error: 50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article WMIServiceWin32ProcessorWorking
Scc Error: 50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article WMIServiceReadRegWorking
Scc Error: 50024 (0xc368)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article WMIServiceWin32DirectoryWorking
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Scc Error: 50022 (0xc366)
Error code: 70347 (0x112cb)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article WMIServiceCIMDataWorking
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Scc Error: 50022 (0xc366)
Error code: 70347 (0x112cb)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article XMLDomDocument
Scc Error: 0 (0x0)
Error code: 0 (0x0)
Calling callback function for reason: 0x4
Callback function returned TRUE
SccPerformer closed.
View 9 Replies
View Related
Apr 17, 2007
I'm trying to install SQL 2005 64bit on a Win2003 R2 SP1 cluster.
The setup faild during the System Configuration Check on one node only with this message box:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.
------------------------------
BUTTONS:
OK
------------------------------
The SQLSetup000x_<servername>_Core.log:
Microsoft SQL Server 2005 Setup beginning at Tue Apr 17 08:21:27 2007
Process ID : 3436
C: empsql2k5_EE_64bitdisc1setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/3/17 8:21:27
Complete: LoadResourcesAction at: 2007/3/17 8:21:27, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/17 8:21:27
Loaded DLL:C: empsql2k5_EE_64bitdisc1xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/3/17 8:21:27, returned true
Running: ValidateWinNTAction at: 2007/3/17 8:21:27
Complete: ValidateWinNTAction at: 2007/3/17 8:21:27, returned true
Running: ValidateMinOSAction at: 2007/3/17 8:21:27
Complete: ValidateMinOSAction at: 2007/3/17 8:21:27, returned true
Running: PerformSCCAction at: 2007/3/17 8:21:27
Complete: PerformSCCAction at: 2007/3/17 8:21:27, returned true
Running: ActivateLoggingAction at: 2007/3/17 8:21:27
Complete: ActivateLoggingAction at: 2007/3/17 8:21:27, returned true
Running: DetectPatchedBootstrapAction at: 2007/3/17 8:21:27
Complete: DetectPatchedBootstrapAction at: 2007/3/17 8:21:27, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__3436" returned false.
Running: PerformSCCAction2 at: 2007/3/17 8:21:27
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2007/3/17 8:21:27, returned true
Running: PerformDotNetCheck at: 2007/3/17 8:21:27
Complete: PerformDotNetCheck at: 2007/3/17 8:21:27, returned true
Running: ComponentUpdateAction at: 2007/3/17 8:21:27
Complete: ComponentUpdateAction at: 2007/3/17 8:21:52, returned true
Running: DetectLocalBootstrapAction at: 2007/3/17 8:21:52
Complete: DetectLocalBootstrapAction at: 2007/3/17 8:21:52, returned true
Running: LaunchLocalBootstrapAction at: 2007/3/17 8:21:52
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 2147614728
Aborting queue processing as nested installer has completed
Message pump returning: 2147614728
Have anyone an idee?
Thanks
Laurent
View 1 Replies
View Related
Oct 17, 2007
Hi all,
I have an issue with an SQL cluster.
I have two MS Windows 2003 Server Ent Ed. SP2 in cluster. They have MS SQL Server 2005 in cluster.
I have created and endpoint and when I try to access I get the attached error in client machine. This problem only occurs in cluster configuration, because the same installation in an SQL (no cluster) works fine.
EventID: 4 Source: Kerberos
The kerberos client received a KRB_AP_ERR_MODIFIED error from the server host/fra-lille-hel03.ea.holcim.net. This indicates that the password used to encrypt the kerberos service ticket is different than that on the target server. Commonly, this is due to identically named machine accounts in the target realm (EA.HOLCIM.NET), and the client realm. Please contact your system administrator.
Anybody knows how to solve it?
Thanks in advanced.
View 1 Replies
View Related
Jan 7, 2008
I am new to SQL server 2005 and have a config question:
I am controlling database connection info using XML indirect config - no problems there.
Essentially I am going to have a number of packages that need to use a common file path, that might change from one server to the next, e.g. Server 1: C:sourceFiles versus Server 2: D:sourceFiles. Within this directory the filenames will remain static. So in the flat file connection manager I'd like to use a variable to reflect the folder - but I don't want to have to create this for each package.
So, I thought I would create a system environment variable and create expressions for the connection managers - something like %SOURCE_DIR% + "file.csv" - but this does not evaluate correctly.
So then i though I could use the SQL server configurations table with a configurationFilter SOURCE_DIR and appropriate configuration value - but then how do I access this in the flat file connection manager to create a dynamic file name?
So essentially I want a variable/property available globally to all my packages and potential flat file connection managers that help me to centrally control file path locations.
Any help would be most appreciated.
View 3 Replies
View Related
May 2, 2007
I have just finished installing SQL 2005 Ent Edition on Win 2000 Adv Server, SQL2005 SP2, and SP2 Hotfix KB934458. After the installation, I could see and configure all services via SQL Configuration Manager and SQL Server Surface Area Configuration tools. This worked for a couple of days and now both configuration tools no longer detect SQL2005 components. SQL Server Surface Area Configuration issued an error that said "No SQL Server 2005 components were found on specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLAC)". SQL Configuration Manager did not list any installed services. I don€™t know what caused this. Anyone has any idea? Please help! Below is the Installation Report which shows installed components.
===================================
The following components are installed on this server
DEV
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Reporting Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
QA
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Common components
Integration Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Notification Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Workstation Components
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
===================================
View 1 Replies
View Related
May 23, 2006
Hi --I was wondering if this is a bug when I add new data in my table SSIS Confiurations and give wizard a new Configuration filter the package configuration wizard can not see the new values --the old values from the previous configuration are still showing---is there any known workaround or forced refresh I can do
thanks in advance Dave
Background:
SQL Package Configurations are most important because they provide the possibility of a central configuration store for your entire enterprise!!!!!!!! and is in my mind the only way to go
http://sqljunkies.com/WebLog/knight_reign/archive/2005/01/24/6843.aspx
Wizard results:
Name:
ETL
Type:
SQL Server
Connection name:
ETLConfiguration
Any existing configuration information for selected configuration filter will be overwritten with new configuration settings.
Configuration table name:
[dbo].[SSIS Configurations]
Configuration filter:
PT_CUST_ABR
Target Property:
Package.Variables[User::gsPreLoad].Properties[Value]
Package.Variables[User::gsPostLoad].Properties[Value]
Package.Variables[User::gsLoad].Properties[Value]
Package.Variables[User::gsFlatFilename].Properties[Value]
Package.Variables[User::gsFileName].Properties[Value]
Package.Variables[User::gsCDOMailTo].Properties[Value]
Package.Variables[User::gsCDOMailSubject].Properties[Value]
Package.Variables[User::giRecordCount].Properties[Value]
Package.Variables[User::giFileSize].Properties[Value]
Package.Variables[User::giBatchID].Properties[Value]
Package.Variables[User::gdFileDateCreated].Properties[Value]
Package.Connections[MyDatabase].Properties[ServerName]
Package.Connections[MyDatabase].Properties[InitialCatalog]
USE [ETLConfiguration]
GO
/****** Object: Table [dbo].[SSIS Configurations] Script Date: 05/23/2006 13:34:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SSIS Configurations](
[ConfigurationFilter] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValue] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
[PackagePath] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValueType] [nvarchar](20) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
View 3 Replies
View Related
Jul 20, 2006
Does SQL Server 2005 Express have a SQL Agent? If so, can someone tell me where I would find it? If not, can someone tell me if there is a replacement for it or some kind of work around?
Thanks,
John
View 2 Replies
View Related
Jan 5, 2006
Hi - I know SQL Server 2005 Express comes with no agent, so how do people using it, currently backup their databases?
eg. I currently use MSDE in a live environment (small user base), and I use the Agent/Jobs to create a backup each night.
How could I achieve the same with the SQL Server 2005 Express?
Thanks for any help,
Mark
View 11 Replies
View Related
Apr 9, 2007
I have a job scheduled to run daily every hour. If I log on to the server the jobs runs sucessfully but if I log off the job fails. I have scheduled a SSIS package to run as a job.. pLease help...
I am using SQL Server 2005. and a proxy account to run the job. I treid to run the job as One Time only and it runs sucessfuly.
View 1 Replies
View Related
May 4, 2007
I am running windows 2003 and sql server 2005. i am following the directions in books online:
On the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
In SQL Server Configuration Manager, expand Services, and then click SQL Agent.
In the results pane, right-click any instance, and then click Start.
A green arrow on the icon next to the SQL Server Agent and on the toolbar indicates that SQL Server Agent started successfully.
Click OK.
the problem is i have nothing in Services. there is nothing to expand.
is it installed wrong?? or is there another step before this that i have to do??
View 1 Replies
View Related
