Re: msde under user group accounts
From: Jim Young (thorium48_at_hotmail.com)
Date: 02/26/05
- Next message: Andrea Montanari: "Re: MSDE install"
- Previous message: Stephen Bishop: "Return value 3"
- In reply to: Jason: "msde under user group accounts"
- Messages sorted by: [ date ] [ thread ]
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.
>
- Next message: Andrea Montanari: "Re: MSDE install"
- Previous message: Stephen Bishop: "Return value 3"
- In reply to: Jason: "msde under user group accounts"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|