MSDE and Enterprise Manager Trouble

I have installed an MSDE instance on my PC. I have used both the setup.exe program and installed MSDE with the merge modules. Everything works fine - I am able to programmatically connect to the database and execute all of my statements. However, when I t
ry to register the database with Enterprise Manager, Enterprise Manager doesn't see the instance. Similarly, my program that uses SQLDMO.DLL to enumerate all servers does not see the MSDE instance. Both the database, my program, and Enterprise Manager are
running locally on the same machine.
This is a development box, and I have had to uninstall MSDE by hand several times by removing registry keys manually. I suspect that my problem is that I have deleted a key that I needed. Does anyone have any clues? Thanks in advance.
Rob Reagan
MSDE with Sp3a or MSDE Release A installs by default without network
connections enabled and will not advertise itself on the network. You can
still register the instance in Enterprise Manager by typing the name in the
textbox during registration.
You can install MSDE with network connections, see the "Customizing Desktop
Engine Setup.exe" topic in Books Online for details. You can also enable
network connections after installation with (I think) svrnetcn.exe in the
Tools\Bin directory, but I have no MSDe instance to check that at the
moment.
Jacco Schalkwijk
SQL Server MVP
"Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
news:AEC24187-ADA9-48D1-ADC3-837FEE031CEB@.microsoft.com...
> I have installed an MSDE instance on my PC. I have used both the setup.exe
program and installed MSDE with the merge modules. Everything works fine - I
am able to programmatically connect to the database and execute all of my
statements. However, when I try to register the database with Enterprise
Manager, Enterprise Manager doesn't see the instance. Similarly, my program
that uses SQLDMO.DLL to enumerate all servers does not see the MSDE
instance. Both the database, my program, and Enterprise Manager are running
locally on the same machine.
> This is a development box, and I have had to uninstall MSDE by hand
several times by removing registry keys manually. I suspect that my problem
is that I have deleted a key that I needed. Does anyone have any clues?
Thanks in advance.
> Rob Reagan

MSDE 2000 Wont Install after Uninstall

I installed MSDE 2000, then uninstalled it because of a
problem with a 3rd party program. I then uninstalled that
3rd party program and downloaded sql2kdesksp3.exe, and
unpacked the installer. I ran a command prompt and typed
setup SAPWD=password SecurityType=SQL
and it began to install, but when the installer came down 5
seconds it would just pause and not do anything. There is
no harddrive activity or anything. I have redownloaded the
package, and tried many things to try and get it to
working, but no success.
Help!
hi Mike,
"Mike" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:069c01c4b60c$09261510$a601280a@.phx.gbl
> I installed MSDE 2000, then uninstalled it because of a
> problem with a 3rd party program. I then uninstalled that
> 3rd party program and downloaded sql2kdesksp3.exe, and
> unpacked the installer. I ran a command prompt and typed
> setup SAPWD=password SecurityType=SQL
> and it began to install, but when the installer came down 5
> seconds it would just pause and not do anything. There is
> no harddrive activity or anything. I have redownloaded the
> package, and tried many things to try and get it to
> working, but no success.
first of all, you have to specify SECURITYMODE=SQL and not SecurityType=SQL
the problem you are facing is probably related to "Setup failed to configure
the server", as explained in
http://support.microsoft.com/default...99&Product=sql
due to a incomplete removal of MSDE instance... anyway, try adding the
/L*v "c:\MsdeLog.txt"
parameter to you command line call to setup.exe in order to create a (about
2mb) verbose log of the installation process, where you can search for
RETURN VALUE 3
condition and, about 10 lines before or after the failure cause is (little)
explained
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 2000 Release A

I am having problems installing the MSDE 2000 Release A on my Computer. I am
not able to find the Microsoft SQL Server Program when I go to Start-Program.
Can you please tell me a Simple Installation Process for MSDE 2000 Release A.
Thanks.
Hi,
MSDE does not install any shotcuts as it is just the engine and has no tools
that ship with it.
"TAP" <TAP@.discussions.microsoft.com> wrote in message
news:C29639C0-3911-4867-A88B-6EE988445A02@.microsoft.com...
>I am having problems installing the MSDE 2000 Release A on my Computer. I
>am
> not able to find the Microsoft SQL Server Program when I go to
> Start-Program.
> Can you please tell me a Simple Installation Process for MSDE 2000 Release
> A.
> Thanks.

MSDE 2000 installation problem

" Starting custom action ConfigServer
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "Latin1_General""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information. "
that is the last action before the install fail in the log
does anyone know what's wrong?
thanx
Lok
hi Lok,
"Lok" <Lok@.discussions.microsoft.com> ha scritto nel messaggio
news:7B1D91E0-00CA-4C32-AC67-267BCFF7958A@.microsoft.com
> " Starting custom action ConfigServer
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q
> "Latin1_General""
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information. "
> that is the last action before the install fail in the log
> does anyone know what's wrong?
> thanx
> Lok
please have a look at
http://support.microsoft.com/default...99&Product=sql
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
|||I have tried every resolutions found on the website and it was still not
installing.
I've always set the lanaguage for non Unicode programs to chinese( Hong
Kong) to be able to display chinese character in the system natively. I have
specified the collation to Latin1_General in order for the setup to start but
the installation was never successful.
After switching the language back to English(United States), MSDE installed
fine.
Now my question is if I switch the language back to Chinese(Hong Kong),
would that mess up the MSDE install.
thanx
Lok
"Andrea Montanari" wrote:

