Michael Maddison
michael at ddisolutions.com.au
Sun Sep 26 20:47:10 CDT 2004
<<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