Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 4th, 2003, 09:08 AM
Registered User
 
Join Date: Jun 2003
Location: , Wiltshire, United Kingdom.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default MSDE 1.0 installs on Windows 9x and XP

As part of a system we have developed we use the MSDE component as the database. On several machines, under different operating systems we have the following errors when trying to install.

From Sqlstp.log:

Setup failed to configure the server. Refer to the server error logs and cnfgsvr.out for more information.

From cnfgsvr.out:

An error occurred while attempting to start the service (31)

I have trawled the internet and Microsoft support site. I have completely uninstalled MSDE by removing registry entries (MSSQLServer etc) and deleting the MSSQL7 directory. All the machine had a working versions of MSDE on, but installed some software that stopped the server from running. After uninstalling and re-installing the above errors occur.

Yes I have stopped all virus software etc whilst trying to do the install.

Microsoft has been no use (reinstall the operating system) and this is my last hope. Any ideas greatly received.
Reply With Quote
  #2 (permalink)  
Old June 4th, 2003, 09:30 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

How are you installing MSDE on the client systems?

Does it fail on all client machines or only some?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
Reply With Quote
  #3 (permalink)  
Old June 4th, 2003, 09:37 AM
Registered User
 
Join Date: Jun 2003
Location: , Wiltshire, United Kingdom.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Via InstallShield, it kicks off this batch file:

start /wait x86\setup\setupsql.exe -s -SMS -f1 "sql70ins.iss"

Contents of sql70ins.iss:

[InstallShield Silent]
Version=v5.00.000
File=Response File
[DlgOrder]
Dlg0=SetupMethod-0
Count=10
Dlg1=SdWelcome-0
Dlg2=SdLicense-0
Dlg3=SdRegisterUser-0
Dlg4=SetupTypeSQL-0
Dlg5=DlgCpSortUnicode-0
Dlg6=DlgServerNetwork-0
Dlg7=DlgServices-0
Dlg8=SdStartCopy-0
Dlg9=SdFinish-0
[SetupMethod-0]
Component-type=string
Component-count=1
Component-0=Local
Result=1
[SdWelcome-0]
Result=1
[SdLicense-0]
Result=1
[SdRegisterUser-0]
szName=microsoft
szCompany=1
Result=1
[SetupTypeSQL-0]
szDir=C:\MSSQL7
Result=302
szDataDir=C:\MSSQL7
[DlgCpSortUnicode-0]
SortId=52
LCID=1033
CompStyle=196609
Result=1
[DlgServerNetwork-0]
NetworkLibs=4095
TCPPort=1433
TCPPrxy=Default
NMPPipeName=\\.\pipe\sql\query
Result=1
[DlgServices-0]
Local-Domain=3855
AutoStart=61455
Result=1
[SdStartCopy-0]
Result=1
[SdFinish-0]
Result=1
bOpt1=0
bOpt2=0

Thanks Jeff, hope this gives you some ideas.
Reply With Quote
  #4 (permalink)  
Old June 4th, 2003, 10:02 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:Originally posted by PhilStollery
 Via InstallShield, it kicks off this batch file:
{snip}
Thanks Jeff, hope this gives you some ideas.
Not many, I'm afraid. We haven't used IS for installing MSDE; we instead used MSDE's setup with its setup.ini - that was MSDE2.0 (SQL Server 2000), though.

I find it interesting that no mention is made that I can see in the .iss file of the authentication method SQL server is to use...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
Reply With Quote
  #5 (permalink)  
Old June 4th, 2003, 10:09 AM
Registered User
 
Join Date: Jun 2003
Location: , Wiltshire, United Kingdom.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, well, er, keep that one under your hat. We have many of thousands of users out there successfully using our software, but all the problems that support receive are based on SQL Sever 7 becoming corrupted and not starting. (Sometimes because MDAC 2.7 is installed and sqlsvr.dll is incompatible - sometimes something else).

I have had to tell 5 individuals they can't use our software because they can't install MSDE.

So again, anyone with any success in enabling MSDE or SQL7 to install after seeing -> An error occurred while attempting to start the service (31) please let me know how.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to connect in windows xp gilgalbiblewheel Access 12 June 1st, 2007 12:59 PM
Threads In Windows XP selorm Windows Server 1 December 7th, 2006 11:10 PM
IIS in Windows XP rodmcleay General .NET 7 November 19th, 2004 09:40 AM
Windows XP btls Wrox Book Feedback 1 July 13th, 2004 02:41 PM
Windows 98 OCX control issues vs Windows XP benoyraj VB How-To 0 May 5th, 2004 08:10 AM



All times are GMT -4. The time now is 05:38 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.