Haslett, Andrew
andrew.haslett at ilc.gov.au
Mon Oct 11 19:32:43 CDT 2004
If this is just for your own purposes, then use the built-in sa account as suggested. Its not an issue of being able to 'see' the other servers, or another network issue, its that you don't have permissions as its assuming you're using the Guest account when using Windows (Integrated) Authentication. Set it up to use SQL Authentication - specify the same password for the sa account so that you only have to remember one, and then use these credentials when registering servers from the other machines. -----Original Message----- From: John W. Colby [mailto:jwcolby at colbyconsulting.com] Sent: Tuesday, 12 October 2004 6:02 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Problems registering database Yea, I don't need any of that stuff. I am the only user. I just need all the Servers to recognize that user. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ At least for the time being, you only need 1 user, which you already have -- sa. Once you finally get around to adding users I STRONGLY recommend that you use roles rather than just users. That way you can define a role once, and then add all the users you want to it. Change the roles of the role and all users inherit the change. You can also build roles up. I often go this route. I.e. Role -- sales staff:: no table rights. Rights to various procedures that allow update, insert, delete maybe. Role -- Manager: no table rights. Rights to do anything Sales can do, plus run some reports and view salaries. Role -- Developer:: rights to tables, sprocs, views, etc. Now add JWC to Sales and also to Manager. Everyone else in Sales gets only those rights, but JWC gets Manager rights as well. _______________________________________________ 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 IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.