February 28, 2002 at 8:41 am
Hi All,
The utility scptxfr.exe used to create the structure. The utility doesn't have the /U switch. Can any other user other than the sa can use this utility?
Any thoughts on this will help!
Thanks!
February 28, 2002 at 10:26 am
I believe you need to be a sys admin, but it might work for a db owner. You need to use integrated security (Windows Auth) if you want someone other than sa to run it.
Steve Jones
February 28, 2002 at 12:07 pm
hI Steve,
I am not an expert with window NT adminstration. Can you guide me on how I should go about doing the integrated security?
February 28, 2002 at 12:26 pm
Which version of SQL? I believe with v7 and 2k, this is always present. So when you add a login, you choose an NT login rather than a SQL login and the users' network password is used. Then the scptxfr utility has a /I option that will use the person's network credentials to conncet.
Once you choose an NT login, then the user mapping to a db is the same as any other login.
Steve Jones
February 28, 2002 at 12:48 pm
THANKS STEVE THE CLIENT IS TRYING NOW. HOPE IT WORKS!
February 28, 2002 at 1:40 pm
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply