I have a visual web part that is calling a database. I’m using a connection string that passes through a SQL account and password to access the DB. This works when trying to access a DB on the same server, but when I try to access a different server I am getting the error
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
The only difference between the two is that the SQL database is located on a different server, so it seems like the credentials aren’t being passed through to the other server.
I’ve had a look online and it’s seems like this is being referred to as the “Double Hop Problem”, but that seems to be related to a windows accounts rather than a SQL Login.
The SQL version is SQL Server 2008. Do I need to specify something in the connection string to pass the credentials through to the other server?