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



installing to sql on sbs server Expand / Collapse
Author
Message
Posted 1/8/2008 12:54:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 9/30/2008 8:12:09 AM
Posts: 3, Visits: 13
Im trying to install the trial version to the sql 2000 on our SBS2003 server, when I use the ToMYSQL tool I get the following error.

SQL Connection failed, check your connection string, full error was:

Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection

Post #3676
Posted 1/8/2008 7:32:21 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: 11/14/2008 11:59:15 AM
Posts: 1,851, Visits: 4,297
The message you are getting may be because permissions are not set or because you have set up Windows Only Authentication - there is no way for sa to log in.

Have SQL set for both Windows and SQL Server Authentication, and than perform the steps again. Review Microsoft's KB on this message http://support.microsoft.com/kb/889615 too

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3677
Posted 1/9/2008 6:49:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 9/30/2008 8:12:09 AM
Posts: 3, Visits: 13
I've tried what was suggested and still get the same error, only this time it takes longer to come up.
Post #3696
Posted 1/9/2008 7:28:41 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: 11/14/2008 11:59:15 AM
Posts: 1,851, Visits: 4,297
Hi

Please provide specifics on what you did. This way I am not assuming you have done something, when it may have been not done.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3697
Posted 1/10/2008 4:40:23 PM
AyaNova Sales & Support

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

Group: Administrators
Last Login: 11/14/2008 11:59:15 AM
Posts: 1,851, Visits: 4,297
Hi again

Did you get your SQL permissions issue resolved?

If not, do provide specifics so that I can help.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3716
« 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 2:42am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.094. 14 queries. Compression Disabled.