MSDE on a 2k Domain Controller

I have asked this before, but it was a while back and then the project got
put on hold, and I can't find the replies - sorry.
Is there any problems (operationally wise, or conflict wise) with putting
MSDE 2000 A on a Windows 2000 Server which is a domain controller (the
server also has Exchange 2000 and ISA 2000 installed on it)?
I can obviously restrict the memory it can use so that's not a problem, but
I wondered if it would create problems or serious performance issues for the
DC.
Also, if it is OK to install on a DC, is the installation straightforward or
are there any special switches or settings I should use? Or do I just do a
plain install as I would on any machine?
Thanks
Keith
Anyone?
"Keith" <@..> wrote in message news:ehizqISKEHA.3436@.tk2msftngp13.phx.gbl...
> I have asked this before, but it was a while back and then the project got
> put on hold, and I can't find the replies - sorry.
> Is there any problems (operationally wise, or conflict wise) with putting
> MSDE 2000 A on a Windows 2000 Server which is a domain controller (the
> server also has Exchange 2000 and ISA 2000 installed on it)?
> I can obviously restrict the memory it can use so that's not a problem,
but
> I wondered if it would create problems or serious performance issues for
the
> DC.
> Also, if it is OK to install on a DC, is the installation straightforward
or
> are there any special switches or settings I should use? Or do I just do
a
> plain install as I would on any machine?
> Thanks
> Keith
>
|||A no-one responded yet...
Yes, you should be fine. One thing to consider is that your service account is now a domain account. I.e., a
potential security issue. (This is because a DC doesn't have any local accounts.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Keith" <@..> wrote in message news:e2TJLgDLEHA.3704@.TK2MSFTNGP11.phx.gbl...
> Anyone?
>
> "Keith" <@..> wrote in message news:ehizqISKEHA.3436@.tk2msftngp13.phx.gbl...
> but
> the
> or
> a
>
sql

MSDE not working

I have installed MSDE on a computer but when I try to create an odbc
connection to it, I can't find the server in the list.
It seems that it isn't running, but I have checked the service to see if it
is running, and it is.
I am trying this on a system that has SQL Server for developers on it.
Could this be causing the problem?
Can someone point me in the right direction on this?
How are you tring to connect. I take it this is a named instance so what
error do you get if you try and connect with osql e.g.
osql -E -S.\INSTANCENAME
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:_RzIc.19690$yc.8850@.fed1read06...
> I have installed MSDE on a computer but when I try to create an odbc
> connection to it, I can't find the server in the list.
> It seems that it isn't running, but I have checked the service to see if
it
> is running, and it is.
> I am trying this on a system that has SQL Server for developers on it.
> Could this be causing the problem?
> Can someone point me in the right direction on this?
>
>
|||Jasper,
Thanks for responding.
The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
Thanks
Lance
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uS%23G5vEaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> How are you tring to connect. I take it this is a named instance so what
> error do you get if you try and connect with osql e.g.
> osql -E -S.\INSTANCENAME
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Lance Geeck" <lgeeck@.cox.net> wrote in message
> news:_RzIc.19690$yc.8850@.fed1read06...
> it
>

MSDE no access on database objects

I have installed MSDE 2000 A, but I can't edit the database objects (tables,
stored procedures, etc.) in Access 2000. If I try, the window appears only
for a moment.
Any suggestions to solve the problem?
Frank
Hi Frank,
"FAT" <FAT@.discussions.microsoft.com> ha scritto nel messaggio
news:D74106D3-FDF3-4359-9AFA-1DB9A25C809E@.microsoft.com
> I have installed MSDE 2000 A, but I can't edit the database objects
> (tables, stored procedures, etc.) in Access 2000. If I try, the
> window appears only for a moment.
> Any suggestions to solve the problem?
> Frank
I think you've probably better resort on alternate tools.. perhaps Acces
2003, or other 3rd party tools...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||ehm........
please have a look at http://www.microsoft.com/sql/msde/partners/default.asp
and/or http://www.aspfaq.com/show.asp?id=2442 ... google for others..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE limitations

