I need help connecting from a blank access 2010 database to my remote SQL Server 2005 database. This is because I'm going to write all my client apps in Access, and store everything on the server with SQL Server. I'm using the wizard, and trying to make a new DSN. What do I put for:
Which SQL Server do you want to connect to?
Server:
The server is windows server 2008, and it is remote. I've been connecting to it with a .RDP file, but I'm not sure how to set up the link. The .RDP connects to mail.blahblahblah.com, where blahblahblah is the domain name. So I put:
mail.blahblahblah.com\SQLEXPRESS
I've also tried:
blahblahblah.com\SQLEXPRESS
I keep getting SQL Server Error: 53, server does not exist or access denied. Could you guys help me figure out what I put for the server name? Thanks
Please ask me to clarify anything that doesn't make sense.
Thanks.