Everyone probably knows this but to GRANT permission in SQL Server 2005 to a Windows Principle enclose the principal name in square brackets. For example:
grant connect on endpoint::sql_endpoint to [domain\name]
In fact anytime you use a Windows Principal name escape the name with [ and ] to save yourself unnecessary annoyance.
Post a Comment