remove guest user in msdb

In according of what I have found on various document I removed to user 'guest' from the msdb database. But now the SQL_Server_Agent don't start.
I run this service from a normal user NT account. In the log error of SQL_Server_agent i found this items:
1) [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2) [298] SQLServer Error: 4060, Impossibile aprire il database richiesto nell'account di accesso 'msdb'. L'accesso avrX esito negativo. [SQLSTATE 42000]
The only solution I have found is to add the NT account to the sysadmin role but I don't want to do this!
Anyone can help me ?
I run SQL 2K SP3 on WIN2K Server SP4
Thanks
The login that SQL Agent uses MUST be a SQL Server Admin account or the
agent will not start.
So first do that.
Then if it still does not start, add the login as a valid user to the MSDB
database, then see.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Roberto Pasqualini" <Roberto Pasqualini@.discussions.microsoft.com> wrote in
message news:7206619A-0EB0-480C-84C0-9E99C2BF4751@.microsoft.com...
> In according of what I have found on various document I removed to user
'guest' from the msdb database. But now the SQL_Server_Agent don't start.
> I run this service from a normal user NT account. In the log error of
SQL_Server_agent i found this items:
> 1) [000] Unable to connect to server '(local)'; SQLServerAgent cannot
start
> 2) [298] SQLServer Error: 4060, Impossibile aprire il database richiesto
nell'account di accesso 'msdb'. L'accesso avr esito negativo. [SQLSTATE
42000]
> The only solution I have found is to add the NT account to the sysadmin
role but I don't want to do this!
> Anyone can help me ?
> I run SQL 2K SP3 on WIN2K Server SP4
> Thanks
|||Many thanks for your promplty response.
I haven't understand this.
So I have another question: in your your opinion while is the best security choice ?
1) Start the SQL_SERVER_AGENT with an NT administrator account, that have sysamind role
2) Assing the sysadmin role to an NT normal user account and use this to start the SQL_SERVER_AGENT.
The Microsoft security baseline analizer suggest that no have more than 2 sysadmin user.
Thanks
"Wayne Snyder" wrote:

> The login that SQL Agent uses MUST be a SQL Server Admin account or the
> agent will not start.
> So first do that.
> Then if it still does not start, add the login as a valid user to the MSDB
> database, then see.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Roberto Pasqualini" <Roberto Pasqualini@.discussions.microsoft.com> wrote in
> message news:7206619A-0EB0-480C-84C0-9E99C2BF4751@.microsoft.com...
> 'guest' from the msdb database. But now the SQL_Server_Agent don't start.
> SQL_Server_agent i found this items:
> start
> nell'account di accesso 'msdb'. L'accesso avrX esito negativo. [SQLSTATE
> 42000]
> role but I don't want to do this!
>
>

remove guest user in msdb

In according of what I have found on various document I removed to user 'gue
st' from the msdb database. But now the SQL_Server_Agent don't start.
I run this service from a normal user NT account. In the log error of SQL_Se
rver_agent i found this items:
1) [000] Unable to connect to server '(local)'; SQLServerAgent cannot st
art
2) [298] SQLServer Error: 4060, Impossibile aprire il database richiesto
nell'account di accesso 'msdb'. L'accesso avr_ esito negativo. [SQLSTA
TE 42000]
The only solution I have found is to add the NT account to the sysadmin role
but I don't want to do this!
Anyone can help me ?
I run SQL 2K SP3 on WIN2K Server SP4
ThanksThe login that SQL Agent uses MUST be a SQL Server Admin account or the
agent will not start.
So first do that.
Then if it still does not start, add the login as a valid user to the MSDB
database, then see.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Roberto Pasqualini" <Roberto Pasqualini@.discussions.microsoft.com> wrote in
message news:7206619A-0EB0-480C-84C0-9E99C2BF4751@.microsoft.com...
> In according of what I have found on various document I removed to user
'guest' from the msdb database. But now the SQL_Server_Agent don't start.
> I run this service from a normal user NT account. In the log error of
SQL_Server_agent i found this items:
> 1) [000] Unable to connect to server '(local)'; SQLServerAgent cannot
start
> 2) [298] SQLServer Error: 4060, Impossibile aprire il database richiesto[/vbco
l]
nell'account di accesso 'msdb'. L'accesso avr esito negativo. [SQLSTATE
42000][vbcol=seagreen]
> The only solution I have found is to add the NT account to the sysadmin
role but I don't want to do this!
> Anyone can help me ?
> I run SQL 2K SP3 on WIN2K Server SP4
> Thanks|||Many thanks for your promplty response.
I haven't understand this.
So I have another question: in your your opinion while is the best security
choice ?
1) Start the SQL_SERVER_AGENT with an NT administrator account, that have sy
samind role
2) Assing the sysadmin role to an NT normal user account and use this to sta
rt the SQL_SERVER_AGENT.
The Microsoft security baseline analizer suggest that no have more than 2 sy
sadmin user.
Thanks
"Wayne Snyder" wrote:

