Can't remove user from role

I have a user in a database role that I cannot remove from the role.
If I go into the user's properties and deselect the role, click OK,
then go back in, the role is still checked.
I've tried to remove them via sp_droprolemember without success.
I am able to add and drop the user from other roles, though, and I'm
able to add/drop other users to the same role.
How do I drop them from the role?
Using: SQL Server 2005 Enterprise
What error message did you get when you tried to remove it from the role?
Linchi
"cbtechlists@.gmail.com" wrote:

> I have a user in a database role that I cannot remove from the role.
> If I go into the user's properties and deselect the role, click OK,
> then go back in, the role is still checked.
> I've tried to remove them via sp_droprolemember without success.
> I am able to add and drop the user from other roles, though, and I'm
> able to add/drop other users to the same role.
> How do I drop them from the role?
> Using: SQL Server 2005 Enterprise
>
|||Hi Linchi:
I don't get an error. It appears to work successfully. But when I look
at the user's roles again, it's still there.
On Feb 12, 12:03Xpm, Linchi Shea
<LinchiS...@.discussions.microsoft.com> wrote:
> What error message did you get when you tried to remove it from the role?
> Linchi
>
> "cbtechli...@.gmail.com" wrote:
>
>
> - Show quoted text -
|||How did you verify whether it's still there in the role? If you are using a
GUI tool, could this be a case of the GUI interface not being refreshed? I
know this may be too obvious, but...
Linchi
"cbtechlists@.gmail.com" wrote:

> Hi Linchi:
> I don't get an error. It appears to work successfully. But when I look
> at the user's roles again, it's still there.
>
> On Feb 12, 12:03 pm, Linchi Shea
> <LinchiS...@.discussions.microsoft.com> wrote:
>
|||If I use sp_helpuser 'theuser' I don't see the role listed.
If I open the properties of the user, the role is listed. I've
refreshed with the same results.
Weird
On Feb 12, 2:26Xpm, Linchi Shea <LinchiS...@.discussions.microsoft.com>
wrote:
> How did you verify whether it's still there in the role? If you are using a
> GUI tool, could this be a case of the GUI interface not being refreshed? I
> know this may be too obvious, but...
> Linchi
>
> "cbtechli...@.gmail.com" wrote:
>
>
>
>
>
> - Show quoted text -

Can't remove user from role

