I need to install a named instance of the Desktop Engine, so I followed the directions at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
which has instructions on using Orca to modify sample.msi. I also followed the instructions found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp
on how to edit the msi file to create a named instance.
YET, when used, this altered msi installs a DEFAULT instance.
Am I missing something? If so, what?
Thanks for any help,
Allan Sorenson
Crossroads technologyOriginally posted by B1ueboy
I need to install a named instance of the Desktop Engine, so I followed the directions at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
which has instructions on using Orca to modify sample.msi. I also followed the instructions found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp
on how to edit the msi file to create a named instance.
YET, when used, this altered msi installs a DEFAULT instance.
Am I missing something? If so, what?
Thanks for any help,
Allan Sorenson
Crossroads technology
A little more info on the last edit:
Using Orca I added the row named 'SqlInstanceName' with the desired instance name as the value to the 'Property' table.
Showing posts with label desktop. Show all posts
Showing posts with label desktop. Show all posts
Friday, March 30, 2012
Installing MSDE on different plattforms.
Product
Our product is developed in Visual Studio .NET using MFC and .NET.
It connects to a MS SQL Server Desktop Edition (MSDE), where the data is
stored.
Installation
Our problems relates to the installation of our product.
Installation happens in these steps:
- Install .NET
- Install MSDE2000 (with a SA password we have chosen)
- Reboot
- Start our own InstallDB.exe which does the follwoing:
-- Connects to the MSDE (the master database)
-- creates our own database (called "exordb" and creates our own sql
user called "exor")
-- Connects again to MSDE using the exor user and loads data into the
exordb database.
We are using the following connectionstring for connecting to master db the
first time.
Data Source=127.0.01; Integrated Security=SSPI;Initial Catalog=master
We are considering to use this one instead:
server=127.0.0.1;uid=sa;pwd=****;database=master
after the exordb is set up we connect using
server=127.0.0.1;uid=exor;pwd=***;database=exordb
Problems
1. (the most critical)
Installation failes (the first connection string) for some customers with XP
SP2 even if they turn off the firewall.
They get the standard SQLServer Exception:
SQL Server does not exist or access denied.
The MSDE is there (unnamed instance) and is ON.
2. (Windows 98)
When installed on Windows98 MSDE does not start automatically after the
reboot, at least that what it seems on the WIndows 98 machine we have tested
on. (We have also discovered that only SQL Autentification works on Win98,
we solved that by using the second connection string instead of the first
one).
3. (manual start of MSDE)
How may we detect (in our code, preferrably .NET/C#) that MSDE is not
running and how do we start it from the code?
4. (MSDE installed by someone else)
If MSDE is already installed on the computer by another program and
SQL-authentification is not set, how may we set it so our connection string
will work.
hi Vilhelm,
Vilhelm wrote:
> Product
> Our product is developed in Visual Studio .NET using MFC and .NET.
> It connects to a MS SQL Server Desktop Edition (MSDE), where the data
> is stored.
> Installation
> Our problems relates to the installation of our product.
> Installation happens in these steps:
> - Install .NET
> - Install MSDE2000 (with a SA password we have chosen)
> - Reboot
> - Start our own InstallDB.exe which does the follwoing:
> -- Connects to the MSDE (the master database)
> -- creates our own database (called "exordb" and creates our own
> sql user called "exor")
> -- Connects again to MSDE using the exor user and loads data into
> the exordb database.
>
> We are using the following connectionstring for connecting to master
> db the first time.
> Data Source=127.0.01; Integrated Security=SSPI;Initial
> Catalog=master
> We are considering to use this one instead:
> server=127.0.0.1;uid=sa;pwd=****;database=master
> after the exordb is set up we connect using
> server=127.0.0.1;uid=exor;pwd=***;database=exordb
> Problems
> 1. (the most critical)
> Installation failes (the first connection string) for some customers
> with XP SP2 even if they turn off the firewall.
> They get the standard SQLServer Exception:
> SQL Server does not exist or access denied.
> The MSDE is there (unnamed instance) and is ON.
I'm trying to get some more material about that kind of issue on XP sp2 to
report it to Microsoft representative... but I am unable to repro it in my
tests.. I'm aware of another issue on XP sp2 which cause installation
failure due to MDAC stack troubles, currently with no workaround as no MDAC
2.8 xp sp2 refresh is available... please forward me more info, if you
like..
> 2. (Windows 98)
> When installed on Windows98 MSDE does not start automatically after
> the reboot, at least that what it seems on the WIndows 98 machine we
> have tested on.
it's correct... MSDE runs as a standard application on Win9x platform as it
does not support service mode..
you should check that the service manager is added in the autostart folder
and that the "Autostart service when OS starts" check box is checked ..
to start MSDE you can call the SQL Server Service Manager as following:
(named instance)
scm.exe -Action 1 -Silent 1 -Service MSSQL$InstanceName
(default Instance)
scm.exe -Action 1 -Silent 1 -Service MSSQLServer
please keep in mind that, on Win9x, MSDE path will not be added to
autoexec.bat if you don't reboot the
computer, so you have to rely on Win32 API like FindFirstFile or the like to
find where the scm.exe is (usually ..\Program Files\Microsoft SQL
Server\80\Tools\Binn\scm.exe)
>(We have also discovered that only SQL
> Autentification works on Win98, we solved that by using the second
> connection string instead of the first one).
MSDE installed on Win9x does not support integrated security
> 3. (manual start of MSDE)
> How may we detect (in our code, preferrably .NET/C#) that MSDE is not
> running and how do we start it from the code?
you can rely on SQL-DMO COM object...
you can then ping it like
dim oServer as SQLDMO.SQLServer2
objServer.PingSQLServerVersion
start it, or just connect...
> 4. (MSDE installed by someone else)
> If MSDE is already installed on the computer by another program and
> SQL-authentification is not set, how may we set it so our connection
> string will work.
you have to manually change the login authentication mode, logging in as
member of the server's sysadmin role and setting the
objServer.IntegratedSecurity.SecurityMode = SQLDMOSecurity_Mixed
or modify the Windows registry
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
LoginMode=2
(HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer for
a named instance)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you a lot for some useful answers!!
More input on question 1.
I have not been able ot reproduce it here, but some of my customers report
this problem. Maybe we can resolve it with some well-phrased questions I can
ask one of my customers on the phone.
We use installshield Premier edition which installs MDAC 2.8 if necessary as
part of the installation process.
Vilhelm Heiberg
Norway.
"Andrea Montanari" wrote:
> hi Vilhelm,
> Vilhelm wrote:
> I'm trying to get some more material about that kind of issue on XP sp2 to
> report it to Microsoft representative... but I am unable to repro it in my
> tests.. I'm aware of another issue on XP sp2 which cause installation
> failure due to MDAC stack troubles, currently with no workaround as no MDAC
> 2.8 xp sp2 refresh is available... please forward me more info, if you
> like..
>
> it's correct... MSDE runs as a standard application on Win9x platform as it
> does not support service mode..
> you should check that the service manager is added in the autostart folder
> and that the "Autostart service when OS starts" check box is checked ..
> to start MSDE you can call the SQL Server Service Manager as following:
> (named instance)
> scm.exe -Action 1 -Silent 1 -Service MSSQL$InstanceName
> (default Instance)
> scm.exe -Action 1 -Silent 1 -Service MSSQLServer
> please keep in mind that, on Win9x, MSDE path will not be added to
> autoexec.bat if you don't reboot the
> computer, so you have to rely on Win32 API like FindFirstFile or the like to
> find where the scm.exe is (usually ..\Program Files\Microsoft SQL
> Server\80\Tools\Binn\scm.exe)
>
> MSDE installed on Win9x does not support integrated security
>
> you can rely on SQL-DMO COM object...
> you can then ping it like
> dim oServer as SQLDMO.SQLServer2
> objServer.PingSQLServerVersion
> start it, or just connect...
>
> you have to manually change the login authentication mode, logging in as
> member of the server's sysadmin role and setting the
> objServer.IntegratedSecurity.SecurityMode = SQLDMOSecurity_Mixed
> or modify the Windows registry
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> LoginMode=2
> (HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer for
> a named instance)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
Our product is developed in Visual Studio .NET using MFC and .NET.
It connects to a MS SQL Server Desktop Edition (MSDE), where the data is
stored.
Installation
Our problems relates to the installation of our product.
Installation happens in these steps:
- Install .NET
- Install MSDE2000 (with a SA password we have chosen)
- Reboot
- Start our own InstallDB.exe which does the follwoing:
-- Connects to the MSDE (the master database)
-- creates our own database (called "exordb" and creates our own sql
user called "exor")
-- Connects again to MSDE using the exor user and loads data into the
exordb database.
We are using the following connectionstring for connecting to master db the
first time.
Data Source=127.0.01; Integrated Security=SSPI;Initial Catalog=master
We are considering to use this one instead:
server=127.0.0.1;uid=sa;pwd=****;database=master
after the exordb is set up we connect using
server=127.0.0.1;uid=exor;pwd=***;database=exordb
Problems
1. (the most critical)
Installation failes (the first connection string) for some customers with XP
SP2 even if they turn off the firewall.
They get the standard SQLServer Exception:
SQL Server does not exist or access denied.
The MSDE is there (unnamed instance) and is ON.
2. (Windows 98)
When installed on Windows98 MSDE does not start automatically after the
reboot, at least that what it seems on the WIndows 98 machine we have tested
on. (We have also discovered that only SQL Autentification works on Win98,
we solved that by using the second connection string instead of the first
one).
3. (manual start of MSDE)
How may we detect (in our code, preferrably .NET/C#) that MSDE is not
running and how do we start it from the code?
4. (MSDE installed by someone else)
If MSDE is already installed on the computer by another program and
SQL-authentification is not set, how may we set it so our connection string
will work.
hi Vilhelm,
Vilhelm wrote:
> Product
> Our product is developed in Visual Studio .NET using MFC and .NET.
> It connects to a MS SQL Server Desktop Edition (MSDE), where the data
> is stored.
> Installation
> Our problems relates to the installation of our product.
> Installation happens in these steps:
> - Install .NET
> - Install MSDE2000 (with a SA password we have chosen)
> - Reboot
> - Start our own InstallDB.exe which does the follwoing:
> -- Connects to the MSDE (the master database)
> -- creates our own database (called "exordb" and creates our own
> sql user called "exor")
> -- Connects again to MSDE using the exor user and loads data into
> the exordb database.
>
> We are using the following connectionstring for connecting to master
> db the first time.
> Data Source=127.0.01; Integrated Security=SSPI;Initial
> Catalog=master
> We are considering to use this one instead:
> server=127.0.0.1;uid=sa;pwd=****;database=master
> after the exordb is set up we connect using
> server=127.0.0.1;uid=exor;pwd=***;database=exordb
> Problems
> 1. (the most critical)
> Installation failes (the first connection string) for some customers
> with XP SP2 even if they turn off the firewall.
> They get the standard SQLServer Exception:
> SQL Server does not exist or access denied.
> The MSDE is there (unnamed instance) and is ON.
I'm trying to get some more material about that kind of issue on XP sp2 to
report it to Microsoft representative... but I am unable to repro it in my
tests.. I'm aware of another issue on XP sp2 which cause installation
failure due to MDAC stack troubles, currently with no workaround as no MDAC
2.8 xp sp2 refresh is available... please forward me more info, if you
like..
> 2. (Windows 98)
> When installed on Windows98 MSDE does not start automatically after
> the reboot, at least that what it seems on the WIndows 98 machine we
> have tested on.
it's correct... MSDE runs as a standard application on Win9x platform as it
does not support service mode..
you should check that the service manager is added in the autostart folder
and that the "Autostart service when OS starts" check box is checked ..
to start MSDE you can call the SQL Server Service Manager as following:
(named instance)
scm.exe -Action 1 -Silent 1 -Service MSSQL$InstanceName
(default Instance)
scm.exe -Action 1 -Silent 1 -Service MSSQLServer
please keep in mind that, on Win9x, MSDE path will not be added to
autoexec.bat if you don't reboot the
computer, so you have to rely on Win32 API like FindFirstFile or the like to
find where the scm.exe is (usually ..\Program Files\Microsoft SQL
Server\80\Tools\Binn\scm.exe)
>(We have also discovered that only SQL
> Autentification works on Win98, we solved that by using the second
> connection string instead of the first one).
MSDE installed on Win9x does not support integrated security
> 3. (manual start of MSDE)
> How may we detect (in our code, preferrably .NET/C#) that MSDE is not
> running and how do we start it from the code?
you can rely on SQL-DMO COM object...
you can then ping it like
dim oServer as SQLDMO.SQLServer2
objServer.PingSQLServerVersion
start it, or just connect...
> 4. (MSDE installed by someone else)
> If MSDE is already installed on the computer by another program and
> SQL-authentification is not set, how may we set it so our connection
> string will work.
you have to manually change the login authentication mode, logging in as
member of the server's sysadmin role and setting the
objServer.IntegratedSecurity.SecurityMode = SQLDMOSecurity_Mixed
or modify the Windows registry
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
LoginMode=2
(HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer for
a named instance)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you a lot for some useful answers!!
More input on question 1.
I have not been able ot reproduce it here, but some of my customers report
this problem. Maybe we can resolve it with some well-phrased questions I can
ask one of my customers on the phone.
We use installshield Premier edition which installs MDAC 2.8 if necessary as
part of the installation process.
Vilhelm Heiberg
Norway.
"Andrea Montanari" wrote:
> hi Vilhelm,
> Vilhelm wrote:
> I'm trying to get some more material about that kind of issue on XP sp2 to
> report it to Microsoft representative... but I am unable to repro it in my
> tests.. I'm aware of another issue on XP sp2 which cause installation
> failure due to MDAC stack troubles, currently with no workaround as no MDAC
> 2.8 xp sp2 refresh is available... please forward me more info, if you
> like..
>
> it's correct... MSDE runs as a standard application on Win9x platform as it
> does not support service mode..
> you should check that the service manager is added in the autostart folder
> and that the "Autostart service when OS starts" check box is checked ..
> to start MSDE you can call the SQL Server Service Manager as following:
> (named instance)
> scm.exe -Action 1 -Silent 1 -Service MSSQL$InstanceName
> (default Instance)
> scm.exe -Action 1 -Silent 1 -Service MSSQLServer
> please keep in mind that, on Win9x, MSDE path will not be added to
> autoexec.bat if you don't reboot the
> computer, so you have to rely on Win32 API like FindFirstFile or the like to
> find where the scm.exe is (usually ..\Program Files\Microsoft SQL
> Server\80\Tools\Binn\scm.exe)
>
> MSDE installed on Win9x does not support integrated security
>
> you can rely on SQL-DMO COM object...
> you can then ping it like
> dim oServer as SQLDMO.SQLServer2
> objServer.PingSQLServerVersion
> start it, or just connect...
>
> you have to manually change the login authentication mode, logging in as
> member of the server's sysadmin role and setting the
> objServer.IntegratedSecurity.SecurityMode = SQLDMOSecurity_Mixed
> or modify the Windows registry
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> LoginMode=2
> (HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer for
> a named instance)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
Installing MSDE 2000
I'm trying to install SQL2000 Desktop for Visual Studio.Net. Fromcmd prompt
I'm running:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=password
Nothing happens then I get a popup saying: "Please go to the control panel
to install and configure system components".
How intuitive!! Does this mean MDAC upgrade or what? Anyone know what this
message implies?
TX
Don't know if it has anything to do with it but can you firstly try..
Setup.exe SAPWD="password"
--Original Message--
From: CW [mailto:CW@.discussions.microsoft.com]
Posted At: Tuesday, 18 January 2005 7:55 AM
Posted To: microsoft.public.sqlserver.msde
Conversation: Installing MSDE 2000
Subject: Installing MSDE 2000
I'm trying to install SQL2000 Desktop for Visual Studio.Net. Fromcmd
prompt I'm running:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1
SAPWD=password
Nothing happens then I get a popup saying: "Please go to the control
panel to install and configure system components".
How intuitive!! Does this mean MDAC upgrade or what? Anyone know what
this message implies?
TX
I'm running:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=password
Nothing happens then I get a popup saying: "Please go to the control panel
to install and configure system components".
How intuitive!! Does this mean MDAC upgrade or what? Anyone know what this
message implies?
TX
Don't know if it has anything to do with it but can you firstly try..
Setup.exe SAPWD="password"
--Original Message--
From: CW [mailto:CW@.discussions.microsoft.com]
Posted At: Tuesday, 18 January 2005 7:55 AM
Posted To: microsoft.public.sqlserver.msde
Conversation: Installing MSDE 2000
Subject: Installing MSDE 2000
I'm trying to install SQL2000 Desktop for Visual Studio.Net. Fromcmd
prompt I'm running:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1
SAPWD=password
Nothing happens then I get a popup saying: "Please go to the control
panel to install and configure system components".
How intuitive!! Does this mean MDAC upgrade or what? Anyone know what
this message implies?
TX
Wednesday, March 28, 2012
Installing MSDE
After a number of tries I have not been able to successfully install the MSDE 2000 Desktop engine.. I downloaded the file, followed all instructions in the ReadMe and now have a folder "Microsoft SQLServer" in the Program Files. This folder contains 2 s
ub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.
In the past, all my database have been in MS Access2000. Am I expecting too much of san Access type of look?
I am at a complete loss as to where to go from here in using the MSDE and getting the sample databases to load. If anyone can point me to a place to look fo a tutorial or simple set of instructions, I would appreciate it, much.
I am using Windows XP Pro.
Milt
hi Milt,
"sirmilt" <sirmilt@.discussions.microsoft.com> ha scritto nel messaggio
news:534F95C8-7C68-45F3-A2CE-6C4995F2B57D@.microsoft.com...
>....
please post your command line...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hello sirmlt,
welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer in
vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both the
tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.
Let us know if you have any more questions.
goodluck
dev
"sirmilt" wrote:
> After a number of tries I have not been able to successfully install the MSDE 2000 Desktop engine.. I downloaded the file, followed all instructions in the ReadMe and now have a folder "Microsoft SQLServer" in the Program Files. This folder contains 2
sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.
> In the past, all my database have been in MS Access2000. Am I expecting too much of san Access type of look?
> I am at a complete loss as to where to go from here in using the MSDE and getting the sample databases to load. If anyone can point me to a place to look fo a tutorial or simple set of instructions, I would appreciate it, much.
> I am using Windows XP Pro.
> --
> Milt
|||Thank you for the response. Your answer clears up my misunderstanding of the interface with the MSDE. I looked at the web site you suggested and it is all in Italian, I hope there is an english version, I will be trying it out over the next couple of day
s.
Milt
"dev_kh" wrote:
> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||dev_kh
Thank you for replying. I took a brief look at the site you suggested and it's in Italian. I will download and hope for an english version.
Thanks Again
Milt
"dev_kh" wrote:
> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||> Thank you for replying. I took a brief look at the site you suggested and
it's in Italian.
>I will download and hope for an english version.
hey... I'm italian, thought =;-D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||dev_kh
Thanks for the response. I download what appears to be the right file and will try it out, I appreciate your trying to help out this novice.
Milt
"dev_kh" wrote:
> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||Andrea
I did download and install the program suceessfully. I'm a comparative novice at programming, however, and have to struggle with some of the settings as I'm not sure exactly what is needed.
I do appreciate your taking the time to try and help me.
Milt
"Andrea Montanari" wrote:
> it's in Italian.
> hey... I'm italian, thought =;-D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Andrea
I did download and install the program suceessfully. I'm a comparative novice at programming, however, and have to struggle with some of the settings as I'm not sure exactly what is needed.
I do appreciate your taking the time to try and help me.
Milt
"Andrea Montanari" wrote:
> it's in Italian.
> hey... I'm italian, thought =;-D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Mime-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de WRwDGb8hXM5vooZ9AkxMRAxL6OyRmZqCnfNc+olhAQgA9jRmO8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Path: TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!not-for-mail
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.msde:16464
hi Milt,
"sirmilt" <sirmilt@.discussions.microsoft.com> ha scritto nel messaggio
news:37427C61-4E89-4529-8969-DA73200715C7@.microsoft.com...
> Andrea
> I did download and install the program suceessfully. I'm a comparative
novice at programming, however, and have to struggle with some of the
settings as I'm not sure exactly what is needed.
> I do appreciate your taking the time to try and help me.
thank you for your interest in this prj of mine... for DbaMgr related
questions, please write me privately about it, in order not to go OT on
microsoft public NG
thank you
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
ub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.
In the past, all my database have been in MS Access2000. Am I expecting too much of san Access type of look?
I am at a complete loss as to where to go from here in using the MSDE and getting the sample databases to load. If anyone can point me to a place to look fo a tutorial or simple set of instructions, I would appreciate it, much.
I am using Windows XP Pro.
Milt
hi Milt,
"sirmilt" <sirmilt@.discussions.microsoft.com> ha scritto nel messaggio
news:534F95C8-7C68-45F3-A2CE-6C4995F2B57D@.microsoft.com...
>....
please post your command line...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hello sirmlt,
welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer in
vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both the
tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.
Let us know if you have any more questions.
goodluck
dev
"sirmilt" wrote:
> After a number of tries I have not been able to successfully install the MSDE 2000 Desktop engine.. I downloaded the file, followed all instructions in the ReadMe and now have a folder "Microsoft SQLServer" in the Program Files. This folder contains 2
sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.
> In the past, all my database have been in MS Access2000. Am I expecting too much of san Access type of look?
> I am at a complete loss as to where to go from here in using the MSDE and getting the sample databases to load. If anyone can point me to a place to look fo a tutorial or simple set of instructions, I would appreciate it, much.
> I am using Windows XP Pro.
> --
> Milt
|||Thank you for the response. Your answer clears up my misunderstanding of the interface with the MSDE. I looked at the web site you suggested and it is all in Italian, I hope there is an english version, I will be trying it out over the next couple of day
s.
Milt
"dev_kh" wrote:
> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||dev_kh
Thank you for replying. I took a brief look at the site you suggested and it's in Italian. I will download and hope for an english version.
Thanks Again
Milt
"dev_kh" wrote:
> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||> Thank you for replying. I took a brief look at the site you suggested and
it's in Italian.
>I will download and hope for an english version.
hey... I'm italian, thought =;-D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||dev_kh
Thanks for the response. I download what appears to be the right file and will try it out, I appreciate your trying to help out this novice.
Milt
"dev_kh" wrote:
> Hello sirmlt,
> welcome to the MSDE group. MSDE does not come with a graphical UI tool. To administer it you can download the free tools online for e.g. MSDEManager or dbamanager by Andrea from http://www.asql.biz/DbaMgr.shtm.
> This will give you a tool to administer the sql server, for e.g. to create logins, users etc. Then to create your database you can use t-sql statements in .net to create the db dynamically but if you want to create it using UI then the server explorer
in vs.net will let you connect to the server (which will be your machine if you install MSDE there) nad create database. Or you can install SQL Server developer edition (cheaper cost wise and for development purposes). This will provide you with both th
e tool to administer the databases (It is called Enterprise Manager) and you can create/modify the db there itself.[vbcol=seagreen]
> Let us know if you have any more questions.
> goodluck
> dev
> "sirmilt" wrote:
2 sub folders "80" and "MSSQL$VSdotNet". These have sub folders which I have serched but cannort locate an executable file that gives me any kind of interface to design or use a database.[vbcol=seagreen]
|||Andrea
I did download and install the program suceessfully. I'm a comparative novice at programming, however, and have to struggle with some of the settings as I'm not sure exactly what is needed.
I do appreciate your taking the time to try and help me.
Milt
"Andrea Montanari" wrote:
> it's in Italian.
> hey... I'm italian, thought =;-D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Andrea
I did download and install the program suceessfully. I'm a comparative novice at programming, however, and have to struggle with some of the settings as I'm not sure exactly what is needed.
I do appreciate your taking the time to try and help me.
Milt
"Andrea Montanari" wrote:
> it's in Italian.
> hey... I'm italian, thought =;-D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Mime-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de WRwDGb8hXM5vooZ9AkxMRAxL6OyRmZqCnfNc+olhAQgA9jRmO8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Path: TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!not-for-mail
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.msde:16464
hi Milt,
"sirmilt" <sirmilt@.discussions.microsoft.com> ha scritto nel messaggio
news:37427C61-4E89-4529-8969-DA73200715C7@.microsoft.com...
> Andrea
> I did download and install the program suceessfully. I'm a comparative
novice at programming, however, and have to struggle with some of the
settings as I'm not sure exactly what is needed.
> I do appreciate your taking the time to try and help me.
thank you for your interest in this prj of mine... for DbaMgr related
questions, please write me privately about it, in order not to go OT on
microsoft public NG
thank you
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Installing MSDE
Hi,
I have been having difficulty installing MSDE 2000 Rel A. It starts the process and then gives a message stating that MicroSoft SQL Server Desktop Engine Setup failed. I ran the install program with a log file and found an entry that failed. (value 3).
Here is the entry from the log file
...
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (RPC0419,LocalSystem,87).
Action ended 15:29:52: InstallFinalize. Return value 3.
Any help would be greatly appreciated.
Glenn Bruckner
hi Glenn,
"Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
messaggio news:263C2E27-6082-4998-9541-7CCC824DB661@.microsoft.com...
> Hi,
> I have been having difficulty installing MSDE 2000 Rel A. It starts the
process and then
>gives a message stating that MicroSoft SQL Server Desktop Engine Setup
failed. I ran the
>install program with a log file and found an entry that failed. (value 3).
>
Please make sure that your File & Print services is started.
Go to Control Panel - Administrative Tools - Services then start 'Server'.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
Thanks for the response. I looked at the services in the Administrative tools but I don't see anything for file and print sharing. I can enable it for the local hard disk if that is necessary. I will work on trying to start them and let you know what h
appens.
GB
"Andrea Montanari" wrote:
> hi Glenn,
> "Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
> messaggio news:263C2E27-6082-4998-9541-7CCC824DB661@.microsoft.com...
> process and then
> failed. I ran the
> Please make sure that your File & Print services is started.
> Go to Control Panel - Administrative Tools - Services then start 'Server'.
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Glenn,
"Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
messaggio news:E575AC6E-7CFD-48BF-BB0E-2AAB5E7AF5A7@.microsoft.com...
> Andrea,
> Thanks for the response. I looked at the services in the Administrative
tools but I don't
>see anything for file and print sharing. I can enable it for the local
hard disk if that is
>necessary. I will work on trying to start them and let you know what
happens.
look for a service named "Server"
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
There is no service listed as Server. The computer I am trying to load MSDE on is Win 2000 Pro machine. Is it possible to load it on Win2000 Pro? (I would also like to load on my XP Pro machine at home as well.)
I also have access to the SQL 2000 Enterprise Manager, should I use that instead?
Thanks again for your help.
GB
"Andrea Montanari" wrote:
> hi Glenn,
> "Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
> messaggio news:E575AC6E-7CFD-48BF-BB0E-2AAB5E7AF5A7@.microsoft.com...
> tools but I don't
> hard disk if that is
> happens.
> look for a service named "Server"
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Glenn,
"Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
messaggio news:365D7A40-1BBC-40F1-ADE6-8B10B46C8972@.microsoft.com...
> Andrea,
> There is no service listed as Server. The computer I am trying to load
MSDE
>on is Win 2000 Pro machine. Is it possible to load it on Win2000 Pro?
>(I would also like to load on my XP Pro machine at home as well.)
>
when installing Win2k, the Typical Settings will automatically set Client
for MS networks, File and Printer sharing and TCP/IP network protocols...
selecting Custom Settings, File and Printer sharing must be manually added..
if File and Printer sharing is not available, you have to add it
then, the "Server" service will be available =;-D
> I also have access to the SQL 2000 Enterprise Manager, should I use that
instead?
Enterprise Manager is to manage SQL Server installed instances... so only
once installed you could use it... by the way, using EM aginst MSDE
instances seems not to be very legal... you should rely on Web Data
Administrator (at MSDE download page) and/or third parties tools like that
listed in http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Glenn.
I read your and Andrea's comments on your problem.
I installed MSDE2000A on the a Win2K Pro machine with SP4 and all worked well, but only after some adjustments. But mine never failed its installation, so its hard to say why your did.
Please be sure that your MSDE installation is started from the command line with a parameter that sets an instance name. You may already have an unnamed instance installed. See the SQL Server 2000 Books Online for this and other help. Its a free download
able reference document for MSDE2000A. Install it and read the parts on installation and connection. There is also a multitude of MS KB articles on these topics. Its not possible to help more without knowing your system much better.
The File and Printer Sharing that Andrea was refering to is an aspect of your network (LAN) software. The LAN connection properties, will show 3 services: TCP/IP, File and Printer Sharing, and Client for MS Networks. Enable them all, although I'm not sure
why the latter two are needed at all but all I've read. That should at least get you going.
Lou Arnold
Ottawa, Canada
"Glenn Bruckner" wrote:
> Hi,
> I have been having difficulty installing MSDE 2000 Rel A. It starts the process and then gives a message stating that MicroSoft SQL Server Desktop Engine Setup failed. I ran the install program with a log file and found an entry that failed. (value 3
).
> Here is the entry from the log file
> ...
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity failed (RPC0419,LocalSystem,87).
> Action ended 15:29:52: InstallFinalize. Return value 3.
> Any help would be greatly appreciated.
> Glenn Bruckner
|||Andrea,
I enabled file and print sharing and tried to install MSDE. It worked perfectly.
Thanks again for your help.
GB
"Andrea Montanari" wrote:
> hi Glenn,
> "Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
> messaggio news:365D7A40-1BBC-40F1-ADE6-8B10B46C8972@.microsoft.com...
> MSDE
> when installing Win2k, the Typical Settings will automatically set Client
> for MS networks, File and Printer sharing and TCP/IP network protocols...
> selecting Custom Settings, File and Printer sharing must be manually added..
> if File and Printer sharing is not available, you have to add it
> then, the "Server" service will be available =;-D
> instead?
> Enterprise Manager is to manage SQL Server installed instances... so only
> once installed you could use it... by the way, using EM aginst MSDE
> instances seems not to be very legal... you should rely on Web Data
> Administrator (at MSDE download page) and/or third parties tools like that
> listed in http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Lou,
I had to enable File and print sharing for Microsoft Networks before I could install MSDE. Once I did that, it installed with out a problem.
Thanks for your assistance.
GB
"Lou Arnold" wrote:
> Hi Glenn.
> I read your and Andrea's comments on your problem.
> I installed MSDE2000A on the a Win2K Pro machine with SP4 and all worked well, but only after some adjustments. But mine never failed its installation, so its hard to say why your did.
> Please be sure that your MSDE installation is started from the command line with a parameter that sets an instance name. You may already have an unnamed instance installed. See the SQL Server 2000 Books Online for this and other help. Its a free downlo
adable reference document for MSDE2000A. Install it and read the parts on installation and connection. There is also a multitude of MS KB articles on these topics. Its not possible to help more without knowing your system much better.
> The File and Printer Sharing that Andrea was refering to is an aspect of your network (LAN) software. The LAN connection properties, will show 3 services: TCP/IP, File and Printer Sharing, and Client for MS Networks. Enable them all, although I'm not su
re why the latter two are needed at all but all I've read. That should at least get you going.[vbcol=seagreen]
> --
> Lou Arnold
> Ottawa, Canada
>
> "Glenn Bruckner" wrote:
3).[vbcol=seagreen]
I have been having difficulty installing MSDE 2000 Rel A. It starts the process and then gives a message stating that MicroSoft SQL Server Desktop Engine Setup failed. I ran the install program with a log file and found an entry that failed. (value 3).
Here is the entry from the log file
...
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (RPC0419,LocalSystem,87).
Action ended 15:29:52: InstallFinalize. Return value 3.
Any help would be greatly appreciated.
Glenn Bruckner
hi Glenn,
"Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
messaggio news:263C2E27-6082-4998-9541-7CCC824DB661@.microsoft.com...
> Hi,
> I have been having difficulty installing MSDE 2000 Rel A. It starts the
process and then
>gives a message stating that MicroSoft SQL Server Desktop Engine Setup
failed. I ran the
>install program with a log file and found an entry that failed. (value 3).
>
Please make sure that your File & Print services is started.
Go to Control Panel - Administrative Tools - Services then start 'Server'.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
Thanks for the response. I looked at the services in the Administrative tools but I don't see anything for file and print sharing. I can enable it for the local hard disk if that is necessary. I will work on trying to start them and let you know what h
appens.
GB
"Andrea Montanari" wrote:
> hi Glenn,
> "Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
> messaggio news:263C2E27-6082-4998-9541-7CCC824DB661@.microsoft.com...
> process and then
> failed. I ran the
> Please make sure that your File & Print services is started.
> Go to Control Panel - Administrative Tools - Services then start 'Server'.
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Glenn,
"Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
messaggio news:E575AC6E-7CFD-48BF-BB0E-2AAB5E7AF5A7@.microsoft.com...
> Andrea,
> Thanks for the response. I looked at the services in the Administrative
tools but I don't
>see anything for file and print sharing. I can enable it for the local
hard disk if that is
>necessary. I will work on trying to start them and let you know what
happens.
look for a service named "Server"
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
There is no service listed as Server. The computer I am trying to load MSDE on is Win 2000 Pro machine. Is it possible to load it on Win2000 Pro? (I would also like to load on my XP Pro machine at home as well.)
I also have access to the SQL 2000 Enterprise Manager, should I use that instead?
Thanks again for your help.
GB
"Andrea Montanari" wrote:
> hi Glenn,
> "Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
> messaggio news:E575AC6E-7CFD-48BF-BB0E-2AAB5E7AF5A7@.microsoft.com...
> tools but I don't
> hard disk if that is
> happens.
> look for a service named "Server"
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Glenn,
"Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
messaggio news:365D7A40-1BBC-40F1-ADE6-8B10B46C8972@.microsoft.com...
> Andrea,
> There is no service listed as Server. The computer I am trying to load
MSDE
>on is Win 2000 Pro machine. Is it possible to load it on Win2000 Pro?
>(I would also like to load on my XP Pro machine at home as well.)
>
when installing Win2k, the Typical Settings will automatically set Client
for MS networks, File and Printer sharing and TCP/IP network protocols...
selecting Custom Settings, File and Printer sharing must be manually added..
if File and Printer sharing is not available, you have to add it
then, the "Server" service will be available =;-D
> I also have access to the SQL 2000 Enterprise Manager, should I use that
instead?
Enterprise Manager is to manage SQL Server installed instances... so only
once installed you could use it... by the way, using EM aginst MSDE
instances seems not to be very legal... you should rely on Web Data
Administrator (at MSDE download page) and/or third parties tools like that
listed in http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Glenn.
I read your and Andrea's comments on your problem.
I installed MSDE2000A on the a Win2K Pro machine with SP4 and all worked well, but only after some adjustments. But mine never failed its installation, so its hard to say why your did.
Please be sure that your MSDE installation is started from the command line with a parameter that sets an instance name. You may already have an unnamed instance installed. See the SQL Server 2000 Books Online for this and other help. Its a free download
able reference document for MSDE2000A. Install it and read the parts on installation and connection. There is also a multitude of MS KB articles on these topics. Its not possible to help more without knowing your system much better.
The File and Printer Sharing that Andrea was refering to is an aspect of your network (LAN) software. The LAN connection properties, will show 3 services: TCP/IP, File and Printer Sharing, and Client for MS Networks. Enable them all, although I'm not sure
why the latter two are needed at all but all I've read. That should at least get you going.
Lou Arnold
Ottawa, Canada
"Glenn Bruckner" wrote:
> Hi,
> I have been having difficulty installing MSDE 2000 Rel A. It starts the process and then gives a message stating that MicroSoft SQL Server Desktop Engine Setup failed. I ran the install program with a log file and found an entry that failed. (value 3
).
> Here is the entry from the log file
> ...
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity failed (RPC0419,LocalSystem,87).
> Action ended 15:29:52: InstallFinalize. Return value 3.
> Any help would be greatly appreciated.
> Glenn Bruckner
|||Andrea,
I enabled file and print sharing and tried to install MSDE. It worked perfectly.
Thanks again for your help.
GB
"Andrea Montanari" wrote:
> hi Glenn,
> "Glenn Bruckner" <GlennBruckner@.discussions.microsoft.com> ha scritto nel
> messaggio news:365D7A40-1BBC-40F1-ADE6-8B10B46C8972@.microsoft.com...
> MSDE
> when installing Win2k, the Typical Settings will automatically set Client
> for MS networks, File and Printer sharing and TCP/IP network protocols...
> selecting Custom Settings, File and Printer sharing must be manually added..
> if File and Printer sharing is not available, you have to add it
> then, the "Server" service will be available =;-D
> instead?
> Enterprise Manager is to manage SQL Server installed instances... so only
> once installed you could use it... by the way, using EM aginst MSDE
> instances seems not to be very legal... you should rely on Web Data
> Administrator (at MSDE download page) and/or third parties tools like that
> listed in http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Lou,
I had to enable File and print sharing for Microsoft Networks before I could install MSDE. Once I did that, it installed with out a problem.
Thanks for your assistance.
GB
"Lou Arnold" wrote:
> Hi Glenn.
> I read your and Andrea's comments on your problem.
> I installed MSDE2000A on the a Win2K Pro machine with SP4 and all worked well, but only after some adjustments. But mine never failed its installation, so its hard to say why your did.
> Please be sure that your MSDE installation is started from the command line with a parameter that sets an instance name. You may already have an unnamed instance installed. See the SQL Server 2000 Books Online for this and other help. Its a free downlo
adable reference document for MSDE2000A. Install it and read the parts on installation and connection. There is also a multitude of MS KB articles on these topics. Its not possible to help more without knowing your system much better.
> The File and Printer Sharing that Andrea was refering to is an aspect of your network (LAN) software. The LAN connection properties, will show 3 services: TCP/IP, File and Printer Sharing, and Client for MS Networks. Enable them all, although I'm not su
re why the latter two are needed at all but all I've read. That should at least get you going.[vbcol=seagreen]
> --
> Lou Arnold
> Ottawa, Canada
>
> "Glenn Bruckner" wrote:
3).[vbcol=seagreen]
Wednesday, March 21, 2012
installed msde database server desktop edition and well...
its sql server 7.0 and im looking for the service network utility and service manager that it didnt come with.. where can i download it?Did you install MSDE 1.0? That is indeed SQL Server 7.0. You should have instead installed MSDE 2000 which is the more recent version and is SQL Server 2000.
Monday, March 19, 2012
Installation/Connection problems with MS Desktop Engine
Actually, it appears to install fine. I used the command line parameters
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without. I've tried on a machine
running Windows 2000 and XP (home addition). I tried updating the XP
machine with XP service pack.
No matter what I try, it apperas to install fine. When I attenpt to connect
to the engine (through the ASP.Net Web Matrix), I select SQL Server
Authentication. I then enter "SA" (No quotes, I've tried both upper and
lower case) as the user and the strongpassword that I used as the parameter
when installing. Everytime I get the same message.
Unable to connect to the database server. SQL Server does not exist or
access denied. ConnectionOpen (Connect()).
I can tell the engine is running because its icon in the tray is running.
What am I missing?
Steve,
You may have installed with SA and strong password (Sql authentication) but I believe the install defaults to Windows authentication.
Follow the below to make sure ... (excerpt from KB-322336)
******
If you are not sure how to verify the authentication mode of your MSDE installation, you can check the corresponding registry entry. By default, the value of the Windows LoginMode registry subkey is set to 1 for Windows Authentication. When Mixed Mode authentication is enabled, this value is a 2.
a.. The location of the LoginMode subkey depends on whether you installed MSDE as the default MSDE instance or as a named instance. If you installed MSDE as the default instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
b.. If you installed MSDE as a named instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\Microsoft SQL Server\%InstanceName%\MSSQLServer\LoginMode
NOTE: Before you switch authentication modes, you must set a sa password to avoid exposing a potential security hole
******
Hope this helps,
Tunji
"Steve Wash" <swash1@.home.com> wrote in message news:79GdnaCfS4T2AtbcRVn-tQ@.comcast.com...
Actually, it appears to install fine. I used the command line parameters
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without. I've tried on a machine
running Windows 2000 and XP (home addition). I tried updating the XP
machine with XP service pack.
No matter what I try, it apperas to install fine. When I attenpt to connect
to the engine (through the ASP.Net Web Matrix), I select SQL Server
Authentication. I then enter "SA" (No quotes, I've tried both upper and
lower case) as the user and the strongpassword that I used as the parameter
when installing. Everytime I get the same message.
Unable to connect to the database server. SQL Server does not exist or
access denied. ConnectionOpen (Connect()).
I can tell the engine is running because its icon in the tray is running.
What am I missing?
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without. I've tried on a machine
running Windows 2000 and XP (home addition). I tried updating the XP
machine with XP service pack.
No matter what I try, it apperas to install fine. When I attenpt to connect
to the engine (through the ASP.Net Web Matrix), I select SQL Server
Authentication. I then enter "SA" (No quotes, I've tried both upper and
lower case) as the user and the strongpassword that I used as the parameter
when installing. Everytime I get the same message.
Unable to connect to the database server. SQL Server does not exist or
access denied. ConnectionOpen (Connect()).
I can tell the engine is running because its icon in the tray is running.
What am I missing?
Steve,
You may have installed with SA and strong password (Sql authentication) but I believe the install defaults to Windows authentication.
Follow the below to make sure ... (excerpt from KB-322336)
******
If you are not sure how to verify the authentication mode of your MSDE installation, you can check the corresponding registry entry. By default, the value of the Windows LoginMode registry subkey is set to 1 for Windows Authentication. When Mixed Mode authentication is enabled, this value is a 2.
a.. The location of the LoginMode subkey depends on whether you installed MSDE as the default MSDE instance or as a named instance. If you installed MSDE as the default instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
b.. If you installed MSDE as a named instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\Microsoft SQL Server\%InstanceName%\MSSQLServer\LoginMode
NOTE: Before you switch authentication modes, you must set a sa password to avoid exposing a potential security hole
******
Hope this helps,
Tunji
"Steve Wash" <swash1@.home.com> wrote in message news:79GdnaCfS4T2AtbcRVn-tQ@.comcast.com...
Actually, it appears to install fine. I used the command line parameters
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without. I've tried on a machine
running Windows 2000 and XP (home addition). I tried updating the XP
machine with XP service pack.
No matter what I try, it apperas to install fine. When I attenpt to connect
to the engine (through the ASP.Net Web Matrix), I select SQL Server
Authentication. I then enter "SA" (No quotes, I've tried both upper and
lower case) as the user and the strongpassword that I used as the parameter
when installing. Everytime I get the same message.
Unable to connect to the database server. SQL Server does not exist or
access denied. ConnectionOpen (Connect()).
I can tell the engine is running because its icon in the tray is running.
What am I missing?
Friday, March 9, 2012
Installation on XP
Hi,
I want to install SQL 2005 (Any edition) on my XP SP-2 Machine. Please note
that it is desktop, there is no LAN Connectivity. It is only for study
purpose. Can any one tell me which edition is appropriate for it and how can
I get it.
Any hints will be sincerely appreciated.
Hardik ShahExpress is free but Developer is only about $50.00 and is essentially
the Enterprise edition so you would have all the features to study and
work with.
Check here:
http://www.microsoft.com/sql/editions/default.mspx
http://www.microsoft.com/sql/prodin...e-features.mspx
Hardik Shah wrote:
> Hi,
> I want to install SQL 2005 (Any edition) on my XP SP-2 Machine. Please not
e
> that it is desktop, there is no LAN Connectivity. It is only for study
> purpose. Can any one tell me which edition is appropriate for it and how c
an
> I get it.
> Any hints will be sincerely appreciated.
> Hardik Shah
>
I want to install SQL 2005 (Any edition) on my XP SP-2 Machine. Please note
that it is desktop, there is no LAN Connectivity. It is only for study
purpose. Can any one tell me which edition is appropriate for it and how can
I get it.
Any hints will be sincerely appreciated.
Hardik ShahExpress is free but Developer is only about $50.00 and is essentially
the Enterprise edition so you would have all the features to study and
work with.
Check here:
http://www.microsoft.com/sql/editions/default.mspx
http://www.microsoft.com/sql/prodin...e-features.mspx
Hardik Shah wrote:
> Hi,
> I want to install SQL 2005 (Any edition) on my XP SP-2 Machine. Please not
e
> that it is desktop, there is no LAN Connectivity. It is only for study
> purpose. Can any one tell me which edition is appropriate for it and how c
an
> I get it.
> Any hints will be sincerely appreciated.
> Hardik Shah
>
Friday, February 24, 2012
Installation Issue
I try to install MSDE using the sapwd switch. During the 'Please wait while
Windows configures Microsoft SQL Server Desktop Engine' process an error pops
up stating:
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
I searched high and low for installation logs and the event viewer on my
server but I cannot find anything relavent to this error.
hi,
Mikey Rogers wrote:
> I try to install MSDE using the sapwd switch. During the 'Please
> wait while Windows configures Microsoft SQL Server Desktop Engine'
> process an error pops up stating:
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> I searched high and low for installation logs and the event viewer on
> my server but I cannot find anything relavent to this error.
as you can see from
http://support.microsoft.com/default...9&Product=sql,
the most relevant cause of this exception is due to uncomplete
installation(s) of other MSDE instances...
if you are not involved in this problem, it recently appears due to MDAC
stack corruptions...
if you have WinXP sp2 installed you can not fix it by applying the higher
MDAC stack (http://msdn.microsoft.com/data/mdac/...s/default.aspx)
becouse no refresh is available for that MDAC sp level, but you can fix MDAC
as reported in http://www.macropool.com/en/download...xp_sp2.html...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||> I try to install MSDE using the sapwd switch. During the 'Please wait
> while Windows configures Microsoft SQL Server Desktop Engine' process
> an error pops up stating:
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> I searched high and low for installation logs and the event viewer on
> my server but I cannot find anything relavent to this error.
>
add certificate
Windows configures Microsoft SQL Server Desktop Engine' process an error pops
up stating:
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
I searched high and low for installation logs and the event viewer on my
server but I cannot find anything relavent to this error.
hi,
Mikey Rogers wrote:
> I try to install MSDE using the sapwd switch. During the 'Please
> wait while Windows configures Microsoft SQL Server Desktop Engine'
> process an error pops up stating:
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> I searched high and low for installation logs and the event viewer on
> my server but I cannot find anything relavent to this error.
as you can see from
http://support.microsoft.com/default...9&Product=sql,
the most relevant cause of this exception is due to uncomplete
installation(s) of other MSDE instances...
if you are not involved in this problem, it recently appears due to MDAC
stack corruptions...
if you have WinXP sp2 installed you can not fix it by applying the higher
MDAC stack (http://msdn.microsoft.com/data/mdac/...s/default.aspx)
becouse no refresh is available for that MDAC sp level, but you can fix MDAC
as reported in http://www.macropool.com/en/download...xp_sp2.html...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||> I try to install MSDE using the sapwd switch. During the 'Please wait
> while Windows configures Microsoft SQL Server Desktop Engine' process
> an error pops up stating:
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> I searched high and low for installation logs and the event viewer on
> my server but I cannot find anything relavent to this error.
>
add certificate
Subscribe to:
Posts (Atom)