WebAdmin tool keeps loosing connection

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: 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: SQL server does not exist or access denied
    ... I know but nevertheless the SQL profiler shows a user SYSTEM with loging ... name NT AUTHORITY\SYSTEM, for the Windows Service. ... Both applications access and update the databases. ... >> The Windows service is supposed to access and update two of the three ...
    (microsoft.public.sqlserver.connect)
  • 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)
  • Re: Windows authentication fails
    ... When I enable mixed mode - everything starts working, because it lets 'sa' to login to database. ... I also added ADMINISTRATOR to all databases and assigned all neccessary rights, but still getting such error windows authentication - not trusted connection. ... It's possible that SQL Server allows windws login, but an application which uses it doesn't like, has different settings somewhere. ...
    (microsoft.public.sqlserver.server)