Connector installation error on windows 2008 R2 server

[GoogleCodeExporter]

I installed the connector on Windows 2008 R2 server on a fresh Alfresco 
Enterprise 4.0 installation. I followed the instructions from the 
AdminUserGuide. Instead of command:

sudo java -jar bin/alfresco-mmt.jar install amps/mdbc-1.0-SNAPSHOT.amp 
tomcat/webapps/alfresco.war

I used the following:

java -jar bin/alfresco-mmt.jar install amps/mdbc-1.0-SNAPSHOT.amp 
tomcat/webapps/alfresco.war

as I am installing on windows and not UNIX.

Now I cannot login into http://127.0.0.1:8080/share/

Error: The remote server may be unavailable or your authentication details have 
not been recognized.

Please help.

Original issue reported on code.google.com by nagpal.v...@gmail.com on 10 May 2012 at 2:00

[GoogleCodeExporter]

Hi, can you provide alfresco.log content errors? ..
Greetings!

Original comment by venzia.spain@gmail.com on 11 May 2012 at 7:53

[GoogleCodeExporter]

Thanks for your response. As I am new to Alfresco, could you please tell me 
which log file do you want to see. Under folder "C:\Alfresco\tomcat\logs" there 
are 15 error log files but was unable to find alfresco.log. Please see attached 
image.

Original comment by nagpal.v...@gmail.com on 11 May 2012 at 10:25

Attachments:

• AlfrescoErrorLogFiles.png

[GoogleCodeExporter]

Hi Vikas,
catalina-2012-05-11 seems to be most recent. Anyway, in the path C:\Alfresco\ 
should be a file called alfresco.log (cleaner than catalina).

Original comment by venzia.spain@gmail.com on 11 May 2012 at 10:30

[GoogleCodeExporter]

Hello Venzia, I have found the log file in C:\Windows\System32 folder. I have 
attached the log file from yesterday when I installed the connector. I hope 
this is not to do with the JDBC driver for MS-SQL. I have copied the files 
sqljdbc.jar and sqljdbc4.jar in the folder tomcat\lib.

Original comment by nagpal.v...@gmail.com on 11 May 2012 at 11:14

Attachments:

• alfresco.log.2012-05-10

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Ok, you must copy attached mysql-connector.. file in tomcat\lib and restart 
Alfresco (The examples included by default work with MySQL, not MS-SQL, these 
can be changed after the first start, to fit your needs).
Let me know if Alfresco now starts correctly.
Regards!

NOTE : For MSSQL 2005 jdbc "Connectors" we use jtds-1.2.2.jar (attached).

Original comment by venzia.spain@gmail.com on 11 May 2012 at 11:29

Attachments:

• mysql-connector-java-5.1.13-bin.jar
• jtds-1.2.2.jar

[GoogleCodeExporter]

Thanks Venzia! I could now log in. This has solved my problem. Now I will try 
to connect to MS-SQL.

Original comment by nagpal.v...@gmail.com on 11 May 2012 at 1:15

[GoogleCodeExporter]

We are happy to hear this good news ;D

Original comment by venzia.spain@gmail.com on 11 May 2012 at 2:16

• Changed state: Done
• Added labels: OpSys-Windows, Type-Other
• Removed labels: Type-Defect

[GoogleCodeExporter]

Please im totally lost .
I HAVE DONE ALL THE INSTALLATION STEPS ON MY SERVER WICH IS A A WINDOWS VISTA , 
RUNNING ALFRESCO 4.D WITH POSTGRE . i have installed the amp file . i have 
started mysql and created the sakila database with the data inserted . yet when 
i go to my admin console i dont see anything . am i getting it wrong please 
help !!!

Original comment by mr.uwa...@googlemail.com on 15 Jun 2012 at 5:57