Distributed Install - Connection Error
Jan 27, 2007
we have a sql server 2005 reporting services distributed installation
db server has: sqldb01dev, sqldb01 st, sqldb01eta
web server is TestWeb01. This had dev, tst, beta installations of report server
all reports are working ok except on beta. Beta was setup just a couple days ago so it has not worked thus far.
all reports use a shared data source on beta(just like on dev and tst)
here is the error on beta for all the reports:
any idea? (SQLDB01_DEV is not the shared data source name. SQLDB01_DEV was used by the developer when creating the report. But this should not matter right? The report should ignore this and use the shared data source i assume?)
An error has occurred during report processing.
Cannot create a connection to data source 'SQLDB01_DEV'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
View 4 Replies
ADVERTISEMENT
Feb 29, 2008
Hi all,
can anyone tell me if an oleDb connection (provider is Jet 4.0 to Access database) can be enlisted in a Distributed Transaction?
The goal is to copy data from SqlServer to Access within a transaction.
Pier
View 10 Replies
View Related
Aug 30, 2006
I am getting the following error when with SQL Express.SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online. While I was very please to see such a verbose error and directions on where to find the answer I have yet to figure out how to turn this option on... I tried sp_configure 'Ad Hoc Distributed Queries', 1 but got the following error The configuration option 'Ad Hoc Distributed Queries' does not exist, or it may be an advanced option.If I execute only sp_configure it does not list Ad Hoc Distributied Queries as an option. I checked the sql Books Online and it tells me to use the Surface configuration tool which SQL Express does not seem to have.... Could someone help me out with this?Thanks - Mark
View 3 Replies
View Related
Mar 9, 2004
Hi, I have configured a linked server, and i have a procedure which makes an UPDATE in a local table using the data in the linked server.
Specifically, I have a function which checks if a given code exists in a linked server's table. The UPDATE changes the value of a column in a local table, if the function returns 1.
I've run the procedure and it gave an error after a few hours cause a simple conversion error inside the function. I solved the error. After this, the procedure did not work more. It gives me the following message:
Server: Msg 7391, Level 16, State 1, Procedure EXISTEONC, Line 16
The operation could not be performed because the OLE DB provider 'MSDASQL'
was unable to begin a distributed transaction.
(EXISTEONC is the function, and in the line 16 there is an OPENQUERY)
Im sure MSDTC is working... i'm lost because i dont know why it worked the first time and not now. Ive also wrote the function again as it was before, but it still doesent works.
Thanks a lot...
View 6 Replies
View Related
Nov 2, 2005
i have two remote servers connected to each other through the linked servers.
i can run querries or even perform inserts as far as its not inside a transaction
but when i am trying to run distribted transaction but it keeps on returning the same msg.
Server: Msg 7391, Level 16, State 1, Line 3
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
i have configured the firewall, made sure the DTC service is started on both and enabled. they both have the same Sp packs, same config.
View 2 Replies
View Related
Dec 14, 2006
I have a stored procedure in SQL2005 that queries and updates a linked oracle server. The sp runs fine from Management Studio, but when called by a CLR trigger I get the following error message:
Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x000000000000000032DD00000000, Command ID: 1)
Error messages:
The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE_LINK" was unable to begin a distributed transaction. (Source: MSSQLServer, Error number: 7391)
Get help: http://help/7391
The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE_LINK" was unable to begin a distributed transaction. (Source: MSSQLServer, Error number: 7391)
Get help: http://help/7391
A .NET Framework error occurred during execution of user defined routine or aggregate 'PriorityTrigger':
System.Data.SqlClient.SqlException: The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE_LINK" was unable to begin a distributed transaction.
Changed database context to 'pims'.
OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE_LINK" returned message "New transaction cannot enlist in the specified transaction coordinator. ".
System.Data.S (Source: MSSQLServer, Error number: 6549)
Get help: http://help/6549
Any thoughts or direction appreciated
Richard
View 4 Replies
View Related
Oct 13, 2006
Here is the full message from the Event Log.
Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.
Any ideas as to how to troubleshoot or solve this?
Thanks!
View 3 Replies
View Related
Nov 14, 2007
Hi, I am working on vs2005 with sql server 2000. I have used TransactionScope class. Example Reference: http://www.c-sharpcorner.com/UploadFile/mosessaur/TransactionScope04142006103850AM/TransactionScope.aspx The code is given below. using System.Transactions; protected void Page_Load(object sender, EventArgs e) { System.Transactions.TransactionOptions transOption = new System.Transactions.TransactionOptions(); transOption.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; transOption.Timeout = new TimeSpan(0, 2, 0); using (System.Transactions.TransactionScope tranScope = new System.Transactions.TransactionScope(TransactionScopeOption.Required,transOption)) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["nwConnString"].ConnectionString)) { int i; con.Open(); SqlCommand cmd = new SqlCommand("update products set unitsinstock=100 where productid=1", con); i = cmd.ExecuteNonQuery(); if (i > 0) { using (SqlConnection conInner = new SqlConnection(ConfigurationManager.ConnectionStrings["pubsConnString"].ConnectionString)) { conInner.Open(); SqlCommand cmdInner = new SqlCommand("update Salary set sal=5000 where eno=1", conInner); i = cmdInner.ExecuteNonQuery(); if (i > 0) { tranScope.Complete(); // this statement commits the executed query. } } } } // Dispose TransactionScope object, to commit or rollback transaction. } } It gives error like
"The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)" The database I have used is northwind database and pubs database which is by default in sql server 2000. So, Kindly let me know how to proceed further. Thanks in advance,Arun.
View 1 Replies
View Related
Apr 12, 2007
Hello
TestMachine1 runs SQL2005 SP2 and has as linked server myRemoteServer (SQL2000) server. I run an stored procedure in TestMachine1 which inserts about 20,000 rows to a table in myRemoteServer and brings back a similar quantity of rows. This stored procedures take about 1.5min to complete, but no error appears.
When running the same stored procedure in TestMachine2 (also SQL2005SP2), the following error appears after about 1 minute of execution (not the exact text):
SQLNCli. TCP Provider: network name is no longer available - communication link failure.
Please note that this stored procedure worked before on TestMachine2 (but with less than 10,000 rows) and that connectivity is proven among TestMachine1 and myRemoteServer, since I can execute "select * from synonym_MyRemoteTable" with no problems at all in the TestMachine2's Management Studio.
TestMachine1 and TestMachine2 have Windows XP Professional SP2; myRemoteServer has Windows 2003 and SQL Server 2000 SP4.
Can you please help me to avoid this error?
View 1 Replies
View Related
Nov 14, 2007
Hi,
I've tried looking for a solution in other threads but I couldn't find anything that was completely the same as my situation. I got a new pc at work and I've tried installing SQL Server 2005 on it but everytime I try to install it, regardless of services included or excluded with the install, I cannot get through the install without this error. Below is the excerpt from the Summary.txt log file.
Error Code: -2147024894
MSI (s) (74!98) [17:10:55:858]: Product: Microsoft SQL Server 2005 Tools -- Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Mon Nov 12 17:10:55 2007
<Func Name='Do_sqlAssemblyRegSvcs'>
Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog.
Error: 2147942402
Error message: The system cannot find the file specified.
Error descrition: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Error Code: -2147024894
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlcasqlassembly.cpp
Compiler Timestamp: Thu Aug 11 01:12:01 2005
Function Name: Do_sqlAssemblyRegSvcs
Source Line Number: 155
I've searched for and found similar problems that deal with the microsoft.sqlserver.notificationservices.dll not being found but I haven't found a fix that worked for me. These are the fixes I've refered to thus far.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1651162&SiteID=17
http://support.microsoft.com/kb/940971
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlcasqlassembly.cpp@Do_sqlAssemblyRegSvcs@Do_sqlAssemblyRegSvcs@x80131501
The answer that seems to fix this problem for everyone is to set the MSDTC service login as the NT AUTHORITYNetworkService account. The problem for me is that this is already set to this profile and I've tried resetting the services and rebooting the machine. I did not have a problem with my old machine, which as far as I can tell, is the same configuration, so I know this install should work.
I'm running Windows XP SP2. This is not the upgrade to SQL Server 2005 SP2, this is the original disk that came with Visual Studio 2005.
Has anyone else faced this issue where changing the MSDTC login wasn't the solution? Also, this is my first post, so I apologize if I've left anything out. Just let me know if you want any other information.
Thank you in advance.
Tim
View 7 Replies
View Related
Jun 12, 2007
I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.
Extract from log:
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).
I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.
Any ideas?
View 3 Replies
View Related
May 3, 2008
Hi,I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property((string)(this.GetPropertyValue("Address1")));When I look at the stack, it is coming from my ProfileWrapper class which adds user address, city, etc.. from a class which inherits fromSystem.Web.Profile.ProfileBase. From the stack, it is calling the System.Web.Profile and crashed when it tries to open a connection atSystem.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject). I already migrated all aspnet_user, aspnet_roles, etc.. and don't get any connection errors. It is only when I try to get the profile data. This works on my pc, but throws an error on my lunarpage website.Any help is greatly appreciated.Thanks,AJAn error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error:Line 100: public virtual string Address2 {Line 101: get {Line 102: return ((string)(this.GetPropertyValue("Address2")));Line 103: }Line 104: set {Source File: c:windowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
oot 021d50639a6858cApp_Code.54nvluyo.1.cs Line: 102Stack Trace:[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +435 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) +782 System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties) +428 System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) +404 System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) +117 System.Configuration.SettingsBase.get_Item(String propertyName) +89 System.Web.Profile.ProfileBase.GetInternal(String propertyName) +36 System.Web.Profile.ProfileBase.get_Item(String propertyName) +68 System.Web.Profile.ProfileBase.GetPropertyValue(String propertyName) +4 ProfileCommon.get_Address2() in c:windowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
oot 021d50639a6858cApp_Code.54nvluyo.1.cs:102 ProfileWrapper..ctor() in d:inetpubvhostsjavcentral.comhttpdocsApp_CodeProfileWrapper.cs:242 ProfileDataSource.GetData() in d:inetpubvhostsjavcentral.comhttpdocsApp_CodeProfileDataSource.cs:17[TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +308 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29 System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +480 System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1960 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.FormView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.FormView.EnsureDataBound() +163 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.FindControl(String id, Int32 pathOffset) +21 System.Web.UI.Control.FindControl(String id) +9 CustomerDetailsEdit.OnPreRender(EventArgs e) in d:inetpubvhostsjavcentral.comhttpdocsUserControlsCustomerDetailsEdit.ascx.cs:60 System.Web.UI.Control.PreRenderRecursiveInternal() +86 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041
View 1 Replies
View Related
Feb 29, 2008
We have a test db, a staging db and a live db. I have a stored procedure that runs fine on test and staging, but throws the following error on live.
The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.
The stored procedure uses linked servers and a transaction.
We're using the following transaction code in the stored procedure
BEGIN
BEGIN TRANSACTION
BEGIN TRY
---
procedure stuff here
---
COMMIT TRANSACTION
END TRY
BEGIN CATCH
DECLARE @ErrorSeverity INT, @ErrorNumber INT, @ErrorMessage NVARCHAR(4000), @ErrorState INT
SET @ErrorSeverity = ERROR_SEVERITY()
SET @ErrorNumber = ERROR_NUMBER()
SET @ErrorMessage = ERROR_MESSAGE()
SET @ErrorState = ERROR_STATE()
IF @ErrorState = 0
SET @ErrorState = 1
RAISERROR ('ERROR OCCURED:%d', @ErrorSeverity, @ErrorState, @ErrorNumber)
IF XACT_STATE() < 0
ROLLBACK TRANSACTION
END CATCH
END
I found the following link which seems to be the problem we're experiencinghttp://support.microsoft.com/kb/937517
The link includes a workaround which is the following:
"To prevent the SQLNCLI provider from sending an attention signal to the server, use the SQLNCLI provider to consume fully any rowsets that the OLE DB consumer creates. "
How do I use the SQLNCLI provider to fully consume any rowsets?
View 11 Replies
View Related
Dec 27, 2007
Hi,
I am working on SQL Server 2005 (x64) with Windows Server 2003 (x64) operating system. I am having a major issue in SSIS. Here is the detailed explanation of the issue :
I have an EXCEL file in 2003 / 2007 version. It contains some data. I want to import the data using SSIS into SQL Server 2005 (x64) database table. I have taken "EXCEL FILE SOURCE" and "SQL Server DESTINATION". It was failed on importing data. Surprisingly it works fine in SQL Server 2005 (x32). Can you please explain why it is NOT woking on (x64) ?
Here is the error code i am getting:
[Excel Source [1]] Error: The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.
Appreciate your time and patience !!
Thanks
View 3 Replies
View Related
Mar 4, 2006
I installed the evaluation version of SQL Server 2005 and now my DSL connection on Windows XP is all fouled up; I'm using Server 2003 at the moment. Will uninstalling it get rid of the problem? First Oracle eats my DSL connection, now SQL wants a piece! :eek:
View 4 Replies
View Related
Feb 26, 2007
I've had a VB 6 / SQL Server 2000 app running in a network enviroment for a couple of years now at a client of mine. Recently, he upgraded to the latest version of Quickbooks which installed SQL Server 2005 on the server. Now there is SQL Server 2000 and 2005 residing on the same server. My VB app still runs on the server but will not run on other machines. I can ping the server from the other machines. Has SQL 2005 taken over the port I was using or maybe has new security features that won't let me access SQL 2000 using my current connection string? Here is my current connection string:
mstrConnStr = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=" & strServerLogin & ";Password=" & strServerPW & ";Initial Catalog=" & strDBName & ";Data Source=" & strServer.
Any help will be greatly appreciated.
Keith
View 4 Replies
View Related
May 22, 2004
Hi All
I installed the following in order:
1. .NET Framework Version 1.1 Redistributable
2. .NET Framework Version 1.1 Software Development Kit (SDK)
3. MSDE 2000 Rel A
In the command window I changed to the directory where MSDE 2000 Rel A was installed and typed in this:
setup.exe INSTANCENAME=MyDb DISABLENETWORKPROTOCOLS=1 SAPWD=<My SA PASSWORD>
MSDE installed successfully and the little icon appeared in the system tray, next to the clock. However, there was no little green arrow/triangle showing on the icon to show connection status as Connected.
4. ASP.NET Commerce Starter Kit
During the Starter Kit install a Connect to Database window opened - Connect to SQL or MSDE.
In the 'Server' field the following was automatically displayed:
STEVE-HOME/MyDb
Where STEVE-HOME is the name of my computer (changed from 'localhost') and MyDb is the instance name.
Thw 'Windows Authentication' radio button was selected by default. I left this unchanged, then clicked OK.
A window opened asking to test the connection. I clicked OK and the connection was successful.
(I didn't select the SQL Server authentication or enter a username, password or select a Database.)
The Starter Kit installed successfully and works fine. However, the SQL Server Service Manager icon states it is not connected when I mouse over it.
I opened the SQL Server Service Manager window and the Server and Services fields are blank.
Surely the Starter Kit wouldn't work if MSDE wasn't connected.
Can anyone advise on how to get the icon to show it is connected
Your help would be greatly appreciated.
View 1 Replies
View Related
Apr 7, 2008
I have a sql express .mdf that is located in c:appdirectorymydb.mdf whilst developing an application. During development my connection string uses the above path to connect to the db. e.g.
"server = .sqlexpress; Integrated Security=True; database=C:appdirectorymydb.mdf"
I have published the app using click once in visual studio.net which places the db in : C:Documents and Settingsuser.nameLocal SettingsApps2.0DataJN1WL1DJ.X7B ... 08ed2810aab2abData
When i am executing the application following a clickonce install, what should I use in my connection string for the path to the db ? or where can I find the above path (e.g. in the registry) so that I can provide it to the connection string ?
Alternatively, can I specify where the DB is going to be installed (via click once). e.g. in my app directory under program files ?
I have tried searching what seems like everywhere for a solution to this problem and as a last resort thought it worth posting the question.
Many thanks in advance.
Simon
View 1 Replies
View Related
Feb 14, 2008
Hi All,
I am getting the following error if I am using the package "Transaction Option=Required" while running through Sql Job:
The AcquireConnection method call to the connection manager "<connection name>" failed with error code 0xC0202009.
while I running the SSIS package on BI environment, I am getting the following error:
[Connection manager "<connection name>"] Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00A "Unable to enlist in the transaction.".
I know the alternative solution is to make the "Transaction Option=Supported", but in my case I have run the whole flow in a single transaction. I came to know that this has been fixed in the service pack1(ref. to http://support.microsoft.com/kb/914375). FYI.. some time it was running successful.
I have taken all the necessary step to run the SSIS package in a distributed transaction(like the steps for MSDTC) and also created the package flow in a sequence.
I was going through the link - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=160340&SiteID=1 but all those didn't solve my problem.
If anyone can help me it will be great. or it is a bug in SSIS?
Thanks.
Jena
View 5 Replies
View Related
Jun 22, 2006
I have a Rounding error: Between flat file connection manager Source & OLE DB Connection Destination (SQL Server 2005) in my Dataflow.
File looks like this lets call column names Col A,B,C,D
70410000 RD1 1223631.92 196042.42
70329000 ICD 11025.84 3353.88
71167300 COL 104270.59 24676.96
flat file connection manager settings: first row Column names then Advanced tab Col A float , Col B float , Col C string ,Col D float ,
OLE DB Connection Destination (SQL Server 2005)
CREATE TABLE [dbo].[PT_CUST_ABR](
[PARTY_NO] [float] NULL,
[PARTY_NAME] [varchar](75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TELECOMABR] [float] NULL,
[GENIABR] [float] NULL,
Problem: ColA (Source) Rounding error to PARTY_NO (Destination)
I have a field of text of in a flat file that the flat file connection manager Source picks up correctly €œ70000893€?
However when it gets the OLE DB Connection Destination the data has changed to 70000896. That€™s before its even Written to the database.
The only clue that something is wrong in the middle is the great Data viewer shows the number as 7.000009E+07
Other clues looking at the data it appears there is a rounding error on only the number that dont end in 00
ColA (Source) PARTY_NO (Destination)
71167300 71167296
70329000 70329000
70410000 70410000
Any ideas people?
Thanks in advance
Dave
View 3 Replies
View Related
Sep 7, 2007
I am working in a distributed environment, I verified msgs have been successfully send from server1 db1 to server2 db2, but I still get the following error msg from the sender server through SQL profile:
Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'.
Does anyone experienced the samething?
Thanks!
View 5 Replies
View Related
Mar 7, 2006
Hello, I have a sql 2005 server, and I am a developer, with the database on my own machine. It alwayws works for me but after some minutes the other developer cant work in the application
He got this error
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.1.140]
and When I see the log event after that error, it comes with another error.
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.1.140]
He has IIS5 and me too.
I created a user on the domain called ASPSYS with password, then in the IIS on anonymous authentication I put that user with that password, and it works, on both machines.
and in the connection string I have.
<add key="sqlconn" value="Data Source=ESTACION15;Initial Catalog=GescomDefinitiva;Integrated Security=SSPI; Trusted_Connection=true"/>
I go to the profiler, and I see that when he browses a page, the database is accesed with user ASPSYS, but when I browse a page, the database is accesed with user SElevalencia.
Thats strange.
The only way that the other developer can work again on the project is to restart the whole machine. He has windows xp profession, I have windows 2000.
If you want me to send logs please tellme
View 20 Replies
View Related
May 31, 2008
Hi All
I'm getting this when executing the code below. Going from W2K/SQL2k SP4 to XP/SQL2k SP4 over a dial-up link.
If I take away the begin tran and commit it works, but of course, if one statement fails I want a rollback. I'm executing this from a Delphi app, but I get the same from Qry Analyser.
I've tried both with and without the Set XACT . . ., and also tried with Set Implicit_Transactions off.
set XACT_ABORT ON
Begin distributed Tran
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.TRANSACTIONMAIN
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.TRANSACTIONMAIN
set REPFLAG = 0 where REPFLAG = 1 and DONE = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.WBENTRY
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.WBENTRY
set REPFLAG = 0 where REPFLAG = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.FIXED
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.FIXED
set REPFLAG = 0 where REPFLAG = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.ALTCHARGE
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.ALTCHARGE
set REPFLAG = 0 where REPFLAG = 1
update OPENDATASOURCE('SQLOLEDB','Data Source=10.10.10.171;User ID=*****;Password=****').TRANSFERSTN.TSADMIN.TSAUDIT
set REPFLAG = 0 where REPFLAG = 1
update TSADMIN.TSAUDIT
set REPFLAG = 0 where REPFLAG = 1
COMMIT TRAN
It's got me stumped, so any ideas gratefully received.Thx
View 1 Replies
View Related
Mar 9, 2007
Hello,
I'm getting this error:
=== Verbose logging started: 09-03-2007 11:22:01 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: c:2615800be9b170361adff8bc7a52ebhotfix.exe ===
MSI (c) (68:50) [11:22:01:246]: Resetting cached policy values
MSI (c) (68:50) [11:22:01:246]: Machine policy value 'Debug' is 0
MSI (c) (68:50) [11:22:01:246]: ******* RunEngine:
******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (c) (68:50) [11:22:01:246]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (68:50) [11:22:01:246]: Grabbed execution mutex.
MSI (c) (68:50) [11:22:01:246]: Cloaking enabled.
MSI (c) (68:50) [11:22:01:246]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (68:50) [11:22:01:246]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (A8:D0) [11:22:01:277]: Grabbed execution mutex.
MSI (s) (A8:3C) [11:22:01:277]: Resetting cached policy values
MSI (s) (A8:3C) [11:22:01:277]: Machine policy value 'Debug' is 0
MSI (s) (A8:3C) [11:22:01:277]: ******* RunEngine:
******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (s) (A8:3C) [11:22:01:402]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (A8:3C) [11:22:01:402]: File will have security applied from OpCode.
MSI (s) (A8:3C) [11:22:01:996]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi' against software restriction policy
MSI (s) (A8:3C) [11:22:01:996]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi has a digital signature
MSI (s) (A8:3C) [11:22:02:121]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (A8:3C) [11:22:02:121]: End dialog not enabled
MSI (s) (A8:3C) [11:22:02:121]: Original package ==> C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
MSI (s) (A8:3C) [11:22:02:121]: Package we're running from ==> C:WINDOWSInstaller1e413d.msi
MSI (s) (A8:3C) [11:22:02:136]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (A8:3C) [11:22:02:136]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (A8:3C) [11:22:02:136]: MSCOREE not loaded loading copy from system32
MSI (s) (A8:3C) [11:22:02:136]: Opening existing patch 'C:WINDOWSInstaller3d37f8c.msp'.
MSI (s) (A8:3C) [11:22:02:136]: SequencePatches starts. Product code: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}, Product version: 9.00.3042.00, Upgrade code: {3A91FA19-A197-467C-850F-0AFE90899371}, Product language 1033
MSI (s) (A8:3C) [11:22:02:136]: PATCH SEQUENCER: Setting patch {EE92F683-5F5C-4970-BB0B-9AC591B60268} to be unregistered, because the patch doesn't have any transform that targets this product.
MSI (s) (A8:3C) [11:22:02:136]: SequencePatches returns success.
MSI (s) (A8:3C) [11:22:02:136]: Final Patch Application Order:
MSI (s) (A8:3C) [11:22:02:136]: Other Patches:
MSI (s) (A8:3C) [11:22:02:136]: UnknownAbsent: {EE92F683-5F5C-4970-BB0B-9AC591B60268} -
MSI (s) (A8:3C) [11:22:02:136]: Machine policy value 'DisablePatch' is 0
MSI (s) (A8:3C) [11:22:02:136]: Machine policy value 'AllowLockdownPatch' is 1
MSI (s) (A8:3C) [11:22:02:136]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (A8:3C) [11:22:02:152]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (A8:3C) [11:22:02:152]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (A8:3C) [11:22:02:152]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (A8:3C) [11:22:02:152]: Transforms are not secure.
MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 2205 2: 3: Control
MSI (s) (A8:3C) [11:22:02:152]: Command Line: REBOOT=ReallySuppress REINSTALLMODE=vomus REINSTALL=ALL CURRENTDIRECTORY=c:2615800be9b170361adff8bc7a52eb CLIENTUILEVEL=3 CLIENTPROCESSID=5736
MSI (s) (A8:3C) [11:22:02:152]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{BEFE6789-8AE1-4E45-B1F7-E3D6B30A51C8}'.
MSI (s) (A8:3C) [11:22:02:152]: Product Code passed to Engine.Initialize: ''
MSI (s) (A8:3C) [11:22:02:152]: Product Code from property table before transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'
MSI (s) (A8:3C) [11:22:02:152]: Product Code from property table after transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'
MSI (s) (A8:3C) [11:22:02:152]: Product registered: entering maintenance mode
MSI (s) (A8:3C) [11:22:02:152]: PROPERTY CHANGE: Adding ProductState property. Its value is '5'.
MSI (s) (A8:3C) [11:22:02:152]: PROPERTY CHANGE: Adding ProductToBeRegistered property. Its value is '1'.
MSI (s) (A8:3C) [11:22:02:152]: Entering CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 1402 2: UNKNOWNNet 3: 2
MSI (s) (A8:3C) [11:22:02:152]: Specifed source is not already in a list.
MSI (s) (A8:3C) [11:22:02:152]: Policy value 'SearchOrder' is 'nmu'
MSI (s) (A8:3C) [11:22:02:152]: Machine policy value 'DisableBrowse' is 1
MSI (s) (A8:3C) [11:22:02:152]: Adding new sources is not allowed.
MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 1729
MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 2729
MSI (s) (A8:3C) [11:22:02:199]: Note: 1: 2729
MSI (s) (A8:3C) [11:22:02:199]: Product: Microsoft SQL Server Setup Support Files (English) -- Configuration failed.
MSI (s) (A8:3C) [11:22:02:199]: MainEngineThread is returning 1625
This installation is forbidden by system policy. Contact your system administrator.
C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
MSI (c) (68:50) [11:22:02:308]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (68:50) [11:22:02:308]: MainEngineThread is returning 1625
=== Verbose logging stopped: 09-03-2007 11:22:02 ===
Time: 03/09/2007 11:22:35.028
KB Number: KB921896
Machine: CEPHEUS
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Failed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x86
Database Services (MSSQLSERVER) ENU SP1 2005.090.2153.00 x86 ENTERPRISE
Analysis Services (MSSQLSERVER) ENU SP1 2005.090.2153.00 x86 ENTERPRISE
Reporting Services (MSSQLSERVER) ENU SP1 9.00.2153.00 x86 ENTERPRISE
Notification Services ENU SP1 9.00.2153.00 x86 ENTERPRISE
Integration Services ENU SP1 9.00.2153.00 x86 ENTERPRISE
SQL Server Native Client ENU 9.00.2047.00 x86
Client Components ENU SP1 9.1.2153 x86 ENTERPRISE
MSXML 6.0 Parser ENU 6.00.3890.0 x86
SQLXML4 ENU 9.00.2047.00 x86
Backward Compatibility ENU 8.05.1704 x86
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
MSSQLSERVER SQL Server Native Client Service 1168
SQLSERVERAGENT SQL Server Native Client Service 2776
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4276
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4280
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4288
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4300
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4308
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4324
DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4364
msftesql Database Services Service 296
ReportServer Database Services Service 1660
MSSQLServerOLAPService Analysis Services Service 1148
MsDtsServer Integration Services Service 352
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 1625
Error Description : Unable to install Windows Installer MSI file
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 2153
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) :
Status : Not Applied
Log File :
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1603
View 2 Replies
View Related
Mar 24, 2008
I am using SSIS 2005 on Windows 2003 server. Using Excel Source to dump the data for staging database.
I am getting following error while I execute it through BI studio's execute button.
Please help.
- Sachin
View 2 Replies
View Related
Mar 11, 2008
I have deployed my packages into Sql Server and I am using Configuration File. As my Data Source is Excel, I have changed the connection string during deployment with Server Path. But I am getting the following errors. Actually the File Exist in Path. May I know What is cause of the issue? Do I need to give any permission to execute the package.
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
component "Excel Source Service Contract Upload" (1) failed validation and returned error code 0xC020801C.
One or more component failed validation.
There were errors during task validation.
DTS_E_OLEDBERROR, Error Code: 0x80004005 Source: "MS JET DB Engine" Description : Path is not valid
View 27 Replies
View Related
Mar 6, 2007
My system can not install the SQL SERVER 2003.There are some errors as follow when I install it.How can I solution this problem.Thanks very much!
09:25:23 Begin Setup09:25:23 8.00.19409:25:23 Mode = Normal09:25:23 ModeType = NORMAL09:25:23 GetDefinitionEx returned: 0, Extended: 0x009:25:23 ValueFTS returned: 109:25:23 ValuePID returned: 109:25:23 ValueLic returned: 009:25:23 System: Windows NT WorkStation09:25:23 SQL Server ProductType: Personal Edition [0x2]09:25:23 Begin Action: SetupInitialize 09:25:23 End Action SetupInitialize09:25:23 Begin Action: SetupInstall09:25:23 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesDir ...09:25:23 CommonFilesDir=C:Program FilesCommon Files09:25:23 Windows Directory=C:WINDOWS09:25:23 Program Files=C:Program Files09:25:23 TEMPDIR=C:WINDOWSTEMP09:25:23 Begin Action: SetupInstall09:25:23 digpid size : 25609:25:24 digpid size : 16409:25:24 Begin Action: CheckFixedRequirements09:25:24 Platform ID: 0xf00000009:25:24 Version: 5.1.260009:25:24 File Version - C:WINDOWSsystem32shdocvw.dll: 6.0.2900.291909:25:24 End Action: CheckFixedRequirements09:25:24 Begin Action: ShowDialogs09:25:24 Initial Dialog Mask: 0x83000f7, Disable Back=0x109:25:24 Begin Action ShowDialogsHlpr: 0x109:25:24 Begin Action: DialogShowSdWelcome09:25:25 End Action DialogShowSdWelcome09:25:25 Dialog 0x1 returned: 109:25:25 End Action ShowDialogsHlpr09:25:25 ShowDialogsGetDialog returned: nCurrent=0x2,index=109:25:25 Begin Action ShowDialogsHlpr: 0x209:25:25 Begin Action: DialogShowSdMachineName09:25:26 ShowDlgMachine returned: 109:25:26 Name = C853FFE5CF474B3, Type = 0x109:25:26 Begin Action: CheckRequirements09:25:26 Processor Architecture: x86 (Pentium)09:25:26 Service Pack: 51209:25:26 ComputerName: C853FFE5CF474B309:25:26 User Name: Administrator09:25:26 IsAllAccessAllowed returned: 109:25:26 OS Language: 0x80409:25:26 End Action CheckRequirements09:25:26 This combination of Package and Operating System allows a full product install.09:25:26 CreateSetupTopology(C853FFE5CF474B3), Handle : 0x1743fb0, returned : 009:25:26 CreateSetupTopology returned : 0, Handle : 0x1743fb009:25:26 Topology Type : 1, Return Value : 009:25:26 ST_GetPhysicalNode returned : 0, PNHandle : 0x174400809:25:26 PN_EnumerateEx returned : 009:25:26 PN_GetSQLStates returned : 0, SqlStates : 0x009:25:26 PN_StartScan [0x1744008] returned : 009:25:26 PN_GetNext [0x1744008] returned : 18, Handle: [0x0]09:25:26 No more items in enumeration.09:25:26 ReleaseSetupTopology09:25:26 Named instance limit: 100, quota: 009:25:26 End Action DialogShowSdMachineName09:25:26 begin ShowDialogsUpdateMask09:25:26 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 009:25:26 Updated Dialog Mask: 0xbf00037, Disable Back = 0x109:25:26 Dialog 0x2 returned: 009:25:26 End Action ShowDialogsHlpr09:25:26 ShowDialogsGetDialog returned: nCurrent=0x4,index=209:25:26 Begin Action ShowDialogsHlpr: 0x409:25:26 Begin Action: DialogShowSdInstallMode09:25:27 ShowDlgInstallMode returned: 109:25:27 InstallMode : 0x109:25:27 End Action DialogShowSdInstallMode09:25:27 begin ShowDialogsUpdateMask09:25:27 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 109:25:27 Updated Dialog Mask: 0xbf40037, Disable Back = 0x109:25:27 Dialog 0x4 returned: 109:25:27 End Action ShowDialogsHlpr09:25:27 ShowDialogsGetDialog returned: nCurrent=0x10,index=409:25:27 Begin Action ShowDialogsHlpr: 0x1009:25:27 Begin Action: DialogShowSdRegisterUserEx09:25:28 End Action DialogShowSdRegisterUserEx09:25:28 Dialog 0x10 returned: 109:25:28 End Action ShowDialogsHlpr09:25:28 ShowDialogsGetDialog returned: nCurrent=0x20,index=509:25:28 Begin Action ShowDialogsHlpr: 0x2009:25:28 Begin Action: DialogShowSdLicense09:25:29 End Action DialogShowSdLicense09:25:29 Dialog 0x20 returned: 109:25:29 End Action ShowDialogsHlpr09:25:29 ShowDialogsGetDialog returned: nCurrent=0x40000,index=1809:25:29 Begin Action ShowDialogsHlpr: 0x4000009:25:29 Begin Action: DialogShowSdCliSvr09:25:29 DisplaySystemPreReq09:25:30 ShowDlgClientServerSelect returned: 109:25:30 Type : 0x209:25:30 End Action DialogShowSdCliSvr09:25:30 begin ShowDialogsUpdateMask09:25:30 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 109:25:30 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x109:25:30 Dialog 0x40000 returned: 109:25:30 End Action ShowDialogsHlpr09:25:30 ShowDialogsGetDialog returned: nCurrent=0x80000,index=1909:25:30 Begin Action ShowDialogsHlpr: 0x8000009:25:30 Begin Action: DialogShowSdInstanceName09:25:30 Begin Action: ShowDlgInstanceName09:25:32 End Action: ShowDlgInstanceName09:25:32 ShowDlgInstanceName returned : 1209:25:32 InstanceName : 09:25:32 End Action DialogShowSdInstanceName09:25:32 begin ShowDialogsUpdateMask09:25:32 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1209:25:32 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x109:25:32 Dialog 0x80000 returned: 1209:25:32 End Action ShowDialogsHlpr09:25:32 ShowDialogsGetDialog returned: nCurrent=0x40000,index=1809:25:32 Begin Action ShowDialogsHlpr: 0x4000009:25:32 Begin Action: DialogShowSdCliSvr09:25:32 DisplaySystemPreReq09:25:34 ShowDlgClientServerSelect returned: 109:25:34 Type : 0x209:25:34 End Action DialogShowSdCliSvr09:25:34 begin ShowDialogsUpdateMask09:25:34 nFullMask = 0xbfc0037, nCurrent = 0x40000, nDirection = 109:25:34 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x109:25:34 Dialog 0x40000 returned: 109:25:34 End Action ShowDialogsHlpr09:25:34 ShowDialogsGetDialog returned: nCurrent=0x80000,index=1909:25:34 Begin Action ShowDialogsHlpr: 0x8000009:25:34 Begin Action: DialogShowSdInstanceName09:25:34 Begin Action: ShowDlgInstanceName09:25:34 End Action: ShowDlgInstanceName09:25:34 ShowDlgInstanceName returned : 109:25:34 InstanceName : MSSQLSERVER09:25:34 CreateSetupTopology(C853FFE5CF474B3), Handle : 0x1743fb0, returned : 009:25:34 CreateSetupTopology returned : 0, Handle : 0x1743fb009:25:34 Topology Type : 1, Return Value : 009:25:34 ST_GetPhysicalNode returned : 0, PNHandle : 0x174400809:25:34 PN_EnumerateEx returned : 009:25:34 PN_GetSQLStates returned : 0, SqlStates : 0x009:25:34 PN_StartScan [0x1744008] returned : 009:25:34 PN_GetNext [0x1744008] returned : 18, Handle: [0x0]09:25:34 No more items in enumeration.09:25:34 ReleaseSetupTopology09:25:34 End Action DialogShowSdInstanceName09:25:34 begin ShowDialogsUpdateMask09:25:34 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 109:25:34 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x109:25:34 Dialog 0x80000 returned: 109:25:34 End Action ShowDialogsHlpr09:25:34 ShowDialogsGetDialog returned: nCurrent=0x100000,index=2009:25:34 Begin Action ShowDialogsHlpr: 0x10000009:25:34 Begin Action: DialogShowSdSetupType09:25:34 Begin Action: Setup Type09:25:56 SQL program folder: d:program files ool softwaresql09:25:56 SQL data folder: d:program files ool softwaresql09:25:56 Windows system folder: C:WINDOWSsystem3209:25:56 Prog req: 38073, Data req: 36544, Sys req: 16916809:25:56 Prog avail: 6388716, Data avail: 6388716, Sys avail: 272730809:25:56 Prog req vs. avail, 74617, 638871609:25:56 Data req vs. avail, 36544, 638871609:25:56 Sys req vs. avail, 169168, 272730809:25:56 DisplaySystemPreReq09:25:56 [SetupTypeSQL]09:25:56 szDir = d:program files ool softwaresql09:25:56 szDir = d:program files ool softwaresql09:25:56 Result = 30109:25:56 szDataDir = d:program files ool softwaresql09:25:56 szDataDir = d:program files ool softwaresql09:25:56 End Action: Setup Type09:25:56 Setup Type: Typical (301)09:25:56 End Action DialogShowSdSetupType09:25:56 begin ShowDialogsUpdateMask09:25:56 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 30109:25:56 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:25:56 Dialog 0x100000 returned: 30109:25:56 End Action ShowDialogsHlpr09:25:56 ShowDialogsGetDialog returned: nCurrent=0x400000,index=2209:25:56 Begin Action ShowDialogsHlpr: 0x40000009:25:56 Begin Action: DlgServices09:26:02 ShowDlgServices returned: 109:26:02 [DlgServices]09:26:02 Local-Domain = 385509:26:02 AutoStart = 1509:26:02 Result = 109:26:02 End Action DlgServices09:26:02 begin ShowDialogsUpdateMask09:26:02 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 109:26:02 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:26:02 Dialog 0x400000 returned: 109:26:02 End Action ShowDialogsHlpr09:26:02 ShowDialogsGetDialog returned: nCurrent=0x800000,index=2309:26:02 Begin Action ShowDialogsHlpr: 0x80000009:26:02 Begin Action: DlgSQLSecurity09:26:08 ShowDlgSQLSecurity returned: 109:26:08 LoginMode = 2,szPwd09:26:08 End Action DlgSQLSecurity09:26:08 begin ShowDialogsUpdateMask09:26:08 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 109:26:09 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:26:09 Dialog 0x800000 returned: 109:26:09 End Action ShowDialogsHlpr09:26:09 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=2409:26:09 Begin Action ShowDialogsHlpr: 0x100000009:26:09 Begin Action: DlgCollation09:26:09 ShowDlgCollation returned: 109:26:09 collation_name = Chinese_PRC_CI_AS,locale_name = Chinese_PRC,lcid = 0x804,SortId = 0,dwCompFlags = 0x3000109:26:09 End Action DlgCollation09:26:09 begin ShowDialogsUpdateMask09:26:09 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 109:26:09 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:26:09 Dialog 0x1000000 returned: 109:26:09 End Action ShowDialogsHlpr09:26:09 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=2509:26:09 Begin Action ShowDialogsHlpr: 0x200000009:26:09 Begin Action: DlgNetwork09:26:09 ShowDlgNetwork returned: 109:26:09 [DlgServerNetwork]09:26:09 NetworkLibs = 25509:26:09 TCPPort = 143309:26:09 TCPPrxy = Default09:26:09 NMPPipeName = \.pipesqlquery09:26:09 Result = 109:26:09 End Action DlgNetwork09:26:09 begin ShowDialogsUpdateMask09:26:09 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 109:26:09 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:26:09 Dialog 0x2000000 returned: 109:26:09 End Action ShowDialogsHlpr09:26:09 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=2709:26:09 Begin Action ShowDialogsHlpr: 0x800000009:26:09 Begin Action: DialogShowSdStartCopy09:26:09 End Action DialogShowSdStartCopy09:26:09 begin ShowDialogsUpdateMask09:26:09 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 109:26:09 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:26:09 Dialog 0x8000000 returned: 109:26:09 End Action ShowDialogsHlpr09:26:09 ShowDialogsGetDialog returned: nCurrent=0x0,index=009:26:09 End Action ShowDialogs09:26:10 Begin Action ProcessBeforeDataMove:09:26:10 DeinstallStart returned (d:program files ool softwaresqlMSSQL): 009:26:10 End Action ProcessBeforeDataMove:09:26:10 Begin Action SetToolsComponentSelection:09:26:10 End Action SetToolsComponentSelection:09:26:10 Begin Action ProcessComponentSelection:09:26:10 End Action ProcessComponentSelection09:26:10 Begin Action LogSelectedComponents:09:26:10 SQLProg09:26:10 SQLProgSQLServr09:26:10 SQLProgSQLServrHelp09:26:10 SQLProgSQLServrSCMDev09:26:10 SQLProgSQLServrSCMDevSCMh09:26:10 SQLProgSQLServrSCMDevSCMX86Lb09:26:10 SQLProgSQLServrSCMDevSCMALb09:26:10 SQLProgSQLServrRs103309:26:10 SQLProgSQLServrRsIntl09:26:10 SQLProgSQLServrActiveX09:26:10 SQLProgSQLServrSystem09:26:10 SQLProgUpgTools09:26:10 SQLProgUpgToolsUpgSys09:26:10 SQLProgUpgToolsActiveX09:26:10 SQLProgUpgToolsRes103309:26:10 SQLProgUpgToolsResOther09:26:10 SQLProgUpgToolsResld09:26:10 SQLProgReplSupp09:26:10 SQLProgReplSuppReplDat09:26:10 SQLProgReplSuppRepComm09:26:10 SQLProgReplSuppRepNoDk09:26:10 SQLProgReplSuppActiveX09:26:10 SQLProgInstall09:26:10 SQLProgSystem09:26:10 SQLProgSvrExt09:26:10 SQLProgSvrExtHelp09:26:10 SQLProgSvrExtSvrExtRs09:26:10 SQLProgSvrExtResIntl09:26:10 SQLProgDat09:26:10 SQLProgDatSmpl09:26:10 SQLProgBaseSys09:26:10 SQLProgBaseBinn09:26:10 SQLProgBaseInst09:26:10 SQLProgSymbols09:26:10 SQLProgSymbolsEXE09:26:10 SQLProgSymbolsDLL09:26:10 SQLProgPerfmon09:26:10 SQLProgPerfmonSystem09:26:10 SQLProgRoot09:26:10 MgtTool09:26:10 MgtToolSEM09:26:10 MgtToolSEMHTML09:26:10 MgtToolSEMMSD9809:26:10 MgtToolSEMMSD98SYS09:26:10 MgtToolSEMMSD98Res09:26:10 MgtToolSEMMSD98Hlp09:26:10 MgtToolSEMHelp09:26:10 MgtToolSEMRes103309:26:10 MgtToolSEMResIntl09:26:10 MgtToolSEMMSD98RsI09:26:10 MgtToolSEMActiveX09:26:10 MgtToolSEMActiveXRes103309:26:10 MgtToolSEMActiveXResIntl09:26:10 MgtToolSEMScripts09:26:10 MgtToolSEMOLEDB09:26:10 MgtToolSEMOLEDBRes103309:26:10 MgtToolSEMOLEDBResIntl09:26:10 MgtToolProfiler09:26:10 MgtToolProfilerHelp09:26:10 MgtToolProfilerRes103309:26:10 MgtToolProfilerResIntl09:26:10 MgtToolQryanlz09:26:10 MgtToolQryanlzHelp09:26:10 MgtToolQryanlzRes103309:26:10 MgtToolQryanlzResIntl09:26:10 MgtToolDTCCLi09:26:10 MgtToolWzcnflct09:26:10 MgtToolWzcnflctWzcnHlp09:26:10 MgtToolWzcnflctWzcn103309:26:10 MgtToolWzcnflctWzcnOthr09:26:10 MgtToolWzcnflctWzcnCmn09:26:10 MgtToolUtilSys09:26:10 MgtToolUtilBinn09:26:10 Connect09:26:10 ConnectConnSys09:26:10 Books09:26:10 BooksBookso09:26:10 BooksBooksoUtils09:26:10 DevTools09:26:10 DevToolsDbg Int09:26:10 DevToolsDbg IntDbg Int Common09:26:10 DevToolsDbg IntEXE09:26:10 CoreRepl09:26:10 CoreReplRes103309:26:10 CoreReplResIntl09:26:10 Core09:26:10 CoreRes103309:26:10 CoreResOther09:26:10 Repostry09:26:10 RepostryRepstSys09:26:10 RepostryRes103309:26:10 RepostryResIntl09:26:10 CoreMisc09:26:10 CoreMiscActiveX09:26:10 CoreMiscActiveXRes103309:26:10 CoreMiscActiveXResIntl09:26:10 CoreMiscRes103309:26:10 Monarch09:26:10 MonarchMonr103309:26:10 MonarchMonrIntl09:26:10 Jet09:26:10 CoreInst09:26:10 CoreCOM09:26:10 CoreCOMRes103309:26:10 CoreCOMResIntl09:26:10 CoreTool09:26:10 CoreToolRes103309:26:10 CoreToolResOther09:26:10 DBLibCli09:26:10 SFExt09:26:10 SFExtActiveX09:26:10 SFExtActiveXRes103309:26:10 SFExtActiveXResIntl09:26:10 SFExtRes103309:26:10 SFExtResIntl09:26:10 Trace09:26:10 TraceRes103309:26:10 TraceResOther09:26:10 MiscCore09:26:10 MC09:26:10 MCMC103309:26:10 MCMCIntl09:26:10 MCHelp09:26:10 SQLMgr09:26:10 SQLMgrRes103309:26:10 SQLMgrResIntl09:26:10 SvrTool09:26:10 SvrToolRes103309:26:10 SvrToolResIntl09:26:10 DTSUI09:26:10 DTSUIRes103309:26:10 DTSUIResIntl09:26:10 MSOlap09:26:10 MSOlapRes103309:26:10 MSOlapResIntl09:26:10 ATL09:26:10 ATLwinnt09:26:10 ATLwin9x09:26:10 MFC42U09:26:10 VC09:26:10 VB09:26:10 OCX109:26:10 SQLAdHlp09:26:10 SQLAdHlpRes103309:26:10 SQLAdHlpResOther09:26:10 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}09:26:10 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}09:26:10 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}09:26:10 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}09:26:10 End Action LogSelectedComponents09:26:10 Begin Action InstallPkgs:09:26:10 Begin Action: Locked Connectivity Files Check09:26:11 ConnectivityLocked returned: 009:26:11 �作�功完�。
09:26:11 End Action: Locked Connectivity Files Check09:26:11 安装程åº?æ£åœ¨å®‰è£… Microsoft æ•°æ?®è®¿é—®ç»„件 (MDAC) ...09:26:11 H:PERSONALx86Othersqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"09:26:29 ExitCode: 009:26:30 安装程åº?æ£åœ¨å®‰è£… Microsoft 分布å¼?事务处ç?†å??调器 (MSDTC) ...09:26:30 C:WINDOWSTEMPSqlSetupBincldtcstp.exe -SupportDir "C:WINDOWSTEMPSqlSetupBin" -DTCPkg "H:PERSONALx86Otherdtcsetup.exe" -LogFile "C:WINDOWSsqlstp.log"09:26:30 Process Exit Code: (0) 09:26:30 /Q:A /T:C:WINDOWSTEMPixp001.tmp09:26:30 安装程åº?æ£åœ¨å®‰è£… HTML 帮助09:26:31 HTML Help installer exit code: 009:26:58 End Action InstallPkgs09:26:58 Begin Action MoveFileData:09:26:58 Enabled SELFREGISTERBATCH09:26:58 Enabled CORECOMPONENTHANDLING09:30:07 Begin Action: MoveFileDataSpecial09:30:07 End Action: MoveFileDataSpecial09:30:07 End Action MoveFileData09:30:07 Begin Action ProcessAfterDataMove:09:30:08 H:PERSONALx86Binnhhcol.exe C:Program FilesMicrosoft SQL Server80ToolsBooks09:30:09 End Action ProcessAfterDataMove09:30:09 Begin Action BuildServer:09:30:09 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 5 -ExePath "d:program files ool softwaresqlMSSQLinnsqlservr.exe" -Service "MSSQLSERVER"09:30:09 Process Exit Code: (0) 09:30:09 Begin Action: CreateRegistrySetSQL09:30:09 End Action: CreateRegistrySetSQL09:30:09 Begin Action: RegWriteSetupEntry09:30:09 End Action: RegWriteSetupEntry09:30:09 Begin Action: CreateSer09:30:09 End Action: CreateSer09:30:09 Begin Action: SkuIt09:30:10 End Action: SkuIt09:30:10 SetFileSecuritySQLAndAdmin for d:program files ool softwaresqlMSSQL returned: 0, 009:30:10 SetRegSecuritySQLAndAdmin for SoftwareMicrosoftMSSQLServerMSSQLServer returned: 0, 009:30:10 Begin Action: UpdateSystemPath09:30:10 Path successfully updated.09:30:10 %SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;C:Program FilesCommon FilesAdobeAGL;C:Program FilesMicrosoft SQL Server80ToolsBINN09:30:10 End Action: UpdateSystemPath09:30:11 C:Program FilesMicrosoft SQL Server80ToolsBinncnfgsvr.exe -F "C:WINDOWSsqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "Chinese_PRC_CI_AS" -H 262782 -U sa -P ###############################################################################
æ£åœ¨å?¯åŠ¨?
Chinese_PRC_CI_AS
-m -Q -T4022 -T3659
æ£åœ¨ä¸Žæœ?务?
driver={sql server};server=C853FFE5CF474B3;UID=sa;PWD=;database=master
æ£åœ¨é…?ç½®æœ?
EXEC sp_grantlogin N'BUILTINAdministrators'
[Microsoft][ODBC SQL Server Driver][SQL Server]已� 'BUILTINAdministrators' 授予登
EXEC sp_addsrvrolemember N'BUILTINAdministrators', 'sysadmin'
[Microsoft][ODBC SQL Server Driver][SQL Server]'BUILTINAdministrators' å·²æ·»åŠ åˆ°è§’è‰² 'sysadm
update master.dbo.spt_server_info set attribute_value = @@version where attribute_id = 2
EXEC sp_addserver N'C853FFE5CF474B3', local
[Microsoft][ODBC SQL Server Driver][SQL Server]密ç ?å·²
EXEC sp_configure 'allow updates', 1
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC 执行完毕。如果 DBCC 输出了错误?
[Microsoft][ODBC SQL Server Driver][SQL Server]已将�置选项 'allow updates' 从 0 改为 1。请�行 RECON
reconfigure with override
update master.dbo.sysaltfiles set size=1024 where name=N'tempdev'
EXEC sp_configure 'allow updates', 0
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC 执行完毕。如果 DBCC 输出了错误?
[Microsoft][ODBC SQL Server Driver][SQL Server]已将�置选项 'allow updates' 从 1 改为 0。请�行 RECON
reconfigure with override
æ£åœ¨æ–开与æœ?务
æ£åœ¨å?œæ¢?
已�功�置 SQL Se
###############################################################################
09:30:49 Process Exit Code: (0) 09:30:49 End Action BuildServer09:30:49 Begin Action SelfRegiser09:30:49 DLLRegisterServer atl.dll: 0, 0x009:31:07 Manual DLLRegisterServer C:WINDOWSsystem32Msrdo20.dll: 0, 0x009:31:08 Manual DLLRegisterServer C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationConflict Viewerwzcnf.dll: 0, 0x009:31:08 Manual DLLRegisterServer C:Program FilesCommon FilesSystemOLE DBmsolap80.dll: 126, 0x7e09:31:08 The file listed below could not be registered. Adding it to RunOnce to try again on the next reboot.09:31:08 DLL0: C:WINDOWSsystem32
egsvr32.exe /s "C:Program FilesCommon FilesSystemOLE DBmsolap80.dll"09:31:08 Manual DLLRegisterServer C:Program FilesCommon FilesSystemOLE DBmsolui80.dll: 126, 0x7e09:31:08 The file listed below could not be registered. Adding it to RunOnce to try again on the next reboot.09:31:08 DLL1: C:WINDOWSsystem32
egsvr32.exe /s "C:Program FilesCommon FilesSystemOLE DBmsolui80.dll"09:31:08 Begin Action SelfRegisterOnCluster09:31:08 End Action SelfRegisterOnCluster09:31:08 Begin Action RegisterSvrReplFiles09:31:08 **** File registered: C:Program FilesMicrosoft SQL Server80COMsnapshot.exe-unregserver09:31:08 **** File registered: C:Program FilesMicrosoft SQL Server80COMdistrib.exe-unregserver09:31:08 **** File registered: C:Program FilesMicrosoft SQL Server80COM
eplmerg.exe-unregserver09:31:08 **** File registered: C:Program FilesMicrosoft SQL Server80COMlogread.exe-unregserver09:31:09 **** File registered: C:Program FilesMicrosoft SQL Server80COMqrdrsvc.exe-unregserver09:31:09 **** File registered: C:Program FilesMicrosoft SQL Server80COMsnapshot.exe-regserver09:31:09 **** File registered: C:Program FilesMicrosoft SQL Server80COMdistrib.exe-regserver09:31:09 **** File registered: C:Program FilesMicrosoft SQL Server80COM
eplmerg.exe-regserver09:31:10 **** File registered: C:Program FilesMicrosoft SQL Server80COMlogread.exe-regserver09:31:10 **** File registered: C:Program FilesMicrosoft SQL Server80COMqrdrsvc.exe-regserver09:31:10 End Action RegisterSvrReplFiles09:31:10 Begin Action SelfRegisterCOMShared09:31:10 End Action SelfRegisterCOMShared09:31:10 End Action SelfRegister09:31:10 Begin Action SetupRegistry:09:31:10 Begin Action RegWriteInstalledInstances:09:31:10 End Action RegWriteInstalledInstances09:31:10 Register this installation of SQL Server with MDAC09:31:11 Completed registering this installation of SQL Server with MDAC09:33:05 创建一个或多个注册表项时出现错误。请å?‚è§? C:WINDOWS\sqlstp.log 以了解详细情况。问题å?¯èƒ½æ˜¯ç”±äºŽæ³¨å†Œè¡¨å¼•ç”¨æ?¡ä»¶ä¸?足而引起的。09:33:05 Action CleanUpInstall:09:33:05 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT09:33:05 Process Exit Code: (1060) 指定的æœ?务并未以已安装的æœ?务å˜åœ¨ã€‚
09:33:05 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQLSERVER09:33:06 Process Exit Code: (0) 09:33:06 StatsGenerate returned: 209:33:06 StatsGenerate (0x0,0x1,0xf000000,0x200,2052,303,0x0,0x1,0,0,009:33:06 StatsGenerate -1,Administrator)09:33:06 Installation Failed.
View 1 Replies
View Related
Jul 27, 2004
hi
when i want to install SQL sever 2000 i recive the message that i can install just client component of it!
my windows is XP and i have IIS and .Net framework installed on it.
thanks
View 2 Replies
View Related
Feb 3, 2004
I was using SQL 7. I uninstalled this and started installing SQL Server 2000 DEsktop Engine. However, install never goes thru and I get this message.
Any ideas would be appreciated.
Thanks
View 2 Replies
View Related
Feb 23, 2007
I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.
mlissaw
View 3 Replies
View Related
Jun 21, 2006
Thank you very much any advice about.
Rick X.
Microsoft SQL Server 2005 Setup beginning at Wed Jun 21 15:09:29 2006
Process ID : 1760
h:fc886af35059928dd687f3a141setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/5/21 15:7:27
Complete: LoadResourcesAction at: 2006/5/21 15:7:27, returned true
Running: ParseBootstrapOptionsAction at: 2006/5/21 15:7:27
Loaded DLL:h:fc886af35059928dd687f3a141xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/5/21 15:9:28, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Oct 26 16:38:20 2005
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Oct 26 16:38:20 2005
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x800706b5 (1717)
Windows Error Text: Interface desconhecida. Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Oct 26 16:37:25 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50
1717
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "1760"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/5/21 15:9:28
Complete: ValidateWinNTAction at: 2006/5/21 15:9:28, returned true
Running: ValidateMinOSAction at: 2006/5/21 15:9:28
Complete: ValidateMinOSAction at: 2006/5/21 15:9:28, returned true
Running: PerformSCCAction at: 2006/5/21 15:9:28
Complete: PerformSCCAction at: 2006/5/21 15:9:28, returned true
Running: ActivateLoggingAction at: 2006/5/21 15:9:28
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
02B6CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: O sistema não pode encontrar o arquivo especificado. Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "1760"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
View 1 Replies
View Related
Apr 23, 2008
Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
Date: 23/04/2008
Time: 16:25:48
User: N/A
Computer: My Server
Description:
SQLVDI: Loc=IdentifySQLServer. Desc=MSSQL$(local). ErrorCode=(1060)The specified service does not exist as an installed service.
. Process=6092. Thread=5960. Client. Instance=(local). VD=.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Can anyone help ?
View 3 Replies
View Related
Nov 3, 2006
I'm getting an error when trying to install the SQL Server 2005 Express. After it installs the Native Client & Support file, it goes through a configuration check.
I'm getting this error (complete) ::
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <machine name> Error: 2147746132 (0x80040154)
and then stops.
Suggestions would be great!!!
View 3 Replies
View Related
