Francisco Tapia
fhtapia at gmail.com
Sun Sep 26 22:08:20 CDT 2004
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 > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco http://ft316db.VOTEorNOT.org