Saturday, February 25, 2012

Can anyone Help me ?

Hi all,
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
samLet me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doamin
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able to
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> > Hi all,
> >
> > I am very new to SQL Server 2000
> > my problem is that to connect to sql server from a client computer
> > first i have to log in to the system in which the sql server is
> > installed
> > is it possible that i dont have to login to the computer
> > so that i just open the query analyzer and just login with the sql
> > server user account i dont want to give the login & the password of the
> > windows
> >
> >
> > can any one help me in this
> > is this possible
> >
> > sam
> >

No comments:

Post a Comment