Post reply

Connect to a linked server

  • September 5, 2007 at 9:06 am

    #118574

    Hi folks,

    I have read access to a database on a remote server, I am not allowed to write any stored procedure on that database. I am wondering what's the best approach to access data on that server?

    My thought is I will have to create a shell database, I write my stored procedures on it, link the server with the 'read-only' server, specify credential somewhere in my sp, fetch data from there.

    Is that correct? How do I do that? I don't think I should store my user name and password in my stored procedure.

    Thanks in advance.

  • September 5, 2007 at 4:39 pm

    #731642

    Can you use Window authentication? That way you don't need to use your user name and password. If you don't have linked server, then you can use OPENROWSET, otherwise you can use openquery to get data from that server.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply