Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 7th, 2005, 10:37 PM
Registered User
 
Join Date: Nov 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL XML Support in IIS

When you right click on a virtual directory and select properties a dialog window is displayed. There is a tab called Data Source. There are two text boxes: one for the path of the SQL Server and the other for the database name.
I have selected the SQL server using the browse button. That works fine.
However the pull down window gives me an error messge:
"Unable to display the list of databases on .... (it names the correct server).
Can anybody suggest some causes for this problem? I am using an account with admin privledges.

Thanks


 
Old November 9th, 2005, 01:10 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

YOU may be using an account with Admin privileges, but the DATABASE needs an account with the proper privileges. I think that might do it.

HTH

P.S. Let me know cause I have to do this soon.


mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Relational SQL Data to XML - Vet SQL/ASP - New XML JimiTheJett XML 1 December 4th, 2008 06:06 PM
Error-Object does not support doesn't support this bootsy Classic ASP Basics 1 May 25th, 2008 07:14 PM
.net2.0 support sql server 2000 MunishBhatia ASP.NET 2.0 Professional 0 March 29th, 2007 05:25 AM
does visual C++ support SQL script davidwong Visual C++ 1 August 17th, 2004 02:30 AM
Server side transformation with- XSL/XML, ASP, IIS kenneth02 Classic ASP XML 3 November 10th, 2003 10:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.