Re: SQL Server Connection Error

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Raymond Lewallen (Raymond.CTR.Lewallen_at_nospam.faa.gov)
Date: 04/06/04 

Date: Tue, 6 Apr 2004 08:39:04 -0500

Trent,

So you know, you can't just change the setting to use Windows and Sql Server
authentication. You must reinstall Sql Server to enable this option. I
could be wrong, but this is how I remember it being setup.

Raymond Lewallen

"Αντώνης" <abiliardis@netscape.net> wrote in message
news:#38Ar53GEHA.3592@TK2MSFTNGP10.phx.gbl...
> Hi Trent,
>
> In all probability the SQL Server has been installed with "Windows only"
> authentication only which is the default. The security settings need to
> be changed to "SQL Server and Windows" authentication.
>
> Hope this helps,
> Antoni
>
> _____________________________________________________________
> B&D Technologies
> http://www.bd-tech.com
> Antoni Biliardis - antoni(at)bd-tech.com
>
>
> O/H Trent έγραψε:
> > Hello to all,
> >
> > I am trying through VB.Net code to connect to a
"System.Data.SqlClient.SqlConnecton" and receive the following error upon
Sql1.Open()
> >
> > "Unable to connect to a trusted sql server connection"
> >
> > Any thoughts? I am using BackOffice SQL Server Test Platform.

Relevant Pages

  • 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)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)