install SQL on WinXP: plan

Showing posts with label plan. Show all posts

Sunday, March 25, 2012

Can not create Maintenance Plan - getting error message

I just setup two new SQL 2005 Stnd x64bit servers for a customer. The
original two servers running the same SQL version have been running
fine for 3 weeks now. The mian production database is attached and SQL
seems to be working fine. When I try to create a new Maintenance Plan
or use the Maint Plan wizard, I get an error message.
The error message:
TITLE: Microsoft SQL Server Management Studio
--
The action you attempted to perform on a remote instance of SQL Server
has failed because the action requires a SQL Server component that is
not installed on the remote computer. To proceed, install SQL Server
2005 Management Tools on the remote computer, and then try again. For
more information, see "How to: Install SQL Server 2005 (Setup)" in SQL
Server 2005 Books Online, or find the article on MSDN at
http://go.microsoft.com/fwlink/?LinkID=57083 . (ObjectExplorer)
For help, click: http://go.microsoft.com/fwlink/?LinkID=57083
----
I did run SCW on the new servers just like I did on the two original
servers.
Any thoughts? ThanksHi,
I get the exact same error - have you found a solution for your problem
yet?
My setup is a 2 node cluster with SQL 2005 SP1
Regards
Jon skrev:
> I just setup two new SQL 2005 Stnd x64bit servers for a customer. The
> original two servers running the same SQL version have been running
> fine for 3 weeks now. The mian production database is attached and SQL
> seems to be working fine. When I try to create a new Maintenance Plan
> or use the Maint Plan wizard, I get an error message.
> The error message:
> TITLE: Microsoft SQL Server Management Studio
> --
> The action you attempted to perform on a remote instance of SQL Server
> has failed because the action requires a SQL Server component that is
> not installed on the remote computer. To proceed, install SQL Server
> 2005 Management Tools on the remote computer, and then try again. For
> more information, see "How to: Install SQL Server 2005 (Setup)" in SQL
> Server 2005 Books Online, or find the article on MSDN at
> http://go.microsoft.com/fwlink/?LinkID=57083 . (ObjectExplorer)
> For help, click: http://go.microsoft.com/fwlink/?LinkID=57083
> ----
> I did run SCW on the new servers just like I did on the two original
> servers.
> Any thoughts? Thanks

Can not create Maintenance Plan - getting error message

I just setup two new SQL 2005 Stnd x64bit servers for a customer. The
original two servers running the same SQL version have been running
fine for 3 weeks now. The mian production database is attached and SQL
seems to be working fine. When I try to create a new Maintenance Plan
or use the Maint Plan wizard, I get an error message.
The error message:
TITLE: Microsoft SQL Server Management Studio
--
The action you attempted to perform on a remote instance of SQL Server
has failed because the action requires a SQL Server component that is
not installed on the remote computer. To proceed, install SQL Server
2005 Management Tools on the remote computer, and then try again. For
more information, see "How to: Install SQL Server 2005 (Setup)" in SQL
Server 2005 Books Online, or find the article on MSDN at
http://go.microsoft.com/fwlink/?LinkID=57083 . (ObjectExplorer)
For help, click: http://go.microsoft.com/fwlink/?LinkID=57083
----
--
I did run SCW on the new servers just like I did on the two original
servers.
Any thoughts? ThanksHi,
I get the exact same error - have you found a solution for your problem
yet?
My setup is a 2 node cluster with SQL 2005 SP1
Regards
Jon skrev:

> I just setup two new SQL 2005 Stnd x64bit servers for a customer. The
> original two servers running the same SQL version have been running
> fine for 3 weeks now. The mian production database is attached and SQL
> seems to be working fine. When I try to create a new Maintenance Plan
> or use the Maint Plan wizard, I get an error message.
> The error message:
> TITLE: Microsoft SQL Server Management Studio
> --
> The action you attempted to perform on a remote instance of SQL Server
> has failed because the action requires a SQL Server component that is
> not installed on the remote computer. To proceed, install SQL Server
> 2005 Management Tools on the remote computer, and then try again. For
> more information, see "How to: Install SQL Server 2005 (Setup)" in SQL
> Server 2005 Books Online, or find the article on MSDN at
> http://go.microsoft.com/fwlink/?LinkID=57083 . (ObjectExplorer)
> For help, click: http://go.microsoft.com/fwlink/?LinkID=57083
> ----
--
> I did run SCW on the new servers just like I did on the two original
> servers.
> Any thoughts? Thanks

Can not create maintenance plan

I have had two SQL 2005 Stnd x64bit servers running without any problems for several weeks now. I just setup two new ones last night. One the two new ones, I get an error message when I try to create a Maintenance Plan. I also get an error when I try to create a plan using the Wizard.

The error message is:
TITLE: Microsoft SQL Server Management Studio

