Red Gate forums :: View topic - Could not connect to database?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

Could not connect to database?

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
chago2011



Joined: 13 Oct 2011
Posts: 4
Location: Orlando, FL

PostPosted: Mon Nov 07, 2011 8:02 pm    Post subject: Could not connect to database? Reply with quote

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?
Back to top
View user's profile Send private message
chago2011



Joined: 13 Oct 2011
Posts: 4
Location: Orlando, FL

PostPosted: Mon Nov 07, 2011 8:36 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 329
Location: Cambridge, UK

PostPosted: Wed Nov 09, 2011 9:16 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group