WDM & sql express install issues

  • This topic is empty.
Viewing 15 posts - 1 through 15 (of 25 total)
  • Author
    Posts
  • #595
    bzsparks
    Member
    • Total Post: 10
    • Regular Joe
    • ★★

    I’m having trouble installing WDM on a new server. I have a fresh install of SQL 2005 Express on a Windows server 2003 R2 with SP2, trying to install WDM 4.5.1.

    Here’s a little background on the server and what I have tried. The server was originally named serverbuild as it was being installed; it was then renamed when it went into production.

    I did a

    sp_dropserver 'serverbuildsqlexpress'

    then a

    sp_addserver productionname

    to get the correct name in sql.

    I then proceeded to install WDM, and it gave an error saying “Unable to attach the Wyse Device Manager database”. I thought it may be related to my sa password, which contained an @ symbol. I thought that may not be acceptable because of complex security and 4.5.1. I changed the password to contain only letters and numbers but the install still failed with the same error.

    I’m not sure where to go from here. Can anyone give some suggestions? Thank you for your responses.

    #10175
    ConfGen
    Keymaster
    • Total Post: 10696
    • Jedi Master
    • ★★★★★★★

    Hi bzsparks,

    open the SQL Manager to edit the WDM database. Look in the INSTALL table and check the entries there. There should be some entries with servernames, etc. If the naming isn’t correct, fix it manually.

    ConfGen

    #10178
    bzsparks
    Member
    • Total Post: 10
    • Regular Joe
    • ★★

    ConfGen, thanks for the quick response.

    The DB never gets created, which is why I thought it was an issue with the sa password. When I open SQL Manager it is just the stock install no DB’s at all.

    I also thought it may have to do with the compatibility level in sql 2005. The default is SQL Server 2005 (90). Is there a way to set a global compatibility level of SQL Server 2000 (80)?

    #10180
    ConfGen
    Keymaster
    • Total Post: 10696
    • Jedi Master
    • ★★★★★★★

    Does “Production” mean that the server is part of your domain? Then there is for sure an issue to complex passwords.
    Do you have a chance to disable the use of complex password in your domain for a few minutes and install WDM in the meantime?

    ConfGen

    #10182
    bzsparks
    Member
    • Total Post: 10
    • Regular Joe
    • ★★

    Yes, it is on the domain. Could you explain how to disable complex passwords? I believe that would be possible for this machine for a short time.

    Thanks again for the quick response.

    #10183
    ConfGen
    Keymaster
    • Total Post: 10696
    • Jedi Master
    • ★★★★★★★

    This has to be done in the GPO for the domain controller

    ConfGen

    #10184
    bzsparks
    Member
    • Total Post: 10
    • Regular Joe
    • ★★

    Would 4.5.1 SR1 be a solution for the complex password issue?

    #10187
    ConfGen
    Keymaster
    • Total Post: 10696
    • Jedi Master
    • ★★★★★★★

    Yes, the SR1 release is fixing this issue.

    #10190
    bzsparks
    Member
    • Total Post: 10
    • Regular Joe
    • ★★

    I downloaded and tried to install 4.5.1 SR1 and received the exact same message as before.

    Complex passwords are still turned on in the domain, however the sa password does not contain any complex characters.

    I guess my next step is to have the network admin disable complex passwords for about 10 mins to get this installed. Once WDM is installed and while complex passwords are turned off what changes will I need to make to the DB so that when complex passwords are turned back on WDM still functions?

    #10191
    ConfGen
    Keymaster
    • Total Post: 10696
    • Jedi Master
    • ★★★★★★★

    SR1 is using a complex password for the local DB user rapport. So no changes are needed.

    #10195
    thinkthin
    Member
    • Total Post: 1649
    • Jacked into The Matrix
    • ★★★★★★

    Hi,

    I was sent these instructions on using SQL express with WDM, I have not tried them however it may be worth a shot. Also I will post the steps to “manually” install the WDM DB on SQL 2005 with complex passwords.

    Cheers,
    -TT

    – An issue was encountered with the default installation of SQL 2005 Express which prevented WSM from properly connecting to its database.

    – The standard SQL 2005 Express installation gives you an option for ‘Instance Name’ and by default uses an instance name of ‘SQLExpress’. If this is not changed to ‘Default Instance’, it prevents WSM from properly working.

    – Steps to install SQL 2005 Express:

    1/ Run standard SQL 2005 Express installation but make 2 changes during installation:
    2/ Uncheck ‘Hide Advanced Configuration Options’
    3/ Select ‘Default Instance’ and NOT ‘Named Instance’ SQLExpress (note, it defaults to ‘Named Instance’)

    #10196
    ConfGen
    Keymaster
    • Total Post: 10696
    • Jedi Master
    • ★★★★★★★

    Good hint, but only saw that on WSM not WDM

    ConfGen

    #10197
    thinkthin
    Member
    • Total Post: 1649
    • Jacked into The Matrix
    • ★★★★★★
    #10208
    ConfGen
    Keymaster
    • Total Post: 10696
    • Jedi Master
    • ★★★★★★★

    Hi bzsparks,

    I think I know the issue now.
    Remove SQL Express and reinstall it afterwards. But install it in Mixed Mode Authentication. I am pretty sure you have just use Windows Authentication now.
    When installing WDM afterwards use the SA account when prompted for the SQL credentials with the password of your SA you’ve entered during the SQL Express install.

    ConfGen

    #10233
    bzsparks
    Member
    • Total Post: 10
    • Regular Joe
    • ★★

    Thanks for all the responses guys, we have decided to wait until 4.5.2 is released.

    ConfGen, mixed mode authentication was installed from the begining, that was a good sugesstion though. I will keep you up to date on the progress of the install once 4.5.2 is released.

    Thank you all for your support and suggestions.

Viewing 15 posts - 1 through 15 (of 25 total)
  • You must be logged in to reply to this topic.