Jira on SQL Server 2008, cannot startup due to option NOCOUNT?

[Stefano Luperto]

I'm installing Jira 4.4.4 and using SQL Server 2008.

I have followed the guide step by step, as written in this page:
http://confluence.atlassian.com/display/JIRA044/Connecting+JIRA+to+SQL+Server+2008

In particular, I've checked if the option NOCOUNT is set or not. I have exactly the same configuration as show in the screenshot in the page. So it should be ok.

But when I startup Jira I get exactly the same log I've found in this page:

http://confluence.atlassian.com/display/JIRA044/Error+caused+by+SET+NOCOUNT+in+MS+SQL+Server

I have also followed the instruction found in this page:

http://confluence.atlassian.com/display/JIRA/MS+SQL+Server+2000+Startup+errors

So I'm sure that my jiradb_user is not the db owner, but he has all the rights needed.
Tables are all created in the jiradb schema (and not dbo schema).

Any suggestion would be very appreciated.

[Stefano Luperto · Accepted solution]

Thanks to Atlassian Support I found the problem: to see if the nocount option is enabled or not, you must go to:

right click on the server -> properties -> connections

then scroll down to the "no count" option. If it's checked, uncheck it.