Re: Server Registration fails - figure this out !

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 08/29/05 

Date: Sun, 28 Aug 2005 19:27:48 -0600

The error message:
 "Login failed for user 'sa'. Reason : not associated with a
trusted SQL server connection"
indicates you aren't using mixed authentication. Maybe
someone reset it to use mixed but didn't restart the service
after making the change.
Make sure the windows account being used has a login, has
their default database available and isn't denied through
any other group membership.

-Sue

On Sun, 28 Aug 2005 15:49:52 +0200, ErwinB <eba@iqs.be>
wrote:

>Hi,
>Try to figure this out, because I was not able to do a d*mn thing !
>
>In EnterPrise Manager on the workstation, I try to add a server
>registration. I tried both ways :
>- using Windows authentication, then the error states "Login failed for
>user Domain\User"
>- using SQL authentication (with 'sa'), then the error states "Login
>failed for user 'sa'. Reason : not associated with a trusted SQL server
>connection"
>
>What I did and what I checked so far :
>- connections are made with TCP/IP (I used the Server Network and the
>Client Network utilities to check)
>- security on SQL Server is set to mixed authentication modes
>- of course, the account of the user is added to the login list
>
>Some details :
>Server side
>- on Windows SBS 2003 box
>- is actually MSDE
>- user interface provided by DbaMgr2K, a FREE tool that acts like
>EnterPrise Manager
>
>Client side
>- Windows XP Pro, SP2
>- has a full SQL Server 2000 installation with EnterPrise Manager
>
>The interesting fact is that a few months ago, it worked quite well
>(although only with SQL Server authentication). It's only after some
>updates (Windows XP SP2 ? update on server ?) that it became impossible
>to have the server registrated.
>
>If you find the solution to this unpleasant problem for me, and you'll
>ever visit Belgium, I'll buy you a 4-pack of the Best Belgian Beer (it's
>called "Duvel").
>
>Thanks !
>
>ErwinB
>
>PS. Now that I'm at it, I read that the default port 1433 should be
>changed. Is there a range of ports available and suitable to this
>purpose ? Thanks again

Relevant Pages

  • Re: Login with no Fixed Server Role and DB Role can stop SQL Agent Service?
    ... a Window 2000 Login with Domain User default permissions, ... > actually answered the question about the permissions the user has re: ... Forget about SQL Server for the moment. ... >> Enterprise Manager, but he is still able to stop the SQL Agent ...
    (microsoft.public.sqlserver.security)
  • Re: Log in problem
    ... Open Enterprise Manager and right click on the server node. ... Select Edit SQL Server Registration Properties. ... You may also just be experiencing a login time...it's hard ... >not log into my local database however I can log into a ...
    (microsoft.public.sqlserver.clients)
  • Re: MSSQL$MSFW :: How to connect to it with SQL Server Enterprise Manager?
    ... > The question is - can I connect to this instance with either SQL Server ... The firewall MSDE is a SQL 2000 instance. ... W3WALL\MSFW as the SQL Server in Enterprise Manager. ... Install the client tools on the firewall, login as ...
    (microsoft.public.isaserver)
  • Re: Storing/saving sessions on SQL Server
    ... If you dont have enterprise manager, download SQL ... "SQL Server does not exist or access denied. ... "Cannot open database requested in login 'ASPState'. ...
    (microsoft.public.dotnet.framework)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)