SMS 2.0 SP4 HRP Problems 1

[jdyer]

I was wondering if anyone has experienced the same problem I am currently. I have recently installed the Hotfix Rollup Package (HRP) on my SMS Site Server. I was initially having an issue with the SMS_COLLECTION_EVALUATOR giving me hundreds of 620 errors. I finally found the article on how to fix that problem. If anyone is having that same problem, please feel free to ask.

1.)Now, I can create a collection, insert clients into the collection within the properties page, but when I finish creating the collection and refresh all collections, the clients do not populate within the collection I just created. Did you follow that? When I click on the collection I have created, the clients that I inserted into the collection are not there, but if you go to the properties of that collection and go to the "Membership Rules" tab all of the clients are there.

If that makes no sense, please ask so I can elaborate.

2.)Also if anyone knows how to use the Feature Pack with SMS, I am in dire need of learning how to push out security patches and updates to clients on my network. I have the Feature Pack installed, but I do not know how to use it.

I'll buy whoever helps me a beer of their choice!

Jeff

 

[mbagshaw]

In answer to your first question. I also have this problem. I have found that if you wait for SMS to update the collection, then the PC's are there. I often change the Update Schedule to 1 minute so that the update occurs in a minute. The PC's are then there and I change the Update Schedule back.

 

[jdyer]

That worked. Thanks! If I come across any other solution for this issue I'll post it for you.

By the way, do you know how to change the handle for an accont in this forum? I want to change mine.

 

[jdyer]

Nevermind, I figured it out.

 

[sambusa]

Yah pls Jdyer i am facing the problem regarding the 620 error,
i have search in internet there is article... lead us to ignor this problem ?

Explain to us pls .

Thanks in advance

 

[jdyer]

First of all, do you have your SQL Server on the same server as your Site Server or are they on separate servers? IF they are on separate servers, you will have to copy the isql.exe executable from your SQl Server and paste it to the c:\winnt\system32 directory of your Site Server. After doing this, reinstall your HRP. This time it should be able to execute the isql.exe file.

If this still doesn't work try this:
Go to where you installed your HRP and find the update.sql file under the i386 directory. Open the .sql file with notepad and find the following:

IF exists (SELECT Name
FROM sysobjects
WHERE Name = 'sp_DecrementCollChangeCount'
AND type= 'P')
DROP PROCEDURE sp_DecrementCollChangeCount
go

and change it to:

IF exists (SELECT name
FROM sysobjects
WHERE name = 'sp_DecrementCollChangeCount'
AND type= 'P')
DROP PROCEDURE sp_DecrementCollChangeCount
go

The difference is the case of Name to name. SQL Server 2000 is case sensitive. Copy this whole update.sql statement and open up your SQL Query Analyzer. Paste the statement and run it against your sms site database.

After doing this I was looking ok. Let me know if you have any questions before trying this. I don't want you making a mistake due to misunderstanding.

 

[sambusa]

Sir :
i have the sql server 7.0 in same machine which hold the sms .
What i have to do ?
Then there isno risk if itry this in my invironment ?

Thanks alot brother

 

[jdyer]

If you have SQL Server 7.0 and SMS on the same server, it may be separate issue from the one I had, but you can try following the instructions I gave you before on running the update.sql statement against your sms database through query analyzer.

 

[sambusa]

Thanks for ur fast response, i will try it asap then reply to u asap


with my best wishes