SQL server throws an error during installation off of Web platform installer

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
11/10/2010 7:31:40 AM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

SQL server throws an error during installation off of Web platform installer

Hi guys,

As i'm in the process of updating my own site, for ease of downloading since CodePlex is anything but screen reader accessible, I figured why not download mojo Portal on my own computer where i could test a real live example while trying to learn IIS for myself.  But there's one problem though.  Upon creation of the SQl server 2008 Express R2 database, I was presented with the error that *** cannot be used as a value for the password and that it must follow the regular expression (?^(8)($ or something like that.  it was much longer, but unfortunately I was unable to capture the error.  This error happens regardless of what characters I use to make up the password.  What am I doing wrong?  And then when I tell it to use an existing database I somehow managed to create which has no password by default, it tells me that it can't connect.  I'm on Windows 7 by the way.  Any input is gladly appreciated.  Thanks so much in advance. 

 

Katherine

11/10/2010 7:39:43 AM
Gravatar
Total Posts 18439

Re: SQL server throws an error during installation off of Web platform installer

Hi Katherine,

The error message is not very informative, but you can solve it by knowing what the default password requirements are for SQL Server.

$Secret123 is an example of a password that meets the criteria. The criteria as far as I know is that it must be at least 8 characters long, have at least one special character like $ or # or !, at least one upper case character, at least one lower case character and at least one numeric character.

Hope it helps,

Joe

11/10/2010 7:47:58 AM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

Re: SQL server throws an error during installation off of Web platform installer

Thanks.  That really does help.  But you'd think that Microsoft'd throw out some kind of flag about the requirements, wouldn't you?  You know, i really have a lot of respect for them, probably giving them credit for things that they don't deserve, but it seems like ever since the birth of Windows, they'd been skimpy on their documentation.  Will they ever learn?  LOL!

11/10/2010 3:47:44 PM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

Re: SQL server throws an error during installation off of Web platform installer

Hi again,

I did what you said, and now I'm getting another error that seems to be unresolvable.  I'm not sure what's meant by the administrator user name and password prompt prior to the prompt about the database.  I get the following  message after typing in a random value considering it can't be empty.  It says "Unable to connect to the database because login failed for sa.  Install anyway?"  Sa appears to be the default admin name given in that box.  This isn't looking good for an enthusiast who one day want's to be able to fly, now does it?  Any input you can provide would be wonderful. 

 

Thanks

11/11/2010 8:25:09 AM
Gravatar
Total Posts 18439

Re: SQL server throws an error during installation off of Web platform installer

When you installed SQL Server using the platform installer it would have prompted you to provide a password for the sa user. The sa user is the super admin sql user. Whatever password you provided when installing it is the password you need to use when you then install apps from the gallery that use sql server.

If you've lost or forgotten what you used for the sa password, you can create an additional sql admin user from sql server management studio, under the Security > Logins node, you would create a sql user  (not a windows user), you could name the new user admin for example and give it a password (which you need to keep track of this time). you can right click the user after creating it and choose properties and then under Server Roles, you would check all the boxes to make him have full admin control.

Hope it helps,

Joe

11/11/2010 8:26:11 AM
Gravatar
Total Posts 18439

Re: SQL server throws an error during installation off of Web platform installer

Or actually you could right click the sa user and choose properties and then change the sa password to one you will remember.

Hope it helps,

Joe

11/11/2010 8:03:47 PM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

Re: SQL server throws an error during installation off of Web platform installer

Oh shoot.  I can't believe this now.  I actually installed SQl Server through the installer off of the web site instead of through WPI since WPI doesn't offer the R2 express edition.  I was never asked to create the Super SQL admin.  Or maybe JAWS forgot to read that part to me while I was installing it?  And not to mention, the SQL Server management studio's a little bit flaky with JAWS.  I'll try it at home with MySQL (considering mySQL's a bit more screen reader friendly)just to see if it can successfully do it, or else my dream's very idiodic if my tests fail.  But I'm trying to learn both technologies considering most .net books, including the ones I own teach you how to develop using SQl server.  Thanks for the clarification though.  And just a question.  Since you're an MCSE and MCDBA, I'd think that you have more leverage to talk to Microsoft about certain things than I do right now at least.  I've noticed that it's harder to get a natively accessible application from them anymore, and sorry to get off the topic a bit, but I've even heard that they're dropping support for the mirror drivers that allow screen readers access to what's on the screen which means that JAWS as it is known by the blind community may be no more unless somebody steps up and does something.  Does Microsoft have an accessibility forum or separate site where I can get these things out to them on?  Thanks so much.  I'll certainly let you know if anything else decides to break. 

 

Katherine

11/11/2010 8:20:53 PM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

Re: SQL server throws an error during installation off of Web platform installer

Oops ... never mind.  Fixed it.  I think that whoever told me that the MSSQL management studio wasn't accessible confused the word with intuitive.  It's very accessible, but sometimes you get lost in the hierarchy.  Maybe sighted folks do too sometimes?  I'll check if this works over the weekend when I have more time and I'm not trying to study for a test. 

11/12/2010 6:37:11 AM
Gravatar
Total Posts 18439

Re: SQL server throws an error during installation off of Web platform installer

Hi Katherine,

Glad you got it working and yes you can be sure that even sighted users can get confused in sql server management studio especially if they are new to it and just learning.

I'm not sure if there is a specific forum at Microsoft for questions about accessibility but with just a brief search I found this site which is about accessibility in Microsoft products (though it seems mostly about consumer products not developer tools):

http://www.microsoft.com/enable/

I also found a Microsoft site that is for helping developers to make sure they are developing accessible applications.

http://msdn.microsoft.com/en-us/windows/bb735024.aspx

I noticed in the Videos section on that page an interesting series of 5 videos about how to develop  a screen reader. I'm sure it is a simple one not as advanced as Jaws, but interesting to note that one could build a screen reader from scratch.

Maybe if you dig around on those sites you will find forums as well. You can be sure that my certifications give me no special access to anyone at Microsoft. I do know a few people there but Microsoft is a huge company and just knowing a few people doesn't give me a direct line to the top or a louder voice or anything like that.

Best,

Joe

11/12/2010 7:47:55 AM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

Re: SQL server throws an error during installation off of Web platform installer

Thanks for the clarifying information.  And it's good to know that certified folks don't get any editional access to stuff.  I can't even believe I even went there!  And i'll have to look at that screen reader thingo.  It sounds really cool.  That's why I say thanks God for the C# language! 

You must sign in to post in the forums. This thread is closed to new posts.