Re: Login failed for user '(null)'

Chris
Do you grant access to SQL Server,for login? What is a default database
did you assign to him?



"Chris Ford" <ChrisFord@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0189E38E-31FC-4E43-A79E-FCABE2726A9A@xxxxxxxxxxxxxxxx
Hello world,

I'm getting the following error when trying to register an instance of SQL
in Enterprise Manager (connecting using Windows authentication):

Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

EM sits on a developer's PC running XP Professional SP2, and SQL Server
2000
Standard Ed. SP4 resides on a Windows 2000 Server (SP4)

This particular PC was previously able to connecte to this manner prior to
migrating the SQL server from being a member server within an NT4 domain
to
being a member server within a Windows 2003 Active Directory Domain.

Any thought's as to why Windows authentication has stopped working would
be
most appreciated.


.

Relevant Pages

  • Re: SQL User SID format?
    ... When you move databases to another server, you can remap users to logins ... capability to remap a user to a login with new ALTER USER syntax - I ... The new ALTER USER syntax works for remapping both SQL and Windows ... this means you already have access to a SID from the syslogins catalog; ...
    (microsoft.public.sqlserver.security)
  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.portalserver.development)