none
Newbie - sa password error after ACT! install - Need pro's help!!!

    Question

  • Hello,
    I am admittedly new to this, especially sql server and am in need of a pro's assistance.. I installed Microsoft Small Business accounting, which in turn installed and configured a sql server. When I installed ACT! 2005 (v7.0) and tried to create a database, it states that it cannot find the master file.... so I tried to install sql server from Microsofts site - downloaded all the packages, unzipped them and ran them... the error I get is that the sql server needs to have an sa password and to use some switch to change it... for the life of me I am lost here. I can't use ACT! at this point and I have not ideas of how to remove, reinstall or repair the sql server.... Any help you can provide would be greatly appreicated!
    Wednesday, August 16, 2006 9:24 PM

Answers

  • The default sa password is blank.  Is it complaining that this is not acceptable and you need to change it ?

    What version of SQL Server do you have ? It sounds like SQL Server Express 2005 ? You may well have two instances installed now, one that came with ACT, and one that you've installed.

    Overall, I'd say ACT are the people to talk to, you're using SQL Server with ACT, right ?

     

    Wednesday, August 16, 2006 11:01 PM
  • ACT will support either one ? I'm not sure that you don't have two instances running now ( SQL Server can have more than one version, or multiple instances of the same version, running on a machine ).  If I were you, I'd uninstall the lot, including SQL Server, and reinstall ACT.  To set the password, you run the installer for SQL Server from the command line and specify SAPWD="whatever", which will set the SA password.  If the version of SQL Server you have installed has a management console, or whatever it was called in SS2000, you can go into it, find the Users section, and change the password there. 

    However, I would be more inclined to do a reinstall from scratch and then try the ACT site:

    http://www.act.com/support/technicalsupport/index.cfm

    I've looked and I can't see anything specific there, but the problem obviously relates to ACT, and if you've paid for it, they would be the ones who know what's going on, and should be supporting you to get their program working.

     

    Wednesday, August 16, 2006 11:22 PM
  • If SS2000 is not in your list, perhaps MSDE is ( that's the free version ).  Otherwise, maybe it uninstalls with ACT.  If you go to Control Panel/Administrative Tools/Services, the list is alphabetical, if there are any listings that start with SQL Server, you still have SQL Server installed :-)

    Your question is right on the edge of what is on topic here, and that means you're unlikely to find people with direct, first hand experience of the problem.  If an uninstall/reinstall doesn't solve it, then I'd suggest looking for a forum populated with people who use ACT.  I'm happy to try and help, but I'm pretty much in the dark, all I can do is comment based on what I know of SQL Server.

     

    Wednesday, August 16, 2006 11:31 PM

All replies

  • The default sa password is blank.  Is it complaining that this is not acceptable and you need to change it ?

    What version of SQL Server do you have ? It sounds like SQL Server Express 2005 ? You may well have two instances installed now, one that came with ACT, and one that you've installed.

    Overall, I'd say ACT are the people to talk to, you're using SQL Server with ACT, right ?

     

    Wednesday, August 16, 2006 11:01 PM
  • Yes, it is saying that the sa password is empty...specifically: "A strong sa password is required for security purposes. Please us SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit." That is what is says when I attempt to run ANY installation version of SQL ... attempting to correct the sql error that I get when I run ACT!. Is there a way to repair or rebuild the sql server?? I have only one instance, from the ACT! install... Thanks for the reply.. !!
    Wednesday, August 16, 2006 11:09 PM
  • By the way.. that was the install error for SQL Server 2000 version A specifically... I installed SQL Server 2005 Express... or tried to... it would run either..
    Wednesday, August 16, 2006 11:11 PM
  • ACT will support either one ? I'm not sure that you don't have two instances running now ( SQL Server can have more than one version, or multiple instances of the same version, running on a machine ).  If I were you, I'd uninstall the lot, including SQL Server, and reinstall ACT.  To set the password, you run the installer for SQL Server from the command line and specify SAPWD="whatever", which will set the SA password.  If the version of SQL Server you have installed has a management console, or whatever it was called in SS2000, you can go into it, find the Users section, and change the password there. 

    However, I would be more inclined to do a reinstall from scratch and then try the ACT site:

    http://www.act.com/support/technicalsupport/index.cfm

    I've looked and I can't see anything specific there, but the problem obviously relates to ACT, and if you've paid for it, they would be the ones who know what's going on, and should be supporting you to get their program working.

     

    Wednesday, August 16, 2006 11:22 PM
  • Sounds great... as for ACT! I called them already.. since I bought this version a while ago,. they stopped supporting it a couple months ago! Nice huh?! As for uninstalling them, I'm all for it.. how do I uninstall SS2000 and all the other instances of SQL Server?? It's not in my remove programs dialog....... Thanks again for the help... look for to hearing back from you        
    Wednesday, August 16, 2006 11:27 PM
  • If SS2000 is not in your list, perhaps MSDE is ( that's the free version ).  Otherwise, maybe it uninstalls with ACT.  If you go to Control Panel/Administrative Tools/Services, the list is alphabetical, if there are any listings that start with SQL Server, you still have SQL Server installed :-)

    Your question is right on the edge of what is on topic here, and that means you're unlikely to find people with direct, first hand experience of the problem.  If an uninstall/reinstall doesn't solve it, then I'd suggest looking for a forum populated with people who use ACT.  I'm happy to try and help, but I'm pretty much in the dark, all I can do is comment based on what I know of SQL Server.

     

    Wednesday, August 16, 2006 11:31 PM