I have a user in a database role that I cannot remove from the role.
If I go into the user's properties and deselect the role, click OK,
then go back in, the role is still checked.
I've tried to remove them via sp_droprolemember without success.
I am able to add and drop the user from other roles, though, and I'm
able to add/drop other users to the same role.
How do I drop them from the role?
Using: SQL Server 2005 EnterpriseWhat error message did you get when you tried to remove it from the role?
Linchi
"cbtechlists@.gmail.com" wrote:
> I have a user in a database role that I cannot remove from the role.
> If I go into the user's properties and deselect the role, click OK,
> then go back in, the role is still checked.
> I've tried to remove them via sp_droprolemember without success.
> I am able to add and drop the user from other roles, though, and I'm
> able to add/drop other users to the same role.
> How do I drop them from the role?
> Using: SQL Server 2005 Enterprise
>|||Hi Linchi:
I don't get an error. It appears to work successfully. But when I look
at the user's roles again, it's still there.
On Feb 12, 12:03=A0pm, Linchi Shea
<LinchiS...@.discussions.microsoft.com> wrote:
> What error message did you get when you tried to remove it from the role?
> Linchi
>
> "cbtechli...@.gmail.com" wrote:
> > I have a user in a database role that I cannot remove from the role.
> > If I go into the user's properties and deselect the role, click OK,
> > then go back in, the role is still checked.
> > I've tried to remove them via sp_droprolemember without success.
> > I am able to add and drop the user from other roles, though, and I'm
> > able to add/drop other users to the same role.
> > How do I drop them from the role?
> > Using: SQL Server 2005 Enterprise- Hide quoted text -
> - Show quoted text -|||How did you verify whether it's still there in the role? If you are using a
GUI tool, could this be a case of the GUI interface not being refreshed? I
know this may be too obvious, but...
Linchi
"cbtechlists@.gmail.com" wrote:
> Hi Linchi:
> I don't get an error. It appears to work successfully. But when I look
> at the user's roles again, it's still there.
>
> On Feb 12, 12:03 pm, Linchi Shea
> <LinchiS...@.discussions.microsoft.com> wrote:
> > What error message did you get when you tried to remove it from the role?
> >
> > Linchi
> >
> >
> >
> > "cbtechli...@.gmail.com" wrote:
> > > I have a user in a database role that I cannot remove from the role.
> > > If I go into the user's properties and deselect the role, click OK,
> > > then go back in, the role is still checked.
> >
> > > I've tried to remove them via sp_droprolemember without success.
> >
> > > I am able to add and drop the user from other roles, though, and I'm
> > > able to add/drop other users to the same role.
> >
> > > How do I drop them from the role?
> >
> > > Using: SQL Server 2005 Enterprise- Hide quoted text -
> >
> > - Show quoted text -
>|||If I use sp_helpuser 'theuser' I don't see the role listed.
If I open the properties of the user, the role is listed. I've
refreshed with the same results.
Weird
On Feb 12, 2:26=A0pm, Linchi Shea <LinchiS...@.discussions.microsoft.com>
wrote:
> How did you verify whether it's still there in the role? If you are using =a
> GUI tool, could this be a case of the GUI interface not being refreshed? I=
> know this may be too obvious, but...
> Linchi
>
> "cbtechli...@.gmail.com" wrote:
> > Hi Linchi:
> > I don't get an error. It appears to work successfully. But when I look
> > at the user's roles again, it's still there.
> > On Feb 12, 12:03 pm, Linchi Shea
> > <LinchiS...@.discussions.microsoft.com> wrote:
> > > What error message did you get when you tried to remove it from the ro=le?
> > > Linchi
> > > "cbtechli...@.gmail.com" wrote:
> > > > I have a user in a database role that I cannot remove from the role.=
> > > > If I go into the user's properties and deselect the role, click OK,
> > > > then go back in, the role is still checked.
> > > > I've tried to remove them via sp_droprolemember without success.
> > > > I am able to add and drop the user from other roles, though, and I'm=
> > > > able to add/drop other users to the same role.
> > > > How do I drop them from the role?
> > > > Using: SQL Server 2005 Enterprise- Hide quoted text -
> > > - Show quoted text -- Hide quoted text -
> - Show quoted text -

Can't open reports with Intranet user

Hi,
I made some reports and I deployed them on my local report server. I want
someone in the Intranet to be able to view them. I did set up the role to
make the intranet group to be able to browse my reports. They can view the
list of the report when they access it from http://server/ReportServer But
they just can't view it when they click on a report. It says they don't have
permissions to open ReportViewer.aspx.
I wonder why it is the problem.Ok I found the problem. The file ReportViewer.aspx didn't gave the
authorization to my Intranet group.

Can't make database role a member of another database role in 2005.

In sql server 2000, I created some custom database roles called ProjectLeader and Developer. I would make these roles a member in the fixed database roles so that I would only have to add the user to the ProjectLeader or Developer role once and they would presto-magico have the security I wanted them to have with no unecessary mouse clicking. I'm not sure how to repeat this process in 2005? Management Studio doesn't seem to allow you to add a role as a member in another role. Is there a work around or solution for this?

You can always use T-SQL; see sp_addrolemember in Books Online. You can post on the Tools forum to see if there is a way to do this within the GUI.

Thanks
Laurentiu

Can't get SQL 2000 agent to run

