Minimun SP Level for Cluster Upgrade

I'm upgrading MSSQL2000 (RTM) cluster to 2005. I haven't seen any information regarding a minimum service pack level for 2000. This upgrade just makes me overly caution.

To upgrade to SQL 2005, you need to be running SQL 2000 SP3(or SP3a) at a minimum.

Thanks,

Sam Lester (MSFT)

|||

Here's the link from Books Online:

http://msdn2.microsoft.com/en-us/library/ms144245.aspx

Sam

Minimum rights for a user to run SQL Server service?

Hi fellows
I was just wondering what the minimum rights a local user
must have to be able to run the MSSQLserver service.
Have been using a user that is administrator on the server
but now i would like to know what the minimum requirments
are for running MSSQLServer service are?
Absolut minimum :-)
Thanks in advance
Risun"Risun" <risun@.wmdata.com> wrote in message
news:0c0d01c39196$5ec6e1c0$a001280a@.phx.gbl...
> I was just wondering what the minimum rights a local user
> must have to be able to run the MSSQLserver service.
> Have been using a user that is administrator on the server
> but now i would like to know what the minimum requirments
> are for running MSSQLServer service are?
> Absolut minimum :-)
You could run the MSSQLServer service account as LocalSystem, no user
account required...
This article does a good job of outlining the account requirements to
properly lock down SQL Server server.
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn
ol/sql/maintain/security/sp3sec/SP3SEC01.ASP
Steve|||If you go to SQL Server download and download Books On Line SP3. This will
tell you what rights the account needs. Search for "Setting up Windows
Services Accounts" and you will fin all the info you need.
--
Barry McAuslin
Look inside your SQL Server files with SQL File Explorer.
Go to http://www.sqlfe.com for more information.
"Risun" <risun@.wmdata.com> wrote in message
news:0c0d01c39196$5ec6e1c0$a001280a@.phx.gbl...
> Hi fellows
> I was just wondering what the minimum rights a local user
> must have to be able to run the MSSQLserver service.
> Have been using a user that is administrator on the server
> but now i would like to know what the minimum requirments
> are for running MSSQLServer service are?
> Absolut minimum :-)
> Thanks in advance
> Risunsql

Minimal configuration of .NET Visual Studio

Hi
What is a minimal configuration of .NET Visual Studio to setup Reporting
Service?
Regards,
GennadiWhat is needed is the 2003 IDE shell.
Visual Basic.NET 2003 version should be enough.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gena" <gretchkosiy@.hotmail.com> wrote in message
news:uJQ0PpkiEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Hi
> What is a minimal configuration of .NET Visual Studio to setup Reporting
> Service?
> Regards,
> Gennadi
>|||Thanx
Is there any possibilities to run away from .NET VisualStudio to create
reports? I mean any GUI tools.
Thanx
Gennadi
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:uzSqmxkiEHA.1764@.TK2MSFTNGP10.phx.gbl...
> What is needed is the 2003 IDE shell.
> Visual Basic.NET 2003 version should be enough.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Gena" <gretchkosiy@.hotmail.com> wrote in message
> news:uJQ0PpkiEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > Hi
> >
> > What is a minimal configuration of .NET Visual Studio to setup Reporting
> > Service?
> >
> > Regards,
> > Gennadi
> >
> >
>|||Report Designer is implemented as VS component and would not work without
VS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gena" <gretchkosiy@.hotmail.com> wrote in message
news:%23mwUt5kiEHA.3664@.TK2MSFTNGP11.phx.gbl...
> Thanx
> Is there any possibilities to run away from .NET VisualStudio to create
> reports? I mean any GUI tools.
> Thanx
> Gennadi
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:uzSqmxkiEHA.1764@.TK2MSFTNGP10.phx.gbl...
>> What is needed is the 2003 IDE shell.
>> Visual Basic.NET 2003 version should be enough.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Gena" <gretchkosiy@.hotmail.com> wrote in message
>> news:uJQ0PpkiEHA.3148@.TK2MSFTNGP10.phx.gbl...
>> > Hi
>> >
>> > What is a minimal configuration of .NET Visual Studio to setup
>> > Reporting
>> > Service?
>> >
>> > Regards,
>> > Gennadi
>> >
>> >
>>
>

Migration Problem with NS SQL 2000 to NS SQL 2005

Hello,

I'm traying to migrate a Notification service solution from SQL Server 2000 to SQL Server 2005. The solution works fine on SQL Server 2000, but on 2005 I allways get the message: "The registry entries for the specified instance of Notification Services could not be found". This message shows up everytime when i want to see the Subscriptions of a given Subscriber in my Web-Interface (written in ASP and C#) or when I want to add a new Subscription. News of a existing Subscription are shown without a problem.

So far I know i did follow all the steps to migrate the Database, Application and NS-Instance.

First I upgrated the DB-Files in SQL 2000 to SQL 2005. (Only the DB-file for user and admin Login for the Web-Inteface) Then i attached the DB file on the SQL 2005 server. So far everything works fine and users can log in. Then I edited the ADF-File and chaged all the NOTIFY syntax to INSERT INTO and changed all the paths to the new server-environement. In the Management Studio of SQL 2005 I created a new NS-Instance with the adapted ADF-file and the service is running without problems. At the end I recompiled all the ASP and C# scripts in Visual Studio 2005 with the assemblies of .NET 2.0 and SQL Server 2005.

Does anybody knows why the entries of this existing and running instance in the registry can't be found? The name of the instance is right and is in the registry.

Can anybody help ?

From my replies to your newsgroup posting....

Have you checked with the depreciated features pages of BOL to make
sure your C# code isn't making use of the old way of doing things?
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/c4612650-eaa9-443a-a4ef-95d9feaf4976.htm
Can you post the code that's failing?

By the way, I have an article on Simple-Talk.com about upgrading
to SQLNS 2005 from 2000.

http://www.simple-talk.com/2006/04/10/building-effective-sql-server-notification-applications-part-i/
or

http://sqlns.blogspot.com/2006/04/upgrading-to-sqlns-2005-from-2000.html

|||I had the same problem and solved it by changing my reference in VS to point to newest version of microsoft.sqlserver.notification.dll (version 9.0.242.0) and recompile- hope this helps-

Migration from ComponentOne Reporting Service to SQL 2005 RS

Hi,
Is it possible to migrate from Component RS to SQL 2005 RS?Hi,
Is it possible to migrate from ComponentOne RS to SQL 2005 RS?