• You should always use SQL Server Configuration manager. It makes sure that all the rights are propagated properly.

    Here is a link that might probably help you.

    -Roy