Hallo everybody :)
I cant make anything of MS explanation about MSDE and its limitations.
Could you please tell me, what is the matter ?
Is it true that only five paralell connections are accepted by engine ?
What abouth next ones? They are wainting in the queue ?
Thhanks in advance
regards
plutonYou can have more than 5 connections as the same time. The limitation is
when you have more than 5 queries *executing at the same time*. Then a
performance throttle will limit the throughput.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"pluton" <zielonadupa@.poczta.onet.pl> wrote in message
news:botn03$fbp$1@.news.onet.pl...
> Hallo everybody :)
> I cant make anything of MS explanation about MSDE and its limitations.
> Could you please tell me, what is the matter ?
> Is it true that only five paralell connections are accepted by engine ?
> What abouth next ones? They are wainting in the queue ?
> Thhanks in advance
> regards
> pluton
>|||There are probably MSDE groups which would be a better place to ask, but I
believe MSDE is limited to 5 simultaneous queries, not 5 connections.
hth
Eric
"pluton" <zielonadupa@.poczta.onet.pl> wrote in message
news:botn03$fbp$1@.news.onet.pl...
> Hallo everybody :)
> I cant make anything of MS explanation about MSDE and its limitations.
> Could you please tell me, what is the matter ?
> Is it true that only five paralell connections are accepted by engine ?
> What abouth next ones? They are wainting in the queue ?
> Thhanks in advance
> regards
> pluton
>|||thanks a lot
pluton|||I think there is also a limitation on what the front-end to a MSDE database
can be written. I read somewhere -- possibly the license agreement -- that
front-ends can be written in MS products only (i.e. MS Office, .NET
Framework, etc.)|||pluton wrote:
> Hallo everybody :)
> I cant make anything of MS explanation about MSDE and its
> limitations. Could you please tell me, what is the matter ?
> Is it true that only five paralell connections are accepted by engine
> ? What abouth next ones? They are wainting in the queue ?
> Thhanks in advance
> regards
> pluton
Ignore Erics comments -Tibor is accurate
You have probably seen
http://www.microsoft.com/sql/msde/productinfo/features.asp
What is key is that it will only execute 5 concurrent batches (any
additional ones are deferred) , there is a 2Gb restriction on the size
per DB and it can only participate as a subscriber in transactional
replication scenario.
in future you might find msde specific questions better answered in
microsoft.public.sqlserver.msde
Since both products are so closely related, this newsgroup may serve to
answer your questions also.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||> Ignore Erics comments -Tibor is accurate
Ouch.
"Mark Broadbent" <no-spam-please_mark.broadbent@.virgin.net> wrote in message
news:OSZoAGUqDHA.2584@.TK2MSFTNGP09.phx.gbl...
> pluton wrote:
> > Hallo everybody :)
> >
> > I cant make anything of MS explanation about MSDE and its
> > limitations. Could you please tell me, what is the matter ?
> > Is it true that only five paralell connections are accepted by engine
> > ? What abouth next ones? They are wainting in the queue ?
> >
> > Thhanks in advance
> >
> > regards
> > pluton
> Ignore Erics comments -Tibor is accurate
> You have probably seen
> http://www.microsoft.com/sql/msde/productinfo/features.asp
> What is key is that it will only execute 5 concurrent batches (any
> additional ones are deferred) , there is a 2Gb restriction on the size
> per DB and it can only participate as a subscriber in transactional
> replication scenario.
> in future you might find msde specific questions better answered in
> microsoft.public.sqlserver.msde
> Since both products are so closely related, this newsgroup may serve to
> answer your questions also.
> --
> Br,
> Mark Broadbent
> mcdba , mcse+i
> =============|||Eric Sabine wrote:
> > Ignore Erics comments -Tibor is accurate
> Ouch.
>
> "Mark Broadbent" <no-spam-please_mark.broadbent@.virgin.net> wrote in
> message news:OSZoAGUqDHA.2584@.TK2MSFTNGP09.phx.gbl...
> > pluton wrote:
> >
> > > Hallo everybody :)
> > >
> > > I cant make anything of MS explanation about MSDE and its
> > > limitations. Could you please tell me, what is the matter ?
> > > Is it true that only five paralell connections are accepted by
> > > engine ? What abouth next ones? They are wainting in the queue ?
> > >
> > > Thhanks in advance
> > >
> > > regards
> > > pluton
> >
> > Ignore Erics comments -Tibor is accurate
> >
> > You have probably seen
> > http://www.microsoft.com/sql/msde/productinfo/features.asp
> >
> > What is key is that it will only execute 5 concurrent batches (any
> > additional ones are deferred) , there is a 2Gb restriction on the
> > size per DB and it can only participate as a subscriber in
> > transactional replication scenario.
> >
> > in future you might find msde specific questions better answered in
> > microsoft.public.sqlserver.msde
> > Since both products are so closely related, this newsgroup may
> > serve to answer your questions also.
> >
> > --
> >
> > Br,
> > Mark Broadbent
> > mcdba , mcse+i
> > =============
Sorry Eric! didnt mean to be rude just that the way I read your post it
was slightly misleading to the original question posted. Anyhow no
doubt you'll get lots of chances to get your own back since Im a long
way from infalible LOL.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============

