Re: Security

From: mat (mat_at_discussions.microsoft.com)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 05:37:05 -0800

I am, the agents login is and i have changed the SQL login that the
connection to the other server uses to sysadmin.

So basicly, all logins used are sysadmin

i have even tried to get it to work by giving the SQL Agents login sysadmin
rights on the other server and not even this works

i am completly stuck.....

"Uri Dimant" wrote:

> mat
> Are you member of SysAdmin Server Role?
>
>
> "mat" <mat@discussions.microsoft.com> wrote in message
> news:D93B7A67-FDE5-49CC-919E-33BEE08A3ECD@microsoft.com...
> > Thanks
> > The connection within the package uses a SQL login for the SQL server it
> > connects to, so even though it is executing using the agent, so using the
> > agents permissions, i presumed that the actual connection will be made
> using
> > the defined login.
> >
> > is this true?
> >
> > "Uri Dimant" wrote:
> >
> > > mat
> > > When you execute the DTS by clicking on the package it is running
> under
> > > permissions that defined on your workstation (local account probably) ,
> as
> > > opposite when it runs with a job ,it should be run under SQL Server
> Agent
> > > account (It should be most likely a domain account)
> > >
> > >
> > >
> > > "mat" <mat@discussions.microsoft.com> wrote in message
> > > news:5520F76E-AE6E-4B14-AE67-2CCBBC4179DC@microsoft.com...
> > > > I have a dts package that transfers data from one sql server to
> another.
> > > it
> > > > uses a SQL login to connect to the second server. When the DTS package
> is
> > > > executed it runs fine but if it is executed from a job or using the
> dtsrun
> > > > utility it always fails
> > > >
> > > > Can anyone help?
> > >
> > >
> > >
>
>
>

Relevant Pages

  • Re: GRANT CREATE DATABASE versus GRANT ALTER ANY LOGIN
    ... server, and is a member of the sysadmin server role. ... could not grant "alter any login" permission to a domain login. ... server or it has been removed "sysadmin" server role. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 Express setup
    ... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server ... Mark the "sysadmin" checkbox to make this Login a member of this Server ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Profiler wont allow a developer to login
    ... I can login to Profiler he get an Invalid ... whether they are sysadmin. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Domain user in SysAdmin Role (SQL Server on Windows Vista)
    ... you might also need to add the login before adding the login to the sysadmin server role: ... Following this instructions I try solve the authenticate problem in Windows Vista for SQL Server 2005: ... In my case the user account to add in sysadmin role is under a domain. ...
    (microsoft.public.sqlserver.security)
  • gdm hangs
    ... gdm will hang 9 of 10 times when logging out. ... with or without the client having been connected to the Server. ... # Timed login, useful for kiosks. ... Must output the chosen host on stdout, ...
    (Debian-User)