Ryan Thomas  United Kingdom Member since 9/18/2007
Registered Users Posts: 59
 |
| 3/20/2008 10:22 AM |
|
SBS 03 standard server with a folder share that contains a third part accountancty program which users run via a shortcut to an executable stored on the share.
Since I applied the patch to the latest version of the accoutancy program I've had a weird problem whereby if you look at the folder share in Computer Management I can see lots of '# Client Connections' even when there are no client PC's turned on. If I unshare the folder I get a window saying 'X users have files open etc'.
There is nothing shown as opn in computer management ?
Where Can i see exactly who and what these files are open by ?
Next question: Why are their 2 permissions boxes when sharing a folder? There is one on the tab where you enter the Share name (button labbelled permissions) and another Tab on its own called 'permissions'. I only use the main tab but what is the point of both ?
thanks
Ryan
|
|
|
|
|
|
Brian Mayo  Along the shoreline of New England Member since 6/22/2005
Registered Users Posts: 313

 |
| 3/20/2008 11:20 AM |
|
Can look in MMC..."Sessions" and "In Use"...to see which PCs have files open.
Depending on what type of files and database this program uses..may want to make sure that its folder is added the servers antivirus real time protection exclusion list..and also client workstations have network media added to their exclusion list.
As far as permissions...yes it's commonly done on 2x levels. The "Share" permissions only gives you basic control of who can "see" the share, and access as the basic share level...but it does not give you much more than that. The "Security" tab is what allows you to benefit from everything that NTFS is about...get very granular in your controlling who gets what.
Commonly...the Share permission goes to Everyone...you then strip down on Security permissions.
|
|
|
|
|
|
Ryan Thomas  United Kingdom Member since 9/18/2007
Registered Users Posts: 59
 |
| 3/20/2008 11:54 AM |
|
Hi Brian I dont have a snap-in called sessions ? thanks for the heads up on permissions - still cant see the point in two tabs though! cheers Ryan |
|
|
|
|
|
Brian Mayo  Along the shoreline of New England Member since 6/22/2005
Registered Users Posts: 313

 |
| 3/20/2008 12:13 PM |
|
It's not a separate snap in. Whatever means you wish to get to your Shared Folders in MMC...expand it..you'll see 3x subfolders, 1. Shares 2. Sessions 3. Open Files.
For a very basic peer to peer network...a small handful of workstations where basically EVERYONE has equal rights to a few shares...yeah you'll never see the benefit of having 2x tabs..and realize the potential of the Security tab which begins to utilize NTFS.
But once you get to slightly larger networks..where you may have some "groups"..or various levels of permissions, on various shares....this is where you begin to realize the meaning of the security tab and NTFS.
|
|
|
|
|
|
Jay Hallsworth  United Kingdom Member since 3/27/2007
Registered Users Posts: 180
 |
| 3/20/2008 12:17 PM |
|
Hi Ryan, I've not followed this thread properly but I think the snapin that Brian is refering to is computer management ... expand System Tools > Expand Shared Folders Regards JH |
|
|
|
|
|
Neil Beswick  United Kingdom Member since 9/26/2007
Registered Users Posts: 97

 |
| 3/20/2008 12:17 PM |
|
Ryan - the share permissions are also useful for file systems that have no inherent security - such as FAT(32) - you wouldn't normally use FAT32, but sometimes you may have no choice - or in gateway products, where the file system is remote. Neil. |
|
|
|
|
|
Ryan Thomas  United Kingdom Member since 9/18/2007
Registered Users Posts: 59
 |
| 3/20/2008 12:40 PM |
|
| the computer management tab doesnt show any opens sessions at all just a bunch of 'client connections' its these im trying to find |
|
|
|
|
|
Jay Hallsworth  United Kingdom Member since 3/27/2007
Registered Users Posts: 180
 |
| 3/20/2008 01:18 PM |
|
Hi Ryan,
You mantion computer management tab .... there are no TABs in MMC are we missing something?
I use an accounting package in a similar way to you... Sage Line100 and often need to see who is in the application, you can see what users has the files open in the open files section of the computer management snapin
There are several ways of getting here, one of which is
On the server ... Click start > run & type compmgmt.msc then click OK
Expand System Tools
Expand Shared Folders
Select Open Files
Hope that helps
Regards
JH
|
|
|
|
|
|
Brian Mayo  Along the shoreline of New England Member since 6/22/2005
Registered Users Posts: 313

 |
