Re: Problems with trusted sharing

From: Peter (anonymous_at_discussions.microsoft.com)
Date: 04/01/04 

Date: Thu, 1 Apr 2004 07:11:36 -0800

Access 2002 doesnt come with enterprise manager, so somehow
the settings got to be entered by hand i think?? perhaps
with regedit?

>-----Original Message-----
>The security setting of your SQL Server has been set to
Windows only (which
>is the default setting for the installation setup),
instead of SQL Server
>and Windows logins.
>
>Open the Enterprise Manager and look at the properties of
the SQL Server
>under the Security tab.
>
>S. L.
>
>"Peter" <president@dreamretail.com> wrote in message
>news:16a4601c41786$54389f70$a401280a@phx.gbl...
>> I am on a closed network behind a firewall. I recently
>> bought the Access 2002 upgrade. I converted an existing
>> access database from 97 to 2002 then Upsized it to SQL. The
>> 97 and 2002 MDBs had a security password. After the file
>> went to the 2002 SQL that comes with the package I tried to
>> create an ODBC link but it would only allow me to select
>> Windows NT and not the user id and password I want. When I
>> try to selct that is says its not a trusted connection.
>> This happens both on the machine itself where the database
>> is as well as all others on the closed IP network. This
>> never used to happen. It appears theres a SQL setting to
>> say one can use eitehr trusted or the ID/password but I
>> cant find it.
>
>
>.
>

Relevant Pages

  • Connecting to SQLServer 2000 from ASP.NET
    ... I have an ASP.NET application that connects to a SQL Server database. ... Windows XP SP2 on development PCs which host the ASP.NET application. ... I managed to add MyDomain\AUser as a SQL user in Enterprise Manager. ... Computer: MachineName ...
    (microsoft.public.sqlserver.server)
  • Connecting to SQLServer 2000 from ASP.NET
    ... I have an ASP.NET application that connects to a SQL Server database. ... Windows XP SP2 on development PCs which host the ASP.NET application. ... I managed to add MyDomain\AUser as a SQL user in Enterprise Manager. ... Computer: MachineName ...
    (microsoft.public.dotnet.framework.aspnet)
  • Server Registration fails - figure this out !
    ... In EnterPrise Manager on the workstation, I try to add a server ... not associated with a trusted SQL server ... security on SQL Server is set to mixed authentication modes ... on Windows SBS 2003 box ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for user sa. Reason: Not associated with a trusted SQL Server Server Connection.
    ... 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 ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL open error
    ... I wish to use Windows authentication rather than supplying ... in Enterprise Manager reads as. ... Source=localhost in my connection string I get the error ... "SQL server does not exist or access denied". ...
    (microsoft.public.dotnet.general)