Cant Auto-Start Agent

I have a SQL Server 2000 that failed to start after a Windows reboot.
Agent properties are checked to auto start if stopped. Under the Agent
Error Log, I have the following data:

Information:
SQL Agent stopping because of Windows shutdown.
SQL Agent terminated normally.

Error:
SQL Server Error: 1115, cannot generate SSPI context SQLState HY000.
Logon to server(local) failed.

Help apprecaited. Thanks
Frank

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Frank Py <fpy@.proactnet.com> wrote in message news:<3f843998$0$202$75868355@.news.frii.net>...
> I have a SQL Server 2000 that failed to start after a Windows reboot.
> Agent properties are checked to auto start if stopped. Under the Agent
> Error Log, I have the following data:
> Information:
> SQL Agent stopping because of Windows shutdown.
> SQL Agent terminated normally.
> Error:
> SQL Server Error: 1115, cannot generate SSPI context SQLState HY000.
> Logon to server(local) failed.
> Help apprecaited. Thanks
> Frank
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

You might find these KB articles helpful:

http://support.microsoft.com/defaul...9&Product=sql2k
http://support.microsoft.com/defaul...4&Product=sql2k

Simon|||I am having this problem, too. Have you found a solution?

Can't access merge agent properties

Hi,
I'm having a problem trying to access merge agent's properties. I have
a SqlServer publication that synchronizes with diferent PDA devices.
These devices register themselfes as subscribers to synchronize with
the database and create a merge agent for each of them.
The problem is that I can't access the agent's properties. If I go to
Replication Monitor -> Agents -> Merge Agents in sql server's
administrative console, right click one of the agent (e.g subscription
name 21F:-460) and then select "Agent Properties..." i get a login
screen "Connect to Sql Server: 21F" and asks for user & password.
What is this account ? I can't understand how this works, could
somebody explain it please ? Is it possible to access merge agent
properties ?
Any help would be appreciated,
thx in advance.
ori
That's the problem with the ActiveX controls used by replication, you can't view the properties in EM.
I normally don't get this error message however when I right click on the agents.
To administer these activeX agents you need to make changes in your code, not through EM.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"ORi" wrote:

> Hi,
> I'm having a problem trying to access merge agent's properties. I have
> a SqlServer publication that synchronizes with diferent PDA devices.
> These devices register themselfes as subscribers to synchronize with
> the database and create a merge agent for each of them.
> The problem is that I can't access the agent's properties. If I go to
> Replication Monitor -> Agents -> Merge Agents in sql server's
> administrative console, right click one of the agent (e.g subscription
> name 21F:-460) and then select "Agent Properties..." i get a login
> screen "Connect to Sql Server: 21F" and asks for user & password.
> What is this account ? I can't understand how this works, could
> somebody explain it please ? Is it possible to access merge agent
> properties ?
> Any help would be appreciated,
> thx in advance.
> ori
>

Can't access merge agent properties

I'm trying to set the logging level on a merge agent. I've read
KB312292. When I right click on the agent and select properties some
text flashes in the status bar but no dialog is displayed. I'm using
SQL 2K SP4.
TIA
Is this for pulls configure through ActiveX scripts/programming? or WSM
pulls?
You can't do it for these.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Darren" <darren@.nospam.com> wrote in message
news:eiaIuotFGHA.3120@.TK2MSFTNGP10.phx.gbl...
> I'm trying to set the logging level on a merge agent. I've read KB312292.
> When I right click on the agent and select properties some text flashes in
> the status bar but no dialog is displayed. I'm using SQL 2K SP4.
> TIA
|||Hilary Cotter wrote:
> Is this for pulls configure through ActiveX scripts/programming? or WSM
> pulls?
> You can't do it for these.
>
It was created from a C# app using the merge object. So how can I
change the logging level for that agent without using what is described
in the KB article?
|||use the status event to get messages. You will probably have to configure
the agent to use the verbose profile to see these messages. I would restart
on failure to use the new profile; running with the verbose profile does not
perform well.
Let me know if you need code for this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Darren" <Darren@.nospam.nospam> wrote in message
news:elcSkBvFGHA.3200@.tk2msftngp13.phx.gbl...
> Hilary Cotter wrote:
> It was created from a C# app using the merge object. So how can I change
> the logging level for that agent without using what is described in the KB
> article?
|||Thanks.
I don't this the status event callback provides enough detail.
I'm trying to get the equivalent of the following options
-output c:\log.txt -outverboselevel 3
I don't see either in the merge profile options.
Hilary Cotter wrote:
> use the status event to get messages. You will probably have to configure
> the agent to use the verbose profile to see these messages. I would restart
> on failure to use the new profile; running with the verbose profile does not
> perform well.
> Let me know if you need code for this.
>

Cann't execute integration service package with SQL server agent

