I am moving a well functioning database (classic asp and MySQL) from one server to another (classic asp and SQL Server).
I have trouble making it work. I changed the connection string as it should be, but when testing a login page that connects to SQL, then I get a time out and the usual 500 - internal server error.
I use classic asp with SQL Server with no issues on another server setup. I used the same concept as there. Here's the connection string:
That setup never failed for me.
On this particular server I question if the created user (the user in the connection string) on the SQL server has got enough rights. The admin only checked "public" for "Database role membership". On a server I control I had to check more options to make it work. Is "Public" enough?
Can anyone help me with some trouble shooting?
Is there a simple code I can use to test the connection from an asp-page to the SQL Server?