Put a PAUSE in your script to make sure that the script is even running (just to make sure there isnt an error mapping the drive). By default, the script hides itself so you won't "see it" run necessarily.
Just a tip.
1) It's in Control Panel - Add Remove Programs - Add/Remove Windows Components (on the panel on the left) - and the service is located under Network Services i believe. It will be checked if it is installed.
2) You'll open up the DNS applet under Administrative Tools, expand your server...
In most environments users do not stay logged into sql server, they connect/disconnect quickly via whatever application you are using. However if they were to stay "permenently connected" then you may run into that barrier. I'm not as familiar with SBS so I can't comment on the product...
Most likely a DNS problem. On your domain controller(s), do a net stop netlogon/net start netlogon and an IP config /registerdns. Make sure all of these servers use an internal dns server. (preferably the same while you are trying to solve this problem).
You will be fine, unless all 45 of your clients are accessing the SQL Server at the exact same time, which is extremely rare...
Most of the time you'll have half that number max accessing it, so you should be good.
There is no risk in reinstalling DNS>
Delete the zones, then uninstall the service, reinstall.
Recreate a zone name with the same name as your FQDN.
Point all clients and servers to this box, run a NET STOP NETLOGON/NET START NETLOGON on all domain controllers, and an IPCONFIG /REGISTERDNS on...
The best way to set up Windows permissions is to allow Everyone- Full Control on the SHARE.
For the NTFS permissions on the folders you are sharing (just the root folder needs to be set because of inheritance) -- Properties - Security - Add --> add your users here. Select the modify checkbox...
Todd,
You need to go into Internet Options - Connections - Advanced on your client, make sure the Bypass proxy for locan servers is checked, and add the name of your server into the Exceptions box.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.