dazza007

I will have a look in the morning, makes sense I am getting tunnel vision!! We are having meltdown and the boss is away and muggings is the only one onsite knows about SIMS. I have been adding the timeout line to clients as they are getting kicked out of SIMS with the database timeout error - and we have 100 users. We are managed by the local council and have no capita report.. To resolve the users being kicked out of sims as it is slow I was adviced to detach and reattach the database. I tried disabling the tcpip pipes in sims and restarting the sql in services for the connections to take effect. however I got error messages, the sql would not start with the tcp ip pipes disabled... So in trying to detach the database and reattach the database using dbattach would not work unless the sql was online. We do have a script to stop access to the database however this is used when upgrading the sims but this method causes issues. How can I kick people off the database - we have connect.ini installed locally in c:\program files\SIMS\SIMS .net\connect.ini My disclaimer is the setup is not my work......... So if I detach and reattach the database this would "clean up" the sql - according to our support. I was also advised to limit the sql to 4gb as it is capitas recommendation - we have the full SQLSERVER version....

If you can track down the procedure that is being run...... I have been trying to do this but as we have had 101 things to do it is difficult to follow. When I sort the processes by task state no one individual keeps popping up.. I have restarted the server and am not seeing large CPU requests (but that may not mean anything)

Thanks for that, I am getting to grips with SQL manager - slowly. That is a good resource. We keep getting a recent expensive query - and insert into command consuming significant amounts of CPU and users are reporting issues accessing and performing simple tasks in SIMS. I had to restart the SIMS server at lunchtime today and the problem has seemed to disappear. Is anyone aware of this issue.

Any ideas on how to locate users who are running large reports?

I have been using activity monitor in the SQL admin studio on our SIMS server to find the most expensive queries. There has been virtually 100% cpu on the SIMS server, with 10 times the CPU resources going to this insert command being performed. My mate tells me I can run a trace to find out the process code but it is all above me. Is there a way of determining which user is causing high cpu load on our server.... Cheers, Darren

Hi I have installed Schoolcomms 8.1 with SCCM and now we are having to update the software. On a test rig I have uninstalled the previous install v8.1 using msiexec /x and uninstalled the new version using msiexec. Uninstallation of the prior version is essential for the new version to work when using SCCM 2012 can I deploy the new software with the msiexec /x ininstallation for the previous version of the software before installation of the newer version? confused on Friday.com Cheers, D

Works a treat If you host the script in c:\windows\setups\scripts and use a script to invoke the powershell file. You will need to enable permissions to allow ps1 files to run in the unattend.xml RunAsynchronousCommand. :)

After a war of attrition I am coming up with a solution here I used unattend.xml to name the computer then I have manually tried this PS script: $domain = "myDomain" $password = "myPassword!" | ConvertTo-SecureString -asPlainText -Force $username = "$domain\myUserAccount" $credential = New-Object System.Management.Automation.PSCredential($username,$password) Add-Computer -DomainName $domain -Credential $credential Now it is just putting A+B together ....

I am trying to get an image onto our network. For testing I am deploying our system using MDT and sysprepping. Then using unattend to get the computer onto the network manually entering a computer name. The problem is that the computer is joining the domain and then the renaming is breaking the trust relationship with the domain controller. When I log on with a domain admin account I get the trust relationship between the computer and the domain message. Is it possible to get a the Win 7 computer onto the domain after assigning the computername? Is the best method to use a wildcard for a computername, so that it joins the domain, then rename and rejoin the domain with a script? en-GB en-GB en-US en-GB en-GB true Work 1 ********************* false Local User LOCAL administrator administrators adminstrator GMT Standard Time Schoolname registeredowner false KMS KEY REGISTERED ORGANISATION REGISTERED OWNER false GMT Standard Time domain.name domainadmin ***** domain.name cmd /c net user administrator /active:yes 1

As I understand the computer can be given a name by removing the line in the unattend.xml however the computer does not join the domain. I can join the domain manually so there are no trust issues. On the flip side I can enter * as a computername which randomises the computername and the computer joins the domain....How can I do both?

We are having the laptops imaged offsite supplying a wim and unattend.xml to the manufacturer.

I have been reading many many threads on using Windows SIM and unattend to join a domain and manually enter a username after applying a wim to our new laptops. Something to do with factory imaging.... Having tested out the unattend.xml I can get the computer onto the domain but with a randomly generated computername. I have left the attribute blank in the xml and deleted the line in the xml that specifies the computername attribute. The former gives me a random computername on the domain and the second does not process the unattend.xml and I have to enter everything manually. Can an unattend.xml allow a user to type in a computername and then join a domain automatically. I was coming to the conclusion that the computer joins the domain with a random name and then admins rename the computer. Thanks for any direction... will post a xml up in the morning. Cheers, D

Hi I have a intel gigabit network adapter (on motherboard) that is exhibiting some strange behaviour and not loading. From a cold boot the adapter does not load returns "driver cannot load code 10 error" The drivers load on a warm reboot and the computer connects to the network. We have lots of machines with this network adapter in and they are working fine.When the device fails I have pinged 127.0.0.1 and it works but pinging the switch returns PING: General failure. The device is not getting a IP address (even APIPA). The switch is opening up the port fine. I updated the latest drivers from intel and same issue occurs. We have had this issue occur more than once and engineers have replaced the motherboard. Totally confused Dazza