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