• Thanks Gail.

    And for the above issue, I think I got the solution...

    I had to explicityly grant connect on TCP Endpoint to every login after the Connect permission was revoked from Public on the TCP endpoint..

    GRANT CONNECT ON ENDPOINT::[TSQL Default TCP] to [loginname]

    Thanks Again..!!