-
Jul 14th, 2011, 06:09 AM
#1
Thread Starter
Frenzied Member
SSRS Connection question
We have set up DNS names for our sql servers so the name Report server points to a particular instance of sql server on one of our servers. So if we want to repoint all our existing connections to a different server we just change the DNS setting.
This works fine in connection strings such as in c# scripts. However when setting up data sources for SSRS reports it doesnt accept the DNS name as a datasource but requires the actual SQL Server name.
Is there a way around this or is it just an SSRS limitation?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|