hi, can anyone explain, how to execute package with sql server agent:

the problem is::

i made a integration service package (in visual studio 2005). When I 'm in visual studio and do "execute" the package it works well. Then I build a dtsx file. When i double click on it, it opens and if i do execute, it works well.

I want to execute the package every week automatically. I write a job in SQL server agent, in Steps I choosed Type=SQL server Integration service packege, then General->packacge source -> file system, and then wrote where the dtsx file is (which was built). "Run as" I choose my user name.

then i'm trying to start a job, but it fails, and writes "The package execution failed."

What I'm doing wrong.

(sorry for my english)

The error message you are getting indicates that you are running the package in the SQL Serve agent as a 'Integration services package' step; right?

The problem with that is that if there is any problem with the execution you message error won't provide any details. To start change the step type to use CmdExec, so the error message is more descriptive. Most of the times the error is due to permission (when the agent executes the job it uses the account that it is being used to run the agent) or the protection level you used to saved your package (a package property).Look into this article for more details:

http://support.microsoft.com/default.aspx/kb/918760

Rafael Salas

Rafael Salas

|||

Some more notes on permissions, such as those for the file store, and a nice example that illustrates the difference between what you can get from the CmdExec step versus the SSIS subsystem-

Scheduled Packages
(http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html)

Cannot view log for SQL Agent job (SQL2005)

Hi,
I've set up jobs and output files in SQL2005. When the job is completed, I
would like to check the output file by clicking VIEW button. However, the
button is grey-out.
The owner of the job is sa. What is other permission I missed ?
Thanks.
Hi Johnny
"Johnny" wrote:

> Hi,
> I've set up jobs and output files in SQL2005. When the job is completed, I
> would like to check the output file by clicking VIEW button. However, the
> button is grey-out.
> The owner of the job is sa. What is other permission I missed ?
> Thanks.
According to Books Online it is not available in SQL 2005
From Books Online:
View
In Microsoft SQL Server 2005, this button is disabled for viewing output
files. Instead, use Notepad to view job step output files. In Microsoft SQL
Server 2000, this launches Notepad to view the output file.
John
|||Hi John,
Thank you. Why leave the button there ?
Regards,
Johnny
"John Bell" wrote:

> Hi Johnny
> "Johnny" wrote:
> According to Books Online it is not available in SQL 2005
> From Books Online:
> View
> In Microsoft SQL Server 2005, this button is disabled for viewing output
> files. Instead, use Notepad to view job step output files. In Microsoft SQL
> Server 2000, this launches Notepad to view the output file.
>
> John
>
|||Hi Johnny
"Johnny" wrote:
[vbcol=seagreen]
> Hi John,
> Thank you. Why leave the button there ?
> Regards,
> Johnny
> "John Bell" wrote:
I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
will bring up the log file in Notepad!!!!
John
|||Yes, I always check the output file for any jobs in SQL2000 Agent job.
"John Bell" wrote:

> Hi Johnny
> "Johnny" wrote:
>
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
> will bring up the log file in Notepad!!!!
> John
|||"John Bell" wrote:
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
> will bring up the log file in Notepad!!!!
> John
And it does!!
John

Cannot view log for SQL Agent job (SQL2005)

Hi,
I've set up jobs and output files in SQL2005. When the job is completed, I
would like to check the output file by clicking VIEW button. However, the
button is grey-out.
The owner of the job is sa. What is other permission I missed ?
Thanks.Hi Johnny
"Johnny" wrote:

> Hi,
> I've set up jobs and output files in SQL2005. When the job is completed,
I
> would like to check the output file by clicking VIEW button. However, the
> button is grey-out.
> The owner of the job is sa. What is other permission I missed ?
> Thanks.
According to Books Online it is not available in SQL 2005
From Books Online:
View
In Microsoft SQL Server 2005, this button is disabled for viewing output
files. Instead, use Notepad to view job step output files. In Microsoft SQL
Server 2000, this launches Notepad to view the output file.
John|||Hi John,
Thank you. Why leave the button there ?
Regards,
Johnny
"John Bell" wrote:

> Hi Johnny
> "Johnny" wrote:
>
> According to Books Online it is not available in SQL 2005
> From Books Online:
> View
> In Microsoft SQL Server 2005, this button is disabled for viewing output
> files. Instead, use Notepad to view job step output files. In Microsoft SQ
L
> Server 2000, this launches Notepad to view the output file.
>
> John
>|||Hi Johnny
"Johnny" wrote:
[vbcol=seagreen]
> Hi John,
> Thank you. Why leave the button there ?
> Regards,
> Johnny
> "John Bell" wrote:
>
I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
will bring up the log file in Notepad!!!!
John|||Yes, I always check the output file for any jobs in SQL2000 Agent job.
"John Bell" wrote:

