SQL Server configuraiton failed -- sql server msde

Raymond Glassmeyer
3/30/2005 5:59:12 AM

Thanks for the reply. I have seen this page. There are no previous instances
of MSDE/SQL Server. This is a first time installation.

I have installed MSDE many times, this is the first time I am installing
MSDE on a XP Pro SP2 system. It looks like MSDE will not install on XP Pro
SP2. If I cannot figure it out soon I will re-install the OS and just go to
SP1, I know that works.

[quoted text, click to view]

Raymond Glassmeyer
3/30/2005 9:55:03 AM

Thanks for troubleshooting this installation problem.

I ran out of time so I re-installed the XP Pro, and then installed MSDE.
Everything is working as it should. I installed XP SP2 after MSDE was
successfully installed. That worked fine.

I would still like to understand why the SQL Server service was unable to
start, and what â€œAn error occurred while attempting to start the service
(1460)â€ in the cnfgsvr.out means. I have been unable to find any
documentation anywhere regarding this startup problem.

I did find this same question asked on several other message boards, but no
answers.

Andrea Montanari
3/30/2005 11:41:23 AM

hi Raymond,
[quoted text, click to view]

please have a look at
http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql

--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Andrea Montanari
3/30/2005 4:10:15 PM

hi Raymond,
[quoted text, click to view]

I'm giving a try my self..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Andrea Montanari
3/30/2005 6:37:36 PM

ok... done...

always logged as local administrator:

Installed XP pro sp1 on a VMWare virtual machine..
configured network ..
tested lan connections, internet connections, Messenger...
installed Avast Anti Virus..
disabled Antivirus and installed sp2..
tested lan connections, internet connections, Messenger...
WebUpdate..
installed a Default and a Named instance of MSDE using the standard
MSDERelaA package.. the account running all SQL Server and SQL Server Agent
services was not modified and was set to LocalSystem

added a Firewall exception on TCP/IP 1433 port with scope restricted only to
another member of the lan.. remote connection succesfull

added a Firewall exception on TCP/IP 1034 port with scope restricted to my
subnet..
added a Firewall exception on UDP 1434 port with scope restricted to my
subnet..
remote connection succesfull

no problem encountered

Component Checker reports MDAC 2.8 WinXP sp 2 (as expected)

--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Andrea Montanari
3/31/2005 12:35:25 PM

hi Raymond,
[quoted text, click to view]

I know that installing MSDE sp3a on WinXP sp2 sometimes raises MDAC concerns
you usually will not be able to troubleshoot as you currently have not a way
to update/repair MDAC as WinXP sp2 ships with it's own MDAC 2.8 WinXP sp2
version, not currently available as a separate download..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server msde

sql server msde : SQL Server configuraiton failed