September 11, 2009
SQL Snippet #1Humberto Acevedo
Troubleshooting SQL endpoint configurations
Q1: I cannot create an endpoint when I log on as a Windows administrator. Why?
A: When creating an endpoint, the server maps it to an existing object in the syslogins table. The object searched in the syslogins table is either the corresponding login of the user who executed the statement, or the user in the [AUTHORIZATION=<user>] clause of the DDL statement. In Yukon Beta1, users that belong to a Windows groups such as Builtin\administrators, do not have an object implicitly created in the syslogins table, thus one must be entered before creating an endpoint. Execute the following command to create a login that can then be used as the owner of the endpoint:
CREATE LOGIN [DOMAIN\USERNAME] FROM WINDOWS
To verify the entry in the syslogins table execute the following query:
SELECT LOGINNAME FROM SYSLOGINS WHERE NAME = 'DOMAIN\USER'
Once the entry is in the syslogins table, then executing the DDL to create an endpoint should succeed.
|
 |
|
|||||||||||||||||||||||||||
|
|
|
