hi Everybody,
for some reason my Sql Server has stopped and i am not able to restart it at all, do i have to reinstall the complete SQl Software or is there ne way i can start the MSSQL Server
I have created a simple package that uses a sql command to pull data from an oracle database and inserts the data into a sql 2005 table. Some of the data fields that i am pulling from contain two digits after the decimal point, however this data is lost when it gets into sql. I have even tried putting the data into a flat file, and still the data is lost.
In the package I have a ole db source connection which is the oracle database and when i do the preview i see all the data I need. I am very confused and tried a number of things to get the data into sql, but none work. Any ideas would be very helpful.
thanks
HI
I need to copy the table structures from my production database to development database but not loose the data in developement. Is there a way to achive this by creating some scripts.
thanks
Hi All,
i'm using a "data conversion" object to convert a numeric field to a string just before i save the record set to the database.
the problem is when this numeric field is > 0 it looses the precision on its decimal value.
example, if numeric value is 0.32
after converting this to a string, the new value will be : .32
it's lost the 0 infront of it. i can't do this converion in the query level because it's a derived field, so i need to convert it to a string before stroing it.
when converting to string i'm using the code page 1252 (ANSI - Latin I). i also tried with unicode string both looses this 0 infront.
can any one help on this?
I created a custom transform that has a custom interface and is a wizard that uses a web service. It creates custom properties and output columns on the fly. I set the dialog result to Ok and close at the end of the steps. The transform then has the custom fields and output columns I created in the wizard. I've verified this by right clicking on the transform and going to the advanced editor. If I then immediately run the package, the custom fields don't exist in the CustomPropertiesCollection. If I close the package and reopen it, the properties now are gone. If I then go through the wizard again, thus recreating the properties, they stay and don't disappear. The quickest way to get a working transform is to add it to my data flow then save, close and reopen the package and then go through the wizard. Just saving after I add the transform does not help.
Does anyone know what might be causing this very strange problem?
I have posted this in the SQL Server Data Access forum but wondered if this was a better location.
We have two Server 2005 boxes and one Sever 2000.
About 3 months ago we started experiencing random database connection drops.
These were manifested by exception errors in database applictions that have worked fine for years.
The .NET application exception message: "The specified network name is no longer available"
The Delphi application exception message: "Possible network error. Write to SQL Server Failed."
Server Management Studio also started giving the error:
"Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)"
All three servers randomly lose connections.
All our clients randomly lose connections.
I don't think its a network problem because only db applications seem to be affected.
Also, a client can be running two or more db applications. Application A will fail, while B marches on unaffected.
Does anyone have any ideas what could be causing this?
I would like a way to monitor the SQL Server connections but am not sure how.
sys.sysprocesses seems to show all the connections, but it doesn't show when a connection is being terminated.
SQL Server log shows no connection messages.
Thank you and Help!
Hello all,
If this is not best forum to ask this question on, please advise.
We have two Server 2005 boxes and one Sever 2000.
About 3 months ago we started experiencing random database connection drops.
These were manifested by exception errors in database applictions that had worked fine for years.
The exception error stated that no db connection exists even though it had been fine a moment ago.
Server Management Studio also started giving the error:
"Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)"
All three servers randomly lose connections.
All our clients randomly lose connections.
I don't think its a network problem because only db applications seem to be affected.
Also, a client can be running two db applications. Application A will fail, while B marches on unaffected.
Does anyone have any ideas what could be causing this?
I would like a way to monitor the SQL Server connections but am not sure how.
sys.sysprocesses seems to show all the connections, but it doesn't show when a connection is being terminated.
SQL Server log shows no connection messages.
Thank you and Help!
This is a question more about EFS, I think, than SQL itself, so apologies for that.
View 1 Replies View RelatedI have a bad web application install for Master Data Services. This was the first installation and there was some back and forth to get it going. I now have set up an identically configured server correctly and figure the easiest thing to do is delete the web app and re-create it rather than spend a bunch of time troubleshooting. How do I do this? I've googled and haven't had much luck. I only want to uninstall the web app since everything up until then was installed correctly.
View 1 Replies View RelatedHi all,
One year ago, I did "Ruuning Setup to Install AdventureWorks Sample Databases and Sample" to install "AdventureWorks" in my SQL Server Management Studio Express. Now, It just have the name "AdventureWorks" on and no contents (no tables, schemas, etc.) in it. In my Control Panel, Add or Remove Programs, AdventureWorksDB (162.00 MB) is still there and AdventureWorks (Windows Installer Package [27,992 KB]) is in my C:/drive.
(1) Should I delete the name "AdventureWorks" in my SQL Server Management Studio Express, and remove AdventureWorksDB (162.00 MB) from the Add or Remove Program, before I re-install AdventureWorks, AdventureWorksDW, and Adventure Works DW sample databases and samples from Windows Installer Package [27,992 KB]? Is my old AdventureWorks (Windows Installer Package [27,992 KB]) still good and complete for installation?
(2) SQL Server 2005 Books Online (September 2007) presents "Reinstalling Sample Databases from Script". But (i) I can not find the file instawdb.sql for reinstalling AdventureWorks from script and I do not have AdventureWorks OLTP in my C:Program FilesMicrosoft SQL Server90ToolsSamples folder, (ii) I can not find the file instawdwdb.sql for reinstalling AdventureWorksDW from script and I do not have AdventureWorks Data Warehouse in my C:Program FilesMicrosoft SQL Server90ToolsSamples folder either!!??
Please help and tell me what is the best way and some detailed instructions/tips to have AdvenureWorks, AdventureWorksDW, and Adventure Works DW sample databases and samples installed in my SQL Server Management Studio Express.
Thanks in advance,
Scott Chang
I need to reinstall on one production server. What steps to be taken before uninstall and install
I am new to SQL Server, please can anyone guide me on this?
Since there is not a method to uninstall SP2 for SQL Server 2005 Express, it is recommended to completely uninstall and then reinstall. I have backed up all databases as well as generated a script to recover username/passwords, is there anything else I should be taking into consideration?
View 4 Replies View RelatedThey are corrupt. I cannot get the odbc driver applet for sql serverto open when I click add and I cannot configure any existing ones. Andthe usage of the drivers fail.Other ODBC drivers work.Does anyone know how to reinstall the SQL Server set of ODBC drivers?MDAC wouldn't install, said it was already at current level.Thanks for any ideas.
View 2 Replies View RelatedHi,I just unistalled Sql Management Express and now I want to install it again but the installer says the product is already installed,Can somebody help me with this
View 3 Replies View RelatedIn previous post in the Getting Started section, I discussed problems trying to run queries on multiple databases:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=299240#299240&SiteID=1
Nobody could help with the problem. I eventually got a query to run after several attempts at deleting and recreating databases. Then, I was hit with the following error message:
Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration)
Nobody could help with that either but based on posts with the same message, I tried uninstalling sql server. It wouldn't uninstall nor can I repair or reinstall. Uninstalling thru Add or Remove Programs only resulted in the program listing being removed from Add or Remove Programs. Most of the sql server programs are still installed. They can be run but continue to malfunction. When I try a new installation, I get a message that the programs are already installed.
Is a complete reinstall of windows xp, programs and data the only solution? I hate to believe it; but, at this point, I see no other choice.
Previously, I have installed SQL 2005 developer edition simplyfied chinese
successfully. But yesterday, I tried to install mobile client software
factory. The installation process create a database as following:
Create DATABASE [AdventureWorksMobileStaging] ON PRIMARY
( NAME = N'AdventureWorksMobileStaging', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging.mdf' , SIZE = 195584KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
( NAME = N'AdventureWorksMobileStaging_log', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging_log.ldf' , SIZE = 265344KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
But today, when I start my notebook, SQL server could not be started.
Then I uninstalled the SQL instance by start->control panel->uninstall...The uninstall
process seems OK. Note that I only uninstalled the instance.Then I tried to reinstall
SQL 2005. However it was reported a Performance Monitor Counter registry key mismatch
error occures. I tried to fix it but failed. The problem is as following:
1, The installation process report a warning of low memory.
My notebook has 512M memory. I have reinstalled SQL 2005 once successfully. At that
time, the warning also shows, but it seems that this warning does not affect installation.
2, User type problem.
The OS of my notebook is XP professional, which is upgraded from XP home edition.
I login it using a domain user such as: "my company's domainmyaccount". I found it
curiously that although I assign myaccount as an Administrator, it will automaticly
changed to "SQL$...." account. I don't know why and when the account property is
changed. But everytime, when I found, I will assign myaccount as an Administrator
back.
3, Performance Monitor Counter registry key problem.
To fix the problem, I firstly tried to run lodctr.exe in cmd window but failed.
When I cd to c:windowssystem32 dir, I can ran lodctr.exe correctly.
I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib,
the result is:
"Last Counter"=dword:0000149c (11128)
"Last Help"=dword:0000149d (11129)
Then I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib 09
and 004, the result is confusing. I can find counter and help key,but both keys contains
really a lot of stuff as:
(1) first page of Counter key:
1
1847
2
System
4
Memory
6
% Processor Time
10
File Read Operations/sec
12
(2) first page of Help key:
3
The System performance object consists of counters that apply to more than one instance of a component processors on the computer.
5
The Memory performance object consists of counters that describe the behavior of physical and virtual memory on the computer. Physical memory is the amount of random access memory on the computer. Virtual memory consists of the space in physical memory and on disk. Many of the memory counters monitor paging, which is the movement of pages of code and data between disk and physical memory. Excessive paging, a symptom of a memory shortage, can cause delays which interfere with all system processes.
7
% Processor Time is the percentage of elapsed time that the processor spends to execute a non-Idle thread. It is calculated by measuring the duration of the idle thread is active in the sample interval, and subtracting that time from interval duration. (Each processor has an idle thread that consumes cycles when no other threads are ready to run). This counter is the primary indicator of processor activity, and displays the average percentage of busy time observed during the sample interval. It is calculated by monitoring the time that the service is inactive, and subtracting that value from 100%.
9
% Total DPC Time is the average percentage of time that all processors spend receiving and servicing deferred procedure calls (DPCs). (DPCs are interrupts that run at a lower priority than the standard interrupts). It is the sum of Processor: % DPC Time for all processors on the computer, divided by the number of processors. System: % Total DPC Time is a component of System: % Total Privileged Time because DPCs are executed in privileged mode. DPCs are counted separately and are not a component of the interrupt count. This counter displays the average busy time as a percentage of the sample time.
11
File Read Operations/sec is the combined rate of file system read requests to all devices on the computer, including requests to read from the file system cache. It is measured in numbers of reads. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval.
I could not find the maximum value of the Counter key and help key, so I could not repair
Last Counter and Last Help key as discribed at SQL 2005 help. Which item correspond to
maximum value of the Counter key and help key?
I tried to correct Last Counter and Help key as:
"Last Counter"=dword:0000149c (5276)
"Last Help"=dword:0000149d (5277)
But it also doesn't work.
Hi,
I had to do a system restore to solve some other issues now my SQL Server 2005 doesnt work (SQL Server 2000 on the same machine [diffrent instance] does). I have tried to uninstall with add/remove programs but the instance doesnt appear there. I have tried to use the 'ARPWrapper.exe /Remove' command as described in KB909967 wich also fails.
I have also tried to reinstall with no sucess. I also tried uninstalling SQL2000 and removing as many references as I could find, again now joy.
Is there a script somewhere to remove everything (although I would like to try and keep the SQL2000 instance)?
I had SQL Server 2005 Express installed on my computer, but was having problems with it interacting with Visual c++ 2005 Express Edition. I uninstalled both items, but now cannot get SQL Server to reinstall. Everything works fine until the installation gets to the "SQL Server Database Services" portion. At that point, I get a failure stating, "The SQL Server service failed to start. For more information see the SQL Server Books Online topics, 'How To: View SQL Server 2005 Setup Log Files' and 'Starting SQL Server Manually'." Behind this modal dialog box, in the install window, it seems to have stopped at "Running action to shutdown instance(Run As Normal User) RANU instance shutdown in progress: MSSQL$SQLEXPRESS"I have tried everything I can find online about this, including use of the Windows Install Clean Up, Aaron Stebner's blog about how to remove a beta version (http://blogs.msdn.com/astebner/archive/2005/12/08/501885.aspx), Ttools, and the Visual Studio Uninstall program. I have manually deleted the folder for SQL Server from my Program Files folder, I have deleted all mention of the program from my registry, and yet I still cannot get the darned thing to reinstall.
My computer is a Pentium Duo-Core 2 6600, running at 2.4 GHz, with 2GB RAM, 129GB of 279GB hard drive space free
, with an NVIDIA GeForce 7600 GS video card. As I say, I had the program running, it just won't reinstall. I am logged on as the one and only user, and I have Administrator priveleges. There have been no changes to the PC aside from removing and trying to reinstall the C++ and SQL Server programs. Can anyone give guidance as to what the heck is going on and what to do?? The haed and tail of my error log is below. I am stuck. Thank you.
Regards,
Andy
=== Verbose logging started: 11/1/2007 11:16:13 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (1C:1C) [11:16:13:234]: Resetting cached policy values
MSI (c) (1C:1C) [11:16:13:234]: Machine policy value 'Debug' is 0
MSI (c) (1C:1C) [11:16:13:234]: ******* RunEngine:
******* Product: c:e02e41a11dc741be12SetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (c) (1C:1C) [11:16:13:234]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (1C:1C) [11:16:13:234]: Grabbed execution mutex.
MSI (c) (1C:1C) [11:16:13:250]: Cloaking enabled.
MSI (c) (1C:1C) [11:16:13:250]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (1C:1C) [11:16:13:250]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (DC:EC) [11:16:13:250]: Grabbed execution mutex.
MSI (s) (DC:F0) [11:16:13:250]: Resetting cached policy values
MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'Debug' is 0
MSI (s) (DC:F0) [11:16:13:250]: ******* RunEngine:
******* Product: c:e02e41a11dc741be12SetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'TransformsSecure' is 0
MSI (s) (DC:F0) [11:16:13:250]: User policy value 'TransformsAtSource' is 0
MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (DC:F0) [11:16:13:250]: File will have security applied from OpCode.
MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'c:e02e41a11dc741be12SetupSqlRun_SQL.msi' against software restriction policy
MSI (s) (DC:F0) [11:16:15:781]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: c:e02e41a11dc741be12SetupSqlRun_SQL.msi is not digitally signed
MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: c:e02e41a11dc741be12SetupSqlRun_SQL.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (DC:F0) [11:16:15:781]: End dialog not enabled
MSI (s) (DC:F0) [11:16:15:781]: Original package ==> c:e02e41a11dc741be12SetupSqlRun_SQL.msi
MSI (s) (DC:F0) [11:16:15:781]: Package we're running from ==> c:WINDOWSInstaller46c82d.msi
MSI (s) (DC:F0) [11:16:15:828]: APPCOMPAT: looking for appcompat database entry with ProductCode '{2B2EF9D0-3876-4021-8F44-FA294E6D3C36}'.
MSI (s) (DC:F0) [11:16:15:828]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (DC:F0) [11:16:15:828]: Detected that this product uses a multiple instance transform.
MSI (s) (DC:F0) [11:16:15:828]: MSCOREE already loaded, using loaded copy
MSI (s) (DC:F0) [11:16:15:828]: Applying multiple instance transform 'qlRun01.mst'...
MSI (s) (DC:F0) [11:16:15:828]: Looking for storage transform: SqlRun01.mst
MSI (s) (DC:F0) [11:16:15:828]: Validating transform 'SqlRun01.mst' with validation bits 0x809
MSI (s) (DC:F0) [11:16:15:828]: Transform 'SqlRun01.mst' is valid.
.
.
.
Property(S): SqlVerComBinRes1033.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = c:Program FilesMicrosoft SQL Server90COMResources1033
Property(S): SqlInstance.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
Property(S): SqlTarget.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL Server
Property(S): SqlInstanceBin.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn
Property(S): Data.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL Server
Property(S): DataInstance.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
Property(S): FTDataDir.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): DataInstanceTxt.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
Property(S): DataInstanceFTData.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): ModuleID_FTSSV = 68C6D15C_77E0_11D5_8528_00C04F68155C
Property(S): SqlFullTextDefaultPath = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): FTERefPath.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): QuotedServiceGroupFTS.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = ANDYSSQLServer2005MSFTEUser$ANDYS$SQLEXPRESS
Property(S): FTEInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLEXPRESS
Property(S): FTERudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1
Property(S): FTERegRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSearch
Property(S): FTEInstanceSubDir.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1MSSQL
Property(S): FTEStartupType = 0
Property(S): FTEStatus = 3
Property(S): InstanceRegKey.7827AB3E_7041_406A_9591_4DB66042927F = Microsoft SQL ServerMSSQL.1
Property(S): InstanceName.7827AB3E_7041_406A_9591_4DB66042927F = SQLEXPRESS
Property(S): SqlVerComFT.BB43EC2E_1D73_400F_AE2F_F370407BC222 = c:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.BB43EC2E_1D73_400F_AE2F_F370407BC222 = c:Program FilesMicrosoft SQL Server90
Property(S): FTESqlInstanceBin.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn
Property(S): FTESqlInstance.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
Property(S): FTESqlInstanceBinRef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef
Property(S): FTESqlInstanceDotNumber.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1
Property(S): SqlVer.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server90
Property(S): FTESharedCompRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server90
Property(S): Sql.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server
Property(S): SqlTarget.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server
Property(S): ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program Files
Property(S): CAFTERemovePerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQLEXPRESS
Property(S): CAFTEUninstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): CAFTEUpgradeFTERefFiles.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQLEXPRESS:c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef
Property(S): CAFTEUpgradeFTERefFilesRollBack.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef
Property(S): CAFTEInstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn
Property(S): CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLEXPRESS
Property(S): CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQLEXPRESS
Property(S): CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYNetworkService
Property(S): FTERegInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLEXPRESS
Property(S): FTERegRudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1
Property(S): FTEUPGRADE.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): FTEUpgrade30.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): FTEUpgradeMSSearchApp.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQLEXPRESS
Property(S): FTEUpgradeMSSearchStandalone.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): CostingComplete = 1
Property(S): FTEInstID.68C6D15C_77E0_11D5_8528_00C04F68155C = 1
Property(S): FTEAppID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}
Property(S): FTEAdminCLSID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D37C-77E0-11D5-8528-00C04F68155C}
Property(S): FTEIFTEAdmin.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bd6f-cc0d-11d6-9a15-505054503030}
Property(S): FTEMSFTEPXY.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bdd4-cc0d-11d6-9a15-505054503030}
Property(S): FTEDollarInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQLEXPRESS
Property(S): FTEServiceName.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQLEXPRESS
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer$SQLEXPRESS
Property(S): SqlActionManaged = 3
Property(S): SqlNamedInstance = 1
Property(S): SqlStateManaged = 2
Property(S): RSVirtualDirectoryManager = Reports$SQLEXPRESS
Property(S): SOURCEDIR = c:e02e41a11dc741be12Setup
Property(S): SourcedirProduct = {B0F9497C-52B4-4686-8E73-74D866BBDF59}
Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITYNetworkService
Property(S): SQLSCMACCOUNT = NT AUTHORITYNetworkService
Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {04F4B2AC-58A6-4ADD-98ED-84973C96062A}
Property(S): ProductToBeRegistered = 1
MSI (s) (DC:F0) [11:19:42:109]: Note: 1: 1708
MSI (s) (DC:F0) [11:19:42:109]: Product: Microsoft SQL Server 2005 -- Installation failed.
MSI (s) (DC:F0) [11:19:42:125]: Cleaning up uninstalled install packages, if any exist
MSI (s) (DC:F0) [11:19:42:125]: MainEngineThread is returning 1603
MSI (s) (DC:EC) [11:19:42:125]: Destroying RemoteAPI object.
MSI (s) (DC:38) [11:19:42:140]: Custom Action Manager thread ending.
=== Logging stopped: 11/1/2007 11:19:42 ===
MSI (c) (1C:1C) [11:19:42:140]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (1C:1C) [11:19:42:140]: MainEngineThread is returning 1603
=== Verbose logging stopped: 11/1/2007 11:19:42 ===
Previously, I have installed SQL 2005 developer edition simplyfied chinese
successfully. But yesterday, I tried to install mobile client software
factory. The installation process create a database as following:
Create DATABASE [AdventureWorksMobileStaging] ON PRIMARY
( NAME = N'AdventureWorksMobileStaging', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging.mdf' , SIZE = 195584KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
( NAME = N'AdventureWorksMobileStaging_log', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging_log.ldf' , SIZE = 265344KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
But today, when I start my notebook, SQL server could not be started.
Then I uninstalled the SQL instance by start->control panel->uninstall...The uninstall
process seems OK. Note that I only uninstalled the instance.Then I tried to reinstall
SQL 2005. However it was reported a Performance Monitor Counter registry key mismatch
error occures. I tried to fix it but failed. The problem is as following:
1, The installation process report a warning of low memory.
My notebook has 512M memory. I have reinstalled SQL 2005 once successfully. At that
time, the warning also shows, but it seems that this warning does not affect installation.
2, User type problem.
The OS of my notebook is XP professional, which is upgraded from XP home edition.
I login it using a domain user such as: "my company's domainmyaccount". I found it
curiously that although I assign myaccount as an Administrator, it will automaticly
changed to "SQL$...." account. I don't know why and when the account property is
changed. But everytime, when I found, I will assign myaccount as an Administrator
back.
3, Performance Monitor Counter registry key problem.
To fix the problem, I firstly tried to run lodctr.exe in cmd window but failed.
When I cd to c:windowssystem32 dir, I can ran lodctr.exe correctly.
I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib,
the result is:
"Last Counter"=dword:0000149c (11128)
"Last Help"=dword:0000149d (11129)
Then I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib 09
and 004, the result is confusing. I can find counter and help key,but both keys contains
really a lot of stuff as:
(1) first page of Counter key:
1
1847
2
System
4
Memory
6
% Processor Time
10
File Read Operations/sec
12
(2) first page of Help key:
3
The System performance object consists of counters that apply to more than one instance of a component processors on the computer.
5
The Memory performance object consists of counters that describe the behavior of physical and virtual memory on the computer. Physical memory is the amount of random access memory on the computer. Virtual memory consists of the space in physical memory and on disk. Many of the memory counters monitor paging, which is the movement of pages of code and data between disk and physical memory. Excessive paging, a symptom of a memory shortage, can cause delays which interfere with all system processes.
7
% Processor Time is the percentage of elapsed time that the processor spends to execute a non-Idle thread. It is calculated by measuring the duration of the idle thread is active in the sample interval, and subtracting that time from interval duration. (Each processor has an idle thread that consumes cycles when no other threads are ready to run). This counter is the primary indicator of processor activity, and displays the average percentage of busy time observed during the sample interval. It is calculated by monitoring the time that the service is inactive, and subtracting that value from 100%.
9
% Total DPC Time is the average percentage of time that all processors spend receiving and servicing deferred procedure calls (DPCs). (DPCs are interrupts that run at a lower priority than the standard interrupts). It is the sum of Processor: % DPC Time for all processors on the computer, divided by the number of processors. System: % Total DPC Time is a component of System: % Total Privileged Time because DPCs are executed in privileged mode. DPCs are counted separately and are not a component of the interrupt count. This counter displays the average busy time as a percentage of the sample time.
11
File Read Operations/sec is the combined rate of file system read requests to all devices on the computer, including requests to read from the file system cache. It is measured in numbers of reads. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval.
I could not find the maximum value of the Counter key and help key, so I could not repair
Last Counter and Last Help key as discribed at SQL 2005 help. Which item correspond to
maximum value of the Counter key and help key?
I tried to correct Last Counter and Help key as:
"Last Counter"=dword:0000149c (5276)
"Last Help"=dword:0000149d (5277)
But it also doesn't work.
Long story short: Installed SQL Server 2005 Developers Edition along with Visual Studio 2005. Everything worked as it should.
Then there was a problem installing .NET Framework 2.0 Security Update. Fixed that by uninstall and reinstall of .NET Framework 2.0.
Now SQL Server does not work. So I figured uninstall/reinstall. Only problem is that it WILL NOT uninstall. I have tried to uninstall manually per KB article (9009967). That doesn't work either.
The error info that I'm geting is:
LinkID: 20476
Product Name: Microsoft SQL Server
Product Version: 9.00.2047.00
Message source: setup.rll
Message ID: 50000
EvtType: stateengine
esourcemodule.cpp@ScheduleActionAction@sqls::ResourceModule::LoadStringW@0x716
I get the same data during setup or uninstall. Neither of which completes.
Needless to say this is driving me nuts. I'm trying to learn VB.NET programming and many of the examples use SQL Server.
Any help would be appreciated.
Hi I installed SQL server 2005 Express and it was successfully set up but I kept on getting error 26 when I try to connect to a database, so I remove all SQL programs from the control panel and reinstall SQL server 2005, but this time the set up stopped halfway saying "cannot start server". How can I successfully reinstall SQL server 2005 express?
View 11 Replies View RelatedI uninstalled a previous version of SQL Server 2000 Developer because it had some custom configurations that I didn't want. When I try to re-install, I get an error message saying:
A previous program installation created pending file operations on the installation machine. You must reboot the computer before running setup.
I don't know what other programs affect SQL that I have on my machine. My previous instance only contained two known databases and I have deleted the applications that went with those databases.
I have deleted all known registry settings for SQL Server. I have also stopped the IIS service because I thought it would impact the install.
I rebooted my machine, but I still get the same error when I try to install. I don't know what to do next? Please help!
While attempting to configure DTC on a Windows xp Pro, SP 2 machine I receive the error message [DTC was installed by the SQL Server. Please reinstall!] Where do I find this installation file to complete the requested task -- any help would be awesome -- I have tried down loading hotfixes, and security updates that mention fixing problems with DTC -- but alas they did not fix my error ;-)
I've got a Windows Server 2003 for Small Business Server. It had got SQL installed. But then SQL was uninstalled. Now I need to put SQL back in, but I don't see how!
There're three CD-Rom but I don't see how and from which CD to install back SQL.
PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005, right?
I had to uninstall SQl Server 2005 Developer Edition because of hardware requirements, and reinstall Express Edition download version.
But SQL Server Database Services fails with this message:
SQL Server Setup has determined that the following account properties are not specified: 'AGTACCOUNT' . Error Code: 28006.
The first time I installed Express the flow of setup ended well without any message. How to act?
I can€™t use the DTS editor because shows an error.
So, I want to reinstall the enterprise manager without uninstall the sql server 2000, Is that possible?
If the answer is yes, How can I do that?
I think that reinstalling only the Enterprise Manager the DTS editor can be fixed.
Sql Version: Sql Server 2000
SO: Windows 2003 Server
Tanks in advance
Ariel.
Something happened when the server fall down because of no disk space.
Now everything is fine but I have a problem in de DTS (from the Enterprise Manager) editor, I can€™t run, modify and even make a new DTS.
What can I do? Is it possible reinstall de DTS components without reinstall sqlserver 2000?
Sql Version: sqlserver2000 Enterprise
SO Version: Windows 2003 Server
Thanks in advance
Ariel.
I had installed SQL Server 2005 for the first time in order to study for the SQL SERVER 2005 Implementation and Maintenance exam. Everything was going ok until I got to the section on Partitions. When I attempted to follow the lessons on partitions, I received an error indicating that the Enterprise Edition was needed for Partitions.
I uninstalled SQL Server and re-installed the Enterprise Edition (MSDN disk). When I re-installed, I was not promopted for a new/default instance name). The old instance that had used for the original installation is presented when I attempt to "Connect to Server." When I select that instance and click Connect, I receive the "Cannot connect to <server name>" error message.
How do I re-establish that instance name or create another default instance?
Regards - Tony
I need to recover an entire named instance because of data corruption on the SAN. The DBs are OK but the SQL Server Service will not start due to a 'windows internal error' so I'm going to restinall the instance. I have all of my data and log files from all databses including the master.. can I use these to recover or is a restore of system databases better??
Also, I have a database with 5 .ndf files. I can't quite get the syntax right to attach these files after I do a restore to get the LATEST data? Can anyone help?
Hi all,
We recently converted an application from accecc97 to access2003.
We used to have 2 databases : 1 with all and only the data (axelD.mbd), 1 with all the forms, query's, ... (axelP.mdb)
We replaced the data (axelD.mdb) with an MSDE database, through UPSIZE and so on. That all worked fine.
This database is placed on the dataserver (DATA1), the converted programm is on the FRONT2 server (FRONT1 stil usess access97 until conversion is totally ready).
We are able to connect to the MSDE by using ADODB recordsets.
We are also perfect able to link the MSDEtables in our axelP.mbd database
We started to test some heavier parts of our application and started to get the following error:
"ERROR 3151"
"ODBC--connection to 'JOROSOFT' failed"
Nothing more.
This happened in a quite complex routine, whitch updates a lot of records, several times and so on.
We could reproduce the same error when executing the following code:
Public Function TestBestellingen()
Dim sql As String
Dim intervalset As DAO.Recordset
Dim planset As DAO.Recordset
Dim tellerke
x = Opendatabases()
tellerke = 0
sql = "Select bestelnummer from vkpbestellijn where bestelnummer > 100000"
Set planset = Db_AxelP.OpenRecordset(sql, dbOpenDynaset)
Do While Not planset.EOF
tellerke = tellerke + 1
Debug.Print tellerke & " - " & planset!Bestelnummer & " --> " & IsKlantStof(planset!Bestelnummer)
planset.MoveNext
Loop
End Function
Function IsKlantStof(p_bestelnummer)
Dim sql As String, rst As DAO.Recordset
Dim hulp_klantstof As Boolean
hulp_klantstof = False
x = Opendatabases()
sql = "select klantstof from vkpbestellijn where bestelnummer = " & p_bestelnummer
Set rst = Db_AxelP.OpenRecordset(sql, dbOpenSnapshot)
With rst
Do While Not .EOF
If !KlantStof = True Then
hulp_klantstof = True
.MoveLast
End If
.MoveNext
Loop
End With
rst.Close
Set rst = Nothing
IsKlantStof = hulp_klantstof
End Function
Function Opendatabases()
If Db_AxelP Is Nothing Then
Set Db_AxelP = DBEngine(0)(0)
End If
End Function
I know this code makes no sence in a real-time environment, but it was to reproduce the error.
This code basically runs trough a 30.000 records and does a little check for certain fields
After 1981 records we get the above error.
(sometimes after 1979 or 1980 or 1982 records)
1977 - 100859 --> True
1978 - 100860 --> True
1979 - 100860 --> False
1980 - 100861 --> True
1981 - 100861 --> True
"vkpbestellijn" is a table that is linked in the AxelP.mdb trough an ODBC connection.
We get the same error (and after 1981 times) if I change the where to a totally other range of "bestelnummer"
I have installed the latest patches of Jet 4.0, MSDE-server, ...
I've been searching the internet for abour 3 days now, and just cant even find the smallest clue what could make this happen.
I hope someone here has an idea.
If you need more details, just ask.
tia,
Axel.
P.S. I'm from Belgium, so my english aint "correct to the point".
We are running an ASP application. That is fairly simple.It selects from one table (15.000 records), and updates into another table.But when we execute the ASP script, it reports the following error, aftercompleting between 70%-80%. This varies each time it runs"Microsoft OLE DB Provider for SQL Server error '80004005'[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or accessdenied. "The application is running in ths following server environmentServer 1Fujitsu-Siemens RX300 Server (Dual 2,8 Xeon, 1 Gb Ram, 72 Gb SCSI Raid 1)Windows 2003 Web Server (IIS)Server 2Fujitsu-Siemens RX300 Server (Dual 2,8 Xeon, 1 Gb Ram, 72 Gb SCSI Raid 1)Windows 2003 Standart serverMicrosoft SQL Server 2000
View 5 Replies View Related
Hi all,
Configuration : MSSQL2005 SP2 on Windows 2003 server
I have a strange issue when scheduling SSIS Job.
When I schedule it, I set the owner as the domain administrator. The scheduled job can be run manually without any problem. The scheduled job run automatically at scheduled time wihtout problem.
But , for an unknow reason, after some cycle, the job failed with the following error :
The job failed. The owner () of <name of the job> does not have server access
As you can see, the owner name is blank.
If I look to the job settings : the owner is still the domain administrator.
If I try to run it manually, the job fails with the same error.
now if I just rename the job name from <name of the job> to <name of the job2> then all problems are solved.
If we let the job failing everyday, sometimes, it starts again to work properly.
We have this issue on 2 jobs.
If anyone has faced this issue : thank you for advise.
Hi,
Excuse me for the 'noobish' question but it seems in my mining models, i am 'loosing' input variables. I am using the Microsoft Decision Tree algorithm and eventhough i have set 4 variables as 'input' and all 4 of them are in my mining structure, the model is using only 3. That 4th variable is also missing from the dependency network graph. Can anyone help me solve this problem?