Showing posts with label installed. Show all posts
Showing posts with label installed. Show all posts

Monday, March 26, 2012

Maintenance Plan - Not under Management Folder

Hi,

I installed the SQL Server Management Studio Express this morning and am able to attach to my SQL2000 instance runnng on my laptop. I wanted to confirm my database backup schedules but there is no Maintenance plan under the Management Folder in SQL Server Management Studio Express.

Can someone please assit me in wotking this out..

Regards..

Peter.

Is there a Legacy node (with its own Database Maintenance Plans node) under Management? I'm not sure what happens when you try to manage a SQL 2000 server, but when upgrading to 2005, that's where the 'safety copies' of the old maintenance plans live, since the ones in 2005 are so different that exact conversion isn't always possible.

Due to this, it may not be possible to manage SQL 2000 maintenance plans with the 2005 management tools -- again, this is just a guess from my side, as I just did away with my last SQL 2000 server last week, and can't check.

'//mdb

|||

Hi,

No there's no node under any folder fro even trying to setup maintenance plans, that's my main issue. I currently have scherduled backups performed on my databases each day and I noted when you right click a database you can back it up but not schedule backups so I wanted to look at perhaps setting up a mainteneace paln.

Regards..

Peter.

|||

The maintenance plan UI in Management Studio uses SQL Agent to run a periodic job to perform the maintenance. SQL Agent is not included in SQL Server Express, so Management Studio Express does not include maintenance plan UI.

You should be able to view existing maintenance plans on SQL Server 2000 servers though. Is this not working for you?

|||

Hi,

Yes I came to that conclusion as well after reviewing the comparisons between all versions of SQL 2005 on the Microsoft web site.

No there is no node to view any exisitng or setup any maintnence plans for my SQL2000 instance.

Regards..

Peter.

Maintenance Plan - Not under Management Folder

Hi,

I installed the SQL Server Management Studio Express this morning and am able to attach to my SQL2000 instance runnng on my laptop. I wanted to confirm my database backup schedules but there is no Maintenance plan under the Management Folder in SQL Server Management Studio Express.

Can someone please assit me in wotking this out..

Regards..

Peter.

Is there a Legacy node (with its own Database Maintenance Plans node) under Management? I'm not sure what happens when you try to manage a SQL 2000 server, but when upgrading to 2005, that's where the 'safety copies' of the old maintenance plans live, since the ones in 2005 are so different that exact conversion isn't always possible.

Due to this, it may not be possible to manage SQL 2000 maintenance plans with the 2005 management tools -- again, this is just a guess from my side, as I just did away with my last SQL 2000 server last week, and can't check.

'//mdb

|||

Hi,

No there's no node under any folder fro even trying to setup maintenance plans, that's my main issue. I currently have scherduled backups performed on my databases each day and I noted when you right click a database you can back it up but not schedule backups so I wanted to look at perhaps setting up a mainteneace paln.

Regards..

Peter.

|||

The maintenance plan UI in Management Studio uses SQL Agent to run a periodic job to perform the maintenance. SQL Agent is not included in SQL Server Express, so Management Studio Express does not include maintenance plan UI.

You should be able to view existing maintenance plans on SQL Server 2000 servers though. Is this not working for you?

|||

Hi,

Yes I came to that conclusion as well after reviewing the comparisons between all versions of SQL 2005 on the Microsoft web site.

No there is no node to view any exisitng or setup any maintnence plans for my SQL2000 instance.

Regards..

Peter.

sql

Wednesday, March 21, 2012

Maintance plans corrupted after sp2...

Posted - 03/19/2007 : 09:14:02


I installed sp2 on my sql server2005. It failed on database engine service. And i am not able to open existing maintance plans or create new plans.
When i try to open existing plan i am getting the following error:
Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}' failed due to the following error: Interface not registered (Exception from HRESULT: 0x80040155). (Microsoft.SqlServer.ManagedDTS)

Any help appreciated...

Had same issue. What I did was run a manual backup of all my user databases. After that all my maintenance plans were working again (Never had issues with my system dbs tho).

Hope this helps.

Regards

Jonas

|||

Hmm you might wanner have a look there is a patch for SP2 adressing Clean Up issues in regards to Maintenance Plans. Built 9.0.3050 (SP2 is 9.0.42)

Regards

Jonas

|||

Also have a look at the patch for SP2 (built 9.0.3050). It adresses issues in regards to clean up...

Regards

Jonas

Maintance plan in SQL SERVER 2005 WORKGROUP

Can any one tell me what I should do with following error :

I'm working with sql server 2005 workgroup and I installed SP2.

When I make a maintenance plan voor backup the databases (full) then at the end I got the following error !

save maintenance plan failed

One or more arguments are invalid.

I red this problem already on forums but I didn't get it resolved.

When I use sql server 2005 developer It worked fine !

Geert

A strange thing happend :

After installing SP2 on a new server everything went well !

Geert

Monday, March 19, 2012

Maintaining Remote SQL Database

Hi,
I have a sql2k server hosted by my ISP. I need to get the database from
my local development server installed on the sql2k server maintained by
my ISP.
My ISP has told me that there is no enterprise manager access to the
server, any changes to the database need to be done through script or
some other means.
Can anyone provide some guidance on the best practices/methods for doing
this, the thought of manually creating all the tables/relationships/sp's
etc.. on the other machine sounds quite a complex process.
Thanks in advance,
Kieran
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!For the initial database create they will probably allow you to backup your
database and they will restore it. alternitavly use sp_detach_db and they
can attach.
For updates to procs etc you can issue CREATE / DROP / ALTER statements
through Query Analyser or send the .SQL scripts to the ISP
--
HTH
Ryan Waight, MCDBA, MCSE
"Kieran" <anonymous@.devdex.com> wrote in message
news:eePAoX%23kDHA.1948@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a sql2k server hosted by my ISP. I need to get the database from
> my local development server installed on the sql2k server maintained by
> my ISP.
> My ISP has told me that there is no enterprise manager access to the
> server, any changes to the database need to be done through script or
> some other means.
> Can anyone provide some guidance on the best practices/methods for doing
> this, the thought of manually creating all the tables/relationships/sp's
> etc.. on the other machine sounds quite a complex process.
> Thanks in advance,
> Kieran
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Kieran <anonymous@.devdex.com> wrote in message news:<eePAoX#kDHA.1948@.TK2MSFTNGP12.phx.gbl>...
> My ISP has told me that there is no enterprise manager access to the
> server, any changes to the database need to be done through script or
> some other means.
> Can anyone provide some guidance on the best practices/methods for doing
> this, the thought of manually creating all the tables/relationships/sp's
> etc.. on the other machine sounds quite a complex process.
Hi
A web-based administration tool like myLittleAdmin can save you a lot
of time and work. More info, demo and free trial on
http://www.mylittletools.net/mla_sql
Best regards
el.c.

Friday, March 9, 2012

main page blank after new install ?

Hi,
I installed reporting services on 2003 (IIS6, front page ext, asp.net, no
vb.net). When connecting to http://server im directed to
http://server/Reports/Pages/Folder.aspx . The main form header shows HOME /
MY SUBSCRIPTIONS / HELP but the main page is blank.
Anyone know why and how to sort ?
Thanks
Scottim just wondering if its because i didnt install VB.net 03 so the report
designer is not available.|||on the hosting server i enter http://localhost and get the Report Manager
with all the options.
From a client i get a blank home page. I assume because nothing is setup yet
which is fine.

Mailsend program

Hi All,

I have installed SQL Server 2005 and created a job. I made the job failed to test the mailsend program. The notification step that uses the mailsend succeeded but I did not get an email. I am using mailsend program on SQL Server 2000 and it works fine. I am really stomped and don't know what to do to fix it?

Thanks.what are you using to send mail? xp_sendmail? xp_smtpmail? CDOSYS? CDONTS?

I feel stomped everyday.|||I am using xp_sendmail.|||have you...

installed outlook on your DB server?

is the agent using a network account mapped to an exhange mail profile?

have you tested sending mail directly from the mail client?

have you started a sql mail client session with xp_startmail?|||Yes, Outlook Express

How can I check it? Our network guys set up the server

Yes and it was successfull

I have read in BOL that this feature will be removed in a future version of Microsoft SQL Server.|||Have you opened the "Surface Area Configuration" tool and looked under feature configuration to enable SQL Mail?

BTW ... Database Mail is the preferred method with 2005.|||I'll try Database Mail option|||Database Mail is MUCH better. It takes a bit of configuration, but it's really nice.

hmscott|||On SQL Server 2005 use sp_senddbmail. It sends mail using SMTP and uses service broker for queuing mails to be sent. No need for Outlook on the server anymore, and the mail sending process is 100% asyncronous.

Monday, February 20, 2012

lsass.exe high cpu, Error 18456

We just migrated to a new sql server with SQL Server 2005 installed (we moved from 2000).

We are experiencing two issues that we cannot resolve:

1. The site and database clients that use this SQL Server run very slow now. We have noticed that the lsass.exe process consistantly uses 25% CPU, +/- 10%. When we stop SQL server the lsass.exe process goes down to 0. What can be causing this? The website uses a SQL user account, not a windows user account.

