[R] connect MSSQL server problem

[CALUM POLWART]

This doesn't sound like it is R failing, it sounds like you don't know the
appropriate connection details for the server. You need to find them out
and come back rather than simply try different username and passwords...

Can you connect to the server using any other ODBC connection and those
credentials?

On Fri, 17 Mar 2023, 19:09 Kai Yang via R-help, <r-help using r-project.org>
wrote:

> Hi Team,I need to connect two MSSQL servers. One server ask me to enter
> user name and password. I can use dbConnect (from DBI package) to connect
> the serve.Another one do not ask me credential to access the serve. But
> when I remove UID and PWD, it doesn't work. Then I tried to use my PC log
> in credential for UID and PWD, it still doesn't allow me to access. The
> error message: Error: nanodbc/nanodbc.cpp:1021: 28000: [Microsoft][ODBC
> Driver 17 for SQL Server][SQL Server]Login failed for user '******'. How to
> modify the code (see below) to access second MSSQL server?
> con <- dbConnect(odbc(),                 Driver   = "ODBC Driver 17 for
> SQL Server",                 Server   = "abcdefghijklmn",
>  Database = "abc_def")
> Thank you,Kai
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

	[[alternative HTML version deleted]]