Re: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server Server Connection.

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 22:09:46 +0530

Hi,

>From the server execute the below command from command prompt

osql /U sa /P passwd /S servname

If the execution give the same error then we can conclude that the
Authentication is not changed to SQL Server and Windows mode.

Open the enterprise manager, navigate to your server, right click on the
left pane, choose properties, select the security tab
and change the "Windows only" to "SQL Server and Windows".

 STOP and START MSSQL Server service

Note:

By default the 'sa' password is blank. Change it quickly. Go to the security
folder (Enterprise manager) of your server and change the sa password.
Include this password in your connection string.

Thanks
Hari
MCDBA

"Grant Reid" <grant.reid@telefonica(dot)net> wrote in message
news:e0xPjFaQEHA.252@TK2MSFTNGP10.phx.gbl...
> Hello,
>
> I am trying to create an OLE DB connection to MS-SQLSERVER 2000.
> I have set the security settings inside Enterprise Manager to allow logins
> for both SQL Server and Windows.
> Does anybody have any ideas as to what is causing this error?
>
> Regards
> Grant Reid
>
>

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Cannot open database requested in login
    ... Assuming your goal is to use windows integrated ... security then leave out the username ... ASP.NET service) as a login to SQL Server and with access to the ... >> you should see security tab, change authentication to "SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Reason: Not associated with a trusted SQL Server connection.
    ... but does that mean ASP uses the IUSR account to access the SQL ... > There are two sets of authentications: Windows, and SQL Server. ... If using integrated security, ...
    (microsoft.public.inetserver.asp.db)
  • ASP.NET "Custom" Security
    ... SQL Server, DB2, MySQL, Oracle, ... Windows server at the other end. ... to be authenticated by the stored procedure against the ... Is this a reasonable security model? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... the Space Shuttle has some very strong windows -- get my point. ... doubt THE single most significant security flaw -- this is the green light ... spoofing was known about when the protocol was introduced and Microsoft did ... > need to use some other mechanism to connect to SQL Server. ...
    (microsoft.public.sqlserver.security)