cannot connect sql 2008 r2

rwheeler23
rwheeler23 used Ask the Experts™
on
I just added a SQL Server 2008 R2 instance onto  a server and I am tyring to create the DSN to this server using the same ODBC administrator tool that talks to a SQL Server 2005 instance, I am greeted with this message. Is there something I need to do on the W2008 Server to get this connection to work? Do I need to install a SQL Server 2008 R2 client onto the workstation? These two instances are located on separate servers.
NODSN.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Yes, you need a SQL Server 2008 client.  You can't connect to 2008 with a 2005 client.

Greg

Som TripathiDatabase Administrator

Commented:
Hi,
If you are using the instance name to connect -
Check if you have Named pipe Protocol enabled on source server.

You may use Port number if only tcp/ip is enabled. If the Server,Portnumber combination does not work. There might be firewall issue on the box where you are getting error. Open the Port before trying to connect.
You could create an UDL file, to do a connection test.
If it works fine, you are able to connect to the database.

-----------------------
UDL File Creation (If Microsoft Data Link not listed)
If no Microsoft Data Link is listed, the following steps should fix this.

1. Right-click on the desktop, or in the folder where you want to create the file.
2. Select New, then Text Document.
3. Give the Text Document any name with a .udl extension ("Show file extensions" must be enabled in folder options).
4. A window will pop up warning that "If you change a filename extension, the file may become unusable. Are you sure you want to change it?" Select Yes.
5. You have now successfully created a UDL file.

http://digital.ni.com/public.nsf/allkb/1D5EB4DCBD13106486256B9D005E11B0
Som TripathiDatabase Administrator

Commented:
Greg is correct, the driver for SQL Server 2005 could not connect SQL Server 2008-R2. So client is must...
rwheeler23President

Author

Commented:
OK, but can a SQL Server 2005 client peacefully co-exist with a SQL Server 2008 R2 client?
I am just setting up a test environment to move an application  to SQL Server 2008 R2 and I cannot afford to lose connectivity to the SQL Server 2005 instance.
>> OK, but can a SQL Server 2005 client peacefully co-exist with a SQL Server 2008 R2 client? <<
you do not need both.
A «SQL Server 2008 R2 client» can access a «MS SQL Server 2005 instance».
rwheeler23President

Author

Commented:
Yes, but the application I am forced to use has been very touchy about the cleint being used. Will I see a new SQL client appear and will the installtion of the SQL 2008 R2 client leave the already existing DSN's alone?
>> OK, but can a SQL Server 2005 client peacefully co-exist with a SQL Server 2008 R2 client? <<
They do really work fine together.
Chief Database Architect
Commented:
hi
yes you can BUT
very important --the  only thing is your SQL Server Native client will be upgraded to latest version, but if you specifically want both versions of SQL Server Native Client, After installing 2008 R2, download SQL Server Native Client for 2005 from this link and install it
 
http://www.microsoft.com/download/en/details.aspx?id=20101
 
Please select your download based on your computer edition (32 or 64 bit)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial