Re: [R] connect MSSQL server problem

2023-03-17 Thread 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 crede

[R] connect MSSQL server problem

2023-03-17 Thread Kai Yang via R-help
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