Login problem

Hi, I'm having a problem connecting to my SQL2005 database, and I'm
wondering if it's even possible to do what I'm trying to do. I have a
domain user set up as the dbo of a database (domain\myuser). Through
the SQL Server Management Studio, I want to connect to the database as
that user, but I am logged into my computer as me (domain\me). So
when I open up the SQL Server Management Studio, when I select use
Windows Authentication, it fills in my username, and I cannot change
it because it's greyed out. Is it possible for me to somehow
authenticate to the server as domain\myuser instead?
Thanks
Dylan
Since you use Windows Authentication, meaning, whoever logged in the
computer, SQL Server sees it as authenticated. So, when you log into your
computer with an account that does not have access to the SQL
Server/database, then you cannot get in. If you have given the account
Domain\MyUser access to the SQL Server/database, then you need to log into
the computer as Domain\MyUser. That is how Windows Authentication works.
"dylan" <dylan.roehrig@.gmail.com> wrote in message
news:1181224874.713354.288520@.g4g2000hsf.googlegro ups.com...
> Hi, I'm having a problem connecting to my SQL2005 database, and I'm
> wondering if it's even possible to do what I'm trying to do. I have a
> domain user set up as the dbo of a database (domain\myuser). Through
> the SQL Server Management Studio, I want to connect to the database as
> that user, but I am logged into my computer as me (domain\me). So
> when I open up the SQL Server Management Studio, when I select use
> Windows Authentication, it fills in my username, and I cannot change
> it because it's greyed out. Is it possible for me to somehow
> authenticate to the server as domain\myuser instead?
> Thanks
> Dylan
>
|||Or, to phrase it differently:
The functionality is found in Windows and called "Run As". :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Norman Yuan" <NotReal@.NotReal.not> wrote in message news:eLKjuQRqHHA.1296@.TK2MSFTNGP06.phx.gbl...
> Since you use Windows Authentication, meaning, whoever logged in the
> computer, SQL Server sees it as authenticated. So, when you log into your
> computer with an account that does not have access to the SQL
> Server/database, then you cannot get in. If you have given the account
> Domain\MyUser access to the SQL Server/database, then you need to log into
> the computer as Domain\MyUser. That is how Windows Authentication works.
> "dylan" <dylan.roehrig@.gmail.com> wrote in message
> news:1181224874.713354.288520@.g4g2000hsf.googlegro ups.com...
>
|||On Jun 7, 12:24 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> Or, to phrase it differently:
> The functionality is found in Windows and called "Run As". :-)
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Norman Yuan" <NotR...@.NotReal.not> wrote in messagenews:eLKjuQRqHHA.1296@.TK2MSFTNGP06.phx.gbl. ..
>
Thanks, yeah, I was basically wondering if that was the only way to do
it. thanks.