Re: Not associated with a trusted SQL Server connection - Windows

Norman,

Thanks for ur inputs. I checked the user accounts on the SQL server and I
found the UserGroup account to which I belong does already exists on the
server(Builtin/Administrators group). I am trying to connect to sql server
using the logged in account(windows user account).

Hence not sure what else I am missing here.

Thanks in advance.
--Kris

"Norman Yuan" wrote:

> Using Windows authentication in SQL server DOES NOT mean that as long as you
> logged on to your computer then you can go into SQL Server. It only means
> that you do not need supply username/password pair when trying to access SQL
> Server, and SQL Server accept who you are as your user account claims.
>
> Important thing for many newbie ( no offence here) to know is security
> include authentication and authorization. Authentication only answers who
> you are. Authorization gives you proper access privilege base on who you
> are.
>
> In your case, when you try to access SQLServer with windows user account,
> SqlServer knows who you are. But you ( the user account) may still not have
> access right to go to a database. First you need to create SQLServer loggin
> that matches your Windows user account or a Windows user group which
> includes your user account. Then you need assign database access permission
> to this SQL Server loggin. After this, your Windows account then becomes
> trusted in the SQLServer.
>
> "Kris" <Kris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:8DD77E7C-AD07-4994-9DE2-FB13C579E5AC@xxxxxxxxxxxxxxxx
> > Val,
> >
> > Can u pl see this post. I have similar problem connecting to a SQL Server
> > which is configured as mixed mode authentication. So far I never came
> across
> > a situation like this but now I am happened to use mixed mode
> authentication
> > but to connect using windows authentication. The authentication is working
> > fine if I specify the username and password in the connection string but I
> > want to use windows authentication for connections to the server.
> >
> > Here is the connectionstring that I am using to connect to SQL server
> using
> > SQLClient provider.
> >
> > --------------------------------------------------------------------------
> ---------------
> > "Data Source=(local);Database=Northwind;Integrated Security=True;"
> > --------------------------------------------------------------------------
> ---------------
> >
> > Am I missing anything here?
> >
> > Thanks in advance.
> > --Kris
>
>
>
.

Relevant Pages

  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for ServerGuest
    ... I think it is not a limitation in Windows 2000. ... access SQL server on Win2000 server by using Windows authenctication if I ... | I have noticed that when I try to log in using Windows Authentication ...
    (microsoft.public.sqlserver.connect)