Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not associated with a trusted SQL Server connection
Message
From
27/06/2001 11:43:39
 
 
To
25/06/2001 16:50:27
General information
Forum:
Visual FoxPro
Category:
Installation, Setup and Configuration
Miscellaneous
Thread ID:
00523262
Message ID:
00524212
Views:
16
Well, I called Microsoft and there was a bit of useful stuff buried in a readme.txt that didn't seem to be on the April 2001 MSDN. The command line parameter SECURITYMODE=SQL seems to be a necessity for a brand new SQL 2000 MSDE installation on Win2K or NT. "sa" will be the only available login, and Windows aunthentication won't let "sa" log in. The parameters for specifying sa passwords don't work. After doing that, since I wanted to set up data table structures, I ran sqlserver.exe from the command line, minimized via the windows shell, waited 60 seconds and started feeding it SQL commands. If you want to coexist with SQL Clients loaded for other purposes, but still run your app's data off the local MSDE, you need to specify the instance name in both the installation and load command lines.

WSHShell = CreateObject("WScript.Shell")
ret1=WSHShell.Run(setuppath+'SETUP.EXE ';
+'INSTANCENAME="'+serverinstance+'" SECURITYMODE=SQL /QB',1,1)
ret2=WSHShell.Run('"'+programpath+'\Binn\sqlservr.exe" -s ';
+serverinstance,2,0)
Randy Hersom
President, Habilitation Software Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform