Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Shennanigans on MSDE install.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-26 : 10:59:54
Ken writes "I have created a VB application to invoke the MSDE 2000 setup, then attach and configure a database. On a small number of computers, the install fails. I set the collation to SQL_Latin1_General_CP1_CS_AS. This switch succeeds, and the last lines in the log file read:

Default collation successfully changed.
Recovery complete.
Warning: override, autoexec procedures skipped.
SQL Server is terminating due to 'stop' request from Service Control Manager.


Nobody has Service Control Manager open, or is tinkering with the MSDE control in the system tray.

My VB application can't connect to the database to do its configuration.

When I connect to the new database with Enterprise Manager, I see Northwind and Pubs databases, but they're corrupt (I can't remember what word it uses). If I delete these two databases then everything is OK. I'm not shipping Northwind and pubs.

My question is, why does MSDE not successfully install? And where are Northwind and pubs coming from? I haven't found anything remotely related on the web or the knowledge base."

chadmat
The Chadinator

1974 Posts

Posted - 2002-04-27 : 03:56:59
They are coming from Instpubs.sql and a similarly named script for Northwind (InstNwind.sql or something like that)


These scripts are in the Install directory.

-Chad

Go to Top of Page
   

- Advertisement -