reinstalling the service pack?

Hello:
On either SQL 2000 or SQL 2005, do you have to reinstall a service pack
whenever you create a new database? Or, does the new database "contain" the
service pack already upon the database's creation?
Thanks!
childofthe1980sYou never need to reinstall.
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:4B00F4AF-662A-405F-900C-345B90966995@.microsoft.com...
> Hello:
> On either SQL 2000 or SQL 2005, do you have to reinstall a service pack
> whenever you create a new database? Or, does the new database "contain"
> the
> service pack already upon the database's creation?
> Thanks!
> childofthe1980s|||For additional info: You will need to install SP of SQL Server for new
instances only, not for databases.
--
Ekrem Ã?nsoy
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:4B00F4AF-662A-405F-900C-345B90966995@.microsoft.com...
> Hello:
> On either SQL 2000 or SQL 2005, do you have to reinstall a service pack
> whenever you create a new database? Or, does the new database "contain"
> the
> service pack already upon the database's creation?
> Thanks!
> childofthe1980s

Reinstall RS Client?

Hi,
I have purchased a new copy of SQL Server for running Reporting Service as
the Evaluation copy has expired.
I have installed Visual Studio with RS client on a workstation as I don't
want to install Report Designer on the Server.
I would like to know is it necessary for me to uninstall the Evaluation Copy
RS Client on my workstation before installing the new RS Client ?
Your advice is sought.I am pretty sure the evaluation expiration is only the server part of RS,
not the design tools. Are you getting a message saying that it has expired
when you try to design? You should still be able to design and preview. If
that is the case (I am trying to remember what I did but I don't think I did
anything with the client tools). Unless you have a problem my suggestion is
to leave the designer alone. After installing the new server you should
download SP2 and install that at both the server and the client.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:%239RZUnfsFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have purchased a new copy of SQL Server for running Reporting Service as
> the Evaluation copy has expired.
> I have installed Visual Studio with RS client on a workstation as I don't
> want to install Report Designer on the Server.
> I would like to know is it necessary for me to uninstall the Evaluation
> Copy RS Client on my workstation before installing the new RS Client ?
> Your advice is sought.
>

Re-install problems

TITLE: Microsoft SQL Server Setup

Setup failed because Service MSSQL$SQLExpress is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property profile enabled. For more information on how to enable the hardware profile logon property refer to the product documentation.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28112

BUTTONS:

OK

Hmm....I'm not sure what to do. I looked at the service and it's set to automatic.

Did you take a look at:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=838712&SiteID=1

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Thank you Jens

Re-install problems

TITLE: Microsoft SQL Server Setup

Setup failed because Service MSSQL$SQLExpress is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property profile enabled. For more information on how to enable the hardware profile logon property refer to the product documentation.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28112

BUTTONS:

OK

Hmm....I'm not sure what to do. I looked at the service and it's set to automatic.

Did you take a look at:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=838712&SiteID=1

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Thank you Jens

Reinstall Full-Text Service SQL Server 2000

