FILE:
fulltext.sql

ERROR:
User does not have permission to perform this action.

Full-Text catalog 'YafSearch' does not exist in database 'psdbwa' or user does not have permission to perform this action.

STATEMENT:
if (select DATABASEPROPERTY(DB_NAME(), N'IsFullTextEnabled')) = 1

BEGIN

	if not exists (select * from dbo.sysfulltextcatalogs where name = N'YafSearch')

	BEGIN

		EXEC sp_fulltext_catalog N'YafSearch', N'create'

		EXEC sp_fulltext_table N'[dbo].[yaf_Message]', N'create', N'YafSearch', N'PK_yaf_Message'	

		EXEC sp_fulltext_column N'[dbo].[yaf_Message]', N'Message', N'add'

		EXEC sp_fulltext_table N'[dbo].[yaf_Message]', N'activate' 

		EXEC sp_fulltext_table N'[dbo].[yaf_Message]', N'Start_change_tracking'

		EXEC sp_fulltext_table N'[dbo].[yaf_Message]', N'Start_background_updateindex'





		EXEC sp_fulltext_table N'[dbo].[yaf_Topic]', N'create', N'YafSearch', N'PK_yaf_Topic'

		EXEC sp_fulltext_column N'[dbo].[yaf_Topic]', N'Topic', N'add'

		EXEC sp_fulltext_table N'[dbo].[yaf_Topic]', N'activate' 

		EXEC sp_fulltext_table N'[dbo].[yaf_Topic]', N'Start_change_tracking'

		EXEC sp_fulltext_table N'[dbo].[yaf_Topic]', N'Start_background_updateindex'

		

		-- enable in yaf_Registry as a default

		IF EXISTS ( SELECT 1 FROM yaf_Registry where [Name] = N'usefulltextsearch' )

			UPDATE yaf_Registry SET [Value] = '1' WHERE [Name] = N'usefulltextsearch'

		ELSE

			INSERT INTO yaf_Registry ([Name],[Value],[BoardID]) VALUES (N'usefulltextsearch','1',NULL);

	END

END

 Login failed for user 'PHX3\Iusr_4481723'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'PHX3\Iusr_4481723'.

Source Error:

Line 545:		private void FixAccess( bool bGrant )
Line 546:		{
Line 547:            DB.system_initialize_fixaccess(bGrant);		
Line 548:		}
Line 549:		#endregion

<connectionStrings>
	<add name="yafnet" connectionString="data source=secureserver;initial catalog=mydatabaseName;user id=userId;pwd=mypwd/>
</connectionStrings>