Help for maintenance plan

Hello to all
I make maintenance plan for backup of my SQL server 2000 database. I want to
make some changes in maintenance plan but i am not bale to see where can i
perform these changes? Need help
Regds
HenrikWhat changes are you trying to make?
If you open Enterprise Manager, go to Management, Maintenance Plans. Right
click the Maintenance Plan you created...go to properties. Then go to the
Complete Backup Tab...
If the option you are looking for is not there, then it's an option that can
only be changed during the creation of the plan.
You will have to create a new plan.
Donna Lambert
"Henrik" wrote:

> Hello to all
> I make maintenance plan for backup of my SQL server 2000 database. I want
to
> make some changes in maintenance plan but i am not bale to see where can i
> perform these changes? Need help
> --
> Regds
> Henrik
>

Help for maintenance plan

Hello to all
I make maintenance plan for backup of my SQL server 2000 database. I want to
make some changes in maintenance plan but i am not bale to see where can i
perform these changes? Need help
Regds
Henrik
What changes are you trying to make?
If you open Enterprise Manager, go to Management, Maintenance Plans. Right
click the Maintenance Plan you created...go to properties. Then go to the
Complete Backup Tab...
If the option you are looking for is not there, then it's an option that can
only be changed during the creation of the plan.
You will have to create a new plan.
Donna Lambert
"Henrik" wrote:

> Hello to all
> I make maintenance plan for backup of my SQL server 2000 database. I want to
> make some changes in maintenance plan but i am not bale to see where can i
> perform these changes? Need help
> --
> Regds
> Henrik
>

Help for maintenance plan

Hello to all
I make maintenance plan for backup of my SQL server 2000 database. I want to
make some changes in maintenance plan but i am not bale to see where can i
perform these changes? Need help
--
Regds
HenrikWhat changes are you trying to make?
If you open Enterprise Manager, go to Management, Maintenance Plans. Right
click the Maintenance Plan you created...go to properties. Then go to the
Complete Backup Tab...
If the option you are looking for is not there, then it's an option that can
only be changed during the creation of the plan.
You will have to create a new plan.
Donna Lambert
"Henrik" wrote:
> Hello to all
> I make maintenance plan for backup of my SQL server 2000 database. I want to
> make some changes in maintenance plan but i am not bale to see where can i
> perform these changes? Need help
> --
> Regds
> Henrik
>sql

help for licence purchase

