Unable to install MSDE | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Unable to install MSDE

I want to install MSDE on WIN XP machine.Each time I run the set up I get an alerrt msg "A stron SA is required for security reason.Please use SAPWD switch to supply the same.Refer to read me for more details."But I am not able to find SAPWD switch .what is it.How can I install MSDE.Pls help
Check readme.
setup.exe sapwd=mycoolpassword
WBR, Vlad A. Scherbinin
By the way; the SA password is the ‘System Administrator’ password, which is very important for SQL server security. MSDE will set your security to use ‘Windows authentication’, but should someone set change this option to ‘mixed mode authentication’ it would be possible to log onto your database with the SA account, and as the default password was previously "" (nothing), that is why you need to set it.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
As always, it pays to read the html file which accompanies the MSDE installer <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ />
[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]Hi, <br />to set the mixed mode (with sql server security / login mode)<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />By the way; the SA password is the ‘System Administrator’ password, which is very important for SQL server security. MSDE will set your security to use ‘Windows authentication’, but should someone set change this option to ‘mixed mode authentication’ it would be possible to log onto your database with the SA account, and as the default password was previously "" (nothing), that is why you need to set it.<br /><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><br />Open registry editor : and opn HKEY_LOCAL_MACHINE-&gt;microsoft -&gt; microsoft sql server -&gt; 80 -&gt; mssql server -&gt; login mode -&gt; add new string as 1 and value as 1<br /><br />it will make you able to log in using sql authentication mode .<br /><br />HTH<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />
Setup never asked for the password.Every time I run the setup.exe.It fails.I am wondering where to supply the password.No text box exist for the password
You run it from the command line like the html file says
I installed it from command line.Set up executed successfully It showd that it installed.But I cant see any GUI interface.How to use MSDE.How to see it?
http://www.microsoft.com/sql/msde/partners/default.asp Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by aaronsandy</i><br /><br />I installed it from command line.Set up executed successfully It showd that it installed.But I cant see any GUI interface.How to use MSDE.How to see it?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><br />After Installing MSDE successfully, install MS SQL Client Tools , after that you can use Query Analyzer,MS SQL EM and other tools . and if you do not wants to use it osql is a very good command line tool available with MSDE.<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />HTH<br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />
Now when I am trying to connect to MSDE using windows authentication I am able to connect.But when i use sql authentication by supplying localhost in place of sql server I am getting this error
server :msg 17,level 16 state 1
[Microsoft][ODBC Sql server][DBNETLIB]SQL server doesnot exist or access denied
hi aaronsandy,<br />please read the bold quote , i have already mentioned how to enable SQL Authentication mode for MSDE.<br /><br /><b>Open registry editor : and opn HKEY_LOCAL_MACHINE-&gt;microsoft -&gt; microsoft sql server -&gt; 80 -&gt; mssql server -&gt; login mode -&gt; add new string as 1 and value as 1<br /><br />it will make you able to log in using sql authentication mode .<br /><br />HTH</b><br /><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ghemant</i><br /><br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]Hi, <br />to set the mixed mode (with sql server security / login mode)<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />By the way; the SA password is the ‘System Administrator’ password, which is very important for SQL server security. MSDE will set your security to use ‘Windows authentication’, but should someone set change this option to ‘mixed mode authentication’ it would be possible to log onto your database with the SA account, and as the default password was previously "" (nothing), that is why you need to set it.<br /><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><br /><b>Open registry editor : and opn HKEY_LOCAL_MACHINE-&gt;microsoft -&gt; microsoft sql server -&gt; 80 -&gt; mssql server -&gt; login mode -&gt; add new string as 1 and value as 1<br /><br />it will make you able to log in using sql authentication mode .<br /><br />HTH</b><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][:I]<br />Regards<br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />
]]>