Re: Trouble registering a server

While I am waiting for someone at that location to show up to help me...

I am going to need to coach the loac Admin person so I want to understand...

I got on a machine locally upon which I have admin rights and upon which SQL
Server 2000 is installed to sort of "practice" before I contact my remote
support. Are you saying it is possible to set up a SQL Server login even if
you do not have any Servers registered, as long as your own windows login has
Admin rights?
In Enterprise manager, I do not see a menu called "Security". On the button
bar, I see a button called New Login, but it only seems to be available on an
already registered server. My current problem is I cannot get a server
registered.

Ultimately, once I get the server registered on that remote machine, I am
going to need to connect to it from my own machine here. Will I also need a
login on that remote server for my windows username here on my local machine?

"Jasper Smith" wrote:

> 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?
> >>
> >>
> >>
>
>
>
.

Loading