WMI Configuration Error On Install Of Sept CTP
Sep 29, 2005I get the following error in the when I run setup of the sept CTP.
View 8 Replies
ADVERTISEMENT
Sept CTP Failed To Install
Oct 6, 2005I am getting the following error when I try to install the September CTP on a Windows XP Pro box. The error is SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
View 1 Replies View RelatedUnexpected Error During Sept. CTP Setup?
Oct 12, 2005Hi, During the Sept. CTP setup I get the following when it tries to install the Workstation tools. Anyone else get this and work around it?
View 1 Replies View RelatedSQL 2005 Install Error - WMI Configuration
Jun 28, 2006I'm getting an error when the SQL install program checks the system - "The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine DI-ERP2 Error:2148007941 (0x80080005).
I've tried a bunch of stuff as suggested by some of the other threads, but nothing is working so far...
Any ideas would be greatly appreciated.
Errors Installing SQL 2005 Beta 2 Sept 05
Sep 28, 2005I'm getting this error:
View 4 Replies View RelatedSQL 2012 :: Escape For Quote In Install Configuration File
Aug 19, 2014I've been installing SQL with a unattended install for awhile, and have the following settings in my install_configuration.ini file. I happened to come across a password with a quote in it today, what is the proper way to escape that quote? I've tried the standard backslash method, and found that to not work.
; SQL Server Agent Service Account
AGTSVCACCOUNT="DomainUserName"
AGTSVCPASSWORD="PasswordWith"AQuoteInIt"
; SQL Server Service Account
SQLSVCACCOUNT="DomainUserName"
SQLSVCPASSWORD="PasswordWith"AQuoteInIt"
; SSRS Service Account
RSSVCACCOUNT="DomainUserName"
RSSVCPASSWORD="PasswordWith"AQuoteInIt"
The cool thing is the install apparently tries a few time to authenticate before giving up, because it ends up locking out the account each time.
SQL 2005 Uninstall/Install Problem WMI Configuration Related
May 17, 2006Hi,
I'm the following encountering WMI error message when invoking SQL2005 setup.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine CAPRICORN Error:2147942405 (0x80070005).
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=70342
I'ver found other postings related to WMI errors and tried the WMI fix batch, but to no avail. I noted the error code I have is 2147942405 which is different from other postings. And from examining setup log generated, this seems to be security related, but cannot find much help combing thru msdn/google, etc
Any help is greatly appreciated.
-James Lin
SCC LOG
================================================================
SCCOpenPerformer Added machine: CAPRICORN
RegisterAddCheckArticleCallbackFunction registered callback function
Calling add article callback function for article: WMIServiceWin32OSWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32OSWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 2
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_OperatingSystem
Property name: OSLanguage
Property type: 2
Value: 2
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_OperatingSystem
Property name: SystemDirectory
Property type: 2
Calling add article callback function for article: WMIServiceWin32CompSystemWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32CompSystemWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_ComputerSystem
Property name: NumberOfProcessors
Property type: 2
Calling add article callback function for article: WMIServiceWin32ProcessorWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32ProcessorWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_PROPERTY
Namespace: cimv2
Class name: Win32_Processor
Property name: CpuStatus
Property type: 2
Calling add article callback function for article: WMIServiceReadRegWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceReadRegWorking
Article type: 4, ARTICLE_WMI_TYPE_VALUES
Number of value: 1
Value: 1
Type: ARTICLE_WMI_TYPE_REGISTRY
DefKey: 0x80000002
Subkey name: SOFTWAREMicrosoftWindowsCurrentVersion
Value name: ProgramFilesDir
Registry type: 4
Calling add article callback function for article: WMIServiceWin32DirectoryWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceWin32DirectoryWorking
Article type: 3, ARTICLE_WMI_TYPE_CLASS
Namespace: cimv2
WQL Query: Select * from Win32_Directory where name='C:\'
Calling add article callback function for article: WMIServiceCIMDataWorking
Callback function returned TRUE
Adding Article...
Article Id: WMIServiceCIMDataWorking
Article type: 3, ARTICLE_WMI_TYPE_CLASS
Namespace: cimv2
WQL Query: Select * from CIM_DataFile where name='C:\'
Calling add article callback function for article: XMLDomDocument
Callback function returned TRUE
Adding Article...
Article Id: XMLDomDocument
Article type: 1, ARTICLE_TYPE_GENERIC_FUNCTION
RegisterCallbackFunction registered callback function
Callback filter = 0x6
Performing check on local machine CAPRICORN
Connecting to CAPRICORN machine
ConnectServer returned 0 (0x0)
ConnectServer returned 0 (0x0)
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Creating class instance Win32_ComputerSystem
CreateInstanceEnum Win32_ComputerSystem returned 0 (0x0)
Enumerating the first class of Win32_ComputerSystem
EnumClass of Win32_ComputerSystem returned 2147942405 (0x80070005)
Creating class instance Win32_OperatingSystem
CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0)
Enumerating the first class of Win32_OperatingSystem
EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005)
Creating class instance Win32_OperatingSystem
CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0)
Enumerating the first class of Win32_OperatingSystem
EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005)
Creating class instance Win32_Processor
CreateInstanceEnum Win32_Processor returned 0 (0x0)
Enumerating the first class of Win32_Processor
EnumClass of Win32_Processor returned 2147942405 (0x80070005)
Openning namespace \rootdefault
GetNamespace \rootdefault returned 0 (0x0)
Getting method EnumValues in StdRegProv class
GetMethod returned 0 (0x0)
Executing method EnumValues in StdRegProv class
ExecMethod returned 2147942405 (0x80070005)
Processing article WMIServiceWin32OSWorking
Scc Error: 50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article WMIServiceWin32CompSystemWorking
Scc Error: 50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article WMIServiceWin32ProcessorWorking
Scc Error: 50026 (0xc36a)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article WMIServiceReadRegWorking
Scc Error: 50024 (0xc368)
Error code: 2147942405 (0x80070005)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article WMIServiceWin32DirectoryWorking
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Scc Error: 50022 (0xc366)
Error code: 70347 (0x112cb)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article WMIServiceCIMDataWorking
Openning namespace \rootcimv2
GetNamespace \rootcimv2 returned 0 (0x0)
Scc Error: 50022 (0xc366)
Error code: 70347 (0x112cb)
Calling callback function for reason: 0x2
Callback function returned TRUE
Processing article XMLDomDocument
Scc Error: 0 (0x0)
Error code: 0 (0x0)
Calling callback function for reason: 0x4
Callback function returned TRUE
SccPerformer closed.
SQL 2005 Install Faild By System Configuration Check
Apr 17, 2007I'm trying to install SQL 2005 64bit on a Win2003 R2 SP1 cluster.
The setup faild during the System Configuration Check on one node only with this message box:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.
------------------------------
BUTTONS:
OK
------------------------------
The SQLSetup000x_<servername>_Core.log:
Microsoft SQL Server 2005 Setup beginning at Tue Apr 17 08:21:27 2007
Process ID : 3436
C: empsql2k5_EE_64bitdisc1setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/3/17 8:21:27
Complete: LoadResourcesAction at: 2007/3/17 8:21:27, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/17 8:21:27
Loaded DLL:C: empsql2k5_EE_64bitdisc1xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/3/17 8:21:27, returned true
Running: ValidateWinNTAction at: 2007/3/17 8:21:27
Complete: ValidateWinNTAction at: 2007/3/17 8:21:27, returned true
Running: ValidateMinOSAction at: 2007/3/17 8:21:27
Complete: ValidateMinOSAction at: 2007/3/17 8:21:27, returned true
Running: PerformSCCAction at: 2007/3/17 8:21:27
Complete: PerformSCCAction at: 2007/3/17 8:21:27, returned true
Running: ActivateLoggingAction at: 2007/3/17 8:21:27
Complete: ActivateLoggingAction at: 2007/3/17 8:21:27, returned true
Running: DetectPatchedBootstrapAction at: 2007/3/17 8:21:27
Complete: DetectPatchedBootstrapAction at: 2007/3/17 8:21:27, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__3436" returned false.
Running: PerformSCCAction2 at: 2007/3/17 8:21:27
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2007/3/17 8:21:27, returned true
Running: PerformDotNetCheck at: 2007/3/17 8:21:27
Complete: PerformDotNetCheck at: 2007/3/17 8:21:27, returned true
Running: ComponentUpdateAction at: 2007/3/17 8:21:27
Complete: ComponentUpdateAction at: 2007/3/17 8:21:52, returned true
Running: DetectLocalBootstrapAction at: 2007/3/17 8:21:52
Complete: DetectLocalBootstrapAction at: 2007/3/17 8:21:52, returned true
Running: LaunchLocalBootstrapAction at: 2007/3/17 8:21:52
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 2147614728
Aborting queue processing as nested installer has completed
Message pump returning: 2147614728
Have anyone an idee?
Thanks
Laurent
Cannot Install SQL Server 2005 Developer Edition - Configuration Tools Only
Jul 16, 2006I have tried several times to install
SQL Server 2005 Developer Edition (most recently from MSDN Disk
3097.1) I have tried to complete an uninstall before each
attempt.
I do get the warning about Minimum Hardware Requirement, but can find
nothing in the detail requirements to exclude my PCs configuration.
I have installed: IIS and .NET Framework 2.0
I have also used ..aspnet_regiis -r to register ASP.NET
I am, successfully, running Visual Studio 2005.
Why does the installation process stop there and what can I do next?
Failed To Install And Configure Error On Install
Nov 14, 2007Hi,
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
SQL Server 2005 Install Error (Error 29528. Unexpected Error While Installing Performance Counters. )
Jun 12, 2007I'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?
Error Log Configuration
Oct 5, 2004Hi. I'm debugging our application, and I need to see the Sql Server 2000 error log files. The problem is that the Sql Server Engine does not log every error that occurs.
For example, when I run a query "Select * from kkk", it gives an error saying "Invalid object name 'kkk'", but the error is only returned to the client. Its not logged in the error log files. I think, that this happens because that error has a low level (16), and the log is only for high-level errors.
Is there a way to configure which errors are logged in the error log, or to make all errors get logged??
Thanks!
Configuration Error
Jul 19, 2007I installed the SQL Server Management Studio Express successfully. However when I tried to run the Configuration Tools -> SQL Server Configuration Manager", I have an error that asked me to send report to Microsoft (I am sure it's familiar to all) with this message "sqlwtsn.exe" error. I tried on 2 machines but same results. Went thru few times uninstall and install but to no avail.
Also, I have installed the dotnetfx and msxml6 but still unable to get it work. I am running XP SP2, one Pentium and AMD machine. 512 MB. Please HELP!!! Any other alternative? I am running some project for my school assignments urgently. Thanks in advance for the advice.
SQL Configuration Error
Mar 18, 2008When i open up configuration area i click Surface Area Configuration for Features, a few seconds later i get the message:
Code Snippet
TITLE: Surface Area Configuration
------------------------------
Failed to connect to server localhostMICROSOFT##SSEE. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
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) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Since i was trying to set this up for development purposes i opened the Local TCP ports and configured the firewall to allow SQL traffic through. I went to my application and it successfully connected to the database. So it leaves me wondering if this error i have would make any difference later - can anyone advise how to resolve?
So far i have allowed local remote connections via TCP, ive adjusted the firewall accordingly (which allows other computers to connect to the server and retrieve database information). Im running Windows Server 2008 with SQL 2005 64 bit edition.
Thanks
WMI Configuration Error
Jul 7, 2006Hi,
I tried installing the SQL Server 2005 evaluatio nedition as well as the free Express edition downloadable from the SQL Server 2005 site, and in both cases I got the following error msg:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine MYPC Error:2147749891 (0x80041003).
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342
------------------------------
BUTTONS:
OK
------------------------------
I cannot figure it out. Some posts suggested using a particular batch file. I did, but it didn't make a difference. Any ideas on what I can do?
Thanks!
Ste
Configuration Error...name Wanted
Nov 30, 2006Hi, does somebody recognize the problem with my code? -Thanks!
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: This is an unexpected token. The expected token is 'NAME'. Line 58, position 52.Source Error:
<sessionState mode="SQLServer"stateConnectionString="Jensen"sqlConnectionString=
"datasource=Database;userid=username;password=pass"cookieless="false"timeout="60"/>
The Annoying WMI Configuration Error
May 10, 2006I'm recieving the following error:
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine 'machine information' Error: 2147749896 (0x80041008).
I've researched the error and found out some people were running batch scripts to reinstall wmi, but none of them worked for me. One of them I gave up on after thirty minutes and it wasn't doing anything.
Please give some suggestions on how I can resolve this issue.
Error After Package Configuration
Jul 2, 2007
I have a package that executes succesfully before package is configured.
but when package is configured to use configuration details either from SQL Server configuration table or XML configuration file, gives an error :
[Connection manager "XYZ"] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Can anyone help me out with this ?
Experts !!! this is my second post, my previous post is still unanswered.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1793362&SiteID=1
Package Configuration Error
Oct 16, 2007
I have a package that executes succesfully before package is configured.
but when package is configured to use configuration details either from SQL Server configuration table or XML configuration file, gives an error :
Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
I am using Hit Software OLEDB provider for DB2/400 Connection
Can anyone help me out with this ?
Publication Configuration Error
Feb 7, 2006Hey Everyone,
I am trying to setup publishing on SQL Server 2000 Enterprise. I will be subscribing from a SQL Mobile 2005 database so I have installed the SQL Server 2000 SP3a Replication Components, .NET Framework 2.0, and the SQL Server 2005 Mobile Edition Server Tools.
I was able to go through the 2005 Mobile Web Synchronization Wizard with no problems. However, when I try to run the Configure Publishing and Distribution Wizard, I get the following message at the end:
SQL Server Enterprise Manager could not configure 'GISSERV' as the Distributor for 'GISSERV'
Error 14114: '(null)' is not configured as a Distributor.
The first option I choose is Make 'GISSERV' it's own Distributor. Then, I select the snapshot folder that I shared. And on the third screen, I've tried going with the standard default settings and customizing those settings.
Has anyone else come across this error? Is there anyone else out there replicating from SQL Server 2000 to SQL Server 2005 Mobile?
Thanks in advance,
Lee
Package Configuration Error
Apr 4, 2007Not sure if you guys have run across this error. I created a simple SSIS package to import from a csv file into SQL Server, and I made it configurable so I can point to any of my 4 destination SQL Servers.
In the error list pane, i'm getting this warning:
Warning loading Package.dtsx: Table "[dbo].[SSIS Configurations]" does not have any records for configuration. This occurs when configuring from a SQL Server table that has no records for the configuration.
The funny thing is, the table is populated with 2 properties, Catalog & ServerName, but at run time, its like the Package ignores the SQL table to apply configuration properties.
Any help would be greatly appreciated.
-- J
SQL Error In Configuration Wizard
Aug 15, 2006I am having trouble installing and start SQl server on my machine. Currently, I am running Windows XP on my computer with service Pack 2. Not sure why but every time I try to execute the configuration instance , the start services portion does not execute and I get an error 0 message. Please help!!
Package Configuration Error
Feb 4, 2008Hello Again
I have sql server 2005 installed in my pc. I have to make a DTS package. I did it and it works fine. I have to create a configuration package.
I made it but when i try to debug it, the package show an error in the connection to the database. Checking the xml file all is correct. I tried to change all parameters but it's the same.
Any one knows why it happens?
Thanx
TableAdapter Configuration Wizard Error
Jan 31, 2007Hi,I always use the following sql statement to check whether an email address exists in a database. With my latest project I tried to do this within the TableAdapter Configuration Wizard and it gave me an error: IF NOT EXISTS (SELECT Email FROM tblEmailList WHERE Email=@Email) BEGIN INSERT INTO tblEmailList (Email, DateRegistered) VALUES (@Email, @DateReg) SELECT 1 AS RESULT END ELSE BEGIN SELECT 0 AS RESULT END first it gave an error saying I must declare the variables @Email and @DateReg then when I removed the part of insert and just wanted to check the email address existence it gave me this error:The Compound statement SQL construct or statement is not supportedAny idea anyone?
View 5 Replies View RelatedConfiguration Failed - Error 1460
Jan 11, 2000Guys, could anyone please help me to resolve this problem:
I'm trying to install MSSQL Server 7 Desktop Edition on Windows 98 (First Edition v4.10.1998).
Everything goes smoothly until the 'Starting Service ...' icon appears. Then I'm getting a setup
error which says that it failed to configure server and refers me to 'cnfgsr.out' file:
-------------------------------------
Starting Service ...
An error occurred while attempting to start the service (1460)
SQL Server configuration failed.
-------------------------------------
The ERRORLOG file contains the following:
-------------------------------------
2000-01-11 18:42:40.40 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows 4.10 (Build 1998: )
2000-01-11 18:42:40.48 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2000-01-11 18:42:40.49 kernel All rights reserved.
2000-01-11 18:42:40.52 kernel Logging SQL Server messages in file 'C:MSSQL7logERRORLOG'.
2000-01-11 18:42:40.86 kernel initconfig: Number of user connections limited to 32767.
2000-01-11 18:42:40.87 kernel SQL Server is starting at priority class 'normal'(1 CPU detected).
2000-01-11 18:42:41.02 kernel User Mode Scheduler configured for thread processing
2000-01-11 18:42:43.15 server Directory Size: 2559
2000-01-11 18:42:43.43 spid0 Using 'sqlimage.dll' version '4.0.5'
Stack Dump being sent to C:MSSQL7logSQL00001.dmp
Stack Dump being sent to C:MSSQL7logSQL00002.dmp
2000-01-11 18:42:48.84 spid0 Problem creating symptom dump file due to internal exceptionUnable to get thread context - no pss
2000-01-11 18:42:48.86 spid0 Problem creating stack dump file due to internal exception
---------------------------------------------------
Any help would be appreciated.
Thank you very much.
Package Configuration Wizard Error
Apr 11, 2008Hi. I've created a number of packages in SSIS which just make temp tables out of views. I did them with the "Optimize for many tables" and "Run in transaction" boxes checked.
Now I'm trying to port them over to another database on another server. I'm first going through the Package Configuration Wizard. When I try to finish the wizard I get a error with the following message:
quote:===================================
Could not complete wizard actions. (Microsoft Visual Studio)
===================================
Could not generate the configuration file. (Microsoft.DataTransformationServices.Wizards)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Wizards.ConfigurationWizardPages.ConfigurationWizardSR&EvtID=CouldNotGenerateConfigurationFile&LinkId=20476
------------------------------
Program Location:
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.OnFinish(CancelEventArgs e)
===================================
Failure exporting configuration file.
(ENRLMNT_UniqueRecords_temp)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Package.ExportConfigurationFile(String str)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
I don't know how to resolve it. Anyone?
One way to deal with this particular issue would be just to recreate the SSIS package on the other server. The issue with this is I want to be positive which view I'm making a copy of and I'm not currently. Since the Import/Export has the transaction setting checked, I can't seem to determine what the source was. Help?
Parent Package Configuration Error
May 7, 2008Hi,
I have a child package running under main parent pakage.
I am passing value of integer & string type variables from parent package to child package's variables ( as disscussed in following artical http://msdn.microsoft.com/en-us/library/ms345179(SQL.100).aspx) ,values assigned in child package variables are futher used to build connection string for flat file connection manager in child package.
I have been using this whole SSIS package sucessfully for last three months,but suddenly the following error arises
"OnError,,,,,,,The result of the expression
Code Snippet
"@[User::StrTextFileImpDirectory] +"SomeTextStringHere"+ @[User::StrANTTextFileName] +(DT_STR,30,1252) @[User::Staging_Date_Key]+ "SomeTextStringHere"
on property "ConnectionString" cannot be written to the property. The expression was evaluated, but cannot be set on the property."
When I see the result of above mentioned expression through Log file than it appears that my string variable
Code Snippet"@[User::StrTextFileImpDirectory]
in child package has not been populated with any value from parent package variable, I.e it has been populated with empty string(While this is not desired value).
Same problem arises with my integer type variable
Code Snippet@[User::Staging_Date_Key]
,it has ben populated with value zero (i.e default value at design time for integer type),while this is not desired value.
Can some one guide me how to figure out the cause for error....
Is it possible that such kind of error may arise due to any change in enviornment of server....
Package Configuration Wizard Error
Aug 9, 2006I am attempting to create an XML Configuration file and I am recieving the following error once I click finish in the wizard:
Could not complete wizard actions.
Additional Information:
Could not generate the configuration file. (Microsoft.Data.TransformationServices.Wizard)
Technical Details:
===================================
Could not complete wizard actions. (Microsoft Visual Studio)
===================================
Could not generate the configuration file. (Microsoft.DataTransformationServices.Wizards)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Wizards.ConfigurationWizardPages.ConfigurationWizardSR&EvtID=CouldNotGenerateConfigurationFile&LinkId=20476
------------------------------
Program Location:
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.OnFinish(CancelEventArgs e)
===================================
Failure exporting configuration file.
(eFreedomAS)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Package.ExportConfigurationFile(String str)
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
Name:
eFreedomAS2
Type:
Configuration File
New configuration file will be created.
File name:
C:abc.xml
Properties:
Package.Variables[User::SourcePath].Properties[Value]
Package.Variables[User::SourcePath].Properties[Name]
Package.Variables[User::Packages].Properties[Value]
Package.Variables[User::Packages].Properties[Name]
Package.Variables[User::PackageDefNumber].Properties[Value]
Package.Variables[User::PackageDefNumber].Properties[Name]
Package.Variables[User::Directory].Properties[Value]
Package.Variables[User::Directory].Properties[Name]
Package.Variables[User::DestinationPath].Properties[Value]
Package.Variables[User::DestinationPath].Properties[Name]
Package.Connections[ViewHelpTopicDef].Properties[Name]
Package.Connections[ViewHelpTopicDef].Properties[ConnectionString]
Package.Connections[ViewDef].Properties[Name]
Package.Connections[ViewDef].Properties[ConnectionString]
Package.Connections[ValidationTestDef].Properties[Name]
Package.Connections[ValidationTestDef].Properties[ConnectionString]
Package.Connections[ValidationRulePackageDef].Properties[Name]
Package.Connections[ValidationRulePackageDef].Properties[ConnectionString]
Package.Connections[ValidationRuleFileDef].Properties[Name]
Package.Connections[ValidationRuleFileDef].Properties[ConnectionString]
Package.Connections[ValidationRuleDef].Properties[Name]
Package.Connections[ValidationRuleDef].Properties[ConnectionString]
Package.Connections[ValidationMessageFileDef].Properties[Name]
Package.Connections[ValidationMessageFileDef].Properties[ConnectionString]
Package.Connections[ValidationMessageDef].Properties[Name]
Package.Connections[ValidationMessageDef].Properties[ConnectionString]
Package.Connections[ValidationIdentifierDependency].Properties[Name]
Package.Connections[ValidationIdentifierDependency].Properties[ConnectionString]
Package.Connections[ValidationCalcGraphEdge].Properties[Name]
Package.Connections[ValidationCalcGraphEdge].Properties[ConnectionString]
Package.Connections[UserGroupFeatureDef].Properties[Name]
Package.Connections[UserGroupFeatureDef].Properties[ConnectionString]
Package.Connections[UserGroupFeature].Properties[Name]
Package.Connections[UserGroupFeature].Properties[ConnectionString]
Package.Connections[UserGroupDef].Properties[Name]
Package.Connections[UserGroupDef].Properties[ConnectionString]
Package.Connections[UserGroup].Properties[Name]
Package.Connections[UserGroup].Properties[ConnectionString]
Package.Connections[TableDef].Properties[Name]
Package.Connections[TableDef].Properties[ConnectionString]
Package.Connections[Source].Properties[UserName]
Package.Connections[Source].Properties[ServerName]
Package.Connections[Source].Properties[Password]
Package.Connections[Source].Properties[Name]
Package.Connections[Source].Properties[InitialCatalog]
Package.Connections[Source].Properties[ConnectionString]
Package.Connections[SelectListItemDef].Properties[Name]
Package.Connections[SelectListItemDef].Properties[ConnectionString]
Package.Connections[SelectListDef].Properties[Name]
Package.Connections[SelectListDef].Properties[ConnectionString]
Package.Connections[ScriptAssemblyDef].Properties[Name]
Package.Connections[ScriptAssemblyDef].Properties[ConnectionString]
Package.Connections[PrintedPageFormulaScriptDef].Properties[Name]
Package.Connections[PrintedPageFormulaScriptDef].Properties[ConnectionString]
Package.Connections[PageDef].Properties[Name]
Package.Connections[PageDef].Properties[ConnectionString]
Package.Connections[PageCalcPathSubPath].Properties[Name]
Package.Connections[PageCalcPathSubPath].Properties[ConnectionString]
Package.Connections[PageCalcPath].Properties[Name]
Package.Connections[PageCalcPath].Properties[ConnectionString]
Package.Connections[PackageLinkDef].Properties[Name]
Package.Connections[PackageLinkDef].Properties[ConnectionString]
Package.Connections[PackageImportTypeDef].Properties[Name]
Package.Connections[PackageImportTypeDef].Properties[ConnectionString]
Package.Connections[PackageIdentifierGroupDef].Properties[Name]
Package.Connections[PackageIdentifierGroupDef].Properties[ConnectionString]
Package.Connections[PackageIdentifierDef].Properties[Name]
Package.Connections[PackageIdentifierDef].Properties[ConnectionString]
Package.Connections[PackageExportTypeDef].Properties[Name]
Package.Connections[PackageExportTypeDef].Properties[ConnectionString]
Package.Connections[PackageDef].Properties[Name]
Package.Connections[PackageDef].Properties[ConnectionString]
Package.Connections[PackageDataItemTextDef].Properties[Name]
Package.Connections[PackageDataItemTextDef].Properties[ConnectionString]
Package.Connections[OnlinePagePrintedPageDef].Properties[Name]
Package.Connections[OnlinePagePrintedPageDef].Properties[ConnectionString]
Package.Connections[OnlinePageDefDependency].Properties[Name]
Package.Connections[OnlinePageDefDependency].Properties[ConnectionString]
Package.Connections[OnlinePageDef].Properties[Name]
Package.Connections[OnlinePageDef].Properties[ConnectionString]
Package.Connections[MaterialityToleranceDef].Properties[Name]
Package.Connections[MaterialityToleranceDef].Properties[ConnectionString]
Package.Connections[LineDef].Properties[Name]
Package.Connections[LineDef].Properties[ConnectionString]
Package.Connections[ImportTypeDef].Properties[Name]
Package.Connections[ImportTypeDef].Properties[ConnectionString]
Package.Connections[ImportDef].Properties[Name]
Package.Connections[ImportDef].Properties[ConnectionString]
Package.Connections[IdentifierStateDef].Properties[Name]
Package.Connections[IdentifierStateDef].Properties[ConnectionString]
Package.Connections[IdentifierRelatedDef].Properties[Name]
Package.Connections[IdentifierRelatedDef].Properties[ConnectionString]
Package.Connections[IdentifierPrintReferenceDef].Properties[Name]
Package.Connections[IdentifierPrintReferenceDef].Properties[ConnectionString]
Package.Connections[IdentifierGroupUserGroupFeatureDef].Properties[Name]
Package.Connections[IdentifierGroupUserGroupFeatureDef].Properties[ConnectionString]
Package.Connections[IdentifierGroupUserGroupFeature].Properties[Name]
Package.Connections[IdentifierGroupUserGroupFeature].Properties[ConnectionString]
Package.Connections[IdentifierGroupIdentifierDef].Properties[Name]
Package.Connections[IdentifierGroupIdentifierDef].Properties[ConnectionString]
Package.Connections[IdentifierGroupIdentifier].Properties[Name]
Package.Connections[IdentifierGroupIdentifier].Properties[ConnectionString]
Package.Connections[IdentifierGroupDef].Properties[Name]
Package.Connections[IdentifierGroupDef].Properties[ConnectionString]
Package.Connections[IdentifierGroup].Properties[Name]
Package.Connections[IdentifierGroup].Properties[ConnectionString]
Package.Connections[IdentifierDef].Properties[Name]
Package.Connections[IdentifierDef].Properties[ConnectionString]
Package.Connections[IdentifierDataItemTextDef].Properties[Name]
Package.Connections[IdentifierDataItemTextDef].Properties[ConnectionString]
Package.Connections[FormulaScriptDef].Properties[Name]
Package.Connections[FormulaScriptDef].Properties[ConnectionString]
Package.Connections[FormulaDef].Properties[Name]
Package.Connections[FormulaDef].Properties[ConnectionString]
Package.Connections[FeatureGroupFeatureDef].Properties[Name]
Package.Connections[FeatureGroupFeatureDef].Properties[ConnectionString]
Package.Connections[FeatureGroupDef].Properties[Name]
Package.Connections[FeatureGroupDef].Properties[ConnectionString]
Package.Connections[FeatureDef].Properties[Name]
Package.Connections[FeatureDef].Properties[ConnectionString]
Package.Connections[ExportTypeRelatedDef].Properties[Name]
Package.Connections[ExportTypeRelatedDef].Properties[ConnectionString]
Package.Connections[ExportTypeFormulaScriptDef].Properties[Name]
Package.Connections[ExportTypeFormulaScriptDef].Properties[ConnectionString]
Package.Connections[ExportTypeExportDef].Properties[Name]
Package.Connections[ExportTypeExportDef].Properties[ConnectionString]
Package.Connections[ExportTypeDef].Properties[Name]
Package.Connections[ExportTypeDef].Properties[ConnectionString]
Package.Connections[ExportTypeBlobTypeDef].Properties[Name]
Package.Connections[ExportTypeBlobTypeDef].Properties[ConnectionString]
Package.Connections[ExportFormulaScriptDef].Properties[Name]
Package.Connections[ExportFormulaScriptDef].Properties[ConnectionString]
Package.Connections[ExportDef].Properties[Name]
Package.Connections[ExportDef].Properties[ConnectionString]
Package.Connections[ColumnHeaderDef].Properties[Name]
Package.Connections[ColumnHeaderDef].Properties[ConnectionString]
Package.Connections[ColumnDef].Properties[Name]
Package.Connections[ColumnDef].Properties[ConnectionString]
Package.Connections[CellTypeFileTypeDef].Properties[Name]
Package.Connections[CellTypeFileTypeDef].Properties[ConnectionString]
Package.Connections[CellTypeDef].Properties[Name]
Package.Connections[CellTypeDef].Properties[ConnectionString]
Package.Connections[CellRangeDef].Properties[Name]
Package.Connections[CellRangeDef].Properties[ConnectionString]
Package.Connections[CellRangeCellDef].Properties[Name]
Package.Connections[CellRangeCellDef].Properties[ConnectionString]
Package.Connections[CellOverrideDef].Properties[Name]
Package.Connections[CellOverrideDef].Properties[ConnectionString]
Package.Connections[CellDef].Properties[Name]
Package.Connections[CellDef].Properties[ConnectionString]
Package.Connections[CategoryDef].Properties[Name]
Package.Connections[CategoryDef].Properties[ConnectionString]
Package.Connections[CalcPathSubPath].Properties[Name]
Package.Connections[CalcPathSubPath].Properties[ConnectionString]
Package.Connections[CalcPath].Properties[Name]
Package.Connections[CalcPath].Properties[ConnectionString]
Package.Connections[CalcGraphEdge].Properties[Name]
Package.Connections[CalcGraphEdge].Properties[ConnectionString]
Package.Connections[AreaDef].Properties[Name]
Package.Connections[AreaDef].Properties[ConnectionString]
Configuration Error In RoleManager In Security VSS
Mar 3, 2006
We have a project that is in a server with windows 2000 (SQL Server 2005 and .Net 2005) And the other developer has a windows XP machine ( .Net 2005) , We are using the VSSC for the project , when the other developer run the application , the following error is show :
Server Error in '/XXX' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load type 'XXXSecurity.RoleSql'.
Source Error:
Line 27: <roleManager enabled="true" defaultProvider="SqlRoleManager" cacheRolesInCookie="true" cookieTimeout="30" cookieRequireSSL="false" createPersistentCookie="true">
Line 28: <providers>
Line 29: <add name="SqlRoleManager" type="XXXSecurity.RoleSql" connectionStringName="MySqlConnection" applicationName="XXX"/>
Line 30: </providers>
Line 31: </roleManager>
Source File: C:Documents and SettingsYYYYMy DocumentsVisual Studio 2005ProjectsXXXRRRRKKKKKweb.config Line: 29
Where XXX is the name of application.
SomeOne Know How Help Me Please???
Report Services Configuration Error
Jan 3, 2007
Hello,
I am a complete Newbie with SQL Server 2005. Can someone help with this problem or at least point me in the right directio for diagnosing it correctly.
I'm learning the Standard SQL product on Windows XP Pro, and everything on my computer has the latest updates (from Windows Updates). I had previously installed SQL Express, but removed all products associated with that according to steps listed at Microsoft's site (pre-installation steps for SQL Server 2005 Standard, as they relate to the removal of SQLExpress).
My problem is I can't run "Reporting Services Configuration". When I try to run it, the main window opens with "Report Server Installation Instance Selection" window, and immediately I get an error box that says, "An unknown error has occurred in the WMI Provider. Error Code 80040219". When I click Ok, I'm back at the instance selection window, where my computer name is by default the machine name, but the instance name is greyed out. After the error, Event Viewer/Application gives the info below. I noticed that it refers to MSSQL.2Reporting Services - but that was the directory for SQL Express Reporting Services, according to the mapping in my registry. It shows mssql.4 as the Standard SQL Reporting Services directory
Event Type: Error
Event Source: Report Server
Event Category: (5)
Event ID: 133
Date: 1/3/2007
Time: 11:08:23 AM
User: N/A
Computer: BSDELL
Description:
The description for Event ID ( 133 ) in Source ( Report Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: c:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerRSReportServer.config.
When I try to connect to Report Services through SQL Server Management Studio, I get the following error: Cannot connect to BsDell - with the following technical details...
Program Location:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Error Sql Server Configuration Manager
Sep 5, 2007when i open services in the computer management console i get the error message
sql server configuration manager .... error... snap in...restart mmc
SQL Reporing Services Configuration Error
Apr 20, 2007In SQL Rep Serv Config Manager under Web Service Identity, the ASp.NET Service account is disabled and if I enter the Report Server application pool into Report Server and Report Manager it brings back:
Setting Web Service Identity
There was an error setting the identity for the web service. The previosly set identity will still be used.
ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070005
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
Any help would be greatly appreciated.
Thanks,
Anoop
SharePoint Configuration && SQL Express - Error 4060
Apr 26, 2006While trying to "Set Configuration Database Server" for Windows SharePoint Services I receive the error:
"Cannot open database "SharePoint" requested by the login.
The login failed. (Error code: 4060)"
I set up a test bed server 'SNET' with WinServer03 SP1, IIS 6. SQL Server Express, and SharePoint Services.
In "Set Configuration Database Server" I used:
Database server: snetsqlexpress
SQL Server database name: SharePoint (I know real imaginative)
Database connection type: * Use Windows authentication
X Connect to existing configuration database.
If I try "Use SQL Authentication"
"Login failed for user <username>. The user is not associated with a trusted SQL Server connection. (Error code: 18452)"
First let me say that while I'm not a newbie, as usual I've bitten off more than I can chew comfortably. Server '03, Active Directory, IIS 6, SQLExpress, and SharePoint are all relatively new to me, hence the test bed server, and I'm on a pretty steep learning curve.
But what's life without a challenge.
So the short and sweet of it is can somebody point me in the right direction to find the root cause of this error. I do have other programs running with this instance of SQLExpress and doing so quite happily. And I've given myself god privileges in AD just to try to get around this.