Need urgent help. The sql 2000 agent service never runs. Tried to run under a
domain admin acct which belongs to SysAdmins role and still doesn't run. Ran
the sqlagent with -c -v switches from command line and got foll. 2 errors:
[298] sql server error 170, line 47: incorrect syntax near 'collate'.
[sqlstate 42000] (connisloginsysadmin)
[000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
but '(Unknown)' is not a member of the SysAdmin role
Tried the microsoft kb solns and still not running. Need this resolved
urgently. Pls help. Thks. We use sql 2000, sp4.
Hi
How about using Service Control Manager.
EXEC master..xp_servicecontrol 'QUERYSTATE', 'SQLSERVERAGENT'
"duchov" <duchov@.discussions.microsoft.com> wrote in message
news:588DF7E4-D96A-4BAD-A1A5-44636138EE54@.microsoft.com...
> Need urgent help. The sql 2000 agent service never runs. Tried to run
> under a
> domain admin acct which belongs to SysAdmins role and still doesn't run.
> Ran
> the sqlagent with -c -v switches from command line and got foll. 2 errors:
> [298] sql server error 170, line 47: incorrect syntax near 'collate'.
> [sqlstate 42000] (connisloginsysadmin)
> [000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
> but '(Unknown)' is not a member of the SysAdmin role
> Tried the microsoft kb solns and still not running. Need this resolved
> urgently. Pls help. Thks. We use sql 2000, sp4.
|||Hi
I don't see collate in any of the statements issued when SQL Agent is
stopped or started. You may want to profile the agent starting (including
errors and exception events) to see what is being processed.
Is there any other messages in the SQL Server logs?
Have you tried running this as the system account?
John
John
"duchov" wrote:

> Need urgent help. The sql 2000 agent service never runs. Tried to run under a
> domain admin acct which belongs to SysAdmins role and still doesn't run. Ran
> the sqlagent with -c -v switches from command line and got foll. 2 errors:
> [298] sql server error 170, line 47: incorrect syntax near 'collate'.
> [sqlstate 42000] (connisloginsysadmin)
> [000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
> but '(Unknown)' is not a member of the SysAdmin role
> Tried the microsoft kb solns and still not running. Need this resolved
> urgently. Pls help. Thks. We use sql 2000, sp4.
|||"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I don't see collate in any of the statements issued when SQL Agent is
> stopped or started. You may want to profile the agent starting (including
> errors and exception events) to see what is being processed.
> Is there any other messages in the SQL Server logs?
> Have you tried running this as the system account?
> John
> John
> "duchov" wrote:
|||Hi John/Uri
setting the agent acct from either EM or service ctrl mngr has same result.
Only other errors in the sql logs are:
1) Operating system error = 31(A device attached to the system is not
functioning.).
This error is in multiple logs though not the current log. Any ideas on this?
2) spid52 Error: 15457, Severity: 0, State: 1 (a sql support site said You
will see that 15457 error
popup if you pull up your SQL Server properties.)
3) Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement
to install..
Errors 2 & 3 are in today's log only and seems to be b/c checked the sql
server properties
Initially agent was under local sys acct n it never ran which is y tried a
domain admin acct but still no success
How do I profile the agent startup/shutdown? I ran a trace via sql profiler
(included errors/exceptions) and manually tried to start agent. the trace
showed 2 records under an application name of sqlAgent - initial boot probe
with no info really. is this what u meant?
Reason this is important is b/c I scheduled some nightly sql backups to disk
n they never run b/c the agent service never starts. Hope u can help.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I don't see collate in any of the statements issued when SQL Agent is
> stopped or started. You may want to profile the agent starting (including
> errors and exception events) to see what is being processed.
> Is there any other messages in the SQL Server logs?
> Have you tried running this as the system account?
> John
> John
> "duchov" wrote:
|||Hi
An Operating System Errors seems like the problem is external to SQL server,
is there anything in the System Event logs?
John
"duchov" <duchov@.discussions.microsoft.com> wrote in message
news:885311AD-1FAC-4745-9430-D1F1A573796E@.microsoft.com...[vbcol=seagreen]
> Hi John/Uri
> setting the agent acct from either EM or service ctrl mngr has same
> result.
> Only other errors in the sql logs are:
> 1) Operating system error = 31(A device attached to the system is not
> functioning.).
> This error is in multiple logs though not the current log. Any ideas on
> this?
> 2) spid52 Error: 15457, Severity: 0, State: 1 (a sql support site said You
> will see that 15457 error
> popup if you pull up your SQL Server properties.)
> 3) Configuration option 'show advanced options' changed from 1 to 1. Run
> the
> RECONFIGURE statement
> to install..
> Errors 2 & 3 are in today's log only and seems to be b/c checked the sql
> server properties
> Initially agent was under local sys acct n it never ran which is y tried a
> domain admin acct but still no success
> How do I profile the agent startup/shutdown? I ran a trace via sql
> profiler
> (included errors/exceptions) and manually tried to start agent. the trace
> showed 2 records under an application name of sqlAgent - initial boot
> probe
> with no info really. is this what u meant?
> Reason this is important is b/c I scheduled some nightly sql backups to
> disk
> n they never run b/c the agent service never starts. Hope u can help.
> "John Bell" wrote:

