RC1/RC2 Sql password errors on install (1 Viewer)

[camshere]

Hi All,

I've tried a couple of times to install Mediaportal, but each time i use the one click setup and it tries to install SQL server it fails citing the password does not meet the policy. This is a new install of RC2 on a clean install of XP Pro with SP3 and all patches installed including the ones suggested on the download page.

From what i've read I'm assumint that the username SA with password MediaPortal which is set in the install script doesn't satisfy SQL Server 2005's min requirements for password complexity - but i'm new to MP and don't know that much about SQL Server so i may be way off base, its just seems strange to be seeing these errors on a clean install.

Am I doing something wrong, have others seen this problem? Or is everyone just using a custom install and using MySQL or something?

Any help would be appreciate - Thanks

Cam

PS - this was also a problem when i installed RC1 using one click on another machine - i ended up just using MySQL on a custom install, but would prefer to use the standard settings for installation so that i can tell my friends to install mediaportal too without having to write a laundry list of things to do

 

[craigparris1]

Hi camshere,

I've seen a couple of these posts recently - my understanding is that the SQL password complexity rules are based on the security policy configured on the PC. If the PC is part of a domain, then the security policy may be derived from domain settings. If it's just a stand-alone PC, then the local policy will apply.

To view the security policy settings (specifically, password complexity), run "gpedit.msc", then go to "Local Computer Policy" -> "Computer Configuration" -> "Windows Settings" -> "Security Settings" -> "Account Policies" -> "Password Policy". I believe the setting "Password must meet complexity requirements" will determine the enforcement of the "sa" password during SQL Express installation.

Hope this helps!

Cheers,
Craig

 

[MdFolter]

Camshere,

Welcome to the forum!

The following is my work around for the security problem. Just choose a password with at least 1 capital, at least 1 symbol and at least a number. It can be very convenient to choose a password that can be remembered.

During istallation you can choose only to download all components and do the install yourself. After downloading you go to C:\Documents and Settings\<user>\Local Settings\Temp\MediaPortal Installation\deploy. Double click mysql-essential-5.0.51b-win32.msi and setup according to the wiki pages. After that double click sqlexpr32_NLD.exe and setup according to the wiki page.
Now double click MediaPortal.DeployTool.exe in C:\Documents and Settings\<user>\Local Settings\Temp\MediaPortal Installation and choose advanced setup. Choose the option I already have a database and I want to use that one!



View attachment 24678

View attachment 24679

Have fun!

Marcel

PS sorry for the dutch language in the attachments. I hope you can work it out!

 

[camshere]

Thanks both of you for your help, I'm sure i could get it running with enough time/effort. I was hoping this was something easy to fix so that when i recommended mediaportal to others i could be sure they'd get it on pretty quick.

One question - if this is a known error, and everyone who downloads RC2 with stock XP will encounter this error, should i submit some form of bug report so that they can fix it in the final release - i'm surprised its still there after RC1, i would have thought someone would have noticed by now - it can't be that hard to get the install scripts to use a password like MediaPortal1 for the SA user and then have it install easily using the one-click install.

 

[chemelli]

Hi all,

standard XP (Home and Pro) come with no password complexity enable so one-click install works as expected.
I will check with the Team if we want to change default password to Something like "MediaPortal1.0" to get arround this user issue.

Also if you install by hand MySQL take care that a lot of optimizations parameters doesn't get filled and you can experience problems.

Simone

 

[chemelli]

Double click mysql-essential-5.0.51b-win32.msi and setup according to the wiki pages. After that double click sqlexpr32_NLD.exe and setup according to the wiki page.

Mixing MSSQL and MySQL

Why ?

Simone