JWColby
jwcolby at colbyconsulting.com
Mon Aug 28 07:59:31 CDT 2006
>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