Hi all,
How can I re-install the full text service?
I can't create new catalog!
I can't delete existing catalogs!
I can't do anything involving the full text service, in Enterprise Manager
or via Query Analyzer.
Thanks in Advance,
Fabio
Fabio,
While removing and reinstalling the Full Text Search (FTS) components (see
below KB article 827449) may resolve this for you, it would also be helpful
to get any error number or error messages that you get when you attempt to
create or drop a FT Catalog via system stored procedures.
For example, what error do you get when you try to create the following FT
Catalog in the Pubs database?
use pubs
go
EXEC sp_fulltext_catalog 'PubInfo', 'create'
EXEC sp_fulltext_table 'pub_info', 'create', 'PubInfo', 'UPKCL_pubinfo'
EXEC sp_fulltext_column 'pub_info', 'pub_id', 'add'
EXEC sp_fulltext_column 'pub_info', 'pr_info', 'add'
EXEC sp_fulltext_table 'pub_info', 'activate'
go
For example, what error do you get when you try to drop the following FT
Catalog in the Pubs database?
use pubs
go
exec sp_fulltext_table 'pub_info','drop'
exec sp_fulltext_catalog 'PubInfo','drop'
go
If the above works successfully, for you on your problem server, then the
problem does not exist with FTS components and removal and reinstallation
may not be necessary. Could you also try the above procedures with your
FT-enable table and FT Catalog and post any errors that are returned. If the
errors that you receive for this "Catch-22" situation, then I can email you
a SQL script file to resolve this issue for you.
827449 How to manually reinstall the Microsoft Search service for an
instance of SQL 2000
http://support.microsoft.com/default...b;EN-US;827449
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Fabio" <fabio@.glb.com.br> wrote in message
news:#iqWcOfCFHA.328@.tk2msftngp13.phx.gbl...
> Hi all,
> How can I re-install the full text service?
> I can't create new catalog!
> I can't delete existing catalogs!
> I can't do anything involving the full text service, in Enterprise Manager
> or via Query Analyzer.
> Thanks in Advance,
> Fabio
>
|||Hi John,
I did all the steps from the article, but now I have the current problem:
when I go to delete an existing catalog or create a new one, the follow
message appears:
"the microsoft search service cannot be administered under the present user
account"
Do you know how can I solve this?
Thanks again
"John Kane" <jt-kane@.comcast.net> wrote in message
news:eJFJwOgCFHA.328@.tk2msftngp13.phx.gbl...
> Fabio,
> While removing and reinstalling the Full Text Search (FTS) components (see
> below KB article 827449) may resolve this for you, it would also be
helpful
> to get any error number or error messages that you get when you attempt to
> create or drop a FT Catalog via system stored procedures.
> For example, what error do you get when you try to create the following FT
> Catalog in the Pubs database?
> use pubs
> go
> EXEC sp_fulltext_catalog 'PubInfo', 'create'
> EXEC sp_fulltext_table 'pub_info', 'create', 'PubInfo', 'UPKCL_pubinfo'
> EXEC sp_fulltext_column 'pub_info', 'pub_id', 'add'
> EXEC sp_fulltext_column 'pub_info', 'pr_info', 'add'
> EXEC sp_fulltext_table 'pub_info', 'activate'
> go
> For example, what error do you get when you try to drop the following FT
> Catalog in the Pubs database?
> use pubs
> go
> exec sp_fulltext_table 'pub_info','drop'
> exec sp_fulltext_catalog 'PubInfo','drop'
> go
> If the above works successfully, for you on your problem server, then the
> problem does not exist with FTS components and removal and reinstallation
> may not be necessary. Could you also try the above procedures with your
> FT-enable table and FT Catalog and post any errors that are returned. If
the
> errors that you receive for this "Catch-22" situation, then I can email
you[vbcol=seagreen]
> a SQL script file to resolve this issue for you.
> 827449 How to manually reinstall the Microsoft Search service for an
> instance of SQL 2000
> http://support.microsoft.com/default...b;EN-US;827449
>
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Fabio" <fabio@.glb.com.br> wrote in message
> news:#iqWcOfCFHA.328@.tk2msftngp13.phx.gbl...
Manager
>
|||Fabio,
Yes. The error message "the microsoft search service cannot be administered
under the present user account" is problematic and often caused by removing
or altering the SQL Server login BUILTIN\Administrators and it most likely
is the source of this problem for you. The MSSearch service needs this login
to log into SQL Server and you can either add back this login with the
original permissions (default master db, sysadmin privileges) or see KB
article:
263712 (Q263712) INF: How to Impede Windows NT Administrators from
Administering a Clustered SQL Server at:
http://support.microsoft.com/default...B;EN-US;263712
If you cannot add back the SQL Server login BUILTIN\Administrators login,
you can use the following SQL code as a substitute:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Fabio" <fabio@.glb.com.br> wrote in message
news:#nic2EiCFHA.3492@.TK2MSFTNGP12.phx.gbl...
> Hi John,
> I did all the steps from the article, but now I have the current problem:
> when I go to delete an existing catalog or create a new one, the follow
> message appears:
> "the microsoft search service cannot be administered under the present
user[vbcol=seagreen]
> account"
> Do you know how can I solve this?
> Thanks again
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:eJFJwOgCFHA.328@.tk2msftngp13.phx.gbl...
(see[vbcol=seagreen]
> helpful
to[vbcol=seagreen]
FT[vbcol=seagreen]
the[vbcol=seagreen]
reinstallation
> the
> you
> Manager
>

regular expression

Hi all,
I m able to use regular expression in a Vbs script, but how can I use them
(if it's possible ) in reporting service code ?
I havent found any subjects like this in the my books (even in "MRS in
action" by Téo Lachev :) )
ThanksFirst, add a function to do your Regular expression in the report level
Code (Report --> Properties --> Code) . Here's an example:
----
Public Function RegExTest () as Object
Dim Str As String = "<expressiontext>the text the returned by
the regular expression</expressiontext>"
Dim expressiontext As String
Dim regexexpressiontext As System.Text.RegularExpressions.Regex
= New
System.Text.RegularExpressions.Regex("<expressiontext>(?<expressiontext>[^<]+)</expressiontext>",
System.Text.RegularExpressions.RegexOptions.IgnoreCase)
expressiontext =regexexpressiontext.Match(Str).Groups("expressiontext").Value
RegExTest = expressiontext
End Function
----
Now your text box will refer to the code in a fashion similar to this:
=Code.RegExTest
And low and behold, regular expressions in Reporting Services.
Andy Potter|||OK.
Thanks a lot !
"Potter" wrote:
> First, add a function to do your Regular expression in the report level
> Code (Report --> Properties --> Code) . Here's an example:
> ----
> Public Function RegExTest () as Object
> Dim Str As String = "<expressiontext>the text the returned by
> the regular expression</expressiontext>"
> Dim expressiontext As String
> Dim regexexpressiontext As System.Text.RegularExpressions.Regex
> = New
> System.Text.RegularExpressions.Regex("<expressiontext>(?<expressiontext>[^<]+)</expressiontext>",
> System.Text.RegularExpressions.RegexOptions.IgnoreCase)
> expressiontext => regexexpressiontext.Match(Str).Groups("expressiontext").Value
> RegExTest = expressiontext
> End Function
> ----
> Now your text box will refer to the code in a fashion similar to this:
> =Code.RegExTest
> And low and behold, regular expressions in Reporting Services.
> Andy Potter
>

Registry settings for service account permissions

We are trying to configure registry settings to allow sql server service to run on a service account in SQL Server 2005. The registry has changed quite a bit from SQL 2000, and we are missing a setting in the software keys that causes sql server service not to start. If we apply permissions to all of HKEY_LOCAL_MACHINE/SOFTWARE, then the service starts, however company security policies do not allow this. Are there any specific keys we should look at, other than the obvious Microsoft/Microsoft SQL Server and Microsoft/MSSQL keys, in which we have already granted permissions to the service account?

Thanks,

Dave

Manually changing the service account is not a supported operation. Changing the service account should only be done via the SQL Server Configuration Manager tool. For further questions about this tool, you can use the SQL Server Tools General forum.

Thanks
Laurentiu

Registry Permissions for on demand pull subscription

To configure an on-demand pull subscription, the domain user account used by
the SQL Server Agent service must have full control permissions on the
registry key: HKLM\Software\Microsoft\Microsoft SQL
Server\80\Replication\Subscriptions. When I attempt to use the registry
editor to configure the permissions, the subscriptions portion of the key is
not present. I am running Win 2000 Server and SQL Server 2000. I am logged on
as an administrator, and I have sucessfully created a merge publication and a
push subcription. Any thoughts on what may be my problem? What SQL process
creates the subscriptions entry in the registery?
Tom McAvoy, MCP
The subscriptions portion of the key can be filled in by using reg files,
but the preferred way of doing it is having Windows Synchronization Manager,
or the ActiveX Controls make these changes.
When you create your push (only through the procs), or you pull (procs or
wizards), ensure you select on demand pull. This will register your
subscription and make the necessary registry entries.
If you did not do this, you will have to configure your pull subcription
withing WSM.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Tom McAvoy" <TomMcAvoy@.discussions.microsoft.com> wrote in message
news:7E02406B-F211-49F4-B1FD-41C2B6127F4A@.microsoft.com...
> To configure an on-demand pull subscription, the domain user account used
by
> the SQL Server Agent service must have full control permissions on the
> registry key: HKLM\Software\Microsoft\Microsoft SQL
> Server\80\Replication\Subscriptions. When I attempt to use the registry
> editor to configure the permissions, the subscriptions portion of the key
is
> not present. I am running Win 2000 Server and SQL Server 2000. I am logged
on
> as an administrator, and I have sucessfully created a merge publication
and a
> push subcription. Any thoughts on what may be my problem? What SQL process
> creates the subscriptions entry in the registery?
> --
> Tom McAvoy, MCP
|||Hillary, thank you for the response. I am unable to create the 'on-demand
pull' subscription due to the lack of permissions on the registry key. I
receive an 'access denied error'. I don't have the exact error info
avaialble right now. I'll review the problem on Monday and post more complete
error info.
"Hilary Cotter" wrote:

> The subscriptions portion of the key can be filled in by using reg files,
> but the preferred way of doing it is having Windows Synchronization Manager,
> or the ActiveX Controls make these changes.
> When you create your push (only through the procs), or you pull (procs or
> wizards), ensure you select on demand pull. This will register your
> subscription and make the necessary registry entries.
> If you did not do this, you will have to configure your pull subcription
> withing WSM.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Tom McAvoy" <TomMcAvoy@.discussions.microsoft.com> wrote in message
> news:7E02406B-F211-49F4-B1FD-41C2B6127F4A@.microsoft.com...
> by
> is
> on
> and a
>
>
|||It seems that you need to be a power user or admin on the machine you are
trying to pull the subscription to.
Also the account which is doing the pulling should be in the PAL.
"Tom McAvoy" <TomMcAvoy@.discussions.microsoft.com> wrote in message
news:8518A10B-BFB3-4C4D-A6E4-8A605F129C22@.microsoft.com...
> Hillary, thank you for the response. I am unable to create the 'on-demand
> pull' subscription due to the lack of permissions on the registry key. I
> receive an 'access denied error'. I don't have the exact error info
> avaialble right now. I'll review the problem on Monday and post more
complete[vbcol=seagreen]
> error info.
> "Hilary Cotter" wrote:
files,[vbcol=seagreen]
Manager,[vbcol=seagreen]
or[vbcol=seagreen]
used[vbcol=seagreen]
registry[vbcol=seagreen]
key[vbcol=seagreen]
logged[vbcol=seagreen]
publication[vbcol=seagreen]
process[vbcol=seagreen]