What are the challenges you face when working across database platforms? Take the survey
Options

Linked server: Authentication required

sleepyheadsleepyhead Posts: 13
edited September 25, 2007 1:10PM in SQL Prompt Previous Versions
When using a linked server SQL prompt asks me to authenticate to the linked server. Usually I do not have access to the linked server when developing from a remote machine thus I must choose 'do not connect'. This works fine but the problem is that every time the cursor is on the line with a linked server SQL prompt asks me to authenticate to the linked server again, again, and again. it never understands 'do NOT connect'. I really hope to see this fixed in the next version.

For me the best thing would be to map linked server ip's to another ip (from internal ip or name to external ip). So SQL prompt would take linked server 'X' and connect to ip 'X.X.X.X' instead. Not sure how useful that is to others though.

Comments

Sign In or Register to comment.