accessing SQL Server 10.00.1600

Hi, team,

Thanks for your help! Please, find here the solution for this issue here...

http://tinyurl.com/9kjfxac

Cheers!
________________________________________
From: r-sig-mac-bounces at r-project.org [r-sig-mac-bounces at r-project.org] On Behalf Of Rodriguez Fernandez, Ricardo Julio
Sent: 24 October 2012 22:33
To: ripley at stats.ox.ac.uk
Cc: r-sig-mac at r-project.org
Subject: Re: [R-SIG-Mac] accessing SQL Server 10.00.1600

Hi!
________________________________________
From: Prof Brian Ripley [ripley at stats.ox.ac.uk]
Sent: 24 October 2012 14:20
To: Rodriguez Fernandez, Ricardo Julio
Cc: r-sig-mac at r-project.org
Subject: Re: [R-SIG-Mac] accessing SQL Server 10.00.1600

On Wed, 24 Oct 2012, Ricardo.Julio.Rodriguez.Fernandez at sergas.es wrote:
Hi!

I'm happy using RMySQL to access a number of MySQL databases and RJDBC to PostgreSQL ones here, but now I do need to integrate data from SQL Server 10.00.1600.

To the best of my knowledge and after googling for a while, RJDBC is my best option to access SQL Server databases from my Mac OS X 10.6.8 installation running R version 2.15.1 (2012-06-22) --
Platform: i386-apple-darwin9.8.0/i386 (32-bit).

java version "1.6.0_37"
Java(TM) SE Runtime Environment (build 1.6.0_37-b06-434-10M3909)
Java HotSpot(TM) 64-Bit Server VM (build 20.12-b01-434, mixed mode)

I'm trying this in R...

drv <- JDBC("com.microsoft.sqlserver.jdbc.SQLServerDriver", "/etc/enu/sqljdbc_2.0/sqljdbc4.jar")
conn <- dbConnect(drv, "jdbc:sqlserver://hostname;integratedSecurity=true", "username", "password")
and getting this exception...

Error in .jcall(drv at jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1],  :
 com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:b62ebeb1-d6b3-47a0-8136-b86b352b4e41

Please, must I be able to access our SQL Server database by
modifying/correcting the connection line syntax or am I using a
wrong driver/method? If I must be able to connect, please, could you
point me to some documentation explaining how to configure this
driver to use integrated authentication? I can access this
server/database without a glitch using Navicat Premiun on the same
Mac OS X box.
This really is a very specialized issue: JDBC access to SQL server.
It is saying 'jdbc:sqlserver://hostname;integratedSecurity=true' is
not supported.  Can you not check a non-R JBDC client and ask on a
JDBC forum?

I do agree. My hope was to find somebody here that is using a similar configuration/environment
to see how she/he has worked around this issue. I'll look for more help where you
propose and keep this thread posted if I get any solution.

Thanks!

Thanks for your help!

Ricardo

--
Ricardo Rodr?guez
Research Management and Promotion Technician
Technical Secretariat
Health Research Institute of Santiago de Compostela (IDIS)
http://www.idisantiago.es

Nota: A informaci?n contida nesta mensaxe e os seus posibles documentos adxuntos ? privada e confidencial e est? dirixida ?nicamente ? seu destinatario/a. Se vostede non ? o/a destinatario/a orixinal desta mensaxe, por favor elim?nea. A distribuci?n ou copia desta mensaxe non est? autorizada.

Nota: La informaci?n contenida en este mensaje y sus posibles documentos adjuntos es privada y confidencial y est? dirigida ?nicamente a su destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, por favor elim?nelo. La distribuci?n o copia de este mensaje no est? autorizada.

See more languages: http://www.sergas.es/aviso_confidencialidad.htm

_______________________________________________
R-SIG-Mac mailing list
R-SIG-Mac at r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-mac

--
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

Nota: A informaci?n contida nesta mensaxe e os seus posibles documentos adxuntos ? privada e confidencial e est? dirixida ?nicamente ? seu destinatario/a. Se vostede non ? o/a destinatario/a orixinal desta mensaxe, por favor elim?nea. A distribuci?n ou copia desta mensaxe non est? autorizada.

Nota: La informaci?n contenida en este mensaje y sus posibles documentos adjuntos es privada y confidencial y est? dirigida ?nicamente a su destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, por favor elim?nelo. La distribuci?n o copia de este mensaje no est? autorizada.

See more languages: http://www.sergas.es/aviso_confidencialidad.htm

accessing SQL Server 10.00.1600

Thread (4 messages)