Can't get SQL 2000 agent to run

Need urgent help. The sql 2000 agent service never runs. Tried to run under
a
domain admin acct which belongs to SysAdmins role and still doesn't run. Ran
the sqlagent with -c -v switches from command line and got foll. 2 errors:
[298] sql server error 170, line 47: incorrect syntax near 'collate'.
[sqlstate 42000] (connisloginsysadmin)
[000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
but '(Unknown)' is not a member of the SysAdmin role
Tried the microsoft kb solns and still not running. Need this resolved
urgently. Pls help. Thks. We use sql 2000, sp4.Hi
How about using Service Control Manager.
EXEC master..xp_servicecontrol 'QUERYSTATE', 'SQLSERVERAGENT'
"duchov" <duchov@.discussions.microsoft.com> wrote in message
news:588DF7E4-D96A-4BAD-A1A5-44636138EE54@.microsoft.com...
> Need urgent help. The sql 2000 agent service never runs. Tried to run
> under a
> domain admin acct which belongs to SysAdmins role and still doesn't run.
> Ran
> the sqlagent with -c -v switches from command line and got foll. 2 errors:
> [298] sql server error 170, line 47: incorrect syntax near 'collate'.
> [sqlstate 42000] (connisloginsysadmin)
> [000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
> but '(Unknown)' is not a member of the SysAdmin role
> Tried the microsoft kb solns and still not running. Need this resolved
> urgently. Pls help. Thks. We use sql 2000, sp4.|||Hi
I don't see collate in any of the statements issued when SQL Agent is
stopped or started. You may want to profile the agent starting (including
errors and exception events) to see what is being processed.
Is there any other messages in the SQL Server logs?
Have you tried running this as the system account?
John
John
"duchov" wrote:

> Need urgent help. The sql 2000 agent service never runs. Tried to run unde
r a
> domain admin acct which belongs to SysAdmins role and still doesn't run. R
an
> the sqlagent with -c -v switches from command line and got foll. 2 errors:
> [298] sql server error 170, line 47: incorrect syntax near 'collate'.
> [sqlstate 42000] (connisloginsysadmin)
> [000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
> but '(Unknown)' is not a member of the SysAdmin role
> Tried the microsoft kb solns and still not running. Need this resolved
> urgently. Pls help. Thks. We use sql 2000, sp4.|||"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I don't see collate in any of the statements issued when SQL Agent is
> stopped or started. You may want to profile the agent starting (including
> errors and exception events) to see what is being processed.
> Is there any other messages in the SQL Server logs?
> Have you tried running this as the system account?
> John
> John
> "duchov" wrote:
>|||Hi John/Uri
setting the agent acct from either EM or service ctrl mngr has same result.
Only other errors in the sql logs are:
1) Operating system error = 31(A device attached to the system is not
functioning.).
This error is in multiple logs though not the current log. Any ideas on this
?
2) spid52 Error: 15457, Severity: 0, State: 1 (a sql support site said You
will see that 15457 error
popup if you pull up your SQL Server properties.)
3) Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement
to install..
Errors 2 & 3 are in today's log only and seems to be b/c checked the sql
server properties
Initially agent was under local sys acct n it never ran which is y tried a
domain admin acct but still no success
How do I profile the agent startup/shutdown? I ran a trace via sql profiler
(included errors/exceptions) and manually tried to start agent. the trace
showed 2 records under an application name of sqlAgent - initial boot probe
with no info really. is this what u meant?
Reason this is important is b/c I scheduled some nightly sql backups to disk
n they never run b/c the agent service never starts. Hope u can help.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I don't see collate in any of the statements issued when SQL Agent is
> stopped or started. You may want to profile the agent starting (including
> errors and exception events) to see what is being processed.
> Is there any other messages in the SQL Server logs?
> Have you tried running this as the system account?
> John
> John
> "duchov" wrote:
>|||Hi
An Operating System Errors seems like the problem is external to SQL server,
is there anything in the System Event logs?
John
"duchov" <duchov@.discussions.microsoft.com> wrote in message
news:885311AD-1FAC-4745-9430-D1F1A573796E@.microsoft.com...[vbcol=seagreen]
> Hi John/Uri
> setting the agent acct from either EM or service ctrl mngr has same
> result.
> Only other errors in the sql logs are:
> 1) Operating system error = 31(A device attached to the system is not
> functioning.).
> This error is in multiple logs though not the current log. Any ideas on
> this?
> 2) spid52 Error: 15457, Severity: 0, State: 1 (a sql support site said You
> will see that 15457 error
> popup if you pull up your SQL Server properties.)
> 3) Configuration option 'show advanced options' changed from 1 to 1. Run
> the
> RECONFIGURE statement
> to install..
> Errors 2 & 3 are in today's log only and seems to be b/c checked the sql
> server properties
> Initially agent was under local sys acct n it never ran which is y tried a
> domain admin acct but still no success
> How do I profile the agent startup/shutdown? I ran a trace via sql
> profiler
> (included errors/exceptions) and manually tried to start agent. the trace
> showed 2 records under an application name of sqlAgent - initial boot
> probe
> with no info really. is this what u meant?
> Reason this is important is b/c I scheduled some nightly sql backups to
> disk
> n they never run b/c the agent service never starts. Hope u can help.
> "John Bell" wrote:
>

