Different connection string - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Different connection string

Author

Topic

pssumesh2003
Starting Member

35 Posts

Posted - 2012-06-15 : 04:11:22

Hi all

can i set differnt connection string of a shared datsource to differnt
users?

Please help ..I am using ssrs 2005

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-06-15 : 09:59:23

quote:
Originally posted by pssumesh2003

Hi all

can i set differnt connection string of a shared datsource to differnt
users?

Please help ..I am using ssrs 2005

I assume you are not referring to the credentials portion of the connection string. If you are, SSRS lets the user provide the credentials. But, as far as I know, other portions of it - server name, Initial Catalog etc. are not configurable on a per user basis in a single data source.

It is sort of hard for me to visualize the business need for using different connection strings on the same data source based on the user. Can you describe why you need to do this? May be someone on the forum could suggest alternatives.

pssumesh2003
Starting Member

35 Posts

Posted - 2012-06-15 : 23:46:20

i have two application with 2 databse running reports on same report server.
if i use one connectionstring other will not work. this is my issue. can you tell me any solution?

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-06-16 : 07:40:35

quote:
Originally posted by pssumesh2003

i have two application with 2 databse running reports on same report server.
if i use one connectionstring other will not work. this is my issue. can you tell me any solution?

Two applications, each with its own database, but the reports are on the same report server AND they use the SAME reports? If they are different reports, of course, you can have different connection strings for each report, but if they need to use the same report, I can't think of anything straightforward.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources