Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Bug: insufficient permissions when bringing database online

I have 60+ databases in my development environment, so keep all of them offline unless required.

If I bring a database online (using SSMS, right click, Tasks, Bring Online) SQL Source Control shows the error:

"Could not connect to the database. The database may be offline, or you may have insufficient permissions."

With the "complete error message" showing as...

"Cannot open database "xxx" requested by the login. The login failed. Login failed for user "xxx\xxx"."

I have access into the database, and can do anything I want with it - but the only way I can get SQL Source Control to work is to restart SSMS.

Despite sending multiple error reports to red-gate, this is still happening in 3.7.0.16 using SQL Express 2005.

6 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Stonefish shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Stonefish commented  ·   ·  Report

    Over six month, and this is still not fixed??

    On the surface of it, this seems like such a simple issue - but I'm well aware that things are not always what they appear.

    It boils down to this...

    If a database is offline, when you click on it to bring it online SQL Source Control shows that it is unavailable (fair enough).

    But then once it's been brought online SQL Source Control does NOT re-check to see if it is available yet.

    Do I really have to restart SSMS each and every time???