MSDE issue

Can’t a client easily register an instance of MSDE using any third party GUI
or EM and get hold of our data structure? How can I over come this issue, if
I am installing MSDE on client computer?
thanx
hi,
"Job Lot" <JobLot@.discussions.microsoft.com> ha scritto nel messaggio
news:7002631C-B28D-4785-8C16-2EFE5D74BD50@.microsoft.com
> Can’t a client easily register an instance of MSDE using any third
> party GUI or EM and get hold of our data structure? How can I over
> come this issue, if I am installing MSDE on client computer?
> thanx
a MSDE instance can be easly registered as a linked server or in EM, from
remote (as long as the required network protocols are enabled) or local pc,
or using third party tools... as long as login privileges are set to the
logged user or a valid SQL Server login is known...
to access the databases, another issue must be granted (quite easy), that's
to say the logged user (login) is mapped to a valid database user...
if the login (both NT [trusted connections] or SQL Server [requiring "user"
and "pwd" credentials]) is member of WinNT administrators group (and thus)
or sysadmins server roles, he/she can actually do whatever he/she wants as
that membership grants illimitate privileges...
this design is part of the SQL Server security and can not be cut... so you
have to grant minimal privileges (server side) to logins in order to allow
only to specific logins the ability to access you databases..
a good article about security model is presented at
http://www.sql-server-performance.co...l_security.asp and
http://www.microsoft.com/technet/pro.../sp3sec03.mspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Installation Problem

I have installed MSDE on a computer but when I try to create an ODBC
connection to it, I can't find the server in the ODBC list of servers
available.
I am trying this on a system that has SQL Server 2000 for Developers on it
What does appear in the list are the following:
(local)
CRA-SERVER-2
Cra-Server-2
I don't know why there are two servers listed plus local, but all three
point to
the database setup under SQL Server 2000 for Developers.
It appears that MSDE installed properly. When I look in Component Services,
it is listed as MSSQL$CDC2, status = Started, Startup type = Automatic,
Logon as Local System. CDC2 is the instance name that I specified in the
Setup portion of the MSDE install package.
The directories specified all seem to have the files and data structures.
When I run the OSQL -E -S \CDC2 I get an error. The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
When I look at the Task Manager, I have 2 copies of sqlservr.exe running. I
Assume one is for SQL Server 2000 Developer and the other is MSDE. (?)
I am a developer and need an ODBC connection to the database in the MSDE
installed CDC2 server. Can someone point me in the right direction for
resolving
this ODBC/SQL Server problem?
Thanks for your help.
Lance
Does this work with SQL authentication?
Meaning,
Osql -Usa -Ppassword sqlserver\instancename?
If it does, then you might want to check
325022 INFO: MSDE Security and Authentication
http://support.microsoft.com/?id=325022
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

MSDE fail after upgrade from WIN98 to WINXP HOME