| 3/20/2008 03:09 PM |
|
One of Many ways to get to this MMC....
Right Click "My Computer"...select "Manage"
Expand the "Shared Folders" hive...
bingo
|
|
|
|
|
|
Ryan Thomas  United Kingdom Member since 9/18/2007
Registered Users Posts: 59
 |
| 3/20/2008 05:19 PM |
|
Guys You are misunderstanding the problem. Looking at open shares is easy yes. This is not the issue. There are open connections visable in the SHARES tab but NO open files in the open shares tab. What who how do i look at the open connections and see what files are locked ? They are there as soon as i drop the share ity complainis about users being connected (even though no client PC's are powered up). The answer is not in computer managennt. cheers Ryan |
|
|
|
|
|
Brian Mayo  Along the shoreline of New England Member since 6/22/2005
Registered Users Posts: 313

 |
| 3/20/2008 06:25 PM |
|
| Not misunderstanding...we have some unanswered question still...up above..asked about if any database engine, and what your antivirus settings were..specifically proper exclusions.
|
|
|
|
|
|
Ryan Thomas  United Kingdom Member since 9/18/2007
Registered Users Posts: 59
 |
| 3/20/2008 06:46 PM |
|
Sorry missed that. There is no AV software. cheers Ryan |
|
|
|
|
|
Ryan Thomas  United Kingdom Member since 9/18/2007
Registered Users Posts: 59
 |
| 3/21/2008 05:46 PM |
|
no answer, wasnt expecting one really as all the MCSE ppl I've asked hadnt a clue either. Anyone have any contacts in MS tech who can maybe answer it ? cheers |
|
|
|
|
|
Sam Thorpe  United States Member since 4/14/2005
Registered Users Posts: 123
 |
| 3/21/2008 06:04 PM |
|
Have you contacted the Accounting Software Vendor's Tech Support? Sounds like the problem is related to their software rather tham SBS. Maybe it is a known issue. |
|
|
|
|
|
Ryan Thomas  United Kingdom Member since 9/18/2007
Registered Users Posts: 59
 |
| 3/21/2008 07:58 PM |
|
I would really like to view '# Client connections', maybe i'm asking the impossible and the feature just doesnt exist. |
|
|
|
|
|
Mick Malloy  Australia Member since 4/6/2007
Microsoft MVP Posts: 287

 |
| 3/22/2008 02:01 PM |
|
if the connection from the client uses standard windows filesharing to open the file it will appear as an 'Open File' in the Computer Management Shared Folders. If some other process (ODBC?) is used to connect from the client to a process on the server and the file is actually opened locally by the server the connection will not appear as an open file in Open Files. ODBC may actually be a bad example, my ODBC-fu isn't blackbelt, I have this feeling that ODBC uses both the 'ODBC channel' and a remote 'file open'. A 'pure' SQL connection is probably a better example, the client/server connection is purely network based and should appear as a 'session' but the files SQL Server is accessing will not appear as 'open' in Shared Folders because the SQL-File relationship is purely local. If the client/server connection is network based (or more correctly _not_ file based) it will not appear open in 'Open Files', you must rely on either the application counting 'current sessions' or inspection of the mechanism used for those connections to figure out who's connected. The most obvious example of this is Exchange. You may have a bazillion people who have Outlook open to the Exchange but priv1.edb is not going to appear in 'Open Files' because the 'open' is performed locally from store.exe to priv1.edb. The remote connections are just something that is not accounted at this level. |
|
|
|
|
|
Ryan Thomas  United Kingdom Member since 9/18/2007
Registered Users Posts: 59
 |
| 3/26/2008 09:14 AM |
|
Hi Mick Its not ODBC just plain running an exe from the server. cheers Ryan |
|
|
|
|
|
Marina Roos  The Netherlands Member since 3/24/2005
Forum Admins Posts: 12290

 |
| 3/26/2008 12:37 PM |
|
Hi Ryan,
It would really help to know which program you are talking about. Else you will need to contact the vendor of that program and ask them.
|
|
| Marina Roos Smallbizserver.Net Administrator | Mission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain' |
|
|
|
|