Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AndyC
Yak Posting Veteran
53 Posts |
 Posted - 2011-06-06 : 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 problemI 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 succesfulWhen 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 nameWhen 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" optionIn 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 uncheckedHelp much appreciatedAndrew Clarkwww.premiersoccerstats.com |
|
|
|
|
|
ODBC login problems. Think it is SQL setup