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  SQL Server 2005 Forums  SQL Server Administration (2005)  Encrypt Connections from Access 2007 to SQL 2008?

Author  Topic  Des Starting Member 7 Posts Posted - 2010-01-12 : 12:38:47 Hi, Is it possible to force Access 2007 to encrypt connections to SQL Server 2008? The SQL server is configured properly with SSL and works with SSMS. To configure a connection for Access I am using a System DSN within ODBC and trying to force it over the port SQL is currently using (61789). I am able to setup the DSN and test a connection successfully. When I try using the connection within Access, it fails with: "[DBNETLIB][CONNECITONOPEN (Connect()).] specified sql server not found." I haven’t found any information that suggests encrypting the connection is possible so I’m wondering if it’s supported. Please advise. Des