- This topic is empty.
-
AuthorPosts
-
September 10, 2007 at 10:05 pm #595
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.
September 11, 2007 at 1:02 pm #10175Hi 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
September 11, 2007 at 1:53 pm #10178ConfGen, 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)?
September 11, 2007 at 2:18 pm #10180Does “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
September 11, 2007 at 3:00 pm #10182Yes, 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.
September 11, 2007 at 3:18 pm #10183This has to be done in the GPO for the domain controller
ConfGen
September 11, 2007 at 3:39 pm #10184Would 4.5.1 SR1 be a solution for the complex password issue?
September 11, 2007 at 6:42 pm #10187Yes, the SR1 release is fixing this issue.
September 12, 2007 at 2:44 pm #10190I 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?
September 12, 2007 at 3:17 pm #10191SR1 is using a complex password for the local DB user rapport. So no changes are needed.
September 13, 2007 at 2:14 am #10195Hi,
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’)September 13, 2007 at 7:32 am #10196Good hint, but only saw that on WSM not WDM
ConfGen
September 13, 2007 at 10:31 am #10197September 14, 2007 at 8:40 am #10208Hi 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
September 18, 2007 at 3:26 pm #10233Thanks 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.
-
AuthorPosts
- You must be logged in to reply to this topic.