Re: MSDE connection problem

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

From: Niels (anonymous_at_discussions.microsoft.com)
Date: 11/03/04

  • Next message: Julia: "Can MSDE trigger call a .NET remote object?" 
    Date: Tue, 2 Nov 2004 23:21:18 -0800

    Andrea,
    thanks a lot you for your comment,
    but it don't solve my problem. :-(

    >MSDE runs in it' own security context, usually under
    >the "LocalSystem" account, an administrative Windows
    >account with enought privileges to performs it's
    >assigned tasks... remove that OS
    >privileges for the restricted users...

    Well, that means that running MSDE was not restricted by
    the prvileges for the windows user?
    Why, did I get an different behaivor on diffrent user
    accounts?
    The Installation of MSDE was running on the unrestricted
    account - could this cause the problem?

    >you only need to grant that (restricted) users login
    >to MSDE, and, of course, granting them access to the
    >desired dbs..
    I don't use internal security. All windows users login to
    the database by using the same (SQL) userid. This userid
    have all rights to read and change data.

    I think my problem starts earler, because I see the MSDE
    symbol in the taskbar but it have *no green arrow or red
    rectangle*. It shows only a empty white circle.

    >info on how to accomplish these task via oSql.exe ,
    >the command line tool provided with MSDE
    If i was logged in by the restricted windows user account
    all used tools (inclusive osql.exe) can't create
    connection to the database.

    "osql -L" shows the Name of the MSDE Instance, but trying
    to connect by using the DatabaseuserID by "osql -U myName"
    fails. Using the unrestricted Windowsaccount all works
    fine.

    Do you have any idea what i can do?

    Thanks in advance.
    Niels

  • Next message: Julia: "Can MSDE trigger call a .NET remote object?"

    Relevant Pages

    • Re: How to backup MSDE db to Samba share
      ... System Account, not "sa" (which is not a real Windows ... It has null credentials on the network and therefore does ... You can change the MSDE service to run in a specific account by changing its ... > How can an MSDE database be backed up to a Samba share on a Unix server? ...
      (microsoft.public.sqlserver.msde)
    • Re: Why I use a Mac, anno 2006
      ... (must trim followups... ... no such account exists on Windows ... The typical windows user is logged in an administrator ...
      (comp.sys.mac.advocacy)
    • Re: Timesheet questions
      ... those two or resource accounts to Project Server authentication rather than ... Windows User Account authentication. ... with the person's Project Server user name and password. ... features require Windows User Account authentication for resources to be ...
      (microsoft.public.project.pro_and_server)
    • Re: Server Error in /MyWebForm Application
      ... You know you can buy the Developer Edition of SQL 2000 for under $50. ... I can't find an ASPNET account. ... it will run under the ASPNET user. ... MSDE does NOT come with a GUI. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: ASPNET MSDE account login failure
      ... Your login failure appears to be a result of a failure on MSDE and not IIS. ... You need to ensure that the account accessing the MSDE engine has a login. ...
      (microsoft.public.dotnet.faqs)