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

Do you mean the user account you are using is in local Administrators group?
Do you log in using local user account or a domain user account (when you
connected to a network)? Just to verify, create a login in SQL Server for
your local user account in format of "MachineName\UserAccount", and then log
onto your Windows with this account and try to connect to SQL Server.

"Kris" <Kris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A93DA0A9-F7DA-4C9D-9E95-F74364E3F83F@xxxxxxxxxxxxxxxx
> 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: Machine Authentication not working with wireless clients and IAS
    ... Windows XP SP2 PC connecting to a wireless network provided by our Aruba ... Wireless settings are WPA/TKIP, with PEAP for authentication. ... Use your global user account or local user account to access this ... What I would do is create a group of wireless enabled computers. ...
    (microsoft.public.internet.radius)
  • Machine Authentication not working with wireless clients and IAS
    ... Windows XP SP2 PC connecting to a wireless network provided by our Aruba ... IAS server is also a domain controller in our Windows 2003 domain, ... Wireless settings are WPA/TKIP, with PEAP for authentication. ... Use your global user account or local user account to access this ...
    (microsoft.public.internet.radius)
  • Re: SQL Remote Data Access Secuity
    ... up authentication for RDA or Merge the first time is challenging ... Once you've got the most basic case working (an explicit SQL Server ... user account being passed from mobile client all the way to the back end), ... Should my desktop database be configured for SQL and Windows ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Changing to mixed mode
    ... one security implication is that coming versions of SQL Server might ... Windows Authentication and you can do that even if you let your ASP ... and assign a user account in the domain that has a mapped login ... the database and allow modification only through secure components in the ...
    (microsoft.public.sqlserver.security)
  • Re: How to disable ctrl-alt-del in a screen saver application
    ... Windows machines, the problem can be easily solved without you writing any ... each company user should have a domain user account. ... Each user in the SQL Server database is a domain user (or should ...
    (microsoft.public.dotnet.framework.windowsforms)
Loading