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.
I am running a 'simple' stored procedure from the Query Analyser (command - FindCustomer L18239, [ ]) which should return a name from a customer table from the input id. It does return the name but I keep getting the message 'Server: Msg 245, Level 16, State 1, Procedure FindCustomer, Line 9 Syntax error converting the varchar value 'Kevin ' to a column of data type int.' - Any ideas what I've done wrong?, thanks.
I recently migrated from 2000 to 2005 database. On the new server, I kept getting this type of error message when there is some sort of join involved and they are not complex join either.
Error - "A severe error occurred on the current command. The results, if any, should be discarded."
ie
select A.Cookie1, A.Cookie2 into BookersLookers_Cookie from BookersLookers_DataSet A LEFT JOIN ActionSetup B on A.ActionID = B.ActionID group by A.Cookie1, A.Cookie2
Is there something in the code where I could prevent this error from happening?
Intra-query parallelism caused your server command (process ID #57) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).
I've seen MS KnowledgeBase for that (http://support.microsoft.com/default.aspx?scid=kb;EN-US;837983)
But I have some probs with it: 1. I don't have permissions for this kind of queries "USE master EXEC sp_configure 'show advanced option', '1' RECONFIGURE WITH OVERRIDE GO" 2. I don't know what is an "intra-query parallelism"...
I'm attaching the query I use. The query runs OK for some parameters but gets this error msg on other parameters.
I'm using a single CPU on 2003 STD Edition.
Query:
create table #mytemp_table (client_id int not null, commission_value int null) insert into #mytemp_table (client_id, commission_value) select client_id, sum(transfer_value) from users_transfers where transfer_type in (1,3) and is_paid = 1 group by client_id
select u.name [Vendor], u.email, sum(cost) as Payment, cmpd.vendor_id, ua.name [Agent], vd.join_date, commission_value [paid], allow_sign from reports ra left outer join codes ctd on ra.affiliation_code_show = ctd.affiliation_code_show left outer join traffic cmp on cmp.campaign_id = ctd.campaign_id left outer join traffic_details cmpd on cmp.campaign_id = cmpd.campaign_id left outer join userssb u on cmpd.vendor_id = u.client_id left outer join userssb ua on cmpd.agent_id = ua.client_id left outer join users_details vd on u.client_id = vd.client_id left outer join #mytemp_table com_paid on com_paid.client_id = u.client_id left outer join allow_db asd on asd.client_id = u.client_id where [conditions] group by
[all the group fields] having sum(cost) > 2999 order by u.name
Hey guys, I bet you didn't guess it but I'm posting here because i need help :P
What I'm trying to do is create a procdure that will run a task on the first Working day of the week. Normally monday but then theres public holidays etc etc.
on a normal week the task runs monday, on public holiday weeks it is tuesday, and christmas even pushs it back to wednesday.
so far im using the dts designer to do this
What I have is: a table with the last run date(not sure I even need this now) a table with a list of public holidays(date) along with a year column
a sql statment getting the last ran date and storing it into a global variable glastrundate
a activex vbscript getting the current year, which is then stored into a globalvariable(gcurrentyear)
then gcurrentyear is then used in a select statement to get the public holidays that are in that year, which are then stored to a rowset (gpubdays) (select pubdays from tbl_pubdays where pubyear = ?)
Now the problem, I am trying to use another axtivex script to check the current date against each row in the global gpubdays. well really I just can't get the for each loop to work, was trying to use it like: for each row(or pubday) in gpubdays if day = today then task fails and will not run the rest of the procedure end if next
sorry if it isnt very clear, still kinda new to SQL server
thanks if you help ^_^
ps. please dont go writing all the code for me, just a nudge in the general right direction
I know I shouldn't rely on sysdepends because it's got all sorts of problems with broken dependency chains, etc. But it's better than nothing for finding dependencies, short of rolling your own t-sql parser. So I use sysdepends anyway, with all its faults. I just don't rely on it. anyway, to the point, just an fyi really:
Here's something about sysdepends discovered today that annoys me. If you introduce a dependency of a proc on a table by selecting from the table in the proc, the sql parser discovers this and dutifully adds a row to sysdepends. Very well. But if you do the same select into a temp table, sysdepends doesn't pick up the dependency! Here's what I mean:
use master go
drop database test_sysdepends go
create database test_sysdepends go
use test_sysdepends go
create table MyTable01 (id int) go
create proc MyProc01 as select id from MyTable01 go
create proc MyProc02 as create table #t (id int)
-- comment this next line out and the dependency is picked up. -- but as long as we insert into the temp table, we don't pick it up... :( insert into #t select id from MyTable01
select id from #t go
select so2.name as parent ,so1.name as dependent from sysdepends d join sysobjects so1 on d.id=so1.id join sysobjects so2 on d.depid=so2.id go
Well all bugs are annoying, but this one is particularly annoying because it kills the BIDS session with consequent loss of all changes made since the last save.
Click on a control flow task. Position the cursor so that it changes to the 4-way pointer. Drag the task a little bit. The UI locks up, and then BIDS disappears.
I can't repro this on demand, but it has happened about 6 times in the past month. Anyone else seen this one?
hi, i'm working with LINQ to SQL and i have a table called Account, in that is Type, which is an int in the database but i map it to a AccountType enum, this works fine, but if i go into the dbml designer and change something later on, it gets errors, so i have to change all int->enum mappings back to int, recompile and then set them again! has anyone else had this? kindest regards
I have the following problem in SSIS and it's driving me nuts!!!!!
My situation is as follows :
Data Source 1 & Data Source 2are joined using a merge join. This bit works fine.
The output of the above join is then joined to a third data source but this time, I only get 63 rows coming through instead of 77097 even though the join key in the second merge join component is the same as the first one!!!
I thought I was going mad so I decided to see if the same problem occurs if I was to do this with T-SQL. I created 3 temporary tables for each of my data sources.
I did an inner join between tmpTable_Source1 and tmpTable_Source2, I then stored the result in tempTable4
The final inner join was performed between tempTable4 and tempTable3 and the result produced 77097 and not 63 rows.
What the hell is SSIS playing at?! The merge keys I used in T-SQL is the same one I used in my SSIS package!!!!
I have SQL Server Manager 8.00.2039 installed because I have one program(app) installed that requires it be installed. For the first littlewhile when I had SQL server installed it would only show up in thetaskmanager tray, now MOST of the time, it shows up as a popup on mydesktop and also in my task tray when I first start XP (SP2). It staysthere until I close it. Is there a way to prevent the SQL from poppingup?Thanks
I have a report that has rolled-up groups with the "expand row" + sign on each row. Everything works great except when you click the + the report scrolls everything above the + off the screen which completely re-shifts the users context... which nobody likes... how can we turn this "feature" off please?
I am having a problem connecting to my SQL Server 2005 database at the same time with SQL Management Studio Express and from the website at the same time. Everytime I want to view any pages in my site that access the database, I have to close management studio and restart the server for some reason or i get a failed login error message. Is it NOT possible to work on the database at the same time as viewing pages in the website that access the database? This freaking error is realy starting to bug me. I sure hope that there is a work around or something for this.
Hello, I am having problems inserting information into my DB.
First is the code for the insert
Sub AddCollector(Sender As Object, E As EventArgs) Message.InnerHtml = ""
If (Page.IsValid)
Dim ConnectionString As String = "server='(local)'; trusted_connection=true; database='MyCollection'" Dim myConnection As New SqlConnection(ConnectionString) Dim myCommand As SqlCommand Dim InsertCmd As String = "insert into Collectors (CollectorID, Name, EmailAddress, Password, Information) values (@CollectorID, @Name, @Email, @Password, @Information)"
myCommand = New SqlCommand(InsertCmd, myConnection)
Try myCommand.ExecuteNonQuery() Message.InnerHtml = "Record Added<br>" Catch Exp As SQLException If Exp.Number = 2627 Message.InnerHtml = "ERROR: A record already exists with the same primary key" Else Message.InnerHtml = "ERROR: Could not add record" End If Message.Style("color") = "red" End Try
myCommand.Connection.Close()
End If
End Sub
No matter what I get a "Could not add record" message
Even substituting the insert command string with my stored procedure I would get the same thing
Stored Procedure:
CREATE Procedure CollectorAdd ( @Name nvarchar(50), @Email nvarchar(50), @Password nvarchar(50), @Information nvarchar(3000), @CustomerID int OUTPUT ) AS
INSERT Collectors ( Name, EMailAddress, Password, Information )
VALUES ( @Name, @Email, @Password, @Information ) GO
Can anyone see any problems with this code? It looks good to me but I get the same message always.
Originally I started using SQL Server Management Studio on the server directly. When I would right click on a view->edit I would essentially get a Alter Script of the view. Clicking on view-> design would open the query editor.
However I decided to connect to the server from my desktop instead using a local installation of SQL Server Management Studio. Now when I right click on a view I only get the modify option which opens the Query Editor and not the actual code that can be scripted. I know I can just right click->script view as->alter to to get similar results. I just can't seem to find any options to change this functionality. Does anybody know how to change this or is this a limitation of a desktop installaion?
So on my local server I have a username CWI. I have my main DB: CW.
CWI is the owner of 5 schemas on CW, and everything works great. --- I now go and create a new DataBase called CWTest. I want to now add the user CWI to the security section of CWTest (The same way I did it in 2000). However, now I get the error message: "The login already has an account under a different user name."
When I created my DataBase, IT had the default user, but now I want to add another user so I can create my schemas. --- On our live servers, we will have 100-300 Databases all using the same useraccount as the "God Mode" user.
I have a very confusing/complicated query that I am trying to run and getting not the results that i want.
Essentially I have three tables (t1, t2, t3) and I want to select data from two of them, but there are conditions on the data where I need fields to match across pairs of tables. When I run my select query I am getting far too many records - it's giving me all possible combinations, instead of the proper combinations that I want.
Select t1.*, t3.field2, t3.field3 FROM, t1, t2, t3WHERE t2.field4=t3.field4 AND t1.field5=x AND t1.field6=t2.field6
I suspect there is plenty wrong with this query - where should I start correcting it?
Hello, does anyone hate the new interface where you manage the Table Relationships, Indexes, and etc?
I hate it a lot for these reasons. 1) Dialog window cannot be resized (really really annoying) 2) The Table-Relationship configuration dialog window is not as convenient to use as SQL Server 2000 Enterprise Manager.
I hope this is the correct place to provide feedback and I hope this will get modified a bit in the next service pack (or) update....
Hi. 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!
I 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.
When 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.
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?
Hi, 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"/>
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.
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
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?
Not 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.
I 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!!
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.
Hi,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?
Guys, 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.
Hi. 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)
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?
Hi, 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
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....
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)
at Microsoft.SqlServer.Dts.Runtime.Package.ExportConfigurationFile(String str) at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
