[dba-SQLServer] Re: Back to the login thing

Robert L. Stewart rl_stewart at highstream.net
Thu Nov 18 10:39:31 CST 2004


John,

Create and use a User account other than Administrator,
and I think the instructions given to you will work.
Administrator is a "different" kind of user account and
I have seen problems like yours when using it between
machines.

Robert

At 10:29 AM 11/18/2004 -0600, you wrote:
>Date: Thu, 18 Nov 2004 11:29:36 -0500
>From: "John W. Colby" <jwcolby at colbyconsulting.com>
>Subject: RE: [dba-SQLServer] Back to the login thing
>To: dba-sqlserver at databaseadvisors.com
>Message-ID: <003301c4cd8b$cb343100$e8dafea9 at ColbyM6805>
>Content-Type: text/plain; charset=us-ascii
>
>Eric,
>
>Well that is the confusing thing here.  Every one of these three machines
>has an administrator account (user name Administrator) all with the same
>password.  I log in as that user on all the machines.  Each of these
>Administrator accounts is indeed an administrator on that machine - these
>are the default admin accounts created by Windows as Windows is installed on
>the machine.
>
>So AFAICT I have done exactly what you are discussing.
>
>John W. Colby





More information about the dba-SQLServer mailing list