Re: Export and email query as a CSV

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: oj (nospam_ojngo_at_home.com)
Date: 02/06/05

Next message: MGFoster: "Re: MSDE and ODBC Tables"
Previous message: Vince: "Re: Help with SQL Query"
In reply to: celtic_kiwi: "Re: Export and email query as a CSV"
Messages sorted by: [ date ] [ thread ]

Date: Sat, 5 Feb 2005 19:31:56 -0800

System account does have full access to the local machine. However, it does
not have a profile.

A few thing to check:
1. Is your Sqlserver service startup account an NT account. If it's started
by LocalSystem, Sqlserver will not have access to network resources. You can
use Service mgr or Enterprise mgr to check.
2. Use the link I posted in previous post to set your proxy account.
Basically, if the user executes the stored procedure is not a SQL admin,
he/she will be impersonating the proxy account to access the system
resources.

-- 
-oj
"celtic_kiwi" <gavin.jolly@gmail.com> wrote in message 
news:1107648291.339211.234390@o13g2000cwo.googlegroups.com...
>I did some more searching and ran a trace, for the fist time ever. Here
> is the data in Tab separated format with quotes around values.  22 rows
> 11 columns.
> I noticed the procedure was running as SYSTEM rather than ADMIN. Could
> this be the cause?
>
> EventClass TextData DatabaseID TransactionID NTUserName NTDomainName 
> HostName ApplicationName LoginName Success IntegerData
> '11' 'exec
> dbo.pg_email_process' '7' '(null)' 'admin' 'GAVINLAPTOP' 'GAVINLAPTOP' 
> 'Advanced
> Query Tool V6' 'GAVINLAPTOP\admin' '(null)' '(null)'
> '42' 'exec
> dbo.pg_email_process' '7' '(null)' 'admin' 'GAVINLAPTOP' 'GAVINLAPTOP' 
> 'Advanced
> Query Tool V6' 'GAVINLAPTOP\admin' '(null)' '(null)'
> '14' '-- network protocol: LPC
> set quoted_identifier on
> set implicit_transactions off
> set cursor_close_on_commit off
> set ansi_warnings on
> set ansi_padding on
> set ansi_nulls on
> set concat_null_yields_null on' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '1' '4096'
> '12' ' set quoted_identifier off' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '11' 'declare @P1 int
> set @P1=-1
> exec sp_prepare @P1 output, NULL, N'Select top 10 EmployeeCode,
> WorkAreaCode, CommencementDate  from treetop..Appointment ', 1
> select @P1' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '10' 'declare @P1 int
> set @P1=1
> exec sp_prepare @P1 output, NULL, N'Select top 10 EmployeeCode,
> WorkAreaCode, CommencementDate  from treetop..Appointment ', 1
> select @P1' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '12' 'Select top 10 EmployeeCode, WorkAreaCode, CommencementDate  from
> treetop..Appointment' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '12' 'SELECT BCPCollationName(0x0904D00034, 167),
> BCPCollationName(0x0904D00034, 167)' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '12' 'Select top 10 EmployeeCode, WorkAreaCode, CommencementDate  from
> treetop..Appointment' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '11' 'exec sp_unprepare 1' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '10' 'exec sp_unprepare 1' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '15' '(null)' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '1' '(null)'
> '14' '-- network protocol: LPC
> set quoted_identifier on
> set implicit_transactions off
> set cursor_close_on_commit off
> set ansi_warnings on
> set ansi_padding on
> set ansi_nulls on
> set concat_null_yields_null on' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '1' '4096'
> '12' ' set quoted_identifier off' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '11' 'declare @P1 int
> set @P1=-1
> exec sp_prepare @P1 output, NULL, N'Select top 10 EmployeeCode,
> WorkAreaCode, CommencementDate  from treetop..Appointment ', 1
> select @P1' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '10' 'declare @P1 int
> set @P1=1
> exec sp_prepare @P1 output, NULL, N'Select top 10 EmployeeCode,
> WorkAreaCode, CommencementDate  from treetop..Appointment ', 1
> select @P1' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '12' 'Select top 10 EmployeeCode, WorkAreaCode, CommencementDate  from
> treetop..Appointment' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '12' 'SELECT BCPCollationName(0x0904D00034, 167),
> BCPCollationName(0x0904D00034, 167)' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '12' 'Select top 10 EmployeeCode, WorkAreaCode, CommencementDate  from
> treetop..Appointment' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '11' 'exec sp_unprepare 1' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '10' 'exec sp_unprepare 1' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '(null)' '(null)'
> '15' '(null)' '1' '(null)' 'SYSTEM' 'NT
> AUTHORITY' 'GAVINLAPTOP' 'Microsoft SQL Server' 'NT
> AUTHORITY\SYSTEM' '1' '(null)'
>
> All help much appreciated. TIA
>
> Gavin
>

Next message: MGFoster: "Re: MSDE and ODBC Tables"
Previous message: Vince: "Re: Help with SQL Query"
In reply to: celtic_kiwi: "Re: Export and email query as a CSV"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: what exec?
... reason the Exec seem to think that they have the upper hand. ... the Leadership provide Scouting for every member of the Group. ... Oddly, that may have arisen as a consequence of, for some reason, ... are both on cub account and regularly have to sign chqs together. ...
(uk.rec.scouting)
Re: Microsoft search service cannot be administered under this account
... Did you register your SQL Server using the SA account or windows ... Try Windows Authentication. ... exec sp_fulltext_table 'authors', 'Start_change_tracking' ...
(microsoft.public.sqlserver.fulltext)
RE: xp_sqlagent_proxy_account and post sp2
... Have you tried to reset the account with a different UID? ... Here is an example from SQL BOL: ... EXEC master.dbo.xp_sqlagent_proxy_account N'SET', ...
(microsoft.public.sqlserver.security)
Re: The Microsoft Search service cannot be administered under the pres
... the BUILTIN\Administrator account as well as a member of the Sysadmin role? ... SQL Server Full-Text Search Does Not Populate Catalogs ... you or your server's sysadmin have removed the ... exec sp_defaultdb N'NT Authority\System', N'master' ...
(microsoft.public.sqlserver.fulltext)
Re: Cant Administer
... The builtin\admin account is a member of the System Administrators roles ... Has anyone modified the SQL Server service account through the ... > exec sp_defaultdb N'NT Authority\System', ...
(microsoft.public.sqlserver.fulltext)