Connecting .net 1.0 to SQL Server 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

Connecting .net 1.0 to SQL Server 2005

Author

Topic

dbradley
Starting Member

9 Posts

Posted - 2008-04-19 : 17:24:17

I have a VB.Net Winform application installed at a client’s site using .net 1.0 and sql server 2000. I am in the process of upgrading to them to sql server 2005. The installation of sql server 2005 is on a different machine then the 2000 version. I have installed SQL Server 2005, SP2 and converted the database from SQL Sever 2000. Everything is good at this point. I can even establish a connection through a user’s login.

The Problem is when I try to connect from a client machine using my .net 1.0 application. The client test machine that I am using is a Windows NT Server which may have something to do with the problem. Any way I am getting the following error message.

SSL Security error

From other topics I have read I believe this is something to do with a certificate. The application only needs to connect from within the local network. I have tried connecting using the ODBC Data Sources tool from the client machine I get the following error.

Microsoft SQL Server ODBC Driver Version 03.81.9001

Running connectivity tests...

Attempting connection
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security error

TESTS FAILED!

Should I be using the TCP/IP?
Do I need to install anything on the client machines?
Do I need to open ports on the firewall?
Is there anything else that I am overlooking?

Thanks,

David

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-19 : 18:07:36

Install sql2k5 client on the machine.