> hi Lok,
> "Lok" <Lok@.discussions.microsoft.com> ha scritto nel messaggio
> news:7B1D91E0-00CA-4C32-AC67-267BCFF7958A@.microsoft.com
> please have a look at
> http://support.microsoft.com/default...99&Product=sql
> --
> 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 & datadir

Is it possible that on the client's machine I install my MSDE instance in the default location (C:\Program Files\Microsoft SQL Server), i.e. do not specify any datadir or Targetdir location in the setup BUT still create my app's database (during installat
ion) in my app's folder, for e.g. in C:\Program Files\MyCompany\Data\ folder and then attach this database's .mdf file to my instance which I installed. Is it necessary that the database has to be in the data folder under the MSDE install location...
Please suggest.
I am asking because I want to have nothing but database in the my app's data folder.
>> still create my app's database (during installation) in my app's folder
Yes. This is possible. It is NOT mandated that the specific databases that
you create should also fall inside the default location. In event that you
create database without any specific paths then they are created in the
default location.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"qa" <anonymous@.discussions.microsoft.com> wrote in message
news:CC9D5500-4C13-45B6-9040-F4A908DAEB26@.microsoft.com...
> Is it possible that on the client's machine I install my MSDE instance in
the default location (C:\Program Files\Microsoft SQL Server), i.e. do not
specify any datadir or Targetdir location in the setup BUT still create my
app's database (during installation) in my app's folder, for e.g. in
C:\Program Files\MyCompany\Data\ folder and then attach this database's .mdf
file to my instance which I installed. Is it necessary that the database
has to be in the data folder under the MSDE install location...
> Please suggest.
> I am asking because I want to have nothing but database in the my app's
data folder.
|||Thanks Vinod for your reply. How can I specify path for the database (not the entire data folder) as C:\Program Files\MyCompany\Data\ while creating the database using scripts during the installation program. And is keeping the database away in myapp's
folder a recommended way of working..
qa
|||You have to specify the path to the database and log files in the CREATE
DATABASE statement of the script file. Example for a database called "HAS":
CREATE DATABASE [HAS] ON (NAME = N'HAS_Data', FILENAME = N'f:\Microsoft SQL
Server\MSSQL\data\HAS_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME =
N'HAS_Log', FILENAME = N'f:\Microsoft SQL Server\MSSQL\data\HAS_Log.LDF' ,
SIZE = 1, FILEGROWTH = 10%)
COLLATE Latin1_General_CI_AS
GO
Willem
"qa" <anonymous@.discussions.microsoft.com> schreef in bericht
news:A7253E41-0E31-4D5C-967F-E7483AE75304@.microsoft.com...
> Thanks Vinod for your reply. How can I specify path for the database (not
the entire data folder) as C:\Program Files\MyCompany\Data\ while creating
the database using scripts during the installation program. And is keeping
the database away in myapp's folder a recommended way of working..
> qa

MSDE

I successfully installed MSDE, but I cannot open the application.
All my files and folder are installed under: C:\Program Files\Microsoft SQL
Server\MSSQL$NETSDK. My operating system is Windows XP Professional and my
Internet Explorer is version 6.0.
What do I need to do? Please advice.
Thank you!
Hi
With MSDE, there is no application you can run. It is a database engine and
does not have a UI.
Generally developers write and application that uses MSDE as the database.
You could use Microsoft Access to access it through an ODBC connection.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"gacevedo" <gacevedo@.discussions.microsoft.com> wrote in message
news:888E44C1-B974-4EC7-96B6-F52E79AE6250@.microsoft.com...
>I successfully installed MSDE, but I cannot open the application.
> All my files and folder are installed under: C:\Program Files\Microsoft
> SQL
> Server\MSSQL$NETSDK. My operating system is Windows XP Professional and
> my
> Internet Explorer is version 6.0.
> What do I need to do? Please advice.
> Thank you!
|||However, it seems we couldn't use Access 2003 to create table with MSDE 2005
express. Is it normal? Or any patch we need to install? Thanks.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:erAE1RCBGHA.3536@.TK2MSFTNGP11.phx.gbl...
> Hi
> With MSDE, there is no application you can run. It is a database engine
> and does not have a UI.
> Generally developers write and application that uses MSDE as the database.
> You could use Microsoft Access to access it through an ODBC connection.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "gacevedo" <gacevedo@.discussions.microsoft.com> wrote in message
> news:888E44C1-B974-4EC7-96B6-F52E79AE6250@.microsoft.com...
>
|||The Access 2003 tools (and the VS 2003 database tools) aren't compatible
with the SQL 2005 meta-data so you won't be able to use them. There
currently isn't a new version of this available.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Good" <good@.man.com> wrote in message
news:u95MJckHGHA.2912@.tk2msftngp13.phx.gbl...
> However, it seems we couldn't use Access 2003 to create table with MSDE
> 2005 express. Is it normal? Or any patch we need to install? Thanks.
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:erAE1RCBGHA.3536@.TK2MSFTNGP11.phx.gbl...
>