Changing Agent User

I have to change the Sql Server 7 startup account from LocalSystem to a
domain account. This domain account has the same permissions that SA does.
As long as the new domain account has the same set of permissions, there
should be no problem with executing jobs, accessing objects, etc.? Can
anyone recommend a reference/article on the implications behind changing the
user?
Thank youSearch Books Online for "level token" and you'll find the attributed you need to give the new
service account. If you change the account using EM, these permissions will be set by EM.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Ick" <nospamplease> wrote in message news:%23bEf7r4gDHA.2248@.TK2MSFTNGP09.phx.gbl...
> I have to change the Sql Server 7 startup account from LocalSystem to a
> domain account. This domain account has the same permissions that SA does.
> As long as the new domain account has the same set of permissions, there
> should be no problem with executing jobs, accessing objects, etc.? Can
> anyone recommend a reference/article on the implications behind changing the
> user?
> Thank you
>|||Thank you Tibor. This is very helpful (although I would never have thought
to search under that phrase lol - I guess that is why you are the MVP and I
am the lowly n00b)
;-)
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:OdHNz2AhDHA.2296@.TK2MSFTNGP09.phx.gbl...
> Search Books Online for "level token" and you'll find the attributed you
need to give the new
> service account. If you change the account using EM, these permissions
will be set by EM.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "Ick" <nospamplease> wrote in message
news:%23bEf7r4gDHA.2248@.TK2MSFTNGP09.phx.gbl...
> > I have to change the Sql Server 7 startup account from LocalSystem to a
> > domain account. This domain account has the same permissions that SA
does.
> >
> > As long as the new domain account has the same set of permissions, there
> > should be no problem with executing jobs, accessing objects, etc.? Can
> > anyone recommend a reference/article on the implications behind changing
the
> > user?
> >
> > Thank you
> >
> >
>|||I'm glad it helped. Reason I remember this is from me training, wanting to have as few characters to
write on the whiteboard. I.e., all about being lazy :-).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Ick" <nospamplease> wrote in message news:eczFhMChDHA.4468@.TK2MSFTNGP12.phx.gbl...
> Thank you Tibor. This is very helpful (although I would never have thought
> to search under that phrase lol - I guess that is why you are the MVP and I
> am the lowly n00b)
> ;-)
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:OdHNz2AhDHA.2296@.TK2MSFTNGP09.phx.gbl...
> > Search Books Online for "level token" and you'll find the attributed you
> need to give the new
> > service account. If you change the account using EM, these permissions
> will be set by EM.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> > "Ick" <nospamplease> wrote in message
> news:%23bEf7r4gDHA.2248@.TK2MSFTNGP09.phx.gbl...
> > > I have to change the Sql Server 7 startup account from LocalSystem to a
> > > domain account. This domain account has the same permissions that SA
> does.
> > >
> > > As long as the new domain account has the same set of permissions, there
> > > should be no problem with executing jobs, accessing objects, etc.? Can
> > > anyone recommend a reference/article on the implications behind changing
> the
> > > user?
> > >
> > > Thank you
> > >
> > >
> >
> >
>

change pwd disconnects remote server

Hello,
I have sql personal server installed on my xp machine and have registered a
remote server called pccm-nt. I have login permissions to the server and I'm
a database user for all of the databases.
I connect to the remote sql server with my windows domain account username a
nd password. When I change my pwd I can no longer connect to the remote serv
er, pccm-nt, I usually have to remove the server and re-register it. Would s
omeone be able to tell me w
hy changing my domain password is causing this conflict?
Thanks,
ChiekoYour security token is now invalid. Logout of the domain and log back in ag
ain.|||Okay,
I'll try that but I think that I did log off and log on again.
Thanks for the help,
Chieko

Change of Ownership??

I am having a problem with object ownership.
The person who setup the SQL Server setup the "dbo" account with his personal permissions. I need to change "dbo" so that the login name is the system account and not a personal account. Is this possible?

If this is not possible can I change the ownership of a system object?
I was able to change ownershipof user objects using the "sp_changeobjectowner" stored procedure, but it did not seem to work for system objects.

Any way around this?

- Ericdid you try sp_changedbowner? This would change the database ownership which I believe should change the system object ownership?>?|||The dbo user is so tightly "hardwired" into the database that I'd give the user a new login, change the ownership of their tables to that new user, and stop right there. I wouldn't even consider allowing the user to keep using dbo.

-PatP