Wednesday, March 7, 2012

Microsoft Web Data Administrator, hangs on log in

Hi
I have downloaded MS Web Data Administrator to conenct to my MSDE
database. It hangs when i login using "SQL Login"
When i open up Web Data Administrator, it defaults to Port 80 and
Cassini Personal Web Server (the "IIS" button has been disabled).
Once I start Web DA with this information, and enter in the following
under an "SQL login"
Username: sa
Password: ****
Server: myServerName\myMSDEDatabase
and press "Login" it does nothing (seems to hang) and im left on the
log in page...I never get an error message, it just keeps on trying to
log in, i presume.
I am running MSDE on Win 2000 Server. MSDE is set up to use SQL
authentication (instead of Windows)
Any suggestions?
--Pam
Hi, I found this floating around on the web and did as it instructed,
but it still doesn't work!
___________________________________________
Christopher Hill Feb 7, 6:40 am show options
Newsgroups: microsoft.public.sqlserver.msde
From: "Christopher Hill" <min...@.ntlworld.com> - Find messages by this
author
Date: Mon, 7 Feb 2005 03:40:46 -0800
Local: Mon,Feb 7 2005 6:40 am
Subject: SOLUTION: SQL Web Data Administrator hangs on login
Reply to Author | Forward | Print | View Thread | Show original |
Report Abuse
(Also posted to
http://register.microsoft.com/=ADmswish/suggestion.asp)
The SQL Web Data Administrator (available here:
http://www.microsoft.com/downl=ADoad...C03=AD9A798-C=
57...
2A332CB7F959&displaylang=3Den) is a very useful tool, but
there is a problem when it is installed with the .net
Framework 1.1 with Service Pack 1. The copy of
WebUIValidation.js that is included with the Web Data
Administrator is out of date and means that it hangs when
you click the 'login' button. If you copy the updated
WebUIValidation.js file from
WINDOWS\Microsoft.NET\Framewor=ADk\v1.1.4322
\ASP.NETClientFiles into {SQL Web Administrator
installation path}\Web\aspnet_client\system=AD_web\1_1_4322\
then the problem with hanging is instantly solved.
Message to Microsoft: Please could you update the SQL Web
Administrator package to fix this problem?
By the way, this is not my solution - I found it on
http://sqljunkies.com/Forums/S=ADhow...PostID=3D2084.
|||Oops, ID-10-T error (IDIOT error!)
the fix I posted above does work, I must have been copying it in the
wrong spot or the copy hadn't "kicked in" just yet.
But the fix truly does work!
--Pam

No comments:

Post a Comment