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

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: [PHP] [Linux] PHP and SQL Server
    ... Is MSDE running in mixed mode authentication? ... default it only uses Windows authentication. ... Is the SQL server and the PHP script running on the same machine? ...
    (php.general)
  • mixed & windows authentication
    ... i am confused by the windows & mixed mode authentication ... Under Windows Authentication, do i need to create a login ... in SQL server? ... thks & rdgs ...
    (microsoft.public.sqlserver.server)
  • Re: Trouble connecting to SQL Server express over Peer to Peer network
    ... I have a program that accesses an SQL Server Express database. ... Configuration and I connect using Windows Authentication. ... that have never been connected to the domain, I have an issue connecting. ...
    (microsoft.public.vb.general.discussion)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot connect a remote sql server
    ... I too have written quite a bit about connecting. ... Hitchhiker's Guide to Visual Studio and SQL Server ... such as the server's firewall, SQL Server's remote connection setting, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)
Loading