We help IT Professionals succeed at work.
Get Started

How do i add an OBDC connection?

CCtech
CCtech asked
on
295 Views
Last Modified: 2012-05-10
I have attached the .mdf and .ldf files to a new database in Microsoft SQL Server Manager Express studio using the sp_attach_db command. The database seems to have been created using the old files from another server without any problem. When i try to create an OBDC connection to the database i recieve the error:

Connection Failed:
SQL state: '01000'
SQL server error: 53
[microsoft][ODBC SQL server driver][DBNETLIB]Connection Open
(connect()).
Connection Failed:
SQL state: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][ODBCNETLIB] SQL Server does not exists or access is denied

This is the first sql database i have tried to create, could i have missed a step?
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE