Re: msde under user group accounts

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

From: Jim Young (thorium48_at_hotmail.com)
Date: 02/26/05


Date: Fri, 25 Feb 2005 22:54:46 -0800

The user or group that needs to connect to the MSDE instance needs to have
login access to the server and permissons on the database.

See the Books Online for sp_addlogin, sp_grantlogin and sp_grantdbaccess.

These are the stored procedures you will use to allow other users besides
the local administrator to connect to the server.

Jim

"Jason" <jlewis@hotmail.com> wrote in message
news:eRC7go2GFHA.4084@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> I installed msde2000a under an administrator account and changed some
> folderpermissions as said in the baseline analyzer.
>
> If i switch to a limited user account, i cannot access the database. Also
> the services do not appear in sql services management panel.
>
> Does someone had this problem before and could solve it? If so, let me
> know.
>



Relevant Pages

  • Re: Error 21008 "Login Already Exist"
    ... To add a user to a database you should be using sp_grantdbaccess. ... have already granted the login access to the server, you do not need to do ... >I get an error message when i try to add a user to a different database on ... > the same server. ...
    (microsoft.public.sqlserver.security)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)