In my regular job, one day one of my client reported that he is not able to view the database objects from his application.
So I have checked for permission on that user, it already has db_read and db_write permissions. So he should able to view the objects.
I checked for login details so that I can test whether he is connecting to instance properly or not. Using those login information I am able to connect to SQL Server management studio and able to query the tables from Managment studio and also using T-SQL.
Now what is the Problem ?
Using that login able to query the objects from SSMS but not from applicaiton, why.
Checked the error logs, no use.
After struggling for some time, as trail changed the default database for that login, and mapped to the database on which he is trying to query.
Ahhh.... It worked......
Client is able to query the tables from application.
:)
So I have checked for permission on that user, it already has db_read and db_write permissions. So he should able to view the objects.
I checked for login details so that I can test whether he is connecting to instance properly or not. Using those login information I am able to connect to SQL Server management studio and able to query the tables from Managment studio and also using T-SQL.
Now what is the Problem ?
Using that login able to query the objects from SSMS but not from applicaiton, why.
Checked the error logs, no use.
After struggling for some time, as trail changed the default database for that login, and mapped to the database on which he is trying to query.
Ahhh.... It worked......
Client is able to query the tables from application.
:)
