Power Music users discussion network
SQL Server 2005 Express issues
Microsoft SQL Server 2005 Express edition is the data platform which Power Music uses. Normally you will not experience any problems, but occasionally other software may cause compatibility issues.
If you get the following error when trying to load Power Music:
'An error has occured whilst establishing a connection to the server. When connecting to the SQL server 2005 this failure may be caused by by the fact that under the default settings, the SQL server does not allow remote connections (SQL network interface error no 26:error locating server/instance specified)'
then it is possible that another application has configured SQL Server 2005 to start manually instead of automatically.
To solve this problem:
Now launch Power Music and the status bar should read 'Connected'
A similar problem can occur if you run Power Music but the status bar reads 'Object reference not set to an instance of an object.' Repeat the steps 1-6 above.
If this doesn't work or if you have other problems with SQL Server 2005 then add a reply to this discussion or contact Cambron Software.
If you get the following error when trying to load Power Music:
'An error has occured whilst establishing a connection to the server. When connecting to the SQL server 2005 this failure may be caused by by the fact that under the default settings, the SQL server does not allow remote connections (SQL network interface error no 26:error locating server/instance specified)'
then it is possible that another application has configured SQL Server 2005 to start manually instead of automatically.
To solve this problem:
- Exit Power Music
- Go to 'start' > 'All Programs' > 'Microsoft SQL Server 2005' > 'Configuration Tools' > 'SQL Server Configuration Manager'
- Select SQL Server 2005 Services
- The services SQL Server (SQLEXPRESS) and SQL Server Browser should have the settings - State 'Running' and Start Mode 'Automatic'. If not, then you need to manually start them, beginning with the SQL Server Browser.
- If the start mode is not Automatic, right click and select Properties. On the Properties screen, select the Service tab. Set the Start Mode to Automatic and press OK.
- To start the service, right click and select Start.
Now launch Power Music and the status bar should read 'Connected'
A similar problem can occur if you run Power Music but the status bar reads 'Object reference not set to an instance of an object.' Repeat the steps 1-6 above.
If this doesn't work or if you have other problems with SQL Server 2005 then add a reply to this discussion or contact Cambron Software.
Replies to This Discussion
-
Permalink Reply by Brenda Cameron on -
Another problem which has been reported by a couple of users is that after a successful installation, the next time the computer is restarted the following message occurs when trying to open Power Music:
'SQL Server has stopped working. A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.'
At Cambron we have been unable to replicate this error and have been trying to find a cause and solution. The common factor appears to be Vista and the existence of a pre-installed instance of SQL Server (MSSMLBIZ) - you can see if you have this using the method described above.
So far the only solution we have found is to turn off User Account Control and this appears to work. We are still trying to find out why. UAC is the feature Microsoft added to Vista to increase security - it caused the annoying prompt you get every time you try to run most programs and most people click yes anyway. It is designed to protect your computer by forcing you to authorize execution of programs. If it is switched off you will no longer receive these prompts.
Microsoft recommend not turning UAC off and there are lots of discussion about it if any of you have concerns. To turn it off, go to Control Panel > User Accounts > Tasks and you will see ‘Turn User Account Control on or off’. Uncheck the box and press OK. You will then be prompted to restart your computer. After restarting try running Power Music and see if it works now.
If you have this problem and turning off UAC works, we would really like to hear from you. It is easy to join this site and contribute. We would like to know if you too have the existence of the MSSMLBIZ instance of SQL Server or if there are any other factors that you think may cause the problem.
-
Permalink Reply by Jeremy Gadd on
-
I am having a serious problem trying to reinstall Power Music after formatting my laptop and reinstalling Windows XP (Home Edition with SP3). The install gets about 3/4 of the way through and then gives an error message. I should have taken a screenshot but I have pasted the install log here instead:
The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.3 {version}
Running checks for package 'Cambron Software End User License Agreement', phase BuildList
The following properties have been set for package 'Cambron Software End User License Agreement':
Running checks for command 'EULApackage\en/eula.txt'
Result of checks for command 'EULApackage\en/eula.txt' is 'Install'
'Cambron Software End User License Agreement' RunCheck result: Install Needed
Running checks for package 'Microsoft Data Access Components 2.8', phase BuildList
Reading value 'FullInstallVer' of registry key 'HKLM\Software\Microsoft\DataAccess'
Read string value '2.81.1132.0'
Setting value '2.81.1132.0 {string}' for property 'MDACVersion'
The following properties have been set for package 'Microsoft Data Access Components 2.8':
Property: [MDACVersion] = 2.81.1132.0 {string}
Running checks for command 'MDAC28\mdac_typ.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'MDACVersion' and value '2.80': true
Result of checks for command 'MDAC28\mdac_typ.exe' is 'Bypass'
'Microsoft Data Access Components 2.8' RunCheck result: No Install Needed
Running checks for package '.NET Framework 2.0', phase BuildList
Running external check with command line "C:\DOCUME~1\******\LOCALS~1\Temp\VSDBD.tmp\dotnetfx\dotnetchk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'DotNetInstalled'
Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer'
Read string value '8.0.6001.18702'
Setting value '8.0.6001.18702 {string}' for property 'IEVersion'
The following properties have been set for package '.NET Framework 2.0':
Property: [DotNetInstalled] = 1 {int}
Property: [IEVersion] = 8.0.6001.18702 {string}
Running checks for command 'dotnetfx\instmsia.exe'
Result of running operator 'ValueExists' on property 'VersionNT': true
Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass'
Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true
Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
Running checks for command 'dotnetfx\dotnetfx.exe'
Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true
Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass'
'.NET Framework 2.0' RunCheck result: No Install Needed
Running checks for package 'Windows Installer 3.1', phase BuildList
The following properties have been set for package 'Windows Installer 3.1':
Running checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true
Result of checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'
'Windows Installer 3.1' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2005 Express Edition SP2', phase BuildList
Running external check with command line "C:\DOCUME~1\******\LOCALS~1\Temp\VSDBD.tmp\SQLExpressSP2\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition SP2':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SQLExpressSP2\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true
Result of checks for command 'SQLExpressSP2\sqlexpr32.exe' is 'Bypass'
Running checks for command 'SQLExpressSP2\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SQLExpressSP2\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition SP2' RunCheck result: Install Needed
EULA for components 'Cambron Software End User License Agreement' was accepted.
EULA for components 'SQL Server 2005 Express Edition SP2' was accepted.
Copying files to temporary directory "C:\DOCUME~1\******\LOCALS~1\Temp\VSDBD.tmp\"
Copying from 'D:\EULApackage\en/eula.txt' to 'C:\DOCUME~1\******\LOCALS~1\Temp\VSDBD.tmp\EULApackage\en/eula.txt'
Copying from 'D:\SQLExpressSP2\sqlexpr32.exe' to 'C:\DOCUME~1\******\LOCALS~1\Temp\VSDBD.tmp\SQLExpressSP2\sqlexpr32.exe'
Running checks for package 'Cambron Software End User License Agreement', phase BeforePackage
The following properties have been set for package 'Cambron Software End User License Agreement':
Running checks for command 'EULApackage\en/eula.txt'
Result of checks for command 'EULApackage\en/eula.txt' is 'Install'
'Cambron Software End User License Agreement' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\******\LOCALS~1\Temp\VSDBD.tmp\EULApackage\en/eula.txt
Verifying file hash
Installing using command line '"C:\DOCUME~1\******\LOCALS~1\Temp\VSDBD.tmp\EULApackage\en/eula.txt" '
Running checks for package 'SQL Server 2005 Express Edition SP2', phase BeforePackage
Running external check with command line "C:\DOCUME~1\******\LOCALS~1\Temp\VSDBD.tmp\SQLExpressSP2\SqlExpressChk.exe"
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressInstalled'
The following properties have been set for package 'SQL Server 2005 Express Edition SP2':
Property: [SQLExpressInstalled] = 1 {int}
Running checks for command 'SQLExpressSP2\sqlexpr32.exe'
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of checks for command 'SQLExpressSP2\sqlexpr32.exe' is 'Install'
'SQL Server 2005 Express Edition SP2' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\******\LOCALS~1\Temp\VSDBD.tmp\SQLExpressSP2\sqlexpr32.exe
WinVerifyTrust returned 0
File trusted
Installing using command line '"C:\DOCUME~1\******\LOCALS~1\Temp\VSDBD.tmp\SQLExpressSP2\sqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1 ADDUSERASADMIN=1'
Process exited with code 1067
Status of package 'Cambron Software End User License Agreement' after install is 'InstallUnknown'
Status of package 'SQL Server 2005 Express Edition SP2' after install is 'InstallFailed'
-
Permalink Reply by Power Music Guru on -
Hi Jeremy
Apparently this is a Microsoft issue with XP SP3.
We are about to release a new version of Power Music but we are updating the installer first before release.
There is now a service pack 3 for SQL Server Express and this will be deployed with the new Power Music.
Meanwhile, you can install SQL Server Express with SP3 directly from this Microsoft link:
http://go.microsoft.com/fwlink/?linkid=65212
If this installs correctly (and according to Microsoft it should), then proceed with the Power Music installation again.
Please let us know how you get on as this will obviously affect our installer update.
-
Permalink Reply by Power Music Guru on
-
There are now 2 Power Music installations for XP on the install page - one for XP SP2 and one for XP SP3. If anyone is reading this please use the correct installation rather than using the Microsoft link above.
Go to installation page
About
© 2010 Created by Power Music Guru
Powered by 
.
