Posted by war_wheelan on 04/18/07 13:44

On Apr 1, 10:01 am, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@greenms.com> wrote:
> <war_whee...@yahoo.com> wrote in message
>
> news:1175350571.321521.171840@b75g2000hsg.googlegroups.com...
>
> > I've figure out how to reboot the server and make the networked
> > database accessible again. After the reboot, I need to manually
> > restart the SQL Server service.
>
> > Does anyone have an idea why I need to restart the service when I is
> > configured to start automatically? Also is there a way to have this
> > happen automatically via a script of something?
>
> Yes, my guess is that SQL Server is starting BEFORE the workstation service
> (I believe that's the one required) so that UNC shares are not available
> until AFTER SQL Server starts.
>
> Restarting SQL Server works because the drives are available at that point.
>
> You can go into the properties of the SQL Server service and play around
> with dependencies and that should allow you to fix it.
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html


I tried setting the database to auto_close and also tried read_only
which didn't correct the problem. What I mean is I still had to
restart the service when the database was set to read_only, but I was
able to access it. I also found that accessing the tables from the
read_only database was quicker. On the other hand, when I set the
database to auto_close I couldn't access it after a reboot even when
restarting the service. The only was that I was able to access the
database was to remove the auto_close options.

[Back to original message]