Could not connect to database?

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Could not connect to database?

Postby chago2011 » Mon Nov 07, 2011 8:02 pm

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?
chago2011
 
Posts: 4
Joined: Thu Oct 13, 2011 6:53 pm
Location: Orlando, FL

Postby chago2011 » Mon Nov 07, 2011 8:36 pm

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.
chago2011
 
Posts: 4
Joined: Thu Oct 13, 2011 6:53 pm
Location: Orlando, FL

Postby chriskelly » Wed Nov 09, 2011 9:16 pm

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?
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests