|
AndyC
Yak Posting Veteran
53 Posts |
 Posted - 06/06/2011 : 10:55:30
|
I am trying to connect an odbc source to the R statistical package but having log in problems. i do not believe it is an R problem
I have set up the ODBC name eplR with an SQL server driver linking to the (local) server using windows NT authentication with the network login ID default. In the set up the datasource test is succesful
When I try and create the connection in R library(RODBC) channel <- odbcConnect("eplR"), I get a failed connection Login failed for user pssguy-PC/pssguy - my local computer name
When I connect to the (local) SQL server 2005 via management studio with Windows authentication. I get a similar error unless I open management studio with the "run as administrator" option
In management studio, if i look at the properties of the (local) server, the authentication is set to Windows authentication mode. The permission to connect SQL grantor is sa and the Grant box is checked. there is also a connect sql permission for pssguy-PC\pssguy with an unchecked box. I check it but on restarting mssql server it has reverted to unchecked
Help much appreciated
Andrew Clark
www.premiersoccerstats.com
|
|
ODBC login problems. Think it is SQL setup
