I have an ASP application that has been running for years where it accesses a remote SQL Server and retrieves data. Unfortunately, the server was turned off, the database moved, without telling me. I am now trying to recreate the access to the new location of the SQL Server. The SQL Server is setup with mixed mode authentication. I have created a Login called cewebuser and given it the password of letmein. The following is my ASP code:
connectionString = "Provider=SQLOLEDB;Server=220.127.116.11;Database=vwiexport;User ID=cewebuser;Password=letmein"
Set checkVWI = Server.CreateObject("ADODB.Connection")
All I get is:
Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'cewebuser'.
I have mapped port 1433 in my router so that the SQL Server requests are routed through to the server.
How can I make this work?