Anyone can help?
I installed MSDE in WIN98 and then upgrade to WINXP home, after that, MSDE failure and i can't reinstall MSDE again, already call microsoft support and try something but no help at all.
John
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Not to be rude, but your first mistake was attempting to upgrade Win9x to
XP.
MSDE installed under Win9x is a completely different animal than an
installation on the NT style operating systems. With Win9x there are no
service applications so MSDE runs as a standard application when the system
starts up. When you upgrade your OS to XP there is no magical conversion of
the MSDE installation to it running as a service. Your best bet is to backup
your databases and then manually uninstall MSDE. Microsoft has an article on
how to do this at:
http://support.microsoft.com/default...b;en-us;290991
After uninstalling MSDE re-install it and restore your databases.
Jim
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OzBSSNkjEHA.1404@.TK2MSFTNGP09.phx.gbl...
> Anyone can help?
> I installed MSDE in WIN98 and then upgrade to WINXP home, after that, MSDE
failure and i can't reinstall MSDE again, already call microsoft support and
try something but no help at all.
> John
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
|||Hi Jim,
Thanks for your advice, i will try it !!
John

>--=AD=EC=A9l=B6l=A5=F3--
>Not to be rude, but your first mistake was attempting to=20
upgrade Win9x to
>XP.
>MSDE installed under Win9x is a completely different=20
animal than an
>installation on the NT style operating systems. With=20
Win9x there are no
>service applications so MSDE runs as a standard=20
application when the system
>starts up. When you upgrade your OS to XP there is no=20
magical conversion of
>the MSDE installation to it running as a service. Your=20
best bet is to backup
>your databases and then manually uninstall MSDE.=20
Microsoft has an article on
>how to do this at:
>http://support.microsoft.com/default.aspx?scid=3Dkb;en-
us;290991
>After uninstalling MSDE re-install it and restore your=20
databases.
>Jim
>"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in=20
message[vbcol=seagreen]
>news:OzBSSNkjEHA.1404@.TK2MSFTNGP09.phx.gbl...
home, after that, MSDE
>failure and i can't reinstall MSDE again, already call=20
microsoft support and[vbcol=seagreen]
>try something but no help at all.
newsgroup engine
>supports Post Alerts, Ratings, and Searching.
>
>.
>

MSDE Environment

Dear all,
i'm new in MSDE, yet, after i'd installed for MSDE ReleaseA which i
get from SQL web site, i realise that I can't run the MSDE without
fully SQL server install, may i know that whether i can run MSDE
without fully SQL SERVER install? if so, how to use it...
pls give me some guide on that, thanks in advance!! :wink:
MSDE IS Sql Server, and does not need full SQL Server installed (otherwise,
why MSDE?). MSDE Download does not come with good document on how to install
it properly for user who does not have experience on SQL Server. I recommend
search MS Knowledge base with key word "MSDE" to get get more detailed
installation guide.
"themafia907" <themafia907@.yahoo-dot-com.no-spam.invalid> wrote in message
news:JMSdnRvJOr2GFYTfRVn_vA@.giganews.com...
> Dear all,
> i'm new in MSDE, yet, after i'd installed for MSDE ReleaseA which i
> get from SQL web site, i realise that I can't run the MSDE without
> fully SQL server install, may i know that whether i can run MSDE
> without fully SQL SERVER install? if so, how to use it...
> pls give me some guide on that, thanks in advance!! :wink:
>
|||Hi
When you run the MSDE Setup, it installs the SQL Server MSDE Edition Engine.
No tools are supplied with MSDE.
Full editions of SQL Server is not required to run MSDE. MSDE is an stripped
down Edition of SQL Server.
What are you trying to achive?
Regards
Mike
"themafia907" wrote:

> Dear all,
> i'm new in MSDE, yet, after i'd installed for MSDE ReleaseA which i
> get from SQL web site, i realise that I can't run the MSDE without
> fully SQL server install, may i know that whether i can run MSDE
> without fully SQL SERVER install? if so, how to use it...
> pls give me some guide on that, thanks in advance!! :wink:
>