Re: Trouble registering a server

Your last comment prompted some more investigation.

When I log in to the remote machine using Remote Desktop Connection, I have
to enter a UserName, a Password and a Domain name.

When I go to Administration Tools==>Services, I find that MSSQLSERVER is
shows "Log In As" = LocalSystem

I am told by the owner of the server that he set me up with Admin rights.
But when I look at Control Panels, I do not see Users and Passwords.

Given all that, what do you suggest?

"Jasper Smith" wrote:

> 1) Correct
> 2) Correct
> 3) Correct (assuming the login is a domain windows account rather than a
> local one)
>
> --
> 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:CAE28E62-8301-41F8-AD94-F0689900CFFD@xxxxxxxxxxxxxxxx
> >I have poked around a bit and would like to rephrase my previous
> >response...
> >
> > My problem is (1) when I log in to the remote physical machine using
> > Remote
> > Desktop Connection, I do not have Admin rights on that machine and (2) I
> > cannot get a server registered within a SQL Server Group.
> >
> > This is what I think you are telling me:
> > 1. Someone with Admin rights on that machine could get into Enterprise
> > manager and register a server within a Server Group.
> > 2. Then, the person with Admin rights could go into that server and create
> > a
> > login for my windows username so that, while connected via Remote Desktop
> > Connection, I could manipulate that single database.
> > 3. At the same time,the person with Admin rights could also create a
> > login
> > for me to use from my remote machine (or I could use the same login as
> > already set up). This would now allow me to use Enterprise Manager on
> > that
> > server from my remote machine and would also allow me to log into that
> > server
> > from my Access front end on my local machine.
> >
> > Is all of this correct?
> >
> > "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?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Connecting a remote workstation to a domain
    ... If you have more than a couple of remote workstations connecting to the SBS ... server via VPN, you really need to consider a Terminal Server in the main ... "Log in using a dial up connection" checkbox, ... roaming profile then synchronizes with the server over the VPN); ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem with Web based client
    ... Seems like you are having problems accessing the web server on the PC you ... > My remote desktop connection works fine when I connect with a Remote ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Remote Access and ISA Server in SBS 2003?
    ... I am glad to hear the Remote Access Wizard is working fine now. ... there is no difference in VPN between SBS 4.5 and SBS ... Error Message: VPN Connection Error 800: Unable to Establish Connection ... the external NIC of the SBS Server. ...
    (microsoft.public.windows.server.sbs)
  • RE: Remote Office Configuration Suggestions?
    ... Welcome to SBS newsgroup. ... I understand that you want to keep the remote office continue working even ... after the main internet connection on the main office is not available. ... If you want to join the remote server to a SBS domain and become a member ...
    (microsoft.public.windows.server.sbs)
  • RE: Another Remote Connection Manager Problem
    ... > internal and 192.168.1.3 for the internet connection. ... > via the SBS server to all clients. ... > With this configuration OWA and Remote Workplace are operational. ... > Connection Manager to connect to the VPN server and gain access to a shared ...
    (microsoft.public.windows.server.sbs)