Hi ,
I develop all my sql code locally, and have set up two linked servers, which I can successfully query whilst logged on with Windows authentication.
If I login with the sql logons (which are mirrored on the two linked servers both usernames are the identical and passwords also) I have created for the applications I am writing, 1 server (non clustered) correctly responds with the dataset and the other server (clustered) keeps telling me SQL Server does not exist or access denied.
On the server which says access denied, I can login to this box with the sql username and password and execute the query successfully, but it will not let me run the queries from my local development pc.
Can anyone help or does anyone have any suggestions on what to check?
thanks in advance.
I develop all my sql code locally, and have set up two linked servers, which I can successfully query whilst logged on with Windows authentication.
If I login with the sql logons (which are mirrored on the two linked servers both usernames are the identical and passwords also) I have created for the applications I am writing, 1 server (non clustered) correctly responds with the dataset and the other server (clustered) keeps telling me SQL Server does not exist or access denied.
On the server which says access denied, I can login to this box with the sql username and password and execute the query successfully, but it will not let me run the queries from my local development pc.
Can anyone help or does anyone have any suggestions on what to check?
thanks in advance.
