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

Microsoft Web Data Administrator

I have download this Front End because MSDE doesnt ship with an Visual
Interface,
i have installed MSDE2000 i believe is MSDE200a
when i installed i pass the SAPWD parameters to the setup and all was
fine...
but i cant loggin with the user SA with no password.
Even if i made an UDL File, i cant connect with that user, i have to check
login USING WINDOWS NT Integrated Security...
:S
how can i connect with the SA user with no password
________________________________
Juan Carlos Garcia
Santo Domingo, Republica Dominicana
hi Juan,
"Juan Carlos Garcia" <AskMePlease@.AskMePlease.Com> ha scritto nel messaggio
news:O%23buOQdmEHA.704@.TK2MSFTNGP09.phx.gbl...
> I have download this Front End because MSDE doesnt ship with an Visual
> Interface,
> i have installed MSDE2000 i believe is MSDE200a
> when i installed i pass the SAPWD parameters to the setup and all was
> fine...
> but i cant loggin with the user SA with no password.
> Even if i made an UDL File, i cant connect with that user, i have to check
> login USING WINDOWS NT Integrated Security...
> :S
> how can i connect with the SA user with no password
if you can not connect using SQL Server authentication at all, this usually
means that only Windows Authentication is enabled for that instance, and you
have to manually enable it, modifying a Windows registry key, as explained
in http://support.microsoft.com/default...b;en-us;285097
if you can connect with SQL Server authentication, but want to clear the sa
password to a blank password, you can execute
EXEC sp_password @.new = 'am301065' , @.loginame = 'sa'
but I strongly warn you not to do it... a strong password always is your
best friend
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Jaun
Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank passwords?
Rich
"Andrea Montanari" wrote:

> hi Juan,
> "Juan Carlos Garcia" <AskMePlease@.AskMePlease.Com> ha scritto nel messaggio
> news:O%23buOQdmEHA.704@.TK2MSFTNGP09.phx.gbl...
> if you can not connect using SQL Server authentication at all, this usually
> means that only Windows Authentication is enabled for that instance, and you
> have to manually enable it, modifying a Windows registry key, as explained
> in http://support.microsoft.com/default...b;en-us;285097
> if you can connect with SQL Server authentication, but want to clear the sa
> password to a blank password, you can execute
> EXEC sp_password @.new = 'am301065' , @.loginame = 'sa'
> but I strongly warn you not to do it... a strong password always is your
> best friend
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Thks.. for the help for both of you... but finally i have to Uninstall and
Install again passing this parameters : setup SAPWD = "****"
SECURITYMODE=SQL
and know its working... :D
thks.. again... see you..
________________________________
Juan Carlos Garcia
Santo Domingo, Republica Dominicana
"Richard Yeo" <RichardYeo@.discussions.microsoft.com> escribi en el mensaje
news:D66748B5-F213-4251-9B5F-E050B681AD08@.microsoft.com...
> Jaun
> Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank
passwords?[vbcol=seagreen]
> Rich
>
> "Andrea Montanari" wrote:
messaggio[vbcol=seagreen]
check[vbcol=seagreen]
usually[vbcol=seagreen]
you[vbcol=seagreen]
explained[vbcol=seagreen]
sa[vbcol=seagreen]
|||hi Richard,
"Richard Yeo" <RichardYeo@.discussions.microsoft.com> ha scritto nel
messaggio news:D66748B5-F213-4251-9B5F-E050B681AD08@.microsoft.com...
> Jaun
> Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank
passwords?
yes it does, but, at install time, you have to force the BLANKSAPWD=1
parameter in order to accept it... an again, I strongly recommend not to
allow blank pwd policies
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Microsoft SQL Web Data Administrator

I have installed this and I cannot access my MSDE Instance. Any ideas?
The instance of my DB is running.
My Server Manager Says that it is running, Services says that it is running,
but I cannot get to the SQLServer (On my own pc) with the Web Data
Administrator or TOAD for SQL Server.
|||It is quite possible that it is running on a non-standard port not 1433.
Open up a console window and type following
PROMPT> telnet localhost 1433
if you see a blank screen that means the server is listening. If you get
an error that means that it is listening on a different port
Joe Tobey wrote:
> I have installed this and I cannot access my MSDE Instance. Any ideas?
> The instance of my DB is running.
|||It is listen in on a different PORT...how do I change that?
"Dennis Black" wrote:

> It is quite possible that it is running on a non-standard port not 1433.
> Open up a console window and type following
> PROMPT> telnet localhost 1433
> if you see a blank screen that means the server is listening. If you get
> an error that means that it is listening on a different port
>
> Joe Tobey wrote:
>
>
|||To determine the port MSDE is using, run the SQL Server Network Utility
on the machine hosting the MSDE instance. The SQL Server Network
Utility can be found at \Program Files\Microsoft SQL
Server\80\Tools\Binn\svrnetcn.exe.
On the general tab, select the your MSDE instance. Select TCP/IP and
press the Properties button and look at the port
Dennis
Joe Tobey wrote:[vbcol=seagreen]
> It is listen in on a different PORT...how do I change that?
> "Dennis Black" wrote:
>