Q:

Create ODBC Connection from Access to SQL Server

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.

A:

The server name is the server name.  It should resolve to an IP address via DNS or some other resolution method.  Of course you will need to make sure you can actually reach that address through any firewalls or other devices between you at the server.

