EndPoint Permission problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

EndPoint Permission problem

Author

Topic

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-03-06 : 05:55:27

Hello everyone. Iam trying to grant a windows login with Grant
create Endpoint Permission

under the master database

grant create endpoint to sql_server_login_from windows_login DineenPC\Dineen

the error message is

msg 102, level 15 store 1, line 1
incorrect syntax near 'DineenPC'

can some tell me where im going wrong please

Kind Regards

Rob

MCTS certified

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-08 : 04:11:28

Try ..

GRANT CREATE ENDPOINT TO [Domain\UserName]
GO

If you need to create the login first then ..

CREATE LOGIN [Domain\UserName] FROM WINDOWS
GO

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources