Thsi really weird to me and I really dunno how to fix it.
1: Login has been granted for Database role "CanUseXP_cmdshell" and it has access in master db.
2: when I test the login it says access is denied.
3: hwen I try to access the path using windows with using this login it works to display me the directory.
4: XP_cmdshell has been set to 1 in sp_configure
5: Few logins which have same privileged have no issues to execute the xp_cmdshell
I also have my test server where the same users exist and connected to the same path and it works fine from test server
what am I missing which caused the login cannot use to execute xp_cmdshell ?
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…