Showing posts with label msdeinstallation. Show all posts
Showing posts with label msdeinstallation. Show all posts

Friday, March 9, 2012

MSDE Installation problem.

I have recently installed MSDE and SP3a on my Windows XP
Pro machine. XP SP2 was installed prior to the MSDE
installation. The installation of both MSDE & SP3a
completed without error.
When I log in the server icon appears on the taskbar.
When I place the mouse pointer over the icon "Unknown -
\\ - MSSQLServer" appears.
When I right click the icon and attempt to start, I
receive the following.
"Error The handle is invalid."
I click OK.
The following error appears.
"An error 6 - (The handle is invalid.) occurred while
performing the service operation on the MSSQLSeerver
service."
I click stop and then receive the same errors in the same
order after being asked if I am sure I wish to stop.
I applied a strong password when installing.
Thoughts?
I am seeing the same symptoms as you are. I just installed VS.Net 2003 and MSDE on a brand spanking new hard disk with windows xp sp2 on it. Though, I don't know if it is the latest version of MSDE.
If I open the sql manager there is nothing in the server field. When I try using "local" and click on the refresh services button I get an error saying "The network path is not found."
Any ideas how I can get MSDE running?
thanks!|||Likewise, same problem, though I'm working off win2k and reached msde need
through a limited period copy of Visual.net (for learning purposes).
I'm afraid I'm not at the pc at the moment, but I installed the msde desktop
patch and wasn't sure whether should also have installed the two other
patches that were available.
I await with interest!
Ivor
"anonymous@.discussions.microsoft.com" wrote:

> I have recently installed MSDE and SP3a on my Windows XP
> Pro machine. XP SP2 was installed prior to the MSDE
> installation. The installation of both MSDE & SP3a
> completed without error.
> When I log in the server icon appears on the taskbar.
> When I place the mouse pointer over the icon "Unknown -
> \\ - MSSQLServer" appears.
> When I right click the icon and attempt to start, I
> receive the following.
> "Error The handle is invalid."
> I click OK.
> The following error appears.
> "An error 6 - (The handle is invalid.) occurred while
> performing the service operation on the MSSQLSeerver
> service."
> I click stop and then receive the same errors in the same
> order after being asked if I am sure I wish to stop.
> I applied a strong password when installing.
> Thoughts?
>
|||I have the same problem.... Any help would really be appreciated..
_cCp

Quote:

Originally posted by Ivor
Likewise, same problem, though I'm working off win2k and reached msde need
through a limited period copy of Visual.net (for learning purposes).
I'm afraid I'm not at the pc at the moment, but I installed the msde desktop
patch and wasn't sure whether should also have installed the two other
patches that were available.
I await with interest!
Ivor
"anonymous@.discussions.microsoft.com" wrote:

> I have recently installed MSDE and SP3a on my Windows XP
> Pro machine. XP SP2 was installed prior to the MSDE
> installation. The installation of both MSDE & SP3a
> completed without error.
> When I log in the server icon appears on the taskbar.
> When I place the mouse pointer over the icon "Unknown -
> \\ - MSSQLServer" appears.
> When I right click the icon and attempt to start, I
> receive the following.
> "Error The handle is invalid."
> I click OK.
> The following error appears.
> "An error 6 - (The handle is invalid.) occurred while
> performing the service operation on the MSSQLSeerver
> service."
> I click stop and then receive the same errors in the same
> order after being asked if I am sure I wish to stop.
> I applied a strong password when installing.
> Thoughts?
>

|||I found out the problem, it's to do with, if I remember rightly, the IWAM_USR
account in windows, you need to change some of the security policies. I'm
not on the machine at the moment, try a search in Knowledge Base or email me
on marmite REMOVE THIS BIT@.fastmail.fm
"plummernh" wrote:

> I have the same problem.... Any help would really be appreciated..
> _cCp
> Ivor wrote:
>
> --
> plummernh
> Posted via http://www.mcse.ms
> View this thread: http://www.mcse.ms/message1050720.html
>

Saturday, February 25, 2012

MSDE Install For 98/SE/ME

I understand for Win 2k and XP installs that a simple re-boot after MSDE
installation will start the MSDE service, but for 98/SE/ME, what is
required?
Does the user have to go to Start Menu and start the service? I do not want
to
complicate the installation routine by having to determine the OS and then
adding an automatic launch if user is on 98 for example. I just want to
know
what to tell the user to do in order to start MSDE.
Paul
P.S. My Setup.bat file is:
setup.exe /settings setup.ini /L*V "c:\EquLog.txt"
and my setup.ini file is:
[Options]
INSTANCENAME=COMPNAME01
SECURITYMODE=SQL
SAPWD="MYPASSWORD"
DISABLENETWORKPROTOCOLS=0
This method is working fine on XP boxes.
hi Paul,
"Paul McTeigue" <paul_mcteigue@.msn.com> ha scritto nel messaggio
news:eWQpb54bEHA.904@.TK2MSFTNGP09.phx.gbl...
> I understand for Win 2k and XP installs that a simple re-boot after MSDE
> installation will start the MSDE service, but for 98/SE/ME, what is
> required?
> Does the user have to go to Start Menu and start the service? I do not
want
> to
> complicate the installation routine by having to determine the OS and then
> adding an automatic launch if user is on 98 for example. I just want to
> know
> what to tell the user to do in order to start MSDE.
Win9x platforms do not support Windows NT service control APIs so SQL
Server/MSDE can not be run as service.. it is run as a standard application
instead, so there's no way to "start the relative services at boostratp"...
you can however select, on Service Manager, to "Auto Start" at startup, to
start automatically whenever the computer boots, which will actually put an
entry in the "automatic execution" folder.
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
|||So - after installation on 98/SE/ME - there will be a Start Menu entry
titled "Service Manager"
whereby if you click it you will have the option of auto-starting ?
I am just looking for a clear user instruction for people installing on
those platforms.
Thanks,
Paul
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2m8q1pFk9u42U1@.uni-berlin.de...[vbcol=seagreen]
> hi Paul,
> "Paul McTeigue" <paul_mcteigue@.msn.com> ha scritto nel messaggio
> news:eWQpb54bEHA.904@.TK2MSFTNGP09.phx.gbl...
> want
then
> Win9x platforms do not support Windows NT service control APIs so SQL
> Server/MSDE can not be run as service.. it is run as a standard
application
> instead, so there's no way to "start the relative services at
boostratp"...
> you can however select, on Service Manager, to "Auto Start" at startup, to
> start automatically whenever the computer boots, which will actually put
an
> entry in the "automatic execution" folder.
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Paul,
"Paul McTeigue" <paul_mcteigue@.msn.com> ha scritto nel messaggio
news:Or$M3dCcEHA.2468@.TK2MSFTNGP09.phx.gbl...
> So - after installation on 98/SE/ME - there will be a Start Menu entry
> titled "Service Manager"
> whereby if you click it you will have the option of auto-starting ?
yes, but only for the MSDE instance, not for the SQL Server Agent :-(

> I am just looking for a clear user instruction for people installing on
> those platforms.
"... please check the 'Autostart' option ..." =;-D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply