Haslett, Andrew
andrew.haslett at ilc.gov.au
Mon Aug 28 09:23:45 CDT 2006
Perhaps the advice provided months (a year?) ago when I recall this same (or similar) problem arose, recommending that this type of thing should not be attempted without sufficient training / experience / professional assistance, was good advice? Simple file sharing is the reason you could not connect. Steps to disable it were posted in a previous post. Enabling it is as simple as checking the box instead of unchecking it.. A 1 minute search on google will further provide these details. Furthermore, the documentation for SQL Server - Books On Line, by far the best product documentation that MS has provided, will provide you with plenty of easy to find material on configuring security in SQL Server, which will detail the issues you are requesting on SQL / Windows Authentication. Sorry if this sounds harsh but there are reasons that this stuff is taught in detailed courses -> it's just not something you can pick up and try to do off the cuff without some experience or at least willingness to investigate the documentation provided. And when the (correct) help we provide is thrown back at us with "you screwed my network" then, with all respect -> good luck with it yourself.. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Monday, 28 August 2006 10:30 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] [AccessD] TransferringadatabasetoanotherSQLServer >In yet another attempt to cater to the masses... I AM the masses. >You need to turn "Simple File Sharing" off, not turn "File Sharing" off. I have no idea how to turn "file sharing" on / off. I have turned "simple file sharing" off with the result that the poor huddled masses can no longer see the files on the poor huddled masses other machines, which makes the poor huddled masses most unhappy. Furthermore, in SQL Server EM with SFS turned off, the other machines no longer even show up as available to register a server on, which also makes the poor huddled masses most unhappy. It seems that by following the simple edict "turn off SFS" the poor huddled masses have royally screwed up the private little workgroup in the home office, and can not seem to get it back. Sigh. DETAILED INSTRUCTIONS on how to COMPLETELY implement something are so much appreciated. The poor huddled masses are called the poor huddled masses precisely because they have not spent the hundreds of hours required to become OS administrators. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Monday, August 28, 2006 8:34 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] [AccessD] Transferring adatabasetoanotherSQLServer On 28 Aug 2006 at 8:16, JWColby wrote: > This is a network in my home office. Why do I need to turn Simple > File Sharing off, and if I need to do that, how do I replace it's functionality? > > With Simple File Sharing OFF my workstations can no longer see each > other and I get "no permission to use" error messages when trying to > browse for shares in Explorer. > > Furthermore, with SFS off, the other machines do not show up when > browsing in EM for other servers. > You need to turn "Simple File Sharing" off, not turn "File Sharing" off. In yet another attempt to cater to the masses, MS introduced a new simplified type of file sharing in XP as an alternative to the standard file sharing that we have always used. They call this new system "Simple File Sharing". XP Home always uses Simple File Sharing. XP Pro defaults to Simple File Sharing if you are using a peer to peer network (no domain controller). If you are configured to use Simple File Sharing, remote users always authenticate using the Guest account and you run into the sort or problem you are facing. To switch to classic file sharing, 1. Double-click My Computer on the desktop. 2. On the Tools menu, click Folder Options. 3. Click the View tab, and then de-select "Use Simple File Sharing" Now you can set proper permissions on your resources and authenticate using accounts with appropriate permissions. See http://support.microsoft.com/kb/304040/ for all the gory details -- Stuart _______________________________________________ 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.