sp_addlogin in sql server 6.5 not as sa
From: MANDAR VENGURLEKAR (mvengurl@hotmail.com)
Date: 09/17/02
- Next message: Lan Lewis-Bevan [MS]: "RE: ?? unable to access SQL Server w/ sa account unless user is Administrator on local machine"
- Previous message: SQL Apprentice: "How to setup a user to create and administer JOBS"
- Next in thread: Russell Fields: "Re: sp_addlogin in sql server 6.5 not as sa"
- Reply: Russell Fields: "Re: sp_addlogin in sql server 6.5 not as sa"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: MANDAR VENGURLEKAR <mvengurl@hotmail.com> Date: Tue, 17 Sep 2002 12:28:30 -0700
Hi,
sp_addlogin can be run only as sa is what is documented.
I need to grant a user privileges to issue this command and be able to
execute this sp.
We are using sql server 6.5 on NT4 with sp6.The sql server uses mixed
security and the default userid is "guest" from the domain
"company_domain".
Please let me know how this can be done.
Thanks in advance
Mandar
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
- Next message: Lan Lewis-Bevan [MS]: "RE: ?? unable to access SQL Server w/ sa account unless user is Administrator on local machine"
- Previous message: SQL Apprentice: "How to setup a user to create and administer JOBS"
- Next in thread: Russell Fields: "Re: sp_addlogin in sql server 6.5 not as sa"
- Reply: Russell Fields: "Re: sp_addlogin in sql server 6.5 not as sa"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
