asked on

SQL Server Remote Connection

I have an MS Access database that I am using to connect to SQL Server. SQL Server is installed on a server running Windows Web Server 2008 OS. If I install the MS Access database on the server, I can connect locally with no problem. Yet when I go to connect from my office PC over the internet it will not connect. The latest error message reads...
SQL State 28000
SQL Error 18452
Login failed for user ''. The user is not associated with a trusted SQL Server Connection.

I am using port 5000 to connect to the server over the internet. I have been told that this port is bing forwarded to the server. I modified the firewall to allow access over ports 1433-1434 and 5000 over TCP/IP and the same over UDP.

PLEASE HELP ME!!!!!!!!!!!!!!!!!!!!

lundnak

Are you connecting to the database with a Windows AD user login or SQL Login? If you are using a Windows AD login, I think it is going to be pretty difficult to connect to SQL Server via the internet as you aren't connected to the same domain.

rawilken

ASKER

I have tried both. It is currently set to SQL and the error I describe is the result.

rawilken

ASKER

The server is not on a domain.

ASKER CERTIFIED SOLUTION

lundnak

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rawilken

ASKER

I am apparently now not getting to the SQL Server at all. I tried creating an IIS ASP connection string. One solution I found in my searches called for one to be establised on the server. I did that and the error messages changed to #53. The error is attached.

rawilken

ASKER

IIS has a connection string for a data source that is tied to SQL Express. Apparently SQL Express is on this server. Did not know that before. IIS connection strings...

rawilken

ASKER

SQL Server name derived from sp_helserver in SQL