Adding Database Issue Solution

	Forums Register Login My Profile Inbox Address Book My Subscription My Forums Member List Search FAQ Ticket List Log Out

Adding Database Issue Solution

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Archiving & Fax] >> GFI MailArchiver >> Adding Database Issue Solution

Page: [1]

Message

<< Older Topic Newer Topic >>

Adding Database Issue Solution - 29.Jun.2009 4:45:20 AM

h.tavakkoli

Posts: 1
Joined: 29.Jun.2009
Status: offline

I have created a database in SQL2005 on another server as Database Server and used 'sa' user for connecting to databse on "Archive Store Wizard" to add a database archive.
When wizard wants to created two database users for 'db_marc_archive' and 'db_marc_browse' roles, it occures an error which says:

Creating logins...
Test Archiving User Failed: QueryFailed

I looked over SQL and saw those users are created but it seems after creation of users, wizard couldn't connect to the database for testing purposes.

After some search and test, I realized that it's come from password format. Because when I changed password to easy charachters (for example 123456) and it worked. Before that I used complex password format contains characters mixed with symbols. It seems problem comes from symbol usage and MailArchiver have some bug with it.
The password was: &/UgNfXQ^4

I used these kind of passwords in other Applications to connect to their databases on this database server and there is no problem.
Does any body knows why this is happenning? or there is a bug in MailArchiver really!

< Message edited by h.tavakkoli -- 29.Jun.2009 4:56:31 AM >

_____________________________

Hossein Tavakkoli