Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
osupratt
Posting Yak Master
238 Posts |
 Posted - 2010-02-23 : 15:25:13
|
| I have read about the OPEN ROWSET or Linked Servers way to pull data from more than one server. I am in an organization where 'for security purposes' i can't use either of those two options.For awhile i was given a nightly SSIS job or package that we worked from and all needed information was placed on one server.Now I am being told that we should develop everything out of SSRS and to use either sub-reports or differing data sets to gather this information. I'm not sure I have ever heard of this as being a best practice or a preffered way of doing things.I hope some of you out there can give me some help in understanding whether this is a good way of doing things and if so why... or a poor way of doing things and in turn the reason why. I just feel some bad design by our corporate IT people is resulting in the way we have been doing things. Obviously i would rather be able to use the Linked Server or OPEN ROWSET options. Is there a way to secure certain databases on servers while having others open to Linked Server or OPEN ROWSET?Thanks for any help or insight you can provide. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-24 : 10:11:10
|
| i dont understand how ssrs replaces openrowset or linked server. SSRS shows data but requires query to be executed at backend to fetch data. so its like a presentation layer for the data------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
osupratt
Posting Yak Master
238 Posts |
Posted - 2010-02-24 : 10:44:28
|
| I need to 'join' things on certain query's. The IT dept. believes that the best way for this is to create a sub-report in SSRS where the parameters =. Does this make sense? I'm telling them that there should be a way using T-SQL to turn on and off Linked Servers in SP's.The IT dept.is afraid that when I create my SP's that I can go across to any server and any database and pull confidential information. Isn't there a way for them to set up some security to where I can't (even by accident) do this? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-24 : 11:00:57
|
| yup. they can set priviledges to objects in other db to give you access to only what you want------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-24 : 11:28:45
|
| ... and if the IT department don't know about that, and don't know how to set it up, its probably wide open now anyway!! |
|
|
|
|
|
|
best practice - query across different servers