Forum Discussion

floressdiego's avatar
floressdiego
Icon for Helper I rankHelper 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
BlueTiger's avatar
BlueTiger
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
5 years ago

With SQL Authentication:

 

 

With Windows Authentication:

 

 

It's the same thing for me.

  • BlueTiger's avatar
    BlueTiger
    Icon for Helper I rankHelper 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?