June 8, 2005 at 2:07 pm
I have never installed standalone MSDE without application, only applied patches for it before. What's the steps to install MSDE.
June 9, 2005 at 8:43 am
If you downloaded MSDE Release A from Microsoft and used the default folder when you unzipped the files you can run the following command line to perform a basic install of a default instance of MSDE running in SQL Mixed Mode:
C:\MSDERelA\setup.exe SAPWD=passwordofyourchoice SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 INSTANCENAME=MSSQLSERVER
Here is an article with other parameters. I believe books online also lists them out:
http://techrepublic.com.com/5102-6329-5034825.html
HTH
Don
June 9, 2005 at 9:31 am
I have a question with regards to MSDE. We're testing some update software and downloaded the free version of MSDE. I know tools like QA or EM don't come with the free version and until our demo is complete and we decide to buy the software we're testing, we didn't want to license any database engine. My question, how do I execute a SQL script without QA or other client tools? During the demo, we've been instructed to execut a script to clean up some tables and I cannot figure it out. Thanks.
Terry
June 9, 2005 at 9:37 am
I'm assuming from your number of posts that you have SQL Server (full version) installed somewhere in your enterprise. You can connect to a MSDE install the same way you connect to any normal SQL database with EM or QA.
Student of SQL and Golf, Master of Neither
June 9, 2005 at 9:41 am
Yeah, I have roughly 20 production servers running SQL. I've never used or saw MSDE until this morning. Thanks for the advice, I'll give it a shot.
Terry
June 9, 2005 at 6:30 pm
It still comes with all of the command line tools, eg "osql"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply