WebAdmin tool keeps loosing connection

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: karmaahost (karmaahost.15ov2l_at_mail.webservertalk.com)
Date: 05/03/04


Date: Mon, 3 May 2004 11:07:14 -0500


This is very strange and need help on this. We installed SQL Webadmin
from microsoft on to our Windows 2003 standard server. We setup the
databases using Enterprise manager and everything was working fine. We
setup two security logins for each database: [1] Windows Authenticated
for login via web broswer and another [2] SQL Authenticated. This
worked for a while but it stopped working. Now what happens is this,
the users are authenticated via Windows login and they could see the
Web Administrator interface but when they try to login via SQL login
using their SQL login it prompts them 3 times before timing out.

No clue why this is happening. Hope I have explained this as much as I
could. Hope to have some solution on this as this is getting very
frustrating and annoying for our clients and us too.

Why would the permissions resetts on its own.

Thanks
KarmaaHost

--
karmaahost
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message210092.html
 


Relevant Pages

  • Re: Renamed Windows login not found in SQL Server 2000
    ... It's almost like SQL tuck some knowledge away in an area ... of memory that only gets released on Windows stop. ... > I am running SQL Server 2000 SP2 with Windows ... > login gets corrupted) I am unable to add the new login to ...
    (microsoft.public.sqlserver.security)
  • Re: Keeping User From Deleting Table Records
    ... authentication and authenticate with Windows. ... Is this Windows "read" permission ... Windows or is this SQL-assigned read permission done through SQL ... SQL login, and grant only read permissions to that user. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication with multiple roles is only for small apps?
    ... The above statement is true but isn't limited only to Windows logins: ... authentication) and using an application Windows account for SQL Server ... on the middle tier if it uses the same login for all connections. ...
    (microsoft.public.sqlserver.security)
  • Re: how to block local admins
    ... the only way you can block local admins is to NOT grant ... I support the Professional Association for SQL Server ... We tried deny login to ... > seeing data in certain databases without causing all sorts ...
    (microsoft.public.sqlserver.security)
  • Re: moving Windows Embedded Data folder location
    ... Yes you can relocate the location of the DB if you are have Windows admin priveleges on the machine and also are a SQL admin on that machine. ... Back in the SQL Management tool, go to the 'Databases' node, right click and choose 'attach'. ...
    (microsoft.public.windowsxp.embedded)