Can't get SQL 2000 agent to run

Need urgent help. The sql 2000 agent service never runs. Tried to run under a
domain admin acct which belongs to SysAdmins role and still doesn't run. Ran
the sqlagent with -c -v switches from command line and got foll. 2 errors:
[298] sql server error 170, line 47: incorrect syntax near 'collate'.
[sqlstate 42000] (connisloginsysadmin)
[000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
but '(Unknown)' is not a member of the SysAdmin role
Tried the microsoft kb solns and still not running. Need this resolved
urgently. Pls help. Thks. We use sql 2000, sp4.Hi
How about using Service Control Manager.
EXEC master..xp_servicecontrol 'QUERYSTATE', 'SQLSERVERAGENT'
"duchov" <duchov@.discussions.microsoft.com> wrote in message
news:588DF7E4-D96A-4BAD-A1A5-44636138EE54@.microsoft.com...
> Need urgent help. The sql 2000 agent service never runs. Tried to run
> under a
> domain admin acct which belongs to SysAdmins role and still doesn't run.
> Ran
> the sqlagent with -c -v switches from command line and got foll. 2 errors:
> [298] sql server error 170, line 47: incorrect syntax near 'collate'.
> [sqlstate 42000] (connisloginsysadmin)
> [000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
> but '(Unknown)' is not a member of the SysAdmin role
> Tried the microsoft kb solns and still not running. Need this resolved
> urgently. Pls help. Thks. We use sql 2000, sp4.|||Hi
I don't see collate in any of the statements issued when SQL Agent is
stopped or started. You may want to profile the agent starting (including
errors and exception events) to see what is being processed.
Is there any other messages in the SQL Server logs?
Have you tried running this as the system account?
John
John
"duchov" wrote:
> Need urgent help. The sql 2000 agent service never runs. Tried to run under a
> domain admin acct which belongs to SysAdmins role and still doesn't run. Ran
> the sqlagent with -c -v switches from command line and got foll. 2 errors:
> [298] sql server error 170, line 47: incorrect syntax near 'collate'.
> [sqlstate 42000] (connisloginsysadmin)
> [000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
> but '(Unknown)' is not a member of the SysAdmin role
> Tried the microsoft kb solns and still not running. Need this resolved
> urgently. Pls help. Thks. We use sql 2000, sp4.|||"John Bell" wrote:
> Hi
> I don't see collate in any of the statements issued when SQL Agent is
> stopped or started. You may want to profile the agent starting (including
> errors and exception events) to see what is being processed.
> Is there any other messages in the SQL Server logs?
> Have you tried running this as the system account?
> John
> John
> "duchov" wrote:
> > Need urgent help. The sql 2000 agent service never runs. Tried to run under a
> > domain admin acct which belongs to SysAdmins role and still doesn't run. Ran
> > the sqlagent with -c -v switches from command line and got foll. 2 errors:
> >
> > [298] sql server error 170, line 47: incorrect syntax near 'collate'.
> >
> > [sqlstate 42000] (connisloginsysadmin)
> >
> > [000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
> >
> > but '(Unknown)' is not a member of the SysAdmin role
> > Tried the microsoft kb solns and still not running. Need this resolved
> > urgently. Pls help. Thks. We use sql 2000, sp4.|||Hi John/Uri
setting the agent acct from either EM or service ctrl mngr has same result.
Only other errors in the sql logs are:
1) Operating system error = 31(A device attached to the system is not
functioning.).
This error is in multiple logs though not the current log. Any ideas on this?
2) spid52 Error: 15457, Severity: 0, State: 1 (a sql support site said You
will see that 15457 error
popup if you pull up your SQL Server properties.)
3) Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement
to install..
Errors 2 & 3 are in today's log only and seems to be b/c checked the sql
server properties
Initially agent was under local sys acct n it never ran which is y tried a
domain admin acct but still no success
How do I profile the agent startup/shutdown? I ran a trace via sql profiler
(included errors/exceptions) and manually tried to start agent. the trace
showed 2 records under an application name of sqlAgent - initial boot probe
with no info really. is this what u meant?
Reason this is important is b/c I scheduled some nightly sql backups to disk
n they never run b/c the agent service never starts. Hope u can help.
"John Bell" wrote:
> Hi
> I don't see collate in any of the statements issued when SQL Agent is
> stopped or started. You may want to profile the agent starting (including
> errors and exception events) to see what is being processed.
> Is there any other messages in the SQL Server logs?
> Have you tried running this as the system account?
> John
> John
> "duchov" wrote:
> > Need urgent help. The sql 2000 agent service never runs. Tried to run under a
> > domain admin acct which belongs to SysAdmins role and still doesn't run. Ran
> > the sqlagent with -c -v switches from command line and got foll. 2 errors:
> >
> > [298] sql server error 170, line 47: incorrect syntax near 'collate'.
> >
> > [sqlstate 42000] (connisloginsysadmin)
> >
> > [000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
> >
> > but '(Unknown)' is not a member of the SysAdmin role
> > Tried the microsoft kb solns and still not running. Need this resolved
> > urgently. Pls help. Thks. We use sql 2000, sp4.|||Hi
An Operating System Errors seems like the problem is external to SQL server,
is there anything in the System Event logs?
John
"duchov" <duchov@.discussions.microsoft.com> wrote in message
news:885311AD-1FAC-4745-9430-D1F1A573796E@.microsoft.com...
> Hi John/Uri
> setting the agent acct from either EM or service ctrl mngr has same
> result.
> Only other errors in the sql logs are:
> 1) Operating system error = 31(A device attached to the system is not
> functioning.).
> This error is in multiple logs though not the current log. Any ideas on
> this?
> 2) spid52 Error: 15457, Severity: 0, State: 1 (a sql support site said You
> will see that 15457 error
> popup if you pull up your SQL Server properties.)
> 3) Configuration option 'show advanced options' changed from 1 to 1. Run
> the
> RECONFIGURE statement
> to install..
> Errors 2 & 3 are in today's log only and seems to be b/c checked the sql
> server properties
> Initially agent was under local sys acct n it never ran which is y tried a
> domain admin acct but still no success
> How do I profile the agent startup/shutdown? I ran a trace via sql
> profiler
> (included errors/exceptions) and manually tried to start agent. the trace
> showed 2 records under an application name of sqlAgent - initial boot
> probe
> with no info really. is this what u meant?
> Reason this is important is b/c I scheduled some nightly sql backups to
> disk
> n they never run b/c the agent service never starts. Hope u can help.
> "John Bell" wrote:
>> Hi
>> I don't see collate in any of the statements issued when SQL Agent is
>> stopped or started. You may want to profile the agent starting (including
>> errors and exception events) to see what is being processed.
>> Is there any other messages in the SQL Server logs?
>> Have you tried running this as the system account?
>> John
>> John
>> "duchov" wrote:
>> > Need urgent help. The sql 2000 agent service never runs. Tried to run
>> > under a
>> > domain admin acct which belongs to SysAdmins role and still doesn't
>> > run. Ran
>> > the sqlagent with -c -v switches from command line and got foll. 2
>> > errors:
>> >
>> > [298] sql server error 170, line 47: incorrect syntax near 'collate'.
>> >
>> > [sqlstate 42000] (connisloginsysadmin)
>> >
>> > [000] SQLServerAgent must be able to connect to SQLServer as SysAdmin,
>> >
>> > but '(Unknown)' is not a member of the SysAdmin role
>> > Tried the microsoft kb solns and still not running. Need this resolved
>> > urgently. Pls help. Thks. We use sql 2000, sp4.