[dba-SQLServer] Registering SQL Servers

John W. Colby jwcolby at colbyconsulting.com
Sun Sep 26 22:54:08 CDT 2004


I did that (see my original post AT THE BOTTOM ;-), no joy.

John W. Colby
www.ColbyConsulting.com 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco
Tapia
Sent: Sunday, September 26, 2004 11:08 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Registering SQL Servers


Create a Windows UID/PWD identical to the remote machine to all 3 servers
and make him Admin... Windows Authentication will see the uid and pwd as the
same and allow you full admin rights to each box.  You can now register w/
Windows authentication in EM.


On Mon, 27 Sep 2004 11:47:10 +1000, Michael Maddison
<michael at ddisolutions.com.au> wrote:
> <<This is stuff I never really needed to know, and I am NOT a notwork 
> administrator.>>
> 
> LOL...  Me either...
> I'm not familiar with Workgroups for this type of stuff. However what 
> I'd do to get me going is change each install to allow mixed mode.  
> Right click on the server in EM and select properties --> security  
> --> SQL + Windows You will need to do it locally, of course.
> 
> Now you should be able to register using sa.  The sa pwd doesn't have 
> to be the same for each server.
> 
> HTH
> 
> Michael M
> 
> 
> 
> Michael,
> 
> I suppose I should have specified.  This is my home office.  I only 
> have a workgroup.  I am trying to get SBS 2003 or even Windows 2003 
> set up but the new computers I bought don't have drivers for 2003 yet 
> so... Workgroup only, no domain.
> 
> Building an identical SA for each machine and logging in as that user 
> allows the file sharing to work without having to supply any passwords 
> etc.  It appears to windows somehow that I am logged on to every 
> machine as the same user thus it doesn't ask me for a password at 
> least to get at mapped drives and shares.
> 
> SQL is set up to use windows authentication.  If I can use the maps 
> and shares, then am I not a trusted log in?  If I am then why is the 
> process of registering accepting the user as a valid user?  It is 
> supposed to be asking Windows if I am valid, and Windows is accepting 
> me as valid at least for the purposes of shares and maps.
> 
> This is stuff I never really needed to know, and I am NOT a notwork 
> administrator.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of 
> Michael Maddison
> Sent: Sunday, September 26, 2004 9:05 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer] Registering SQL Servers
> 
> John,
> 
> I think you have several options...
> 
> Give yourself Domain Admin privs.  Alternatively create a another 
> single a/c and give it local admin on each server.
> 
> Register using sa for each server.
> 
> To remotely admin SQL you need to have Local Admin on each box and be 
> logged on as that account.  I don't think creating 3 a/c's basically 
> the same counts!
> 
> regards
> 
> Michael M
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John 
> W. Colby
> Sent: Monday, 27 September 2004 4:12 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] Registering SQL Servers
> 
> I have 3 computers with SQL Server installed, full install.  I want to 
> register the databases on each machine on each other machine so that I 
> can see the three databases from EM regardless of which machine I am 
> on.
> 
> I will admit up front that I did the install under different user 
> names, i.e. under the default Administrator on one and under jcolby on 
> the other two (I think).
> 
> I am using windows authentication.  I have a "reasonably strong" 10 
> character pneumonic password (first character of 10 words, but no 
> numbers or special characters).  I have created identical 
> Administrator / password accounts on all three machines.  All three 
> machines can see shares from each other without entering any passwords 
> / user names (as long as I'm logged in as administrator on that 
> machine).
> 
> I have logged off and back on as the administrator using the identical 
> password on each machine.
> 
> Neo1 can see Local and can see (and register) Soltek, but if I try and 
> register Neo2 I can see the server but get ""Neo2 - Login failed for 
> 'Neo2\Guest'. Neo2 can see Local and can see (and register) Soltek, 
> but if I try and register Neo1 I can see the server but get the same 
> "login failed for Neo1\Guest" error. Soltek can see Local (although it 
> is CALLED SOLTEK!!! It can see Neo1 and Neo2 but cannot register them, 
> getting the same "login failed" message.
> 
> What is going on here.  How do I sync them up so that all three can 
> see and register the other two.
> 
> Also what is the difference between the solid green circle with a 
> white arrow (in the server group tree) and the white circle with the 
> green arrow? Neo1 shows green with white arrows, Neo2 shows white with 
> green arrows, and Soltek shows its own name instead of Local and a 
> solid green with white arrow.
> 
> I believe Soltek was showing a Local but I couldn't connect to it, so 
> I deleted it and re-registered it to itself which is why I am not 
> seeing Local.
> 
> Can anyone briefly and succinctly explain what is happening during 
> this registration process, and how to get where AI want to go?
> 
> TIA,
> 
> John W. Colby
> www.ColbyConsulting.com





More information about the dba-SQLServer mailing list