MSDE to SQL

When scaling a system's back end from MSDE to the enterprise version of SQL
what types of issues or concerns would you watch for?
ThanksI am sure there are tons of white papers on this, but I dont suspect that
you'll experience any huge hurdles.
MSDE is essentially a throttled down version of the SQL Server Engine.
"Because it is fully compatible with other editions of SQL Server,
developers can easily target both SQL Server and MSDE 2000 with the same
core code base. This provides a seamless upgrade path from MSDE 2000 to SQL
Server if an application grows beyond the storage and scalability limits of
MSDE 2000."
http://www.microsoft.com/sql/msde/p...fo/overview.asp
Greg Jackson
PDX, Oregon|||Miles,
MSDE IS SQL Server... You should have no problems at all...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:5A4CD4C1-9923-436B-B711-C3F702A505DB@.microsoft.com...
> When scaling a system's back end from MSDE to the enterprise version of
SQL what types of issues or concerns would you watch for?
> Thanks

MSDE to SQL

When scaling a system's back end from MSDE to the enterprise version of SQL what types of issues or concerns would you watch for?
ThanksI am sure there are tons of white papers on this, but I dont suspect that
you'll experience any huge hurdles.
MSDE is essentially a throttled down version of the SQL Server Engine.
"Because it is fully compatible with other editions of SQL Server,
developers can easily target both SQL Server and MSDE 2000 with the same
core code base. This provides a seamless upgrade path from MSDE 2000 to SQL
Server if an application grows beyond the storage and scalability limits of
MSDE 2000."
http://www.microsoft.com/sql/msde/productinfo/overview.asp
Greg Jackson
PDX, Oregon|||i have a MS Windows 2003 Enterprise Edition but i don't have PDC installed so i don't have a domain in the LAN, i installed SQL Server 2000 on this server, but the clients ( MSDE 2000 ) can not se the SQL server.
My cuestion is , i have to install a pdc and then mount SQL server , and add the clients to the domain
"Jaxon" wrote:
> I am sure there are tons of white papers on this, but I dont suspect that
> you'll experience any huge hurdles.
> MSDE is essentially a throttled down version of the SQL Server Engine.
> "Because it is fully compatible with other editions of SQL Server,
> developers can easily target both SQL Server and MSDE 2000 with the same
> core code base. This provides a seamless upgrade path from MSDE 2000 to SQL
> Server if an application grows beyond the storage and scalability limits of
> MSDE 2000."
>
> http://www.microsoft.com/sql/msde/productinfo/overview.asp
>
>
> Greg Jackson
> PDX, Oregon
>
>|||MSDE doesn't have network access enabled by default. Enable using svrnetcn.exe.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Visual FoxPro programmer" <VisualFoxProprogrammer@.discussions.microsoft.com> wrote in message
news:927CFF5D-751E-4040-AF0D-B3896E64D68C@.microsoft.com...
> i have a MS Windows 2003 Enterprise Edition but i don't have PDC installed so i don't have a
domain in the LAN, i installed SQL Server 2000 on this server, but the clients ( MSDE 2000 ) can not
se the SQL server.
> My cuestion is , i have to install a pdc and then mount SQL server , and add the clients to the
domain
>
> "Jaxon" wrote:
> > I am sure there are tons of white papers on this, but I dont suspect that
> > you'll experience any huge hurdles.
> >
> > MSDE is essentially a throttled down version of the SQL Server Engine.
> >
> > "Because it is fully compatible with other editions of SQL Server,
> > developers can easily target both SQL Server and MSDE 2000 with the same
> > core code base. This provides a seamless upgrade path from MSDE 2000 to SQL
> > Server if an application grows beyond the storage and scalability limits of
> > MSDE 2000."
> >
> >
> > http://www.microsoft.com/sql/msde/productinfo/overview.asp
> >
> >
> >
> >
> > Greg Jackson
> > PDX, Oregon
> >
> >
> >|||Miles,
MSDE IS SQL Server... You should have no problems at all...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:5A4CD4C1-9923-436B-B711-C3F702A505DB@.microsoft.com...
> When scaling a system's back end from MSDE to the enterprise version of
SQL what types of issues or concerns would you watch for?
> Thanks

