Hello,
My 1st attempt to install .Net framework, MSDE, my application and the databases during setup (using the MSDE deployment toolkit RC) works fine on windows xp. Now when I try to do the same for windows 98 SE machine, I am able to install .Net framweork an
d MSDE, but after that during the installation I get the following error message:
"An exception occured in the OnAfterInstall event handler of DBInstaller.CustomInstaller --> Unable to access service: Operating system does not support controlling a Windows service. A service can only be controlled on Windows NT, Windows 2000, or lat
er."
It's clear that when the setup tries to start the service to create the database etc it fails. Is this a known issue. I researched on web but couldn't find anything. Any ideas.
Thanks
dev
Any ideas..
Showing posts with label setup. Show all posts
Showing posts with label setup. Show all posts
Friday, March 30, 2012
MSDE Tookit thinks MSDE is not installed when it is.
I have multiple applications that will use the same named instance of MSDE. When I try to setup my second application using the MSDE Deployment addin it thinks that MSDE needs to be installed again. According to the flowchart it should bypass this and
just install my appliation. Any suggestions as to why my setup insists in needs to install another instance? My instance name is the same for all applications.
Thanks,
Bill
Bill in one of the previous messages someone from Microsoft mentioned that it is a known bug in the beta version of the toolkit. Hopefully it will be fixed.
goodluck
dev
|||Thanks for the info. Does anyone know when the full release will be out?
sql
just install my appliation. Any suggestions as to why my setup insists in needs to install another instance? My instance name is the same for all applications.
Thanks,
Bill
Bill in one of the previous messages someone from Microsoft mentioned that it is a known bug in the beta version of the toolkit. Hopefully it will be fixed.
goodluck
dev
|||Thanks for the info. Does anyone know when the full release will be out?
sql
MSDE Text datatype - unable to store more than 900 characters. (msde + visual studio 2003)
Hello,
I'm not sure if it's the setup I did wrong, but I can't seem to get mytext datatype in my database to store more than 900 characters. I'm trying to setup a news database for my website, which will populatethe information into a datagrid. To test, I manually added a newsitem in the database through the visual studio 2003 gui. Iimmediately noticed a problem as the I was getting an error after along news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is"text" filled with simple text in the column. As a further test,Isimply entered 12334567890123... up to 900 characters and stillrecevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
I think may be your create table statement was not executed correctly because text can grow it is not table space based SQL Server creates an Arithmetic pointer to the file. Try the link below see if you can download the eval edition of the SQL Server. Or you could drop the table and recreate it and test again. Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx
I'm not sure if it's the setup I did wrong, but I can't seem to get mytext datatype in my database to store more than 900 characters. I'm trying to setup a news database for my website, which will populatethe information into a datagrid. To test, I manually added a newsitem in the database through the visual studio 2003 gui. Iimmediately noticed a problem as the I was getting an error after along news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is"text" filled with simple text in the column. As a further test,Isimply entered 12334567890123... up to 900 characters and stillrecevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
I think may be your create table statement was not executed correctly because text can grow it is not table space based SQL Server creates an Arithmetic pointer to the file. Try the link below see if you can download the eval edition of the SQL Server. Or you could drop the table and recreate it and test again. Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx
MSDE SP4 install problem
I attempted to install MSDE SP4 (file SQL2000.MSDE-KB884525-SP4-x86-ENU) on a WinXP Pro SP2 machine.
Command used:
setup SAPWD="ourpw" SECURITYMODE=SQL /L*v c:\MSDELog.log
Install log shows successful install.
MSDE appears to function properly, service starts automatically after reboot, etc.
I can open and work with DB's with a freebie 3rd party GUI called DbaMGR2K, through which I have added the necessary DB user for our locally running ASP application to use the db.
However, when I try to use the DB with our locally running ASP application - connecting with ADO from a dll we wrote, I get the following:
"[DNETLIB]{ConnectionOpen (Connect()).]SQL Server does not exist or access denied"
Any help appreciated.
day10
Hi,
make sure that you connect to the same database and you are using a valid login for connecting. Perhaps you have chosen another authentication mode within the ADO code ? That could explain either the one or the other error message you are getting.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
I think we have solved the issue. We used the SQL Server Network Utility to enable TCP/IP (apparently not enabled by default) and now all appears well.
I wonder if there is a way to enable TCP/IP during the install process. Is there an install flag/option?
|||>> Is there an install flag/option?
Most likely. The flag for this when installing SP3 was "DISABLENETWORKPROTOCOLS=0". I wouldn't think that they would have removed it for SP4.
sqlWednesday, March 28, 2012
MSDE sp3 install problems
I recently had to install 40 german NT 4 laptops with MSDE sp3.
I prepared a setup.ini file:
[Options]
DATADIR="C:\Programme\Microsoft SQL Server\"
TARGETDIR="C:\Programme\Microsoft SQL Server\"
SAPWD="AStrongPwd"
SECURITYMODE=SQL
and installed most of them sucessfully. Some of them I installed via network, some of them were installed from CD. I tested each installation by copying a prepared database into the data directory and tried to connect to this database using the specified sapwd and found out
When i installed from CD, I could connect to the databases.
Some of the network installs produce a logon failure. it looks like the sapwd was ignored during install - I could not figure out, which password was used, I uninstalled it and reinstalled from CD.
Does anyone know what's the reason for this behaviour?
Thanks,
clothildeGet any information from SQLSTP.LOG on those failed installations for this behaviour.
I prepared a setup.ini file:
[Options]
DATADIR="C:\Programme\Microsoft SQL Server\"
TARGETDIR="C:\Programme\Microsoft SQL Server\"
SAPWD="AStrongPwd"
SECURITYMODE=SQL
and installed most of them sucessfully. Some of them I installed via network, some of them were installed from CD. I tested each installation by copying a prepared database into the data directory and tried to connect to this database using the specified sapwd and found out
When i installed from CD, I could connect to the databases.
Some of the network installs produce a logon failure. it looks like the sapwd was ignored during install - I could not figure out, which password was used, I uninstalled it and reinstalled from CD.
Does anyone know what's the reason for this behaviour?
Thanks,
clothildeGet any information from SQLSTP.LOG on those failed installations for this behaviour.
MSDE setup question
Hello:
I had partitioned my harddrive to have both XP PRO and Red Hat. Got fed up with all that and so used Partition Magic 8.0 to repartition the drive to be one 16 Gig drive. I still have over 8 Gig left on it even after installing VS .NET on it.
I have successfully installed Visual Studio .NET Pro 2003 on it and I can now write programs in VB and see it on my intranet at c:/wwwroot/.
I am now trying to install MSDE 2000 for Developers Using VS .NET. I have downloaded the file from Microsoft and then when I go to install it on my hard drive it tells me it cannot; I have to free up 92.44 Megs for it to be able to extract it to my c drive.
I am a newbee and any help will be GREATLY appreciated!!Sorry but have solved this problem too.
Turns out I was using the wrong download.
Thanx anyways.|||Ohh Boy, you are really working under a tight Hard drive. With 92.44 Megs, any software would complain about free space. Free up some space and try it. Some harddisk space is needed for paging and stuff, so its very normal your program complaining about the disk space. I hope thats what your problem is.
If you are having trouble installing the MSDE, take a look at my blog entry
Let us know your exact issue
MSDE setup problems
I am attempting to install SharePoint Services (with
MSDE) using all standard/default options. The WSS setup
appears to proceed normally until it attempts to
configure the MSDE. This portion of the WSS setup fails
and I receive the following error message:
MICROSFOT SQL SERVER DESKTOP ENGINE
Setup failed to configure the server. Refer to the server
error logs and setup error logs for more information.
Not sure where to find these two logs are located or why
the MSDE setup failed.
Any help resolving this problem will be appreciated.
Jim
hi Jim,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:ecbf01c43d3c$230fb2e0$a401280a@.phx.gbl...
> I am attempting to install SharePoint Services (with
> MSDE) using all standard/default options. The WSS setup
> appears to proceed normally until it attempts to
> configure the MSDE. This portion of the WSS setup fails
> and I receive the following error message:
> MICROSFOT SQL SERVER DESKTOP ENGINE
> Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
> Not sure where to find these two logs are located or why
> the MSDE setup failed.
> Any help resolving this problem will be appreciated.
> Jim
please have a look at
http://support.microsoft.com/default...99&Product=sql
hth
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
|||Thanks Andrea. This is just the KB article that I was
looking for.
Jim
>--Original Message--
>hi Jim,
><anonymous@.discussions.microsoft.com> ha scritto nel
messaggio[vbcol=seagreen]
>news:ecbf01c43d3c$230fb2e0$a401280a@.phx.gbl...
server[vbcol=seagreen]
why
>please have a look at
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;816499&Product=sql
>hth
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||I have the same problem. However, after using the
solutions mentioned in that KB, I still got the same
error " Setup failed to configure the server".
Choi
>--Original Message--
>hi Jim,
><anonymous@.discussions.microsoft.com> ha scritto nel
messaggio[vbcol=seagreen]
>news:ecbf01c43d3c$230fb2e0$a401280a@.phx.gbl...
server
>please have a look at
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;816499&Product=sql
>hth
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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) using all standard/default options. The WSS setup
appears to proceed normally until it attempts to
configure the MSDE. This portion of the WSS setup fails
and I receive the following error message:
MICROSFOT SQL SERVER DESKTOP ENGINE
Setup failed to configure the server. Refer to the server
error logs and setup error logs for more information.
Not sure where to find these two logs are located or why
the MSDE setup failed.
Any help resolving this problem will be appreciated.
Jim
hi Jim,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:ecbf01c43d3c$230fb2e0$a401280a@.phx.gbl...
> I am attempting to install SharePoint Services (with
> MSDE) using all standard/default options. The WSS setup
> appears to proceed normally until it attempts to
> configure the MSDE. This portion of the WSS setup fails
> and I receive the following error message:
> MICROSFOT SQL SERVER DESKTOP ENGINE
> Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
> Not sure where to find these two logs are located or why
> the MSDE setup failed.
> Any help resolving this problem will be appreciated.
> Jim
please have a look at
http://support.microsoft.com/default...99&Product=sql
hth
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
|||Thanks Andrea. This is just the KB article that I was
looking for.
Jim
>--Original Message--
>hi Jim,
><anonymous@.discussions.microsoft.com> ha scritto nel
messaggio[vbcol=seagreen]
>news:ecbf01c43d3c$230fb2e0$a401280a@.phx.gbl...
server[vbcol=seagreen]
why
>please have a look at
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;816499&Product=sql
>hth
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||I have the same problem. However, after using the
solutions mentioned in that KB, I still got the same
error " Setup failed to configure the server".
Choi
>--Original Message--
>hi Jim,
><anonymous@.discussions.microsoft.com> ha scritto nel
messaggio[vbcol=seagreen]
>news:ecbf01c43d3c$230fb2e0$a401280a@.phx.gbl...
server
>please have a look at
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;816499&Product=sql
>hth
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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 SetUp Hell: Newbie Help
I am trying to setup MSDE for the very first time. So I am absolutely a
newbie. I downloaded sql2ksp3 from microsoft site. I unpacked the file to a
folder and then clicked on setup.
I get an error message about using the command line to supply a strong
password and the setup exits...
I use the command line to supply a password like
setup SAPWD="Pwd777b7" and then the setup seems to install or change some
files.
I click on the setup again and I get an error an invalid Instance name name
error. I have read and reread the (from a first user's point of view) the
very unhelpful help file I download with MSDE setup.
I have been going back and forth on this. Anyone know what's wrong... Anyone
know of a URL where I can find a step-by-step method of installing MSDE.
Thanks in advance
hi,
JP Bless wrote:
> I am trying to setup MSDE for the very first time. So I am absolutely
> a newbie. I downloaded sql2ksp3 from microsoft site. I unpacked the
> file to a folder and then clicked on setup.
> I get an error message about using the command line to supply a strong
> password and the setup exits...
> I use the command line to supply a password like
> setup SAPWD="Pwd777b7" and then the setup seems to install or change
> some files.
you should have a new default instace of MSDE installed, with no network
protocols enabled and allowing only Windows authenticated connections..
please verify using the Windows Services applet (control panel->management
tools->services) you have a MSSQLSERVER and SQLSERVERAGENT entry for the
related services...
> I click on the setup again and I get an error an invalid Instance
> name name error.
it failed as you tried that way to install a second default instance of MSDE
and ony 1 default instace is allowed... you can install other (up to 15, for
a max of 16 instances in total) named instances providing the additional
parameter
INSTANCENAME=whatever_name
>I have read and reread the (from a first user's
> point of view) the very unhelpful help file I download with MSDE
> setup.
> I have been going back and forth on this. Anyone know what's wrong...
> Anyone know of a URL where I can find a step-by-step method of
> installing MSDE.
>
if you can read/understand french,
http://perso.wanadoo.fr/jm.doudoux/m...msde/msde.htm, if you can
read/understand italian, http://www.visual-basic.it/articoli/scMsde01.htm,
but I do not know english sites
anyway, you should not just click on the setup.exe boostrap installer but
call it from a command window and provide all the required parameters,
usually (depending on your needs) in the form of
c:\...\>setupe.exe INSTANCENAME=whatever SAPWD=your_strong_pwd
SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 /L*v "C:\MSDELOG.txt"
this typical command line will install a named instance named "whatever",
with "sa" login pwd = "your_strong_pwd", enabling SQL Server standard
connections (mixed mode authentication, allowing both integrated security a
standard SQL Server connections), enabling network protocols and thus
enabling remote connections and finally enabling verbose logging of the
installation process to a text file of about 2mb for a successfull
installation you can inspect in case of troubles for
RETURN VALUE 3
entries... this entries are localized in the particular MSDE localized
flavour, and about 10/15 lines before each entry some (sometime cryptic)
description of the problem will be reported...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea. It helped. Now I am done with with installation, I guess I
just cleared the first hurdle. My next task is to know how to add tables and
queries. I see there is no GUI (like Enterprise Manager) in the full/server
version, to administer/add table/Queries etc. Any tips where to begin?
Once again, thanks for the help, I really appreciate it.
Joe
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3rv3laFloeqnU1@.individual.net...
> hi,
> JP Bless wrote:
> you should have a new default instace of MSDE installed, with no network
> protocols enabled and allowing only Windows authenticated connections..
> please verify using the Windows Services applet (control panel->management
> tools->services) you have a MSSQLSERVER and SQLSERVERAGENT entry for the
> related services...
> it failed as you tried that way to install a second default instance of
MSDE
> and ony 1 default instace is allowed... you can install other (up to 15,
for
> a max of 16 instances in total) named instances providing the additional
> parameter
> INSTANCENAME=whatever_name
>
> if you can read/understand french,
> http://perso.wanadoo.fr/jm.doudoux/m...msde/msde.htm, if you can
> read/understand italian, http://www.visual-basic.it/articoli/scMsde01.htm,
> but I do not know english sites
> anyway, you should not just click on the setup.exe boostrap installer but
> call it from a command window and provide all the required parameters,
> usually (depending on your needs) in the form of
> c:\...\>setupe.exe INSTANCENAME=whatever SAPWD=your_strong_pwd
> SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 /L*v "C:\MSDELOG.txt"
> this typical command line will install a named instance named "whatever",
> with "sa" login pwd = "your_strong_pwd", enabling SQL Server standard
> connections (mixed mode authentication, allowing both integrated security
a
> standard SQL Server connections), enabling network protocols and thus
> enabling remote connections and finally enabling verbose logging of the
> installation process to a text file of about 2mb for a successfull
> installation you can inspect in case of troubles for
> RETURN VALUE 3
> entries... this entries are localized in the particular MSDE localized
> flavour, and about 10/15 lines before each entry some (sometime cryptic)
> description of the problem will be reported...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Joe,
JP Bless wrote:
> Thanks Andrea. It helped. Now I am done with with installation, I
> guess I just cleared the first hurdle. My next task is to know how to
> add tables and queries. I see there is no GUI (like Enterprise
> Manager) in the full/server version, to administer/add table/Queries
> etc. Any tips where to begin?
>
my tip is to use the prj you can find at the link following my sign., which
provides free a user interface similar to Enterprise Manager written in vb6
on top of SQL-DMO object model as long as a lot of dynamic SQL :D, but I'm
deeply involved in that advice :D
you have further choices, both commercial and free at
http://www.microsoft.com/sql/msde/partners and
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.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks a million... I appreciate the help. I will look at the sites and
tools.
Once again thanks.
Joe
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3rvco3FkpmcvU1@.individual.net...
> hi Joe,
> JP Bless wrote:
> my tip is to use the prj you can find at the link following my sign.,
which
> provides free a user interface similar to Enterprise Manager written in
vb6
> on top of SQL-DMO object model as long as a lot of dynamic SQL :D, but I'm
> deeply involved in that advice :D
> you have further choices, both commercial and free at
> http://www.microsoft.com/sql/msde/partners and
> 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.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
newbie. I downloaded sql2ksp3 from microsoft site. I unpacked the file to a
folder and then clicked on setup.
I get an error message about using the command line to supply a strong
password and the setup exits...
I use the command line to supply a password like
setup SAPWD="Pwd777b7" and then the setup seems to install or change some
files.
I click on the setup again and I get an error an invalid Instance name name
error. I have read and reread the (from a first user's point of view) the
very unhelpful help file I download with MSDE setup.
I have been going back and forth on this. Anyone know what's wrong... Anyone
know of a URL where I can find a step-by-step method of installing MSDE.
Thanks in advance
hi,
JP Bless wrote:
> I am trying to setup MSDE for the very first time. So I am absolutely
> a newbie. I downloaded sql2ksp3 from microsoft site. I unpacked the
> file to a folder and then clicked on setup.
> I get an error message about using the command line to supply a strong
> password and the setup exits...
> I use the command line to supply a password like
> setup SAPWD="Pwd777b7" and then the setup seems to install or change
> some files.
you should have a new default instace of MSDE installed, with no network
protocols enabled and allowing only Windows authenticated connections..
please verify using the Windows Services applet (control panel->management
tools->services) you have a MSSQLSERVER and SQLSERVERAGENT entry for the
related services...
> I click on the setup again and I get an error an invalid Instance
> name name error.
it failed as you tried that way to install a second default instance of MSDE
and ony 1 default instace is allowed... you can install other (up to 15, for
a max of 16 instances in total) named instances providing the additional
parameter
INSTANCENAME=whatever_name
>I have read and reread the (from a first user's
> point of view) the very unhelpful help file I download with MSDE
> setup.
> I have been going back and forth on this. Anyone know what's wrong...
> Anyone know of a URL where I can find a step-by-step method of
> installing MSDE.
>
if you can read/understand french,
http://perso.wanadoo.fr/jm.doudoux/m...msde/msde.htm, if you can
read/understand italian, http://www.visual-basic.it/articoli/scMsde01.htm,
but I do not know english sites
anyway, you should not just click on the setup.exe boostrap installer but
call it from a command window and provide all the required parameters,
usually (depending on your needs) in the form of
c:\...\>setupe.exe INSTANCENAME=whatever SAPWD=your_strong_pwd
SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 /L*v "C:\MSDELOG.txt"
this typical command line will install a named instance named "whatever",
with "sa" login pwd = "your_strong_pwd", enabling SQL Server standard
connections (mixed mode authentication, allowing both integrated security a
standard SQL Server connections), enabling network protocols and thus
enabling remote connections and finally enabling verbose logging of the
installation process to a text file of about 2mb for a successfull
installation you can inspect in case of troubles for
RETURN VALUE 3
entries... this entries are localized in the particular MSDE localized
flavour, and about 10/15 lines before each entry some (sometime cryptic)
description of the problem will be reported...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea. It helped. Now I am done with with installation, I guess I
just cleared the first hurdle. My next task is to know how to add tables and
queries. I see there is no GUI (like Enterprise Manager) in the full/server
version, to administer/add table/Queries etc. Any tips where to begin?
Once again, thanks for the help, I really appreciate it.
Joe
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3rv3laFloeqnU1@.individual.net...
> hi,
> JP Bless wrote:
> you should have a new default instace of MSDE installed, with no network
> protocols enabled and allowing only Windows authenticated connections..
> please verify using the Windows Services applet (control panel->management
> tools->services) you have a MSSQLSERVER and SQLSERVERAGENT entry for the
> related services...
> it failed as you tried that way to install a second default instance of
MSDE
> and ony 1 default instace is allowed... you can install other (up to 15,
for
> a max of 16 instances in total) named instances providing the additional
> parameter
> INSTANCENAME=whatever_name
>
> if you can read/understand french,
> http://perso.wanadoo.fr/jm.doudoux/m...msde/msde.htm, if you can
> read/understand italian, http://www.visual-basic.it/articoli/scMsde01.htm,
> but I do not know english sites
> anyway, you should not just click on the setup.exe boostrap installer but
> call it from a command window and provide all the required parameters,
> usually (depending on your needs) in the form of
> c:\...\>setupe.exe INSTANCENAME=whatever SAPWD=your_strong_pwd
> SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 /L*v "C:\MSDELOG.txt"
> this typical command line will install a named instance named "whatever",
> with "sa" login pwd = "your_strong_pwd", enabling SQL Server standard
> connections (mixed mode authentication, allowing both integrated security
a
> standard SQL Server connections), enabling network protocols and thus
> enabling remote connections and finally enabling verbose logging of the
> installation process to a text file of about 2mb for a successfull
> installation you can inspect in case of troubles for
> RETURN VALUE 3
> entries... this entries are localized in the particular MSDE localized
> flavour, and about 10/15 lines before each entry some (sometime cryptic)
> description of the problem will be reported...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Joe,
JP Bless wrote:
> Thanks Andrea. It helped. Now I am done with with installation, I
> guess I just cleared the first hurdle. My next task is to know how to
> add tables and queries. I see there is no GUI (like Enterprise
> Manager) in the full/server version, to administer/add table/Queries
> etc. Any tips where to begin?
>
my tip is to use the prj you can find at the link following my sign., which
provides free a user interface similar to Enterprise Manager written in vb6
on top of SQL-DMO object model as long as a lot of dynamic SQL :D, but I'm
deeply involved in that advice :D
you have further choices, both commercial and free at
http://www.microsoft.com/sql/msde/partners and
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.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks a million... I appreciate the help. I will look at the sites and
tools.
Once again thanks.
Joe
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3rvco3FkpmcvU1@.individual.net...
> hi Joe,
> JP Bless wrote:
> my tip is to use the prj you can find at the link following my sign.,
which
> provides free a user interface similar to Enterprise Manager written in
vb6
> on top of SQL-DMO object model as long as a lot of dynamic SQL :D, but I'm
> deeply involved in that advice :D
> you have further choices, both commercial and free at
> http://www.microsoft.com/sql/msde/partners and
> 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.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
MSDE Setup fails...
I don't think I've ever worked so long and tried so many suggestions,
recommendations and followed KB article processes in my life with so little
success -- in fact, none -- and so intransigent a set of symptoms. I hope
that there is someone here that will be able to help me.
To set the hardware scene: I have a 3 year old Sony Vaio with P4 HT 3.2
ghz, 1GB ram, 560 GB of hard drive and a new ATI video card. It has had
lots of software installed and removed over the last couple of years. My
wife has an almost identical eMachine that is 9 months old and is still in
the exact state that it was when it came out of the box. Both run XP Pro
sp2.
The problem: I purchased a copy of Pinnacle Studio Plus vers 10 video
editing software. With it I got also their media manager which uses MSDE.
I have not been able to successfully install that software. It gets to the
exact same spot (says that it is 5 sec from finishing the MSDE setup) and
then quits with an error every time. I've tried manually installing MSDE
and the symptoms and results are exactly the same -- each and every time.
I've verified that File & print sharing are installed and enabled. I've
verified that my policy is to install unsigned drivers. I've cleaned out
the registry of failed attempt entries. I've removed all of the file
directories. I've run the MDAC repair that I found in another post here.
I've got the setup logs and the error logs, including the verbose log from
my manual attempt but it has not helped me.
Nothing has made one single iota of a difference. Kinda like trying to
teach a pig to tell time -- won't work, just irritates the pig and
frustrates you.
Now, here's the kicker: I tried the install on my wife's machine and it
went perfectly. Installed without a hitch.
The logs (setup & error) are similar, but as you might guess, differ in a
couple of key respects. I have put the successful setup log and error log
into a spreadsheet along with the unsuccessful setup log and error log.
I've matched the common entries from both on the same row and hi-lighted the
differences.
If there is someone here that can help me I can provide this file, or
anything else related that you might need, via e-mail.
Can someone give me a hand with this?
Frustrated in Seattle
I ran the verification software and it showed that I had all MDAC 2.8 sp1
components installed with no differences/issues detected.
I noticed that I don't have a service, much less one running, for MSSQL. So
I installed MS SQL Server 2005 Express. It installed perfectly and
afterwards the service was there and running. However, MSDE still wouldn't
install -- exact same behavior.
I did find another log [extension was ".out"] and it also is pointing to an
ODBC problem. Nowhere in any instructions does it say anything about
setting up any ODBC connections so I suspect this may be a red herring. But
I did put it right after this note for reference.
I clearly don't know what I'm talking about but I'm getting the sense that I
don't really need SQL Server installed because MSDE is supposed to be some
sort of "light" version for the desktop. So the fact that MSDE is not
installing may account for why there was no MSSQL service before I installed
SQL Server 2005 Express.
Btw, I've verified that File & Print sharing is enabled and that unsigned
drivers are set to install automatically -- two things that MS KB identified
as potential related issues. I've gone through and completely removed all
registry vestiges of the product and the file directories and started over
from scratch. The result was exactly the same.
The first error that it encounters is when it tries to configure the new
server it's installing and it's an unrecoverable error. I've included the
log entries for that as well.
Still looking for help. Sigh...
Howard
################################################## #######################
====SQL Server Error Log====
2006-01-26 20:40:34.31 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 2)
2006-01-26 20:40:34.32 server Copyright (C) 1988-2002 Microsoft Corporation.
2006-01-26 20:40:34.32 server All rights reserved.
2006-01-26 20:40:34.32 server Server Process ID is 2460.
2006-01-26 20:40:34.32 server Logging SQL Server messages in file
'C:\Program Files\Pinnacle\MediaServer\Microsoft SQL
Server\MSSQL$PINNACLESYS\LOG\ERRORLOG'.
2006-01-26 20:40:34.34 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2006-01-26 20:40:34.49 server SQL Server configured for thread mode
processing.
2006-01-26 20:40:34.49 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2006-01-26 20:40:34.53 spid3 Warning ******************
2006-01-26 20:40:34.53 spid3 SQL Server started in single user mode. Updates
allowed to system catalogs.
2006-01-26 20:40:34.68 spid3 Starting up database 'master'.
2006-01-26 20:40:35.15 server Using 'SSNETLIB.DLL' version '8.0.766'.
2006-01-26 20:40:35.17 spid5 Starting up database 'model'.
2006-01-26 20:40:35.28 spid3 Server name is 'OFFICE\PINNACLESYS'.
2006-01-26 20:40:35.28 spid3 Skipping startup of clean database id 5
2006-01-26 20:40:35.28 spid3 Skipping startup of clean database id 6
2006-01-26 20:40:35.28 spid3 Starting up database 'msdb'.
2006-01-26 20:40:35.28 server SQL server listening on 192.168.1.100: 1465.
2006-01-26 20:40:35.28 server SQL server listening on 127.0.0.1: 1465.
2006-01-26 20:40:35.28 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-01-26 20:40:35.28 server SQL Server is ready for client connections
2006-01-26 20:40:35.78 spid5 Clearing tempdb database.
2006-01-26 20:40:36.84 spid5 Starting up database 'tempdb'.
2006-01-26 20:40:37.03 spid3 Recovery complete.
2006-01-26 20:40:37.03 spid3 SQL global counter collection task is created.
2006-01-26 20:40:37.12 spid3 Warning: override, autoexec procedures skipped.
2006-01-26 20:40:44.71 spid3 SQL Server is terminating due to 'stop' request
from Service Control Manager.
================================================== =====================
====Verbose MSDE Install Log=====
Starting custom action SkuIt
MSI (s) (A4:A4) [22:15:37:640]: Executing op:
ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_A BC9_EAB2C064397B...
MSI (s) (A4:A4) [22:15:37:640]: Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (A4:A0) [22:15:37:656]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3F.tmp, Entrypoint: ConfigServer
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Howard\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Howard\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
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
"SQL_Latin1_General_CP1_CI_AS""
MSI (c) (54:98) [22:16:04:703]: Font created. Charset: Req=0, Ret=0, Font:
Req=MS Shell Dlg, Ret=MS Shell Dlg
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (A4!20) [22:16:08:500]: Product: Microsoft SQL Server Desktop
Engine -- Setup failed to configure the server. Refer to the server error
logs and setup error logs for more information.
Action ended 22:16:08: InstallFinalize. Return value 3.
################################################## ##########################===Configure.out===Start ing Service ...SQL_Latin1_General_CP1_CI_AS -m -Q -T4022 -T3659Connecting to Server ...driver={sql server};server=OFFICE\PINNACLESYS;UID=sa;PWD=;data base=
master[Microsoft][ODBC Driver Manager] Data source name not found and no defaultdriver specifieddriver={sql server};server=OFFICE\PINNACLESYS;UID=sa;PWD=;data base=master[Microsoft][ODBC Driver Manager] Data source name not found and no defaultdriver speci
fieddriver={sql server};server=OFFICE\PINNACLESYS;UID=sa;PWD=;data base=master[Microsoft][ODBC Driver Manager] Data source name not found and no defaultdriver specifiedSQL Server configuration failed.########################################### #############
####################
|||hi Howard,
Howard Woodard wrote:
> MSI (s) (A4!20) [22:16:08:500]: Product: Microsoft SQL Server Desktop
> Engine -- Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
> Action ended 22:16:08: InstallFinalize. Return value 3.
this error is usually related to
http://support.microsoft.com/default...9&Product=sql,
but I do think you already noticed and tried it's advices...
another non indicated cause I'm aware of is related to MDAC stack
corruption, as you alredy reported, tha could be fixed as reported in
http://www.macropool.com/en/download/mdac_xp_sp2.html.. but it seems to me
you already checked that...
other causes... to the besto of my knowledge, unfortunately I can not help
further...
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
|||Thanks Andrea. There is one more thing that you can help me with if you
would. It appears that there is some expectation that I would already have
a Microsoft Sql Server directory under the Program Files directory and
possibly even an SQLSERVER service running. Is that right? I have neither
and see no option for installing it from my XP Pro CD.
Can you confirm what I should be looking for please?
Tia,
Howard
==========================================
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:44eh20F1qf9sU1@.individual.net...
> hi Howard,
> Howard Woodard wrote:
> this error is usually related to
> http://support.microsoft.com/default...9&Product=sql,
> but I do think you already noticed and tried it's advices...
> another non indicated cause I'm aware of is related to MDAC stack
> corruption, as you alredy reported, tha could be fixed as reported in
> http://www.macropool.com/en/download/mdac_xp_sp2.html.. but it seems to me
> you already checked that...
> other causes... to the besto of my knowledge, unfortunately I can not help
> further...
> --
> 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
>
|||Never mind. I got this figured out. MSDE installs from the XP Office CD,
not from the XP Pro CD.
I reinstalled it and then my video editing software was able to install the
instance that it needed.
Thanks for helping me.
==============================
"Howard Woodard" <woodard@.msn.com> wrote in message
news:uqrrZUGKGHA.740@.TK2MSFTNGP12.phx.gbl...
> Thanks Andrea. There is one more thing that you can help me with if you
> would. It appears that there is some expectation that I would already
> have a Microsoft Sql Server directory under the Program Files directory
> and possibly even an SQLSERVER service running. Is that right? I have
> neither and see no option for installing it from my XP Pro CD.
> Can you confirm what I should be looking for please?
> Tia,
> Howard
> ==========================================
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:44eh20F1qf9sU1@.individual.net...
>
sql
recommendations and followed KB article processes in my life with so little
success -- in fact, none -- and so intransigent a set of symptoms. I hope
that there is someone here that will be able to help me.
To set the hardware scene: I have a 3 year old Sony Vaio with P4 HT 3.2
ghz, 1GB ram, 560 GB of hard drive and a new ATI video card. It has had
lots of software installed and removed over the last couple of years. My
wife has an almost identical eMachine that is 9 months old and is still in
the exact state that it was when it came out of the box. Both run XP Pro
sp2.
The problem: I purchased a copy of Pinnacle Studio Plus vers 10 video
editing software. With it I got also their media manager which uses MSDE.
I have not been able to successfully install that software. It gets to the
exact same spot (says that it is 5 sec from finishing the MSDE setup) and
then quits with an error every time. I've tried manually installing MSDE
and the symptoms and results are exactly the same -- each and every time.
I've verified that File & print sharing are installed and enabled. I've
verified that my policy is to install unsigned drivers. I've cleaned out
the registry of failed attempt entries. I've removed all of the file
directories. I've run the MDAC repair that I found in another post here.
I've got the setup logs and the error logs, including the verbose log from
my manual attempt but it has not helped me.
Nothing has made one single iota of a difference. Kinda like trying to
teach a pig to tell time -- won't work, just irritates the pig and
frustrates you.
Now, here's the kicker: I tried the install on my wife's machine and it
went perfectly. Installed without a hitch.
The logs (setup & error) are similar, but as you might guess, differ in a
couple of key respects. I have put the successful setup log and error log
into a spreadsheet along with the unsuccessful setup log and error log.
I've matched the common entries from both on the same row and hi-lighted the
differences.
If there is someone here that can help me I can provide this file, or
anything else related that you might need, via e-mail.
Can someone give me a hand with this?
Frustrated in Seattle
I ran the verification software and it showed that I had all MDAC 2.8 sp1
components installed with no differences/issues detected.
I noticed that I don't have a service, much less one running, for MSSQL. So
I installed MS SQL Server 2005 Express. It installed perfectly and
afterwards the service was there and running. However, MSDE still wouldn't
install -- exact same behavior.
I did find another log [extension was ".out"] and it also is pointing to an
ODBC problem. Nowhere in any instructions does it say anything about
setting up any ODBC connections so I suspect this may be a red herring. But
I did put it right after this note for reference.
I clearly don't know what I'm talking about but I'm getting the sense that I
don't really need SQL Server installed because MSDE is supposed to be some
sort of "light" version for the desktop. So the fact that MSDE is not
installing may account for why there was no MSSQL service before I installed
SQL Server 2005 Express.
Btw, I've verified that File & Print sharing is enabled and that unsigned
drivers are set to install automatically -- two things that MS KB identified
as potential related issues. I've gone through and completely removed all
registry vestiges of the product and the file directories and started over
from scratch. The result was exactly the same.
The first error that it encounters is when it tries to configure the new
server it's installing and it's an unrecoverable error. I've included the
log entries for that as well.
Still looking for help. Sigh...
Howard
################################################## #######################
====SQL Server Error Log====
2006-01-26 20:40:34.31 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 2)
2006-01-26 20:40:34.32 server Copyright (C) 1988-2002 Microsoft Corporation.
2006-01-26 20:40:34.32 server All rights reserved.
2006-01-26 20:40:34.32 server Server Process ID is 2460.
2006-01-26 20:40:34.32 server Logging SQL Server messages in file
'C:\Program Files\Pinnacle\MediaServer\Microsoft SQL
Server\MSSQL$PINNACLESYS\LOG\ERRORLOG'.
2006-01-26 20:40:34.34 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2006-01-26 20:40:34.49 server SQL Server configured for thread mode
processing.
2006-01-26 20:40:34.49 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2006-01-26 20:40:34.53 spid3 Warning ******************
2006-01-26 20:40:34.53 spid3 SQL Server started in single user mode. Updates
allowed to system catalogs.
2006-01-26 20:40:34.68 spid3 Starting up database 'master'.
2006-01-26 20:40:35.15 server Using 'SSNETLIB.DLL' version '8.0.766'.
2006-01-26 20:40:35.17 spid5 Starting up database 'model'.
2006-01-26 20:40:35.28 spid3 Server name is 'OFFICE\PINNACLESYS'.
2006-01-26 20:40:35.28 spid3 Skipping startup of clean database id 5
2006-01-26 20:40:35.28 spid3 Skipping startup of clean database id 6
2006-01-26 20:40:35.28 spid3 Starting up database 'msdb'.
2006-01-26 20:40:35.28 server SQL server listening on 192.168.1.100: 1465.
2006-01-26 20:40:35.28 server SQL server listening on 127.0.0.1: 1465.
2006-01-26 20:40:35.28 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-01-26 20:40:35.28 server SQL Server is ready for client connections
2006-01-26 20:40:35.78 spid5 Clearing tempdb database.
2006-01-26 20:40:36.84 spid5 Starting up database 'tempdb'.
2006-01-26 20:40:37.03 spid3 Recovery complete.
2006-01-26 20:40:37.03 spid3 SQL global counter collection task is created.
2006-01-26 20:40:37.12 spid3 Warning: override, autoexec procedures skipped.
2006-01-26 20:40:44.71 spid3 SQL Server is terminating due to 'stop' request
from Service Control Manager.
================================================== =====================
====Verbose MSDE Install Log=====
Starting custom action SkuIt
MSI (s) (A4:A4) [22:15:37:640]: Executing op:
ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_A BC9_EAB2C064397B...
MSI (s) (A4:A4) [22:15:37:640]: Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (A4:A0) [22:15:37:656]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI3F.tmp, Entrypoint: ConfigServer
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Howard\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Howard\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
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
"SQL_Latin1_General_CP1_CI_AS""
MSI (c) (54:98) [22:16:04:703]: Font created. Charset: Req=0, Ret=0, Font:
Req=MS Shell Dlg, Ret=MS Shell Dlg
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (A4!20) [22:16:08:500]: Product: Microsoft SQL Server Desktop
Engine -- Setup failed to configure the server. Refer to the server error
logs and setup error logs for more information.
Action ended 22:16:08: InstallFinalize. Return value 3.
################################################## ##########################===Configure.out===Start ing Service ...SQL_Latin1_General_CP1_CI_AS -m -Q -T4022 -T3659Connecting to Server ...driver={sql server};server=OFFICE\PINNACLESYS;UID=sa;PWD=;data base=
master[Microsoft][ODBC Driver Manager] Data source name not found and no defaultdriver specifieddriver={sql server};server=OFFICE\PINNACLESYS;UID=sa;PWD=;data base=master[Microsoft][ODBC Driver Manager] Data source name not found and no defaultdriver speci
fieddriver={sql server};server=OFFICE\PINNACLESYS;UID=sa;PWD=;data base=master[Microsoft][ODBC Driver Manager] Data source name not found and no defaultdriver specifiedSQL Server configuration failed.########################################### #############
####################
|||hi Howard,
Howard Woodard wrote:
> MSI (s) (A4!20) [22:16:08:500]: Product: Microsoft SQL Server Desktop
> Engine -- Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
> Action ended 22:16:08: InstallFinalize. Return value 3.
this error is usually related to
http://support.microsoft.com/default...9&Product=sql,
but I do think you already noticed and tried it's advices...
another non indicated cause I'm aware of is related to MDAC stack
corruption, as you alredy reported, tha could be fixed as reported in
http://www.macropool.com/en/download/mdac_xp_sp2.html.. but it seems to me
you already checked that...
other causes... to the besto of my knowledge, unfortunately I can not help
further...
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
|||Thanks Andrea. There is one more thing that you can help me with if you
would. It appears that there is some expectation that I would already have
a Microsoft Sql Server directory under the Program Files directory and
possibly even an SQLSERVER service running. Is that right? I have neither
and see no option for installing it from my XP Pro CD.
Can you confirm what I should be looking for please?
Tia,
Howard
==========================================
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:44eh20F1qf9sU1@.individual.net...
> hi Howard,
> Howard Woodard wrote:
> this error is usually related to
> http://support.microsoft.com/default...9&Product=sql,
> but I do think you already noticed and tried it's advices...
> another non indicated cause I'm aware of is related to MDAC stack
> corruption, as you alredy reported, tha could be fixed as reported in
> http://www.macropool.com/en/download/mdac_xp_sp2.html.. but it seems to me
> you already checked that...
> other causes... to the besto of my knowledge, unfortunately I can not help
> further...
> --
> 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
>
|||Never mind. I got this figured out. MSDE installs from the XP Office CD,
not from the XP Pro CD.
I reinstalled it and then my video editing software was able to install the
instance that it needed.
Thanks for helping me.
==============================
"Howard Woodard" <woodard@.msn.com> wrote in message
news:uqrrZUGKGHA.740@.TK2MSFTNGP12.phx.gbl...
> Thanks Andrea. There is one more thing that you can help me with if you
> would. It appears that there is some expectation that I would already
> have a Microsoft Sql Server directory under the Program Files directory
> and possibly even an SQLSERVER service running. Is that right? I have
> neither and see no option for installing it from my XP Pro CD.
> Can you confirm what I should be looking for please?
> Tia,
> Howard
> ==========================================
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:44eh20F1qf9sU1@.individual.net...
>
sql
MSDE setup failed
was installing MSDE for use with Web matrix
thot had done all correctly ie the setup.exe sapwd=xxxxx securitymode=sql from the command prompt
was told that setup has failed
where is the problemWas there any other information provided with the error message? If the message was "Setup Failed to configure the server" then this might help:
thot had done all correctly ie the setup.exe sapwd=xxxxx securitymode=sql from the command prompt
was told that setup has failed
where is the problemWas there any other information provided with the error message? If the message was "Setup Failed to configure the server" then this might help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql
Also, there should be a setup log created that might have more information.
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 setup errors - Act! 2005
My problem originates with trying to install Act! 2005.
This latest ver of Act! now requires MSDE 2000A. When the
program itself tries to install (along with MSDE in the
background), it hangs at the end, with Error 1603. Their
tech support suggested I try installing MSDE myself. That
install setup hung at the end, causing the error log
language below. Any suggestions on how to get MSDE to
follow thru on the setup?
I'm running WinXP Home. Full admin privs.
TempFolder is C:\DOCUME~1\Owner\LOCALS~1\Temp\{E09B48B5-
E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\Owner\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
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 "SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server
error logs and setup error logs for more information.
Action ended 18:12:05: InstallFinalize. Return value 3.
Hi Bill,
I'd suggest trying the verbose setup option and reading/posting the log file
produced.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:048901c49150$6e423360$a401280a@.phx.gbl...
> My problem originates with trying to install Act! 2005.
> This latest ver of Act! now requires MSDE 2000A. When the
> program itself tries to install (along with MSDE in the
> background), it hangs at the end, with Error 1603. Their
> tech support suggested I try installing MSDE myself. That
> install setup hung at the end, causing the error log
> language below. Any suggestions on how to get MSDE to
> follow thru on the setup?
> I'm running WinXP Home. Full admin privs.
> TempFolder is C:\DOCUME~1\Owner\LOCALS~1\Temp\{E09B48B5-
> E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \Owner\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
> \sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> 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 "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
> Action ended 18:12:05: InstallFinalize. Return value 3.
|||I had problems installing MSDE too. You might want to make sure you
have file and printer sharing for MS networks turned on. It worked
for me after turning it on. I'm not sure why.
-Bgarr
"Bill" <anonymous@.discussions.microsoft.com> wrote in message news:<048901c49150$6e423360$a401280a@.phx.gbl>...
> My problem originates with trying to install Act! 2005.
> This latest ver of Act! now requires MSDE 2000A. When the
> program itself tries to install (along with MSDE in the
> background), it hangs at the end, with Error 1603. Their
> tech support suggested I try installing MSDE myself. That
> install setup hung at the end, causing the error log
> language below. Any suggestions on how to get MSDE to
> follow thru on the setup?
> I'm running WinXP Home. Full admin privs.
> TempFolder is C:\DOCUME~1\Owner\LOCALS~1\Temp\{E09B48B5-
> E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \Owner\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
> \sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> 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 "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
> Action ended 18:12:05: InstallFinalize. Return value 3.
|||I, too, tried to install Act! 2005 tonight and was stopped by:
"Error: -1603 Fatal error during installation"
How do I make sure file and printer sharing are turned on. I'm on a
stand alone computer runing XP Home. Plenty of disk space.
Hoby, in Idaho
bgarrydo@.netscape.net (Bruce Garr) wrote in message news:<3136070.0409060431.2679afed@.posting.google.c om>...[vbcol=seagreen]
> I had problems installing MSDE too. You might want to make sure you
> have file and printer sharing for MS networks turned on. It worked
> for me after turning it on. I'm not sure why.
> -Bgarr
> "Bill" <anonymous@.discussions.microsoft.com> wrote in message news:<048901c49150$6e423360$a401280a@.phx.gbl>...
|||Greg, My computer help left and I am here to figure this
out myself. I can do some things on computer, but Verbose
setup is greek to me. How do I try this setup? Thanks.
Bill at badkochie@.yahoo.com Sept.2 reply
>--Original Message--
>Hi Bill,
>I'd suggest trying the verbose setup option and
reading/posting the log file
>produced.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"Bill" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:048901c49150$6e423360$a401280a@.phx.gbl...
the[vbcol=seagreen]
That[vbcol=seagreen]
D3605127224A}[vbcol=seagreen]
I "MSSQLSERVER" -[vbcol=seagreen]
server
>
>.
>
|||hi,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:89c101c49626$84ff6430$a301280a@.phx.gbl...
> Greg, My computer help left and I am here to figure this
> out myself. I can do some things on computer, but Verbose
> setup is greek to me. How do I try this setup? Thanks.
add the
/L*v "c:\msdelog.txt"
parameter to your command line parameters call for setup.exe
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
This latest ver of Act! now requires MSDE 2000A. When the
program itself tries to install (along with MSDE in the
background), it hangs at the end, with Error 1603. Their
tech support suggested I try installing MSDE myself. That
install setup hung at the end, causing the error log
language below. Any suggestions on how to get MSDE to
follow thru on the setup?
I'm running WinXP Home. Full admin privs.
TempFolder is C:\DOCUME~1\Owner\LOCALS~1\Temp\{E09B48B5-
E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\Owner\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
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 "SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server
error logs and setup error logs for more information.
Action ended 18:12:05: InstallFinalize. Return value 3.
Hi Bill,
I'd suggest trying the verbose setup option and reading/posting the log file
produced.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:048901c49150$6e423360$a401280a@.phx.gbl...
> My problem originates with trying to install Act! 2005.
> This latest ver of Act! now requires MSDE 2000A. When the
> program itself tries to install (along with MSDE in the
> background), it hangs at the end, with Error 1603. Their
> tech support suggested I try installing MSDE myself. That
> install setup hung at the end, causing the error log
> language below. Any suggestions on how to get MSDE to
> follow thru on the setup?
> I'm running WinXP Home. Full admin privs.
> TempFolder is C:\DOCUME~1\Owner\LOCALS~1\Temp\{E09B48B5-
> E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \Owner\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
> \sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> 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 "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
> Action ended 18:12:05: InstallFinalize. Return value 3.
|||I had problems installing MSDE too. You might want to make sure you
have file and printer sharing for MS networks turned on. It worked
for me after turning it on. I'm not sure why.
-Bgarr
"Bill" <anonymous@.discussions.microsoft.com> wrote in message news:<048901c49150$6e423360$a401280a@.phx.gbl>...
> My problem originates with trying to install Act! 2005.
> This latest ver of Act! now requires MSDE 2000A. When the
> program itself tries to install (along with MSDE in the
> background), it hangs at the end, with Error 1603. Their
> tech support suggested I try installing MSDE myself. That
> install setup hung at the end, causing the error log
> language below. Any suggestions on how to get MSDE to
> follow thru on the setup?
> I'm running WinXP Home. Full admin privs.
> TempFolder is C:\DOCUME~1\Owner\LOCALS~1\Temp\{E09B48B5-
> E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \Owner\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}
> \sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> 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 "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
> Action ended 18:12:05: InstallFinalize. Return value 3.
|||I, too, tried to install Act! 2005 tonight and was stopped by:
"Error: -1603 Fatal error during installation"
How do I make sure file and printer sharing are turned on. I'm on a
stand alone computer runing XP Home. Plenty of disk space.
Hoby, in Idaho
bgarrydo@.netscape.net (Bruce Garr) wrote in message news:<3136070.0409060431.2679afed@.posting.google.c om>...[vbcol=seagreen]
> I had problems installing MSDE too. You might want to make sure you
> have file and printer sharing for MS networks turned on. It worked
> for me after turning it on. I'm not sure why.
> -Bgarr
> "Bill" <anonymous@.discussions.microsoft.com> wrote in message news:<048901c49150$6e423360$a401280a@.phx.gbl>...
|||Greg, My computer help left and I am here to figure this
out myself. I can do some things on computer, but Verbose
setup is greek to me. How do I try this setup? Thanks.
Bill at badkochie@.yahoo.com Sept.2 reply
>--Original Message--
>Hi Bill,
>I'd suggest trying the verbose setup option and
reading/posting the log file
>produced.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"Bill" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:048901c49150$6e423360$a401280a@.phx.gbl...
the[vbcol=seagreen]
That[vbcol=seagreen]
D3605127224A}[vbcol=seagreen]
I "MSSQLSERVER" -[vbcol=seagreen]
server
>
>.
>
|||hi,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:89c101c49626$84ff6430$a301280a@.phx.gbl...
> Greg, My computer help left and I am here to figure this
> out myself. I can do some things on computer, but Verbose
> setup is greek to me. How do I try this setup? Thanks.
add the
/L*v "c:\msdelog.txt"
parameter to your command line parameters call for setup.exe
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 setup errors
I am trying install MSDE on XPSP2 pro. It fails the following set of erros
in the setup log. These lines are from a non-verbose log I created while
running the setup.
Appreciate any help.
Thanks
Shishir
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action SkuIt
Setting SqlEdition property failed
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
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 "SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (B4!D0) [17:39:55:781]: Product: Microsoft SQL Server Desktop Engine
-- Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
I got some info on the possible causes of failure as below. Unfortunately
neither of them help.
If your machine name has lowercase characters then you may be hitting this
issue - http://support.microsoft.com/default...;en-us;Q285100
If you had a old instance of MSDE on the machine you may be hitting this
issue - http://support.microsoft.com/default...b;en-us;816499
"Shishir" wrote:
> I am trying install MSDE on XPSP2 pro. It fails the following set of erros
> in the setup log. These lines are from a non-verbose log I created while
> running the setup.
> Appreciate any help.
> Thanks
> Shishir
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action SkuIt
> Setting SqlEdition property failed
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> 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 "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> MSI (s) (B4!D0) [17:39:55:781]: Product: Microsoft SQL Server Desktop Engine
> -- Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
>
|||hi Shishir,
Shishir wrote:
> I am trying install MSDE on XPSP2 pro. It fails the following set
> of erros in the setup log. These lines are from a non-verbose log I
> created while running the setup.
>..
> Engine -- Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
this exception is sometime related to MDAC stack corruption... as no MDAC XP
sp2 refresh is available to fix it, you can only go as indicated in
http://www.macropool.com/en/download/mdac_xp_sp2.html
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I downloaded the repair tool and reregistered all the components. It still
fails the same way.
"Andrea Montanari" wrote:
> hi Shishir,
> Shishir wrote:
> this exception is sometime related to MDAC stack corruption... as no MDAC XP
> sp2 refresh is available to fix it, you can only go as indicated in
> http://www.macropool.com/en/download/mdac_xp_sp2.html
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
sql
in the setup log. These lines are from a non-verbose log I created while
running the setup.
Appreciate any help.
Thanks
Shishir
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action SkuIt
Setting SqlEdition property failed
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
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 "SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (B4!D0) [17:39:55:781]: Product: Microsoft SQL Server Desktop Engine
-- Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
I got some info on the possible causes of failure as below. Unfortunately
neither of them help.
If your machine name has lowercase characters then you may be hitting this
issue - http://support.microsoft.com/default...;en-us;Q285100
If you had a old instance of MSDE on the machine you may be hitting this
issue - http://support.microsoft.com/default...b;en-us;816499
"Shishir" wrote:
> I am trying install MSDE on XPSP2 pro. It fails the following set of erros
> in the setup log. These lines are from a non-verbose log I created while
> running the setup.
> Appreciate any help.
> Thanks
> Shishir
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action SkuIt
> Setting SqlEdition property failed
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> 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 "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> MSI (s) (B4!D0) [17:39:55:781]: Product: Microsoft SQL Server Desktop Engine
> -- Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
>
|||hi Shishir,
Shishir wrote:
> I am trying install MSDE on XPSP2 pro. It fails the following set
> of erros in the setup log. These lines are from a non-verbose log I
> created while running the setup.
>..
> Engine -- Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
this exception is sometime related to MDAC stack corruption... as no MDAC XP
sp2 refresh is available to fix it, you can only go as indicated in
http://www.macropool.com/en/download/mdac_xp_sp2.html
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I downloaded the repair tool and reregistered all the components. It still
fails the same way.
"Andrea Montanari" wrote:
> hi Shishir,
> Shishir wrote:
> this exception is sometime related to MDAC stack corruption... as no MDAC XP
> sp2 refresh is available to fix it, you can only go as indicated in
> http://www.macropool.com/en/download/mdac_xp_sp2.html
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
sql
MSDE Setup and first database
I'm deploying MSDE with a desktop app (windows forms .net).
after installing MSDE, how do I create the database for the application?
I cannot provide a createdb.sql script to the user because there is no
queryanalyzer or similar tools.
How can I run the create query from the setup? or what is the recommended
method for doing this?
Thank You!
Hi,
Give a batch file to create the database. All you have to do is double click
the batch file. batch file should contain:-
OSQL -Usa -Ppassword -S servername -Q'Create database
dbname' -o'c:\createdb.log'
Save the command inside a .BAT file and send to client side to create the
database. Instad of giving the -Q parameter you
can also input a .SQL file which contans sequence of TSQL commands.
Thanks
Hari
SQL Server MVP
"Harley" <harleyobrienAThotmailDOTcom> wrote in message
news:E3273FC0-ADE4-47B1-9F3D-8DEC479E3341@.microsoft.com...
> I'm deploying MSDE with a desktop app (windows forms .net).
> after installing MSDE, how do I create the database for the application?
> I cannot provide a createdb.sql script to the user because there is no
> queryanalyzer or similar tools.
> How can I run the create query from the setup? or what is the recommended
> method for doing this?
> Thank You!
after installing MSDE, how do I create the database for the application?
I cannot provide a createdb.sql script to the user because there is no
queryanalyzer or similar tools.
How can I run the create query from the setup? or what is the recommended
method for doing this?
Thank You!
Hi,
Give a batch file to create the database. All you have to do is double click
the batch file. batch file should contain:-
OSQL -Usa -Ppassword -S servername -Q'Create database
dbname' -o'c:\createdb.log'
Save the command inside a .BAT file and send to client side to create the
database. Instad of giving the -Q parameter you
can also input a .SQL file which contans sequence of TSQL commands.
Thanks
Hari
SQL Server MVP
"Harley" <harleyobrienAThotmailDOTcom> wrote in message
news:E3273FC0-ADE4-47B1-9F3D-8DEC479E3341@.microsoft.com...
> I'm deploying MSDE with a desktop app (windows forms .net).
> after installing MSDE, how do I create the database for the application?
> I cannot provide a createdb.sql script to the user because there is no
> queryanalyzer or similar tools.
> How can I run the create query from the setup? or what is the recommended
> method for doing this?
> Thank You!
MSDE setup / installation
Hi
I am a beginner in this, may I asked some basic question
1. do I need any version of MSDE before installing MSDE2000 sp3?
2. I have an environment with two servers, each of these has a web server
with a DC running, and I have written a .NET application for administrator
to maintain user a/c in this domain. Now, I would like to use a MSDE server
for keeping logs.
Can I have an installation of MSDE on each of these servers such that the
two installation would synchronize on a periodic basis?
Please note that changes of records are expected on either of these servers!
TIA
hi,
dl wrote:
> Hi
> I am a beginner in this, may I asked some basic question
> 1. do I need any version of MSDE before installing MSDE2000 sp3?
no, you can just directly install MSDE Rel A (sp3a level) and upgrade to sp4
via http://www.microsoft.com/sql/downloads/2000/sp4.mspx MSDE package (or
directly install MSDE at the sp4 level... but currently it's not clear to me
if general users not owning a "required" SQL Server license as per
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp are eligile for
direct sp4 use... just a note, Microsoft representatives already exposed a
refresh of MSDE Rel A updated at sp4 level will be made available...)
> 2. I have an environment with two servers, each of these has a web
> server with a DC running, and I have written a .NET application for
> administrator to maintain user a/c in this domain. Now, I would like
> to use a MSDE server for keeping logs.
> Can I have an installation of MSDE on each of these servers such that
> the two installation would synchronize on a periodic basis?
> Please note that changes of records are expected on either of these
> servers!
>
yes, you can install MSDE on both servers, and even provide a replication
paht between the 2 MSDE instances, as MSDE supports merge and snapshot
replication
(http://msdn.microsoft.com/library/de...lover_694n.asp)
but, unfortunately, without Enterprise Manager tool it will be not trivial
to set it up
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
|||In message <ei6anK5cFHA.3488@.tk2msftngp13.phx.gbl>, dl@.?.?.invalid
writes
>Hi
>I am a beginner in this, may I asked some basic question
>1. do I need any version of MSDE before installing MSDE2000 sp3?
If your download file for sp3 is about 60-70mb then know it will install
MSDE at the same time if not present. You would be better using the
MSDERelA package (which includes sp3).
>2. I have an environment with two servers, each of these has a web server
>with a DC running, and I have written a .NET application for administrator
>to maintain user a/c in this domain. Now, I would like to use a MSDE server
>for keeping logs.
>Can I have an installation of MSDE on each of these servers such that the
>two installation would synchronize on a periodic basis?
>Please note that changes of records are expected on either of these servers!
Yes. You can have as many instances per server as you like (well up to
16 anyway - I think thats the right number). Yes you can use DTS to
keep the servers synchronised (you would normally pick one as the master
however). Just make sure your database and table design are decent (ie:
Primary Keys etc).
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
I am a beginner in this, may I asked some basic question
1. do I need any version of MSDE before installing MSDE2000 sp3?
2. I have an environment with two servers, each of these has a web server
with a DC running, and I have written a .NET application for administrator
to maintain user a/c in this domain. Now, I would like to use a MSDE server
for keeping logs.
Can I have an installation of MSDE on each of these servers such that the
two installation would synchronize on a periodic basis?
Please note that changes of records are expected on either of these servers!
TIA
hi,
dl wrote:
> Hi
> I am a beginner in this, may I asked some basic question
> 1. do I need any version of MSDE before installing MSDE2000 sp3?
no, you can just directly install MSDE Rel A (sp3a level) and upgrade to sp4
via http://www.microsoft.com/sql/downloads/2000/sp4.mspx MSDE package (or
directly install MSDE at the sp4 level... but currently it's not clear to me
if general users not owning a "required" SQL Server license as per
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp are eligile for
direct sp4 use... just a note, Microsoft representatives already exposed a
refresh of MSDE Rel A updated at sp4 level will be made available...)
> 2. I have an environment with two servers, each of these has a web
> server with a DC running, and I have written a .NET application for
> administrator to maintain user a/c in this domain. Now, I would like
> to use a MSDE server for keeping logs.
> Can I have an installation of MSDE on each of these servers such that
> the two installation would synchronize on a periodic basis?
> Please note that changes of records are expected on either of these
> servers!
>
yes, you can install MSDE on both servers, and even provide a replication
paht between the 2 MSDE instances, as MSDE supports merge and snapshot
replication
(http://msdn.microsoft.com/library/de...lover_694n.asp)
but, unfortunately, without Enterprise Manager tool it will be not trivial
to set it up
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
|||In message <ei6anK5cFHA.3488@.tk2msftngp13.phx.gbl>, dl@.?.?.invalid
writes
>Hi
>I am a beginner in this, may I asked some basic question
>1. do I need any version of MSDE before installing MSDE2000 sp3?
If your download file for sp3 is about 60-70mb then know it will install
MSDE at the same time if not present. You would be better using the
MSDERelA package (which includes sp3).
>2. I have an environment with two servers, each of these has a web server
>with a DC running, and I have written a .NET application for administrator
>to maintain user a/c in this domain. Now, I would like to use a MSDE server
>for keeping logs.
>Can I have an installation of MSDE on each of these servers such that the
>two installation would synchronize on a periodic basis?
>Please note that changes of records are expected on either of these servers!
Yes. You can have as many instances per server as you like (well up to
16 anyway - I think thats the right number). Yes you can use DTS to
keep the servers synchronised (you would normally pick one as the master
however). Just make sure your database and table design are decent (ie:
Primary Keys etc).
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
MSDE Setup -- Wheres the Server?
I am using VB.net to build ASP.net pages. I finally decided it was time to start using SQL server based code. So, I installed MSDE...or so I thought.
I have the server Icon in the bottom systray and it's green and seems to be running.
I have been able to use Microsoft Access' Database Upgrade Wizard to create BB.adp file.
An in VB.net I see a master.dbo connection in Server Explorer.
But I can't figure out how to access the database via the SQL server. When I right click on Server Explorer...the Create a New SQL database menu item is greyed out.
My concern is that my installation is not complete and/or I don't know how to locate and verify the server.
Any help would be appreciated. ThanksMSDN link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msderoadmap.asp to run thru the details.
I have the server Icon in the bottom systray and it's green and seems to be running.
I have been able to use Microsoft Access' Database Upgrade Wizard to create BB.adp file.
An in VB.net I see a master.dbo connection in Server Explorer.
But I can't figure out how to access the database via the SQL server. When I right click on Server Explorer...the Create a New SQL database menu item is greyed out.
My concern is that my installation is not complete and/or I don't know how to locate and verify the server.
Any help would be appreciated. ThanksMSDN link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msderoadmap.asp to run thru the details.
Monday, March 26, 2012
MSDE security (still confused!)
I am distributing my application which includes MSDE 2000. My setup program
attaches .MDF and .LDF files once instance of MSDE 2000 is installed on the
customer’s computer. Now my worry is how can I restrict customers running W2k
or XP from accessing my database using EM or third party GUI’s. If customers
are running W2k or XP and have administrative privileges they can easily
register the installed instance of MSDE with EM and access the data
structure, stored proc etc?
I tested it on a computer which is running W2k, I logged in as
Administrator, ran my Setup program to install MSDE, attach .MDF and .LDF,
..NET framework, MDAC and my application. Then I installed EM and registered
an instance of installed MSDE with it. I could access everything in the
attached db.
How can I prevent this, as data structure, stored proc etc means a lot and
can’t let anyone steal it.
Thanks
Hi Job,
You're not going to like the answer but you can't. If the user has admin
privileges on the system, you can't keep them out. You can make it difficult
for them but you can't actually keep them out. There are many things they
can do to get back in.
You might need to look at encrypting your stored procs (ie create them WITH
ENCRYPTION). That at least might be a start.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Job Lot" <JobLot@.discussions.microsoft.com> wrote in message
news:1AACA558-6859-43A6-BF6B-0550D0F7750C@.microsoft.com...
>I am distributing my application which includes MSDE 2000. My setup program
> attaches .MDF and .LDF files once instance of MSDE 2000 is installed on
> the
> customer's computer. Now my worry is how can I restrict customers running
> W2k
> or XP from accessing my database using EM or third party GUI's. If
> customers
> are running W2k or XP and have administrative privileges they can easily
> register the installed instance of MSDE with EM and access the data
> structure, stored proc etc?
> I tested it on a computer which is running W2k, I logged in as
> Administrator, ran my Setup program to install MSDE, attach .MDF and .LDF,
> .NET framework, MDAC and my application. Then I installed EM and
> registered
> an instance of installed MSDE with it. I could access everything in the
> attached db.
> How can I prevent this, as data structure, stored proc etc means a lot and
> can't let anyone steal it.
> Thanks
>
|||That was the last thing I wanted to hear. What’s the point of having windows
authentication in first place, when its will leave your database system
vulnerable. Why MS has designed it this way, where does all security features
goes? How can you ensure that you are designing robust and secure database
system? Imagine you spending weeks on designing your database system to find
out that there’s no secured way to conceal it. I can’t even use Access as I
can’t run stored proc with it? Is there any other better solution available?
"Greg Low [MVP]" wrote:
> Hi Job,
> You're not going to like the answer but you can't. If the user has admin
> privileges on the system, you can't keep them out. You can make it difficult
> for them but you can't actually keep them out. There are many things they
> can do to get back in.
> You might need to look at encrypting your stored procs (ie create them WITH
> ENCRYPTION). That at least might be a start.
> HTH,
>
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Job Lot" <JobLot@.discussions.microsoft.com> wrote in message
> news:1AACA558-6859-43A6-BF6B-0550D0F7750C@.microsoft.com...
>
>
|||"Job Lot" <JobLot@.discussions.microsoft.com> wrote in message
news:3D7C097D-4567-46DA-9C98-29139C6B5FAF@.microsoft.com...
> That was the last thing I wanted to hear. What's the point of having
windows
> authentication in first place, when its will leave your database system
> vulnerable. Why MS has designed it this way, where does all security
features
> goes? How can you ensure that you are designing robust and secure database
> system? Imagine you spending weeks on designing your database system to
find
> out that there's no secured way to conceal it. I can't even use Access as
I
> can't run stored proc with it? Is there any other better solution
available?
A logical move would be from MSDE to SQL Server running on a server
platform. While similar issues exist with folks that have local
administrative access, you can lock down your instance of SQL Server fairly
tightly. Combine that with stored procedure encryption and possibly, file
level encryption you should be able to go a long way to protect your
intellectual investment.
Steve
attaches .MDF and .LDF files once instance of MSDE 2000 is installed on the
customer’s computer. Now my worry is how can I restrict customers running W2k
or XP from accessing my database using EM or third party GUI’s. If customers
are running W2k or XP and have administrative privileges they can easily
register the installed instance of MSDE with EM and access the data
structure, stored proc etc?
I tested it on a computer which is running W2k, I logged in as
Administrator, ran my Setup program to install MSDE, attach .MDF and .LDF,
..NET framework, MDAC and my application. Then I installed EM and registered
an instance of installed MSDE with it. I could access everything in the
attached db.
How can I prevent this, as data structure, stored proc etc means a lot and
can’t let anyone steal it.
Thanks
Hi Job,
You're not going to like the answer but you can't. If the user has admin
privileges on the system, you can't keep them out. You can make it difficult
for them but you can't actually keep them out. There are many things they
can do to get back in.
You might need to look at encrypting your stored procs (ie create them WITH
ENCRYPTION). That at least might be a start.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Job Lot" <JobLot@.discussions.microsoft.com> wrote in message
news:1AACA558-6859-43A6-BF6B-0550D0F7750C@.microsoft.com...
>I am distributing my application which includes MSDE 2000. My setup program
> attaches .MDF and .LDF files once instance of MSDE 2000 is installed on
> the
> customer's computer. Now my worry is how can I restrict customers running
> W2k
> or XP from accessing my database using EM or third party GUI's. If
> customers
> are running W2k or XP and have administrative privileges they can easily
> register the installed instance of MSDE with EM and access the data
> structure, stored proc etc?
> I tested it on a computer which is running W2k, I logged in as
> Administrator, ran my Setup program to install MSDE, attach .MDF and .LDF,
> .NET framework, MDAC and my application. Then I installed EM and
> registered
> an instance of installed MSDE with it. I could access everything in the
> attached db.
> How can I prevent this, as data structure, stored proc etc means a lot and
> can't let anyone steal it.
> Thanks
>
|||That was the last thing I wanted to hear. What’s the point of having windows
authentication in first place, when its will leave your database system
vulnerable. Why MS has designed it this way, where does all security features
goes? How can you ensure that you are designing robust and secure database
system? Imagine you spending weeks on designing your database system to find
out that there’s no secured way to conceal it. I can’t even use Access as I
can’t run stored proc with it? Is there any other better solution available?
"Greg Low [MVP]" wrote:
> Hi Job,
> You're not going to like the answer but you can't. If the user has admin
> privileges on the system, you can't keep them out. You can make it difficult
> for them but you can't actually keep them out. There are many things they
> can do to get back in.
> You might need to look at encrypting your stored procs (ie create them WITH
> ENCRYPTION). That at least might be a start.
> HTH,
>
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Job Lot" <JobLot@.discussions.microsoft.com> wrote in message
> news:1AACA558-6859-43A6-BF6B-0550D0F7750C@.microsoft.com...
>
>
|||"Job Lot" <JobLot@.discussions.microsoft.com> wrote in message
news:3D7C097D-4567-46DA-9C98-29139C6B5FAF@.microsoft.com...
> That was the last thing I wanted to hear. What's the point of having
windows
> authentication in first place, when its will leave your database system
> vulnerable. Why MS has designed it this way, where does all security
features
> goes? How can you ensure that you are designing robust and secure database
> system? Imagine you spending weeks on designing your database system to
find
> out that there's no secured way to conceal it. I can't even use Access as
I
> can't run stored proc with it? Is there any other better solution
available?
A logical move would be from MSDE to SQL Server running on a server
platform. While similar issues exist with folks that have local
administrative access, you can lock down your instance of SQL Server fairly
tightly. Combine that with stored procedure encryption and possibly, file
level encryption you should be able to go a long way to protect your
intellectual investment.
Steve
MSDE Replication issue
I am trying merge replication between two instances of MSDE on two
different machines on LAN.
I have setup the snapshot agent . when I try running the agent using
sp_start_job @.job_name='MergeSnapshot'
I get an error message saying job name ('MergeSnapshot') does not exist
I am new to replication and trying this for the first time...
Any help is appreciated.
Hello,
Please check out this article:
http://support.microsoft.com/default...b;en-us;324992
regards,
Henk Steunenberg
<prabhusangeeta@.yahoo.com> wrote in message
news:1133288220.042242.206490@.g44g2000cwa.googlegr oups.com...
>I am trying merge replication between two instances of MSDE on two
> different machines on LAN.
> I have setup the snapshot agent . when I try running the agent using
> sp_start_job @.job_name='MergeSnapshot'
> I get an error message saying job name ('MergeSnapshot') does not exist
> I am new to replication and trying this for the first time...
> Any help is appreciated.
>
different machines on LAN.
I have setup the snapshot agent . when I try running the agent using
sp_start_job @.job_name='MergeSnapshot'
I get an error message saying job name ('MergeSnapshot') does not exist
I am new to replication and trying this for the first time...
Any help is appreciated.
Hello,
Please check out this article:
http://support.microsoft.com/default...b;en-us;324992
regards,
Henk Steunenberg
<prabhusangeeta@.yahoo.com> wrote in message
news:1133288220.042242.206490@.g44g2000cwa.googlegr oups.com...
>I am trying merge replication between two instances of MSDE on two
> different machines on LAN.
> I have setup the snapshot agent . when I try running the agent using
> sp_start_job @.job_name='MergeSnapshot'
> I get an error message saying job name ('MergeSnapshot') does not exist
> I am new to replication and trying this for the first time...
> Any help is appreciated.
>
MSDE rel A installation error
I got an error "Setup failed to configure the server". I
have tried to delete the directory "C:\program
files\microsoft sql sever before installation. But I still
get this error. What should i do?
Thank you very much. I spent a week to install this MSDE
but still failed. I am very desperate...
San
hi San,
"San" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1e5f701c4554e$a0454200$a501280a@.phx.gbl...
> I got an error "Setup failed to configure the server". I
> have tried to delete the directory "C:\program
> files\microsoft sql sever before installation. But I still
> get this error. What should i do?
> Thank you very much. I spent a week to install this MSDE
> but still failed. I am very desperate...
in addition to folder delete, try cealning the Windows Registry too, as
reported in
http://support.microsoft.com/default...;EN-US;Q290991
"Remove a Specific Instance of SQL Server" section...
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
|||Thank you. However, I am confused. It is because that KB
is for those who have sql sever installed before. My
computer did not contains any sql sever before (I think).
Could you give me more hints on what I should delete?
Furthermore, I found a strange registry. It
is "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft SQL
Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}".
Should I delete this?
Thank you for your help.
San
>--Original Message--
>hi San,
>"San" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:1e5f701c4554e$a0454200$a501280a@.phx.gbl...
still
>in addition to folder delete, try cealning the Windows
Registry too, as
>reported in
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q290991
>"Remove a Specific Instance of SQL Server" section...
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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 San,
"San" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1e59401c45553$1386bba0$a101280a@.phx.gbl...
> Thank you. However, I am confused. It is because that KB
> is for those who have sql sever installed before. My
> computer did not contains any sql sever before (I think).
> Could you give me more hints on what I should delete?
> Furthermore, I found a strange registry. It
> is "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft SQL
> Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}".
> Should I delete this?
personally I always and only cleared the registry keys reported in the KB
article... as you already read, this does not clear the Windows Installer
registry entries, but I was quiet happy with this method when a MSDE
instance I installed refused to uninstall... I still have this entry in the
Add/Remove programs applet, but I'll remove it ...perhaps =;-D
the hive you notice shoul'd only point to a Temp folder used by the setup
process...
you wrote[vbcol=seagreen]
uncomplete installations can make the system dirty, so you are supposed to
clear it before re-proceeding with new installs...
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
sql
have tried to delete the directory "C:\program
files\microsoft sql sever before installation. But I still
get this error. What should i do?
Thank you very much. I spent a week to install this MSDE
but still failed. I am very desperate...
San
hi San,
"San" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1e5f701c4554e$a0454200$a501280a@.phx.gbl...
> I got an error "Setup failed to configure the server". I
> have tried to delete the directory "C:\program
> files\microsoft sql sever before installation. But I still
> get this error. What should i do?
> Thank you very much. I spent a week to install this MSDE
> but still failed. I am very desperate...
in addition to folder delete, try cealning the Windows Registry too, as
reported in
http://support.microsoft.com/default...;EN-US;Q290991
"Remove a Specific Instance of SQL Server" section...
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
|||Thank you. However, I am confused. It is because that KB
is for those who have sql sever installed before. My
computer did not contains any sql sever before (I think).
Could you give me more hints on what I should delete?
Furthermore, I found a strange registry. It
is "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft SQL
Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}".
Should I delete this?
Thank you for your help.
San
>--Original Message--
>hi San,
>"San" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:1e5f701c4554e$a0454200$a501280a@.phx.gbl...
still
>in addition to folder delete, try cealning the Windows
Registry too, as
>reported in
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q290991
>"Remove a Specific Instance of SQL Server" section...
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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 San,
"San" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1e59401c45553$1386bba0$a101280a@.phx.gbl...
> Thank you. However, I am confused. It is because that KB
> is for those who have sql sever installed before. My
> computer did not contains any sql sever before (I think).
> Could you give me more hints on what I should delete?
> Furthermore, I found a strange registry. It
> is "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft SQL
> Server Setup.{5B5BFFF9-9D55-45AF-9390-AA4DC1C4EEFE}".
> Should I delete this?
personally I always and only cleared the registry keys reported in the KB
article... as you already read, this does not clear the Windows Installer
registry entries, but I was quiet happy with this method when a MSDE
instance I installed refused to uninstall... I still have this entry in the
Add/Remove programs applet, but I'll remove it ...perhaps =;-D
the hive you notice shoul'd only point to a Temp folder used by the setup
process...
you wrote[vbcol=seagreen]
uncomplete installations can make the system dirty, so you are supposed to
clear it before re-proceeding with new installs...
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
sql
Friday, March 23, 2012
MSDE Problem - SQL Server not found or access denied
I am running the MSDE 2000 Setup off the SQL Server 2000 Developer Edition CD.
After installation is complete, there is a service under the Control Panel -> Services window
called MSSQL$GregInstance. I then start that service.
But now when I try to connect to the database using
osql -E -S GregInstance
I get told that the SQL Server does not exist or access denied. Even though the server is running. I have also tried
osql -E -S localhost
but no luck. Why can it not find the instance of SQL Server?
Note : SQL Server 2000 is not installed on the machine, only this MSDE instance.
Thanks
GregNot to worry, I forgot to add in the name of the pc with a \ before the instance name...
i.e
osql -E -S GREG\GregInstance
Subscribe to:
Posts (Atom)