MSDE 2000 on MS Server 2003

We have a MSDN subscription so I beleive we can
redistribute MSDE with our App., but can it be installed
on 2003 Server (or any MS Server?).
Apart from the limit of 25 connections and 2GB DB size
are there any other important restrictions?
Thanks
James
Works fine with any of the current OS. I have run it on 2000, xp and 2003.
No issues.
The 25 connections is a bit vague. MS says a 'workload governor', which I
have found to kick in around 15-20 connections.
"James" <james@.xsol.com> wrote in message
news:158501c50d4a$2d2c5bf0$a501280a@.phx.gbl...
> We have a MSDN subscription so I beleive we can
> redistribute MSDE with our App., but can it be installed
> on 2003 Server (or any MS Server?).
> Apart from the limit of 25 connections and 2GB DB size
> are there any other important restrictions?
> Thanks
> James
|||It will work just fine. Just make sure that you upgrade MSDE with SP3,
otherwise Server 2003 will block any access to the MSDE instance.
Jim
"James" <james@.xsol.com> wrote in message
news:158501c50d4a$2d2c5bf0$a501280a@.phx.gbl...
> We have a MSDN subscription so I beleive we can
> redistribute MSDE with our App., but can it be installed
> on 2003 Server (or any MS Server?).
> Apart from the limit of 25 connections and 2GB DB size
> are there any other important restrictions?
> Thanks
> James

MSDE - Rename and ReJoin new Domain

We had to rename our domain and thus, had to re-join the new domain after
MSDE was installed. I am now unable to connect to MSDE. MSDE is installed
on XP 2 on a workstation computer. I'm guessing it has something to do with
the accounts the MSDE is running under. Does anyone know how to get MSDE
running after joining a new domain? Thanks in advance!
hi Brian,
Brian wrote:
> We had to rename our domain and thus, had to re-join the new domain
> after MSDE was installed. I am now unable to connect to MSDE. MSDE
> is installed on XP 2 on a workstation computer. I'm guessing it has
> something to do with the accounts the MSDE is running under. Does
> anyone know how to get MSDE running after joining a new domain?
> Thanks in advance!
the account MSDE is running on has little to do with you unable to connect
to it... it only will (<G>) allow MSDE to run on it's specific machine an so
on... on the contrary, it could now have problems related to it's
impossibility to run the service at all, or connect to remote shares (SQL
Server and SQL Server Agent services) that requires net trusting...
for SQL Server standard login you should not have problem at all...but you
have to verify your domain WinNT logins and WinNT groups logins if still
valid..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for the response, but i think you miss understood what I posted, or I
wasn't very clear. I cannot connect to MSDE but it is not actually starting
up. I undrstand user log in's in SQL Server, however, that is not the issue.
MSDE does not start up properly, my cnfgsvr.out contains this
[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option 'allow
updates' changed from 1 to 0. Run the RECONFIGURE statement to install.
reconfigure with override
Disconnecting from Server ...
Stopping Service ...
This makes me think that the services are running under the wrong Windows,
or possibly Domain user account. For example, if you go to control panel,
admin tools, services, right click SQL AGent and select log on, it is set to
system account by default. I think this may be where the issues is. Thanks
for your help
Brian
"Andrea Montanari" wrote:

> hi Brian,
> Brian wrote:
> the account MSDE is running on has little to do with you unable to connect
> to it... it only will (<G>) allow MSDE to run on it's specific machine an so
> on... on the contrary, it could now have problems related to it's
> impossibility to run the service at all, or connect to remote shares (SQL
> Server and SQL Server Agent services) that requires net trusting...
> for SQL Server standard login you should not have problem at all...but you
> have to verify your domain WinNT logins and WinNT groups logins if still
> valid..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Brian,
Brian wrote:
> Thanks for the response, but i think you miss understood what I
> posted, or I wasn't very clear. I cannot connect to MSDE but it is
> not actually starting up. I undrstand user log in's in SQL Server,
> however, that is not the issue. MSDE does not start up properly, my
> cnfgsvr.out contains this
> [Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
> 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to
> install.
> reconfigure with override
> Disconnecting from Server ...
> Stopping Service ...
> This makes me think that the services are running under the wrong
> Windows, or possibly Domain user account. For example, if you go to
> control panel, admin tools, services, right click SQL AGent and
> select log on, it is set to system account by default. I think this
> may be where the issues is. Thanks for your help
>
I apologise for the misunderstanding...
yes, if the service is not running at all, you probably have problems in the
account running the services.. and yes, accessing the services management
applet and configuring a correct account for the services should do the
trick
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply