Re: Trouble registering a server

Right, so that suggests that your windows domain account is not setup as a
login on the server. You need to get someone who is a local administrator on
the server to add your login account to SQL Server using Enterprise Manager
(Security>Logins>New Login). The good news is that you are actually
connecting to the server okay (since the login failed error is returned by
SQL directly)

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"Bill Sturdevant" <BillSturdevant@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:7560D58A-E140-4085-96FD-9C900AB052F0@xxxxxxxxxxxxxxxx
> Now I get the following message:
>
> ServerName - Login failed for user 'XXXXXX\myWindowsUserName' where XXXXXX
> is maybe some sort of domain name...
>
> "Jasper Smith" wrote:
>
>> You do not need to supply your username and password if connecting using
>> a
>> windows account (which it sounds like you are doing). It also sounds like
>> the server is set for Windows Authentication only. Simply don't supply
>> the
>> username and password when registering the server (if using the wizard
>> select the top option on the "Select an Authentication Mode" page - the
>> option is labeled Windows Authentication
>>
>> --
>> HTH
>>
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>>
>> "Bill Sturdevant" <BillSturdevant@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message news:B134A1B1-CFAE-4F20-B196-A73748D18C3F@xxxxxxxxxxxxxxxx
>> >I have SQL Server 2000 installed on a Windows 2K machine. The machine
>> > happens to be located in another city. I do not have administrator
>> > rights
>> > on
>> > this machine, but am able to collect to it using Remote Desktop
>> > Connection.
>> > Someone at that location installed DQL Server for me, but neither of us
>> > really understood what we were doing at the time.
>> >
>> > I could not start/stop SQL Server, but discovered I could go into
>> > MSSQLWERVER Properties (Control Panels\Administrative
>> > Tools\Services\MSSQLSERVER) and set up a SQL Server account which
>> > allows
>> > me
>> > to start and stop SQL Server.
>> >
>> > Now, working remotely but on that same machine, I am in Entrerprise
>> > Manager
>> > trying to Register a server. I right click on the ServerGroup and
>> > select
>> > New
>> > Server Registration. I select the server (there happens to be others
>> > available in this installation so they show up), then enter the
>> > Username
>> > and
>> > password I set up for myself in MSSWLSERVER, but it fails telling me my
>> > Username is "Not associated with a trusted SQL Server connection"
>> >
>> > What am I doing wrong, not doing?
>>
>>
>>


.

Relevant Pages

  • Secure web authentication system w/o SSL and PKI
    ... In the beginning, a user should be able to register for an account, ... minted one-time password to their email address. ... it is assumed that only both the server and the end ... I'm making the big assumption that the user's email login has not been ...
    (comp.security.misc)
  • Re: user cant access OWA or RWW
    ... I filtered the Security log on the server using her name in the User box and unchecked Success. ... Now I see Event 533's for her account when I tried it this morning. ... There should be a couple of events during this login process. ...
    (microsoft.public.windows.server.sbs)
  • Re: Compromise?
    ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Auth to SQL Server from ATL Web Service not working...
    ... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
    (microsoft.public.vc.atl)
  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)