We are running MS SQL 2005 on Windows Server 2003. We are storing one of our MS SQL databases on a NAS device. It is working quite well except for one minor problem. Whenever the MS SQL machine restarts, MS SQL is not able to access the NAS device. To fix,
all I have to do is restart MS SQL (not the machine, just the database server) and then it works fine again until the next time the machine restarts.
It is as though, when the machine is starting, MS SQL starts before the machine is ready to do TCP/IP file sharing. I suppose the solution is to delay the starting of MS SQL until the machine is ready to network. I would appreciate suggestions for introducing
such a delay.
View Complete Post