Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
 Posted - 2005-05-09 : 07:31:31
|
| I run stored procedure from VB6 application and use the connectioncon.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Test;Data Source=MYSYS"This works correctly if the QA points to some other Database. When QA is in Test Database, I get the error from VB application saying[b]Run time error '-2147467259(80004005)'Cannot open Database requested in Login 'Test'. Login fails.Any reason?MadhivananFailing to plan is Planning to fail |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-05-09 : 09:43:31
|
| The error is fairly descriptive.Does your user have permission and a login in the test database on the test box?-------Moo. :) |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-09 : 09:48:37
|
| Problem solved. It is in Single user mode. But I wonder how it was changed to single user mode. Is there any way to check this from QA?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Login fails