I'm trying
to convert
an Access database
to use a SQLServer backend. I've upsized the database and everything works on the server, but I'm unable
to access it remotely.
I'm running SQLServer Express 2005 on Windows Server 2003. The server is not configured as a domain controller, nor connected
to a domain. The computers I'm trying
to access the server from are part of a domain, but there are no local domain controllers. I'm at a remote location and the computers are configured and connected
to the domain at the home office, then shipped
to us. We normally log in with cached credentials and VPN into the home office when we need
to access the domain.
I can use Remote Desktop Connection
to access the 2k3 server which is running SQLServer. If I log into the server with my username, I can bring up the database,
access it via the Trusted Connection, and the database works. If I try
to run the database locally, however, I get the Server Login dialog box. I can not use a Trusted Connection because my local login is
to the home office domain and is not recognized by the SQLServer machine. If I try
to use the username/password that is local
to the SQLServer, I get a login failed error. I've tried entering the username as "username", "workgroup/username" (where "workgroup" is the name of the workgroup on the SQLServer), "sqlservername/username" and "
[email protected]" where "1.2.3.4" is the IP of the SQLServer. In all cases, I get a login failed error. As I said, I can login
to the server via Remote Desktop Connection with the same username and password and use the database, so permissions for the username appear
to be correct for both a remote connection and for database
access. Not sure where
to go from here and any assistance would be appreciated.
