Post reply

Endpoint

  • March 14, 2009 at 3:06 am

    #201564

    Can anyone explain about endpoint ,How its working ? what is the use of Endpoint ? please given any link where i can find the details of endpoint .

    Thaks in Advance .

  • March 14, 2009 at 3:40 am

    #959653

    Hi there,

    Here is a detailed article including examples on working with SQL Server endpoints.

    http://www.simple-talk.com/sql/database-administration/sql-server-endpoints-soup-to-nuts/[/url]

    Cheers,

    John Sansom (@sqlBrit) | www.johnsansom.com

  • March 14, 2009 at 3:42 am

    #959654

    thnks for your reply....

  • March 14, 2009 at 3:55 am

    #959657

    You're welcome.

    John Sansom (@sqlBrit) | www.johnsansom.com

  • March 24, 2010 at 12:21 am

    #1138707

    I am am studying for the MS SQL Server 2008 Implementation and Management Exam. On the practice test supplied by MS Training Kits there is the following question, pertaining to endpoints (see below).

    Despite the side readings offered here and elsewhere I am not able to visualize this scenario. In what scenario would *users* of an application need to have Connect permissions on an endpoint in addition to permissions for the application (middle layer).

    Question: "You are the database administrator at A. Datum Corporation.

    Users are complaining that applications cannot connect to the SQL Server. You have verified all the application settings and you can connect to the server from your desktop using SSMS. But the users' applications keep returning an "Access denied" error message. What could be the problem?

    Answer: Users do not have CONNECT permissions on the endpoint.

    Thank you very much for your time. Helen

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply