Re: old question about login, but no help from the existing thread
From: Mercury (me_at_spam.com)
Date: 06/08/05
- Next message: David Crone: "Application Role"
- Previous message: Mercury: "Re: Cannot generate SSPI context"
- In reply to: Sue Hoegemeier: "Re: old question about login, but no help from the existing thread"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 8 Jun 2005 23:48:30 +1200
As per Sue's comments: Try RunAs to start the program and supply the other
account credentails to the RunAs command prompt command.
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:vkrca15shfi507irrpra5vsej5q3tad2n7@4ax.com...
> When you specify a user name and password, you are telling
> SQL Server to log you in with a SQL Login. When you specify
> a trusted connection, you will be logged in using the
> windows credentials you used when logging on to the box you
> are currently logged into.
> If you want to log in under a different windows account, you
> need to log out and then log back into the PC with the
> account you want connecting to SQL Server.
>
> -Sue
>
> On Tue, 7 Jun 2005 20:08:01 -0700, "man-in-nature"
> <maninnature@discussions.microsoft.com> wrote:
>
>>Thanks for the input. But that is not what want to do. What I would like
>>to
>>have is that I have a few different windows accounts created on the same
>>xp
>>box, each account is used in a different connection scenario. For that, I
>>do
>>need to specify a different window account for different scenario when I
>>connect to the same sql instance.
>>
>>Thanks.
>>
>>"Alejandro Mesa" wrote:
>>
>>> > - Windows Authentication only
>>>
>>> osql -d adventureworks2000 -E
>>>
>>>
>>> AMB
>>>
>>> "man-in-nature" wrote:
>>>
>>> > osql -d adventureworks2000 -U admin -P admin
>>> >
>>> > Login failed for user 'admin'. Reason: Not associated with a trusted
>>> > SQL
>>> > Server connection.
>>> >
>>> > My system and configurations:
>>> >
>>> > - Winxp + sp2
>>> > - mssql developer edition + sp3a
>>> > - Windows Authentication only
>>> > - Local System Account is used to start the sql instance
>>> > - admin/admin is the administrator account to login to the xp box
>>> > - admin/admin was added to "SQL Server Group/[Machine
>>> > Name]/Security/Logins"
>>> > with the database access and all database role assigned to the
>>> > database in
>>> > question.
>>> > - admin/admin was added to "Databases/[database in question]/Users,
>>> > with
>>> > Permit in Database Role all checked.
>>> >
>>> > Am I missing anything?
>>> >
>>> > Thanks
>>> >
>
- Next message: David Crone: "Application Role"
- Previous message: Mercury: "Re: Cannot generate SSPI context"
- In reply to: Sue Hoegemeier: "Re: old question about login, but no help from the existing thread"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
