The sql databases are hosted on different boxex than the websites. If I configure an active server page on the website to access the sql database on another server, what username/password would I use?

Is there any problem with trusted connections between the website and database or account delegations problems? For example, annonymous access to the website still uses a user account. If the connection string uses a different user account, will there be a failure to connect?

It should not create any issues. You can get the username and password to access your MS SQL database from your database hosting provider.

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