If this is your first time using Add2Exchange or you are upgrading or migrating, post here.

1/23/2013 1:29:32 AM
Gravatar
Total Posts 4

Problems creating SQL tables

Hi,

 

I am installing Add2Exchange Standard on an Exchange 2010 server.  The installation has completed correctly.  However when I run the A2E Console I get an error saying "Problems encountered during creation of database/tables.  Please switch to Service Control Panel and start the SQL A2ESQLServer instance with the service account credentials..."

I have checked that the SQL instance and the A2E Service is using the service account and both services are running.  Where do I go to from here?

 

 

1/23/2013 9:25:42 AM
Gravatar
Total Posts 158

Re: Problems creating SQL tables

Stop the Add2Exchang eservice.  You are still trying to install it.  Open the A2E Console and see if that works

Try picking the services account for sqlserver a2esqlserver and putting in the password, and restating the sql service

then open the Add2Exchange Console again.

 

Questions, is this a first time installation?  Did you run the preinstaller first on the exchange box?

Is the Service account part of local administrators of the box you are installing this on (permanently - and added to any AD policy you may have)

It could be UAC was not turned off and a reboot prior to the Add2Exchange installation? 

To check this, if you navigate in the registry to local machine, software, or wow6432node and OpenDoor Software, what is the value of the service account?  If it is not the a2eservice account, and it says system, then that is the issue, change it to the service account name and try to open the A2E Console again.

If it is the service account, check in the file system to see if you already have DB files in the c:\program files (x86)\openDoor software\add2exchange\database from a previous install.  If not,  fill this out please to continue: http://support.diditbetter.com/support-request.aspx

 

1/23/2013 9:27:27 AM
Gravatar
Total Posts 158

Re: Problems creating SQL tables

Could this permissions be it?

http://support.diditbetter.com/kb/a2e_220.aspx

 

1/23/2013 8:00:00 PM
Gravatar
Total Posts 4

Re: Problems creating SQL tables

Hi,

In answer to your questions:

 

I tried running the console with and without the A2E service running without sucess.

The SQL service is runnign with the A2E service account not a special A2E SQL service account which I think is what you are suggesting.  I didn't knwo that I needed a second service account.  Please confirm.

This is the first installation and I ran the preinstaller on the exchange box.

The service account was not a local admin.  I made it a local admin but that did not fix the problem.

I believe UAC is turned off.

I checked the service account in the registry.  It was set to system.  I changed it to the A2E service account.  This did not work either.

The database folder was empty.

I finally was able to proceed further by naviagting to the console executable and selecting "run as administrator".  The databases were then created and the console launched.  Does this suggest that there is a problem with UAC?

It is now replicating properly.  However I need to manually shutdown the A2E service before launching the console and manually restart it when I close the console.  Is this normal?

1/31/2013 1:03:08 AM
Gravatar
Total Posts 4

Re: Problems creating SQL tables

Further to my last email.  I was able to setup one relationship to sync a public folder contacts list to a user's mailbox into a sub folder of the users's Contacts folder.  The folder synced fine.  However when I created a second relationship it doesn't seem to by syncronising.  The destination folder was created from within the A2E Console.  However it is totally empty.  I don't know what to do from here.  I'd really appreciate some help with this.  Many thanks.

1/31/2013 9:30:52 AM
Gravatar
Total Posts 158

Re: Problems creating SQL tables

yes it would appear that uac was on and not rebooted prior to the install

please call in to 800-837-8636 and we will assist with Premier Support, or continue with Free Support by filling out a support ticket here: http://support.diditbetter.com/support-request.aspx.

 

2/1/2013 4:20:27 AM
Gravatar
Total Posts 4

Re: Problems creating SQL tables

Hi

 

I uninstalled.  Rebooted the server. Then re-run the pre-installer, followed by the setup program and it has worked.  I can now confirm that new relationships are establishing fine and are syncronising.  Many thanks for your help.

2/1/2013 9:06:17 AM
Gravatar
Total Posts 158

Re: Problems creating SQL tables

pleasure serving you

have a great weekend.

 

So for someone new to our products

Consider the Enterprise for larger installs or more effortless relationship creation, management and removal.

With Standard you make one to one relationships for Calendar Contacts and Tasks.  Enterprise you can do the same folder types and make individual

relationships, but you can also do Posts, Notes, Gal Sync and you have the Relationship Group Manager.

It will make a template relationship (to the service account) and then you attach an email enabled dist list with the people you want to sync to

or from  - something like z_GalSync,  and it will make and remove the relationships for you by the inclusion or exclusion in the distribution list.

It is our best technology and is very useful in the one to many, many to one, and full mesh relationships. 

For example, if you wanted to make relationships where everyone got everything no matter where they made it, then it would be a full mesh relationship.

A full mesh relationship is actually three rels, Pub to private, private to pub, and private to private (each with its own relationship settings) and then in RGM, you attach the same dist list to all.

If you had 5 people, you would need to make (5+1) x 5 relationships - or 30 and it would take 30 minutes with singles.  The Enterprise RGM templates you can do in about 4.

It is not much more expensive, an easy upgrade from Standard,

just a thought for someone new to our product line

maybe other Aussies want to be in the know, on the go.

...hey, that was good.

Also, I took it you were an independent IT guy, and we have programs to collaborate