Options

Could not connect to database?

chago2011chago2011 Posts: 5
edited November 9, 2011 3:16PM in SQL Source Control Previous Versions
Using SSC 2.2.1.23. Connecting to a database running SQL Server Express 2005 on my own laptop as SA. This account has sysadmin privs and is able to go into the database and do whatever.

SSC starts churning and after about 45 seconds, it fails and gives me an error:

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

Under "Show complete error message" it says:

==
Cannot open database "eDataHub" requested by the login. The login failed.
Login failed for user 'sa'.
==

I'm getting the impression it's timing out. This is a fairly large database. But it should be reading just the schema, right? Also, other than tables, there are no other objects in this database (i.e., no views, procs, etc).

Any idea what's going on?
· Share on Twitter

Comments

  • Options
    chago2011chago2011 Posts: 5
    The problem... resolved itself.

    I'd been wrestling with this issue since Friday, including a couple of hours today. I rebooted the laptop, restarted SSMS countless times, etc, etc.

    While on the phone with support (of course!), I decided to right click on one of the tables (in SSMS) and select "Design" immediately after the SSC timed out on me. And, right after the table design grid came up, SSC updated with all the tables that needed to be checked into SVN.

    Now there is no timeout, even if I restart SSMS. Go figure.
    · Share on Twitter
  • Options
    chriskellychriskelly Posts: 378
    It's good to hear that you have been able to solve the problem.

    If you refer to the SQL error log, are there any messages in there? Or lots of messages previously which then stop when you manage to get SSC working?
    · Share on Twitter
Sign In or Register to comment.