MSDE Limits

I know from experience that when the number of concurrent users on an MSDE
database exceeds the limit, an error is logged and the workload govenor
kicks in. Does something similar occur when the 2 GB limit is exceeded? I
had the experience yesterday where an application stopped responding for no
apparent reason. It's MSDE database was near 2 GB and the only thing we
could figure was that MSDE was trying to extend the database past 2GB.
Unfortunately there was no error logged, either from MSDE or from my
application.
MSDE will not allow you to extend the size of the database beyond 2GB. There
is no limit on the size of the log file, but there will be an inherent limit
on insert transactions due to the limit on the database size. If your
database has reached 2GB you should still be able to query data or perform
deletes or updates (as long as the update don't tigger an extent). If MSDE
failed to create an extent then there should be an log entry created in the
SQL Server log.
Jim
"Andy Walldorff" <andyw@.REMOVEsuperior.net> wrote in message
news:OfI6oIJHEHA.3288@.TK2MSFTNGP12.phx.gbl...
> I know from experience that when the number of concurrent users on an MSDE
> database exceeds the limit, an error is logged and the workload govenor
> kicks in. Does something similar occur when the 2 GB limit is exceeded?
I
> had the experience yesterday where an application stopped responding for
no
> apparent reason. It's MSDE database was near 2 GB and the only thing we
> could figure was that MSDE was trying to extend the database past 2GB.
> Unfortunately there was no error logged, either from MSDE or from my
> application.
>
|||Thanks
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:uxhZEINHEHA.4092@.TK2MSFTNGP11.phx.gbl...
> MSDE will not allow you to extend the size of the database beyond 2GB.
There
> is no limit on the size of the log file, but there will be an inherent
limit
> on insert transactions due to the limit on the database size. If your
> database has reached 2GB you should still be able to query data or perform
> deletes or updates (as long as the update don't tigger an extent). If MSDE
> failed to create an extent then there should be an log entry created in
the
> SQL Server log.
> Jim
> "Andy Walldorff" <andyw@.REMOVEsuperior.net> wrote in message
> news:OfI6oIJHEHA.3288@.TK2MSFTNGP12.phx.gbl...
MSDE
> I
> no
>

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...
>
>.
>

MSDE Event ID 208/17055 (Newbie)

Hello,
We get these events logged every night, apparently when
the SQLAGENT tries to do it's backup. I'm afraid I
didn't configure MSDE on this particular server, and I
don't have any Enterprise Mgr functions on the desktop,
so I'm slightly at a loss as to how to go about resolving
this issue, being that I'm a noob when it comes to SQL.
Any advise, help or pointers would be great.
A pint goes to the first correct answer!
Andy Griggs.
Hello,
If you have another computer with Entreprise manager, you can donnect to the
msde by the network..
Marc Allard
"Andy Griggs" <andrew.griggs@.agile-it.net> a crit dans le message de
news:20dd701c459ec$940620c0$a101280a@.phx.gbl...
> Hello,
> We get these events logged every night, apparently when
> the SQLAGENT tries to do it's backup. I'm afraid I
> didn't configure MSDE on this particular server, and I
> don't have any Enterprise Mgr functions on the desktop,
> so I'm slightly at a loss as to how to go about resolving
> this issue, being that I'm a noob when it comes to SQL.
> Any advise, help or pointers would be great.
> A pint goes to the first correct answer!
> Andy Griggs.