I am using Windows 2003 Standard Server (stand alone) and trying to install SQL Server 2000 Enterprise edition. The installation stops whenever I have entered the sa password (the dialog box disappeared and then nothing happed, but the "setupsql" process (something like this) is still there).
The same happened when I install SQL Server 2000 in Windows 2000 Server. For Win2K, I can first install SQL Server 7.0 and then upgrade to 2000 (same SQL Server 2000 installation CD!). However, Windows 2003 doesn't support SQL Server 7.0. So I can't use this method...
Hello,I received the error message below when i'm trying to install SQLServer 2000 standard edition into a Windows 2000 Professionaleworkstation.Error :Microsoft SQL server 2000 Standard Edition server components is notsupported on this operating system. Only client components will beavailable for installation.Any request modification ?Best regards,Thanks
I am trying to install microsoft sql server 2000 enterprise edition on a windows 2000 advance server. I keep getting error message
A previous program installation created pending file operations on the installation machine. You must restart the computer before running . I have restarted machine and no change.
What does error message mean and what is solution?
I just installed SQL Server 2000 Developers edition on my computer. After installation I tried to create a simple table which I was unable to do. When I attempted to create the table, I went into SQL Server Enterprise Manager and under Console Root I extended / Microsoft SQL Servers / SQL Server Group / (local) Windows NT when it gave me the following 2 message box errors :
----------------------------------------------------------------------------------- An error 1069-(The service did not start due to login failure)occured while preforming this server operation on the MSSQL service.
---and---
A connection could not be established to (local).
Reason: SQL Server does not exist or access denied. ConnectionOpen(Connect()).
Please verify SQL Server is running and check your SQL Servier registion properties(by right- clicking on the (local) node) and try again.
I have Windows XP Professional and currently run IIS. I have tried re-registering without success and at this point I don't know what I need to do in order to correct these errors and create a simple table.
Hi, I'm learning ASP.net and I just bought Visual Studio .net professional. I tried to install MS SQL server 2000 on my two computers. One OS is windows server 2003 standard edition and another is Win XP professional. Both of them appeared SQL Server Upgrade Wizard "from server 6.5 upgrade to server 2000". I don't think I have server 6.5 installed and there is no server 6.5 application interface to run the server. What's the problem? I cannot run the Wizard successfully. Can I just ignore it?Thank you,William
I installed sql server 2000 sp2 standard edition on Windows 2003, when installing, it said "This version is not supported on this os", but I was told to continue installing the software and that I could install the latest security patches to bring it up to date. Will that work? Do I need to do anything else? SQL Server 2000 is up and running on the box. When running the statement " select @@version" it informed me that I was at 8.00.194 patch level. How can I tell if SQL Server 2000 is 32 or 64 bit? I was trying to download the lasted patch and it asked for that info. Thanks.-- New to SQL Server
I just wanted to get the advice.I have a sql server2000 installed on Windows 2000 advanced server machine in my company using windows authentication.I wanted to install another instance of this sql server on remote sites located in other country where the domain name and everything changes.I wanted to use the same existing schema there in new site.Can i import this database there and create new users of new domain using this .
I HAVE INSTALLED WINDOWS SERVER 2003 R2 + SP2 STANDARD 64 BIT. CAN I INSTALL SQL SERVER 2000 32 BIT STANDARD +SP4 ON IT.PLEASE HELP ME REGARDS SELVARAJ
I was wondering if anyone might be able to help me here. To be honest, this is my first time i have encountered SQL Server 2000 SP4. I need some guidance as to how to install and set up the SQL Server 2000 SP4. I have done it with SQL Server 2005 Express Edition and it's (I think) a lot easier to install and get it going.
My computer runs on windows XP Pro (windows 32bit). I got confused when i got to the following microsoft webpage - http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en. I downloaded SQL2000-KB884525-SP4-x86-ENU.EXE. And when running the setup.bat, the message came up saying "SQL Server 2000 is not installed on this machine. setup will now exit". What do i need to have the SQL Server 2000 installed on my machine?
I have installed IIS, VS.NET 2003, .NET 2.0 Framework, and now I have tried to install the standard version of SQL Server 2000 and it is telling me that I can only install the client components. The O/S is Windows XP Pro on a laptop.
I get the following error while trying to install sql server 2000 eval edition on Win XP
> "An error occurred while creating one or more registry entries. Please > see C:Windowssqlstp.log for details. The problem could be caused by a > low registry quota condition."
Im attempting to install SQL Server 2000 Standard on Windows XP Pro and it keeps returning to me an error:
"Microsoft SQL Server 2000 Standard Edition server component is not supported on this operating system. Only client components will be available for installation."
Anybody have any idea what this means according to the documentation and previous posts on installation problems my operating system should support this edition of SQL server.
I am trying to install SQL Server 2000 on a new Windows 2003 server. I stopped the IIS and tried installing from two different CDs. In both cases I got the following error right at the start of the installation -
I installed MS Sql server 2000 having Typical type setup. I choosed Local system account in service setting & mixed mode authentication mode. I choose default Tcp/Ip port 1433 which is free. After successful installtion i tried telnet localhost 1433 But gaves the error : "Could not open connection to host on port 1433" Connection failed. So should i do for remote or telnet connection. Please help me!
i have win xp and i trying to install ms sql server 2000 Enterprise Editionon it but after i try to do this i get a following message "Microsoft SQLServer 2000 Enterprise Edition server component is not supported on thisoperating system. Only clients components will be available forinstallation".regardsspark
I am installing SQL Server 2000 on the standalone computer having Windows XP Professional with Service Pack 2.
At the time of installation when I select install database server the setup windows not coming, at the background sqlstp.exe & other setup programs are running.
Please suggest me the solution for this error. The pc has Visual Studio 2003 installed on it & IIS is also installed.
Hello, I have sql server 2000 personal edition on my PC and I have just got a 2005 DVD. I tried to install it but it is not working. I don't know how to manage my databases. As if there is no graphical managemnt tool. The 2005 is also Personal edition. I reinstalled the sql 2000, and now I'm trying t upgrade to sql 2005, but still don't know how to do that. Please someone help me!!!!!!!!!!
I have SQL Server 2000 installed on my laptop and am trying to install an instance of MSDE. I keep getting the error message: "The installation of SQL Server 2000 Desktop Engine has failed. Please see the Getting Started manual for further instructions."
I have done this installation before on other machines. Something must be corrupt on my machine (?). The error message is not very enlightening. Any ideas?
Hi Guys, I have had SQL Server Express and Sql Server Management Studio Express installed on my machine for some time and recently tried to install a trial of SQL Server 2005 as well. (Yes, I'm migrating from Visual Studio Express to Visual Studio Professional, just as in tended!) Everything went fine except that nothing seemed to be installed. I searched in all the obvious places - both on the Start/Programs menu and on the hard-drive: nothing. A check under Add/Remove Programs showed that Sql Server 2005 Express was installed, but called SQL Server 2005. So after a number of retries in which the install program kept saying that there was nothing to install, I selected every option under Advanced in the intall process. This resulted in stuff being installed and I now have SQL Server 2005 running on my machine, but no SQL Server Manager icon. My questions are:
Where can I find the SQL Server Manager executeable? Has anyone installed SQL Server Express, SQL Server Mangement Studio Express, SQL Server 2005 and SQL Server Management Studio on a single machine successfully? If so, what order did you install them in? (I'm planning on uninstalling everything SXQL Server related and starting again.) Thanks very much for your help. Regards Gary
Hi, i tried to install MS SQL server 2000 in my XP system but during the setup service account installation, i tried to use a domain user account but it cannot validate my user name and password. I used my windows administrator logon account and password. Please help..thank you.
I have an installation of SQL Server 2000. Both MBSA and @@versionshow this to be the gold release. When I install Service Pack 3a, itshows no error. But after restart of the server, it's still unpatched,by both MBSA and @@version.Any idea what may be going on here?
I have been asked to provide a SQL Server 2000 Service Pack 4 validation procedure... I have been unable to locate any reference to how this can be validated in either the program itself or in the registry... Any help is appreciated...
My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help
I am new to this sql server thing.And for last couple of days i m trying to figure out whether we can install sql server 2000 ent edition in a server after installing or upgrading sql server 2005 from (sql server 2000) . As sql server 2005 is know to exist side by side with earlier sql server versions .
And coming to the problem which i m facing is , I have installed sql server 2005 ent in windows 2000 server in which sql server 2000 is residing.Later when i observerd i realised that actually i have upgraded 2000 to sql 2005 server (which i hav done after consulting many people).As a result few of the client systems which were running sql server personal edition were unable to access their data from the database.For temporary relief i have installed sql server 2005 express edition plus management studio in the client systems . The doubts which i am having are
1) what happens if i uninstall sql server 2005 2) Is it possible to install sql server 2000 ent edition now to work along with sql server 2005
thanks in advance .....waiting for your quick replies ..any idea's
I had 5 servers hang all on the same day, all within about 5 mins of each other scattered across 4 corners of the UK. Our support team tell me that it has something to do with SQL Server, but cannot say what. I can see looking at the error log of one of the servers, that there are about4 entries everyday since startup, and this continues right up until the night before the freeze.
At 22:00 the night before the freeze, a load of entries are written (Iv'e cut down the list to make it easier to read). then at around 4am the servers all froze. Could someone take a sneaky peak at these logs and tell me in your own opinion what caused this to happen.
The first section, is what I believe to be normal
2006-11-28 20:52:53.68 server Copyright (C) 1988-2002 Microsoft Corporation. 2006-11-28 20:52:53.68 server All rights reserved. 2006-11-28 20:52:53.68 server Server Process ID is 952. 2006-11-28 20:52:53.68 server Logging SQL Server messages in file 'D:Program FilesMicrosoft SQL ServerMSSQLlogERRORLOG'. 2006-11-28 20:52:53.73 server SQL Server is starting at priority class 'normal'(1 CPU detected). 2006-11-28 20:52:54.75 server Working Set size set to 409600 kilobytes. 2006-11-28 20:52:54.90 server SQL Server configured for thread mode processing. 2006-11-28 20:52:54.90 server Processor affinity turned ON, processor mask 0x1 2006-11-28 20:52:54.92 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks. 2006-11-28 20:52:55.20 server Attempting to initialize Distributed Transaction Coordinator. 2006-11-28 20:52:57.20 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b 2006-11-28 20:52:57.53 spid3 Starting up database 'master'. 2006-11-28 20:52:59.31 spid3 Server name is 'SN047483'. 2006-11-28 20:52:59.31 server Using 'SSNETLIB.DLL' version '8.0.760'. 2006-11-28 20:52:59.31 spid5 Starting up database 'model'. 2006-11-28 20:52:59.50 spid8 Starting up database 'msdb'. 2006-11-28 20:52:59.50 spid9 Starting up database 'pubs'. 2006-11-28 20:52:59.53 spid10 Starting up database 'udb'. 2006-11-28 20:52:59.64 spid11 Starting up database 'vgold'. 2006-11-28 20:53:00.07 server SQL server listening on 155.202.58.53: 1433. 2006-11-28 20:53:00.07 server SQL server listening on 127.0.0.1: 1433. 2006-11-28 20:53:00.29 spid5 Clearing tempdb database. 2006-11-28 20:53:00.64 server SQL server listening on TCP, Shared Memory, Named Pipes. 2006-11-28 20:53:00.64 server SQL Server is ready for client connections 2006-11-28 20:53:00.71 spid9 Starting up database 'dbs'. 2006-11-28 20:53:01.01 spid8 Recovery is checkpointing database 'msdb' (4) 2006-11-28 20:53:01.50 spid5 Starting up database 'tempdb'. 2006-11-28 20:53:53.78 spid3 Recovery complete. 2006-11-28 20:53:53.78 spid3 SQL global counter collection task is created. 2006-11-28 20:53:54.32 spid59 Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'. 2006-11-29 00:00:01.10 spid69 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'xp_instance_regread'. 2006-11-29 02:00:01.54 spid69 Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_cmdshell'. 2006-11-29 02:00:09.31 backup Database backed up: Database: master, creation date(time): 2006/11/28(20:52:57), pages dumped: 1907, first LSN: 159:245:1, last LSN: 159:247:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}). 2006-11-29 02:00:11.46 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1667, first LSN: 397:332:1, last LSN: 397:335:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}). 2006-11-29 02:01:58.10 backup Database backed up: Database: dbs, creation date(time): 2004/10/05(08:00:04), pages dumped: 94467, first LSN: 114:53199:1, last LSN: 114:53203:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}). 2006-11-29 02:01:58.20 backup Database log truncated: Database: dbs. 2006-11-29 10:51:33.43 spid62 Using 'odsole70.dll' version '2000.80.760' to execute extended stored procedure 'sp_OACreate'. 2006-11-30 02:00:04.34 backup Database backed up: Database: master, creation date(time): 2006/11/28(20:52:57), pages dumped: 1907, first LSN: 159:260:1, last LSN: 159:262:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}). 2006-11-30 02:00:06.57 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1667, first LSN: 398:26:1, last LSN: 398:29:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}). 2006-11-30 02:01:53.84 backup Database backed up: Database: dbs, creation date(time): 2004/10/05(08:00:04), pages dumped: 94467, first LSN: 114:54895:1, last LSN: 114:54899:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}). 2006-11-30 02:01:53.93 backup Database log truncated: Database: dbs. 2006-11-30 13:10:09.96 spid67 Error: 60002, Severity: 15, State: 1 2006-11-30 13:10:09.96 spid67 PBX login_id 5592 already exists in user id 379. Proc Name: um_user_insert. 2006-12-01 02:00:04.51 backup Database backed up: Database: master, creation date(time): 2006/11/28(20:52:57), pages dumped: 1907, first LSN: 159:275:1, last LSN: 159:277:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}). 2006-12-01 02:00:06.76 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1667, first LSN: 398:408:1, last LSN: 398:411:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}). 2006-12-01 02:01:52.31 backup Database backed up: Database: dbs, creation date(time): 2004/10/05(08:00:04), pages dumped: 94515, first LSN: 114:55915:1, last LSN: 114:55923:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}). 2006-12-01 02:01:52.39 backup Database log truncated: Database: dbs.
This second section then has around a good few hundred entries.
2006-12-01 22:00:01.98 spid67 Error: 60132, Severity: 15, State: 1 2006-12-01 22:00:01.98 spid67 Folder 7 is not assigned to user 11 Proc Name: ags_workflow_sess_count. 2006-12-01 22:00:02.04 spid67 Error: 60132, Severity: 15, State: 1 2006-12-01 22:00:02.04 spid67 Folder 7 is not assigned to user 11 Proc Name: ags_workflow_sess_count. 2006-12-01 22:18:02.57 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 22:18:02.57 spid66 Folder 7 is not assigned to user 63 Proc Name: ags_workflow_sess_count. 2006-12-01 22:43:37.42 spid67 Error: 60132, Severity: 15, State: 1 2006-12-01 22:43:37.42 spid67 Folder 7 is not assigned to user 493 Proc Name: ags_workflow_sess_count. 2006-12-01 22:43:37.43 spid67 Error: 60132, Severity: 15, State: 1 2006-12-01 22:43:37.43 spid67 Folder 7 is not assigned to user 493 Proc Name: ags_workflow_sess_count. 2006-12-01 22:44:37.51 spid58 Error: 60132, Severity: 15, State: 1 2006-12-01 22:44:37.51 spid58 Folder 7 is not assigned to user 613 Proc Name: ags_workflow_sess_count. 2006-12-01 22:46:07.00 spid67 Error: 60132, Severity: 15, State: 1 2006-12-01 22:46:07.00 spid67 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count. 2006-12-01 23:00:20.65 spid58 Error: 60132, Severity: 15, State: 1 2006-12-01 23:00:20.65 spid58 Folder 7 is not assigned to user 949 Proc Name: ags_workflow_sess_count. 2006-12-01 23:00:20.67 spid58 Error: 60132, Severity: 15, State: 1 2006-12-01 23:00:20.67 spid58 Folder 7 is not assigned to user 973 Proc Name: ags_workflow_sess_count. 2006-12-01 23:02:33.07 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 23:02:33.07 spid66 Folder 7 is not assigned to user 1010 Proc Name: ags_workflow_sess_count. 2006-12-01 23:04:38.10 spid58 Error: 60132, Severity: 15, State: 1 2006-12-01 23:04:38.10 spid58 Folder 7 is not assigned to user 1247 Proc Name: ags_workflow_sess_count. 2006-12-01 23:04:38.12 spid58 Error: 60132, Severity: 15, State: 1 2006-12-01 23:04:38.12 spid58 Folder 7 is not assigned to user 1266 Proc Name: ags_workflow_sess_count. 2006-12-01 23:06:08.59 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 23:06:08.59 spid66 Folder 7 is not assigned to user 1659 Proc Name: ags_workflow_sess_count. 2006-12-01 23:06:08.59 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 23:06:08.59 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count. 2006-12-01 23:06:08.59 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 23:06:08.59 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count. 2006-12-01 23:06:08.60 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 23:06:08.60 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count. 2006-12-01 23:06:08.60 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 23:06:08.60 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count. 2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count. 2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count. 2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count. 2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count. 2006-12-01 23:06:08.64 spid66 Error: 60132, Severity: 15, State: 1 2006-12-01 23:06:08.64 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count. 2006-12-01 23:06:08.64 spid66 Error: 60132, Severity: 15, State: 1
This section shows from 4am onwards
2007-01-13 04:05:09.87 spid71 Error: 60132, Severity: 15, State: 1 2007-01-13 04:05:09.87 spid71 Folder 7 is not assigned to user 613 Proc Name: ags_workflow_sess_count. 2007-01-13 04:05:13.40 spid75 Error: 60132, Severity: 15, State: 1 2007-01-13 04:05:13.40 spid75 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count. 2007-01-13 04:05:16.15 spid77 Error: 60132, Severity: 15, State: 1 2007-01-13 04:05:16.15 spid77 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count. 2007-01-13 04:05:17.29 spid61 Error: 60132, Severity: 15, State: 1 2007-01-13 04:05:17.29 spid61 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count. 2007-01-13 04:05:18.12 spid69 Error: 60132, Severity: 15, State: 1 2007-01-13 04:05:18.12 spid69 Folder 7 is not assigned to user 63 Proc Name: ags_workflow_sess_count. 2007-01-13 04:10:28.81 spid51 Unable to load OLE/DB initialization service. 2007-01-13 04:58:12.21 server Error: 17883, Severity: 1, State: 0 2007-01-13 04:58:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68. 2007-01-13 04:59:12.21 server Error: 17883, Severity: 1, State: 0 2007-01-13 04:59:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68. 2007-01-13 05:00:12.21 server Error: 17883, Severity: 1, State: 0 2007-01-13 05:00:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68. 2007-01-13 05:01:12.21 server Error: 17883, Severity: 1, State: 0 2007-01-13 05:01:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68. 2007-01-13 05:02:12.21 server Error: 17883, Severity: 1, State: 0 2007-01-13 05:02:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68. 2007-01-13 05:03:12.21 server Error: 17883, Severity: 1, State: 0
Hi, i tried to install SQL Server 2000 Developer and MSDE the whole day on my Windows XP SP2. MDAC is the latest, that come with WinXP SP2 (2.81). The installation fails at the end after 100% complete.
It says: Translated: "the setup programm starts the server and installs the configuration you chose..." ("das setup-programm startet den server und installiert die von ihnen gewählte konfiguration...")
then it takes some time and the failure appears, saying: "the setup programm could not configure the server. you can find more information in the server-failure-log files and in "C:windowssqlstp.log."
I have a Windows 2003 Enterprise x64 edition cluster setup and functioning normally. Now, I am trying to get SQL Server 2000 installed as a failover cluster but am having some difficulty. When installing, I get the message '[sqsrvres] ODBC sqldriverconnect failed' in the event log. The message happens when the installer is trying to bring the SQL Server Service resource online.
I am able to ping the name of the instance successfully. I am able to manually start the 'MSSQL$InstanceName' service. I have turned off the firewall on both machines, but this did not help. I have the DTC Service setup as a resource in the same cluster group.
I also read http://support.microsoft.com/default.aspx?scid=kb;en-us;815431 which seemed promising, but did not reolve the problem.
Hi guys, I am having a serious problem on my SQL server. Assuming there's a web server (Cold Fusion in IIS) connects to my SQL server (SQL server 2005 and million records in it which consider quite big for the db size), it works fine and run smoothly during weekday. However, there will be lots of users accessing the db through my web application (located at my web server) until my web application get hang. Not only that, even I want to access my SQL server from my place using management studio also fail.
I try remote desktop into the SQL server, view the 'Task Manager', it shows 1-2% CPU usage that it takes; and i'm able to open the SQL server using management studio. Therefore, I try to restart my web service( IIS ) , and it still unable to open my web application. However, once I restart the SQL service, my web application is available. This issue happens to me every weekend with several times. It's no point for me to restart the SQL service again and again.
1) What's the reason that I need to restart the SQL service then only I can open the web application? Is it the SQL server hang or the connection problem?
2) Is it lots of record in the database causing the server gets hang since lots of user accessing the database? 3) Where can I check out the exactly problem on it ? IIS log or SQL log?
Hope can get any assistance from here and get a solution/suggestion from you guys as soon as possible.
i was trying to install sql server 2000 enterprise edition on win 2003 with SP1. i got stuck with this error sayinbg;"the driver software you are installing has not been properly signed with Autheticode(TM) technology. therefore windows cannot tell if the software has been modified since it was published. the publisher's identity cannot be verified because of a problem, The installed INF file does not contain digital signature infromation"
Do you still want to install this driver software?
No matter what i click, either yes or no, it takes me nowhere. i googled it everywhere still could not find a solution. please let me know if you guys got any idea.
lately we are experiencing some very strange behaviour on the part of our SQL-Server.
We are using SQL-Server as a combined Database for one COM+ application and one J2EE-Application. All of this is installed on the same machine (dual-CPU, 2 GB RAM).
This setup has been up and running for almost a year now.
In the last two weeks there have been incidences where the performance of SQL-Server is decreasing steadily until it finally hangs completely (just SQL-Server, not the machine itself).
This happens 2-3 times a week, curiously always between 9 and 10 a.m.!
After stopping and restarting the actual SQL-Server "Service", everything is back to normal (until the next morning or the morning after that).
There are a few automated batches that access the database via the COM+ Server. These run at night and are completed before work begins at ca. 7 a.m.
Profiler-Logs show a few "Escalate Locks", but those alone cannot account for this strange behaviour.