MSDE to MSDE Replication

Hi,
I would like to know if I can do Replication from a MSDE 2000 to another
MSDE 2000 system (one way).
All I need to do is Sync Server database changes on to a Workstation
database(Real-Time).
Let me give an example.
We have Server and Workstation product. Our Server will have a LiveConfig db
and each workstation will have a localLookupDB(basically same as
LiveConfig). I know If I have the Server as Std SQL Server 2000 I can use
Replication to propogate changes onto workstation what if the Server is
MSDE?
Are there any ways to Replicate data From a Server database onto Workstation
database (Real-Time).
Your advice is appreciated.
Thanks
Arun
You can use merge replication for msde to msde. You can use snapshot,
transactional or merge replication to MSDE from SQL Server 2000. Your
latency may be in the order of minutes.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Arun Kumar" <arunpv@.hotmail.com> wrote in message
news:ObTva%232pFHA.748@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I would like to know if I can do Replication from a MSDE 2000 to another
> MSDE 2000 system (one way).
> All I need to do is Sync Server database changes on to a Workstation
> database(Real-Time).
> Let me give an example.
> We have Server and Workstation product. Our Server will have a LiveConfig
db
> and each workstation will have a localLookupDB(basically same as
> LiveConfig). I know If I have the Server as Std SQL Server 2000 I can use
> Replication to propogate changes onto workstation what if the Server is
> MSDE?
> Are there any ways to Replicate data From a Server database onto
Workstation
> database (Real-Time).
> Your advice is appreciated.
> Thanks
> Arun
>
|||Thanks for the reply.
If I do use merge replication from MSDE to MSDE what are the drawbacks?
Are there any other ways you can suggest for replicating data from one
server to another? (or one to many MSDE)
Thanks
Arun
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23KmSQu3pFHA.820@.TK2MSFTNGP09.phx.gbl...
> You can use merge replication for msde to msde. You can use snapshot,
> transactional or merge replication to MSDE from SQL Server 2000. Your
> latency may be in the order of minutes.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Arun Kumar" <arunpv@.hotmail.com> wrote in message
> news:ObTva%232pFHA.748@.TK2MSFTNGP12.phx.gbl...
> db
> Workstation
>

MSDE SP4 Upgrade problem

