MSDE instance not running

I have a MSDE installation on a computer with XP
Professional. When logged in to the computer with an
administrator account, the instance of the server runs and
my application works properly. But when logged in as any
user type other than an administrator, the SQL server
doesn't run and, of course, neither does my application.
The computer may ultimately be used by multiple users and I
am interested in being able set up a user(s) to work with
the software without having administrative privileges on
the computer.
Thank you,
Mack Harris
Your MSDE instance is probably setup with Windows authentication and no
logins other than the default ones. SQL Server is running it is just that
other users besides those in the Administrators group cannot connect to the
server. If you want to keep using only Windows authentication you will need
to add logins to the server instance for the users or a group that the users
are a member of and allow them access to your applications database. You
could also switch the instance to use mixed mode authentication and setup
some SQL logins for the users.
"Mack Harris" <mack.harris@.agconnections.com> wrote in message
news:137501c5147d$314e9bf0$a601280a@.phx.gbl...
>I have a MSDE installation on a computer with XP
> Professional. When logged in to the computer with an
> administrator account, the instance of the server runs and
> my application works properly. But when logged in as any
> user type other than an administrator, the SQL server
> doesn't run and, of course, neither does my application.
> The computer may ultimately be used by multiple users and I
> am interested in being able set up a user(s) to work with
> the software without having administrative privileges on
> the computer.
> Thank you,
> Mack Harris
|||I beleive the instance was installed in mixed mode because
SECURITYMODE=SQL is in the setup.ini used on the computer.
When I go to the SQL Service Manager, the Server field is
blank, the Services field is blank, and a "Not Connected"
message is at the bottom of the dialog.
I have been looking at Local Security Settings on the
computer so I could create/modify a windows user group but
I can't find the necessary documentation to do that.
I appreciate your help,
Mack Harris

>--Original Message--
>Your MSDE instance is probably setup with Windows
authentication and no
>logins other than the default ones. SQL Server is running
it is just that
>other users besides those in the Administrators group
cannot connect to the
>server. If you want to keep using only Windows
authentication you will need
>to add logins to the server instance for the users or a
group that the users
>are a member of and allow them access to your applications
database. You
>could also switch the instance to use mixed mode
authentication and setup
>some SQL logins for the users.
>
>"Mack Harris" <mack.harris@.agconnections.com> wrote in
message
>news:137501c5147d$314e9bf0$a601280a@.phx.gbl...
>
>.
>