> Hi Johnny
> "Johnny" wrote:
>
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then i
t
> will bring up the log file in Notepad!!!!
> John|||"John Bell" wrote:
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then i
t
> will bring up the log file in Notepad!!!!
> John
And it does!!
John

Cannot view log for SQL Agent job (SQL2005)

Hi,
I've set up jobs and output files in SQL2005. When the job is completed, I
would like to check the output file by clicking VIEW button. However, the
button is grey-out.
The owner of the job is sa. What is other permission I missed ?
Thanks.Hi Johnny
"Johnny" wrote:
> Hi,
> I've set up jobs and output files in SQL2005. When the job is completed, I
> would like to check the output file by clicking VIEW button. However, the
> button is grey-out.
> The owner of the job is sa. What is other permission I missed ?
> Thanks.
According to Books Online it is not available in SQL 2005
From Books Online:
View
In Microsoft SQL Server 2005, this button is disabled for viewing output
files. Instead, use Notepad to view job step output files. In Microsoft SQL
Server 2000, this launches Notepad to view the output file.
John|||Hi John,
Thank you. Why leave the button there ?
Regards,
Johnny
"John Bell" wrote:
> Hi Johnny
> "Johnny" wrote:
> > Hi,
> >
> > I've set up jobs and output files in SQL2005. When the job is completed, I
> > would like to check the output file by clicking VIEW button. However, the
> > button is grey-out.
> >
> > The owner of the job is sa. What is other permission I missed ?
> >
> > Thanks.
> According to Books Online it is not available in SQL 2005
> From Books Online:
> View
> In Microsoft SQL Server 2005, this button is disabled for viewing output
> files. Instead, use Notepad to view job step output files. In Microsoft SQL
> Server 2000, this launches Notepad to view the output file.
>
> John
>|||Hi Johnny
"Johnny" wrote:
> Hi John,
> Thank you. Why leave the button there ?
> Regards,
> Johnny
> "John Bell" wrote:
> > According to Books Online it is not available in SQL 2005
> >
> > From Books Online:
> >
> > View
> > In Microsoft SQL Server 2005, this button is disabled for viewing output
> > files. Instead, use Notepad to view job step output files. In Microsoft SQL
> > Server 2000, this launches Notepad to view the output file.
> >
> >
> > John
> >
I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
will bring up the log file in Notepad!!!!
John|||Yes, I always check the output file for any jobs in SQL2000 Agent job.
"John Bell" wrote:
> Hi Johnny
> "Johnny" wrote:
> > Hi John,
> >
> > Thank you. Why leave the button there ?
> >
> > Regards,
> > Johnny
> >
> > "John Bell" wrote:
> >
> > > According to Books Online it is not available in SQL 2005
> > >
> > > From Books Online:
> > >
> > > View
> > > In Microsoft SQL Server 2005, this button is disabled for viewing output
> > > files. Instead, use Notepad to view job step output files. In Microsoft SQL
> > > Server 2000, this launches Notepad to view the output file.
> > >
> > >
> > > John
> > >
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
> will bring up the log file in Notepad!!!!
> John|||"John Bell" wrote:
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
> will bring up the log file in Notepad!!!!
> John
And it does!!
John

cannot start sqlserver agent - urgent

I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
Is your local SQL Server instance running? Can you connect to your SQL
instance using a different tool (like Query Analyser or osql.exe) and
the same login (be it a SQL login or a trusted connection) that your
instance of SQLAgent is configured to use? Is SQLAgent configured to
use a trusted connection or a standard SQL login?
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:

>I cannot start the sqlserver agent neither manually or automatically and I
>get this message in the event log:
>SQLServerAgent could not be started (reason: Unable to connect to server
>'(local)'; SQLServerAgent cannot start).
>Can anyone please help? Thanks.
>
>
|||How can I find out the SQLagent configuration of trust connection or standard SQL login? And how can I get help from this. Thanks.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
Is your local SQL Server instance running? Can you connect to your SQL instance using a different tool (like Query Analyser or osql.exe) and the same login (be it a SQL login or a trusted connection) that your instance of SQLAgent is configured to use? Is SQLAgent configured to use a trusted connection or a standard SQL login?
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
00allen_iverson wrote:
I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
|||Open SQL Enterprise Manager. Expand the branches to expose your local
instance. Left-click on the local instance; this will establish a
client connection (SQLEM being the client) to your server. If that is
successful then your SQL server is running and accepting client connections.
Expand the + next to the server name. Expand the + next to Management.
Right-click on SQL Server Agent and select the property menu option.
This will bring up the configuration dialog box for SQL Agent.
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:
http://msdn.microsoft.com/library/de...omate_01et.asp)
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
[vbcol=seagreen]
> How can I find out the SQLagent configuration of trust connection or
> standard SQL login? And how can I get help from this. Thanks.
>
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com
> <mailto:mike.hodgson@.mallesons.nospam.com>> wrote in message
> news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
> Is your local SQL Server instance running? Can you connect to
> your SQL instance using a different tool (like Query Analyser or
> osql.exe) and the same login (be it a SQL login or a trusted
> connection) that your instance of SQLAgent is configured to use?
> Is SQLAgent configured to use a trusted connection or a standard
> SQL login?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> 00allen_iverson wrote:

