Backup-Recovery and Internet Based Client forums are live
The messages on these topics have been moved from 'General' to these forums.
Reply:
These two new forums were not accepting posts, we have corrected the internet forum , but have not been able to recover the 'pending' posts yet. Please try re-posting to the internet forum.
------------------------------------
MOSS Lists vs SQL Tables
We are designing a solution (MOSS website + a lot of services) and have two options to store the information, the first is to save them in a custom list under moss, and the second option is to save them in reqular tables in SQL server.
with moss list we can use the search in moss, and the add edit delete options, but what about the performance?
Reply:
If you have lists that exceed this, I'd make sure I had some filtered views defined which returned fewer results
------------------------------------
Reply:
------------------------------------
PLEASE READ BEFORE POSTING A QUESTION: Hardware & Drivers FAQ - 5600
Hardware Compatibility and Drivers 5600
Q: Why doesn't my <insert hardware device> function properly? It worked without issues in XP.
A: Most of the causes of hardware (sound cards, keyboards, etc.) not properly working is because of drivers. Either the driver is incompatible or missing from the system. In these cases, checking the manufacturer's website for the latest drivers can solve your issue. The Windows Update site also regularly pushes out updated drivers for various devices.
Q: Why do I have to install the drivers for my Legacy AC97 audio device, where it was built-in for Windows XP?
A: All Legacy Audio devices must be downloaded from Windows Update, or from the vendor's website. We have removed all Legacy Audio built-in driver support from Vista in its entirety.
Q: There used to be Creative drivers available on Windows Update, why can't I see them anymore?
A: All Creative drivers were brought down because these drivers were the Windows XP WDM drivers. We have seen many issues that these drivers cause on Vista, therefore we have brought them down from Windows Update. We want to insure the highest quality drivers on Windows Update.
Q: Are MIDI/Gameports supported under Vista?
A: We've removed support for these types of devices, in favor of USB connected devices.
Q: Is my <insert hardware device> compatible with Vista?
A: One of the caveats of participating in a beta program is that you're never really sure if your device will properly install and function. Some drivers will either be incompatible or missing. As we get closer to the final beta and the eventual RTM, devices should begin to be listed on our Hardware Compatibility website.
Q: Why isn't a driver for my device included in the current build of Windows Vista, although it was present in a previous build?
A: A vendor may remove their drivers from the build for various reasons, your best bet for help on this is to ask fellow testers and Microsoft staff for assistance in the private Longhorn newsgroups. Also, please be sure to file a bug report on hardware that doesn't install.
Q: Why does my Creative SB Audigy have poor performance and eventually stops working altogether?
A: This is most-likely a driver compatibility issue. Along with checking the Windows Update site you can check Updated list of Creative drivers compatible with Vista.
Q: Is SLI supported?
A: At this time there are no SLI drivers available for Windows Vista, we expect to have these available by RTM.
Q: Why is my Marvell Yukon driver still not working?
A: This is a known issue and is still under investigation as it was thought to be fixed in the previous build. It will continue to be investigated until it is fixed.Reply:
A: One of the caveats of participating in a beta program is that you're never really sure if your device will properly install and function. Some drivers will either be incompatible or missing. As we get closer to the final beta and the eventual RTM, devices should begin to be listed on our Hardware Compatibility website."
This post seems to be a bit out of date, since Vista is now out of beta.
------------------------------------
Reply:
------------------------------------
Reply:
It`s rather SILLY of microsoft to disable the gameport, it`s putting alot of my friends off buying vista in the first place, they are music producers, have the gameport use for MIDI devices, synths etc..................
Personally i went out to buy a USB Midi cable from a well known auction site and Vista doesnt even support that. :(
------------------------------------
Reply:
------------------------------------
Reply:
SAME OL YADA YADA YADA! AT THE ROLL-OUT EVENT, YOUR MILLIONAIRE STAFE TOUTED HOW MUCH "PRE-RELEASE" EFFORT WAS SPENT ON VISTA! WELL.....Y O U O B V I O U S L Y DIDN'T SPEND ENOUGH TIME WITH HARDWARE VENDORS. I WONDER IF A P P L E HAS THE SAME PROBLEM WITH THEIR NEW SYSTEMS.........I W O U L D B E T ONE MONTH OF Y O U R SALARY THAT THEY DON'T!
WHY SHOULD I RECOMMEND TO MY CUSTOMERS TO SPEND 200+ ON A MB, 200 + ON MEMORY, 200+ ON A AN ATI AIW, YADA YADA YADA!
I COULD SPEND 45 BUCKS ON MSI OR ONE OF SEVERAL OTHER MBS AND THEIR WOULDN'T BE THIS PROBLEM!
I THINK BILL NEEDS TO TAKE A 10000 MILE TRIP TO NORTH IDAHO AND VISIT ME!
------------------------------------
Reply:
I installed windows vista and do not have sound , windows vista will not get to reconize my
sound system ,with xp was no problem but this new system of vista is not that good
please help me.
manny2bs
------------------------------------
Reply:
i'm sure it's the same reason motherboard makers are building their mbs without more than one pci slot.
it's all about MONEY!
you can make a one-piece mb in china for cents and charge everyone that wants to build a real puter hundreds.
do you think ms or creative or any hardware vender really give a rats *** about us; we are only .00001% of their market!
here we are, for some stupid reason, trying to build "real computers" for REAL people and all we get is their half-*** os and driver support!
WHAT DO WE THE OEM'S GET FOR: wasting billions of OUR F R E E...HOURS ...on THEIR betas?
....ONLY A KICK IN THE *** AND.... YADA YADA YADA YADA YADA!
HERE WE ARE ON THE FRONT LINES, ANSWERING A GAZILLION QUESTIONS FROM PEOPLE THAT DON'T EVEN BUY FROM US; BECAUSE THEIR 10 CENT "BOX STORE" puter does not work!
maybe we would be better off back living in caves.
it's like everything else, the whales are eating all the small fish. amd/ati.....and the like. the oem or inventor or innovator is a dying breed.
i wanted to know why ati would not come out with video capture software for THEIR "few hundred dollar" aiw in vista. sure, the graphics and sound driver are there butts that's it.
maybe ms only wants us to use media player rather than ati, roxio or real player.
oh......if we only had a UNION!
maybe its time for another anti-trust class action!
all in wonder has been my bread and butter since they first began.
ms and ati's aiw software has allways been a pain in the ***...and to ati's credit, it was getting better.....that is until Vista came out!
in closing....I WOULD NOT HOLD YOUR BREATH WAITING FOR ANY OF THE CON GLOM IRATES to get back to YOUR pidly-*** PROBLEM...for they have
way too much money to make!
hope this helps.....glen....kb7bth@hotmail.com
------------------------------------
Reply:
| tantank wrote: | |
|
No, AMD/ATI and Nvidia will create those drivers though... Nvidia's SLI support has started for Vista (x86 & x64) but I am sure its not as mature as its XP counterpart, so be prepared for a major performance decrease between XP and vista on the same hardware. I have a geforce 7950gt and it performs about 10-15% lower FPS in vista as opposed to XP. This should be expected though you would have seen the same decrease moving from win98 to win2k back in the day. The only difference is the hardware you ran '98 on was much easier to migrate to 2k than xp to vista (from my experience).
------------------------------------
Reply:
| kb7bth wrote: | |
|
Bill needs to take his Vista and go jump in a lake!
------------------------------------
Reply:
| kb7bth wrote: | |
|
/signed
/Amen!
------------------------------------
Reply:
yo dude...are you an oem?
it's interesting that ati/amd or is it amd/ati and ms and gigabyte and nvid are teaming up again...like they have done before, to offer specials for certain products.
i used to curse apple for being so anti-oem, butt after dealing for so many years with the ms sh** that i am seriously thinking about "going apple". ps...don't try to sell the idea to apple......i've already created a "poor-mans" pattent for that idea.
g
------------------------------------
Reply:
andre' : is it your "full time ms job to reply to our questions?
thanks..g
------------------------------------
Reply:
| kb7bth wrote: | |
|
Yes, I own a retail store and build PC's for End Users. In addition, I have worked on "Poor Man Mac's" from the mid '90's era (Power Computing, Radius, APS Technologies, DayStar Digital, UMAX you name it we've had it on a bench at some point) those Mac Clones are nightmares.. Don't worry about me I want nothing to do with Apple or spec'n out Apple clones. There is nothing wrong with PC hardware technology, the problem lies in the Mainstream choice of operating system, and the control it allows the OS creator to have over the hardware market...Windows Devs should look at what's out there and be coding to work with it, not making hardware vendors design around its limitations and blocking other OS's from being allowed access to drivers and 3rd party apps.. (if you want your drivers digitally signed you can't open source them...) This is what happens when bad (greedy) people gain control over good technology...
------------------------------------
Reply:
i forgot to add the "lol" after the ps.
anyway, i understand why very few puter builders will reply to my posts. i'm sure ms monitors all the traffic and "black balls" anyone "o contrair" to the party line.
g
------------------------------------
Reply:
------------------------------------
Reply:
| Andre Rivera - MSFT wrote: | |
|
It's July 2007 now. When will SLI drivers be available for Windows Vista? Do you have an estimate?
I'm wanting to buy a dual-graphics card system that is DirectX 10 compatible. Since only Vista supports DirectX 10.... that means I need SLI drivers for Vista. Checking at www.alienware.com they say that SLI drivers are not yet available for Vista. Where else should I be looking to see when the drivers will be available?
Thanks,
Bolas
------------------------------------
Reply:
It seems that Microsoft have taken out all support for MIDI in Vista, except the very basic interface needed for any soundcard to work. Neither gameport nor USB devices work, and all the support services, applets and interfaces have been disabled or removed. The only sound support in Vista is for playing commercial DVDs. Says a lot, doesn't it!
I shall be advising my customers to buy Apples.
------------------------------------
Reply:
>> "We've removed support for these types of devices, in favor of USB connected devices"
Wrong. USB devices are not supported either. There is no device support for MIDI in Vista.
------------------------------------
Reply:
well kids...same ol bla,bla,bla,bla,bla. its all about money. ms sends us to the maker, the maker sends us to ms and the cycle continues. what they don't tell ya is that they all own each other and in order to make the max profit, they send to their partners for the "other" stuff you need to get your customers toy to work.
ati for their all in wonder products send you to their "partners" so you can spend another 90 bucks for software that should be included, as it used to be, with the product they sell.
maybe with the dems in control of the house and senate, we should get them to regulate the makers of this krap, so they will be "REQUIRED" to furnish software to MAKE it work!
hummmmmmmmm
------------------------------------
Reply:
kb7bth: Read the posting BEFORE pasting in your usual witter. There is NO support for MIDI in Vista; Microsoft is NOT passing you over to the manufacturers, they can't do anything about it. You are NOT being sent round any cycle, just dropped in the cesspit.
Oh, and we in the UK don't give a bleep about your funny little system of government over there in the ex-colonies, nor your laughable 'constitution'. If you want to play at pretending it matters, take your toys somewhere else.
------------------------------------
Reply:
Will I be able to use my MIdI usb to midi in / out from my keyboard on a new PC with Vista as an operating system?
I use my keyboard as do thousands of other people with an audio mixing programme. It is very creative and fun.
Should I opt for Vista or get the latest IMAC. I find it hard to believe that musical devices will not be able to be connected to Windows.
------------------------------------
Analysis Services best practise checker available
We at U2U, a training and consultancy company, created a tool which checks an Analysis Services 2005 server against nearly 30 of the published best practises. The tool reports the violated best practises, renders these in a report and allows you to export them to xml or csv format. For more information and a download of the currently free tool, go to http://www.u2u.be/res/SQL05_ASBPA.aspx.
Reply:
Interesting... how does it compare to the official SQL2005 Best Practices Analyzer (http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en) which now works with Analysis Services too?
------------------------------------
Reply:
Interesting list of best practices, Waldorf. Looks like there is some overlap with the Microsoft Best Practices Analyzer.
Since we're linking to best practices, there are a few regarding aggregations coded into BIDS Helper:
http://www.codeplex.com/bidshelper/Wiki/View.aspx?title=Validate%20Aggregations&referringTitle=Home
------------------------------------
usb safely remove
IIS IWA will not pass user credentials if there is a (.) in the web address
We have an intranet website running reporting services and we are using Integrated Windows Authentication.
Everything was working fine until we created a new DNS name for our website. In the past we just used the server name such as: http://server1/reports
But, now we wanted to use a more routable internet name such as: http://www.mycompany.com/reports
The problem was that we were operating in an intranet environment and relying on automatic login credentials using IIS and IWA. So, when the users typed in the new address: http://www.mycompany.com/reports they would be prompted for their domain username and password.
As it turns out this is by design in Internet Explorer. If there is a "dot" in the domain name then it assumes you are on the "Internet" (not an "Intranet") and will not pass the user credentials. When we used just the machine name of the report server there wasn't a "dot" in the name hence credentials were passed perfectly.
The solution:
Your network admin needs to create a login script that adds http://www.mycompany.com to the Local Intranet Zone in Internet Explorer. (That can also be done manually but you would have to visit each pc in your office and add the setting)
I hope this helps someone.
Vista Software Protection Platform (SPP)
Hello,
On September 6, 2006 Microsoft has released a new feature in windows Vista called Software Protection Platform (SPP)
Software Protection Platform (SPP), is a new built-in feature in windows vista that detects if your windows copy is genuine or non-genuine. if your copy is non-genuine SPP will going to reduce your windows functionality and disable all windows features.
in reduced functionality mode you will only able to run Internet Explorer
the picture is a screenshot for a non-genuine windows copy after reduced funcationality by SPP
Reply:
Is there a solution? Anything I can do to get back to where it was before? Maybe back to windows xp?
------------------------------------
Reply:
| JaysonCee wrote: | |
|
Your only solution is to activate this copy with a geniune windows copy with a legal serial number
------------------------------------
Reply:
How do I get one of those?
------------------------------------
Reply:
hello,
you can buy your license from any license distributor or any computer shop,
http://www.microsoft.com/windows/products/windowsvista/buyorupgrade/default.mspx
------------------------------------
IIS IWA performance tip to speed up reports and authentication
We were having some performance issues with our reports when we came accross a TechNet article explaining how IIS 6 will authenticate each request no matter if the user has already been previously authenticated. (such as how IIS 5 performs).
http://blogs.technet.com/industry_insiders/articles/407751.aspx
Our servers are inside of an intranet so there is not much concern over session stealing or other security issues prevelant on the Internet. (obviously security is always a concern but we need performance more than security at this point)
So, the solution to speed up the user authentication process for NTLM Integrated Windows Authentication (IWA) in IIS 6 is as follows:
Change to the \inetpub\adminscripts folder and run each of the following commands:
1. cscript adsutil.vbs SET w3svc/1/NTAuthenticationProviders "NTLM"
2. cscript adsutil.vbs SET w3svc/1/AuthPersistSingleRequest FALSE
The "1" in both the above commands will cause the property to be set on the Default Web Site. Change "1" to affect another web site or remove "1/" from the command to affect the entire server.
Once the two commands have been executed enter the following to ensure that they have run correctly:
1. cscript adsutil.vbs GET w3svc/1/NTAuthenticationProviders
2. cscript adsutil.vbs GET w3svc/1/AuthPersistSingleRequest
Finally run IISRESET from the command line to restart the web server.
This change will drastically reduce the number of authentication attempts (401.1,401.2,etc.).
Before this change, more than half the hits recorded in our web logs were 401.x authentication entries (almost 50,000 per day).
The web pages are much faster now and almost appear to "pop" onto the screen now that each individual graphic element does not need to be authenticated.
I hope this helps someone else as it did for us.
Copying / Moving Data from SQL2005 to SQL2000
Hi
I have a (possibly) common position where half of our IT department is SQL 2005 and the rest is SQL2000. For myself, having to work in a SQL2000 environment and needing data from a SQL2005 Cluster I came up with this solution.
Also, to alert me when the process starts and completes since it is part of a scheduled process, I have it do a RAISERROR with logging to record entry and exit times. In addition, this runs out a series of PRINT statements that lets the operator know what table is currently being worked on.
Of course, any suggestions for speeding this up would be helpful!
What I have found that works for getting data (albeit slow) from SQL 2005 down to SQL 2000 is to script a fairly simple copy process -
-- it is actually pretty easy to follow if you just read the code......
-- first, we find all the views which are present, so they can be ignored when copying the raw data
CREATE TABLE #VIEWS (TABLE_NAME NVARCHAR (255) )
INSERT #VIEWS
SELECT TABLE_NAME FROM
OPENDATASOURCE(
'SQLOLEDB',
Data Source=SQL2005server;User ID=trust_me;Password=i_know_what_i_am_doing' )
.SQL_SIS_SYSTEM.INFORMATION_SCHEMA.VIEWS
-- now, we get the actual tables with data
CREATE TABLE #TEMP (TBL_SCHEMA VARCHAR (12), TBL_NAME VARCHAR (255), RECCNT INT )
INSERT #TEMP
SELECT TABLE_SCHEMA , TABLE_NAME FROM
OPENDATASOURCE( 'SQLOLEDB', 'Data Source=SQL2005server;User ID=trust_me;Password=i_know_what_i_am_doing' )
.SQL_SIS_SYSTEM.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_NAME NOT IN (SELECT TABLE_NAME FROM #VIEWS)
-- then, we start copying tables over - now we tag the ones which are populated with at least 1 row.
-- the first cursor loop gets all table names, the second will find row counts of source tables.
-- this segment uses (ugh) cursor to loop through and gather all of the data. This cursor is at the table name level - not
-- processing anything, and is used only to find tables which have a rowcount > 0
-- believe it or not, the cursors run pretty darn quickly since they arnet doing any calculations - just finding
-- tables with row counts > 0
SET @QUOT = CHAR(39)
SET @LBRAKT = '['
SET @RBRAKT = ']'
SET @IUT = 'IsUserTable'
SET @ODBC_CMD ='(' + @QUOT + 'SQLOLEDB' + @QUOT + ',' + @QUOT + 'Data Source=SQL2005server;User ID=trust_me;Password=i_know_what_i_am_doing' + @QUOT +
').SQL_SIS_SYSTEM.dbo.'
PRINT 'BEGIN TABLE SCHEMA LOAD CURSOR. ' + CAST(GETDATE() AS VARCHAR (50) )
DECLARE GETEM CURSOR FOR
SELECT TBL_SCHEMA, TBL_NAME FROM #TEMP
OPEN GETEM
FETCH NEXT FROM GETEM INTO @TBL_SCHEMA, @TBL_NAME
WHILE @@FETCH_STATUS = 0
BEGIN
SET @SQL = 'UPDATE #TEMP SET RECCNT = ' +
'(SELECT COUNT(*) FROM OPENDATASOURCE(' +
@QUOT + 'SQLOLEDB'+ @QUOT + ',' + @QUOT +''Data Source=SQL2005server;User ID=trust_me;Password=i_know_what_i_am_doing' + @QUOT +
').SQL_SIS_SYSTEM.' + @TBL_SCHEMA + '.' + @TBL_NAME +')' +
' WHERE TBL_NAME = ' + @QUOT + @TBL_NAME + @QUOT
EXEC (@SQL)
FETCH NEXT FROM GETEM INTO @TBL_SCHEMA, @TBL_NAME
END
CLOSE GETEM
DEALLOCATE GETEM
PRINT 'FINIS TABLE SCHEMA LOAD CURSOR. ' + CAST(GETDATE() AS VARCHAR (50) )
DECLARE @PLIN VARCHAR (80),@LFT_PLIN VARCHAR (20),
@RT_PLIN VARCHAR (20), @TLIN INT
PRINT 'BEGIN TABLE CHECK AND LOAD CURSOR.'
DECLARE FETCHIT CURSOR FOR
SELECT TBL_NAME, RECCNT FROM #TEMP WHERE RECCNT > 0
OPEN FETCHIT
FETCH NEXT FROM FETCHIT INTO @TBL_NAME, @RECCNT
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'CHECKING ' + @LBRAKT+ @TBL_NAME + @RBRAKT
IF NOT EXISTS (SELECT * FROM dbo.sysobjects
WHERE id = object_id
(@LBRAKT+ @TBL_NAME + @RBRAKT )
AND OBJECTPROPERTY(id,''+@IUT) = 1)
BEGIN
SET @LFT_PLIN = 'OBJECT' + SPACE(5)
SET @RT_PLIN = SPACE(5) + 'NOT FOUND. BUILD ' +
CAST(@RECCNT AS VARCHAR (6) ) + ' rowS.'
SET @PLIN = @LFT_PLIN + @LBRAKT+ @TBL_NAME + @RBRAKT
SET @TLIN = LEN(@PLIN)
SET @PLIN = @PLIN + SPACE(50 - @TLIN) + @RT_PLIN
PRINT 'ENTRY. ' + CAST(GETDATE() AS VARCHAR (50) )
PRINT @PLIN
PRINT 'COPYING DATABASE TABLE.'
SET @SQL = ' SELECT * INTO ' + @TBL_NAME +
' FROM OPENDATASOURCE' + @ODBC_CMD + @TBL_NAME
EXEC (@SQL)
PRINT 'COMPLETED. ' + CAST(GETDATE() AS VARCHAR (50) )
END
IF EXISTS (SELECT * FROM dbo.sysobjects
WHERE id = object_id
(@LBRAKT+ @TBL_NAME + @RBRAKT )
AND OBJECTPROPERTY(id,''+@IUT) = 1)
-- #TEMP (RECCNT) CONTAINS ROW COUNT OF SOURCE SYSTEM.
-- COMPARE TO ROW COUNT OF LOCAL TABLE
BEGIN
SELECT @DEST_RECCNT = RECCNT FROM #TEMP
WHERE TBL_NAME = @TBL_NAME
IF @DEST_RECCNT = @RECCNT
BEGIN
PRINT 'TABLE row COUNT MATCHES. BYPASSING REBUILD.'
END
IF @DEST_RECCNT <> @RECCNT
BEGIN
SET @SQL = 'DROP TABLE ' + @TBL_NAME
EXEC (@SQL)
SET @LFT_PLIN = 'OBJECT' + SPACE(5)
SET @RT_PLIN = SPACE(5) + 'REBUILD.' +
CAST(@RECCNT AS VARCHAR (6) ) + ' rowS.'
SET @PLIN = @LFT_PLIN + @LBRAKT+ @TBL_NAME + @RBRAKT
SET @TLIN = LEN(@PLIN)
SET @PLIN = @PLIN + SPACE(50 - @TLIN) + @RT_PLIN
PRINT 'ENTRY. ' + CAST(GETDATE() AS VARCHAR (50) )
PRINT @PLIN
PRINT 'COPYING DATABASE TABLE.'
SET @SQL = ' SELECT * INTO ' + @TBL_NAME +
' FROM OPENDATASOURCE' + @ODBC_CMD + @TBL_NAME
EXEC (@SQL)
PRINT 'COMPLETED. ' + CAST(GETDATE() AS VARCHAR (50) )
END
END
FETCH NEXT FROM FETCHIT INTO @TBL_NAME, @RECCNT
END
CLOSE FETCHIT
DEALLOCATE FETCHIT
PRINT 'FINIS TABLE CHECK AND LOAD CURSOR.'
XIT:
RAISERROR (50002,010,1) WITH LOG -- FLAG COMPLETION TIME IN SQL LOG
SET QUOTED_IDENTIFIER OFF
Reply:
Using Microsoft SQL Server Database Publishing Wizard 1.1, you can copy/move data from 2005 to 2000.
Follow the link to download :
Microsoft SQL Server Database Publishing Wizard 1.1
Thanks
Naras
------------------------------------
Steadystate, WDP, and and Optiplex 745
I am having trouble getting SS to work properly on our new machines for our libraries. I can install SS fine on an Optiplex 745 and as long as I leave it alone, it is fine. However, as soon as I turn on WDP, the system reboots, goes to the Windows splash screen for a second and then to a black screen and hangs. Upon rebooting, I get a BSOD saying there is a problem with the hard drive and to remove any newly installed HD controllers and drivers and then run chkdsk /f
I then have to reboot and choose "last known good configuration". This lets me back into the system but WDP is now turned off. Looking at the event viewer I see a message saying that the WSS hung on starting. If I try to turn WDP back on it does the sme thing over again. If I run CHKDSK it finds no errors. I have tried all of your tests for turning off all services and startup options except for WSS and the problem persists.
The problem only shows up when I turn on WDP. If I have the default settings for WSS turned on and WDP turned off the system runs fine. I have WSS and WDP turned on and working on all of my Optiplex GX270s and Optiplex GX260s. I have not tested my GX280s and GX620s. However, I have tried 10 GX745s, 5 were imaged and 5 were fresh installs from Dell CDs and every one of them has failed as soon as I reboot after turning WDP on.
This problem does not exist if I use SCT. WDP works perfectly with that software. Also I have noticed I can create a 5 - 10 GB freespace which SCT uses fine ( I could probably go less) with WDP. The file created by WSS is 40GB. Why is this cache file so huge? And is there anything I can do for my GX745s or should I just go back to SCT until all of these bugs are taken care of?
One more note - I have noticed that all of the GX745s have 40GB cache files while the GX260s and GX270s only have a 4.58GB cache file.
Reply:
Hi Tjohnson,
First of all, as WDP is sensitive to the hard drive problems, please also defrag the hard drive and make sure drive C is not compressed. (Open "My Computer", right click drive C and then choose Properties. In the General tab, make sure the "Compress drive to save disk space" option is unchecked.)
Meanwhile, you can disable Automatically Restart to collect crash dump file
------------------------
1. Click Start, right-click My Computer and then choose Properties.
2. Choose the Advanced tab.
3. Click on the Settings button in the "Startup and Recovery" part.
4. Click to uncheck the "Automatically restart" option.
5. Click OK to close the window. Reproduce the reboot issue.
6. If blue screen occurs, please located the dump files under C:\windows\minidump. Please send them to me at v-shshao@microsoft.com for analyzing.
Regarding the WDP cache file size. I would like to explain that SteadyState uses different technique from SCT. We had to manually create a separated partition to support SCT's WDP. For SteadyState, it creates a cache file automatically. During SteadyState WDP's installation, it will calculate the size of your drive C and create a cache file equal to 50 percent (up to 40 gigabytes [GB]) of the FREE disk space. For example, if you drive C is 100-GB, and your operating system and programs use 20 GB, you have 80 GB of free space available. WDP will create a cache file which is 40GB. Please check the size of the drive C first. You can reduce its size from "Change cache file size" of WDP.
Best Regards,
------------------------------------
Reply:
Good News and Bad news
Good news - I re installed a PC from the Dell CD and with nothing but the OS and Drivers, I was able to get WDP to work. I am installing updates and applications and testing after each one to see where and if it breaks again.
Bad news - As soon as I installed SS on the machine and turned on WDP, Defrag will no onger work. I can click on defrag and analyze but nothing happens. Also on the systems that have the dead on reboot problem, they are not creating any dump files. They are set up for it but there is nothing being created.
------------------------------------
Reply:
Hi,
Thanks for your feedback.
Regarding the Defrag, I performed some research and the following suggestions may be helpful:
Check the status of DCOM Server Process Launcher service
---------------
1. Click Start>Run, type in Services.msc and click OK.
2. Scroll down to DCOM Server Process Launcher. Double click on it and set Startup type to Automatic. Restart your computer.
If the issue persists, you can also try the suggestions on the following website:
Disk defrag will not work
http://forum.tweakxp.com/forum/Topic192189-1-1.aspx
Please Note: Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.
As this forum focuses on SteadyState specific issues, you may post to Windows XP General newsgroup to see whether they have any other suggestions:
The reason why we recommend posting appropriately is that you will get the most qualified pool of respondents, and other customers who read the newsgroups regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
Regards,
------------------------------------
Reply:
Based on my further test, this can be a known issue, please refer to the following thread:
http://forums.microsoft.com/WindowsToolsandUtilities/ShowPost.aspx?PostID=2313283&SiteID=69
Regards,
------------------------------------
Reply:
All the best!
-Chris.
------------------------------------
Reply:
My understanding based on an Interview with the Steadystate developement team (performed with the Tech Soup staff)was that disk defragmenter was purposly disabled when you enable WDP. This is by design. The explanation from the Tech Soup interview stated that there was not any need to defragment the drives AFTER you turn on WDP because the disk basically returns to the previous state. They always recommend that you run the disk defrag before you turn on WDP.
------------------------------------
Forefront Management Console & Exchange Server2007 Edge Role
Hi, a customer is using the Microsoft Forefront Server Security Management Console to obtain best reports from Forefront for Exchange. The problem is when they want to add an Exchange Server with the Edge Role cause its on a workgroup and based on the Forefront Readme File this access is not Supported and i can view just the Domain Exchange Servers Reports.
How can I get the reports from the Exchange 2007 - Edge Server Role?
Thanks!!!!
Ing. Hiram Dante Celis Office: (52)5550043300 Availability: Monday-Friday / 9:00 AM – 6:00 PM PST Email: hcelis@itsln.com IT Consultant ITSLN S.A. de C.V.
Reply:
Hi Hiram,
You're correct in saying that managing servers in a workgroup is not supported - the management console can only be used to manage Forefront Servers that reside in a domain.
-Holly K.
------------------------------------
Reply:
Thank you for reply me, I dont Understand why the Microsoft Forefront Server Security Management Console Developers has not view this limitant, cause the most important SPAM, Attacks, etc Reports on an Exchange Server 2007 Topology are on the First contacted Role Server (EDGE TRANSPORT SERVER ROLE) and this role works on a Workgroup for security reasons.
The solution could be join the edge server or wait for a service pack, utility, export method..
Thanks Again!!!
------------------------------------
Reply:
------------------------------------
URL Access in a Web Application for SSRS PARAMETER
I am using ReportViewer Using URL Access in a Web Application Through Direct Addressing i.g https://localhost/ReportServer/Pages/ReportViewer.aspx?/NEW%20REPORT/CannedReport&rs:Command=Render&rc:toolbar=true&ReportData=jne6wcFv6TXgrSd20rl6aQ==&rc
But I need the parameter of SSRS ..not want to pass the parameter values in url for this though i am changing manually on explorer address rc
What might be the reason
How can i get the REPORT PARAMETER of SSRS in my web application
I am using ReportViewer for parameter i am setting property in my .net application
ReportViewer.multiState.True;
still the parameters are not comming.
No SSU File
I setup some user profiles using Steady State.
I wanted to export the profile but their are no .ssu files on the machine.
Why didn't the application create a .ssu profile?
What do I need to do?
Thanks
Jan
Reply:
Hi Jan,
Is there any error message when exporting a user profile? Where did you save the exported profiles? Are there any additional files after exporting some SteadyState profiles?
Please show hidden files and file extensions to check the save location again
-------------------------
1. Click Start, then click Control Panel, and then click Folder Options.
2. Click the View tab. Under Hidden files and folders, click "Show hidden files and folders."
3. To display other hidden files, clear the "Hide protected operating system files (Recommended)" check box.
4. Click the "Hide extensions for known file type".
5. Click OK.
Please also check the export steps
-------------------------
1. Open SteadyState.
2. Click Export User
3. Select a user from User name drop down list.
4. Choose a save location.
5. Click Save.
Best Regards,
------------------------------------
Reply:
I had set the view to show hidden files.
But they did not appear in the drop down.
I recycled the power on the machines four or five times.
They have finally showed up. Never received an error just a blank drop down.
I thought the export would copy the setting exactly as I have them but it always defaults to Windows 2000 look.
If you change the policy Steady State don't alway apply the policy changes even after a reboot but if you run gpupdate.exe it appears to correct the problem.
Thanks
Jan
------------------------------------
Reply:
Hi Jan,
Thank you for your update on this issue.
What do you mean by "blank drop down"? Did this occur when performing step 3. "Select a user from User name drop down list"?
If this issue still occurs, you can capture a screenshot of the blank drop down and I will perform further research on it.
To capture a screenshot:
------------------------
1. Press the Print Screen key (PrtScn) on your keyboard.
2. Click "Start", click "Run", type "mspaint", and click "OK".
3. In Paint, click Paste under the Edit Menu, click Save under the File menu, type a file name for the snap shot, choose JPEG as "Save as type", click "Desktop" on the left pane, and click Save.
4. Please find the screenshot on the Desktop and send it as an attachment to: v-shshao@microsoft.com
As to the SteadyState export feature, please understand that it only exports the restrictions which were configured from SteadyState. All the other configurations will not be kept.
Regards,
------------------------------------
Example: Powershell and SMO
Here's an example of using SMO from Powershell.
It's not entirely polished, but hopefully will give others an example of how to use the two technologies together
# Script server objects
#
# Requires Windows Powershell to be installed
# (http://www.microsoft.com/windowsserver2003/technologies/management/powershell/default.mspx)
#
# Returns zero for success, non-zero for failure
#
# RNM 10.10.2007
#------------------
trap {
"AN ERROR OCCURRED! :-("
return 255
}
[reflection.assembly]::LoadwithPartialName("Microsoft.SQLServer.SMO") | out-Null
# Set variables
[boolean]$defaulted = $false
if ($args[0] -ne $null) {
$server = $args[0] }
else {
$server = "default_server"
$defaulted = $true
}
if ($args[1] -ne $null) {
$filename = $args[1] }
else {
$filename = "c:\work\temp.txt"
$defaulted = $true
}
if ($args[2] -ne $null) {
$action = $args[2] }
else {
$action = "linkedservers"
$defaulted = $true
}
# Delete output file if it exists already
remove-Item $filename
# Create SQL Server object
$sql = New-Object 'Microsoft.sqlserver.management.smo.server' $server
# Create SQL Server ScriptingOptions object
$scropt = New-Object 'Microsoft.sqlserver.management.smo.scriptingoptions'
$scropt.FileName = $filename
$scropt.includeheaders = $true
$scropt.appendtofile = $true
# Script required objects
switch ($action) {
"linkedservers" {
# Script linked servers
$sql.LinkedServers | foreach-Object {$_.script($scropt) | out-null}
}
"logins" {
# Script logins
$sql.Logins| foreach-Object {$_.script($scropt) | out-null}
}
"jobs" {
# Script logins
$sql.JobServer.jobs| foreach-Object {$_.script($scropt) | out-null}
}
default {
# Exit with failure code
"ERROR: Action not recognised"
return 2
}
}
# Print results
$action + " on " + $server + " scripted to " + $filename
# If we defaulted any of the values then issue a warning, otherwise exit cleanly
if ($defaulted -eq $false) {
return
}
else
{
""
"WARNING: One or more of the required command line parameters was not provided. Defaults were used"
""
"Expected parameters: "
" <server> <filename to script to> <linkedservers|logins>"
return 1
}
Reply:
You might check out
http://www.simple-talk.com/sql/database-administration/managing-sql-server-using-powersmo/
Dan
------------------------------------
leaving Software Updates off
I now have to login, go back into Steady state, turn Updates OFF, reboot (saving this change in WDP on the way out), then wait for Steady State to commit changes, etc, before I can finally shut the laptops down and put them away.
What gives? If I choose to admin the laptops this way (updates OFF), why does Steady State insist on turning Updates on, and do so without telling me?
This "feature" provided a ton of fun over the past few weeks. The bosses have been thrilled.
Thanks,
Reply:
Hi Kcamp0,
Based on my test, after turning on Windows Disk Protection (WDP), SteadyState will turn on "Schedule Software Updates" automatically. This is a by design behavior to reminder customers the update issue when WDP is on. Please understand that we recommend updating the system to protect the computer. As WDP is configured to "Remove all changes at restart" by default, Windows Updates and software updates will not be kept if you update them using other methods.
I will report this issue to our product team to confirm if this design is changeable.
Best Regards,
------------------------------------
Reply:
MS put a setting in Steady State allowing the admin to either turn Auto Updates on or off, then has SS _force_ it to be on, regardless what the admin selects. Why, then, is the AU setting available at all? And why doesn't MS advertise this in documentation? SS's designed behavior is neither a 'reminder' nor a 'recommendation', as you say, it is an imposition!
I have SS installed on a fleet of laptops that are loaned to students. Neither the students nor I want them to boot a laptop and then wait for 10 minutes while WDP commits changes. They want to boot, login, and get to work. I, as admin, am aware of the round about steps required to update the laptops manually, and I have a scheduled, manageable, and effective method to do so.
In short, I know MS recommends turning AU on, and I choose not to do so due to my particular, not-in-Redmond-Oregon situation. This is overbearing and unacceptable.
I hope you will check with the programmers to find a quick fix, a registsty edit or a SS patch maybe, that will get MS off my back about updating.
Regards,
------------------------------------
Reply:
"Scheduling and automating updates is not mandatory. If you want or need to install an update manually, you can do so by selecting Manually download and install updates. Selecting this option turns off scheduled updates to the shared computer."
------------------------------------
Reply:
Hi Kcamp0,
Based on the feedback of our product team, this by design behavior will be kept. Actually, most people will want Windows Updates, so enabling WDP automatically enables SteadyState's handing of Windows Updates. If you would like to change it, please modify it after enabling WDP.
I am not clear what manner is used to update the systems manually on your side. However, as I know, we have to modify WDP mode to save changes when updating. Otherwise, updates will not be retained by WDP. Similar sentences can be found on the same page of SteadyState Handbook:
"If you want or need to install an update manually, you can do so by selecting Do not use Windows SteadyState to download and install updates. Selecting this option turns off Windows SteadyState-managed automatic updates for the shared computer. In addition, you must select Retain changes permanently in the Protect the Hard Disk dialog box when you manually download and install updates or your updates will be cleared when the computer is restarted. "
Thank you for your understanding.
Regards,
------------------------------------
same problem not help sight
I emailed my it department and microsoft no answer
Reply:
? is this a question?
Deli
------------------------------------
Deleting More then 1 column at a time (in report builder) crashes VS2005
fairly simple, just look at the title.
Create a table with several columns. shift click to select more then one. right click press delete, and watch VS crash.
How to: use an Execute SQL Task to generate XML Results and parse using a For Each Loop Container
I thought I wanted to do something simple and ended up spending the better part of a day tearing out my hair trying to figure out how to do this. I wanted to get a list of records and for each record in my list, do something. Before I process a batch, I want to reset all of my failed batches. I finally figured out how to do this using the Execute SQL Task to return XML and the For Each Loop Container to parse the xml and perform the action.
I couldn't find any guidelines for why I would select one kind of EnumerationType versus another in the For Each Loop Container. Also, it would have been nice to have a simple code example for using a query to generate XML then using the for each loop container to parse it.
When generating xml from an Execute SQL Task, set the ResultSet to "XML", then assign a string variable to capture the results on the Result Set tab for Result Name "0"
Here is my SQL Statement:
SELECT 1 AS tag,
NULL AS parent,
NULL AS [batches!1!],
NULL AS [batch_id!2!]
UNION ALL
SELECT 2 AS tag,
1 AS parent,
NULL AS [batches!1!],
batch_id AS [batch_id!2!]
from batch_log
where batch_status not in ('complete', 're-run')
order by [batches!1!], [batch_id!2!]
for xml explicit
which yields an xml result of:
<batches><batch_id>1</batch_id><batch_id>2</batch_id></batches>
When the Execute SQL Task has a result set of "XML", the parent node, "ROOT", is automatically added so the results actually are:
<ROOT><batches><batch_id>1</batch_id><batch_id>2</batch_id></batches></ROOT>
This is important because unless I had set a bazillion break points and took a peek at my string variable that was capturing the results I would never have figured out why my xpath wasn't working!
In my example, the batch_id is an integer. So far, I have yet to figure out how to assign that value to anything other than a string since the variable that contains the xml is a string, but, I can live with this little item while the whole thing actually works now. The xpath was a bit tricky and I think I've finally got it configured though I can't tell you why it works this way because as I said, I couldn't find any guidelines on why to pick which enumeration type. Here is what ended up working for me:
On the Collection tab:
DocumentSourceType = "Variable"
DocumentSource = "User::reset_batch"(the variable that captures my XML results from the Execute SQL Task)
EnumerationType = "ElementCollection"
OuterXPathStringSourceType = "DirectInput"
OuterXPathString="/ROOT/batches/*"
InnerElementType = "NodeText"
InnerXPathStringSourceType = "DirectInput"
InnerXPathString="."
On the Variable Mappings tab:
Add a string variable with index "0" to capture the batch_id. *This is where I can't figure out how to change the data type.
Voila, now I can at least capture the id from the xml and perform my next steps to reset a failed batch inside my for each loop.
How to Copy SQL 2000 Databases and Logins to SQL 2005
If you have attempted to copy a SQL 2000 database and it's logins to a SQL 2005 server, you may have noticed that the local SQL logins can no longer login to the database after it has been copied due to mismatched SID's.
I had a requirement to copy several SQL 2000 databases with hundreds of local logins and found many of the logins could not login to the database after it had been copied to SQL 2005. After working with Microsoft we came up with the following resolution to this issue, this solution will work no matter if there are just a few logins or hundreds of them. The following is broken up into three sections, the instructions, and two Stored Procedures.
http://support.microsoft.com/kb/246133/
-- **************** Instructions ****************
drop procedure [dbo].[sp_hexadecimal]
GO
GO
SET ANSI_NULLS ON
GO
@binvalue varbinary(256),
@hexvalue varchar(256) OUTPUT
AS
DECLARE @charvalue varchar(256)
DECLARE @i int
DECLARE @length int
DECLARE @hexstring char(16)
SELECT @charvalue = '0x'
SELECT @i = 1
SELECT @length = DATALENGTH (@binvalue)
SELECT @hexstring = '0123456789ABCDEF'
WHILE (@i <= @length)
BEGIN
DECLARE @tempint int
DECLARE @firstint int
DECLARE @secondint int
SELECT @tempint = CONVERT(int, SUBSTRING(@binvalue,@i,1))
SELECT @firstint = FLOOR(@tempint/16)
SELECT @secondint = @tempint - (@firstint*16)
SELECT @charvalue = @charvalue +
SUBSTRING(@hexstring, @firstint+1, 1) +
SUBSTRING(@hexstring, @secondint+1, 1)
SELECT @i = @i + 1
END
SELECT @hexvalue = @charvalue
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
DECLARE @name sysname
DECLARE @xstatus int
DECLARE @binpwd varbinary (256)
DECLARE @txtpwd sysname
DECLARE @tmpstr varchar (256)
DECLARE @SID_varbinary varbinary(85)
DECLARE @SID_string varchar(256)
DECLARE login_curs CURSOR FOR
SELECT m.sid, m.name, xstatus, m.password FROM master..sysxlogins M, MyDatabase..sysusers T
WHERE M.sid=T.sid and (srvid IS NULL AND m.name <> 'sa')
ELSE
DECLARE login_curs CURSOR FOR
SELECT m.sid, m.name, xstatus, m.password FROM master..sysxlogins M, MyDatabase..sysusers T
WHERE M.sid=T.sid and (srvid IS NULL AND m.name = @login_name)
OPEN login_curs
FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd
IF (@@fetch_status = -1)
BEGIN
PRINT 'No login(s) found.'
CLOSE login_curs
DEALLOCATE login_curs
RETURN -1
END
SET @tmpstr = '/* sp_help_revlogin script '
PRINT @tmpstr
SET @tmpstr = '** Generated '
+ CONVERT (varchar, GETDATE()) + ' on ' + @@SERVERNAME + ' */'
PRINT @tmpstr
PRINT ''
PRINT 'DECLARE @pwd sysname'
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
PRINT ''
SET @tmpstr = '-- Login: ' + @name
PRINT @tmpstr
IF (@xstatus & 4) = 4
BEGIN -- NT authenticated account/group
IF (@xstatus & 1) = 1
BEGIN -- NT login is denied access
SET @tmpstr = 'EXEC master..sp_denylogin ''' + @name + ''''
PRINT @tmpstr
END
ELSE BEGIN -- NT login has access
SET @tmpstr = 'EXEC master..sp_grantlogin ''' + @name + ''''
PRINT @tmpstr
END
END
ELSE BEGIN -- SQL Server authentication
IF (@binpwd IS NOT NULL)
BEGIN -- Non-null password
EXEC sp_hexadecimal @binpwd, @txtpwd OUT
IF (@xstatus & 2048) = 2048
SET @tmpstr = 'SET @pwd = CONVERT (varchar(256), ' + @txtpwd + ')'
ELSE
SET @tmpstr = 'SET @pwd = CONVERT (varbinary(256), ' + @txtpwd + ')'
PRINT @tmpstr
EXEC sp_hexadecimal @SID_varbinary,@SID_string OUT
SET @tmpstr = 'EXEC master..sp_addlogin ''' + @name
+ ''', @pwd, @sid = ' + @SID_string + ', @encryptopt = '
END
ELSE BEGIN
-- Null password
EXEC sp_hexadecimal @SID_varbinary,@SID_string OUT
SET @tmpstr = 'EXEC master..sp_addlogin ''' + @name
+ ''', NULL, @sid = ' + @SID_string + ', @encryptopt = '
END
IF (@xstatus & 2048) = 2048
-- login upgraded from 6.5
SET @tmpstr = @tmpstr + '''skip_encryption_old'''
ELSE
SET @tmpstr = @tmpstr + '''skip_encryption'''
PRINT @tmpstr
END
END
FETCH NEXT FROM login_curs INTO @SID_varbinary, @name, @xstatus, @binpwd
END
CLOSE login_curs
DEALLOCATE login_curs
RETURN 0
GO
Reply:
Worked like a charm.
Also, since I'm using Managment Studio Express, I was unable to copy the databases, but attach/detach worked.
I also got "
Msg 15021, Level 16, State 2, Line 1
Invalid value given for parameter PASSWORD. Specify a valid parameter value.
"
All I had to do was change the password on the users I'd migrated, and everything else worked.
------------------------------------
Reply:
didn't work
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_help_revlogin_by_db.sql'.
personal i can't belive how stupid MS is.
------------------------------------
Exchange 2007 not shown in license ledger report
Asset Intelligence collects knowledge about applications by conducting a series of archaeological digs on a given system. The data we collect is then transform into a series of signatures which are then sent to the site server for matching against the knowledge base (aka Catalog). One of the items Asset Intelligence digs up is the ProductID (you can get some background information on ProductID and DigitalProductID from this KB article http://support.microsoft.com/kb/936607).
In the case of Exchange 2007 there is no local ProductID since that information is stored in Active Directory vs. local machine. Because Asset Intelligence does not integrate AD for data, we have no access to this information and are therefore unable to provide license ledger information for this particular product.
We are working with the Exchange team to address this issue in future, but for now this is a know limitation that we wanted to share with you.
Reply:
Please note that this affects all three Asset Intelligence releases (i.e. AI 1.0, AI 1.1 and AI 1.5)
------------------------------------
No comments:
Post a Comment