Can anyone help with the function for reporting the day before current date? I'm using Crystal 10. Being new to Crystal I can't seem to get the formula to work that I have. I want the report that I have built to display the day before's data. Thanks very much in advance!!DateAdd ('d',-1 ,CurrentDate )|||The database field that I pull the date from is the {Trips.tdate}, therefor it would be this?
{Trips.tdate} dateadd('d',-1 ,CurrentDate )|||Just go to REPORT -> SELECT EXPERT and in that write:
{Trips.tdate} = dateadd('d',-1 ,CurrentDate )|||I am getting an error stating "a string is required". It follows the =|||in trips, tdate is string|||This is what I have
{Trips.tdate} = dateadd('d',-1 ,CurrentDate )
I get a "number amount, currency amount, boolean or sting is expected here" Here being between the = and dateadd
I know now why I became a paramedic!|||You are comparing a string (which happens to look like a date to you) with a date.
In the field explorer, right click, show field type to check - should say string.
Convert your trips.tdate string to a date.
Alternatively, make sure you store dates as dates, not strings :)
So something like:
CDate({trip.tdate}) = dateadd('d',-1 ,CurrentDate )
To avoid having to do this throughout a report (if you use trip.tdate a lot) you can create a formula to return the string as a date and use the formula instead of the database field.
Still better to store it properly in the first place though!|||You are correct in the fact it is a string. I have no way of changing how the software captures the date. I pasted the following
CDate({trip.tdate}) = dateadd('d',-1 ,CurrentDate )
It now tells me that trip.tdate is an unknown field.|||You weren't supposed to blindly copy my typo! It's Trips (with an 'S') not trip.|||I got it, I got it!!!! Thanks everyone!!!!!!|||Thanks JaganEllis!
Showing posts with label current. Show all posts
Showing posts with label current. Show all posts
Wednesday, March 7, 2012
Function default parameter
I am creating a udh function that requires to know the current date.
Since GetDate() can't be used inside a UDF I thought
I would use a date parameter with a default value of GetDate()
i.e.:
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = GetDate()
) Returns
or
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = (Select GetDate())
) Returns
These do not even compile
However
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = GetDate
) Returns
Does but when I call it it
Select * from dbo.ufn_GetWeekAreaAvailability(1,'1',Default)
It tells me that string cannot be converted to a date
Server: Msg 241, Level 16, State 1, Procedure ufn_Test, Line 0
Syntax error converting datetime from character string.
Any Idea...
Thanks
Fred
Hi Fred,
You can't use a function as the default value for a parameter, only
literals. You can use a view that just returns the value of GETDATE() for
example:
CREATE VIEW vw_getdate
AS
SELECT GETDATE() AS getdate
but the view will be accessed each time the function is executed, which
means that you can end up with having different values for each execution.
The safest is not to use a default value and just pass in the value for
GETDATE().
Jacco Schalkwijk
SQL Server MVP
"Fred" <Fred@.discussions.microsoft.com> wrote in message
news:7315A12D-37ED-4F5F-8855-2DFE1F2153E6@.microsoft.com...
>I am creating a udh function that requires to know the current date.
> Since GetDate() can't be used inside a UDF I thought
> I would use a date parameter with a default value of GetDate()
> i.e.:
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = GetDate()
> ) Returns
> or
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = (Select GetDate())
> ) Returns
> These do not even compile
> However
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = GetDate
> ) Returns
> Does but when I call it it
> Select * from dbo.ufn_GetWeekAreaAvailability(1,'1',Default)
> It tells me that string cannot be converted to a date
> Server: Msg 241, Level 16, State 1, Procedure ufn_Test, Line 0
> Syntax error converting datetime from character string.
> Any Idea...
>
> Thanks
>
>
> --
> Fred
Since GetDate() can't be used inside a UDF I thought
I would use a date parameter with a default value of GetDate()
i.e.:
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = GetDate()
) Returns
or
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = (Select GetDate())
) Returns
These do not even compile
However
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = GetDate
) Returns
Does but when I call it it
Select * from dbo.ufn_GetWeekAreaAvailability(1,'1',Default)
It tells me that string cannot be converted to a date
Server: Msg 241, Level 16, State 1, Procedure ufn_Test, Line 0
Syntax error converting datetime from character string.
Any Idea...
Thanks
Fred
Hi Fred,
You can't use a function as the default value for a parameter, only
literals. You can use a view that just returns the value of GETDATE() for
example:
CREATE VIEW vw_getdate
AS
SELECT GETDATE() AS getdate
but the view will be accessed each time the function is executed, which
means that you can end up with having different values for each execution.
The safest is not to use a default value and just pass in the value for
GETDATE().
Jacco Schalkwijk
SQL Server MVP
"Fred" <Fred@.discussions.microsoft.com> wrote in message
news:7315A12D-37ED-4F5F-8855-2DFE1F2153E6@.microsoft.com...
>I am creating a udh function that requires to know the current date.
> Since GetDate() can't be used inside a UDF I thought
> I would use a date parameter with a default value of GetDate()
> i.e.:
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = GetDate()
> ) Returns
> or
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = (Select GetDate())
> ) Returns
> These do not even compile
> However
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = GetDate
> ) Returns
> Does but when I call it it
> Select * from dbo.ufn_GetWeekAreaAvailability(1,'1',Default)
> It tells me that string cannot be converted to a date
> Server: Msg 241, Level 16, State 1, Procedure ufn_Test, Line 0
> Syntax error converting datetime from character string.
> Any Idea...
>
> Thanks
>
>
> --
> Fred
Function default parameter
I am creating a udh function that requires to know the current date.
Since GetDate() can't be used inside a UDF I thought
I would use a date parameter with a default value of GetDate()
i.e.:
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = GetDate()
) Returns
or
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = (Select GetDate())
) Returns
These do not even compile
However
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = GetDate
) Returns
Does but when I call it it
Select * from dbo.ufn_GetWeekAreaAvailability(1,'1',Default)
It tells me that string cannot be converted to a date
Server: Msg 241, Level 16, State 1, Procedure ufn_Test, Line 0
Syntax error converting datetime from character string.
Any Idea...
Thanks
--
FredHi Fred,
You can't use a function as the default value for a parameter, only
literals. You can use a view that just returns the value of GETDATE() for
example:
CREATE VIEW vw_getdate
AS
SELECT GETDATE() AS getdate
but the view will be accessed each time the function is executed, which
means that you can end up with having different values for each execution.
The safest is not to use a default value and just pass in the value for
GETDATE().
--
Jacco Schalkwijk
SQL Server MVP
"Fred" <Fred@.discussions.microsoft.com> wrote in message
news:7315A12D-37ED-4F5F-8855-2DFE1F2153E6@.microsoft.com...
>I am creating a udh function that requires to know the current date.
> Since GetDate() can't be used inside a UDF I thought
> I would use a date parameter with a default value of GetDate()
> i.e.:
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = GetDate()
> ) Returns
> or
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = (Select GetDate())
> ) Returns
> These do not even compile
> However
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = GetDate
> ) Returns
> Does but when I call it it
> Select * from dbo.ufn_GetWeekAreaAvailability(1,'1',Default)
> It tells me that string cannot be converted to a date
> Server: Msg 241, Level 16, State 1, Procedure ufn_Test, Line 0
> Syntax error converting datetime from character string.
> Any Idea...
>
> Thanks
>
>
> --
> Fred
Since GetDate() can't be used inside a UDF I thought
I would use a date parameter with a default value of GetDate()
i.e.:
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = GetDate()
) Returns
or
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = (Select GetDate())
) Returns
These do not even compile
However
Create function dbo.ufn_GetWeekAreaAvailability(
@.WeekId int,
@.AreaId char(1),
@.Now DateTime = GetDate
) Returns
Does but when I call it it
Select * from dbo.ufn_GetWeekAreaAvailability(1,'1',Default)
It tells me that string cannot be converted to a date
Server: Msg 241, Level 16, State 1, Procedure ufn_Test, Line 0
Syntax error converting datetime from character string.
Any Idea...
Thanks
--
FredHi Fred,
You can't use a function as the default value for a parameter, only
literals. You can use a view that just returns the value of GETDATE() for
example:
CREATE VIEW vw_getdate
AS
SELECT GETDATE() AS getdate
but the view will be accessed each time the function is executed, which
means that you can end up with having different values for each execution.
The safest is not to use a default value and just pass in the value for
GETDATE().
--
Jacco Schalkwijk
SQL Server MVP
"Fred" <Fred@.discussions.microsoft.com> wrote in message
news:7315A12D-37ED-4F5F-8855-2DFE1F2153E6@.microsoft.com...
>I am creating a udh function that requires to know the current date.
> Since GetDate() can't be used inside a UDF I thought
> I would use a date parameter with a default value of GetDate()
> i.e.:
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = GetDate()
> ) Returns
> or
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = (Select GetDate())
> ) Returns
> These do not even compile
> However
> Create function dbo.ufn_GetWeekAreaAvailability(
> @.WeekId int,
> @.AreaId char(1),
> @.Now DateTime = GetDate
> ) Returns
> Does but when I call it it
> Select * from dbo.ufn_GetWeekAreaAvailability(1,'1',Default)
> It tells me that string cannot be converted to a date
> Server: Msg 241, Level 16, State 1, Procedure ufn_Test, Line 0
> Syntax error converting datetime from character string.
> Any Idea...
>
> Thanks
>
>
> --
> Fred
Friday, February 24, 2012
Full-Text Search is not enabled for the current database
We are having problems with Full-Text searching...
Recently we installed a SQL application that needs to access full-text
searching.
It gave the following error:
"The crawl seed <MSSQL75://SQLServer/0539c240> in project <SQLServer
SQL0001400006> cannot be accessed. Error: 8007052e - Logon failure: unknown
user name or bad password."
Upgrading from SQL2kSP3a to SQL2kSP4 didn't change our situation.
Changing to system account following instructions in KB277549 also didn't
fix the problem.
We decided to reinstall the MSSearch service following commands in KB827449.
We received the following error:
"Full-Text Search is not enabled for the current database. Use
sp_fulltext_database to enable full-text search for the database."
Then we ran EXEC sp_fulltext_database 'enable'.
This didn't resolve the problem as we received error message:
"Microsoft search service cannot be administered under present user account."
Current Status recap:
* MSSearch service is started
* In EM > Support Services > Full Text Search is running
* In EM > R-click on Full-Text Catalogs > Rebuild All Catalogs produces
error:
"Microsoft search service cannot be administered under present user account."
* In EM > R-click on catalog within Full-Text Catalog > Rebuild Catalog
produces error:
"Full-Text Search is not enabled for the current database. Use
sp_fulltext_database to enable full-text search for the database."
Not sure if this is user account related or bad install of MSSearch.
Before reloading SQL or contacting MS Support, any advice is appreciated.
Thanks!
D Krage,
As you have reviewed KB 277549 (Q277549) PRB: Unable to Build Full-Text
Catalog After You Modify MSSQLServer Logon Account Through [NT4.0) Control
Panel [or Win2K Component Services] at
http://support.microsoft.com/default...;EN-US;277549, did you do
all of the "Steps to Reproduce Behavior", including stopping & re-starting
the MSSearch & MSSQLServer?
The error you're getting (Logon failure: unknown user name or bad password)
is typical of the above. Additionally, have you or anyone else removed or
altered the BUILTIN\Administrators login? If so, can you re-add it or alter
it back to its original values, including the master database and with
sysadmin rights?
You may also want to review KB article 317746 "PRB: SQL Server Full-Text
Search Does Not Populate Catalogs" at
http://support.microsoft.com/default...b;en-us;317746
However, since you've moved ahead with re-installing the MSSearch components
via the procedures in KB 827449, the above most likely no longer applies. At
this time, the following is the primary error: "Microsoft search service
cannot be administered under present user account." and usually, this error
indicates a missing or altered BUILTIN\Administrators login, but you might
also want to checkout the steps at
http://www.doughughes.net/index.cfm/...nk/entryId-126 as others have
had success with this method in correcting this error.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"d krage" <d krage@.discussions.microsoft.com> wrote in message
news:4C845DC5-B0D7-4F45-A0FC-FB3DCF5F8427@.microsoft.com...
> We are having problems with Full-Text searching...
> Recently we installed a SQL application that needs to access full-text
> searching.
> It gave the following error:
> "The crawl seed <MSSQL75://SQLServer/0539c240> in project <SQLServer
> SQL0001400006> cannot be accessed. Error: 8007052e - Logon failure:
> unknown
> user name or bad password."
> Upgrading from SQL2kSP3a to SQL2kSP4 didn't change our situation.
> Changing to system account following instructions in KB277549 also didn't
> fix the problem.
> We decided to reinstall the MSSearch service following commands in
> KB827449.
> We received the following error:
> "Full-Text Search is not enabled for the current database. Use
> sp_fulltext_database to enable full-text search for the database."
> Then we ran EXEC sp_fulltext_database 'enable'.
> This didn't resolve the problem as we received error message:
> "Microsoft search service cannot be administered under present user
> account."
> Current Status recap:
> * MSSearch service is started
> * In EM > Support Services > Full Text Search is running
> * In EM > R-click on Full-Text Catalogs > Rebuild All Catalogs produces
> error:
> "Microsoft search service cannot be administered under present user
> account."
> * In EM > R-click on catalog within Full-Text Catalog > Rebuild Catalog
> produces error:
> "Full-Text Search is not enabled for the current database. Use
> sp_fulltext_database to enable full-text search for the database."
> Not sure if this is user account related or bad install of MSSearch.
> Before reloading SQL or contacting MS Support, any advice is appreciated.
> Thanks!
|||Thanks for your reply John. As it turns out the error indicated a problem
with user rights, however, the problem turns out to be a bad install of
MSSearch.
Here is what corrected the problem...from Google groups.
http://groups.google.com/group/micro...b7c7692a0e2ff1
According to Google search results, there should be a
HKLM\Software\Microsoft\Search\1.0\Applications\SQ L Server key. This did not
exist, but existed on two of our other servers. The article said to go to
regedit under HKLM\Software\Microsoft\MSSQLServer\Tracking and rename the key
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}. I renamed the key by putting an X in
front of the name. This makes the SQL Server think that the Search service is
not installed with SQL Server.
After this, shut down all affected services and ran the SQL 2000 install
from CD and did a Custom to modify the installation. All components were
already checked except the Search, so checked the search. Did not uncheck
other components or this would uninstall the other components.
After doing this and rebooting, catalog creation appeared to work. Added
item to database and number of items in catalog increased. Reapplied Service
pack 4 to update the SQL search files. Rebooted. Our SQL app search function
is now working.
Hope this can help someone else out there.
d Krage
"John Kane" wrote:
> D Krage,
> As you have reviewed KB 277549 (Q277549) PRB: Unable to Build Full-Text
> Catalog After You Modify MSSQLServer Logon Account Through [NT4.0) Control
> Panel [or Win2K Component Services] at
> http://support.microsoft.com/default...;EN-US;277549, did you do
> all of the "Steps to Reproduce Behavior", including stopping & re-starting
> the MSSearch & MSSQLServer?
> The error you're getting (Logon failure: unknown user name or bad password)
> is typical of the above. Additionally, have you or anyone else removed or
> altered the BUILTIN\Administrators login? If so, can you re-add it or alter
> it back to its original values, including the master database and with
> sysadmin rights?
> You may also want to review KB article 317746 "PRB: SQL Server Full-Text
> Search Does Not Populate Catalogs" at
> http://support.microsoft.com/default...b;en-us;317746
> However, since you've moved ahead with re-installing the MSSearch components
> via the procedures in KB 827449, the above most likely no longer applies. At
> this time, the following is the primary error: "Microsoft search service
> cannot be administered under present user account." and usually, this error
> indicates a missing or altered BUILTIN\Administrators login, but you might
> also want to checkout the steps at
> http://www.doughughes.net/index.cfm/...nk/entryId-126 as others have
> had success with this method in correcting this error.
> Hope that helps!
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "d krage" <d krage@.discussions.microsoft.com> wrote in message
> news:4C845DC5-B0D7-4F45-A0FC-FB3DCF5F8427@.microsoft.com...
>
>
|||You're welcome, d Krage,
After reviewing the Google groups link & thread as that was an old one from
back in 2001 as I was the person who helped Chris with "The solution that
John found to my problem was this:" back when I was fulltime at Microsoft...
I'm now a bit older and wiser, but it still is good to be remembered!
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"d krage" <dkrage@.discussions.microsoft.com> wrote in message
news:8F7D817F-B35C-4689-97E4-C79B711842B8@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply John. As it turns out the error indicated a problem
> with user rights, however, the problem turns out to be a bad install of
> MSSearch.
> Here is what corrected the problem...from Google groups.
> http://groups.google.com/group/micro...b7c7692a0e2ff1
> According to Google search results, there should be a
> HKLM\Software\Microsoft\Search\1.0\Applications\SQ L Server key. This did
> not
> exist, but existed on two of our other servers. The article said to go to
> regedit under HKLM\Software\Microsoft\MSSQLServer\Tracking and rename the
> key
> {E07FDDA7-5A21-11d2-9DAD-00C04F79D434}. I renamed the key by putting an X
> in
> front of the name. This makes the SQL Server think that the Search service
> is
> not installed with SQL Server.
> After this, shut down all affected services and ran the SQL 2000 install
> from CD and did a Custom to modify the installation. All components were
> already checked except the Search, so checked the search. Did not uncheck
> other components or this would uninstall the other components.
> After doing this and rebooting, catalog creation appeared to work. Added
> item to database and number of items in catalog increased. Reapplied
> Service
> pack 4 to update the SQL search files. Rebooted. Our SQL app search
> function
> is now working.
> Hope this can help someone else out there.
> d Krage
> "John Kane" wrote:
Recently we installed a SQL application that needs to access full-text
searching.
It gave the following error:
"The crawl seed <MSSQL75://SQLServer/0539c240> in project <SQLServer
SQL0001400006> cannot be accessed. Error: 8007052e - Logon failure: unknown
user name or bad password."
Upgrading from SQL2kSP3a to SQL2kSP4 didn't change our situation.
Changing to system account following instructions in KB277549 also didn't
fix the problem.
We decided to reinstall the MSSearch service following commands in KB827449.
We received the following error:
"Full-Text Search is not enabled for the current database. Use
sp_fulltext_database to enable full-text search for the database."
Then we ran EXEC sp_fulltext_database 'enable'.
This didn't resolve the problem as we received error message:
"Microsoft search service cannot be administered under present user account."
Current Status recap:
* MSSearch service is started
* In EM > Support Services > Full Text Search is running
* In EM > R-click on Full-Text Catalogs > Rebuild All Catalogs produces
error:
"Microsoft search service cannot be administered under present user account."
* In EM > R-click on catalog within Full-Text Catalog > Rebuild Catalog
produces error:
"Full-Text Search is not enabled for the current database. Use
sp_fulltext_database to enable full-text search for the database."
Not sure if this is user account related or bad install of MSSearch.
Before reloading SQL or contacting MS Support, any advice is appreciated.
Thanks!
D Krage,
As you have reviewed KB 277549 (Q277549) PRB: Unable to Build Full-Text
Catalog After You Modify MSSQLServer Logon Account Through [NT4.0) Control
Panel [or Win2K Component Services] at
http://support.microsoft.com/default...;EN-US;277549, did you do
all of the "Steps to Reproduce Behavior", including stopping & re-starting
the MSSearch & MSSQLServer?
The error you're getting (Logon failure: unknown user name or bad password)
is typical of the above. Additionally, have you or anyone else removed or
altered the BUILTIN\Administrators login? If so, can you re-add it or alter
it back to its original values, including the master database and with
sysadmin rights?
You may also want to review KB article 317746 "PRB: SQL Server Full-Text
Search Does Not Populate Catalogs" at
http://support.microsoft.com/default...b;en-us;317746
However, since you've moved ahead with re-installing the MSSearch components
via the procedures in KB 827449, the above most likely no longer applies. At
this time, the following is the primary error: "Microsoft search service
cannot be administered under present user account." and usually, this error
indicates a missing or altered BUILTIN\Administrators login, but you might
also want to checkout the steps at
http://www.doughughes.net/index.cfm/...nk/entryId-126 as others have
had success with this method in correcting this error.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"d krage" <d krage@.discussions.microsoft.com> wrote in message
news:4C845DC5-B0D7-4F45-A0FC-FB3DCF5F8427@.microsoft.com...
> We are having problems with Full-Text searching...
> Recently we installed a SQL application that needs to access full-text
> searching.
> It gave the following error:
> "The crawl seed <MSSQL75://SQLServer/0539c240> in project <SQLServer
> SQL0001400006> cannot be accessed. Error: 8007052e - Logon failure:
> unknown
> user name or bad password."
> Upgrading from SQL2kSP3a to SQL2kSP4 didn't change our situation.
> Changing to system account following instructions in KB277549 also didn't
> fix the problem.
> We decided to reinstall the MSSearch service following commands in
> KB827449.
> We received the following error:
> "Full-Text Search is not enabled for the current database. Use
> sp_fulltext_database to enable full-text search for the database."
> Then we ran EXEC sp_fulltext_database 'enable'.
> This didn't resolve the problem as we received error message:
> "Microsoft search service cannot be administered under present user
> account."
> Current Status recap:
> * MSSearch service is started
> * In EM > Support Services > Full Text Search is running
> * In EM > R-click on Full-Text Catalogs > Rebuild All Catalogs produces
> error:
> "Microsoft search service cannot be administered under present user
> account."
> * In EM > R-click on catalog within Full-Text Catalog > Rebuild Catalog
> produces error:
> "Full-Text Search is not enabled for the current database. Use
> sp_fulltext_database to enable full-text search for the database."
> Not sure if this is user account related or bad install of MSSearch.
> Before reloading SQL or contacting MS Support, any advice is appreciated.
> Thanks!
|||Thanks for your reply John. As it turns out the error indicated a problem
with user rights, however, the problem turns out to be a bad install of
MSSearch.
Here is what corrected the problem...from Google groups.
http://groups.google.com/group/micro...b7c7692a0e2ff1
According to Google search results, there should be a
HKLM\Software\Microsoft\Search\1.0\Applications\SQ L Server key. This did not
exist, but existed on two of our other servers. The article said to go to
regedit under HKLM\Software\Microsoft\MSSQLServer\Tracking and rename the key
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}. I renamed the key by putting an X in
front of the name. This makes the SQL Server think that the Search service is
not installed with SQL Server.
After this, shut down all affected services and ran the SQL 2000 install
from CD and did a Custom to modify the installation. All components were
already checked except the Search, so checked the search. Did not uncheck
other components or this would uninstall the other components.
After doing this and rebooting, catalog creation appeared to work. Added
item to database and number of items in catalog increased. Reapplied Service
pack 4 to update the SQL search files. Rebooted. Our SQL app search function
is now working.
Hope this can help someone else out there.
d Krage
"John Kane" wrote:
> D Krage,
> As you have reviewed KB 277549 (Q277549) PRB: Unable to Build Full-Text
> Catalog After You Modify MSSQLServer Logon Account Through [NT4.0) Control
> Panel [or Win2K Component Services] at
> http://support.microsoft.com/default...;EN-US;277549, did you do
> all of the "Steps to Reproduce Behavior", including stopping & re-starting
> the MSSearch & MSSQLServer?
> The error you're getting (Logon failure: unknown user name or bad password)
> is typical of the above. Additionally, have you or anyone else removed or
> altered the BUILTIN\Administrators login? If so, can you re-add it or alter
> it back to its original values, including the master database and with
> sysadmin rights?
> You may also want to review KB article 317746 "PRB: SQL Server Full-Text
> Search Does Not Populate Catalogs" at
> http://support.microsoft.com/default...b;en-us;317746
> However, since you've moved ahead with re-installing the MSSearch components
> via the procedures in KB 827449, the above most likely no longer applies. At
> this time, the following is the primary error: "Microsoft search service
> cannot be administered under present user account." and usually, this error
> indicates a missing or altered BUILTIN\Administrators login, but you might
> also want to checkout the steps at
> http://www.doughughes.net/index.cfm/...nk/entryId-126 as others have
> had success with this method in correcting this error.
> Hope that helps!
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "d krage" <d krage@.discussions.microsoft.com> wrote in message
> news:4C845DC5-B0D7-4F45-A0FC-FB3DCF5F8427@.microsoft.com...
>
>
|||You're welcome, d Krage,
After reviewing the Google groups link & thread as that was an old one from
back in 2001 as I was the person who helped Chris with "The solution that
John found to my problem was this:" back when I was fulltime at Microsoft...
I'm now a bit older and wiser, but it still is good to be remembered!
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"d krage" <dkrage@.discussions.microsoft.com> wrote in message
news:8F7D817F-B35C-4689-97E4-C79B711842B8@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply John. As it turns out the error indicated a problem
> with user rights, however, the problem turns out to be a bad install of
> MSSearch.
> Here is what corrected the problem...from Google groups.
> http://groups.google.com/group/micro...b7c7692a0e2ff1
> According to Google search results, there should be a
> HKLM\Software\Microsoft\Search\1.0\Applications\SQ L Server key. This did
> not
> exist, but existed on two of our other servers. The article said to go to
> regedit under HKLM\Software\Microsoft\MSSQLServer\Tracking and rename the
> key
> {E07FDDA7-5A21-11d2-9DAD-00C04F79D434}. I renamed the key by putting an X
> in
> front of the name. This makes the SQL Server think that the Search service
> is
> not installed with SQL Server.
> After this, shut down all affected services and ran the SQL 2000 install
> from CD and did a Custom to modify the installation. All components were
> already checked except the Search, so checked the search. Did not uncheck
> other components or this would uninstall the other components.
> After doing this and rebooting, catalog creation appeared to work. Added
> item to database and number of items in catalog increased. Reapplied
> Service
> pack 4 to update the SQL search files. Rebooted. Our SQL app search
> function
> is now working.
> Hope this can help someone else out there.
> d Krage
> "John Kane" wrote:
Subscribe to:
Posts (Atom)