cannot start sqlserver agent - urgent

I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.Is your local SQL Server instance running? Can you connect to your SQL
instance using a different tool (like Query Analyser or osql.exe) and
the same login (be it a SQL login or a trusted connection) that your
instance of SQLAgent is configured to use? Is SQLAgent configured to
use a trusted connection or a standard SQL login?
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:

>I cannot start the sqlserver agent neither manually or automatically and I
>get this message in the event log:
>SQLServerAgent could not be started (reason: Unable to connect to server
>'(local)'; SQLServerAgent cannot start).
>Can anyone please help? Thanks.
>
>|||How can I find out the SQLagent configuration of trust connection or standar
d SQL login? And how can I get help from this. Thanks.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:u0r
F7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
Is your local SQL Server instance running? Can you connect to your SQL inst
ance using a different tool (like Query Analyser or osql.exe) and the same l
ogin (be it a SQL login or a trusted connection) that your instance of SQLAg
ent is configured to use? Is SQLAgent configured to use a trusted connectio
n or a standard SQL login?
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
00allen_iverson wrote:
I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.|||Open SQL Enterprise Manager. Expand the branches to expose your local
instance. Left-click on the local instance; this will establish a
client connection (SQLEM being the client) to your server. If that is
successful then your SQL server is running and accepting client connections.
Expand the + next to the server name. Expand the + next to Management.
Right-click on SQL Server Agent and select the property menu option.
This will bring up the configuration dialog box for SQL Agent.
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:
ate_01et.asp" target="_blank">http://msdn.microsoft.com/library/d...>
ate_01et.asp)
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
[vbcol=seagreen]
> How can I find out the SQLagent configuration of trust connection or
> standard SQL login? And how can I get help from this. Thanks.
>
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com
> <mailto:mike.hodgson@.mallesons.nospam.com>> wrote in message
> news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
> Is your local SQL Server instance running? Can you connect to
> your SQL instance using a different tool (like Query Analyser or
> osql.exe) and the same login (be it a SQL login or a trusted
> connection) that your instance of SQLAgent is configured to use?
> Is SQLAgent configured to use a trusted connection or a standard
> SQL login?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> 00allen_iverson wrote:
>

cannot start sqlserver agent - urgent

I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.This is a multi-part message in MIME format.
--000802080501040405060909
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Is your local SQL Server instance running? Can you connect to your SQL
instance using a different tool (like Query Analyser or osql.exe) and
the same login (be it a SQL login or a trusted connection) that your
instance of SQLAgent is configured to use? Is SQLAgent configured to
use a trusted connection or a standard SQL login?
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
>I cannot start the sqlserver agent neither manually or automatically and I
>get this message in the event log:
>SQLServerAgent could not be started (reason: Unable to connect to server
>'(local)'; SQLServerAgent cannot start).
>Can anyone please help? Thanks.
>
>
--000802080501040405060909
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Is your local SQL Server instance running? </tt><tt>Can you
connect to your SQL instance using a different tool (like Query
Analyser or osql.exe) and the same login (be it a SQL login or a
trusted connection) that your instance of SQLAgent is configured to
use? Is SQLAgent configured to use a trusted connection or a standard
SQL login?</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
00allen_iverson wrote:
<blockquote cite="mideM3MWIZYFHA.1404@.TK2MSFTNGP09.phx.gbl" type="cite">
<pre wrap="">I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
</pre>
</blockquote>
</body>
</html>
--000802080501040405060909--|||This is a multi-part message in MIME format.
--=_NextPart_000_000F_01C561D8.D5F683E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How can I find out the SQLagent configuration of trust connection or =standard SQL login? And how can I get help from this. Thanks.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message =news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
Is your local SQL Server instance running? Can you connect to your =SQL instance using a different tool (like Query Analyser or osql.exe) =and the same login (be it a SQL login or a trusted connection) that your =instance of SQLAgent is configured to use? Is SQLAgent configured to =use a trusted connection or a standard SQL login?
--
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W =http://www.mallesons.com=20
00allen_iverson wrote: I cannot start the sqlserver agent neither manually or automatically and =I get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server =
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
--=_NextPart_000_000F_01C561D8.D5F683E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

