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

In SSMS under MSSQLSERVER01 look under Security - Logins.

Right click on Diego and choose properties.

In the "User Mapping" page select the database Pedidos and check to make sure a suitable Database role membership is selected at the bottom. It sounds like you just have public selected, when in actual fact you would want db_datareader at minimum.

 

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?