JWColby
jwcolby at colbyconsulting.com
Mon Aug 28 18:28:31 CDT 2006
Stuart, >This is an SQL Server list. I, and apparently others, assumed that anyone who had set up SQL Server installations using Windows authentication would have learnt at least the basics of Windows network security. Give me a break Stuart. I am an Access database person. I have a WFW here at my home office. My clients have network administrators to administer their networks. MY (damn few) clients who use SQL Server have admits to administer them. Now, I have set up SQL Server about a dozen times over the last three years. I have never known anything about Networking, and never required knowing that stuff to do the install. Have you never run the install? You come to a page where it asks you which you want and you select one. The SQL Server install continues. How in the world does that equate to "having to know anything damn thing about any damned thing"? For whatever reason, the installs in the past have always just worked, at least in terms of being able to see the other servers from the various workstations. I have no clue why they just worked, nor have I any clue why they are not now. Apparently you and others assume too much. I assumed that this was a friendly Accessed list, where those who know help those who don't. At least it always has been in the past. If it has morphed into a "got to be a guru to be here" list that is fine, just say so and I will leave 'cause I clearly am not a guru. Perhaps I can talk to the powers that be and they will set up another SQL server list for those of us who are not Database / Network Admits. All of us poor schuss who don't know enough to join this list can muddle around at least trying to help each other. Of course that does beg the question of why you are on THIS list in the first place, if you are such a guru you don't need help, and all the others on this list are such gurus they don't need help. Must be a lonely place. I hope the truth is that I can come here and get more than "turn off simple file sharing" in response to an apparently rather complex issue of two Windows XP machines running SQL Server 2k where the servers cannot see each other. >Now you can set proper permissions on your resources and authenticate using accounts with appropriate permissions." >If you don't understand the last part, you shouldn't be messing with the first part. I can see that you are not interested in helping either. And had Haslett stated that in such no nonsense terms I would not have messed with the simple file sharing. At least my machines could see each other's files before, now I don't even have that. Thanks Stuart, your support is much appreciated (I assume). 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 5:38 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] [AccessD]TransferringadatabasetoanotherSQLServer On 28 Aug 2006 at 11:03, JWColby wrote: > If that is the case, then throwing out advice like "turn off simple > file sharing" is inappropriate advice, at least without a "this will > royally screw up your private workgroup file sharing (and not even get > you what you are after)" warning. Sorry if THAT sounds harsh, but I > am NOT a Notwork Admin (nor are many others on this list), and > apparently my workgroup file sharing IS SCREWED UP because I blithely followed "correct" advice. > Sorry, if this sounds harsh, but. If you don't know the basics of network sharing and user management, you shouldn't be trying to set up multi-user or client-server based database applications. As I posted earlier: "....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." If you don't understand the last part, you shouldn't be messing with the first part. This is an SQL Server list. I, and apparently others, assumed that anyone who had set up SQL Server installations using WIndows authentication would have learnt at least the basics of Windows network security. Take a look around http://compnetworking.about.com/od/windowsfilesharing/ or spend ten minutes with Google and "Windows file sharing". -- Stuart _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com