Forum Discussion

floressdiego's avatar
floressdiego
Helper I
5 years ago

SQL Server - we couldn't authenticate with the credentials provided

Hello,  I have been trying to connect to SQL Server all day today. The error that shows is the following: If I press "OK" I cannot access the Data, the database comes empty. If I press canc...
Need Help
floressdiego's avatar
floressdiego
Helper I
5 years ago

This is what I currently have

 

BlueTiger's avatar
BlueTiger
Helper I
5 years ago

That looks fine, dbo_owner is good.

 

In SSMS what happens if you run the following query?

SELECT * FROM Pedidos

Can you see results? Do you get different results when logged into SSMS using Windows Authentication or SQL authentication?

 

  • floressdiego's avatar
    floressdiego
    Helper I
    5 years ago

    With SQL Authentication:

     

     

    With Windows Authentication:

     

     

    It's the same thing for me.

    • BlueTiger's avatar
      BlueTiger
      Helper I
      5 years ago

      Can you go ahead to the next step and load the data even though it is empty?

      Then go to advanced editor and copy and paste the contents here?