Forum Discussion
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...
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.
This is what I currently have
That looks fine, dbo_owner is good.
In SSMS what happens if you run the following query?
SELECT * FROM PedidosCan you see results? Do you get different results when logged into SSMS using Windows Authentication or SQL authentication?
With SQL Authentication:
With Windows Authentication:
It's the same thing for me.
