I have a server 2008 r2 domain, with windows 7 prof 32 bit workstations. The IP's are assigned through DHCP, on one of the workstations there is an excel database with consumer information. It is in a shared folder with everyone having read/write permission. There is a shortcut on all workstation desktop's to access it individually. Since Friday it has not been accessible, the error messages are that the computer is not accessible or the trust relationship for the domain has failed. I have reset the computer accounts, I have disjoined/rejoined the computer with the database, also have disjoined/rejoined all other workstations as well. On one of the workstations I am able to connect to the shared folder but only see shared printers and no database file. I am lost on what to try next any and all suggestions will be appreciated..
Shared Folder
- Thread starter jeffb
- Start date
YeOldeStonecat
Well-Known Member
- Reaction score
- 7,020
- Location
- Englewood Florida
Do an IPCONFIG /ALL on both the server, and workstations.
What I want to focus on, is what the server is using for Primary DNS in its TCP/IP properties, as well as the workstations.
On the server, and a workstation, bring up event viewer....and look at system, security, directory services 'n stuff on the server. Look for red entries when the last reboot and log in was. On the workstation..look for entries at the time of login.
TCP/IP properties, advanced, WINS tab, enable NETBIOS over IP. Both server, and workstations (easily done for workstations via a setting in DHCP on the server).
What I want to focus on, is what the server is using for Primary DNS in its TCP/IP properties, as well as the workstations.
On the server, and a workstation, bring up event viewer....and look at system, security, directory services 'n stuff on the server. Look for red entries when the last reboot and log in was. On the workstation..look for entries at the time of login.
TCP/IP properties, advanced, WINS tab, enable NETBIOS over IP. Both server, and workstations (easily done for workstations via a setting in DHCP on the server).
Last edited:
Markverhyden
Well-Known Member
- Reaction score
- 11,339
- Location
- Raleigh, NC
I'm at a loss. Nothing personal. You've gone through the trouble to setup a regular server domain. Fine. Why in the world are you all using a workstation as a file share point, in essence a file share server, when you all already have a real server which can handle that.
I have 2, 2008 R2 servers:
Primary DNS Suffix: cwabserver1.cwab.org
DNS Suffix Search: cwabserver1.cwab.org
Autoconfig Enabled: Yes
IP Add: 10.1.10.176
Sub Mask: 255.255.255.0
Def Gate: 10.1.10.1
Dns Servers: 10.1.10.176, 10.1.10.177
NetBIOS Tcpip: Enabled
All Workstations are similar except the IP's
Primary DNS Suffix: cwabserver1.cwab.org
DNS Suffix Search: cwabserver1.cwab.org
Connection Specific DNS Suffix: cwabserver1.cwab.org
DHCP Enabled: Yes
AutoConfig Enabled: Yes
IP: 10.1.10.
Sub Mask: 255.255.255.0
Def Gate: 10.1.10.1
DHCP Server: 10.1.10.176
DNS Servers: 10.1.10.176
NetBIOS Tcpip: Enabled
Let me know if you need more info.
Primary DNS Suffix: cwabserver1.cwab.org
DNS Suffix Search: cwabserver1.cwab.org
Autoconfig Enabled: Yes
IP Add: 10.1.10.176
Sub Mask: 255.255.255.0
Def Gate: 10.1.10.1
Dns Servers: 10.1.10.176, 10.1.10.177
NetBIOS Tcpip: Enabled
All Workstations are similar except the IP's
Primary DNS Suffix: cwabserver1.cwab.org
DNS Suffix Search: cwabserver1.cwab.org
Connection Specific DNS Suffix: cwabserver1.cwab.org
DHCP Enabled: Yes
AutoConfig Enabled: Yes
IP: 10.1.10.
Sub Mask: 255.255.255.0
Def Gate: 10.1.10.1
DHCP Server: 10.1.10.176
DNS Servers: 10.1.10.176
NetBIOS Tcpip: Enabled
Let me know if you need more info.
Mark, the excel file was created and saved on a workstation. I tried putting on the server to handle the sharing but when the file was opened individually, it only opened as a read only file and changes would not show up across the network. The only way to update the changes was to keep it on the original workstation.
Markverhyden
Well-Known Member
- Reaction score
- 11,339
- Location
- Raleigh, NC
Ahh... Ok, so some kind of message like "this file is in use and can only be opened as read only"?
Actually it shows up on some computers as "shortcut.lnk" is missing and on 2 of the workstations it asks for user and password info. When I put my domain credentials in the folder opens, but only shows shared printers no documents, in this case an excel file. I have checked the permissions on the host computer and nothing has changed.
Markverhyden
Well-Known Member
- Reaction score
- 11,339
- Location
- Raleigh, NC
I was referring to the symptoms when the file was hosted on the server. Sounds like there is a lock file problem.
TurricanII
Well-Known Member
- Reaction score
- 449
- Location
- Isle of Man
'Trust relationship for the domain has failed' usually affects one PC when you try to log in. rejoining should have ironed that out. Each PC and the server keep a secret computer account password between themselves. They change the password every couple of weeks. If a PC is turned off for an extended period, or if you clone a PC that has been joined to the domain, or if you have two PC's with the same name then this can cause the share problems you are having and also cause the trust relation ship to fail because the server can not agree the new password with the workstation.
Opening Excel XLS from a shared folder should behave in virtually the same way from a workstation or the server but you reall should get it working from the server;
1. Create a folder.
2. On the folder properties > Security tab, add all the domain users with read/write NTFS permissions.
3. Share it and give all the Users read-write share permissions.
4. Put the file in and away you go
Best to use the server because it has a static ip which makes it more reliable to share from. Also the server's Shadow Copies will not be destroyed when the end user runs CryptoLocker (new variants DO kill System Restore on workstations), giving you an immediate fix.
If you insist on using Win7 to share from then make sure the AV/firewall is not blocking clients. Give the workstation a reservation in DHCP. If the folder does not show up then unshare it and reshare it. Do not use a dollar at the end of the sharename as this will hide the share.
Make sure the Server service is running on the workstation and that you have the File and Print sharing ticked on the workstation's network card. Make sure the workstation and its network card is not turning off with power saving.
If the file keeps getting locked then turn off the preview pane in Windows Explorer on all clients as this will open the Excel file to show the preview. Also you might need to turn off Opportunistic Locking but I haven't really had to do this since the days of DOS databases and older Sage versions:
https://blogs.technet.microsoft.com...e-definitive-locked-file-post-updated-772014/
Opening Excel XLS from a shared folder should behave in virtually the same way from a workstation or the server but you reall should get it working from the server;
1. Create a folder.
2. On the folder properties > Security tab, add all the domain users with read/write NTFS permissions.
3. Share it and give all the Users read-write share permissions.
4. Put the file in and away you go
Best to use the server because it has a static ip which makes it more reliable to share from. Also the server's Shadow Copies will not be destroyed when the end user runs CryptoLocker (new variants DO kill System Restore on workstations), giving you an immediate fix.
If you insist on using Win7 to share from then make sure the AV/firewall is not blocking clients. Give the workstation a reservation in DHCP. If the folder does not show up then unshare it and reshare it. Do not use a dollar at the end of the sharename as this will hide the share.
Make sure the Server service is running on the workstation and that you have the File and Print sharing ticked on the workstation's network card. Make sure the workstation and its network card is not turning off with power saving.
If the file keeps getting locked then turn off the preview pane in Windows Explorer on all clients as this will open the Excel file to show the preview. Also you might need to turn off Opportunistic Locking but I haven't really had to do this since the days of DOS databases and older Sage versions:
https://blogs.technet.microsoft.com...e-definitive-locked-file-post-updated-772014/
Thank you Mark, you pointed me in the right direction. It turned out that I was sharing it the wrong way from the server. I wasn't using share and storage management, now that I have that setup it is sharing and pushing out changes. Thank you to all who gave suggestions, a simple problem has been giving me fits for the last couple of days.
Similar threads
