Registered users    
MembershipMembership:
Latest New UserLatest:Tim Whiteside
New TodayNew Today:18
New YesterdayNew Yesterday:7
User CountOverall:23106

Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12634
Marina Roos12290
Eriq Neale2105
Michael Patrick1906
Stan Guinn1847
Robert Pearman1728
Nick Pieters1425
Stewart Brown609
Kevin D.563
william warren548
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Subject: Another question I cannot find anyone to answer!
Prev Next
You are not authorized to post a reply.

Author Messages
Ryan Thomas User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 User is Offline
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 AdministratorMission 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'
You are not authorized to post a reply.
Forums > Microsoft Smallbusiness Server > Small Business Server 2003 > Another question I cannot find anyone to answer!



ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.