The action you attempted to perform on a remote instance of SQL Server has failed
because the action requires a SQL Server component that is not installed on the
remote computer. To proceed, install SQL Server 2005 Management Tools on the remote
computer, and then try again. For more information, see "How to: Install SQL Server
2005 (Setup)" in SQL Server 2005 Books Online, or find the article on MSDN at
http://go.microsoft.com/fwlink/?LinkID=57083 . (ObjectExplorer)

For help, click: http://go.microsoft.com/fwlink/?LinkID=57083

Note: SQL Agent is running. So far, everything else seems to be working fine.

Any ideas?

Thanks in advance.

jtwDitto -- same problem, same server type. I observed that it was accessible prior to SP1 but not afterwards. Post-SP1 hotfixes did not solve problem either.|||

Can you make sure you have installed Integrated Service as it should be installed in order to create maintenance plans from the SQL Manager.

Thanks

|||

Hi,

I have the same issue - post sp1 on 2005 64bit. I was under the impression that sp1 removed the need for SSIS when creating maintenance plans.

I just go round in circles trying to reinstall the management tools - but it wont let me as the install cd is now an old version (RTM) and you cant slipstream SP1... do i have to install SSIS?

thanks

Luke

|||

Yes you do need to have SSIS installed to get all the right components to Maintance plans working. This is one of the fixes targeted for SP2 but for right now you need to install SSIS.

Michelle

Can not create maintenance plan

The error message is:
TITLE: Microsoft SQL Server Management Studio

For help, click: http://go.microsoft.com/fwlink/?LinkID=57083

Note: SQL Agent is running. So far, everything else seems to be working fine.

Any ideas?

Thanks in advance.

jtwDitto -- same problem, same server type. I observed that it was accessible prior to SP1 but not afterwards. Post-SP1 hotfixes did not solve problem either.|||

Can you make sure you have installed Integrated Service as it should be installed in order to create maintenance plans from the SQL Manager.

Thanks

|||

Hi,

I have the same issue - post sp1 on 2005 64bit. I was under the impression that sp1 removed the need for SSIS when creating maintenance plans.

I just go round in circles trying to reinstall the management tools - but it wont let me as the install cd is now an old version (RTM) and you cant slipstream SP1... do i have to install SSIS?

thanks

Luke

|||

Yes you do need to have SSIS installed to get all the right components to Maintance plans working. This is one of the fixes targeted for SP2 but for right now you need to install SSIS.

Michelle

Can not create maintenance plan

The error message is:
TITLE: Microsoft SQL Server Management Studio

For help, click: http://go.microsoft.com/fwlink/?LinkID=57083

Note: SQL Agent is running. So far, everything else seems to be working fine.

Any ideas?

Thanks in advance.

jtwDitto -- same problem, same server type. I observed that it was accessible prior to SP1 but not afterwards. Post-SP1 hotfixes did not solve problem either.|||

Can you make sure you have installed Integrated Service as it should be installed in order to create maintenance plans from the SQL Manager.

Thanks

|||

Hi,

I have the same issue - post sp1 on 2005 64bit. I was under the impression that sp1 removed the need for SSIS when creating maintenance plans.

I just go round in circles trying to reinstall the management tools - but it wont let me as the install cd is now an old version (RTM) and you cant slipstream SP1... do i have to install SSIS?

thanks

Luke

|||

Yes you do need to have SSIS installed to get all the right components to Maintance plans working. This is one of the fixes targeted for SP2 but for right now you need to install SSIS.

Michelle

sql

Can not create maintenance plan

The error message is:
TITLE: Microsoft SQL Server Management Studio

For help, click: http://go.microsoft.com/fwlink/?LinkID=57083

Note: SQL Agent is running. So far, everything else seems to be working fine.

Any ideas?

Thanks in advance.

jtwDitto -- same problem, same server type. I observed that it was accessible prior to SP1 but not afterwards. Post-SP1 hotfixes did not solve problem either.|||

Can you make sure you have installed Integrated Service as it should be installed in order to create maintenance plans from the SQL Manager.

Thanks

|||

Hi,

I have the same issue - post sp1 on 2005 64bit. I was under the impression that sp1 removed the need for SSIS when creating maintenance plans.

I just go round in circles trying to reinstall the management tools - but it wont let me as the install cd is now an old version (RTM) and you cant slipstream SP1... do i have to install SSIS?

thanks

Luke

|||

Yes you do need to have SSIS installed to get all the right components to Maintance plans working. This is one of the fixes targeted for SP2 but for right now you need to install SSIS.

Michelle

Monday, March 19, 2012

can MSRS 2000 run with .NET 2.0

Can MSRS 2000 run with .NET 2.0 . If not then is there any plan for a MSRS version which is compatible with MSRS 2000?No. RS 2000 is not .Net2.0 compatible.
Reporting Services 2005 is .Net 2.0 compatible. RS 2005 is being released with SQL Server 2005.

Can MSDE work as SQL Server?

I plan on replacing a SQL2000 database with MSDE for lowering budget.
Can we script up the SQL database (with SPs, triggers, and UDFs) and recreate it in MSDE?
Thanks.All SQL Server code will work fine on MSDE. The restriction is that it is restricted to 8 concurrent operations. At that point, there is a governer that kiks in to slow down operations.

http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true

http://www.microsoft.com/sql/msde/|||How can we create/maintain tables, views, stored procedures, triggers and UDFs in MSDE?
Thanks|||through SQL code. CREATE TABLE, CREATE VIEW, ALTER PRCEDURE etc... see Books Online

(you can also connect with the SQL Server client tools, and other SQL Server management tools can be found on the web)

Thursday, March 8, 2012

Can I..........

Can I run "Maintenance Plan" directly (without wait its scheduling)? If can,
How to run it?You can run the job(s) associated with the plan directly by right-clicking
the job in EM and selecting Start Job.
HTH
Jerry
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:ezk7V%23bzFHA.3152@.TK2MSFTNGP10.phx.gbl...
> Can I run "Maintenance Plan" directly (without wait its scheduling)? If
> can,
> How to run it?
>|||In Enterprise Manager, go to Management / SQL Server Agent / Jobs,
right-click on the appropriate job for your maintenance plan and choose
Start Job.
Razvan|||Yes go to the jobs and the maintainance plan(s) should be listed there
DB backup for ...plan
Transaction log backup for ...plan
Integrity checks for ...plan
just right click and select start job
http://sqlservercode.blogspot.com/
"Bpk. Adi Wira Kusuma" wrote:

> Can I run "Maintenance Plan" directly (without wait its scheduling)? If ca
n,
> How to run it?
>
>

Sunday, February 12, 2012

Can I manually delete .bak files?

I'm running a SQL 2000 server and have a maintenance plan that does complete
backups daily, with a 10 day retention on files.
For some reason, I have .bak files that go back as far as January on several
databases, which is an issue in and of itself.
My question is, are all of the .bak files independent of each other and can
I safely delete older ones without affecting the more recent backups?
Thanks you,
LarryAre we talking about database or log backups?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:C86E6A38-8449-4ADB-8F5D-0559B676AB16@.microsoft.com...
> I'm running a SQL 2000 server and have a maintenance plan that does complete
> backups daily, with a 10 day retention on files.
> For some reason, I have .bak files that go back as far as January on several
> databases, which is an issue in and of itself.
> My question is, are all of the .bak files independent of each other and can
> I safely delete older ones without affecting the more recent backups?
> Thanks you,
> Larry|||Database, not transaction.
"Tibor Karaszi" wrote:
> Are we talking about database or log backups?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Larry" <Larry@.discussions.microsoft.com> wrote in message
> news:C86E6A38-8449-4ADB-8F5D-0559B676AB16@.microsoft.com...
> > I'm running a SQL 2000 server and have a maintenance plan that does complete
> > backups daily, with a 10 day retention on files.
> >
> > For some reason, I have .bak files that go back as far as January on several
> > databases, which is an issue in and of itself.
> >
> > My question is, are all of the .bak files independent of each other and can
> > I safely delete older ones without affecting the more recent backups?
> >
> > Thanks you,
> >
> > Larry
>|||A more recent db backup is not dependent on an earlier db backup. However if you need to do point in
time restore to some point between the earlier and the more recent db backup and you also have log
backups covering that period, then you want to save the earlier db backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:D06E7454-66E6-4153-8EFA-3B7A0FF7C62E@.microsoft.com...
> Database, not transaction.
> "Tibor Karaszi" wrote:
>> Are we talking about database or log backups?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Larry" <Larry@.discussions.microsoft.com> wrote in message
>> news:C86E6A38-8449-4ADB-8F5D-0559B676AB16@.microsoft.com...
>> > I'm running a SQL 2000 server and have a maintenance plan that does complete
>> > backups daily, with a 10 day retention on files.
>> >
>> > For some reason, I have .bak files that go back as far as January on several
>> > databases, which is an issue in and of itself.
>> >
>> > My question is, are all of the .bak files independent of each other and can
>> > I safely delete older ones without affecting the more recent backups?
>> >
>> > Thanks you,
>> >
>> > Larry
>>

Sunday, March 25, 2012

Can not create Maintenance Plan - getting error message

Can not create Maintenance Plan - getting error message

Can not create maintenance plan

Can not create maintenance plan

Can not create maintenance plan

Can not create maintenance plan

Monday, March 19, 2012

can MSRS 2000 run with .NET 2.0

Can MSDE work as SQL Server?

Thursday, March 8, 2012

Can I..........

Sunday, February 12, 2012

Can I manually delete .bak files?

Can I manually delete .bak files?

Can I manually delete .bak files?

install SQL on WinXP

Blog Archive

About Me