How can I find out the SQLagent =configuration of trust connection or standard SQL login? And how can I get help =from this. Thanks.
"Mike Hodgson" wrote in message news:u0rF7QZYFHA.4060=@.TK2MSFTNGP10.phx.gbl...Is your local SQL Server instance running? Can you connect =to your SQL instance using a different tool (like Query Analyser or osql.exe) =and the same login (be it a SQL login or a trusted connection) that your =instance of SQLAgent is configured to use? Is SQLAgent configured to use a =trusted connection or a standard SQL login?
--mike =hodgson | database =administrator | mallesons =stephen jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.nospam.com | W http://www.mallesons.com 00allen_iverson wrote: I cannot start the sqlserver agent neither =manually or automatically and I get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server ='(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.

---

--=_NextPart_000_000F_01C561D8.D5F683E0--|||This is a multi-part message in MIME format.
--010604090704090006030404
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Open SQL Enterprise Manager. Expand the branches to expose your local
instance. Left-click on the local instance; this will establish a
client connection (SQLEM being the client) to your server. If that is
successful then your SQL server is running and accepting client connections.
Expand the + next to the server name. Expand the + next to Management.
Right-click on SQL Server Agent and select the property menu option.
This will bring up the configuration dialog box for SQL Agent.
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp)
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
> How can I find out the SQLagent configuration of trust connection or
> standard SQL login? And how can I get help from this. Thanks.
>
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com
> <mailto:mike.hodgson@.mallesons.nospam.com>> wrote in message
> news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
> Is your local SQL Server instance running? Can you connect to
> your SQL instance using a different tool (like Query Analyser or
> osql.exe) and the same login (be it a SQL login or a trusted
> connection) that your instance of SQLAgent is configured to use?
> Is SQLAgent configured to use a trusted connection or a standard
> SQL login?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> 00allen_iverson wrote:
>>I cannot start the sqlserver agent neither manually or automatically and I
>>get this message in the event log:
>>SQLServerAgent could not be started (reason: Unable to connect to server
>>'(local)'; SQLServerAgent cannot start).
>>Can anyone please help? Thanks.
>>
>>
--010604090704090006030404
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Open SQL Enterprise Manager. Expand the branches to expose your
local instance. Left-click on the local instance; this will establish
a client connection (SQLEM being the client) to your server. If that
is successful then your SQL server is running and accepting client
connections.<br>
<br>
Expand the + next to the server name. Expand the + next to
Management. Right-click on SQL Server Agent and select the property
menu option. This will bring up the configuration dialog box for SQL
Agent.<br>
<br>
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.<br>
<br>
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:<br>
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp</a>)<br>">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp</a>)<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
00allen_iverson wrote:
<blockquote cite="mideGEYJXZYFHA.2128@.TK2MSFTNGP14.phx.gbl" type="cite">
<title></title>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<meta content="MSHTML 6.00.2900.2604" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">How can I find out the SQLagent
configuration of trust connection or standard SQL login? And how can I
get help from this. Thanks.</font></div>
<div> </div>
<blockquote
style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;"
dir="ltr">
<div>"Mike Hodgson" <<a
href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mike.hodgson@.mallesons.nospam.com</a>>
wrote in message <a href="http://links.10026.com/?link=news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl">news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl</a>...</div>
<tt>Is your local SQL Server instance running? </tt><tt>Can you
connect to your SQL instance using a different tool (like Query
Analyser or osql.exe) and the same login (be it a SQL login or a
trusted connection) that your instance of SQLAgent is configured to
use? Is SQLAgent configured to use a trusted connection or a standard
SQL login?</tt><br>
<div class="moz-signature">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2">database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font
face="Tahoma" size="2"> +61 (2) 9296 3668 |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">F</font></b><font
face="Tahoma" size="2"> +61 (2) 9296 3885 |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">M</font></b><font
face="Tahoma" size="2"> +61 (408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma"
size="2"> <a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
|</font><b><font face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=http://www.mallesons.com</a></font></span>">http://www.mallesons.com">http://www.mallesons.com</a></font></span>
</p>
</div>
<br>
<br>
00allen_iverson wrote:
<blockquote cite="mideM3MWIZYFHA.1404@.TK2MSFTNGP09.phx.gbl"
type="cite">
<pre wrap="">I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
</pre>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>
--010604090704090006030404--

Cannot Start SQL Server Agent

Whenever I attempt to start SQL Server Agent I get the following error message: "An error 5 - (Access is denied) occurred while performing this service operation on the SQLServerAgent service"
I log in to the SQL Server as 'sa'. What could be the possible problem?Originally posted by AlveenX
Whenever I attempt to start SQL Server Agent I get the following error message: "An error 5 - (Access is denied) occurred while performing this service operation on the SQLServerAgent service"

I log in to the SQL Server as 'sa'. What could be the possible problem?

What user is set to startup the SQLAgent service? This user must be added in SQLServer logins and give system administrator rights over the SQLServer.

ionut|||The easy way (i think), on Services, try to put the service starting with the "local system account"|||SQL Server uses a windows account to start the sql server agent service. This user should have preferably administrator rights on the machine where the sql server resides. This user can be a local user ( in that case "local system account" is best, as pal19 already mentioned) or, if the sql server has to communicate with other (sql) servers, a domain user account.
You can change the user account that is used in the enterprise manager. Go to management --> sql server agent --> right click and select properties --> general tab. You can also go to the services tab in the Windows administrative tools and change the properties of the sql server agent service there.|||Thanks Jora, Pal19 and Ionut Calin. SQL Server Agent has eventually started. Thanks so much for your help.

AlveenX

Cannot start SQL Server & Sql Agent

Hi,
i am running SQL server 2000 evaluation copy on SQL server 2003 and
suddenly i cannot open my EM
From Service Manager , i can start SQL Server but not SQL Agent, From EM
, i could not connect to my SQL Database
it says : "connection could not be established ... Access denied or SQL
Server does not exist"
Appreciate any advice
tks & rdgs
Hi ,
here's the error msg from ErrorLog:
2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2005-03-27 00:35:51 - ! [000] Unable to connect to server 'WKRZ\PRODUCTION';
SQLServerAgent cannot start
2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
rdgs
"maxzsim" wrote:

> Hi,
> i am running SQL server 2000 evaluation copy on SQL server 2003 and
> suddenly i cannot open my EM
> From Service Manager , i can start SQL Server but not SQL Agent, From EM
> , i could not connect to my SQL Database
> it says : "connection could not be established ... Access denied or SQL
> Server does not exist"
> Appreciate any advice
> tks & rdgs
|||Hi
Running an evaluation copy on an instance called Production sounds very
suspicious!
Have you seen:
http://support.microsoft.com/default...b;en-us;237604
John
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:C7AB28C2-5EEA-49BA-BB33-4A834AD400CA@.microsoft.com...[vbcol=seagreen]
> Hi ,
> here's the error msg from ErrorLog:
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not
> exist
> or access denied. [SQLSTATE 08001]
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2005-03-27 00:35:51 - ! [000] Unable to connect to server
> 'WKRZ\PRODUCTION';
> SQLServerAgent cannot start
> 2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
> rdgs
> "maxzsim" wrote:

Cannot start SQL Server & Sql Agent

Hi,
i am running SQL server 2000 evaluation copy on SQL server 2003 and
suddenly i cannot open my EM
From Service Manager , i can start SQL Server but not SQL Agent, From EM
, i could not connect to my SQL Database
it says : "connection could not be established ... Access denied or SQL
Server does not exist"
Appreciate any advice
tks & rdgsHi ,
here's the error msg from ErrorLog:
2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not e
xist
or access denied. [SQLSTATE 08001]
2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2005-03-27 00:35:51 - ! [000] Unable to connect to server 'WKRZ\PRODUCTI
ON';
SQLServerAgent cannot start
2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
rdgs
"maxzsim" wrote:

> Hi,
> i am running SQL server 2000 evaluation copy on SQL server 2003 and
> suddenly i cannot open my EM
> From Service Manager , i can start SQL Server but not SQL Agent, From E
M
> , i could not connect to my SQL Database
> it says : "connection could not be established ... Access denied or SQL
> Server does not exist"
> Appreciate any advice
> tks & rdgs|||Hi
Running an evaluation copy on an instance called Production sounds very
suspicious!
Have you seen:
http://support.microsoft.com/defaul...kb;en-us;237604
John
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:C7AB28C2-5EEA-49BA-BB33-4A834AD400CA@.microsoft.com...[vbcol=seagreen]
> Hi ,
> here's the error msg from ErrorLog:
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not
> exist
> or access denied. [SQLSTATE 08001]
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2005-03-27 00:35:51 - ! [000] Unable to connect to server
> 'WKRZ\PRODUCTION';
> SQLServerAgent cannot start
> 2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
> rdgs
> "maxzsim" wrote:
>

Cannot start SQL Server & Sql Agent

Hi,
i am running SQL server 2000 evaluation copy on SQL server 2003 and
suddenly i cannot open my EM
From Service Manager , i can start SQL Server but not SQL Agent, From EM
, i could not connect to my SQL Database
it says : "connection could not be established ... Access denied or SQL
Server does not exist"
Appreciate any advice
tks & rdgsHi ,
here's the error msg from ErrorLog:
2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not exist
or access denied. [SQLSTATE 08001]
2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2005-03-27 00:35:51 - ! [000] Unable to connect to server 'WKRZ\PRODUCTION';
SQLServerAgent cannot start
2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
rdgs
"maxzsim" wrote:
> Hi,
> i am running SQL server 2000 evaluation copy on SQL server 2003 and
> suddenly i cannot open my EM
> From Service Manager , i can start SQL Server but not SQL Agent, From EM
> , i could not connect to my SQL Database
> it says : "connection could not be established ... Access denied or SQL
> Server does not exist"
> Appreciate any advice
> tks & rdgs|||Hi
Running an evaluation copy on an instance called Production sounds very
suspicious!
Have you seen:
http://support.microsoft.com/default.aspx?scid=kb;en-us;237604
John
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:C7AB28C2-5EEA-49BA-BB33-4A834AD400CA@.microsoft.com...
> Hi ,
> here's the error msg from ErrorLog:
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 17, SQL Server does not
> exist
> or access denied. [SQLSTATE 08001]
> 2005-03-27 00:35:51 - ! [298] SQLServer Error: 10060, ConnectionOpen
> (Connect()). [SQLSTATE 01000]
> 2005-03-27 00:35:51 - ! [000] Unable to connect to server
> 'WKRZ\PRODUCTION';
> SQLServerAgent cannot start
> 2005-03-27 00:35:51 - ? [098] SQLServerAgent terminated (normally)
> rdgs
> "maxzsim" wrote:
>> Hi,
>> i am running SQL server 2000 evaluation copy on SQL server 2003 and
>> suddenly i cannot open my EM
>> From Service Manager , i can start SQL Server but not SQL Agent, From
>> EM
>> , i could not connect to my SQL Database
>> it says : "connection could not be established ... Access denied or SQL
>> Server does not exist"
>> Appreciate any advice
>> tks & rdgs

Cannot start sql agent in 2005

I get this message when I try to start a sql 2005 server agent. Im
running windows 2003 service pack 1 and sql 2005 service pack 1. The
strange thing is the agent and sql service are running as a domain
account with sysadmin privileges.
Can anyone help?
SQLServerAgent could not be started (reason: SQLServerAgent must be
able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
member of the SysAdmin role).You can see the login attributes used by Agent if you in SSMS right-click Agent, the Connection
page. Make sure that this account/login exists and a login in SQL Server and that it has sysadmin
privileges in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Blakmk" <M.G.Blakey@.googlemail.com> wrote in message
news:1162379472.947639.182570@.b28g2000cwb.googlegroups.com...
>I get this message when I try to start a sql 2005 server agent. Im
> running windows 2003 service pack 1 and sql 2005 service pack 1. The
> strange thing is the agent and sql service are running as a domain
> account with sysadmin privileges.
> Can anyone help?
> SQLServerAgent could not be started (reason: SQLServerAgent must be
> able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
> member of the SysAdmin role).
>

Cannot start sql agent in 2005

I get this message when I try to start a sql 2005 server agent. Im
running windows 2003 service pack 1 and sql 2005 service pack 1. The
strange thing is the agent and sql service are running as a domain
account with sysadmin privileges.
Can anyone help?
SQLServerAgent could not be started (reason: SQLServerAgent must be
able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
member of the SysAdmin role).You can see the login attributes used by Agent if you in SSMS right-click Ag
ent, the Connection
page. Make sure that this account/login exists and a login in SQL Server and
that it has sysadmin
privileges in SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Blakmk" <M.G.Blakey@.googlemail.com> wrote in message
news:1162379472.947639.182570@.b28g2000cwb.googlegroups.com...
>I get this message when I try to start a sql 2005 server agent. Im
> running windows 2003 service pack 1 and sql 2005 service pack 1. The
> strange thing is the agent and sql service are running as a domain
> account with sysadmin privileges.
> Can anyone help?
> SQLServerAgent could not be started (reason: SQLServerAgent must be
> able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
> member of the SysAdmin role).
>

Cannot start Microsoft SQL Server agent & Enterprise manager

Hi:
I am receiving the following error message while trying to open Enterprise
Manager in MSSQL 2000 Server.
A connection could not be established to ABCD
Reason : I/O error 1117(the request could not performed because of an I/O
device error.) detected during read at offset 0x00000000b1e000 in file
'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
Please verify SQL Server is running and check your SQL Server registration
properties (by right cliking on the ABCD node) and try again.
This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
3). The MSSQL server service SQL Server Agent services are running under
local system. This is a Standalone machine.
Help is required on an urgent basis as this is a production server.
With Regards
Mitul
You have a problem with the mdf file for your master database file. Possibly the file is locked by
some other process (like anti-virus). If that is the case, try again. If you are unlucky, the master
mdf file is corrupt for some reason, and you have to go the rebuildm.exe route.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mitul" <Mitul@.discussions.microsoft.com> wrote in message
news:46466B5B-D821-4C07-BD8C-8996EBAD7915@.microsoft.com...
> Hi:
> I am receiving the following error message while trying to open Enterprise
> Manager in MSSQL 2000 Server.
>
> A connection could not be established to ABCD
> Reason : I/O error 1117(the request could not performed because of an I/O
> device error.) detected during read at offset 0x00000000b1e000 in file
> 'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
> Please verify SQL Server is running and check your SQL Server registration
> properties (by right cliking on the ABCD node) and try again.
>
> This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
> 3). The MSSQL server service SQL Server Agent services are running under
> local system. This is a Standalone machine.
> Help is required on an urgent basis as this is a production server.
> With Regards
> Mitul

