Hi all, This is my first message in this forum and I am a new bie to SQL server 2005.. I am trying to schedule the backup job for a database in 2005 and I am not able to figure out where it is. I browsed through few topics in the forums and found that I can do using sql server agent in the SQL server management studio. But I do not see the sql server agent in the management studio. Any help is appreciated.
Thanks all!
My backup jobs have been failing and when I go in to services there is no SQLSERVERAGENT listed.
Anyone have any ideas on this one?
Hi,
I'm learning SQL 2005 and installed the express ADV edition to my pc. But I miss the Agent service.
Is this included in express? Has it another name after SQL server 2000?
thanks
majid
I can't believe this. MSDE was a great product and I'm sure that SQL Express is even better. The difference is that I can't migrate any of my company's applications to it because they rely on a Replication architecture (requiring Replication Publication). And SQL Agent, how are you supposed to keep the database in good shape if you can't run Maintenance Plans at scheduled intervals?
I know, there are third party products out there to compensate for the lack of the SQL Agent, but they don't solve the replication problem. Besides, the Agent still exists in other editions - it's not like it has been dropped completely. Why do we have to lose functionality and features? We have already lost the use of a second CPU and memory > 1GB. Why do they need to keep taking stuff out? Why don't they just limit access to the new feature-set?
I would rather lose the new features such as Report Server and Full Text Indexing and get the SQL Agent and Replication Publication back. I can almost understand that with a free product, they don't want to keep piliing new features in just to give them away - even though I'm sure the sale of the larger editions more than covers the R&D investment in their construction. Why can't we chose? Agent or Report Server, Replication or Full Text Indexing? I don't need some of these new features (others might), I just want the features that I used to have. Perhaps SQL 2005 setup can be made to choose 2 out of the 4 features?
Whats more, I can't even say that I'll just stick with MSDE, as it now has a limited support life. Microsoft announced that any SQL Server version prior to 2005 SP1 will NOT be supported on Vista or Longhorn Server (nor does it support anything less than Windows 2000 SP4 or Windows XP SP2 where MSDE does).
OK - let me get this right. We had something that has been taken away in the new version. Perhaps I don't deserve the new version if I don't pay for it - fine - I'll stick to the old one I already have. BUT wait... I can't use that on the new platforms coming out.
Are my entry-level customers going to pay for the Workgroup Edition (add AUD$1200 to my entry level edition application of AUD$1500) to replace the Replication Publisher and provide a Maintenance plan? Is anyone going to pay for the re-architecting and re-construction of my application to work around these new limitations?
I guess that will be me. Is this what happens for being loyal to MS products?
Please - give back the SQL Agent and Replication publication.
Joe
My Snapshot Agent for SQL Server 2005 sometimes does not fully complete. I am expecting around 2073 files in the snapshot folder but only get 492 (this number does change). I have immediate_sync set to true, so I should get a full snapshot every time. It seems to quit after all data has been BCP'ed out and before the schema generation starts. I do get the "The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active. " message in the MSSnapshot_history table.
I am guessing that there is some sort of blocking that is preventing the snapshot agent from continuing and then it times out and dies. But that is a total guess as I have not been able to observe the behavior, only the outcome.
Any suggestions to what the cause is or how I can fix it?
Thanks, Amy
Recently the Agent on our production server has exhibited a condition where the agent history is missing on around 80% of our jobs. The jobs still run but no history, we have cycled the services, rebooted etc but nothing rememdies the issue.
Has anyone else ever ecountered this with SS and if so do you have a solution?
The program shortcut "Visual Studio 2005 Command Prompt" seems to be mising from the "Visual Studio 2005 Command Prompt" Start menu added by the current Microsoft SQL Server 2005 Express Edition Toolkit. Where is it? How to workaround?
I am trying to do Download details SQL Server 2005 Samples and Sample Databases (April 2006) -> GettingStartedWithSQLSamples.htm which says "a. Open a Microsoft Visual Studio 2005 command prompt. Click Start, point to All Programs, point to Microsoft Visual Studio 2005, point to Visual Studio Tools, and then click Visual Studio 2005 Command Prompt." but I can find no such command prompt within "Visual Studio Tools", only "Visual Studio 2005 Remote Debugger{, Configuration Wizard}".
What's wrong? How to fix or workaround? I'd install .NET SDK 2.0 to get it's Command Prompt but that's about 570MB merely for a command prompt!
Thanks for your help, -Mike Parker
Hi All,
I have a requirement of logging the failure and the error of a job executing a SSIS package to text file.
However, when I go to job step -> Advanced, in the section "SQL Server
Integration Services Package" where that info to setup logging is, it
is blank and just says:
"There are no options for this command type"
Any ideas?
I thought that this might not be supported in Standard Edition as I am running standard edition. Then I checked on two other servers, where I have Enterprise edition with SP2. On one of the installations, I am able to give the log file, the other one still shows,
"There are no options for this command type"
What is the problem? Both of them I am using the sysadmin role account. I have proxy account created on both the SQL instances. I don't think this is the problem, but still I checked this.
Can anybody help me?
Regards,
Virendra
I've got SQL Server 2005 Ent Ed 9.0.1399 and want to change mysecondary Log Shipping server into a primary. I've tried locating thesp_change_secondary_role, but can't seem to find it. Has it beenreplaced with another stored procedure? If so, which are the proceduresto run?On SQL Server 2000, the following were the steps listed:1. Transfer logins2. Run sp_change_primary_role3. Run sp_change_secondary_role4. Run sp_change_monitor_role (this exists in SQL Server 2005)5. Run sp_resolve_logins3 & 5 are what I'd expect to perform if the primary isn't available.N.I.T.I.N.
View 1 Replies View RelatedWhen I install SQL server 2005 and select the option to have Integration Services installed, I cannot see the templates in VS 2005. Is there a way to tell if they have been installed on the harddrive? Is there any way to install them manually?
Thanks,
Carey
Hi there U all,
for the third time I am installing SQL-Server 2005 express and i have an error.
Cannot install sql because .NET 2.0 framework is missing allthough I have the .NET 2.0 framework allready installed and even re-installed it too. When trying again I get the message that there isn't an SSL-certificate present.
My question is, would this probably cause the error when installing?
Anyone?
Grtz and thx,
Recloose(Thomas)
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
I've just installed SQL Server 2005 Development Edition x64 on Windows XP x64bit. The actual server (as well as Integration, Reporting Services etc) installs fine, I can connect to it via Visual Studio 2005 fine. However, all of the software tools are missing including Management Studio, Business Intelligence Studio etc. They don't show up in the start menu at all and I can't find them in the Program Files directory.
Anyone know how I can get them back? I've tried reinstalling SQL Server 2005, reformatting Windows XP x64, I'm at my wits end!! Many thanks!
I've seen a few threads on this which seem to suppose the problem is on Express edition rather than Standard edition. Not so here.
This is definitely Standard edition, SP3 as seen by running
SELECT CONVERT(char(20), SERVERPROPERTY('Edition'))
SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel'))
In SSMS
Under the Management folder there is no "Maintenance Plans" folder.
There IS a "Maintenance Plans" folder under the Legacy Folder.
I have another instance which is Standard and SP1 which looks just fine.
Hi,
I have a query that uses the following fields from MSmerge_history:
MSmerge_history.start_time, MSmerge_history.runstatus and MSmerge_history.duration
Below is the query that I am using:
SELECT
MSmerge_agents.subscriber_name AS SubscriberName,
MSmerge_history.start_time AS SyncTime,
MSmerge_history.runstatus AS SyncStatusID,
MSmerge_history.comments AS Comments,
MSmerge_history.duration AS Duration
FROM distribution.dbo.MSmerge_agents MSmerge_agents INNER JOIN distribution.dbo.MSmerge_history MSmerge_history
ON MSmerge_agents.id = MSmerge_history.agent_id
WHERE MSmerge_history.runstatus IN (2, 6) AND publisher_db = DB_NAME()
AND MSmerge_agents.subscriber_name + CONVERT(nvarchar, MSmerge_history.start_time) NOT IN
(SELECT SubscriberName + CONVERT(nvarchar, SyncTime) FROM SyncActivities)
My query runs fine under SQL Server 2000 but when I run it in SQL Server 2005, it doesn't work any more. Looking at MSmerge_history table under SQL Server 2005, this fields have been removed. Does anyone know where I can access those fields? Is it in another table?
thanks
Romeo
I have several servers that do not have SSMS installed. A couple of them are running as a clustered server. How do I install SSMS on these servers? they are running and have production databases on them. I have tried re-installing the management tools but that didn't work.
Any advice will be greatly appreciated.
I have installed SQL Server 2005 and setup a cluster and log shipping. I decided to perform a planned failover and realized that there are no sp_change_primary_role and sp_change_secondary_role stored procedures. I checked on both the SQL Server 2005 installations and could not find them.
My question is :
"Is it safe to get these stored procedures from a SQL Server 2000 database and run them on the SQL Server 2005 database ??"
"Has anyone come across such missing stored procedures in SQL Server 2005 and know the reason why it is so (so that I can avoid it in the future if it due to a faulty installation) ?"
Cheers
NEVILLE GEORGE
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
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
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??
I have scheduled a job in SQL Server Agent, as it executes it fails Immediatly. The error history displays the following error details, which i copied from the log file
"Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted.
The system cannot find the path specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format. End Error ... The package could not be f... The step failed."
I am using the File System Type to load my package.
Please assisst me in finding the solution
Regards
ZeEsHaN
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?
I've installed an SSL certificate via IIS. I stopped sql server and agent but cannot restart them. I'm getting the following message in the error log:
2007-10-31 21:24:53.63 Server Error: 17182, Severity: 16, State: 1.
2007-10-31 21:24:53.63 Server TDSSNIClient initialization failed with error 0x2, status code 0x38.
2007-10-31 21:24:53.63 Server Error: 17182, Severity: 16, State: 1.
2007-10-31 21:24:53.63 Server TDSSNIClient initialization failed with error 0x2, status code 0x1.
2007-10-31 21:24:53.63 spid9s Starting up database 'model'.
2007-10-31 21:24:53.63 Server Error: 17826, Severity: 18, State: 3.
2007-10-31 21:24:53.63 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-10-31 21:24:53.63 Server Error: 17120, Severity: 16, State: 1.
2007-10-31 21:24:53.63 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
I've tried removing the SSL certificate but with no success.
Help! I'm starting to think that the only solution is to uninstall sql server 2005 and reinstall.
I was studying the SQL Server 2005 Surface Area Configuration tool to see how i could increase security.
I cannot find some of the components in “Surface area Configuration of Features�.
For example DAC appears to be missing. This is a dedicated administrator connection that allows an administrator to connect to a server.
Is this because I have SQL 2005 express instead of the professional version or could it even be to do with the operating system (XP home)
Only the following components are listed under "Database Engine":
Ad Hoc Remote Queries
CLR Integration
Native XML Web Services
OLE Automation
Service Broker
Xp_cmdshell
Thanks
Hi,
Hopefully someone can help me with this.
When I downloaded the files and after burning the DVD to create the DVD to setup the 7031A - Upgrading to Microsoft SQL 2005 course, all of the executable files (BCBase.exe, Upgrade.exe, InPlace.exe, SideBySide.exe and SQL7Upgrade.exe) are not in the Setup/Drives folder...the only item in that folder is a file called "placeholder.txt".
Please, if anyone knows how to get these exectuables let me know.
Thanks,
David - EduCorp Training & Consulting
Good Afternoon,
I just installed SQL Server 2005 64bit on a fresh system with no other applications loaded on running on the new server.
The only other component that was installed with the SS2K5 database services is SSIS. The base installation and the SP2 patch went on perfect.
I went looking for the Management Studio thru the Start menu options and it is NOT under the Microsoft SQL Server 2005 group. The only options under the SS2K5 group are "Configuration Tools" and "Docs and Tutorials".
Here are file names that I downloaded from the MS website and installed.
SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #1 x64 MLF.x11-57796 (which is a zipped)
SQLServer2005SP2-KB921896-x64-ENU
There was also another zipped file that I tried to install but it seems to be a duplicate of the zipped file above:
SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #2 x64 MLF.x11-57797
Any help would be greatly appriciated.
Thanks ALL!
J Kusch
Hi.
I have installed an SQL 2005 Failover Cluster on a Two Node Active Passive Windows 2003 Cluster.If i am trying to failover from the Active node to the passive Node,The Sql Server,Sql Server Agent and SQL Analysis resources fail,However if i reset the passowrd in the services tab of the above three services on the pasive node,the resources come online.
Below is the brief of my setup
1.I have two Active directory domain controllers running Windows 2003 R2 Standard edition with SP2.
2.i have installed a Windows 2003 Two Node Active Passive Cluster as NODE1 and NODE2.
3.The Domain account used to install WIndows 2003 A/P Cluster is Clusteradmin.This account is the member of Administartors on the Domain as well as the Local Admin on NODE1 and NODE2.
4.SQL 2005 with SP2 is installed on both the Nodes as SQL 2005 Failover Cluster.The account used to install SQL 2005 is sqadmin.This account is the member of Administartors on the domain and the member of Local Admins on NODE1 and NODE2.
5.SLQ 2005 has four domain groups for 4 SQL Services.The Services are SQL Server,SQL Server Agent,SLQ Anaylisis Server and Full text Search.
6.Each of these servcie has a seperate service account created for them.All these service accounts areb the members of domain admin and the member of Local Admin on NODE1 and NODE2.
7.Each of these servcies is running under these servcie accounts in the Servcies tab in NODE1 and NODE2.
8.If i fail the resources from NODE1 to NODE2 ,The SQL Server,SQL Server Agent and SQL Anaylisis resources are failing.on going to the service tab of NODE 2 I reset the password for these services,the services come online.
10.The Cluster resources and MSDTC Resources are Failing over successfully.They are coming online successfully.
11,I have a problem with the SQL Server Resources,even if i failback to NODE1 from NODE2,the same resources are failing again.
Plz Advice.
Regards
Khalid
Who needs to invoke the jobs in SQL05? Manually executing the job import_myteam as a user with dbo privileges fails. So, which user account should be assigned to successfully run scheduled jobs (ie, dbo)?
The package file for the job in question is located in the server€™s C:Documents and SettingsuserxyzMy DocumentsVisual Studio 2005ProjectsIntegration Services Project3Integration Services Project3MyTeam (1).dtsx, but this still fails when the user userxyz is logged on and is executing the job directly from the server console.
Step1 of the package executes as userxyz
Step 2 fails and runs as cpmc-casql02
The user account userxyz has administrator rights to the server as well as being a sysadmin of the SQL2005 database (named cpcasql02).
The account cpmc-casql02 is a €śpublic€? user of the database and is a member of the administrator group on the server itself.
This same scenario carries for tasks as simple as truncating a table and importing the contents of another table in the same database.
All of these jobs exhibit the same behavior whether run directly from the server console on remotely from a workstation connected to the SQL2005 database.
Attempting to get a really simple job working, we also created a very simple SSIS package which does a select from a database table and writes the output to a text file. When running the same package from the user€™s workstation within Visual Studio, the package executes successfully. Once copied to the server, and run from within SQLServer as MyJunePackage however, the execution fails in the same manner as described above. The first step executes successfully as the logged-in user and the second fails executed under the account cpmc-casql02.
So, again we have the same behavior of sequential steps being run as different users with unsatisfactory results. Please advise as to how to set up these jobs to run correctly and consistently.
Thanks very much,Eric W
I installed SQL Server 2005 Developer Edition. When i create a new database (using the "New Database" dialog) i cannot set the new database's compatibility level to "SQL Server 2005(90)" because this option is not in the "dropdown list". the only items shown are: "SQL Server 7.0(70)" and "SQL Server 2000(80)". I set the owner to "sa". How do i get "SQL Server 2005(90)" in my "compatibility level" drop down list? Is this an installation option that i missed? Thanks in advance for any assistance!
-chris
Hello all,
I'm new with SP v3 and the Reporting Services of SQL Server 2005.
I did a prototyp report and show it with "SQL Reporting Services
Report"-WebPart, but I can't find the WebParts Report Viewer and
Explorer in the WebPart Gallery.
Please, could somebody give me a clue where the problem could be, or
how I could isolate the problem area.
Cheers
Marc
Hello, hoping someone might be able to help.
I've set up Database Mail on an instance of 2005 and the test mail works just fine. However, when testing a job (notify on fail, success, whatever) the mail fails to send. Job History last information reads NOTE: Failed to notify 'My Name' via email.
Checked out the Database Mail logs - nothing interesting.
Restarted the Agent service and then checked out the current Agent Log. Found message:
[260] Unable to start mail session (reason: No mail profile defined).
The 'DatabaseMailProfile' key is most certainly defined in the Registry
(at 'HKEY_LOCAL_MACHINE', N'SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1SQLServerAgent')
I'm at a loss...why is it telling me no mail profile defined?
I'd be most grateful for any help if anybody else has run across this problem.
Cheers,
Megan
I have six stored procedures that I have to run hourly during the day. When I schedule them into separate SQL jobs (they must run concurrently), the percent CPU of Sqlagent90.exe process goes way up, eventually pegging out the overal CPU usage on the server. When I run the six stored procedures concurrently from query windows in SQL Server Management Sudio, the overall CPU usage stays very low.
Is there something about the SQL Server Agent that inherently adds CPU overheard? Thanks in advance ....
After some weeks evaluating tools and platforms for developing an application, I decided to move to SQL Server 2005 Express Edition. Everything was fine till last night, when after creating my tables, I needed to populate them. I tried to find the Import and Export Data Wizard that SQL Server 7.0 and 2000 used to have, but great was my surprise when I found - in this forum - a post that said that it's not available in the Express Edition.
I'll have to move back in time (what I hate) to remember the way BCP worked. Can somebody post some examples to not start from zero ? Does anybody know a third party visual tool that can import/export data from text files to a SQL Server DB via ODBC ?
What's the reason it was not included in the EE ?
THanks !