> The login that SQL Agent uses MUST be a SQL Server Admin account or the
> agent will not start.
> So first do that.
> Then if it still does not start, add the login as a valid user to the MSDB
> database, then see.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Roberto Pasqualini" <Roberto Pasqualini@.discussions.microsoft.com> wrote
in
> message news:7206619A-0EB0-480C-84C0-9E99C2BF4751@.microsoft.com...
> 'guest' from the msdb database. But now the SQL_Server_Agent don't start.
> SQL_Server_agent i found this items:
> start
> nell'account di accesso 'msdb'. L'accesso avr_ esito negativo. [SQLST
ATE
> 42000]
> role but I don't want to do this!
>
>

Remote XML transfer

hello there,
I currently have a vb client application that outputs details to a well
formed xml document.
my question is, how can i send this information (automated) to my sql server
2005 ?
Im able to load the xml document locally, into a xml datatype and retrive it
fine, however the need is to complete this from a cleint machine across a
network.
I have looked for many examples but none seem to fit what im after.
any one help ?
regards
russ.
If you are using VB.NET then you can use ADO.NET to either insert the xml
into a table or pass the xml as a parameter to a stored procedure.
For an example of how this can be done in ADO.NET 2.0 see:
http://msdn.microsoft.com/data/DataA...sqlxml_ado.asp
Regards,
Galex Yen
"grumpy" wrote:

> hello there,
> I currently have a vb client application that outputs details to a well
> formed xml document.
> my question is, how can i send this information (automated) to my sql server
> 2005 ?
> Im able to load the xml document locally, into a xml datatype and retrive it
> fine, however the need is to complete this from a cleint machine across a
> network.
> I have looked for many examples but none seem to fit what im after.
> any one help ?
> regards
> russ.
>
>
>

Remote XML transfer

hello there,
I currently have a vb client application that outputs details to a well
formed xml document.
my question is, how can i send this information (automated) to my sql server
2005 ?
Im able to load the xml document locally, into a xml datatype and retrive it
fine, however the need is to complete this from a cleint machine across a
network.
I have looked for many examples but none seem to fit what im after.
any one help ?
regards
russ.If you are using VB.NET then you can use ADO.NET to either insert the xml
into a table or pass the xml as a parameter to a stored procedure.
For an example of how this can be done in ADO.NET 2.0 see:
http://msdn.microsoft.com/data/Data.../sqlxml_ado.asp
Regards,
Galex Yen
"grumpy" wrote:

> hello there,
> I currently have a vb client application that outputs details to a well
> formed xml document.
> my question is, how can i send this information (automated) to my sql serv
er
> 2005 ?
> Im able to load the xml document locally, into a xml datatype and retrive
it
> fine, however the need is to complete this from a cleint machine across a
> network.
> I have looked for many examples but none seem to fit what im after.
> any one help ?
> regards
> russ.
>
>
>