Cannot Register Sql Server Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allan Latts (alatts_at_yaoo.com)
Date: 03/24/04 

Date: Tue, 23 Mar 2004 18:01:10 -0800

We have SQL Server installed on a windows 2000 server machine. I have a copy of Sql Server Personal Addition - Client tools on my computer. When I open the SQL Server Enterprise manager and try perform an New SQL Server Registration, I get the following error: Login Failed for user '(null)'. Reason: Not associated with a trusted SQL Server Connection. I am using windows authentication.

I am able to connect to other sql server databases on other servers.

I also cannot connect to the server via ODBC. I get the error: Unable to locate database server. Verify that the database server name you entered is correct.

I am running microsoft XP / Microsoft SQL Server 2000 service pack 3a is on the server.

Relevant Pages

  • Re: application developement
    ... *lot* of data where they have no ODBC driver. ... We have this partial list of supported ODBC database platforms: ... Adaptive Server Anywhere ... Microsoft SQL Server ...
    (comp.lang.c)
  • Linked Servers: Invalid schema
    ... Have you put a trace on the ODBC ... call 'in query analyser)- that gets ... database you are trying to connect to and schema refers to ... >server in Enterprise Manager and I have also used it ...
    (microsoft.public.sqlserver.odbc)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: database server interfaces examples
    ... them provide ODBC drivers, and there are many third-party providers, also. ... OLEdb is another Microsoft standard. ... Access Projects with Microsoft SQL Server, ... the most current database server interfaces. ...
    (comp.databases.ms-access)