2. We have an error in the event log that might be related to the issue above. It appears every few minutes:

Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/25/2006
Time: 11:54:42 AM
User: NT AUTHORITY\SYSTEM
Computer: MSDB
Description:
Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]

The error log from SQL gives more info:

Error: 18456, Severity: 14, State: 16.

What is causing this? How can this be traced?

I am stuck here. All help greatly appreciated.

Moshe

I'm not sure about the lsass.exe process, but here is a good blog from the SQL Protocols team about the failure error messages.

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Thanks,
Sam Lester (MSFT)

|||

I have seen that blog, but it did not help me. I will post there anyway though.

Please advise, this is a serious issue.

|||

I may also add that I have not yet ungraded to Service Pack 1. Are their any known issues related to this that were fixed with Service Pack 1? I would only upgrade now if you were confident that upgrading would fix the issue since the server is now deployed.

|||People, including me, have also seen high CPU usage by lsass.exe when signing into Windows Live Messenger (and possibly earlier versions of Messenger).
|||I have the same problem, everytime that I open messenger live the cpu goes high, lsass.exe take all my cpu...

have you find something to fix the problem?

regards,

|||I reformatted the machine that resolved the issue. Microsoft PSS was not helpful in this and could not uncover the cause of the issue. Sad

lsass.exe high cpu, Error 18456

We just migrated to a new sql server with SQL Server 2005 installed (we moved from 2000).

We are experiencing two issues that we cannot resolve:

1. The site and database clients that use this SQL Server run very slow now. We have noticed that the lsass.exe process consistantly uses 25% CPU, +/- 10%. When we stop SQL server the lsass.exe process goes down to 0. What can be causing this? The website uses a SQL user account, not a windows user account.

2. We have an error in the event log that might be related to the issue above. It appears every few minutes:

Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/25/2006
Time: 11:54:42 AM
User: NT AUTHORITY\SYSTEM
Computer: MSDB
Description:
Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]

The error log from SQL gives more info:

Error: 18456, Severity: 14, State: 16.

What is causing this? How can this be traced?

I am stuck here. All help greatly appreciated.

Moshe

I'm not sure about the lsass.exe process, but here is a good blog from the SQL Protocols team about the failure error messages.

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Thanks,
Sam Lester (MSFT)

|||

I have seen that blog, but it did not help me. I will post there anyway though.

Please advise, this is a serious issue.

|||

I may also add that I have not yet ungraded to Service Pack 1. Are their any known issues related to this that were fixed with Service Pack 1? I would only upgrade now if you were confident that upgrading would fix the issue since the server is now deployed.

|||People, including me, have also seen high CPU usage by lsass.exe when signing into Windows Live Messenger (and possibly earlier versions of Messenger).
|||I have the same problem, everytime that I open messenger live the cpu goes high, lsass.exe take all my cpu...

have you find something to fix the problem?

regards,

|||I reformatted the machine that resolved the issue. Microsoft PSS was not helpful in this and could not uncover the cause of the issue. Sad

lsass.exe high cpu, Error 18456

We just migrated to a new sql server with SQL Server 2005 installed (we moved from 2000).

We are experiencing two issues that we cannot resolve:

1. The site and database clients that use this SQL Server run very slow now. We have noticed that the lsass.exe process consistantly uses 25% CPU, +/- 10%. When we stop SQL server the lsass.exe process goes down to 0. What can be causing this? The website uses a SQL user account, not a windows user account.

2. We have an error in the event log that might be related to the issue above. It appears every few minutes:

Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/25/2006
Time: 11:54:42 AM
User: NT AUTHORITY\SYSTEM
Computer: MSDB
Description:
Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]

The error log from SQL gives more info:

Error: 18456, Severity: 14, State: 16.

What is causing this? How can this be traced?

I am stuck here. All help greatly appreciated.

Moshe

I'm not sure about the lsass.exe process, but here is a good blog from the SQL Protocols team about the failure error messages.

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Thanks,
Sam Lester (MSFT)

|||

I have seen that blog, but it did not help me. I will post there anyway though.

Please advise, this is a serious issue.

|||

I may also add that I have not yet ungraded to Service Pack 1. Are their any known issues related to this that were fixed with Service Pack 1? I would only upgrade now if you were confident that upgrading would fix the issue since the server is now deployed.

|||People, including me, have also seen high CPU usage by lsass.exe when signing into Windows Live Messenger (and possibly earlier versions of Messenger).|||I have the same problem, everytime that I open messenger live the cpu goes high, lsass.exe take all my cpu...

have you find something to fix the problem?

regards,|||I reformatted the machine that resolved the issue. Microsoft PSS was not helpful in this and could not uncover the cause of the issue. Sad