rwallacej
asked on
VB Error # -2147467259
Hi
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
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
so you are using Windows Authenticated user to connect. Please check the login user has rights to connect to ther sql server.
ASKER
using Windows Authenticated user to connect: that is correct
login user has rights to connect to ther sql server: the same user can sometimes log-in; another time they can't, just minutes afterward
login user has rights to connect to ther sql server: the same user can sometimes log-in; another time they can't, just minutes afterward
What is your maximum concurrent user connection set to?
Look In Enterprise Manager, right click the server properties->connection tab. Let me know, if is it set to 0 (unlimited) or something else?
Look In Enterprise Manager, right click the server properties->connection tab. Let me know, if is it set to 0 (unlimited) or something else?
ASKER
it is set to zero
ASKER
any more ideas?
AFTER I can no longer connect from VBA in Management studio when I try to connect to database I get message
Error Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details
the files aren't read only
I can see the database but no '+' next to it like the others (or like it after a reboot/during when macros are going fine)
thanks
AFTER I can no longer connect from VBA in Management studio when I try to connect to database I get message
Error Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details
the files aren't read only
I can see the database but no '+' next to it like the others (or like it after a reboot/during when macros are going fine)
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you assyst, issue is resolved
ASKER
The conncetion string is like this:
"Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;Initia