Hello,
Thank you in advance.
I plan to buy SQL 2000. My situation is: two IIS boxes (
dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they
are all running in Windows 2000.
Those two IIS boxes have some other VB applications (<15)
may access database.
Question:
which licence model is good for me? Standard or Enterprise
version?
alex| Hello,
|
| Thank you in advance.
|
| I plan to buy SQL 2000. My situation is: two IIS boxes (
| dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they
| are all running in Windows 2000.
| Those two IIS boxes have some other VB applications (<15)
| may access database.
|
| Question:
| which licence model is good for me? Standard or Enterprise
| version?
--
Hi Alex,
Checkout the licensing section of the SQL Server FAQ at:
http://www.microsoft.com/sql/howtobuy/faq.asp
Hope this helps,
--
Eric Cárdenas
SQL Server support|||Standard and Enterprise refer to the edition of SQL Server. The edition =is a separate item from the licensing mode. For licensing information =refer to http://www.microsoft.com/sql/howtobuy/default.asp. For =information on each edition of SQL Server, refer to this page: =http://www.microsoft.com/sql/evaluation/features/choosing.asp
-- Keith
"alex" <anonymous@.discussions.microsoft.com> wrote in message =news:033c01c3cf25$1d1152c0$a401280a@.phx.gbl...
> Hello,
> > Thank you in advance.
> > I plan to buy SQL 2000. My situation is: two IIS boxes ( > dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they > are all running in Windows 2000.
> Those two IIS boxes have some other VB applications (<15) > may access database.
> > Question:
> which licence model is good for me? Standard or Enterprise > version?
> > alex >|||Thank you guys.
Please tell me how do I buy SQL server in simple words.
Alex
>--Original Message--
>Hello,
>Thank you in advance.
>I plan to buy SQL 2000. My situation is: two IIS boxes (
>dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they
>are all running in Windows 2000.
>Those two IIS boxes have some other VB applications
(<15)
>may access database.
>Question:
>which licence model is good for me? Standard or
Enterprise
>version?
>alex
>.
>|||http://www.microsoft.com/sql/howtobuy/default.asp
Next Steps
1.. Review the SQL Server Licensing FAQ.
2.. Compare prices of Oracle9i and IBM DB2 to learn how much you can =save with SQL Server.
3.. To obtain copies of SQL Server 2000, you can:
a.. Call (800) 426-9400 from the United States or call (877) =568-2495 from Canada to speak with a Microsoft representative. b.. Purchase licenses from Microsoft licensing program resellers. =(http://shop.microsoft.com/helpdesk/mvlref.asp)
c.. Order from a U.S. reseller =(http://shop.microsoft.com/helpdesk/reseller.asp).=20
d.. Search the Microsoft Worldwide Information site =(http://www.microsoft.com/worldwide/) to find an international reseller =in your location. e.. Buy online from shop.microsoft.com. -- Keith
"alex" <anonymous@.discussions.microsoft.com> wrote in message =news:09b401c3cfc1$258421c0$a601280a@.phx.gbl...
> Thank you guys.
> > Please tell me how do I buy SQL server in simple words.
> > Alex
> > >--Original Message--
> >Hello,
> >
> >Thank you in advance.
> >
> >I plan to buy SQL 2000. My situation is: two IIS boxes ( > >dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they > >are all running in Windows 2000.
> >Those two IIS boxes have some other VB applications > (<15) > >may access database.
> >
> >Question:
> >which licence model is good for me? Standard or > Enterprise > >version?
> >
> >alex > >
> >.
> >

Help - can't create or edit a Maintenance Plan

I noticed the following after changing the password for the SQL 2005 Service
Accounts.
- I could not longer edit or create Maintenance Plans.
- error returned 0x80004005 (Client unable to establish connection)
In the SQL error log I found
Server Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
Oct 14 2005 00:35:21
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
.
.
Server FallBack certificate initialization failed with error code: 1.
Server Warning:Encryption is not available, could not find a valid
certificate to load.
.
.
Logon The prelogin packet used to open the connection is structurally
invalid; the connection has been closed. Please contact the vendor of the
client library. [CLIENT: <local machine>]
Logon Error: 17828, Severity: 20, State: 3.
*** Note that SQL is running on
Windows Server 2003 R2 Standard x64 edition Service Pack 1
It is also a domain controller.
Any ideas?
ThanksHi,
I was having this exact same problem, here is what resolved this issue
for me:
1. Go to C:\Documents and Settings\"sql startup account"\Application
Data\Microsoft\Crypto\RSA\S-1-5-21.....
(where "sql startup account" should be the name of your startup account
for sql server")
2 Backup and then delete any files in the S-1-5-21etcetc folder. (but
don't delete the folder)
3. Restart SQL Server.
HTH.
BobT732 wrote:
> I noticed the following after changing the password for the SQL 2005 Servi
ce
> Accounts.
> - I could not longer edit or create Maintenance Plans.
> - error returned 0x80004005 (Client unable to establish connection)
> In the SQL error log I found
> Server Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
> Oct 14 2005 00:35:21
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
> .
> .
> Server FallBack certificate initialization failed with error code: 1.
> Server Warning:Encryption is not available, could not find a valid
> certificate to load.
> .
> .
> Logon The prelogin packet used to open the connection is structurall
y
> invalid; the connection has been closed. Please contact the vendor of the
> client library. [CLIENT: <local machine>]
> Logon Error: 17828, Severity: 20, State: 3.
>
> *** Note that SQL is running on
> Windows Server 2003 R2 Standard x64 edition Service Pack 1
> It is also a domain controller.
> Any ideas?
> Thanks|||Yes that did it!
Thank You Very Much
"teefer22@.hotmail.com" wrote:

> Hi,
> I was having this exact same problem, here is what resolved this issue
> for me:
> 1. Go to C:\Documents and Settings\"sql startup account"\Application
> Data\Microsoft\Crypto\RSA\S-1-5-21.....
> (where "sql startup account" should be the name of your startup account
> for sql server")
> 2 Backup and then delete any files in the S-1-5-21etcetc folder. (but
> don't delete the folder)
> 3. Restart SQL Server.
> HTH.
>
> BobT732 wrote:
>

Help - can't create or edit a Maintenance Plan

I noticed the following after changing the password for the SQL 2005 Service
Accounts.
- I could not longer edit or create Maintenance Plans.
- error returned 0x80004005 (Client unable to establish connection)
In the SQL error log I found
Server Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
Oct 14 2005 00:35:21
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
.
.
Server FallBack certificate initialization failed with error code: 1.
Server Warning:Encryption is not available, could not find a valid
certificate to load.
.
.
Logon The prelogin packet used to open the connection is structurally
invalid; the connection has been closed. Please contact the vendor of the
client library. [CLIENT: <local machine>]
Logon Error: 17828, Severity: 20, State: 3.
*** Note that SQL is running on
Windows Server 2003 R2 Standard x64 edition Service Pack 1
It is also a domain controller.
Any ideas?
ThanksHi,
I was having this exact same problem, here is what resolved this issue
for me:
1. Go to C:\Documents and Settings\"sql startup account"\Application
Data\Microsoft\Crypto\RSA\S-1-5-21.....
(where "sql startup account" should be the name of your startup account
for sql server")
2 Backup and then delete any files in the S-1-5-21etcetc folder. (but
don't delete the folder)
3. Restart SQL Server.
HTH.
BobT732 wrote:
> I noticed the following after changing the password for the SQL 2005 Service
> Accounts.
> - I could not longer edit or create Maintenance Plans.
> - error returned 0x80004005 (Client unable to establish connection)
> In the SQL error log I found
> Server Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
> Oct 14 2005 00:35:21
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
> .
> .
> Server FallBack certificate initialization failed with error code: 1.
> Server Warning:Encryption is not available, could not find a valid
> certificate to load.
> .
> .
> Logon The prelogin packet used to open the connection is structurally
> invalid; the connection has been closed. Please contact the vendor of the
> client library. [CLIENT: <local machine>]
> Logon Error: 17828, Severity: 20, State: 3.
>
> *** Note that SQL is running on
> Windows Server 2003 R2 Standard x64 edition Service Pack 1
> It is also a domain controller.
> Any ideas?
> Thanks|||Yes that did it!
Thank You Very Much
"teefer22@.hotmail.com" wrote:
> Hi,
> I was having this exact same problem, here is what resolved this issue
> for me:
> 1. Go to C:\Documents and Settings\"sql startup account"\Application
> Data\Microsoft\Crypto\RSA\S-1-5-21.....
> (where "sql startup account" should be the name of your startup account
> for sql server")
> 2 Backup and then delete any files in the S-1-5-21etcetc folder. (but
> don't delete the folder)
> 3. Restart SQL Server.
> HTH.
>
> BobT732 wrote:
> > I noticed the following after changing the password for the SQL 2005 Service
> > Accounts.
> >
> > - I could not longer edit or create Maintenance Plans.
> > - error returned 0x80004005 (Client unable to establish connection)
> > In the SQL error log I found
> > Server Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
> > Oct 14 2005 00:35:21
> > Copyright (c) 1988-2005 Microsoft Corporation
> > Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
> > .
> > .
> > Server FallBack certificate initialization failed with error code: 1.
> > Server Warning:Encryption is not available, could not find a valid
> > certificate to load.
> > .
> > .
> > Logon The prelogin packet used to open the connection is structurally
> > invalid; the connection has been closed. Please contact the vendor of the
> > client library. [CLIENT: <local machine>]
> > Logon Error: 17828, Severity: 20, State: 3.
> >
> >
> > *** Note that SQL is running on
> > Windows Server 2003 R2 Standard x64 edition Service Pack 1
> >
> > It is also a domain controller.
> >
> > Any ideas?
> >
> > Thanks
>