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!!!!!!!!!!!!!!!!!!!!
rawilkenAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lundnakCommented:
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.
0
rawilkenAuthor Commented:
I have tried both. It is currently set to SQL and the error I describe is the result.
0
rawilkenAuthor Commented:
The server is not on a domain.
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

lundnakCommented:
Can you check the SQL Server Error log?  Does it display an invalid login error message during the time you attempted to login?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rawilkenAuthor Commented:
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.  New SQL Connection Error
0
rawilkenAuthor Commented:
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...  
0
rawilkenAuthor Commented:
SQL Server name derived from sp_helserver in SQL Server instance
0
rawilkenAuthor Commented:
Here is IIS strings...ooops IIS Connection strings
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if the machine you want to connect from is NOT on the same or a trusted domain, you cannot use Windows based logins, but SQL logins.
for this, you need to have both:
* a SQL login created (that is not based on windows authentication)
* the sql instance to actually ALLOW the sql logins : this is called mixed authentication
 => usually, the error you get means that this second setting is not set as needed, or that if it is set, the sql instance has not yet been restarted to take that parameter into account.
0
rawilkenAuthor Commented:
I figured out what the problem was. I was assigning it to a port the wrong way. Once I changed it the connection worked perfectly.
0
rawilkenAuthor Commented:
The comments awarded points sent me in a direction that did result in finding a solution.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.