I'm connecting to SQL Server using Excel.
Sometimes I get the message
VB Error # -2147467259
Generated by Microsoft OLE DB Provider
Cannot open database '.....' required by the login. Login failed
I get this message even though I don't change credentitals, Excel just decides to not work.
When I get this message, when opening up SQL Serve Management studio, the database is visible but doesn't have a '+' next to it, so can't see tables etc.
A reboot fixes things....
Help please for why this is occuring and how I can avoid having to always reboot, thanks