Hi I'm using SQL2000 on a Win2K server. I am having some difficulty configuring the security on the virtual directory for SQLXML I am using the "Configure SQL XML Support in IIS" utility supplied, which has worked perfectly with other installations. On this installation, I can make it work by setting "Always log on as:" to use a SQL Server account (in this case I am currently using 'sa' which I'm not happy about). However, when I change it to use a Windows Login - either using the !USR_MACHINENAME account, or my own Windows account - I cannot get the Database dropdown on the Data Source page to display a list of databases on the server. It WILL do so when using the 'sa' account but not with any of the Windows accounts. Instead it gives a message "Unable to display a list of databases on (local)". Yet I can login to Enterprise Manager and browse the server as myself with full access rights. The machine is patched to hilt, latest SPs etc. If I can make it work using my credentials I can gradually work backwards to getting the !USR_MACHINENAME account to work. Anyone got any suggestions? TIA Feargal
This has been confirmed as a bug by MS "Feargal" wrote in message news:uATWXbG0IHA.2084@TK2MSFTNGP06.phx.gbl... > Hi > > I'm using SQL2000 on a Win2K server. > I am having some difficulty configuring the security on the virtual > directory for SQLXML > > I am using the "Configure SQL XML Support in IIS" utility supplied, which > has worked perfectly with other installations. On this installation, I can > make it work by setting "Always log on as:" to use a SQL Server account > (in this case I am currently using 'sa' which I'm not happy about). > > However, when I change it to use a Windows Login - either using the > !USR_MACHINENAME account, or my own Windows account - I cannot get the > Database dropdown on the Data Source page to display a list of databases > on the server. It WILL do so when using the 'sa' account but not with any > of the Windows accounts. > > Instead it gives a message "Unable to display a list of databases on > (local)". Yet I can login to Enterprise Manager and browse the server as > myself with full access rights. > > The machine is patched to hilt, latest SPs etc. If I can make it work > using my credentials I can gradually work backwards to getting the > !USR_MACHINENAME account to work. > > Anyone got any suggestions? > > TIA > Feargal >
