Reg BCS Entity
Hi Team,
I have created one BCS Entity and provided permissions after that i have created a list for that external list. I need to add a hyperlink to perticular column in the External list, That should be provide in readlist method only. Please provide the solution.
Regards,
Bharat.v
SCCM 2012 - Clients fail to pull policy assignment from secondary site
Here is my scenario:
1 primary site
16 secondary sites
Boundaries configured for each secondary site with site assignment to secondary site and secondary site as distribution point.
With this configuration I find that ccmexec.log shows client is restarting every time I launch software center and software center closes when the client restarts.
In order to get it to stay open I have to delete a registry key (HKLM\Software\Microsoft\SMS\Mobile Client\"ProductVersion"="5.00.7711.0000".
I am able to get it to stay open by doing this however it does not show the package I have deployed.
I have checked Primary Site server logs and do see the policy created for the device and the offer for the device. Yet the client does not receive the policy.
If I reconfigure the boundaries to point at the Primary site then the client does get the policy and all works as it should. This would mean though that the client is not interacting with the secondary site and I might as well be using distribution points. Also note if I point at the primary site I do not need to delete the reg key in order for the sms agent service to stay started.
What I have determined is that the secondary site is not getting the policy for the client and when the client request the policy from a secondary site it is restarting the sms agent service.
So I am stuck.. any help would be appreciated..
- Edited by Tod_Elliott Saturday, July 21, 2012 4:51 PM mispelling
Reply:
Client can't be assigned to any secondary site.
See, http://technet.microsoft.com/en-us/library/gg682060.aspx
Anoop C Nair - @anoopmannur :: MY Site: www.AnoopCNair.com :: FaceBook: ConfigMgr(SCCM) Page :: Linkedin: Linkedin<
------------------------------------
Reply:
Thx for your reply,
I do realize that it can not be "Assigned" to a secondary site however if you look at the boundary groups it gives you an option to use a secondary site as assigned, if you look at sccm 2007 you will see that the boundary for a secondary site is assigned the secondary site code( you can not change this), this doesnt mean the client is assigned to the the secondary site code it means it uses it as a proxy management point. It wouldnt matter if the client was assigned to the primary site or secondary site as the secondary is a proxy management point.
But your missing the point to my issue.
My issue is that my clients do not get a policy assigment through the proxy management point.
Only when I point the boundary to the priamary site and exclude the secondary site from the boundary do my clients get the assigment.
Tod Elliott
------------------------------------
Reply:
Tod Elliott
------------------------------------
WCF Oracle Polling in BizTalk 2010-View Interlinked with Different Database
BizTalk Polling WCF oracle database views using super user account. All views working expect one. I was getting error "Cannot open connection". Initially I was thinking to do somthng with properties like receive timeouts.., but the same were working good for rest of the views.
I started looking into view shared by oracle team and got to know that the view is calling completly different database table using DBlink. I can see @ in the table details, which says that the view is connecting to different database table to get details.
If i execute the tables in sql plus, I am getting query result, with the same logins in BizTalk port and sql plus.
Here comes the queries, BizTalk WCF custom adapter with oracle bindings support this?
- Changed type LeoTang Monday, July 30, 2012 12:26 AM
Reply:
Is UseAmbientTransaction set to true? If so could you try at set it to false and confirm if you still get the same error?
Morten la Cour
------------------------------------
SMO and WMI to change SQL Service Account Credentials
I am trying to write a powershell script that will whut down SQL Server, change the Service Account Credentials, and restart the service and have been working for this for about 2 days now so I think I need some help.
Here is the script I am using (Everything works fine for stopping/starting the services) and I added the 1 line to SetServiceAccount that it keeps failing on
#Load the assembly containing the objects used in this example
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlWmiManagement")
#Declare Variables
$SQLServiceAccount = 'DOMAIN\username'
$SQLServiceAccountPassword = 'XXXXXXX'
#Get a managed computer instance
$mc = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer
#List out all sql server instnces running on this mc
foreach ($Item in $mc.Services){$Item.Name}
#Get the default sql server datbase engine service
$svc = $mc.Services["MSSQLSERVER"]
# for stopping and starting services PowerShell must run as administrator
#Stop this service
$svc.Stop()
$svc.Refresh()
while ($svc.ServiceState -ne "Stopped")
{
$svc.Refresh()
$svc.ServiceState
}
"Service" + $svc.Name + " is now stopped"
#change service account credentials
$svc.SetServiceAccount($SQLServiceAccount,$SQLServiceAccountPassword)
"Starting " + $svc.Name
$svc.Start()
$svc.Refresh()
while ($svc.ServiceState -ne "Running")
{
$svc.Refresh()
$svc.ServiceState
}
$svc.ServiceState
"Service" + $svc.Name + "is now started"
Below is the error I keep getting and when I look up SetServiceAccount it does take 2 parameters. I am running PowerShell as administrator
Running
Running
Running
Stopped
ServiceMSSQLSERVER is now stopped
ERROR: Exception calling "SetServiceAccount" with "2" argument(s): "Set service account failed. "
ChangeServiceAccountCredentials_1.ps1 (39): ERROR: At Line: 39 char: 23
ERROR: + $svc.SetServiceAccount <<<< ($SQLServiceAccount,$SQLServiceAccountPassword)
ERROR: + CategoryInfo : NotSpecified: (:) [], MethodInvocationException
ERROR: + FullyQualifiedErrorId : DotNetMethodException
ERROR:
Starting MSSQLSERVER
Stopped
Stopped
Stopped
Stopped
Running
Running
ServiceMSSQLSERVERis now started
>> Execution time: 00:01:14
>> Script Ended
Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz
- Edited by Chad ChurchwellMicrosoft employee Wednesday, July 18, 2012 8:16 PM spelling
Reply:
Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz
------------------------------------
Reply:
1. Make sure to run the PSConsole as Administrator.
2. You may need to make sure WMI properly working on the box (WMI is not blocked by the firewall or maybe there's something turn off)
3. In the username, make sure to include you machine or domain name.
4. Notice the result value should equal 0 for successful change (if you get a 2 then it failed)
5. Of course, confirm the changes have been applied in the Services control panel.
Here's my results:
PS C:\Users\Administrator> Get-Service *sql*
Status Name DisplayName
------ ---- -----------
Running MSSQL$SQLEXPRESS SQL Server (SQLEXPRESS)
Stopped MSSQLFDLauncher SQL Full-text Filter Daemon Launche...
Running MSSQLSERVER SQL Server (MSSQLSERVER)
Stopped MSSQLServerADHe... SQL Active Directory Helper Service
Start... MSSQLServerOLAP... SQL Server Analysis Services (MSSQL...
Stopped SQLAgent$SQLEXP... SQL Server Agent (SQLEXPRESS)
Stopped SQLBrowser SQL Server Browser
Stopped SQLSERVERAGENT SQL Server Agent (MSSQLSERVER)
Running SQLWriter SQL Server VSS Writer
PS C:\Users\Administrator> $svc = Get-WmiObject Win32_Service -Filter 'Name="MSSQL$SQLEXPRESS"'
PS C:\Users\Administrator> $svc.Change($null,$null,$null,$null,$null,$null,"BIZTALK2K10DEV\myservice",'$3rv1c3')
__GENUS : 2
__CLASS : __PARAMETERS
__SUPERCLASS :
__DYNASTY : __PARAMETERS
__RELPATH :
__PROPERTY_COUNT : 1
__DERIVATION : {}
__SERVER :
__NAMESPACE :
__PATH :
ReturnValue : 0
PSComputerName :
PS C:\Users\Administrator> $svc2 = Get-WmiObject Win32_Service -Filter 'Name="MSSQLSERVER"'
PS C:\Users\Administrator> $svc2.Change($null,$null,$null,$null,$null,$null,"BIZTALK2K10DEV\myservice",'$3rv1c3')
__GENUS : 2
__CLASS : __PARAMETERS
__SUPERCLASS :
__DYNASTY : __PARAMETERS
__RELPATH :
__PROPERTY_COUNT : 1
__DERIVATION : {}
__SERVER :
__NAMESPACE :
__PATH :
ReturnValue : 0
PSComputerName :
I hope this help somehow.
Thanks, Max Trinidad Microsoft MVP - PowerShell Florida PowerShell User Group: http://www.flpsug.com/ Blog: http://www.maxtblog.com/ Old Blog: http://maxt2posh.wordpress.com/ Follow me on Twitter: @MaxTrinidad Member of: CITGA, UGSS, INETA and PASS.
------------------------------------
Reply:
I dont know it is a problem with your code, but have you tried to change the password account, see if it is not blocked..etc
We can make a try to see if it is some problem with SMO, try to change this way
$Srv = gwmi win32_service -filter "name='MSSQLSERVER'"
$Srv.StopService()
$Srv.Change($null,$null,$null,$null,$null,$null,'Domain\account','PAssword',$null)
$Srv.Startservice()
if it works, then we can guess it's something with the SMO. If not works, then probably the problem it is other..maybe with the account/password
- Edited by Laerte Junior Friday, July 20, 2012 2:42 PM
------------------------------------
Reply:
I understand there are other ways to do what I am trying to do, but as a SQL DBA I am wanting to try to build a set of standard scripts related to SQL using SMO and these exanples are using just WMI, which of course is an alternative, but is there a known bug with SMO that anyone is aware of as my script syntactically looks correct
Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz
------------------------------------
Reply:
I have both SQL Server 2008 r2 and SQL Server 2012 in my VM and I dont had any problems with your SMO code
- Edited by Laerte Junior Friday, July 20, 2012 7:07 PM
------------------------------------
Reply:
If your code work in other machines, this indicates that something is preventing it to work. Compare your firewall, UAC setting and maybe a feature against your machine where this script works. Again, something is missing. I normally leave everything open on my machine just for demo purpose.
I'm in the middle of preparing and reconfiguring some of my VM's and I will try to replicate this condition later.
:)
Thanks, Max Trinidad Microsoft MVP - PowerShell Florida PowerShell User Group: http://www.flpsug.com/ Blog: http://www.maxtblog.com/ Old Blog: http://maxt2posh.wordpress.com/ Follow me on Twitter: @MaxTrinidad Member of: CITGA, UGSS, INETA and PASS.
------------------------------------
Reply:
Hey Chad,
I look carefully at your script you have something nice going on when you have multiple instances. I suggest using "Type" of Service in the SMO Microsoft.SqlServer.SqlWmiManagement instead of the instance name.
Do a $mc.Services to list all properties and you'll see there's a property named "Type" containing the value "SqlServer". I think using the service type will give you a better result. Then, you can use a foreach, and don't want to worry about a particular instance name.
I will try to replicate the problem in a few more hours.
:)
Thanks, Max Trinidad Microsoft MVP - PowerShell Florida PowerShell User Group: http://www.flpsug.com/ Blog: http://www.maxtblog.com/ Old Blog: http://maxt2posh.wordpress.com/ Follow me on Twitter: @MaxTrinidad Member of: CITGA, UGSS, INETA and PASS.
------------------------------------
Reply:
I was able to replicate the failure in Windows 7 with SQL Server: 2008 Express, 2008 R2, and 2012.
It was all about running the PS Console "As an Administrator". See code snippet below:
#Load the assembly containing the objects used in this example
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlWmiManagement")
#Get a managed computer instance
$mc = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer
$mc.Services | Where{$_.Type -eq 'SqlServer'} | Select name, serviceaccount | ft -autosize
#change service account credentials
$svc = $mc.Services["MSSQLSERVER"]
$svc.SetServiceAccount(".\MyService",'my$3rv1c3')
Also, there's no need to change to an older version of the SMO assembly. By the way I even had the UAC set to default.
:)
Thanks, Max Trinidad Microsoft MVP - PowerShell Florida PowerShell User Group: http://www.flpsug.com/ Blog: http://www.maxtblog.com/ Old Blog: http://maxt2posh.wordpress.com/ Follow me on Twitter: @MaxTrinidad Member of: CITGA, UGSS, INETA and PASS.
- Edited by MaxTrinidad Sunday, July 22, 2012 1:28 PM
------------------------------------
Please Participate: Your Recommended Exam Resources
Having recently resumed Microsoft certifications after a break of several years, I'm curious to know what exams people are taking, and what resources you're finding useful. This information can prove valuable to all of us, so please participate. Thanks.
1. What current (not retired) Microsoft exams have you taken or are taking?
2. What resources have you used or are using (e.g., books, practice tests, video training, etc.)
3. Of these resources, which ones would you recommend?
Thank you all for your participation.
Reply:
OK then, I'll get the ball rolling. Just resumed 70-680 prep, and here are my resources.
Current exam: 70-680 (Windows 7, Configuring)
Books: MS Press MCTS Self-Paced Training Kit (Exam 70-680)
Don Poulton MCTS 70-680 Cert Guide: Microsoft Windows 7, Configuring
MS Press MCTS 70-680 Rapid Review: Configuring Windows 7
Video Training: CBT Nuggets 70-680 Training
Practice Tests: SelfTest Software 70-680 Practice Test
Online Resources: Microsoft TechNet
Recommended: I recommend all of them, with possible exception of MS Press 70-680 book.
- Edited by James JT Taylor Sunday, July 22, 2012 12:33 PM
------------------------------------
sharepoint restore site
i create back up from a sharepointe site and restor.
the first site is Multi-Language.
error is :the resource object with key 'currentLanguage' was not found.
what can i do for resolving problem?
Reply:
- On your SharePoint Web-Front-End Server navigate to 'C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\CONFIG\Resources'
- Copy needed resource files (.resx).
- Navigate to the IIS Virtual Directory of your SharePoint web site
- Copy resource files into the Virtual Directory's App_GlobalResources folder
- Perform an IISRESET
- Refresh your page.
------------------------------------
Reply:
Hi,
Did you restore it in the same server or different server because I think key 'currentLanguage' belong to physical resource file so you have to also copy the resource file from backup server to /14/resources folder .
Regards,
Fadi Abdulwahab, SharePoint Consultant
http://blogs.msdn.com/b/fabdulwahab
http://sqlgoogler.blogspot.com/
------------------------------------
Reply:
Hi
Restore it in the different server ,I just have a sp back up.
Physical resource ?What resource do you mean?
------------------------------------
Reply:
Hi,
Check these two places in the source server if there any custom resource files belong to your site and move these files to destination server
1- On your SharePoint Web-Front-End Server navigate to 'C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\Resources'
2-Or navigate to the IIS Virtual Directory of your SharePoint web site Copy resource files into the Virtual Directory's App_GlobalResources folder
Regards,
Fadi Abdulwahab, SharePoint Consultant
http://blogs.msdn.com/b/fabdulwahab
http://sqlgoogler.blogspot.com/
------------------------------------
Getting connected to office 2010
Reply:
- Merged by Max Meng Monday, July 23, 2012 6:01 AM
------------------------------------
Reply:
http://office.microsoft.com/en-us/word-help/activate-office-2010-programs-HA010354227.aspx#_Toc272916427
Don
------------------------------------
Reply:
http://office.microsoft.com/en-us/word-help/activate-office-2010-programs-HA010354227.aspx#_Toc272916427
Don
------------------------------------
Not recieving the alert e-mail on document library
After subscribing the alert, a initial e-mail is received, but the subsequent emails are not received like document addition and deletion
its to a single user not receving the susbsequent alert e-mail for the document library for rest user its working fine.
Reply:
silly question but have you checked that this user has an email address populated in his user profile ?
------------------------------------
Reply:
Its not the silly question, read my question carefully.
If that was the case then the user must have not received the Initial alert mail.
------------------------------------
New to SQL
Reply:
Welcome to this forum, paddy_sql. If you have beginner questions unrelated to T-SQL, post those to Getting Started with SQL Server forum (http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted).
Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
------------------------------------
Reply:
Welcome to the T-SQL Forum!
Just a reminder, for quick assistance the more information you give the better.
Happy & productive foruming!
Kalman Toth SQL SERVER 2012 & BI TRAINING
- Edited by Kalman Toth Saturday, July 21, 2012 3:16 PM
------------------------------------
Run Profiles
All,
In support we do discuss the topic of run profiles quite a bit. So i have compiled a wiki to kind of centralize the information, as well as add to it.
REFERENCE: Run Profiles: http://social.technet.microsoft.com/wiki/contents/articles/12529.reference-run-profiles.aspx
Additionally, I put together a wiki on automating run profiles using the script button.
REFERENCE: How to automate run profiles via the script button: http://social.technet.microsoft.com/wiki/contents/articles/12528.reference-how-to-automate-run-profiles-via-the-script-button.aspx
Tim Macaulay Security Identity Support Team Support Escalation Engineer
Reply:
Tim - I would appreciate it if you would look at Event Broker yourself (link below) to understand our vision of how easy it can (and should) be to intuitively manage all run profile execution, together with pre/post processing, in a single web console, and do so in a non-preemptive manner to achieve near real time provisioning and sync. I understand that while many will want to take the scripting option, the more the sync config grows the more cumbersome this approach becomes, and the more unsatisfactory the result. While this is a commercial product designed to enhance both FIM and ILM/MIIS before it, what I want people to understand the philosophy behind the approach, and that it is time we stopped settling for the substandard.
I should also mention that FIM continues to lose business to Oracle/Novell/IBM/etc. simply because it cannot tick the "event driven" checkbox on the feature list ... and this should no longer be the case, but will continue to be while there continues to be this lack of awareness which I am trying to address with posts like this.
Thanks for your interest.
Bob Bradley (FIMBob @ TheFIMTeam.com) ... now using Event Broker 3.0 for just-in-time delivery of FIM 2010 policy via the sync engine, and continuous compliance for FIM
------------------------------------
DFS and mapped drives
I've recently had an issue with intermittent drive mappings not working to DFS shares, after chasing down what it wasn't, I was able to pin it down to what it was.
I'm posting this in case anyone else has these issues as well.
Problem:
I had complaints from some clients at one site that some of their drive mappings were not showing up. Server 2008 R2 domain. Looking into the problem, I saw that the problem was with both XP SP3 and 7 SP1 clients. I noticed that the server\share drives mapped without fail every time, but the DFS shares were hit and miss, but a client either got all DFS mappings or none. All methods were affected GP Pref, logon script, ADUC home drive mapping.
Solution:
After completing a 2003R2 to 2008R2 domain change, I noticed the last server DC1 migrated was missing the root structures in the registry key: HKEY_LOCAL_MACHINE\Software\Microsoft\Dfs\Roots\DomainV2
The other servers migrated first and second DC2 and DC3 had the root structures under the aforementioned key. I also noticed that my DFS structure was still in 2000 mode. Instead of creating the reg keys, I decided to follow "Migrate a Domain-based Namespace to Windows Server 2008 Mode" from http://technet.microsoft.com/en-us/library/cc753875.aspx knowing that I would be recreating all my DFS root structures in the V2 format anyway.
Recreating the DFS roots proved to be problematic, as removing them from the DFS GUI seem to work until I tried to recreate them. I received a "\\<var>domain</var>\<var>root</var>\<var>folder</var>: Properties cannot be set on the folder. The request is not supported" error. Trying to remove them through the cmd prompt resulted in an error that they didn't exist.
Looking in ADUC under system -> DFS, I find the roots are still there. I remove them, and restart the two DFS services. Now I could create my V2 roots, and import the config that I had backed up in step 1 of the aforementioned technet article.
Now all three servers have the appropriate registry keys under HKEY_LOCAL_MACHINE\Software\Microsoft\Dfs\Roots\DomainV2, and the drive mappings are all working.
In regards to the intermittent mappings, I'm sure it was seen on some clients but not others due to my over-riding the referral ordering. I did this due to latency in copying large files. Five people in one department with their home drive targeting the same DFS share get assigned to DC2 and DC3. Another person in that department gets assigned to DC1, and copies a 2 GB file to it. IT gets a call when the rest of the department cannot see the file. (until it replicates) By over-riding referral ordering, and setting 1 server priority to a DFS folder, all users of that folder get the same server. But in the case of DC1 missing the reg key listing the DFS root structures (yes they showed in the DFS GUI), anyone with that had DC1 as the preference would not map to the DFS share.
Funny thing is, there were no errors I could find on the affected clients or in the DFS logs on the servers.
Brad
- Edited by brhodgins Wednesday, July 18, 2012 8:28 PM
- Changed type MedicalSMicrosoft contingent staff Thursday, August 9, 2012 3:47 AM sharing
Reply:
TechNet Subscriber Support in forum |If you have any feedback on our support, please contact tnmff@microsoft.com.
------------------------------------
windows 7 update
Reply:
I'd ask them here.
http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_update
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.
------------------------------------
nothing displaying under channel, subscriber & subscription in SCOM
Hi All,
Suddenly nothing is displayed under channel, subscriber & subscription part in SCOM. Kindly help me.
Regards,
Sandy
- Changed type Nicholas Li Monday, August 6, 2012 9:24 AM
Reply:
Sandy,
Is notification working? When you say nothing is displayed, what do you mean? Were there subscriptions set up before and now they are not there? What is the state of your ops db? Is SQL healthy? What do you see in the ops manager RMS event log?
Did you try /clearcache switch when launching the console?
Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/
------------------------------------
Reply:
Hi Blake,
It was working fine before, recently we resetted the SDK & Config password after that nothing is dislayed under channel, subscriber & subscription part.
But we edited the password under SDK & config service but nothing is there.
CUrrently alerts triggering, web console and all other stuffs are working, except this.
------------------------------------
Reply:
Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/
- Edited by Blake Mengotto Friday, July 20, 2012 5:41 PM
------------------------------------
Reply:
Hi Blake,
I changed the password in Database too. But there is no error or warning in Event log in RMS.
Do i need to check any specific Event log.
Regards,
Sandy.
------------------------------------
Reply:
Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/
------------------------------------
Reply:
Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/
------------------------------------
Reply:
------------------------------------
Reply:
Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/
------------------------------------
Reply:
------------------------------------
Reply:
So nothing in the Event logs on the RMS. You have the notification MP. You cannot create new notifications.
Not being able to create new notifications is a big issue and something you probably need to call PSS about.
Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/
------------------------------------
Infopath validation
Hello,
I have an infopath 2007 form.
How do I prevent users from saving the form when there are validation errors? I am not using the submit option. Right now, users can save the form even though there are errors.
Thanks,
T
Reply:
The Out Of The Box error detecting function can only work with the submit button. If you want to stop users from saving when some fields are not filled in, you may want to:
- Disable the save button from the toolbar
- Define your own save buttons
- Within this save button, user rules to check mandatory fields
Please remember to Propose As Answer if this solves your problem
- Edited by Jason Li - Canada Friday, July 20, 2012 5:16 PM
------------------------------------
How to upgrade from Failover Clustered SQL Server 2005 to 2008 R2 and Windows Server 2008 to 2008 R2?
We have two active-active SQL server 2005 instance running on windows server 2008. Both are enterprise (SQL and Windows) Editions. We have a plan to upgrade both SQL Server 2005 to 2008 R2 and Windows server 2008 to 2008 R2.
Please Let me know what is the sequence for completing the migration process.
1. upgrade first SQL 2005 or Windows Server 2008
2. provide me a useful link to find out some screenshot for reference
- Edited by karthik selvam sivasamy Tuesday, July 17, 2012 6:59 AM
Reply:
Hello,
Please follow the instructions provided on the following article for an in-place migration of the cluster:
http://technet.microsoft.com/en-us/library/ff182312(WS.10).aspx
Then upgrade the SQL Server failover cluster instance:
http://msdn.microsoft.com/en-us/library/ms191295(v=sql.105).aspx
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
------------------------------------
Reply:
Thanks for the info Alberto.
but i want to know, which one I'll upgrade first sql server 2008 R2 first or Windows server 2008 R2?
First upgrade sql server 2008 R2 and then upgrade windows 2008 R2 or reverse the process.
which will take least priory, downtime and complexity.
------------------------------------
Reply:
Hello,
I would upgrade the operating system first. The order I posted the links above is based on that approach.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
------------------------------------
MS did wrong bundling FEP to SCCM
Hi
Where is the admistrative advantage integrating FEP into SCCM ? Many companies decided to use third party products instead of the administrative monster called SCCM. It's too complex for most of the infrastructures smaller and mid-sized companies have and it's a real good idea to tell my business partners "Sure we can offer you a complete AV solution even from Microsoft but you have to hire an additional administrator to take care of your new system and btw. you have to buy another product just to manage the AV system".
SCCM does not fit most of our and our customers needs and many other third-party products do better and are much easier to handle. SCE lacks some features but it's not like SCCM what we in GErmany would call a "eierlegende Wollmichsau" (word4word: egg-giving-wool-milk-pig :) ) So this was a real breakthrough providing smaller companies with a basic tool to manage their environments.
Where is the logic building FEP into SCCM and not giving SCE the needed features to provide a reliant base installation for FEP ?
Many guys like SCCM, I'm obviously not part of them. But cutting customers freedom to decide what they want to use in their infrastructure to manage systems if they want to use FEP is the wrong way.
Many of our customers already use powerful tools and won't switch to SCCM as they didn't in the past. We already build FCS infrastructures there and have to offer them AV products from other vendors instead of FEP because it's easier to implement a new AV solution than a new systemmanagement and deployment infrastructure.
FCS was not the best CS solution but it was relativly small and integrated best into MS based infrastructures. FEP seemed to be a real step forward but the requirements are to high becasue MS did two steps back at customer satisfaction.
So why is there no "SCCM free" version of FEP for the customers who don't like SCCM ? Maybe missing some features but I could live with that. Deploying the agents is not the problem, just give as a good dashboard and the toold we need to isolate infected PCs. Don't tell us "you will need SCCM", AD and Windows offering a quite good set of tools to take care of them, when the FEP client does the rest on the machine everything is fine. Fiddling with Symantec, TrendMicro, Sophos, McAfee at various customers is a pain and a powerful and (!) easy to use MS integrated solution would be great. But with the current requirements I would have a bad feeling recommending FEP :(
Greetings from Germany
Andreas
Reply:
I agree. It is a shame.
I am thinking I will stick with McAfee ASAP. It is not the best for Zero Day attacks, but it is easy to install and manage.
It seems every new product coming out is forced to integrate into SCCM. I like the idea of being able to manage it all in one place, but for smaller companies - it just seems overkill and unnecessarily complicated and expensive. Smaller being 1-10 server and 1-50 workstations - small!
------------------------------------
Reply:
Absolutely failed on requirement of SCCM for Forefront Endpoint.
We have been looking forward to Endpoint security to be released for a long time. The Forefront Client management is so out of date requiring a standalone SCOM2005 server. Our expectation was that we would use our SCOM2007R2 server to manage Forefront Enpoint clients. We have no need for SCCM, absolutley stupid that SCCM is required to install another product when SCOM is already present for ongoing management. We deploy desktop via images and will never need or use SCCM ever. This imaging method is a supported and documented Microsoft procedure. Did no one in Forefront team ever think they would have customer actually using their deployment procedures without SCCM? Or did some marketing tool think was a good way to boost sales of slow moving SCCM product?
Unless MS wake up and remove the requiement for SCCM we will have no choice but to switch to another AntiVirus vendor next time we do a desktop refresh since our ForeFront Client has no upgrade path as of right now. EPIC FAIL MICROSOFT!
If you want your customers to switch to another vendor just say so! no need to for all this SCCM nonsense.
------------------------------------
Reply:
I don't believe that SCCM is a requirement for FEP. By the looks of this article about configuring FEP Policies it looks like you can administer FEP using SCCM or SCOM...but maybe I'm reading it wrong...
FYI, it seems pretty simple to administer FEP using SCCM, built-in reporting, built-in policy templates for exclusions, plus automatic detection and policy application to any SCCM clients on your network running FEP...
Cheers,
Zach
"FEP gives you a choice of two ways to manage policy. First, if you have ConfigMgr deployed and the FEP 2010 product installed, then you can use the FEP node in the ConfigMgr console to author policies. ConfigMgr (via its Software Distribution feature) will deploy the policies for you to the monitored FEP agents. However, if you prefer, or if you do not have ConfigMgr deployed (such as when you are only using the OpsMgr MP), you can use Group Policy to author and distribute policy."
------------------------------------
Reply:
FYI, there is nothing 'simple' about needing a product you don't have and don't want the overhead of using. Not to mention there is nothing 'simple' about the expense of licesing the product. Always the elephant in the room when dicussing the abilities and 'simplicity' of MS products.
But thanks for the heads up on the technet blog about using GPO. Pity the product itself makes no clear mention of it, it seem the marketing folks have had too much input again.
Cheers.
------------------------------------
Reply:
I don't believe that SCCM is a requirement for FEP. By the looks of this article about configuring FEP Policies it looks like you can administer FEP using SCCM or SCOM...but maybe I'm reading it wrong...
FYI, it seems pretty simple to administer FEP using SCCM, built-in reporting, built-in policy templates for exclusions, plus automatic detection and policy application to any SCCM clients on your network running FEP...
Cheers,
Zach
"FEP gives you a choice of two ways to manage policy. First, if you have ConfigMgr deployed and the FEP 2010 product installed, then you can use the FEP node in the ConfigMgr console to author policies. ConfigMgr (via its Software Distribution feature) will deploy the policies for you to the monitored FEP agents. However, if you prefer, or if you do not have ConfigMgr deployed (such as when you are only using the OpsMgr MP), you can use Group Policy to author and distribute policy."
Zach,
SCCM IS a requirement! You need SQL also, but that can be the "light" version that comes with the installer. And oh yeah, lets ditch WSUS as well and use SCCM for that!!!
I can see the advantages of updating via SCCM, but only for new environments, not for organisations that already have WSUS in place.....
Just my 2cents....
Steven
------------------------------------
Reply:
Agree
I'm in the process of deployng FEP on 3k+ wks and the SCCM part was a nightmare.
------------------------------------
Reply:
I am generally very forgiving of Microsoft, as their products and tools have done me well over time. However, I have never been so frustrated with a product than I am with this one. Who ever made the decision to bundle this with SCCM needs to be fired immediately. To delay the launch of the product for as long as they did for the explicit reason to bundle it with SCCM, and to essentially shut out most small businesses was a joke. I have spent more time trying to get this product to install correctly than I did getting an entire Lync deployment running.
I will literally gen 5 new machines - all identical, clean installs from Win7 media, and 3 will get the client, 2 won't. 1 might fail, 1 might get listed as "Not Targeted" - there doesn't seem to be any ryhme or reason to what is going on. I constantly find my self creating new collections and new advertisements just to target machines that might have failed.
I am counting down the days to tech ed so I can confront the product team directly, and talk to every AV competitor on the floor, as I am now ready to remove this product permanently.
Bob
------------------------------------
Reply:
Microsoft have been doing this for 30 years now. Its about time they stopped the corporate culture of making excuses for buggy, flakey, poorly designed software and started to deliver quality like so many of their competitors do. Obviously, the monopoly mentality has a lot to do with all this too, I don't know how they'll overcome the corporate arrogance that engenders. Oh, and the self-delusional marketing hype they've fallen victim too in recent years.
I have managed to install the forefront endpoint client without management just to see how it works. Imagine my surprise that it still tries to download updates for the Forefront client product which was uninstalled prior to endpoint client being installed. I don't know if this is a fault in forefront client not uninstalling properly or a bug in endpoint client. I just know this is typical of the kind of poor design we have all come to expect from Microsoft.
I now have updates for a non-installed product downloading and failing every day. Epic fail microsoft.
YES, I'll be talking to every AV competitor too. Microsoft AV has no future in our network as it stands.
------------------------------------
Reply:
------------------------------------
Reply:
At the end of the day, FEP was designed based upon the SCCM and SCOM platforms. Consequently, there is an assumption that in order to run FEP, you must be running one of these platforms to fully utilise FEP as it was designed to be used. Running FEP without SCCM or SCOM is going to be technically possible (as with a lot of products) but without the management infrastructure in place, you will lose the ability to manage and report across all your clients and understand what is really happening from a malware protection standpoint. When looking at antivirus solutions, this "lack of visibility" is a big deal in order to understand the current security status of clients and the security exposure of your network. For example, without SCCM/SCOM in place you will not be able to:
- See the current status of updates across all FEP clients; which are up to date and which are failing to update etc.
- See the current status of infected machines, number of malware incidents, cleaning results etc.
- Initiate remote actions on clients like quick/full scan now, update now etc.
- Provide SMTP alerts on malware detection and outbreaks
- Run reports to assess malware status, update deployment health etc.
- Compare endpoint security compliance against a required baseline
Given that when FEP is deployed in standalone mode without the System Center management components you lose all of the AV management features in the bulleted items listed above, this is too much of a compromise to me. I would rather customers use an alternative product rather than use FEP at all in this scenario. Just having the endpoint running a good malware engine/client is only part of the overall solution and achieving this at the expense of management/reporting is just too much of a sacrifice in my opinion.
I would agree that not providing integration with SCE was probably a big mistake, as many SMB customers will not be using full product versions of SCCM/SCOM and are not likely to be able to do so; FEP is clearly aimed at the Enterprise market. For this reason, SMB customers who come to me who are unwilling (or cannot afford) to run SCCM/SCOM will be recommended to use another antivirus product that does not requires these product prerequisites. Do I feel bad about this? No, because ultimately I know that FEP was not really designed for their type of environment (at this time); FEP was designed to unify security and management by using a single management platform to achieve desktop security from a "single pane of glass" product. This is a big deal for Enterprise customers who have already invested a lot of money in a solutions (like SCCM) to manage their desktops, who do not want to deploy a completely new infrastructure just to extend client management to also include antivirus/malware protection. Using a single management product and "bolting on" malware protection makes total sense for these guys...
The fact that existing customers who have FCS (which doesn't have the same platform prerequisites) will be left without an upgrade path is a bitter pill to swallow and I have the upmost sympathy, BUT this doesn't mean you should compromise your FEP deployment to try and emulate FCS.
So, for the time being, I will be keeping our existing AV partnership and recommending that SMB customers (or those not using SCCM/SCOM) use this product as opposed to FEP. For enterprise customers (or SMBs that are running/willing to run SCCM/SCOM) I will be recommending FEP. I am ever hopeful that MS will add support to SCE, but until then I think my approach is both realistic and likely to provide a fully functioning solution for respective customers, which is the most important thing to me as a hired consultant. I also have my eye on the FEP managed service being brought to market by TrueSec (hi Johan!) as this product fills the current "SMB gap" very nicely :)
Windows Intune (the SMB cloud offering) is the likely better option for SMBs looking for client management and malware protection, but as this currently does not support servers. Consequently, this is it not an ideal solution either as it is not an all encompassing malware protection solution to include both clients and server...this may change as Intune matures no doubt...
Cheers
JJ
Jason Jones | Forefront MVP | Silversands Ltd | My Blogs: http://blog.msedge.org.uk and http://blog.msfirewall.org.uk
------------------------------------
Reply:
System Center Endpoint Protection 2012 (previously Forefront Endpoint Protection 2010) can be licensed via resellers like CDW.com as standalone installs for $8-$12/user or device/year depending on quantity and other purchases (min 5 licenses required for volume licensing - not all licenses have to be SCEP2012).
There is no server or central reporting or management in this scenario. You don't need System Center Configuration Manager, etc. SCEP2012 installs and works and looks exactly like Security Essentials except that it can be installed on Windows Server 2008 R2 (Standard - Datacenter) and Vista/Win7 (32bit or 64bit). I have not tried to install it on SBS or Essentials, but I hear they are not yet supported. I don't believe XP is supported either.
The SCEP2012 installer is on the SCCM2012 image, which can be obtained by downloading the SCCM2012 Trial. Open the EXE with 7Zip and look for the \SMSSETUP\CLIENT\SCEPInstall.exe file, which is around 17-18MB. That is all you need to run to install the standalone SCEP2012 client.
Note: Standalone licensing appears to be honor system, so you could try it out before purchasing. There is no activation or cdkey or anything. Details with links and steps to purchase, dload, and install are here with confirmation from a Microsoft Security Engineer about licensing:
/* Don Reynolds */
------------------------------------
Reply:
Hi Don,
Thanks for updating this thread. I read the other forum thread you had started and I'm still a little puzzled with SCEP2012 and licensing with Windows servers.
I wanted to confirm that what you are stating is that SCEP2012 can be installed on servers just as you could on workstations. Is the license cost the same for both workstations and servers? So if I bought the CDW SKU's as you noted, I should be able to install on either workstation and servers?
Thanks for the information and any clarification you can provide.
------------------------------------
Reply:
As long as they show up in your VLSC web account under License Summary.
I confirmed SCEP2012 works for XP, Vista/Win7, and Windows Server 2008 R2 Standard/Enterprise/Datacenter.
You must use Device Licenses for server OS, but you can use either for client OS.
/* Don Reynolds */
------------------------------------
File System Object from a remote URL
I have a client who has multiple websites, and wants to be able to access image folders using FSO from a different URL. Is this possible?
Example:
PropImages folder exists on www.stratusinternational.com
They want to be able to select an image on www.pinosovillas.com which updates the Db [MySQL - shared by all 32 of their domains] Image selection copies the image filename to the Property Editor.
Unfortunately both sites are hosted on different servers [same hosting company]
I use FSO on the main site [Stratus International] to do this, but that means at the moment we have to grant access to the admin section to all 32 users to make changes there. They'd prefer changes are made on the respective sites.
As the PropImages folder is 32Gb in size, and updated regularly, we don't want to replicate across all domains.
Hope I have given enough info to make sense!!
Any help appreciated
Glen
Reply:
FSO cannot access web sites. (URLs) FSO can use only UNC paths and legacy drive paths.
Your FSO runs on teh web server so it is using a local path that is likely mapped via teh web site code. Web code can look at its own URL and discover the path to the file. You could pass this back th ethe user but that would make all local paths visiable to everyone.
I recommend creating a web based file manager to manage file or use FTP. Most ISPs do provide web based file managers which the web admin can control.
This is not really a scripting question. Yu should be asking it in the IIS developer forum.
You might also look into using POwerShell with the Net WebClient class as it can upload files to a web server.
Generally web based file managers or FTP are what is used.
¯\_(ツ)_/¯
------------------------------------
Reply:
Thank you.
Yep, it seems I am going to have to just force them to use the one domain [where the files reside] to access the files, as all other suggestions I have had seem to have issues as well. All we want is to be able to select the filename from, a visual thumbnail list. FTP and file managers could leave the system open to 'user' error.
I did spend ages trying to figure out which forum/thread to use, and decided on this one as a previous FSO question had been asked in it!
Regards
Glen
Glen - glen@getonline.es - 0034 966 187 230
------------------------------------
Reply:
We write websites all of the time that upload files to custom repositories. I do not see where the user error comes in.
Of course since you are not a WIndows technician I can see where modifying the website might be a problem.
Uploading and downloading files and controlling the users experience is what web sites are all about. Look at all of the photography and video sites. They don't have issues do they? We can quickly build sites that let us upload almost anything.
The issue has always been security but HTPS is now reliable and, as long as we manage the Mime Types, there should not be an issue of security.
The other possibility is to build a simple web service that takes a file object and save it to the correct location or retrieves it from the correct location.
When we have multiple web sites that use them same images of files teh files are usually stored on a central system and accessed via a web service. FTP over SSL is also a good way to gain remote access to files
.
¯\_(ツ)_/¯
------------------------------------
Reply:
We're not looking to upload or download - merely select which image is shown at the top of the list. If I wanted to do more than that, then I would spend the time doing something more in line with your suggestions.
Of course since you are not a WIndows technician I can see where modifying the website might be a problem. - you assume too much.
Uploading and downloading files and controlling the users experience is what web sites are all about. Look at all of the photography and video sites. They don't have issues do they? We can quickly build sites that let us upload almost anything. This isn't what we want or what the question was about.
Regards
Glen
Glen - glen@getonline.es - 0034 966 187 230
------------------------------------
Reply:
How can a file system control what image is shown on the top of a page?
How can FSO update a MySQL database.
Your question and explanation fail to make any sense.
¯\_(ツ)_/¯
------------------------------------
Reply:
Perhaps not clear enough at the start: The editor page fires a popup which lists the images as thumbnails. When the Admin clicks the image, the filename is returned to the image field on the the parent editor form which when updated writes the data to the Db. All that works perfectly on the domain where the images are.
I wanted to be able to do that from another domain [to the first domain's image folder] - that was the question. Yes, I could call Domain 1's page in an iFrame and solve the issue on domain 2, 3, 4 etc. but I was looking to see if there was a better way.
Regards
Glen
Glen - glen@getonline.es - 0034 966 187 230
------------------------------------
Reply:
Just create a web service that, when given an image name(url) it will translate it to a location and send back the location. I don;t se what the problem is. It has nothing to do with FSo but to do with getting back teh path from teh server that is storing the image.
A web page can be caled with a query sring that contains the url to teh image. The web page is located on teh server wher ethe images are stored and where the url is pointed.
Use the GetPathFromURL function to return the physical path.
Alternately move the whole database updaye to a page that can be called with aa query string. The page convert the uRL and updates the database al in one step. All of your logic is already there just move it to a separate page and call it in the background. SOAP would be the easiest waty to do and most useful nut a simple HTTP query string would owrk
http:\\targetserver.dom.com\SendToMySql.aspx?url=www.server.com/path/path/image1.jpg
Now grab the url on the home server and translate to the file path and save in database, (of course you will need to encode the url string. THe page processign the url should be relative to teh image storage in some way so you can use Mappath. I would hope the database has the storage locations as a url but if not then just build location awareness into the page however you have it set now.
¯\_(ツ)_/¯
------------------------------------
SBS 2003 Rules for interface with Seagate NAS 110 Black Armor
Hello,
Can someone help me with configuration of rules with SBS 2003 server? I had a Seagate Black Armor NAS 110 which failed, so i had to do a RMA and swap out. After doing so each time my LAN network would do updates (on work stations) I have to remap all of the drives over on each and every work station.
Obviously this has become unbearable, and I am sure its because of swapping out the drive. Can't view event logs nada, all data has been successfully mirgrated over to new drive. This is the only issue I am having, if someone can walk me through the process it would be deeply appreciated.
We are a non-profit (Discoveries oh Hope Foundation) that works for Autism Speaks, and this is becoming a liability to say the least.
Thanks,
Herman007
- Changed type LeoTangModerator Friday, July 20, 2012 10:32 AM
Reply:
Hi,
As this is a SBS server related issue, it is recommended that open a thread at Small Business Server forum:
http://social.technet.microsoft.com/Forums/en-US/smallbusinessserver
The engineers and community members there have more experience can help you in a more efficient way. Thanks for understanding!
Leo Tang [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
------------------------------------
Reply:
Leo,
Thank you very much i will direct my questioned pointedly in that direction. TRhank you for your help.
Herman007
Herman Regusters
------------------------------------
How to set up a subordinate folder for sharing when the parent folder needs to remain private in a Win 7 64 bit network (3 computers)
Reply:
I think you have a mixture of advanced sharing and public folder
sharing. If you set Pubic folder sharing to yes and don't do anything
else you only share the Public folders and nothing else.
If you use advanced sharing, you should turn off public folder sharing.
In your description it seems, that somebody shared either the "Users"
folder or even the root of your drive. Even with this set to share, no
user should be able to access the folders of another user, except for
administrators, which have access to everything by default - as not
only the sharing settings but also the security settings are honoured
by the OS in granting access to a resource.
So I'd first check the Users folder and the root of your Windows drive
for sharing settings and remove them, if you don't need them.
Wolfgang
------------------------------------
Reply:
------------------------------------
distribution list in outlook 2007
dear all,
I delete a user from a distribution list in outlook 2007.
(I use outlookanywhere, so the distribution list is located on Exchange server
But when I send the email to this distribution list. this deteled user always can receive my email.
why?
thank you
john
Reply:
Could be replication or the user may not have been removed. Can you check via the EMC/ADUC depending on what version of Exch you're using.
Others things may be that their is a forward setup/transport rule/another nested DL etc...
Sukh
------------------------------------
No comments:
Post a Comment