Cannot start Microsoft SQL Server agent & Enterprise manager

Hi:
I am receiving the following error message while trying to open Enterprise
Manager in MSSQL 2000 Server.
---
A connection could not be established to ABCD
Reason : I/O error 1117(the request could not performed because of an I/O
device error.) detected during read at offset 0x00000000b1e000 in file
'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
Please verify SQL Server is running and check your SQL Server registration
properties (by right cliking on the ABCD node) and try again.
---
This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
3). The MSSQL server service SQL Server Agent services are running under
local system. This is a Standalone machine.
Help is required on an urgent basis as this is a production server.
With Regards
MitulYou have a problem with the mdf file for your master database file. Possibly the file is locked by
some other process (like anti-virus). If that is the case, try again. If you are unlucky, the master
mdf file is corrupt for some reason, and you have to go the rebuildm.exe route.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mitul" <Mitul@.discussions.microsoft.com> wrote in message
news:46466B5B-D821-4C07-BD8C-8996EBAD7915@.microsoft.com...
> Hi:
> I am receiving the following error message while trying to open Enterprise
> Manager in MSSQL 2000 Server.
> ---
> A connection could not be established to ABCD
> Reason : I/O error 1117(the request could not performed because of an I/O
> device error.) detected during read at offset 0x00000000b1e000 in file
> 'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
> Please verify SQL Server is running and check your SQL Server registration
> properties (by right cliking on the ABCD node) and try again.
> ---
> This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
> 3). The MSSQL server service SQL Server Agent services are running under
> local system. This is a Standalone machine.
> Help is required on an urgent basis as this is a production server.
> With Regards
> Mitul

