TCP/IP file sharing component
i need identify service (if that's indeed need do) handles file sharing on tcp/ip.
we running ms sql 2005 on windows server 2003 , storing 1 databases on nas device. working quite except whenever ms sql machine restarts, ms sql not able access nas device. fix, have restart ms sql (not machine, database server) , works fine again until next time machine restarts.
it though, when machine starting, ms sql starts before machine ready tcp/ip file sharing. suppose solution delay starting of ms sql until machine ready network. need know of many services this. can configure ms sql not start until networking service started.
any thoughts? or if going down wrong path, corrections?
no, kb 2015754 not address specific problem.
i have solved running batch file during computer startup:
sleep 60 sc stop sqlserveragent sleep 5 sc stop mssqlserver sleep 5 sc start mssqlserver sleep 5 sc start sqlserveragent
Windows Server > Platform Networking
Comments
Post a Comment