Recently when I try to upgrade my current MSDE2000 (SP3a) to SP4 in Windows
XP – SP2, the system just keep on failing me. He is the scenario:
1. Download the MSDE 2000 SP4 from Microsoft site
2. Extract the MSDE SP4
3. Run the following command via command prompt or batch file:
echo off
echo "Start to Upgrade MSDE SP4 ... "
setup.exe /UPGRADESP SQLRUN INSTANCENAME=JSNG SECURITYMODE=SQL
UPGRADEUSER=sa UPGRADEPWD=Th3B3st /L*v c:\MSDE_Log.log
echo "SP4 Upgrade Process completed!"
4. Once the above batch file was run, the standard configuration
screen (gathering information) will be triggered
5. However, after a while the installation will just stopped (before
the title of the windows has changed to show the instance name)
6. When I checked on the verbose log, I have found out that the failure
of the installation is due to the system has failed to configure the server.
PFB for the last few rows of the verbose log:
=== Logging stopped: 8/22/2006 17:36:49 ===
MSI (c) (90:88) [17:36:49:865]: Note: 1: 1729
MSI (c) (90:88) [17:36:49:865]: Product: Microsoft SQL Server Desktop Engine
-- Configuration failed.
MSI (c) (90:88) [17:36:49:865]: Grabbed execution mutex.
MSI (c) (90:88) [17:36:49:865]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (90:88) [17:36:49:865]: MainEngineThread is returning 1603
=== Verbose logging stopped: 8/22/2006 17:36:49 ===
7. Since this is the configuration error, so I have tried to locate
the cnfgsvr.out and hope to get some hints from there, but unfortunately the
config server file is still not updated yet where it still keep the old info
during the installation of MSDE 2000 SP3a.
8. When I try to locate the error (value = 3), I have found out the
its due to the system has detected blank sa password, but I am sure that the
password that I has provided is correct. PFB for the error recorded in the
verbose log:
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{EFB70B01-B1F3-4960-AB69-4A280084A60C}
Starting custom action UpgDetectBlankSaLogin()
Entering Function MyMsiEvaluateCondition
MsiEvaluateCondition for VersionNT returned TRUE
End Function MyMsiEvaluateCondition
An error was encountered during connection to server: 1
Ending custom action UpgDetectBlankSaLogin().
Action ended 9:37:45:
UpgDetectBlankSaLogin.2D02443E_7002_4C0B_ABC9_EAB2 C064397B. Return value 3.
Action ended 9:37:45: INSTALL. Return value 3.
Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(S): SqlDataDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlProgramDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlInstanceName = EASYSHIP
Property(S): SqlSecurityMode = SQL
Property(S): SqlSa...
Property(S): SqlDisableNetworkProtocols = 0
Property(S): SqlDoUpgrade = 1
Property(S): ProductName = Microsoft SQL Server Desktop Engine (EASYSHIP)
Property(S): VersionNT = 501
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1
Property(S): DefaultUIFont = Tahoma8
9. I have even try to use a different command line and yet it failed.
PFB for the alternative command line that I have used:
setup.exe /UPGRADESP SQLRUN INSTANCENAME=JSNG SECURITYMODE=SQL SAPWD=Th3B3st
/L*v
10. I have tried the same in a Windows 2000 Std Server - SP4, and yet it
failed.
During my testing, I have closed down all SQL related activities, including
the followings:
1. Microsoft OutLook
2. SQL Agent Service
3. Easyship Scheduler
But I still experience the above.
I have tried to re-run the same in one of my fresh Windows XP (in virtual
machine), and everything just works fine. Could it be any unclean registry
entry that fail this? Or could it be any software component that is
incompatible with this? Does it have anything to do with the version of MS
Installer being installed in my machine? FYI, I have installed the latest MS
Installer 3.1 before when I tried to install SQL Express, however after I
have remove it, the problem still persist.
Do you have any idea on the above? PFA for the versbose log.
HI,
I am also facing the same issue in my domain.
Unable to find much details.
Is your issue resolved?If yes kindly help me out.
Thanks in advance,
Harish K
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
|||HI,
I am also facing the same issue in my domain.
Unable to find much details.
Is your issue resolved?If yes kindly help me out.
Thanks in advance,
Harish K
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
sql

MSDE Setup Failed

Need Help !!!!

I'm trying to install MSDE on my computer - Dell 2.4 ghz
Operating system is Windows XP Professional.
I have already installed the WEB Matrix but having problems installing MSDE.
I keep getting this error message.

I receive this error message:

(Setup failed to configure the server. Refer to the server error logs and setup error
logs for more information.)

Thanks In AdvanceSigh. Setting up MSDE is one of the most complex things that Microsoft has imposed on us.

What do the logs say? They're usually a pretty good source of information.

Don|||Hi Don,
Thanks for taking the time, Here's the latest log I found. see if this can help?
Thanks again

Jeff

2003-08-02 18:32:43.26 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2003-08-02 18:32:43.26 server Copyright (C) 1988-2002 Microsoft Corporation.
2003-08-02 18:32:43.26 server All rights reserved.
2003-08-02 18:32:43.26 server Server Process ID is 1592.
2003-08-02 18:32:43.26 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2003-08-02 18:32:43.28 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2003-08-02 18:32:43.29 server SQL Server configured for thread mode processing.
2003-08-02 18:32:43.29 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2003-08-02 18:32:43.32 spid3 Warning ******************
2003-08-02 18:32:43.32 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2003-08-02 18:32:43.32 spid3 Starting up database 'master'.
2003-08-02 18:32:43.78 server Using 'SSNETLIB.DLL' version '8.0.760'.
2003-08-02 18:32:43.79 spid5 Starting up database 'model'.
2003-08-02 18:32:44.01 server SQL server listening on 192.168.0.2: 1433.
2003-08-02 18:32:44.03 server SQL server listening on 127.0.0.1: 1433.
2003-08-02 18:32:44.09 spid3 Server name is 'CDISLAND'.
2003-08-02 18:32:44.09 spid3 Starting up database 'msdb'.
2003-08-02 18:32:44.59 spid5 Clearing tempdb database.
2003-08-02 18:32:45.54 spid5 Starting up database 'tempdb'.
2003-08-02 18:32:45.78 spid3 Recovery complete.
2003-08-02 18:32:45.78 spid3 SQL global counter collection task is created.
2003-08-02 18:32:45.79 spid3 Warning: override, autoexec procedures skipped.
2003-08-02 18:32:46.28 server SQL server listening on TCP, Shared Memory, Named Pipes.
2003-08-02 18:32:46.28 server SQL Server is ready for client connections
2003-08-02 18:32:54.10 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.|||Finally got it to work, here's what I did:

