Connection error for sqlserver rake db:migrate

Question

I am getting the following error:

Open
OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
HRESULT error code:0×80020009
Exception occurred.

I have tried following the directions here with no luck.

Any ideas?

FIXED

My specific issue I believe was related to having to many mixed systems installed on my laptop. I had Visual Studio 2005 and 2008 components and SQL Server Management Standard loaded with SQL Server Express Edition as well as various other components that might have affected the stability of my environment. Once I reloaded Vista and went back through the steps from the link above it worked without issue.

I only loaded the Express Editions of SQL Server and SQL Server Management Studio.

What version of SQL server are you using? Could you post your database.yml? — hectorsq
– hectorsq, Commented Oct 4, 2008 at 2:44

Cade Roux · Accepted Answer · 2008-09-30 21:39:12Z

1

Usually a authentication/permissions error.

Is the SQL Server on the same box as the web server, review the accounts they are running under, and review the type of connection you are making (integrated or otherwise)?

answered Sep 30, 2008 at 21:39

Cade Roux

90.1k42 gold badges186 silver badges268 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Orion Edwards · Accepted Answer · 2008-10-01 00:39:05Z

0

Random guess: By default SQL Server (express, at least anyway) does NOT enable network access. The SQL Admin manager tools connect to it using named pipes, however rails most likely will be trying to use TCP.

answered Oct 1, 2008 at 0:39

Orion Edwards

125k67 gold badges248 silver badges341 bronze badges

Comments

FortunateDuke · Accepted Answer · 2009-02-25 20:06:13Z

0

My specifc issue I believe was related to having to many mixed systems installed on my laptop. I had Visual Studio 2005 and 2008 componets and SQL Server Managment Standard loaded with SQL Server Express Edition as well as various other componets that might have effected the stability of my envirnomnet. Once I reloaded Vista and went back through the steps on http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServer it worked without issue.

I only loaded the Express Editions of SQL Server and SQL Server Management Studio

answered Feb 25, 2009 at 20:06

FortunateDuke

1,1533 gold badges14 silver badges27 bronze badges

Collectives™ on Stack Overflow

Connection error for sqlserver rake db:migrate

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related