Web Data Administrator remote authentication problem

microsoft.public.sqlserver.tools

3 Apr 2006 3:15 PM

Mike C

All,

I'm trying to put in a facility for the remote management of SQL2000
databases using the 2004 version of Web Data Administrator as provided by
Microsoft. This is currently running on an IIS6 server in a virtual root
called Webadmin.

I am able to connect to the SQL server instance on the IIS6 server via SQL
authentication or integrated Windows authentication with no problems. I can
also connect to a remote SQL instance using SQL authentication.

I am however unable to connect to a remote SQL instance via integrated
Windows authentication. I need to be able to do this. The error simply
returns "Invalid username and/or password, you are using a windows login that
is not your own, or server does not exist". None of these scenarios apply.

What is confusing is that everything works fine when I switch to using the
packaged Cassini web server which ships with the Web Data Administrator
application. This then operates on port 111 by default and allows me to
connect to local and remote SQL instance via either SQL or integrated Windows
authentication.

I have tried changing the virtual root from the default "Web" folder to the
"\Samples\SqlWebAdmin" as per some suggestions I've seen elsewhere however
this did not work. I have also copied the WebUIValidation.js from the Service
Pack 1 version of .NET 1.1 as per some other suggestions with no luck.

Can anyone provide any inspiration on this as I need to get it working.

Just for information all SQL servers are running under Windows 2003 server
as is the IIS box, all version of SQL are 2000 SP4.

Thanks.