0
votes
0answers
165 views

SQL Server keep crashing, cannot connect with SSMS, Agent not starting

System Windows Server 2003 x64 SQL Server 2005 x64 Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmin group) - If I supplied the wrong password, ...
1
vote
2answers
4k views

Add SSH host key to another user's PuTTY cache

I have written a PS1 script that 7-zips a file and uses PuTTY's SCP to store it at my back-up server. I have tested it and it works perfectly. Then I log into my SQL Server Agent and add an extra ...
0
votes
1answer
500 views

Error SQL Server 2005 Using Proxy to run Agent Job ConnGetProxyPassword

I'm using a proxy to run several SQL Server agent jobs. Essentially the jobs copy data from Excel spreadsheets into a dbs via a network shared drive. The jobs have been failing for several weeks with ...
1
vote
2answers
2k views

Is it safe to restart Sql Server Agent?

I've found myself in the tenuous role of a developer tasked to manage a SQL server. I've set up some jobs to run on a schedule, but would like to receive email notification on completion. I've set ...
1
vote
1answer
190 views

Can you use a relatively expensive filter on transactional replication?

I'm trying to replicate (transactional, push) a relatively small table (50K rows), subject to several different filters, which are rather expensive (each taking at least an hour long to complete, ...
2
votes
2answers
3k views

SQL Server Agent refuses to start

I'm having a problem with SQL Server 2005 where the SQL Server Agent suddenly refuses to start. If I attempt to start it through Services, I get the error "SQL Server Agent (MSSQLSERVER) service on ...
0
votes
1answer
275 views

SQL Server Agent 2005 job runs but provides no output

Essentially I have a job which runs in BIDS and as as a stand lone package and while it runs under the SQL Server Agent it doesn't complete properly (no error messages though). The job steps are: 1) ...
0
votes
2answers
1k views

SQL Server 2005 Agent running SSIS job can't find file path

Basically I'm trying to run a functioning SSIS job (created in BIDS) under the SQL Server Agent - it reads a set of Excel spreadsheets and dumps the results into a table. The problem I'm having is ...
3
votes
3answers
2k views

How to execute msdb.dbo.sp_start_job from a stored procedure in user database in sql server 2005

I am trying to execute a msdb.dbo.sp_start_Job from MyDB.dbo.MyStoredProc in order to execute MyJob 1) I Know that if i give the user a SqlAgentUser role he will be able to run the jobs that he owns ...
1
vote
1answer
172 views

SQL Server 2005 Alerts no Email Option

I've got Database Mail set up successfully, I can send test emails, however when I go to set up an alert to be sent by email to an operator I don't have a checkbox to check to say email should be ...
2
votes
3answers
3k views

Run a SQL Server 2005 Job as Administrator on Windows Server 2008

I have a job, C:\foo.bat. When I run the job from windows explorer it fails. When I right click on the file and click "Run as administrator..." the job passes. Now when I setup the job in SQL ...
0
votes
1answer
982 views

SSRS - SQL Agent Job Report Queuing

So we have a small number of SQL Server 2005 Servers running a lot of SSRS reports, which is running into issues where the servers cannot keep up with the total number of reports, that users are ...
4
votes
5answers
12k views

Calling sp_start_job from a stored procedure

Our developers to be able to start a SQL Server Agent job from their .Net code. I know I can call *msdb..sp_start_job* to do just that, but I don't want to give general user accounts direct access to ...
1
vote
4answers
804 views

SQL Server 2005 error related to SQL Agent and Database Restores

I have been restoring sql 2005 databases from one server to another (similar spec, same version and service pack etc.) and have encountered the following. The problem starts with the restore of the ...