Showing posts with label dns. Show all posts
Showing posts with label dns. Show all posts

Wednesday, March 7, 2012

Installing SQL Reporting in a virtual web

Is there a way to install SQL Reporting in a Virtual Web (which has an
external DNS) on IIS6 so that it can be run like www.<external
DN>.com/Reports ? I've installed it on my SQL server in the default IIS
directory, but want to run reports in the virtual web. Creating a virtual
directory pointing to the SQL Reporting folders do not work. How can I
configure IIS to run SQL Reporting in the Virtual Web?
Thanks.
DanHello,
Install a virtutal web site and add a new virutal directory to the original
folder is not officially support. However, you can refer to the following
article:
Moving Reporting Services' Virtual Directories
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Friday, February 24, 2012

Installing SQL 2005 on servers with DNS

I've looked into installing the SQL 2005 Enterprise beta in my organization to look at it's features and capabilities. We use SQL 2000 today.

My setups weren't successful, and the reason (I think) is that the server I was installing these on is running DNS, because it's a Global Catalog server.

My question is whether this will be an issue going forward in future releases. For example, how would you support SQL 2005 in Small Business Server?

We currently have three servers: one is a global catalog and another is a backup for redundancy reasons. The other server does not run DNS or AD, but it does run Exchange, and we'd prefer not to install SQL on that box. We had installed SQL 2000 previously on either of the AD boxes, and it worked fine, since our query levels are minimal.

Thanks.There is a known issue installing SQL Server 2005 on a domain controller, including Small Business Server. We're currently working on a fix and expect at release to support installation on DCs and SBS. Right now there is no known work around.

Dan