Great help. Thanks. I never thought to look in the event logs.

Hi FANOFHADR,

Yes , indeed you can use both the names ( primary and listener) to connect to the databases. But it makes more sense to include your listener name as data source in your connection string to make your apps listen to the current primary group of databases if a disaster has occurred.

If you are using your primary instance name in your connection string it means that everytime a failover occurs you need to update your connection string.

Thanks for the reply Mohamed

Referring to my comment dated January 7, 2012 at 5:59pm

After struggling for so long i found a solution to this.

Before you reinstall SQL server using Mixed Mode Authentication. (I know the pain of doing that. Sometimes, it wont work for this because you backup your database.mdf under the non permissible user and when you attach it after reinstalling SQL it still shows the same 15247 error)

What worked for me is;

Logged in under windows authentication

1) Went to Database\Security -> Right clicked on my role -> Selected all the necessary permissions

2) Went to \Security ->Right clicked on my role -> Selected all the necessary permissions

3) Restart SQL

4) Log in using SQL authentication

5) Repeat steps (1) & (2)

By God’s grace it should work. If not, try reinstalling SQL with a positive mind

Thank you for the very thorough troubleshooting guidelines you have provided in this website. Although my problem still remain unresolved I have picked up a tip or two from here.

Recently to deploy my site I changed my authentication from windows to SQL authentication. Successfully added the user to ‘Security\Logins’. But having problem enabling database role membership as it returns error 15247. I believe error 15151 is also that of permission issues.

If anyone have come across this problem before I really hope to get a few input to work around on this.

Thank you in advance.