Cannot start Log Reader Agent and Snapshot Agent

I am testing peer to peer replication in our environment. I simulated a three node peer to peer topology and a local distributor.

For some wierd reason I cannot get the Log Reader Agent and snapshot agent to start. The domain account under which SQL Server Agent runs has administrator previlage on the box. I also use a domain account for SQL Server Service. (none of the passwords changed).

This is the error I am getting - "Executed as user: abc. A required privilege is not held by the client. The step failed"

Any ideas?

Also this domain account is a member of

SQLServer2005MSSQLUsers$ServerName$MSSQLSERVER

SQLServer2005MSAgentUser$ServerName$MSSQLSERVER

open the properties of each job and change the owner to sa and it should work fine.|||I tried it. No luck...it gives the same error message

Cannot start agent...

Hi there.
I am getting the following error when trying to start the Sqlserver agent
(on a version 7 db):
SQLServerAgent could not be started (reason: Unable to connect to server;
SQLServerAgent cannot start).
I have connect to the server using the NT windows authentication (which is
what is used to start the agent) and I connect 100%.
Does anyone have any ideas?
Any help will be appreciated.
Thanks
ClintThe SQL Server MUST be running and a domain controller must be available...
SQL Agent MUST also connect to SQL with a SQL login which has ADMINISTRATIVE
SQL privelege..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"Tiger Woods" <clintonn@.meb.co.za> wrote in message
news:3f2f5fa6$0$227@.hades.is.co.za...
> Hi there.
> I am getting the following error when trying to start the Sqlserver agent
> (on a version 7 db):
> SQLServerAgent could not be started (reason: Unable to connect to server;
> SQLServerAgent cannot start).
> I have connect to the server using the NT windows authentication (which is
> what is used to start the agent) and I connect 100%.
> Does anyone have any ideas?
> Any help will be appreciated.
> Thanks
> Clint
>|||Clint,
Here is a link to an article by Richard Waymire on 7.0 security
http://tinyurl.com/j24t . It discusses security issues related to SQL Agent
The following Troubleshooting guide for SS2000 may also be of interest:
http://tinyurl.com/j249
Russell Fields
"Tiger Woods" <clintonn@.meb.co.za> wrote in message
news:3f2f5fa6$0$227@.hades.is.co.za...
> Hi there.
> I am getting the following error when trying to start the Sqlserver agent
> (on a version 7 db):
> SQLServerAgent could not be started (reason: Unable to connect to server;
> SQLServerAgent cannot start).
> I have connect to the server using the NT windows authentication (which is
> what is used to start the agent) and I connect 100%.
> Does anyone have any ideas?
> Any help will be appreciated.
> Thanks
> Clint
>