Forum Discussion

Miruthan's avatar
Miruthan
Icon for Advocate V rankAdvocate V
8 years ago

Windows - Alternate credentials not working in Import\Direct query

Hi,   I am trying to use Alternate credentials of Window to connect SQL Database, encountering error of couldn't authenticate with credentials.  I am able to connct same instance from SSMS without ...
Need Help
Tips and Tricks
Tutorial Requests
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Miruthan,

 

What about using default windows authentication or database authentication? And please check if your sql server instance allows remote connection.

 

Regards,

Jimmy Tao

Miruthan's avatar
Miruthan
Icon for Advocate V rankAdvocate V
8 years ago

v-yuta-msftI am able to RDP the SQL server instance. Database authentication and Default window authetication dont have access on Database. Only alternate credentials.