Endpoint Failure - 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 Failure

Author

Topic

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-03-03 : 05:38:23

Hello there. I am trying to create an Endpoint for Mirroring. But when i exeute. I get a message saying. I do not have permission to create an endpoint on the instanse or on its behalf. Do i have to grant it permission to create endpoints.??

Many thanks

Rob

MCTS certified

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-03-03 : 06:12:13

I created endpoints before but now im not aloud. My instance and windows service is DBSV1\Newmanslane. is there a statement to grant create endpoints at all.

Regards

Rob

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-03-03 : 06:47:07

From BoL:

Permissions
Requires CREATE ENDPOINT permission, or membership in the sysadmin fixed server role. For more information, see GRANT Endpoint Permissions (Transact-SQL).

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-03-03 : 06:51:48

Hello Rick

I have looked at the GRANT Endpoint Permissions (Transact-SQL).

Could you give me an example please. Im very confused what i need to use

Rob

MCTS certified

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-03-03 : 07:06:23

Try these:

http://www.developer.com/db/article.php/3390241

http://www.ss64.com/sql/grant_user.html

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-03-03 : 07:15:01

same old stuff. Im am logged on with windows authentication. so no login name. Can i just grant the windows login to create
endpoints. ?

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-03-03 : 08:08:35

Its not a question weather i can connect to it.

I can not create one

Regards

Rob

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-03-03 : 08:46:51

If you actually read the second link you would see that you need to use:

grant create endpoint to <username>

<username> can be a SQL user or a windows domain/user.

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-03-03 : 08:55:10

Ok thank you very much.

to save messing about. could i just

grant ALL to login. Obviously only in testing , not in practice

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-03-03 : 09:06:13

I guess you could, but you would need the correct permissions to do this in the firstplace anyway and if you are not a member of the sysadmins group, you are going to have issues, especially when you ask the DBA to grant you ALL..

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2009-03-03 : 09:10:10

thank you very much Rick

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources