AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



SQL Express already installed onto server... Expand / Collapse
Author
Message
Posted 5/24/2007 9:03:49 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 8:27:06 PM
Posts: 1,702, Visits: 4,008
For the benefit of all AyaNova users, I wanted to post here what another AyaNova user did in the situation where SQL Express was already installed on the server, and the IT Admin did not know what the sa password for SQL Express was.

During the attempt to transfer the database using the ToMSSQL utility, the "sa" account would not authenticate due to an unknown sa password

The user downloaded the SQL Server Management Studio Express from Microsoft and changed authentication methods to Windows Authentication

Then they changed the sa account password 

Then they changed authentication the method back to SQL and Windows and proceeded with the install.

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3134
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 3:14am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 10 queries. Compression Disabled.