August 17, 2005 at 10:55 pm
i would appreciate if some one could me help me on this.
Regards,
Deb
August 18, 2005 at 7:44 am
Throwing out things to try/check:
Has your firewall changed where it would deny port 1433 connections. Example Windows firewall can deny connection to the remote database. If it is turned on, check to make sure that you have an Execption for the Servname and port 1433
Have you tried dropping and re-creating the linked server?
In OSQL are you using -S Servername\Instance name
What is the error in OSQL, is it the same error?
Have you looked at: microsoft kb article on error: Potential causes of the "SQL Server does not exist or access denied" error messagehttp://support.microsoft.com/default.aspx?scid=kb;en-us;328306
August 18, 2005 at 8:14 am
first of all thanks for the reply, as at last i got one reply
1) As i mentioned when i am running it through QA it is running fine, only when i am using osql it is giving problems.
2) i am connecting to the default and the instance was installed for a different reason post which i am facing this problem.
3)yes we tried re adding the linked servers.
4)yes i have gone through the above mentioned link.
August 18, 2005 at 9:58 am
Hi,
check the connection settings, do you connect with the same user in QA and osql?
karl
Best regards
karl
August 18, 2005 at 12:58 pm
you are using -E on osql that would mean that you will need either to setup ACCOUNT DELEGATION in kerberos OR change the connection to use SQL authentication( -U -P) with permissions on the remote server
* Noel
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply