Hello Jeggebeen,

If you have configured an ASP page to access SQL database on another server you need to use your database username and password with database server IP address details.

It would not be an affect if anonymous access to the website. If the connection string uses a correct user account in connection strings then it will be working fine. For example I have posted below mentioned connection strings:

- DSN less connection
Dim SqlConn
Set SqlConn = Server.CreateObject("ADODB.Connection")
SqlConn.ConnectionString="Driver={SQL Server};" & _
"Server=server IP address;" & _
"Database=dbname;" & _
"Uid=username;" & _
"Pwd=password;"
SqlConn.Open
Response.Write "SQL Connection Successful"

Thanks,

Shane G.
AccuWebHosting.Com