Avatar of marksmithy69

asked on 

Problems Connecting to Database With ODBC

I am a total newbie to SQL Server, so I am a little lost.  I have a SQL Server 2005 database on server A.  Because Server A is being decommissioned, I had to copy the database to server B, which I have done (both have SQL Server 2005 installed).  I am able to log into the new database with no problems etc.

I have a separate client server which has to connect to the new database using ODBC.  When I try and connect to the database using ODBC, I get an error stating that the database cannot be found.  The database is named exactly the same as on the old server.  I am able to connect to the old database using the same client machine, using the same database name with no issues.

Am I missing something?  Like I said, I am brand new to SQL Server.  This is the first time I have tried copying a database.  Thanks everyone.
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
Ted Bouskill
Avatar of marksmithy69


I was playing around with the configuration, and i selected 'TCP/IP Only', so now I can connect to the database.  But now I am getting a 'Login Failed For User' error.  When you copy a database, do the security permissions have to be reset?  Thanks.
Avatar of Ted Bouskill
Ted Bouskill
Flag of Canada image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft SQL Server 2005
Microsoft SQL Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo