Process Could Note Deliver Updates (s) At The Publisher
Feb 19, 2007
I have created a publisher with row filtering using merge replication .I configured 5-6 subscribers for it.It was working fine for 2 months.But now for two subscribers its showing an error Process could not deliver update (s) at the publisher
Ive checked the job history..its showing
Merge process encountered an unexpected network error. The connection to tublisher 'Publishername' is no longer available
I have Two databases,that same schemas and same tables. that both servers are different location. but data must be update and input from both sites.that data must be same both.
so i've planed to replication data both servers,then i must chose merge replication right?
so i'm set
server1 (assumed server1 as main) are Distributor/Publisher
and
server2 just Subscriber only
that i can configuration successfully.
then i'm chose push replication from server1 but it's not work.
this is error message that show
The process could not deliver the snapshot to the Subscriber.
please advise me what's wrong and how to fix problem?
I am Having trouble trying to set up SQL Server Replication Utilising Web Synchronisation Where the IIS(Web Server) is on a separate machine to the SQL Server(Publisher). I am using MSDE as the SQL Server Box, however even when I used SQLServer2000, or SQLServer2005 I have had no joy with the 2 separate Servers setup.
If I have the one server then I have no problems (i.e. One Server Setup) Server A: Windows 2000, with MSDE installed enabled for Merge replication, and has a Publication set up. IIS Web Page Setup for Synchronisation
My SQL Server 2005 Mobile device syncs via the web page on ServerA Fine, no problems at all.
The Trouble is when I am trying to utilise SQL Server Replication as follows. (i.e. 2 Server Setup)
Basically I am using the Same ServerA as in the one Server setup I had above. All I have done is I am now using a Separate IIS Server for the Web Synchronisation ServerB I have run the "Configure Web Synchronisation Wizard"(ConnWiz30.exe) on my web page on ServerB. And I am using Anonymous Access Authentication With Windows NT Authentication on my Web Server(ServerB), the Anonymous User is a Domain user, and is the Same Domain User I used in the One Server setup which I had working (so this IIS Anonymous Domain user should have all permissions required on the ServerA (SQL Publisher) both Windows permissions and SQL Server Permissions.
Server A: Windows 2000, with MSDE installed enabled for Merge replication, and has a Publication set up.
Server B: Windows XP, IIS Web Server(Web page enabled for Web Synchronisation)
I have a Mobile device as a subscriber, which is using Web Synchronisation on ServerB(Web Server), to sync with the ServerA (MSDE Box). The error I am receiving is "A Call to SQL Server Reconciler has Failed" Try to resynchronise, "The Process Could Not deliver the Snapshot to the Subscriber"
A little extra info: -I can remotely connect from my Web server(ServerB) to the SQL Box ServerA via a TCP/IP ODBC connection so remote connections does not seem to be an issue.
-If on My Mobile device if I try to Add a Subscription & Synchronise the replication using the AddSubscription(AddOption.ExistingDatabase), it works fine. (Obviously the subscription database does exist before the synchronisation)
If I try to Add a Subscription & Synchronise the replication using the AddSubscription(AddOption.CreateDatabase), I get the error as mentioned.
Is there something I have missed? Any help you can provide is much appreciated.
I have a primary and secondary servers both running Windows 2000 SP3 with SQL 2000 SP3. I have set up transactional replication with the primary server as publisher and the secondary server has the distributor and subscriber DB. I am testing the scenerio where my primary server goes down and I have to make updates to the secondary server until my primary server comes back up. I am able to update my subscriber database and the transactions go into the MSreplication_queue table to be pushed back to the primary when it comes back up. When I bring the primary server back up and start the queue agent job it starts pushing the transactions over and then stops after 4 or 5 transactions with the error "Failed while applying queued message to publisher". I have attached part of the log file for the agent below
In the sql server logs I am getting this message: Replication-Replication Transaction Queue Reader Subsystem: agent Repl Queue Reader failed. Failed while applying queued message to publisher. Error: 14151, Severity: 18, State: 1
I have a wired situation..!I set up transactional replication on one of my development server (SQL2000 Dev Edition with sp4).It is running fine without any issues and all of a sudden, i noticed inmy repication monitor tab under Publisher where I usually see thepublication is empty now.I do see the snapshot agent, log reader and distribution agent under myagents inside the replication Monitor. But its usefull to see all 3agents in one window under publisher before. What happend? Is there anyway to get that inside that monitor? Has someone encountered thissitation before? Please advise....After that I tried to create a new set of replication on differentdatabase on the same server and i dont see those either underReplication Monitor - Publishers....All it says is (No Items)....I would appreciate any help to correct this issue... Thanks in advance..
And thanks to Ray for another frustrating response. Gentle suggestion, if you are going to hang out here you may find people appreciate a tad more detail than 'script it'. I consistently get a chuckle out of your responses.
I was having a problem installing SP1, it would barely get started before it would fail. I found it had to do with having many of my databases on an external USB drive. I detached all of those databases, rebooted the machine and then attempted to re-install the Service Pack. This time everything worked fine. Just passing it along in case someone else ran into this.
I have asked this question before (but the question was geared for something else). Let me briefly lay out my question.
I currently have a WinForm app I distribute that interfaces with Access. When I distribute it, I have in the application startup path a folder called "Database" which has the Access .mdf. With me so far?
Now. I have tools that automate and semi-automate the embedding of important information into my database during the course of a project. However, because more people are starting to use my tools, we have a concurrency issue. I was looking at SSEE as a replacement for Access to solve this problem and avoid the concurrency problem. Hence it is not for the customer I am moving to SSEE but for my internal team who use my tools.
I am having a difficult time delivering the finished product because I don't quite know how to deliver SSEE. I am very proficient with setups, and know that as a prequisite they have SSEE as a selectable item, but how to I attach my database to SSEE in the setup? Do I need to detach my database from my server and reattach it during the setup for the customer?
I have found no articles describing this (except ClickOnce which is not what I want). If everyone raves about SSEE over Access, I would think this would be a widely available question.
This is probably a question for a MVP or someone who has dealt with this personally, so I would welcome your expertise in this matter.
I have job in SQL Server 2000 that is setup to notify an email operator upon successful completion.
When I test the notification to the set email operator it sends the email just fine.
When the job is run manually it emails the operator just fine.
When the job is run on a schedule it does not email the operator upon completion. It gives the details in view job history "NOTE: Failed to notify '<operator>' via email.
I have other jobs on the same server that run and notify via email to other operators upon successful completion just fine.
I have parsed MS Technet and the web and did not find anything.
This isn't a performance type of question, or whose CPU is bigger, but I'm more interested in knowing what people use out there as far as monitor setups go.
The root of the question stems from working in large package where there are many components laid out on the work flow. What do you use to work with large layouts? I constantly find it troubling to view enough of my package and am always zooming out to see more of the package. However, when doing that, the text becomes unreadable, of course.
I currently use a dual-monitor setup using my laptop and a LCD flat screen.
Resolutions on the laptop is 1920 x 1200 and the LCD monitor is 1280 x 1024. This helps to keep windows and output screens on one monitor while keeping the work flow on the other. Even still, I wish I had more screen real estate.
We are repeatedly having the trouble of our publisher database becoming unresponsive during network problems. We have publisher in carribean, distribution agent in canada and subscribers all over. The problem comes when publisher cant deliver to distributor due to network outages.
We are planning on moving the distributor to the carribean ultimately but that will take a while, and our application repeatedly needs to be restarted due to these freezes.
Does anyone know of this problem & possible ways to fix it in the short term (short of changing our replication topology).
is this a bug in replication?
ps.database is merge & transactional pubs. (some tables merge/some trans)
with datediff all I can get it to return is months or a total of thedays...so if the difference in dates is 12 months 4 days how do I adjust theSQL to accommodate both?
hi, I am working on SQL server 6.5 using a desk top. Now I am about to buy a note book and do some development work. As far as I know, win 95,98 does not support SQL server 6.5
But SQL sever 7.0 does support win 95,98 Am I correct? I am confuzed, what notebook operating system shall I buy which will allow me to work on sql development on the road.
another issues is what if I choose to use win 98 for sql server 7.0 what are the things that I will be missing . In other word, what are the limitation that I may have when acquiring win 98 as an operating system for sql server 7.0..
how can standard subscription or data driven subscription be used to deliver reports to specific email address.
the standard subscription or data driven subscription can be used to delever reports using Windows file share ,but how to make it work for delivering to emails..
I'm using data-driven subscription to deliver reports to users via email.
However every few days or so, some of the reports will fail to get delivered to some of the subscribers. The rpts and subscribers affected are usually not the same.
The log showed the below messages....would really appreciate if anybody can shed light on this! TIA!
ReportingServicesService!library!16!02/21/2008-09:03:09:: i INFO: Call to RenderFirst( '/Daily Movement Reports/FDDlyTopRevoAgt' ) ReportingServicesService!cache!16!02/21/2008-09:03:09:: i INFO: From cache live: /Daily Movement Reports/FDDlyTopRevoAgt ReportingServicesService!library!16!02/21/2008-09:03:09:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. ReportingServicesService!dbpolling!4!02/21/2008-09:03:09:: i INFO: NotificationPolling processing item 336709ba-97ce-4e6f-b9d3-09ae26e9f6fb ReportingServicesService!library!4!02/21/2008-09:03:09:: i INFO: Call to RenderFirst( '/Daily Movement Reports/FDDlyTopRevoAgt' ) ReportingServicesService!library!4!02/21/2008-09:03:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.IO.IOException: The process cannot access the file 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesRSTempFilesRSFile_bbc8b100-f99e-438f-88bc-bd796b88bc1c' because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at Microsoft.ReportingServices.Library.PartitionFileStream..ctor(String path, PartitionManager manager, Boolean deleteOnClose) at Microsoft.ReportingServices.Library.PartitionManager.GetFileFromPartition(String path) at Microsoft.ReportingServices.Library.MemoryThenFileStream..ctor(String filename, Int32 threshold, PartitionManager partitionManager) at Microsoft.ReportingServices.Library.CachedData.GetNewStream() at Microsoft.ReportingServices.Library.CachedRenderingResult.GetRenderingResult() at Microsoft.ReportingServices.Library.RSService.RenderAsSnapshot(CatalogItemContext reportContext, Guid reportId, DateTime executionDate, DateTime expirationDate, ClientRequest session, ReportSnapshot snapshotData, String description, Boolean foundInCache, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
I am working on a report which displays profit and loss discrepancy between two systems. So if there is discrepancy, in other words, the dataset returns value, then I want reporting serive to deliever the report to intended users. I am currently using standard edition with no data-driven subscription support.
I do not know what is the workaround for this implementation. Tks for advise in advance.
I first attempted to install SQL Server 2005 with the management tools, SQL server services installed ok but the management tools did not install. I tried to re-install the management tools but the setup program thought that they were already installed. I then un-installed everything in Add/Remove programs, & rebooted. I then tried to install again but this time it thought that the SQL server services were already installed. I removed the services from the registry and rebooted again. Now when I try to install SQL Server 2005 it simply fails
The last message in the log is "Note: 1: 1708 MSI (s) (A0:6C) [15:34:23:656]: Product: Microsoft SQL Server 2005 -- Installation failed"
Any help would be appreciated
MSI (s) (A0:6C) [15:34:22:593]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServer 3: 2 MSI (s) (A0:6C) [15:34:22:593]: Note: 1: 1325 2: v2.0.50727 MSI (s) (A0:6C) [15:34:22:593]: PROPERTY CHANGE: Adding ASPNET_EVENTLOGDLL.6BAD20EB_8CBD_4950_9F16_9F83B608665D property. Its value is 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727EventLogMessages.dll'. MSI (s) (A0:6C) [15:34:22:593]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL ServerMSSQL.1Replication 3: 2 MSI (s) (A0:6C) [15:34:22:593]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL ServerMSSQL.1Replication 3: 2 MSI (s) (A0:6C) [15:34:22:609]: Doing action: DetectSKUOS.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 15:34:22: AppSearch. Return value 1. MSI (s) (A0:74) [15:34:22:609]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI2B6.tmp, Entrypoint: DetectSKUOS Action start 15:34:22: DetectSKUOS.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=DetectSKUOS <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: DetectSKUOS PerfTime Start: DetectSKUOS : Thu Feb 22 15:34:22 2007 <Func Name='DetectSKUOS'> VersionNT/64 detected MsiNTProductType = 3 OS type: 0xf0000000, supported: 0xfff0ff00 <EndFunc Name='DetectSKUOS' Return='0' GetLastError='0'> PerfTime Stop: DetectSKUOS : Thu Feb 22 15:34:22 2007 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (A0:6C) [15:34:22:687]: Skipping action: DetectWYukonOS.D20239D7_E87C_40C9_9837_E70B8D4882C2 (condition is false) MSI (s) (A0:6C) [15:34:22:687]: Skipping action: SetErrorReporting (condition is false) MSI (s) (A0:6C) [15:34:22:687]: Skipping action: SetSqmReporting (condition is false) MSI (s) (A0:6C) [15:34:22:687]: Doing action: SetEnableRanu Action ended 15:34:22: DetectSKUOS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (A0:6C) [15:34:22:687]: PROPERTY CHANGE: Modifying SqlEnableRanu property. Its current value is '0'. Its new value: '1'. Action start 15:34:22: SetEnableRanu. MSI (s) (A0:6C) [15:34:22:687]: Doing action: CCPSearch Action ended 15:34:22: SetEnableRanu. Return value 1. MSI (s) (A0:6C) [15:34:22:687]: Note: 1: 2205 2: 3: CCPSearch MSI (s) (A0:6C) [15:34:22:687]: Note: 1: 2228 2: 3: CCPSearch 4: SELECT `Signature_` FROM `CCPSearch` Action start 15:34:22: CCPSearch. MSI (s) (A0:6C) [15:34:22:687]: Doing action: RMCCPSearch Action ended 15:34:22: CCPSearch. Return value 0. MSI (s) (A0:6C) [15:34:22:687]: Note: 1: 2205 2: 3: CCPSearch MSI (s) (A0:6C) [15:34:22:687]: Note: 1: 2228 2: 3: CCPSearch 4: SELECT `Signature_` FROM `CCPSearch` Action start 15:34:22: RMCCPSearch. MSI (s) (A0:6C) [15:34:22:687]: Doing action: RestoreProductID Action ended 15:34:22: RMCCPSearch. Return value 0. MSI (s) (A0:20) [15:34:22:703]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI2B7.tmp, Entrypoint: RestoreProductID Action start 15:34:22: RestoreProductID. <Func Name='LaunchFunction'> Function=RestoreProductID <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: RestoreProductID PerfTime Start: RestoreProductID : Thu Feb 22 15:34:22 2007 <Func Name='RestoreProductID'> <EndFunc Name='RestoreProductID' Return='0' GetLastError='0'> PerfTime Stop: RestoreProductID : Thu Feb 22 15:34:22 2007 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (A0:6C) [15:34:22:765]: Doing action: SetShowPID Action ended 15:34:22: RestoreProductID. Return value 1. MSI (s) (A0:6C) [15:34:22:781]: PROPERTY CHANGE: Adding ShowPID property. Its value is '1'. Action start 15:34:22: SetShowPID. MSI (s) (A0:6C) [15:34:22:781]: Doing action: ValidatePID Action ended 15:34:22: SetShowPID. Return value 1. MSI (s) (A0:50) [15:34:22:781]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI2B8.tmp, Entrypoint: ValidateProductID MSI (s) (A0!58) [15:34:22:843]: PROPERTY CHANGE: Adding CCPTrigger property. Its value is '2'. MSI (s) (A0!58) [15:34:22:843]: PROPERTY CHANGE: Adding PKU property. Its value is '0'. MSI (s) (A0!58) [15:34:22:843]: PROPERTY CHANGE: Adding PIDSEQ property. Its value is '271000003'. MSI (s) (A0!58) [15:34:22:843]: PROPERTY CHANGE: Adding PID property. Its value is '**********'. MSI (s) (A0!58) [15:34:22:843]: PROPERTY CHANGE: Adding ProductID property. Its value is '**********'. MSI (s) (A0!58) [15:34:22:843]: PROPERTY CHANGE: Adding DPID property. Its value is '**********'. MSI (s) (A0!58) [15:34:22:843]: PROPERTY CHANGE: Adding DigitalProductID property. Its value is '**********'. MSI (s) (A0!58) [15:34:22:843]: PROPERTY CHANGE: Adding PIDRET property. Its value is '0'. Action start 15:34:22: ValidatePID. MSI (s) (A0:6C) [15:34:22:843]: Doing action: DetectProductID Action ended 15:34:22: ValidatePID. Return value 1. MSI (s) (A0:20) [15:34:22:859]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI2B9.tmp, Entrypoint: DetectProductID Action start 15:34:22: DetectProductID. <Func Name='LaunchFunction'> Function=DetectProductID <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: DetectProductID PerfTime Start: DetectProductID : Thu Feb 22 15:34:22 2007 <Func Name='DetectProductID'> <EndFunc Name='DetectProductID' Return='0' GetLastError='0'> PerfTime Stop: DetectProductID : Thu Feb 22 15:34:22 2007 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (A0:6C) [15:34:22:937]: Doing action: SetPIDKEY Action ended 15:34:22: DetectProductID. Return value 1. MSI (s) (A0:6C) [15:34:22:937]: PROPERTY CHANGE: Deleting PIDKEY property. Its current value is '**********'. Action start 15:34:22: SetPIDKEY. MSI (s) (A0:6C) [15:34:22:937]: Doing action: SetValidMOFInstanceNameProp.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 15:34:22: SetPIDKEY. Return value 1. MSI (s) (A0:4C) [15:34:22:953]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI2BA.tmp, Entrypoint: SetValidMOFInstanceNameProp Action start 15:34:22: SetValidMOFInstanceNameProp.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=SetValidMOFInstanceNameProp <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: SetValidMOFInstanceNameProp PerfTime Start: SetValidMOFInstanceNameProp : Thu Feb 22 15:34:23 2007 <Func Name='SetValidMOFInstanceNameProp'> MSI (s) (A0!60) [15:34:23:109]: PROPERTY CHANGE: Adding ValidMOFInstanceName property. Its value is '1'. Setting ValidMofInstanceName to 1 <EndFunc Name='SetValidMOFInstanceNameProp' Return='0' GetLastError='0'> PerfTime Stop: SetValidMOFInstanceNameProp : Thu Feb 22 15:34:23 2007 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (A0:6C) [15:34:23:109]: Doing action: CostInitialize Action ended 15:34:23: SetValidMOFInstanceNameProp.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (A0:6C) [15:34:23:125]: Machine policy value 'MaxPatchCacheSize' is 10 Action start 15:34:23: CostInitialize. MSI (s) (A0:6C) [15:34:23:125]: PROPERTY CHANGE: Adding ROOTDRIVE property. Its value is 'D:'. MSI (s) (A0:6C) [15:34:23:125]: PROPERTY CHANGE: Adding CostingComplete property. Its value is '0'. MSI (s) (A0:6C) [15:34:23:125]: Transforming table Component.
MSI (s) (A0:6C) [15:34:23:125]: Transforming table Component.
MSI (s) (A0:6C) [15:34:23:125]: Transforming table Component.
MSI (s) (A0:6C) [15:34:23:125]: Note: 1: 2205 2: 3: Patch MSI (s) (A0:6C) [15:34:23:125]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (A0:6C) [15:34:23:125]: Note: 1: 2205 2: 3: MsiPatchHeaders MSI (s) (A0:6C) [15:34:23:125]: Note: 1: 2205 2: 3: __MsiPatchFileList MSI (s) (A0:6C) [15:34:23:125]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (A0:6C) [15:34:23:125]: Note: 1: 2228 2: 3: PatchPackage 4: SELECT `DiskId`, `PatchId`, `LastSequence` FROM `Media`, `PatchPackage` WHERE `Media`.`DiskId`=`PatchPackage`.`Media_` ORDER BY `DiskId` MSI (s) (A0:6C) [15:34:23:125]: Doing action: SetFTSearchProperties.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 15:34:23: CostInitialize. Return value 1. MSI (s) (A0:C4) [15:34:23:140]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI2BC.tmp, Entrypoint: SetFTSearchProperties Action start 15:34:23: SetFTSearchProperties.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=SetFTSearchProperties <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: SetFTSearchProperties PerfTime Start: SetFTSearchProperties : Thu Feb 22 15:34:23 2007 <Func Name='SetFTSearchProperties'> MSI (s) (A0!C0) [15:34:23:250]: PROPERTY CHANGE: Modifying FTERudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C property. Its current value is 'MSSQLSERVER'. Its new value: 'MSSQL.1'. FTS Property Name: FTEInstName.68C6D15C_77E0_11D5_8528_00C04F68155C set MSI (s) (A0!C0) [15:34:23:250]: PROPERTY CHANGE: Modifying FTERegRoot.68C6D15C_77E0_11D5_8528_00C04F68155C property. Its current value is 'SoftwareMicrosoftMSSQLSERVERMSSearch'. Its new value: 'SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSearch'. FTS Property Name: FTERudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C set MSI (s) (A0!C0) [15:34:23:250]: PROPERTY CHANGE: Adding FTEInstanceSubDir.68C6D15C_77E0_11D5_8528_00C04F68155C property. Its value is 'MSSQL.1MSSQL'. FTS Property Name: FTERegRoot.68C6D15C_77E0_11D5_8528_00C04F68155C set FTS Property Name: FTEInstanceSubDir.68C6D15C_77E0_11D5_8528_00C04F68155C set FTS Property Name: FTEClusterSec.68C6D15C_77E0_11D5_8528_00C04F68155C set <EndFunc Name='SetFTSearchProperties' Return='0' GetLastError='0'> PerfTime Stop: SetFTSearchProperties : Thu Feb 22 15:34:23 2007 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (A0:6C) [15:34:23:265]: Doing action: FileCost Action ended 15:34:23: SetFTSearchProperties.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (A0:6C) [15:34:23:281]: Note: 1: 2262 2: Class 3: -2147287038 MSI (s) (A0:6C) [15:34:23:281]: Note: 1: 2262 2: Extension 3: -2147287038 MSI (s) (A0:6C) [15:34:23:281]: Note: 1: 2262 2: TypeLib 3: -2147287038 Action start 15:34:23: FileCost. MSI (s) (A0:6C) [15:34:23:281]: Doing action: IsolateComponents Action ended 15:34:23: FileCost. Return value 1. Action start 15:34:23: IsolateComponents. MSI (s) (A0:6C) [15:34:23:281]: Doing action: SQLLicensing.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 15:34:23: IsolateComponents. Return value 0. MSI (s) (A0:50) [15:34:23:296]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI2BD.tmp, Entrypoint: SQLLicensing Action start 15:34:23: SQLLicensing.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=SQLLicensing <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: SQLLicensing PerfTime Start: SQLLicensing : Thu Feb 22 15:34:23 2007 <Func Name='SQLLicensing'> <EndFunc Name='SQLLicensing' Return='0' GetLastError='0'> PerfTime Stop: SQLLicensing : Thu Feb 22 15:34:23 2007 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (A0:6C) [15:34:23:375]: Doing action: CAResolveInstanceName.68C6D15C_77E0_11D5_8528_00C04F68155C Action ended 15:34:23: SQLLicensing.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (A0:54) [15:34:23:390]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI2BE.tmp, Entrypoint: ResolveInstanceName Action start 15:34:23: CAResolveInstanceName.68C6D15C_77E0_11D5_8528_00C04F68155C. FTECa.DLL: INFO: FTE: ResolveInstanceName(), Entering... FTECa.DLL: INFO: FTE: This is NOT an Exchange Server install... FTECa.DLL: INFO: ResolveInstanceName: FTEInstName obtained: MSSQLSERVER FTECa.DLL: INFO: ResolveInstanceName: FTERudeInstName obtained: MSSQL.1 FTECa.DLL: INFO: LookupInstanceId: Iterating the key: 1 FTECa.DLL: ERROR: LookupInstanceId: RegQueryValueEx(RudeName) failed. Err = 2 Action ended 15:34:23: CAResolveInstanceName.68C6D15C_77E0_11D5_8528_00C04F68155C. Return value 3. Action ended 15:34:23: INSTALL. Return value 3. Property(S): ProductCode = {FFFA78A7-BD51-4255-8470-C4D4A85B49F5} Property(S): ProductLanguage = 1033 Property(S): Manufacturer = Microsoft Corporation Property(S): ProductVersion = 9.00.1399.06 Property(S): MEDIAPACKAGEPATH = Setup Property(S): ALLUSERS = 1 Property(S): NULLGUID = {00000000-0000-0000-0000-000000000000} Property(S): ASPNetVersion = 2.0.50727 Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52152 Property(S): ARPPRODUCTICON = ARPIcon.ico Property(S): ARPNOREPAIR = 1 Property(S): ARPSYSTEMCOMPONENT = 1 Property(S): MsiHiddenProperties = SQLPASSWORD;AGTPASSWORD;ASPASSWORD;RSPASSWORD;SQLBROWSERPASSWORD;RSSQLPASSWORD;RSSQLPassword;RSSQLPasswordQuoted;RSSETUPPASSWORD;RSSetupPassword;SAPWD;saPWD;UPGRADEPWD;SqlUpgradePwd;SQLPassword;ServicePassword;ADMINPASSWORD;PIDKEY;FTEPassword.68C6D15C_77E0_11D5_8528_00C04F68155C;checksum.7354AFCB_913B_4E9F_B76C_2376101FDE0C;checksum.;DigitalProductID;DPID;Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2;Rollback_SqlConnection.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_XmlSingleNode.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_RSSetting.D20239D7_E87C_40C9_9837_E70B8D4882C2;PID;ProductID;RSUPGRADEPASSWORD;Do_RSSetSharePointExclusionPath.D20239D7_E87C_40C9_9837_E70B8D4882C2 Property(S): SecureCustomProperties = SQL_SHOWLIC;UPGRADESQL90 Property(S): SqlServerBuild = 1 Property(S): SqlCluster = 0 Property(S): INSTALLLEVEL = 90 Property(S): FXAssemblyVersion = 2.0.0.0 Property(S): VSAssemblyVersion = 8.0.0.0 Property(S): SqlErrorReporting = #0 Property(S): SqlSqmReporting = #0 Property(S): SqlEnableRanu = 1 Property(S): SqlPatchLevel = 9.00.1399.06 Property(S): ChannelID = 271 Property(S): PIDTemplate = 77654<````=````=````=````=`````>@@@@@ Property(S): mpc = 77654 Property(S): OEMRelease = 0 Property(S): SQLSETUPBOOTSTRAPSETUPPATH = C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Property(S): SQLSETUPARPWRAPPER = C:Program FilesMicrosoft SQL Server90Setup BootstrapARPWrapper.exe Property(S): UPGRADE_ADVISOR_CMD32 = C:Program FilesMicrosoft SQL Server90Setup Bootstrap Property(S): SQLIEMINVERSION = C:WINDOWSsystem32shdocvw.dll Property(S): ProgramFilesFolder = C:Program Files Property(S): ProductID = ********** Property(S): DigitalProductID = ********** Property(S): INSTALLSQLDIR = D:Program FilesMicrosoft SQL Server Property(S): INSTALLSQLDATADIR = D:Program FilesMicrosoft SQL Server Property(S): SqlCollation = Latin1_General_CI_AS Property(S): SqlInstanceName = MSSQLSERVER Property(S): saSetAutoSAPWDAndDisable = 1 Property(S): ShowPID = 1 Property(S): MDACSXS = 1 Property(S): DefaultUIFont = Tahoma8 Property(S): VersionNT = 502 Property(S): LocalSystemAccount = NT AUTHORITYSYSTEM Property(S): DefaultBuiltInAccount = LocalSystemAccount Property(S): NetworkServiceAccount = NT AUTHORITYNETWORK SERVICE Property(S): LocalServiceAccount = NT AUTHORITYLOCAL SERVICE Property(S): INSTALLSQLSHAREDDIR = D:Program FilesMicrosoft SQL Server Property(S): UI_INSTALLSQLSHAREDDIR = D:Program FilesMicrosoft SQL Server Property(S): SimpleFeatureTitle_Feat1 = SQL Server Database Services Property(S): SqlDisableNetworkProtocols = 2 Property(S): SimpleFeature_SQLEngineVS = Create a SQL Server failover cluster Property(S): SimpleFeature_Feat1 = &SQL Server Database Services Property(S): Service_AGT = SQL Server Agent Property(S): Service_OLAP = SQL Server Analysis Services Property(S): Service_SQL = SQL Server Property(S): Service_RS = SQL Server Reporting Services Property(S): Service_Browse = SQL Server Browser Property(S): Service_DTS = SQL Server Integration Services Property(S): Service_ADHelper = SQL Server Active Directory Helper Property(S): Service_SQLWriter = SQL Server VSS Writer Property(S): Service_FTS = SQL Server FullText Search Property(S): ServiceDesc_RS = Manages, executes, renders, schedules and delivers reports. Property(S): ServiceDesc_AGT = Executes jobs, monitors SQL Server, and fires alerts, and allows automation of some administrative tasks. Property(S): ServiceDesc_SQL = Provides storage, processing and controlled access of data and rapid transaction processing. Property(S): ServiceDesc_Browse = Provides SQL Server connection information to client computers. Property(S): ServiceDesc_OLAP = Supplies online analytical processing (OLAP) and data mining functionality for business intelligence applications. Property(S): ServiceDesc_DTS = Provides management support for SSIS package storage and execution. Property(S): ServiceDesc_ADHelper = Enables integration with Active Directories. Property(S): ServiceDesc_SQLWriter = Provides the interface to backup/restore Microsoft SQL server through the Windows VSS infrastructure. Property(S): ServiceDesc_FTS = Quickly creates full-text indexes on content and properties of structured and semi-structured data to allow fast linguistic searches on this data. Property(S): ServiceGroupDesc_ADHelper = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Active Directory Helper in SQL Server 2005. Property(S): ServiceGroupDesc_AGT = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Agent in SQL Server 2005. Property(S): ServiceGroupDesc_OLAP = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Analysis Services in SQL Server 2005. Property(S): ServiceGroupDesc_Browse = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Browser in SQL Server 2005. Property(S): ServiceGroupDesc_DTS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Integration Services in SQL Server 2005. Property(S): ServiceGroupDesc_FTS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server and SQL Server FullText Search in SQL Server 2005. Property(S): ServiceGroupDesc_NS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Notification Services in SQL Server 2005. Property(S): ServiceGroupDesc_RS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Reporting Services in SQL Server 2005. Property(S): ServiceGroupDesc_RSWeb = Members in the group have the required access to be assigned as the log on account for the associated instance of SQL Server Reporting Services in SQL Server 2005 Property(S): ServiceGroupDesc_SQL = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server and SQL Server FullText Search in SQL Server 2005. Property(S): ServiceGroupDesc_SQL_NEW = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server in SQL Server 2005. Property(S): ServiceGroupDesc_FTS_NEW = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Full Text Search in SQL Server 2005. Property(S): DlgService_AGT = SQL Server Agent Property(S): DlgService_OLAP = Analysis Services Property(S): DlgService_SQL = SQL Server Property(S): DlgService_RS = Reporting Services Property(S): DlgService_Browse = SQL Browser Property(S): AutoStart_AGT = SQL Server A&gent Property(S): AutoStart_OLAP = &Analysis Services Property(S): AutoStart_SQL = &SQL Server Property(S): AutoStart_RS = Rep&orting Services Property(S): AutoStart_Browse = SQL Bro&wser Property(S): AutoStart_FTS = SQL Server &FullText Search Property(S): _AuthenticationType = Windows Property(S): SQL_rgCollation = 1 Property(S): OLAP_rgCollation = 0 Property(S): _InstanceType = Default Property(S): _LicensingMode = PerSeat Property(S): AGTLogin = DomainAccount Property(S): ASLogin = DomainAccount Property(S): SingleLogin = DomainAccount Property(S): SQLLogin = DomainAccount Property(S): RSLogin = DomainAccount Property(S): SQLBROWSERLogin = DomainAccount Property(S): _UpgradeLogon = Windows Property(S): _SampleDBMode = InstallSD Property(S): ButtonTextStyle = {ButtonTextStyle} Property(S): DlgTextStyle = {DlgTextStyle} Property(S): DlgTextStyleB = {DlgTextStyleB} Property(S): DlgTitleStyle = {DlgTitleStyle} Property(S): DlgTitleStyleB = {DlgTitleStyleB} Property(S): FixedStyle = {FixedStyle} Property(S): T_DataFree = T_DataFree Property(S): T_DataReq = T_DataReq Property(S): T_ProgramFree = T_ProgramFree Property(S): T_ProgramReq = T_ProgramReq Property(S): T_IPVal = T_IPVal Property(S): T_Subnet = T_Subnet Property(S): ErrorDialog = ErrorDlg Property(S): TextVSName = &Virtual server name: Property(S): ENABLERANU = 1 Property(S): AccountForAllNodesDlg_Desc = Account for remote setup. Property(S): AccountForAllNodesDlg_Text = Enter a user name and password that is a valid administrator account for all nodes in the cluster system. This will be used during setup only. Property(S): AccountForAllNodesDlg_Title = Remote Account Information Property(S): Authentication_ConfirmPWText = Confirm &password: Property(S): Authentication_DlgDesc = The authentication mode specifies the security used when connecting to SQL Server. Property(S): Authentication_DlgText = Select the authentication mode to use for this installation. Property(S): Authentication_DlgTitle = Authentication Mode Property(S): Authentication_EnterPWText = &Enter password: Property(S): Authentication_saPasswordText = Specify the sa logon password below: Property(S): Authentication_SQL = &Mixed Mode (Windows Authentication and SQL Server Authentication) Property(S): Authentication_Windows = &Windows Authentication Mode Property(S): BrowseFolder_ComboText = &Install in: Property(S): BrowseFolder_DlgDesc = You can select a different folder for installation. Property(S): BrowseFolder_DlgTitle = Change Folders Property(S): BrowseFolder_TailText = Installation &path: Property(S): BrowseFolder_TailTextShared = The SQL Server shared path has already been configured. Property(S): ButtonText_Abort = &Abort Property(S): ButtonText_Add = &Add Property(S): ButtonText_Back = < &Back Property(S): ButtonText_Browse = B&rowse... Property(S): ButtonText_Cancel = Cancel Property(S): ButtonText_Close = &Close Property(S): ButtonText_Complete = &Complete Property(S): ButtonText_ContinueLater = &Continue Later Property(S): ButtonText_DiskCost = &Disk Cost... Property(S): ButtonText_Exit = &Exit Property(S): ButtonText_Finish = &Finish Property(S): ButtonText_Help = &Help Property(S): ButtonText_Ignore = &Ignore Property(S): ButtonText_Install = &Install Property(S): ButtonText_Minimal = &Minimal Property(S): ButtonText_New = &New Property(S): ButtonText_Next = &Next > Property(S): ButtonText_No = &No Property(S): ButtonText_Normal = &Normal Property(S): ButtonText_OK = OK Property(S): ButtonText_Open = &Open Property(S): ButtonText_Reinstall = &Reinstall Property(S): ButtonText_ReinstallMode = &Select the reinstall mode Property(S): ButtonText_Remove = &Remove Property(S): ButtonText_Remove2 = &Remove Property(S): ButtonText_Report = &Report Property(S): ButtonText_Reset = &Reset Property(S): ButtonText_Restore = &Restore Property(S): ButtonText_Resume = &Resume Property(S): ButtonText_Retry = &Retry Property(S): ButtonText_Up = &Up Property(S): ButtonText_Yes = &Yes Property(S): Cancel_DlgDesc = Are you sure you want to cancel the installation? Property(S): Cancel_DlgText = The installation is not complete. If you exit the wizard now, Microsoft SQL Server will not be installed. Property(S): ClusterGroup_DlgDesc = Select the cluster group where the virtual server resources will be installed. Property(S): ClusterGroup_DlgStaticTextAvailable = Available cluster groups: Property(S): ClusterGroup_DlgStaticTextUnavailable = Unavailable cluster groups: Property(S): ClusterGroup_DlgTitle = Cluster Group Selection Property(S): ClusterNodeDlg_ButtonTextAdd = &Add -> Property(S): ClusterNodeDlg_ButtonTextRemove = <- &Remove Property(S): ClusterNodeDlg_StaticTextAvailableNode = Available nodes: Property(S): ClusterNodeDlg_StaticTextRequiredNode = Required node: Property(S): ClusterNodeDlg_StaticTextSelectedNode = Selected nodes: Property(S): ClusterNodeDlg_StaticTextUnavailableNode = Unavailable nodes: Property(S): ClusterNodeDlg_Text = Select the nodes to include in the virtual server. Property(S): ClusterNodeDlg_Title = Cluster Node Configuration Property(S): Collation_Service = S&ervice: Property(S): Collation_Service1 = Collation settings for service: Property(S): Collation_AS_Collation = Analysis Services Collation: Property(S): Collation_ChkBinary = Binary Property(S): Collation_ChkBinary2 = Binary - code point Property(S): Collation_ChkCase = Case - sensitive Property(S): Collation_ChkAccent = Accent - sensitive Property(S): Collation_ChkKana = Kana - sensitive Property(S): Collation_ChkWidth = Width - sensitive Property(S): Collation_Designator = Collation &designator and sort order: Property(S): Collation_DlgDesc = Collation settings define the sorting behavior for your server. Property(S): Collation_DlgCusomizeText = &Customize for each service account Property(S): Collation_DlgTitle = Collation Settings Property(S): Collation_SQL = &SQL collations (used for compatibility with previous versions of SQL Server) Property(S): DiskPrompt = Please insert next disk Property(S): DiskSpace_DlgDesc = Disk space required for the installation exceeds available disk space. Property(S): DiskSpace_DlgDesc1 = The available disk space and the space required for installation are shown below. Property(S): DiskSpace_DlgText = The highlighted volumes, if any, do not have enough disk space available for the currently selected features. Click Disk Cleanup to free disk space and then click Resume to continue the installation, or click Exit to exit the wizard. Property(S): DiskSpace_DlgTitle = Out of Disk Space Property(S): DiskSpace_DlgTitle1 = Disk Cost Property(S): DiskSpace_LBDiskCleanup = Use disk cleanup to free more disk space by removing unneeded files. Property(S): REASON_ADMIN_DISABLED = Administrative shares must be enabled in order to let Setup access remote nodes Property(S): REASON_DARWIN_VER = Windows installer is not present or has not the required version Property(S): REASON_DUP_INSTANCE_NAME_CLST = An instance with the same name is already installed in one or more nodes of the cluster. Property(S): REASON_GROUP_HOSTS_VS = Already contains a SQL Virtual Server Property(S): REASON_GROUP_NO_DISK = Does not contain any valid cluster disk Property(S): ERROR_INVALID_PID = This is an invalid Product Key value. Please check the number located on your Product Key sticker. Property(S): ERROR_INVALID_USERNAME = The Name is required for the installation. Property(S): REASON_NODE_DOWN = The node is down or unavailable Property(S): REASON_NOT_KNOWN = Unknown Property(S): REASON_PENDING_REBOOT = The node must be rebooted before running setup Property(S): REASON_SCC_CHECK_FAILED = A SCC check failed on the node Property(S): ERROR_UNKNOWN = Installation error. Install it by running setup.exe. Property(S): REASON_VERSION_ADDNODE = Adding nodes to the Virtual Server definition using a newer version of Setup is not allowed. Property(S): REASON_OS_VER = SQL Server requires Windows 2000 Service Pack 4, or Windows XP Service Pack 1 or later for installation. Property(S): REASON_OS_TYPE = This version of SQL Server is not supported on this version of Windows. Property(S): Exit_DlgDesc1 = Setup has installed Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc2 = Setup has removed Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc3 = Setup has updated Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc4 = Setup has reinstalled Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc5 = Setup has upgraded Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgTitle = Completing Microsoft SQL Server Setup Property(S): SimpleFeature_DlgDesc = Select the components to install or upgrade. Property(S): SimpleFeature_DlgTitle = Components to Install Property(S): SimpleFeature_Feat2 = &Analysis Services Property(S): SimpleFeature_AnalysisServerVS = Create an Analysis Server failover cluster Property(S): SimpleFeature_Feat3 = &Reporting Services Property(S): SimpleFeature_Feat4 = N&otification Services Property(S): SimpleFeature_Feat5 = &Integration Services Property(S): SimpleFeature_Feat6 = &Workstation components, Books Online and development tools Property(S): SimpleFeatureTitle_Feat2 = Analysis Services Property(S): SimpleFeatureTitle_Feat3 = Reporting Services Property(S): SimpleFeatureTitle_Feat4 = Notification Services Property(S): SimpleFeatureTitle_Feat5 = Integration Services Property(S): SimpleFeatureTitle_Feat6 = Client Components Property(S): SimpleFeature_Advanced = A&dvanced Property(S): SimpleFeature_AdvancedText = For more options, click Advanced. Property(S): SimpleFeature_Components = Components to be installed Property(S): SimpleFeature_OutOfSpace = There is not enough disk space to install the selected components. Click Advanced for more options. Property(S): Feature_DlgDesc = Select the program features you want installed. Property(S): Feature_DlgText = Click an icon in the following list to change how a feature is installed. Property(S): Feature_DlgTitle = Feature Selection Property(S): Feature_FeatureFrame = Feature description Property(S): Feature_GroupBox1 = Installation path Property(S): FileInUse_DlgDesc = Some files that need to be updated are currently in use. Property(S): FileInUse_DlgText = The following applications are using files that need to be updated by this setup. Close these applications and click Retry to continue. Property(S): FileInUse_DlgTitle = Files in Use Property(S): InitDlg_Title = Microsoft SQL Server Installation Property(S): InitDlg_Desc = Setup is preparing to continue with the installation. Property(S): InitDlg_Text = Please wait while setup prepares to continue with the installation. Property(S): Instance_Default = &Default instance Property(S): Instance_DlgDesc = You can install a default instance or you can specify a named instance. Property(S): Instance_DlgText = Provide a name for the instance. For a default installation, click Default instance and click Next. To upgrade an existing default instance, click Default instance. To upgrade an existing named instance select Named instance and specify the instance name. Property(S): Instance_DlgText1 = To view a list of existing instances and components click on Installed instances. Property(S): Instance_DlgTitle = Instance Name Property(S): Instance_Named = N&amed instance Property(S): IPAddress_DlgDesc = Enter virtual server information. Property(S): IPAddress_DlgStaticTextClusterIP = Network address: Property(S): IPAddress_DlgStaticTextIPAddress = &IP address: Property(S): IPAddress_DlgStaticTextIPSel = &Selected networks and IP addresses: Property(S): IPAddress_DlgStaticTextNetToUse = N&etwork to use: Property(S): IPAddress_DlgStaticTextSubnet = Network subnet: Property(S): IPAddress_DlgStaticTextVSName = Virtual server name: Property(S): IPAddress_DlgText = Enter an IP address for the virtual server. To add IP addreses for additional networks, click Add. Property(S): IPAddress_DlgTitle = Virtual Server Configuration Property(S): License_Devices = devices Property(S): License_Processors = processors Property(S): LicenseModeDlg_DlgDesc = SQL server supports two client licensing modes: per seat licensing and processor licensing. Property(S): LicenseModeDlg_DlgText = Choose the appropriate licensing modes. Property(S): LicenseModeDlg_DlgText1 = Per seat license: each device that accesses Microsoft SQL Server requires a separate license. Property(S): LicenseModeDlg_DlgText2 = Processor license: each processor on this server requires a separate license. Property(S): LicenseModeDlg_DlgTitle = Licensing Mode Property(S): LicenseModeDlg_Processor = &Processor license for Property(S): LicenseModeDlg_RadioButtonGroup = Licensing mode Property(S): LicenseModeDlg_Seat = Per &seat license for Property(S): Maintenance_ChgLabel = Ch&ange Installed Components Property(S): Maintenance_ChgLabelCl = &Maintain the Virtual Server Property(S): Maintenance_ChgText = Maintain features of this instance. Property(S): Maintenance_ChgTextCl = Add or remove nodes to the virtual server. Property(S): Maintenance_DlgDesc = You can change or remove this instance of SQL Server. Property(S): Maintenance_DlgTitle = Change or Remove Instance Property(S): Maintenance_RmvLabel = R&emove Microsoft SQL Server Property(S): Maintenance_RmvText = Remove all features of this existing installation from your computer. Property(S): Maintenance_RmvTextCl = Remove the virtual server from your cluster. Property(S): Maintenance_ChgLabelResume = Complete the &suspended installation Property(S): Maintenance_ChgTextResume = Complete the suspended installation of Microsoft SQL Server on your computer. Property(S): Progress_DlgDesc1 = The program features you selected are being installed. Property(S): Progress_DlgDesc2 = The Microsoft SQL Server is being removed. Property(S): Progress_DlgDesc3 = Setup is installing the components you selected. Property(S): Progress_DlgDesc4 = The Microsoft SQL Server is being reinstalled. Property(S): Progress_DlgText1 = Please wait while Setup installs Microsoft SQL Server. Installation may take several minutes. Property(S): Progress_DlgText2 = Please wait while Setup removes Microsoft SQL Server. This may take several minutes. Property(S): Progress_DlgText3 = Please wait while Setup updates Microsoft SQL Server. This may take several minutes. Property(S): Progress_DlgText4 = Please wait while Setup reinstalls Microsoft SQL Server. Installation may take several minutes. Property(S): Progress_DlgTitle1 = Installing Microsoft SQL Server Property(S): Progress_DlgTitle2 = Removing Microsoft SQL Server Property(S): Progress_DlgTitle3 = Configuring Microsoft SQL Server Property(S): Progress_DlgTitle4 = Reinstalling Microsoft SQL Server Property(S): Progress_lbStatus = Status: Property(S): Register_CompLabel = C&ompany: Property(S): Register_DlgSpec = The following information will personalize your installation. Property(S): Register_DlgText = The Name field must be filled in prior to proceeding. The Company field is optional. Property(S): Register_DlgText1 = Please enter your 25 character Product Key. You can find this number on the yellow sticker in the CD liner notes or the CD sleeve. Property(S): Register_DlgTitle = Registration Information Property(S): Register_NameLabel = N&ame: Property(S): Resume_ResumeText = Setup will complete the suspended installation of Microsoft SQL Server on your computer. To continue, click Next. Property(S): Resume_TextLine1 = Microsoft SQL Server Installation Wizard Property(S): ServiceAccountDlg_Advanced = &Customize for each service account Property(S): ServiceAccountDlg_Autostart = Start services at the end of setup Property(S): ServiceAccountDlg_AutostartServices = Start services at the end of setup Property(S): ServiceAccountDlg_DlgDesc = Service accounts define which accounts to log in. Property(S): ServiceAccountDlg_DlgTitle = Service Account Property(S): ServiceAccountDlg_Domain = Use a domain use&r account Property(S): ServiceAccountDlg_DomainLabel = &Domain: Property(S): ServiceAccountDlg_BuiltIn = Use the built-in S&ystem account Property(S): ServiceAccountDlg_PasswordLabel = &Password: Property(S): ServiceAccountDlg_Service = S&ervice: Property(S): ServiceAccountDlg_Service1 = Service: Property(S): ServiceAccountDlg_UsernameLabel = &Username: Property(S): Setup = Setup Property(S): StartCopy_DlgDesc = Setup is ready to begin installation. Property(S): StartCopy_DlgDescReinst = Setup is ready to begin reinstallation. Property(S): StartCopy_DlgDescRemove = You have chosen to remove the program from your system. Property(S): StartCopy_DlgDescRemoveCl = You have chosen to remove the program from your cluster. Property(S): StartCopy_DlgDescVSConfig = Setup is ready to begin updating your virtual server. Property(S): StartCopy_DlgText = Setup has enough information to start copying the program files. To proceed, click Install. To change any of your installation settings, click Back. To exit setup, click Cancel. Property(S): StartCopy_DlgText2 = Click Cancel to exit setup. Property(S): StartCopy_DlgTextConfig = Setup has enough information to start installation. Click Install to proceed. Property(S): StartCopy_DlgTextReinstData = You have chosen to re-install all features of existing installation including data files, and therefore overwrite the system database. Click Reinstall to proceed. Property(S): StartCopy_DlgTextReinst = You have chosen to re-install all features of existing installation. Click Reinstall to proceed. Property(S): StartCopy_DlgTextRemove = Click Remove to remove Microsoft SQL Server from your computer. After removal, this program will no longer be available for use. Property(S): StartCopy_DlgTextRemoveCl = Click Remove to remove Microsoft SQL Server from your cluster. After removal, this program will no longer be available for use. Property(S): StartCopy_DlgTextUnchanged = You did not change your virtual server configuration. Property(S): StartCopy_DlgTitle = Ready to Install Property(S): StartCopy_DlgTitleConfig = Ready to Update Property(S): StartCopy_DlgTitleReinst = Ready to Reinstall Property(S): StartCopy_DlgTitleRemove = Remove Microsoft SQL Server Property(S): StaticUserName = Account: Property(S): StaticUserPassword = &Password: Property(S): TextDataDir = &Data files: Property(S): TextProgramFileDir = Program files: Property(S): UpgradeLogon_DlgDesc = Database account for upgrading. Property(S): UpgradeLogon_DlgText = The authentication mode specifies the security used when connecting to SQL Server during database upgrading. Property(S): UpgradeLogon_DlgTitle = Upgrade Logon Information Property(S): UpgradeLogon_Password = &Password: Property(S): UpgradeLogon_SQL = &SQL Server Authentication Mode Property(S): UpgradeLogon_SQLText = Enter SQL Server account: Property(S): UpgradeLogon_UserName = &Username: Property(S): UpgradeLogon_Windows = &Windows Authentication Mode Property(S): UserExit_FinishText1 = To complete installation at another time, please run setup again. Property(S): UserExit_FinishText2 = Click Finish to exit setup. Property(S): UserExit_RestContText1 = You can either keep any existing installed elements on your system to continue this installation at a later time or you can restore your system to its original state prior to the installation. Property(S): UserExit_RestContText2 = Click Restore or Continue Later to exit the installation wizard. Property(S): UserExit_TextLine = Setup was interrupted before Microsoft SQL Server could be completely installed. Property(S): VirtualServer_DlgDesc = The virtual server name must be unique on the network. Property(S): VirtualServer_DlgText = Enter the name of the new virtual server. Property(S): VirtualServer_DlgTitle = Virtual Server Name Property(S): WARNING_QUORUMGROUP1 = You have chosen the group containing the quorum resource. It is strongly recommended that you should not use the quorum group with SQL Server. Property(S): WARNING_QUORUMGROUP2 = Are you sure you want to proceed? Property(S): DWTITLENAME = Microsoft SQL Server Setup Property(S): DWHEADERTEXT = Microsoft SQL Server Setup was unable to install on your computer. Property(S): DWERRORTEXT = Microsoft SQL Server Setup has encountered a problem and will end. Property(S): ErrorDlg_Title = Microsoft SQL Server Setup Property(S): Wait_Title = Please wait... Property(S): Wait_Database = Validating settings. Property(S): Wait_Service = Starting Service: [1] Property(S): Wait_Connect = Validating database access on SQL Server [1]. Property(S): ErrorReporting_DlgDesc = Help Microsoft improve some of the SQL Server 2005 components and services. Property(S): ErrorReporting_DlgText1 = For more information on the error reporting feature and the type of information sent, click Help. Property(S): ErrorReporting_DlgText1_Property = ErrorReporting_DlgText1 Property(S): ErrorReporting_DlgText1_Express = By installing Microsoft SQL Server 2005, SQL Server and its components will be configured to automatically send fatal service error reports to Microsoft or a Corporate Error Reporting Server. Microsoft uses error reports to improve SQL Server functionality, and treats all information as confidential. Property(S): ErrorReporting_DlgTitle = Error and Usage Report Settings Property(S): ErrorReporting_CheckBox = &Automatically send Error reports for SQL Server 2005 to Microsoft or your corporate error reporting server. Error reports include information regarding the condition of SQL Server 2005 when an error occurred, your hardware configuration and other data. Error reports may unintentionally include personal information, which will not be used by Microsoft. Property(S): ErrorReporting_SQM_CheckBox = Automatically send &Feature Usage data for SQL Server 2005 to Microsoft. Usage data includes anonymous information about your hardware configuration and how you use our software and services. Property(S): EnableRanu_DlgDesc = Configure Run As Normal User mode. Property(S): EnableRanu_DlgText1 = Allow users who do not have administrator privileges to run a separate instance of the Database Engine. Property(S): EnableRanu_DlgText1_Property = EnableRanu_DlgText1 Property(S): EnableRanu_DlgTitle = User Instances Property(S): EnableRanu_CheckBox = &Enable User Instances Property(S): BrowseFolder_VolumeList = Program files must be installed on a valid local disk available on all cluster nodes. The volumes values are: Property(S): ProductClash_DlgTitle = Existing components Property(S): ProductClash_DlgDesc = Components have been found on the machine. Select upgrade options below. Property(S): ProductClash_DlgText = The following components that you chose to install are already installed on the machine. To view a report of available options and alternatives click on Details. Property(S): ProductClash_Detail = &Details... Property(S): ProductClash_Warning = Components shared between SQL Server instances will be removed if they belong only to the SQL Server instance being upgraded. Property(S): ProductClash_LegacyTools = Management Tools Property(S): ProductClash_LegacyDTS = Data Transformation Services Property(S): DetailDlg_DlgTitle = Installation options Property(S): DetailDlg_DlgDesc = The list below shows installed components and upgrade options. Property(S): InstanceListDlg_DlgTitle = Installed instances Property(S): InstanceListDlg_DlgDesc = The list below contains all existing instances and components installed on this machine. Property(S): InstanceListDlg_InstanceListText = To view details for an installed instance, select an instance from the list below. To proceed, select the instance name to upgrade and click OK. Property(S): InstanceListDlg_TypeText = Type: Property(S): InstanceListDlg_VersionText = Version: Property(S): InstanceListDlg_EditionText = Edition: Property(S): InstanceListDlg_LanguageText = Language: Property(S): InstanceListDlg_DetailGroup = Installed Instance Details Property(S): Instance_Instances = &Installed instances Property(S): Product_YukonServer = Yukon Server Property(S): Product_SQLServer = SQL Server Property(S): Product_AnalysisServices = Analysis Services Property(S): Product_ReportServer = Reporting Services Property(S): ProductClash_Maintain = (Cannot maintain product, to maintain the product go to Add or Remove Programs) Property(S): ProductClash_Upgrade = (Cannot upgrade product, to maintain the product go to Add or Remove Programs) Property(S): ProductClash_UpgradeAsVS = (Upgrade product to Virtual Server) Property(S): ProductClash_Virtualize = (Cannot virtualize product) Property(S): Detail_Name = Name: Property(S): Detail_AllowedAction = Allowed Action: Property(S): Detail_Reason = Reason: Property(S): Detail_Warning = Warning: Property(S): Detail_ActionMaintain = Maintain (Action is only available from Add or Remove Programs) Property(S): Detail_ReasonMaintain = Cannot maintain product, to maintain the product go to Add or Remove Programs Property(S): Detail_ActionUpgrade = Upgrade Property(S): Detail_ReasonUpgrade = Product can be upgraded to a new version Property(S): Detail_ActionNone = None Property(S): Detail_ReasonNoVirtualize = Product cannot be virtualized Property(S): Detail_ReasonNone = Upgrades are not supported yet Property(S): Detail_ReasonBlock = Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Property(S): Detail_ReasonRemoveDTS = The SQL Server instance you are upgrading includes Data Transformation Services. Following the upgrade, Data Transformation Services will be removed unless there are other SQL Server instances installed that share it. Click on help for more information. Property(S): Detail_ReasonRemoveTools = The SQL Server instance you are upgrading includes SQL Server Management Tools. Following the upgrade, previous versions of SQL Server Management Tools will be removed unless there are other SQL Server instances installed that share them. Do not use previous versions of SQL Server Management Tools with SQL Server 2005. Instead, use SQL Server 2005 Management Tools included in the SQL Server 2005 Workstation Components feature. Property(S): SampleDatabase_DlgDesc = Configure how the sample databases are installed. Property(S): SampleDatabase_DlgText = Specify a method to install the sample databases to an existing instance of SQL Server. To attach the sample databases, you must have permissions to create databases on the specified instance. Property(S): SampleDatabase_DlgTitle = Sample Databases Setup Property(S): SampleDatabase_ServerText = &SQL Server instance: Property(S): SampleDatabase_Install = &Install sample databases without attaching Property(S): SampleDatabase_Attach = Install and &attach sample databases Property(S): Report_ActionUpgrade = Upgrade Property(S): Report_ActionVirtualize = Virtualize Property(S): Report_InstallTitle = The following components will be installed: Property(S): Report_BlockTitle = The following components that you selected will not be changed: Property(S): Report_WarnSPTitle = Warning: Setup found that the following components that already exist are at a different service pack level than the components being installed. Property(S): Report_WarnSPCompList = Components: Property(S): Report_WarnSPTail = After completing setup, you must download and apply the latest SQL Server 2005 service pack to all the components. Property(S): UpgradeTools = Upgrading tools [1] Property(S): UpgradeRepl = Upgrading replication [1] Property(S): UpgradeEngine = Upgrading SQL Engine [1] Property(S): UpgradeDTS = Upgrading DTS [1] Property(S): HideAdvancedOptionsText = Hi&de advanced configuration options Property(S): ArpProductDispayName = Microsoft SQL Server 2005 Property(S): Built_inLocalSystem = Local system Property(S): Built_inNetworkService = Network service Property(S): Built_inLocalService = Local service Property(S): Wait_UpgradeBlocker_Title = Analyzing Upgrade Property(S): Wait_UpgradeBlocker_Status = Validating Upgrade Options. Property(S): UpgradeBlockerDlg_DlgDesc = The following issues currently block upgrading to SQL Server 2005 Property(S): UpgradeBlockerDlg_DlgTitle = Upgrade Blocked Property(S): UpgradeBlockerDlg_UAWarning = For assistance in resolving these issues, run Upgrade Advisor. You can install Upgrade Advisor from the SQL Server 2005 Setup Splash Screen. Property(S): DomainGroup_DlgTitle = Domain Groups for Clustered Services Property(S): DomainGroup_DlgText = The startup account for each clustered service will be added to the DomainNameGroupName to set its access control. Enter the name of existing DomainNameGroupName for each clustered service being installed. For additional information, click Help. Property(S): DomainGroup_Browse = ... Property(S): DomainGroupDlg_Service = Service Name Property(S): DomainGroupDlg_Group = DomainNameGroupName Property(S): SqlDomainGroup_SQL = &SQL Server Property(S): SqlDomainGroup_AGT = S&QL Server Agent Property(S): SqlDomainGroup_FTS = &Full-Text Search Property(S): SqlDomainGroup_AS = &Analysis Services Property(S): SqlDomainGroupService_SQL = SQL Server Property(S): SqlDomainGroupService_AGT = SQL Server Agent Property(S): SqlDomainGroupService_FTS = Full-Text Search Property(S): SqlDomainGroupService_AS = Analysis Services Property(S): SqlSortId030 = Binary order, for use with the 437 (U.S. English) Character Set. Property(S): SqlSortId031 = Dictionary order, case-sensitive, for use with the 437 (U.S. English) Character Set. Property(S): SqlSortId032 = Dictionary order, case-insensitive, for use with the 437 (U.S. English) Character Set. Property(S): SqlSortId033 = Dictionary order, case-insensitive, uppercase preference, for use with the 437 (U.S. English) Character Set. Property(S): SqlSortId034 = Dictionary order, case-insensitive, accent-insensitive, for use with the 437 (U.S. English) Character Set. Property(S): SqlSortId035 = Binary order based on code point comparison, for use with the 437 (U.S. English) Character Set. Property(S): SqlSortId040 = Binary order, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId041 = Dictionary order, case-sensitive, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId042 = Dictionary order, case-insensitive, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId043 = Dictionary order, case-insensitive, uppercase preference, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId044 = Dictionary order, case-insensitive, accent-insensitive, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId045 = Binary order based on code point comparison, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId049 = Strict compatibility with version 1.x case-insensitive databases, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId051 = Dictionary order, case-sensitive, for use with 1252 Character Set. Property(S): SqlSortId052 = Dictionary order, case-insensitive, for use with 1252 Character Set. Property(S): SqlSortId053 = Dictionary order, case-insensitive, uppercase preference, for use with 1252 Character Set. Property(S): SqlSortId054 = Dictionary order, case-insensitive, accent-insensitive, for use with 1252 Character Set. Property(S): SqlSortId055 = Alternate dictionary order, case-sensitive, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId056 = Alternate dictionary order, case-insensitive, uppercase preference, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId057 = Alternate dictionary order, case-insensitive, accent-insensitive, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId058 = Scandinavian dictionary order, case-insensitive, uppercase preference, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId059 = Scandinavian dictionary order, case-sensitive, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId060 = Scandinavian dictionary order, case-insensitive, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId061 = Alternate dictionary order, case-insensitive, for use with the 850 (Multilingual) Character Set. Property(S): SqlSortId081 = Dictionary order, case-sensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId082 = Dictionary order, case-insensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId083 = Czech dictionary order, case-sensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId084 = Czech dictionary order, case-insensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId085 = Hungarian dictionary order, case-sensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId086 = Hungarian dictionary order, case-insensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId087 = Polish dictionary order, case-sensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId088 = Polish dictionary order, case-insensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId089 = Romanian dictionary order, case-sensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId090 = Romanian dictionary order, case-insensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId091 = Croatian dictionary order, case-sensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId092 = Croatian dictionary order, case-insensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId093 = Slovak dictionary order, case-sensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId094 = Slovak dictionary order, case-insensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId095 = Slovenian dictionary order, case-sensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId096 = Slovenian dictionary order, case-insensitive, for use with the 1250 (Central European) Character Set. Property(S): SqlSortId105 = Dictionary order, case-sensitive, for use with the 1251 (Cyrillic) Character Set. Property(S): SqlSortId106 = Dictionary order, case-insensitive, for use with the 1251 (Cyrillic) Character Set. Property(S): SqlSortId107 = Ukrainian dictionary order, case-sensitive, for use with the 1251 (Cyrillic) Character Set. Property(S): SqlSortId108 = Ukrainian dictionary order, case-insensitive, for use with the 1251 (Cyrillic) Character Set. Property(S): SqlSortId113 = Dictionary order, case-sensitive, for use with the 1253 (Greek) Character Set. Property(S): SqlSortId114 = Dictionary order, case-insensitive, for use with the 1253 (Greek) Character Set. Property(S): SqlSortId120 = Mixed dictionary order, for use with the 1253 (Greek) Character Set. Property(S): SqlSortId121 = Dictionary order, case-sensitive, accent-sensitive, for use with the 1253 (Greek) Character Set. Property(S): SqlSortId122 = Dictionary order, case-sensitive, accent-sensitive, for use with the 1253 (Greek) Character Set. Property(S): SqlSortId124 = Dictionary order, case-insensitive, accent-insensitive, for use with the 1253 (Greek) Character Set. Property(S): SqlSortId129 = Dictionary order, case-sensitive, for use with the 1254 (Turkish) Character Set. Property(S): SqlSortId130 = Dictionary order, case-insensitive, for use with the 1254 (Turkish) Character Set. Property(S): SqlSortId137 = Dictionary order, case-sensitive, for use with the 1255 (Hebrew) Character Set. Property(S): SqlSortId138 = Dictionary order, case-insensitive, for use with the 1255 (Hebrew) Character Set. Property(S): SqlSortId145 = Dictionary order, case-sensitive, for use with the 1256 (Arabic) Character Set. Property(S): SqlSortId146 = Dictionary order, case-insensitive, for use with the 1256 (Arabic) Character Set. Property(S): SqlSortId153 = Dictionary order, case-sensitive, for use with the 1257 (Baltic) Character Set. Property(S): SqlSortId154 = Dictionary order, case-insensitive, for use with the 1257 (Baltic) Character Set. Property(S): SqlSortId155 = Estonian dictionary order, case-sensitive, for use with the 1257 (Baltic) Character Set. Property(S): SqlSortId156 = Estonian dictionary order, case-insensitive, for use with the 1257 (Baltic) Character Set. Property(S): SqlSortId157 = Latvian dictionary order, case-sensitive, for use with the 1257 (Baltic) Character Set. Property(S): SqlSortId158 = Latvian dictionary order, case-insensitive, for use with the 1257 (Baltic) Character Set. Property(S): SqlSortId159 = Lithuanian dictionary order, case-sensitive, for use with the 1257 (Baltic) Character Set. Property(S): SqlSortId160 = Lithuanian dictionary order, case-insensitive, for use with the 1257 (Baltic) Character Set. Property(S): SqlSortId183 = Danish/Norwegian dictionary order, case-insensitive, uppercase preference, for use with 1252 Character Set. Property(S): SqlSortId184 = Swedish/Finnish (Phone) dictionary order, case-insensitive, uppercase preference, for use with 1252 Character Set. Property(S): SqlSortId185 = Swedish/Finnish (Standard) dictionary order, case-insensitive, uppercase preference, for use with 1252 Character Set. Property(S): SqlSortId186 = Icelandic dictionary order, case-insensitive, uppercase preference, for use with 1252 Character Set. Property(S): StdSku = 1 Property(S): UpgradeCode = {929C9FEC-8873-4A1A-A209-9AF432E8E1D1} Property(S): SqlPackageId = 1 Property(S): ProductName = Microsoft SQL Server 2005 Property(S): ProductNameSetup = Microsoft SQL Server 2005 Setup Property(S): RemoveFeatureList = SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,SQL_SharedTools,SQL_BC_DEP Property(S): ROOTDRIVE = D: Property(S): ValidMOFInstanceName = 1 Property(S): PIDRET = 0 Property(S): DPID = ********** Property(S): PID = ********** Property(S): PIDSEQ = 271000003 Property(S): PKU = 0 Property(S): CCPTrigger = 2 Property(S): SqlPerfMonRegKey = SQLCTR Property(S): SqlSubDir = MSSQL Property(S): InstanceSubDir = MSSQL.1 Property(S): Namechecksum.7354AFCB_913B_4E9F_B76C_2376101FDE0C = Standard Edition Property(S): Namechecksum.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = Standard Edition Property(S): QuotedServiceGroupAgent.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF = IECDC-WIAS169SQLServer2005SQLAgentUser$IECDC-WIAS169$MSSQLSERVER Property(S): QuotedServiceGroupADHelper.2C8E638F_C982_4AA5_A173_7148A8E8649D = IECDC-WIAS169SQLServer2005MSSQLServerADHelperUser$IECDC-WIAS169 Property(S): QuotedServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 = IECDC-WIAS169SQLServer2005SQLBrowserUser$IECDC-WIAS169 Property(S): QuotedServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE = IECDC-WIAS169SQLServer2005SQLBrowserUser$IECDC-WIAS169 Property(S): QuotedServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 = IECDC-WIAS169SQLServer2005SQLBrowserUser$IECDC-WIAS169 Property(S): InstId = MSSQL.1 Property(S): PreviousInstId = MSSQL.1 Property(S): SqlLegacyRegPath = MSSQLServer Property(S): SqlOriginalMachineName = IECDC-WIAS169 Property(S): RSSqlPoolLimit = 150 Property(S): RSGUIDVALUE = {97ba1f98-43fe-42dd-8a0d-ff40868ebe16} Property(S): ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2 = C:Program Files Property(S): ModuleID_SQLBASE = D20239D7_E87C_40C9_9837_E70B8D4882C2 Property(S): SQLAUTOSTART = 1 Property(S): InstanceName.D20239D7_E87C_40C9_9837_E70B8D4882C2 = MSSQLSERVER Property(S): RSPREREQUISITECHECKED = 1 Property(S): SqlCOMPlusInstalled = 1 Property(S): SqlASPNETInstalled = 1 Property(S): ProgramMenuFolder.ConfigurationTools1033 = C:Documents and SettingsAll UsersStart MenuPrograms Property(S): SqlDefaultWebSite = /W3SVC/1 Property(S): SqlIISInstalled = 1 Property(S): IISCHECKED = 1 Property(S): SCMLocalServiceAccount = NT AUTHORITYLocalService Property(S): SCMNetworkServiceAccount = NT AUTHORITYNetworkService Property(S): PerformanceLogUsersGroup = BUILTINPerformance Log Users Property(S): PerformanceMontiorUsersGroup = BUILTINPerformance Monitor Users Property(S): DW20PATH_CPUTYPEX86 = X86 Property(S): QuotedComputerName = IECDC-WIAS169 Property(S): QuotedDefaultDomain = VF-IE Property(S): DW20PATH_X86.8D56D6B0_25DE_4471_A64F_717FC5AB6330 = C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE Property(S): DefaultDomain = VF-IE Property(S): WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E = C:WINDOWS Property(S): SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E = C:WINDOWSsystem32 Property(S): WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E = C:WINDOWS Property(S): SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E = C:WINDOWSsystem32 Property(S): WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E = C:WINDOWS Property(S): SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E = C:WINDOWSsystem32 Property(S): WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E = C:WINDOWS Property(S): SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E = C:WINDOWSsystem32 Property(S): WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E = C:WINDOWS Property(S): SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E = C:WINDOWSsystem32 Property(S): WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E = C:WINDOWS Property(S): SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E = C:WINDOWSsystem32 Property(S): WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E = C:WINDOWS Property(S): SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E = C:WINDOWSsystem32 Property(S): WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E = C:WINDOWS Property(S): SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E = C:WINDOWSsystem32 Property(S): ACTION = INSTALL Property(S): Preselected = 1 Property(S): UILevel = 2 Property(S): ServicePrefixRS.6080319C_1466_426E_9E7A_1DD555143E0A = SQLServer2005ReportServerUser$IECDC-WIAS169$ Property(S): ServicePrefixSSIS.6080319C_1466_426E_9E7A_1DD555143E0A = SQLServer2005DTSUser$IECDC-WIAS169 Property(S): OriginalDatabase = D:MSMSQLServer2005ServersSetupSqlRun_SQL.msi Property(S): DATABASE = C:WINDOWSInstallerd5f48.msi Property(S): Privileged = 1 Property(S): RedirectedDllSupport = 2 Property(S): MsiWin32AssemblySupport = 5.2.3790.1830 Property(S): MsiNetAssemblySupport = 2.0.50727.42 Property(S): Date = 22/02/2007 Property(S): Time = 15:34:23 Property(S): TTCSupport = 1 Property(S): ColorBits = 32 Property(S): TextHeight = 16 Property(S): BorderSide = 1 Property(S): BorderTop = 1 Property(S): CaptionHeight = 19 Property(S): ScreenY = 768 Property(S): ScreenX = 1024 Property(S): SystemLanguageID = 6153 Property(S): ComputerName = IECDC-WIAS169 Property(S): UserLanguageID = 6153 Property(S): UserSID = S-1-5-21-1275210071-484763869-725345543-115600 Property(S): LogonUser = manncol_srvadm Property(S): AdminUser = 1 Property(S): VirtualMemory = 7379 Property(S): PhysicalMemory = 3928 Property(S): SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F = C:WINDOWSsystem32 Property(S): Intel = 15 Property(S): ShellAdvtSupport = 1 Property(S): OLEAdvtSupport = 1 Property(S): GPTSupport = 1 Property(S): FontsFolder = C:WINDOWSFonts Property(S): ModuleID_SQLBRWS = 2FC2D269_8625_4826_B
I have a project that consists of a SQL db with an Access front end as the user interface. Here is the structure of the table on which this question is based:
Code Block
create table #IncomeAndExpenseData ( recordID nvarchar(5)NOT NULL, itemID int NOT NULL, itemvalue decimal(18, 2) NULL, monthitemvalue decimal(18, 2) NULL ) The itemvalue field is where the user enters his/her numbers via Access. There is an IncomeAndExpenseCodes table as well which holds item information, including the itemID and entry unit of measure. Some itemIDs have an entry unit of measure of $/mo, while others are entered in terms of $/yr, others in %/yr.
For itemvalues of itemIDs with entry units of measure that are not $/mo a stored procedure performs calculations which converts them into numbers that has a unit of measure of $/mo and updates IncomeAndExpenseData putting these numbers in the monthitemvalue field. This stored procedure is written to only calculate values for monthitemvalue fields which are null in order to avoid recalculating every single row in the table.
If the user edits the itemvalue field there is a trigger on IncomeAndExpenseData which sets the monthitemvalue to null so the stored procedure recalculates the monthitemvalue for the changed rows. However, it appears this trigger is also setting monthitemvalue to null after the stored procedure updates the IncomeAndExpenseData table with the recalculated monthitemvalues, thus wiping out the answers.
How do I write a trigger that sets the monthitemvalue to null only when the user edits the itemvalue field, not when the stored procedure puts the recalculated monthitemvalue into the IncomeAndExpenseData table?
SQL server 20005 SP2 is install in my WIN XP machine. I implement a SSRS report and try to deliver the report to a share folder in window 2000 server.
I create and set permissions on a shared folder as per the information in http://msdn2.microsoft.com/en-us/library/ms345228.aspx. The account that I use in subscription is local admin account in the target machine.
I have try path \<servername>c$XXX and \<servername>XXX. Both is not ok.
I find following error message in the log file of reporting service.
ReportingServicesService!library!d!04/29/2008-00:03:40:: e ERROR: Throwing Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid., A logon error occurred when attempting to access the file share. The user account or password is not valid.; Info: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword) at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd) --- End of inner exception stack trace ---
If I try to deliver same report to a share folder in WIN XP in the same way. It is ok.
Situation: In this stored procedure, I have to calculate in some manner: Font, FontSize, BoldText, ShowBox and number of characters to see how many lines it will take on a Crystal Report. Wondering if you have seen some like this on Web or have an ideas? Measurements(length, width) and character count seem appropriate. How about a function?
Can anyone help me with a problem I have with SSRS 2005? How do I configure SQL Server 2005 Reporting Services to deliver subscription e-mails to addresses external to my windows domain?
I've been having trouble configuring the Report Server e-mail delivery component to send subscription e-mails to addresses outside the domain on which the report server is hosted.
For e.g. since my local windows domain is named "smartsystems.com", I have found that the Report Manager does not have any problems sending subscription mails to "eawagu@smartsystems.com" but throws up an error whenever I include "eawagu@yahoo.com" in the recipients' list.
Hi... I have data that i am getting through a dbf file. and i am dumping that data to a sql server... and then taking the data from the sql server after scrubing it i put it into the production database.. right my stored procedure handles a single plan only... but now there may be two or more plans together in the same sql server database which i need to scrub and then update that particular plan already exists or inserts if they dont...
this is my sproc... ALTER PROCEDURE [dbo].[usp_Import_Plan] @ClientId int, @UserId int = NULL, @HistoryId int, @ShowStatus bit = 0-- Indicates whether status messages should be returned during the import.
AS
SET NOCOUNT ON
DECLARE @Count int, @Sproc varchar(50), @Status varchar(200), @TotalCount int
SET @Sproc = OBJECT_NAME(@@ProcId)
SET @Status = 'Updating plan information in Plan table.' UPDATE Statements..Plan SET PlanName = PlanName1, Description = PlanName2 FROM Statements..Plan cp JOIN ( SELECT DISTINCT PlanId, PlanName1, PlanName2 FROM Census ) c ON cp.CPlanId = c.PlanId WHERE cp.ClientId = @ClientId AND ( IsNull(cp.PlanName,'') <> IsNull(c.PlanName1,'') OR IsNull(cp.Description,'') <> IsNull(c.PlanName2,'') )
SET @Count = @@ROWCOUNT IF @Count > 0 BEGIN SET @Status = 'Updated ' + Cast(@Count AS varchar(10)) + ' record(s) in ClientPlan.' END ELSE BEGIN SET @Status = 'No records were updated in Plan.' END
SET @Status = 'Adding plan information to Plan table.' INSERT INTO Statements..Plan ( ClientId, ClientPlanId, UserId, PlanName, Description ) SELECT DISTINCT @ClientId, CPlanId, @UserId, PlanName1, PlanName2 FROM Census WHERE PlanId NOT IN ( SELECT DISTINCT CPlanId FROM Statements..Plan WHERE ClientId = @ClientId AND ClientPlanId IS NOT NULL )
SET @Count = @@ROWCOUNT IF @Count > 0 BEGIN SET @Status = 'Added ' + Cast(@Count AS varchar(10)) + ' record(s) to Plan.' END ELSE BEGIN SET @Status = 'No information was added Plan.' END
SET NOCOUNT OFF
So how do i do multiple inserts and updates using this stored procedure...
I was trying to extract data from the source server using OLEDB Source and SQL Server Destination when i encountered this error:
"Transaction (Process ID 135) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.".
What must be done so that even if the table being queried is locked, i wouldn't experience any deadlock?
Hello all, I am running into an interesting scenario on my desktop. I'm running developer edition on Windows XP Professional (9.00.3042.00 SP2 Developer Edition). OS is autopatched via corporate policy and I saw some patches go in last week. This machine is also a hand-me-down so I don't have a clean install of the databases on the machine but I am local admin.
So, starting last week after a forced remote reboot (also a policy) I noticed a few of the databases didn't start back up. I chalked it up to the hard shutdown and went along my merry way. Friday however I know I shut my machine down nicely and this morning when I booted up, I was in the same state I was last Wenesday. 7 of the 18 databases on my machine came up with
FCB:pen: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred while creating or opening file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf'. Diagnose and correct the operating system error, and retry the operation. and it also logs FCB:pen failed: Could not open file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.).
I've caught references to the auto close feature being a possible culprit, no dice as the databases in question are set to False. Recovery mode varies on the databases from Simple to Full. If I cycle the SQL Server service, whatever transient issue it was having with those files is gone. As much as I'd love to disable the virus scanner, network security would not be amused. The data and log files appear to have the same permissions as unaffected database files. Nothing's set to read only or archive as I've caught on other forums as possible gremlins. I have sufficient disk space and the databases are set for unrestricted growth.
Any thoughts on what I could look at? If it was everything coming up in RECOVERY_PENDING it's make more sense to me than a hit or miss type of thing I'm experiencing now.
Dear list Im designing a package that uses Microsofts preplog.exe to prepare web log files to be imported into SQL Server
What Im trying to do is convert this cmd that works into an execute process task D:SSIS ProcessPrepweblogProcessLoad>preplog ex.log > out.log the above dos cmd works 100%
However when I use the Execute Process Task I get this error [Execute Process Task] Error: In Executing "D:SSIS ProcessPrepweblogProcessLoadpreplog.exe" "" at "D:SSIS ProcessPrepweblogProcessLoad", The process exit code was "-1" while the expected was "0".
There are two package varaibles User::gsPreplogInput = ex.log User::gsPreplogOutput = out.log
How do I use the execute process task? I am trying to unzip the file using the freeware PZUnzip.exe and I tried to place the entire command in a batch file and specified the working directory as the location of the batch file, but the task fails with the error:
SSIS package "IngramWeeklyPOS.dtsx" starting.
Error: 0xC0029151 at Unzip download file, Execute Process Task: In Executing "C:ETLPOSDataIngramWeeklyUnzip.bat" "" at "C:ETLPOSDataIngramWeekly", The process exit code was "1" while the expected was "0".
Then I tried to specify the exe directly in the Executable property and the agruments as the location of the zip file and the directory to unzip the files in, but this time it fails with the following message:
SSIS package "IngramWeeklyPOS.dtsx" starting.
Error: 0xC002F304 at Unzip download file, Execute Process Task: An error occurred with the following error message: "%1 is not a valid Win32 application".
The command in the batch file when run from the command line works perfectly and unzips the file, so there is absolutely no problem with the command, I believe it is just the set up of the variables on the execute process task editor under Process. Any input on resolving this will be much appreciated.
I am designing a utility which will keep two similar databases in sync. In other words, copying the new data from db1 to db2 and updating the old data from db1 to db2.
For this I am making use of the 'Tablediff' utility which when provided with server name, database, table info will generate .sql file which can be used to keep the target table in sync with the source table.
I am using the Execute Process Task and the process parameters I am providing are:
The customer.bat file will have the following code: tablediff -sourceserver "LV-SQL5" -sourcedatabase "TC_CTI" -sourcetable "CUSTOMER_1" -destinationserver "LV-SQL2" -destinationdatabase "TC_CTI" -destinationtable "CUSTOMER" -f "c:SQL_bat_Filessql5TC_CTIsql_filescustomer1"
the .sql file will be generated at: C:SQL_bat_Filessql5TC_CTIsql_filescustomer1.
The Problem: The Execute Process Task is working fine, ie., the tables are being compared correctly and the .SQL file is being generated as desired. But the task as such is reporting faliure with the following error :
[Execute Process Task] Error: In Executing "C:SQL_bat_FilesSQL5TC_CTIpackage_occurrence.bat" "" at "C:Program Files (x86)Microsoft SQL Server90COM", The process exit code was "2" while the expected was "0". ]
Some of you may suggest to just set the ForceExecutionResult = Success (infact this is what I am doing now just to get the program working), but, this is not what I desire.
I'm pulling data from Oracle db and load into MS-SQL 2008.For my data type checks during the data load process, what are options to ensure that the data being processed wouldn't fail. such that I can verify first in-hand with the target type of data and then if its valid format load it into destination table else mark it with error flag and push into errors table... All this at the row level.One way I can think of is to load into a staging table then get the source & destination table -column data types, compare them and proceed.
should I just try loading the data directly and if it fails try trouble shooting(which could be a difficult task as I wouldn't know what caused error...)
I am having this table locking issue that I need to start paying attention to as its getting more frequent.
The problem is that the data in the tables is live finance data that needs to be changed and viewed almost real time so what I have picked up so far is that using 'table Hints' may not be a good idea.
I have a guy at work telling me that introducing a data access layer is the only way to solve this, I am not convinced but havnt enough knowledge to back my own feeling up. (asp system not .net).
Hi, I'm trying to upload the ASPNETDB.MDF file to a hosting server via FTP, and everytime when it was uploaded half way(40% or 50%) I would get an error message saying: "550 ASPNETDB.MDF: The process cannot access the file because it is being used by another process" and then the upload failed. I'm using SQL Express. Does anybody know what's the cause? Thanks a lot
