Hi,
Looking for a proper way to change a SQL login ( not a domain user ) from
DBO to SA ( and back if a curtain action has finished ) using TSQL.
This user is NOT connected to any role therefor sp_droprolemember/
sp_addrolemember is not appropriate.
Can you help me out guys?
G Kramerwould SETUSER or EXECUTE AS do?
Peter
Showing posts with label proper. Show all posts
Showing posts with label proper. Show all posts
Thursday, March 22, 2012
Wednesday, March 7, 2012
Change the domain setting for the MS SQL 2000 Server
Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
James
To add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>
|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights[vbcol=seagreen]
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in
>
>.
>
|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
James
To add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>
|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights[vbcol=seagreen]
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in
>
>.
>
|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in
Change the domain setting for the MS SQL 2000 Server
Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesHello,
If you bring up "Services" on your Server machine and have
a look for the SQL Server service, you can change the
account though there.
Remember to stop and start it after you have finished.
Peter
"Choose a job you love, and you will never have to work a
day in your life. "
Confucius
>--Original Message--
>Hallo,
>During the installation I have to choose the proper
service accounts. On a
>form that appears, I can set the service setting to use
local system account
>or to use a domain user account.
>I would like to use the domain user account to allow
other apllication to
>query the SQL server. But latter on I would like to
change the domain.
>Where to change the domain setting before put the the SQL
srver machine in
>another domain?
>Thanks in advance
>James
>.
>|||To add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
>> Hallo,
>> During the installation I have to choose the proper
service accounts. On a
>> form that appears, I can set the service setting to use
local system
>account
>> or to use a domain user account.
>> I would like to use the domain user account to allow
other apllication to
>> query the SQL server. But latter on I would like to
change the domain.
>> Where to change the domain setting before put the the
SQL srver machine in
>> another domain?
>> Thanks in advance
>> James
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> >--Original Message--
> >To add to Peter's response, you can also change the
> service account using
> >Enterprise Manager. This will assign the account the
> advanced user rights
> >needed.
> >
> >--
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >"James" <James@.discussions.microsoft.com> wrote in message
> >news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> >> Hallo,
> >>
> >> During the installation I have to choose the proper
> service accounts. On a
> >> form that appears, I can set the service setting to use
> local system
> >account
> >> or to use a domain user account.
> >> I would like to use the domain user account to allow
> other apllication to
> >> query the SQL server. But latter on I would like to
> change the domain.
> >> Where to change the domain setting before put the the
> SQL srver machine in
> >> another domain?
> >>
> >> Thanks in advance
> >>
> >> James
> >>
> >
> >
> >.
> >
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesHello,
If you bring up "Services" on your Server machine and have
a look for the SQL Server service, you can change the
account though there.
Remember to stop and start it after you have finished.
Peter
"Choose a job you love, and you will never have to work a
day in your life. "
Confucius
>--Original Message--
>Hallo,
>During the installation I have to choose the proper
service accounts. On a
>form that appears, I can set the service setting to use
local system account
>or to use a domain user account.
>I would like to use the domain user account to allow
other apllication to
>query the SQL server. But latter on I would like to
change the domain.
>Where to change the domain setting before put the the SQL
srver machine in
>another domain?
>Thanks in advance
>James
>.
>|||To add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
>> Hallo,
>> During the installation I have to choose the proper
service accounts. On a
>> form that appears, I can set the service setting to use
local system
>account
>> or to use a domain user account.
>> I would like to use the domain user account to allow
other apllication to
>> query the SQL server. But latter on I would like to
change the domain.
>> Where to change the domain setting before put the the
SQL srver machine in
>> another domain?
>> Thanks in advance
>> James
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> >--Original Message--
> >To add to Peter's response, you can also change the
> service account using
> >Enterprise Manager. This will assign the account the
> advanced user rights
> >needed.
> >
> >--
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >"James" <James@.discussions.microsoft.com> wrote in message
> >news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> >> Hallo,
> >>
> >> During the installation I have to choose the proper
> service accounts. On a
> >> form that appears, I can set the service setting to use
> local system
> >account
> >> or to use a domain user account.
> >> I would like to use the domain user account to allow
> other apllication to
> >> query the SQL server. But latter on I would like to
> change the domain.
> >> Where to change the domain setting before put the the
> SQL srver machine in
> >> another domain?
> >>
> >> Thanks in advance
> >>
> >> James
> >>
> >
> >
> >.
> >
Change the domain setting for the MS SQL 2000 Server
Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesTo add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in[vbcol=seagreen]
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesTo add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in[vbcol=seagreen]
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in
Subscribe to:
Posts (Atom)