·Went to my Add/Remove Programs located in Control Panel.
·Removed MSDE from the Add/Remove Programs.
·Went to my C Drive and removed/deleted the (sql2ksp3 folder)
·Next I went to my Programs files folder and also removed/deleted the (Microsoft SQL server) folder.
·Then Restart computer, and reinstall (sql2ksp3) again – thus eliminating the roll back error

Reinstalling sql2kDesksp3
·Double clicked on sql2kDesksp3 bringing up the installation wizard
·And just followed the installation instructions.
·Now your asked to specify where the files in the SQL2KdeskSP3.exe should be unpacked. Leave the default value, C:\sql2ksp2.
·Once this step is complete the installation wizard will quit.
·Next go to Start, Run, and type in cmd and this opens the command prompt. And enter your commands here.
·Type in cd\sql2ksp3 and hit enter
·Next type dir and hit enter
·Next type cd MSDE and hit enter
·Next type dir and hit enter
·Next type setup SAPWD=password SECURITYMODE=SQL and hit enter
And Installation will begin – this may take a few minutes.

Note: where “password” is the password you want for the administrative MSDE account. [Make sure that you write down and remember your password. You will
Need to provide this supplied password when working with MSDE.

After installation is complete, Restart your computer. Upon returning to Windows, you
Should see a new icon in your system tray. The icon will look like a computer tower with a green arrow in a white circle. That's your Done.

Hope this helps Somebody
Cheers!!|||Thanks loads it has helped me...|||Cool! Glad you got it worked out!

Don

MSDE Service Manager on XP Pro SP2

I recently installed MSDE 2K on a Windows XP SP2 system. Everything appears
to be working fine, with the exception of the service manager. For some
reason, it will not find the system on the local network and will not
connect to it if I type the name in the server name area. Is this normal or
am I just missing something? Thanks in advance.
hi David,
"David Young" <cdyoung@.uta.edu> ha scritto nel messaggio
news:eBToEMg3EHA.3840@.tk2msftngp13.phx.gbl
> I recently installed MSDE 2K on a Windows XP SP2 system. Everything
> appears to be working fine, with the exception of the service
> manager. For some reason, it will not find the system on the local
> network and will not connect to it if I type the name in the server
> name area. Is this normal or am I just missing something? Thanks in
> advance.
actually, for local instances connections, WinXP sp2 should not be a
problem, but only for remote connections :D
as regard the Service Manager not showing the instance name, this is a known
issue when network protocols are disabled (default setting) as you can see
in http://support.microsoft.com/default...b;EN-US;814132
as regard directly typing in the instance name... did you provide the name
in the ComputerName\InstanceName format ( or just (local)\InstanceName) ?
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 Release A

Dear Experts,
I heard that MSDE Release A removes the limitation of 7 concurrent
queries that affect MSDE when too many users connecting to the system at
the same time. Is this correct?
Thank you very much
No, Release A does not make any changes to the Query Governor. You are
probably confusing this with SQL Server 2005 Express Edition which replaces
MSDE. Express does not have a Query Governor.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:OspP3bHVGHA.5332@.TK2MSFTNGP10.phx.gbl...
> Dear Experts,
> I heard that MSDE Release A removes the limitation of 7 concurrent queries
> that affect MSDE when too many users connecting to the system at the same
> time. Is this correct?
> Thank you very much
sql

MSDE Release A

Dear Experts,
I heard that MSDE Release A removes the limitation of 7 concurrent
queries that affect MSDE when too many users connecting to the system at
the same time. Is this correct?
Thank you very muchNo, Release A does not make any changes to the Query Governor. You are
probably confusing this with SQL Server 2005 Express Edition which replaces
MSDE. Express does not have a Query Governor.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:OspP3bHVGHA.5332@.TK2MSFTNGP10.phx.gbl...
> Dear Experts,
> I heard that MSDE Release A removes the limitation of 7 concurrent queries
> that affect MSDE when too many users connecting to the system at the same
> time. Is this correct?
> Thank you very much|||Thank you very much. This answers my question

MSDE ON WINDOWS XP - Unable to determine system default collation.

Please help Me,
I need Install MSDE2000 On Windows XP, but this message is show in the proces
Product: Microsoft SQL Server Desktop Engine -- Unable to determine system default collation.Are you running Windows XP Pro or Home?|||Please help Me,

I need Install MSDE2000 On Windows XP PRO, but this message is show in the proces

Product: Microsoft SQL Server Desktop Engine -- Unable to determine system default collation.|||Have you tried to logon with a user with administrator privileges?|||Originally posted by Dynatoz
Have you tried to logon with a user with administrator privileges?

Yes, I using the Administrator Acount

MSDE on CD

Is it possible to run MSDE from a CD ROM? What I want to
do is create a system using the SQL Server. First, I want
to create a process using DTS to import a text file into
SQL Server. Then from there write a program in VB to
manipulate that data from the sql server. I want to run
all this from a CD-ROM. Is this possible? What would I
need to run the app from the CD? Would the client need to
install any files to run the sql server or vb app? ANy
and all help would be appreciated.
Mike
hi Mike,
"Mike" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1123001c4166a$f6c84140$a001280a@.phx.gbl...
> Is it possible to run MSDE from a CD ROM? What I want to
> do is create a system using the SQL Server. First, I want
> to create a process using DTS to import a text file into
> SQL Server. Then from there write a program in VB to
> manipulate that data from the sql server. I want to run
> all this from a CD-ROM. Is this possible? What would I
> need to run the app from the CD? Would the client need to
> install any files to run the sql server or vb app? ANy
> and all help would be appreciated.
> Mike
SQL Server must be installed on a pc in order to run it... it can be
installed remotely and you can connect from a remote client, but it must be
installed somewhere on the LAN... you can partially store the databases on
CD (please have a look at
http://msdn.microsoft.com/library/de...es_03_92hx.asp)
but the core engine and all system stuffs must be installed..
VB apps also require all VB runtime and dependencies to be locally
installed... you can then run your app from a CD, but all related VB stuffs
have to be installed and properly registered...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE not upgraded to full version

We have a customer that has MSDE 2000 loaded on his machine. They are
running SBS 2003 Premium, so we took the SQL 2000 CD that came w/ the
system and went to load SQL Server 2000. Well, it didn't give me the
ooption of the default instance.
How can I upgrade the default instance of MSDE to a full version of SQL
Server 2000? Or did i just miss something in the installation?
Darin
*** Sent via Developersdex http://www.developersdex.com ***Never mind - I didn't read the screens inthe setup - I needed to select
UPGRADE.
duh
Darin
*** Sent via Developersdex http://www.developersdex.com ***|||"Darin" <darin_nospam@.nospamever> wrote in message
news:ufd7BopEIHA.3548@.TK2MSFTNGP06.phx.gbl...
> We have a customer that has MSDE 2000 loaded on his machine. They are
> running SBS 2003 Premium, so we took the SQL 2000 CD that came w/ the
> system and went to load SQL Server 2000. Well, it didn't give me the
> ooption of the default instance.
> How can I upgrade the default instance of MSDE to a full version of SQL
> Server 2000? Or did i just miss something in the installation?
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***
You cannot upgrade. You have to install a new instance and then restore or
reattach your existing data to it.
--
David Portas

MSDE not starting properly

I have MSDE come up when my system boots, but the server name does not appear
in the 1st dropdown box. So, I have to type the server name in and click the
start button in the MSDE window to get it to come up. I just want it to
start at boot-up, and be there without having to type the server name in
every time. Help.
You have the following options:
1. Add the following statement to Win.ini
Run = "SCM -Action 1 -Service mssqlserver -Silent"
2. Run the following in DOS:
REM modify SCM
SCM -Action 7 -Service mssqlserver -SvcStartType 2 -Silent
REM start sql service now
SCM -Action 1 -Service mssqlserver -Silent
"Tom Nowak" <TomNowak@.discussions.microsoft.com> wrote in message
news:BB6F9956-3BD9-4B00-A332-A5D79EC1ABAB@.microsoft.com...
> I have MSDE come up when my system boots, but the server name does not
appear
> in the 1st dropdown box. So, I have to type the server name in and click
the
> start button in the MSDE window to get it to come up. I just want it to
> start at boot-up, and be there without having to type the server name in
> every time. Help.

MSDE memory Usage

It seems that the MSDE running SP3a is eating up about 100MB every few days
on my system. Once I reboot it settles down but starts it up again. Is
there a memory leak? Is there a way to calm down the SQLSERVER.EXE memory
usuage?
Thanks
The SQL Server 2000 database engine is designed to take advantage of as much
memory as it can without impacting other applications. If other applications
start running on the computer the database engine will dynamically release
memory for their use. You can also tailor how much memory the database
engine uses by setting configuration options.
For more information, see:
http://msdn.microsoft.com/library/?u...asp?frame=true
Alan Brewer [MSFT]
Content Architect
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

MSDE Installation

I have tried intalling MSDE on 2 machines and on each of
them after the installation i get the small server icon
running in system tray, but the circle is white and says
cannot connect.
Thanks
Hi ezahnle,
Try double-clicking on the icon and then, in the spot for a servername, try
your computer name and then click connect. If you specified an INSTANCE NAME
while installing, you'll need to put:
computername\instancename
instead.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"ezahnle" <anonymous@.discussions.microsoft.com> wrote in message
news:1b2001c5016d$d4bf0a40$a401280a@.phx.gbl...
>I have tried intalling MSDE on 2 machines and on each of
> them after the installation i get the small server icon
> running in system tray, but the circle is white and says
> cannot connect.
> Thanks
>

MSDE Install problem

I installed MSDE SP3A with sapwd=abc123 instancename=msde_1. I went to services and started mssql$msde_1 and sqlagent$msde_1. In the system tray, I clicked the sql service manager. I put msde_1 in the server name and hit refresh services, but I get an error stating "The Network Path was not found".

Can someone give me a clue as to what I am doing wrong?

I'm new to MSDE and would like to use it with MSACCESS Projects.This folder should exist and contain the log file if the MSDE Service actually could start at all: C:\Program Files\Microsoft SQL Server\LOG

Now, if you don't have a service called MSSQL$msde_1, then the installation failed. Please review the installation log file.|||Unistall, the try this option
create a file named "Settings.ini"

[Options]
SAPWD=YourPassword
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
DATADIR="C:\MSDE"
TARGETDIR="C:\MSDE"

then run this from command promt or create a .bat file

setup.exe /settings Settings.ini /L*v C:/MSDELog.log|||I reinstalled with listed settings and Instancename= MSDE01. I do have a service called MSSQL$MSDE01 which I started. I have also started the service SQLAgent$MSDE01.

The problem I am now getting is on trying to open a new project in MSACCESS. It pops up with a SQL Server logon screen. I have the Trusted Connection checked, and nothing appears in the Server Name dropdown list box. I have typed both MSSQL$MSDE01 and MSDE01 as the server name, but in both cases I get the following error:

Connection failed:
SQLState:'01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection Failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.|||I don't speak very good english
See the attached image.

MSDE install

Dear Everybody,
When i am installing MSDE 2000 Release A on Windows XP Professional System.
It gives me Error "Invalid Instance Name".
What I done wrong please help me.
Ashok
hi,
Ashok wrote:
> Dear Everybody,
> When i am installing MSDE 2000 Release A on Windows XP Professional
> System. It gives me Error "Invalid Instance Name".
>
can you please provide the command line you passed to the setup.exe boostrap
installer?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 BLANKSAPWD=1
Here the instance name is NetSDK.
Once you are instlled successful with this instance name NetSDK, if you want
to install again with the same instance name, you need to remove instance.
"Ashok" wrote:

> Dear Everybody,
> When i am installing MSDE 2000 Release A on Windows XP Professional System.
> It gives me Error "Invalid Instance Name".
> What I done wrong please help me.
> Ashok
>
>

MSDE for Small Network System

Is it appropriate of using MSDE for peer to peer network system of a few computers, commercially?
All computers are working on Windows XP Pro, sharing DB each other via MSDE.
Are there anyone to advice us regarding the technical problems or licence problems?
Hi,
You can use MSDE on the peer to peer network. There are no licensing
issues, as MSDE is available free of cost and can be freely downloaded from
http://www.microsoft.com/sql/msde/do...s/download.asp
The technical issues that you may face are
1. There is not frontend for MSDE. you can use Web Data Administrator tool.
It can be downloaded from
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
2. The data size in MSDE is limited to 2GB. The data cannot grow beyond 2
GB in an MSDE database.
3. MSDE has a workload governor that gets activated when there are more
than 8 process running simultaneously on an instance of MSDE. The workload
governor slows down the response of the MSDE instance. However, it does not
stop from multiple users using it. for more information on Workload
governor please visit
http://msdn.microsoft.com/library/?u.../8_ar_sa2_0ciq
.asp?frame=true
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

MSDE for free?

Im searching for a SQL server that is free.

I have programed a ASP system that Im now intend to sell.

But the problem is that it needs to run on SQL and therefor im searching for a SQL server that is free to use.

And I found out that MSDE is free.

Now Im wondering if I can use this for the ASP system I intend to sell?

I wont make any money on MSDE, becaus the costumers will pay for the ASP and not the SQL. Is this possible?Check the following links:

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=7840&pg=2

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/usingmsde.asp

http://msdn.microsoft.com/vstudio/downloads/addins/msde/deploying.aspx|||Thank you... that was a greate help for me...

MSDE Error 18456

Hi,
Read a lot about the above mentioned error.
But I don't understand the solutions.
About the operating system I an a novice too.
Installed MSDE a few times before the server Icon with the green errow apered.
Deinstalled MSDE 2000 a few times and removed also the directories.
Some in this newsgroup mentioned that there are entries in the registry that
should be deleted. But about the registry I am a novice.
Is there another solution to make a clean install.
Henk
hi Henk,
Henk wrote:
> Hi,
> Read a lot about the above mentioned error.
> But I don't understand the solutions.
> About the operating system I an a novice too.
> Installed MSDE a few times before the server Icon with the green
> errow apered. Deinstalled MSDE 2000 a few times and removed also the
> directories.
> Some in this newsgroup mentioned that there are entries in the
> registry that should be deleted. But about the registry I am a novice.
> Is there another solution to make a clean install.
about the folders and registry entries to be deleted, you can have a look at
http://support.microsoft.com/default...EN-US;Q290991, which
completely remove an MSDE instance from a pc but for the presence orphaned
Windows Installer registry entries.. for the latter you have to use
MsiZap.exe, part of the Windows Installer SDK, as indicated in
http://support.microsoft.com/default...b;en-us;320873
unfortunately there's no other "manual" method to clean a system..
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
|||"Andrea Montanari" schreef:
Knip
Thank you Andrea,
Your suggestion helped me a lot.
But I can't connect to the database.
I like to connect a database with Visual basic.net (standard) trhough a
sql data adaptor,wich invokes a wizard.
I choose New. connection.
Servername=PC_name
Login = Username
Passw = Userlogin passw
The next error appeared.
Login Failed for user.
What I am doing wrong.
Sorry but I am a novice and a little bit slow in understanding.
Henk.
|||hi Henk,
Henk wrote:
> But I can't connect to the database.
> I like to connect a database with Visual basic.net (standard) trhough
> a sql data adaptor,wich invokes a wizard.
> I choose New. connection.
> Servername=PC_name
> Login = Username
> Passw = Userlogin passw
> The next error appeared.
> Login Failed for user.
> What I am doing wrong.
> Sorry but I am a novice and a little bit slow in understanding.
i hope the exception raised continue with " .. not associated with a trusted
SQL Server connection"
if this is the case you have to understand that MSDE installs by default on
WinNT platform enabling only trusted authenticated connections..
you can modify this behaviour both at install time, providing the
SECURITYMODE=SQL parameter to the setup.exe MSDE boostrap installer, or
later, at run-time, accessing the Windows registry and modifying the
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
LoginMode=2
for a default MSDE instance, or
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
LoginMode=2
for a named instance...
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
|||"Andrea Montanari" schreef:

> hi Henk,
> Henk wrote:
> i hope the exception raised continue with " .. not associated with a trusted
> SQL Server connection"
> if this is the case you have to understand that MSDE installs by default on
> WinNT platform enabling only trusted authenticated connections..
> you can modify this behaviour both at install time, providing the
> SECURITYMODE=SQL parameter to the setup.exe MSDE boostrap installer, or
> later, at run-time, accessing the Windows registry and modifying the
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> LoginMode=2
> for a default MSDE instance, or
> HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
> LoginMode=2
> for a named instance...
> --
> 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 your quick reply.
I am not used to change any thing in the registry.
I found the next entrys.
Defaultlogin Reg_SZ guest
Loginmode Reg_Dword 0X00000000(0)
Should I Change 0X00000000(0) into 2
But during setup I gave the next parameter in: SecurityMode=SQL
Henk.
|||"Henk" schreef:

>
> "Andrea Montanari" schreef:
>
> I am not used to change any thing in the registry.
> I found the next entrys.
> Defaultlogin Reg_SZ guest
> Loginmode Reg_Dword 0X00000000(0)
> Should I Change 0X00000000(0) into 2
> But during setup I gave the next parameter in: SecurityMode=SQL
> Henk.
>
I tried the above mentioned settings.
But nothing worked.
Tried the next thing.
Removed MSDE2000 through
Start-Config-Software-MicrosoftSQLMSDe
Removed
Restart
Manually removed Map Microsoft SQL Server
within map MSSQl
Map-Log
New install MSDE200
Installed MSDERelA
setup SAPWD=Sapassword SecurityMode=SQL
Restart
Server Runs
Registery check
Loginmode=0
DefaultLogin = guest.
Manually Loginmode=2 changed
Tried again in VB.net
Login failed for user.
I tried everything but nothing works.
Henk
|||hi,
Henk wrote:
> I tried the above mentioned settings.
> But nothing worked.
> Tried the next thing.
> Removed MSDE2000 through
> Start-Config-Software-MicrosoftSQLMSDe
> Removed
> Restart
> Manually removed Map Microsoft SQL Server
> within map MSSQl
> Map-Log
> New install MSDE200
> Installed MSDERelA
> setup SAPWD=Sapassword SecurityMode=SQL
> Restart
> Server Runs
> Registery check
> Loginmode=0
> DefaultLogin = guest.
> Manually Loginmode=2 changed
> Tried again in VB.net
> Login failed for user.
> I tried everything but nothing works.
first... try SECURITYMODE=SQL ... perhaps it's case sensitive.. never
tried mixed case...
then... if you modify the registry try stopping and restarting the server...
then.. can you please repeat the exception you are prompted with?
thank you
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
|||"Andrea Montanari" schreef:

> hi,
> Henk wrote:
> first... try SECURITYMODE=SQL ... perhaps it's case sensitive.. never
> tried mixed case...
> then... if you modify the registry try stopping and restarting the server...
> then.. can you please repeat the exception you are prompted with?
> thank you
> --
> 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
>
Many thanks again for answering my questions.
But none of the answers solved the question.
But after all it works.
What I have done is the following.
Deinstalled MSDE.
Removed everything with SQL from program files and from the registery.
Dit a registery cleanup, with RegClean.
And after all defragmented my harddisk.
After that I installed MSDE and started to ad a sqladapter and everything
works.
I scrolled through the started services and there was one thing that seemed
to be different, the SQLServerAgent was automaticly started.
Till now I don't know what i dit wrong and that is a shame, but it works.
Thanks again for answering.
Henk

>