Linked server: Authentication required
sleepyhead
Posts: 13
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.
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
Does it work to go into SQL Prompt's settings and turn the support for distributed queries off when the linked server connection is not available?