Group: Forum Members
Last Login: 12/27/2007 8:14:15 AM
Posts: 3,
Visits: 16
I am setting up a new SQL server for my company. Currently Ayanova resides on an existing SQL 2000 server. I copied the database from the old server to the new server and using SQL Server manager I attached the existing Ayanova database. I then created the SQL user account that I had used on the old server to access the database and made sure the account settings and permissions were the same on the new server. Finally, I edited the ayanova.exe.config file to have the servername for the new SQL server. The username and password in the file shouldn't need to change since they are the same on the new server.
When I start Ayanova, I get the debug error window and the message says "Login failed for user 'ayanova'. Reason: Not associated with a trusted SQL Server connection."
What is required to move the Ayanova database from one server to another and make it work?
Group: Forum Members
Last Login: 12/27/2007 8:14:15 AM
Posts: 3,
Visits: 16
I figured it out. It was a permissions problem with the SQL server. Since it was a new install I hadn't looked at the full SQL setup and just the database setup. Everything is working fine now.
You cannot post new topics.
You cannot post topic replies.
You cannot post new polls.
You cannot post replies to polls.
You cannot edit your own topics.
You cannot delete your own topics.
You cannot edit other topics.
You cannot delete other topics.
You cannot edit your own posts.
You cannot edit other posts.
You cannot delete your own posts.
You cannot delete other posts.
You cannot post events.
You cannot edit your own events.
You cannot edit other events.
You cannot delete your own events.
You cannot delete other events.
You cannot send private messages.
You cannot send emails.
You may read topics.
You cannot rate topics.
You cannot vote within polls.
You cannot upload attachments.
You cannot download attachments.
You cannot post HTML code.
You cannot edit HTML code.
You cannot post IFCode.
You cannot post JavaScript.
You cannot post EmotIcons.
You cannot post or upload images.
Posted 9/19/2006 7:04:02 AM
