This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a script for checking the Network and Connect related permission of SQL Server User.
When you installed the SQL Server, for network access you should enable the TCP/IP pipeline and other connect permission so that others can access the server.
Using below script, you can easily identify those permissions which are important for connecting SQL Server. I took the reference from this official page.
|
1 2 3 4 5 6 7 8 9 |
SELECT EP.name, SP.STATE, CONVERT(nvarchar(38), suser_name(SP.grantor_principal_id)) AS GRANTOR, SP.TYPE AS PERMISSION, CONVERT(nvarchar(46),suser_name(SP.grantee_principal_id)) AS GRANTEE FROM sys.server_permissions SP, sys.endpoints EP WHERE SP.major_id = EP.endpoint_id ORDER BY Permission,grantor, grantee |
