Re: Cannot Register Sql Server Database

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

Date: Wed, 24 Mar 2004 08:40:06 +0530

Hi,

Are you using Domain user id to login to your machine, if yes then check the
SQL server that you have given access to sql server.

How to check.

In Enterprise Manager, Security option, Check wheather ur login is there
with reqired previlages.

Thanks
Hari
MCDBA

"Allan Latts" <alatts@yaoo.com> wrote in message
news:B571755C-B3AA-4ED1-94D9-FE11B0B8EE3E@microsoft.com...
> 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: 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)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)