John Colby
jcolby at colbyconsulting.com
Sat Aug 16 11:30:25 CDT 2003
Shamil, I would HIGHLY recommend a fresh install of Win2K / SQL Server and the rest. I am thinking that you may never the registry straightened out and may therefore have small crazy problems for the rest of the computer's life. John W. Colby www.colbyconsulting.com -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com]On Behalf Of Shamil Salakhetdinov Sent: Saturday, August 16, 2003 7:30 AM To: AccesD - dba-Tech Subject: [dba-Tech] OT: W2K gurus your advice is needed (moved here from AccessD)... Gentlemen & gentlewomen, and especially the greatest AccessD advisor Mr. Drew Wutka! I wanted to report here that subject problem is on its way to be solved. Having got Drew's advice/hints I did some dirty registry hacking (what MS advises in KB wasn't enough - I needed to manually edit another dozen of registry entries) and voila' the W2K Server loads now and seems to work 80 percent correct... But there are still some annoyning problems, which I wanted to ask your advise here how to solve. Here is the first one - SQL Server Service doesn't want to start now: <<< And error 1069 - (The service did not start due to a logon failure) occured while performing this service operation on the MSSQLServer service) >>> and <<< A connection could not be estableshed to PARIS\SQLSVRONPARIS Reason: SQL Server does not exists or access denied. ConnectionOpen (Connect())... Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the PARIS\SQLSVRONPARIS node) and try again. in the system event log I see for Service Control Manager: Logon attempt with current password failed with the following error: Logon failure: the user has not been granted the requested logon type at this computer. The MSSQL$SQLSVRONPARIS service failed to start due to the following error: The service did not start due to a logon failure. >>> I probably should better reinstall SQL Server but maybe there exists a quickier solution? Another question - is it possible to make a kind of repair install for W2K Server ? - if this is possible where I can read about it? Reason: there are other messages, which are very cryptic for me to expect I find how to solve the problems behind them - these are the messages from different system logs: <<< NetLogon: Dynamic registration or deregistration of one or more DNS records failed with the following error: No DNS servers configured for local system. >>> <<< MRxSmb: The redirector was unable to initialize security context or query context attributes. >>> <<< DHCPServer: The DHCP/BINL service has determined that it is not authorized to service clients on this network for the Windows domain: DAISY.local. >>> <<< NTDS: General, Global Catalog The attempt to communicate with global catalog \\paris.DAISY.local failed with the following status: Could not find the domain controller for this domain. The operation in progress might be unable to continue. The directory service will use the locator to try find an available global catalog server for the next operation that requires one. The record data is the status code. >>> <<< NTDS: General, Global Catalog Unable to establish connection with global catalog. >>> <<< UserEnv: Windows cannot determine the user or computer name. Return value (1908). >>> Despite all that error messages above W2K seems to work rather well and it has some rather stronmg self-repairing facilities... TIA for any help, Shamil P.S. This accident with my system was AFAIU because I installed the second harddrive with jumpers set incorrectly. Because of that during boot-up W2K Server used I: drive as its system drive but there was also C: drive present with W2K server operation system installed on it - so it (W2K) somehow managed to load in this configuration but on shutdown (or even during its working) it MODIFIED registry by writing absolute paths starting from I: for some services, data (including Active Directory) etc. .... And I thought I made full backup before I started my stupid games with hardware but I DIDN'T do backup of system information :( So the only solution was to continue my crazy games - now with registry)... It seems that it worked in general but there are still some problems as above... As in any accident there exists a positive experience - I've never had enough time to look that close on all existing Windows services, registry entries etc. - I think I'm now quite experienced in all that and in back-uping/restoring... ----- Original Message ----- Shamil Salakhetdinov shamil at smsconsulting.spb.ru Fri Aug 15 23:30:25 CDT 2003 Thanks a lot, Drew, this is what I was looking for! I will read and play with it and will try to apply it! I should have asked my question here yesterday! Many thanks, Shamil ----- Original Message ----- From: "Drew Wutka" <DWUTKA at marlow.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Friday, August 15, 2003 10:07 PM Subject: RE: [AccessD] OT: W2K gurus your advice is needed... > Here ya go Shamil: > http://support.microsoft.com/default.aspx?scid=kb;en-us;249321 > > Tell your system engineers that it might help if they took a look at MS's KB > once in a while! <evilgrin> > > Drew > > -----Original Message----- > From: Shamil Salakhetdinov [mailto:shamil at smsconsulting.spb.ru] > Sent: Friday, August 15, 2003 11:54 AM > To: AccessD > Subject: [AccessD] OT: W2K gurus your advice is needed... > > > Hi All, > > Here is a tough one - at least the system engineers I know here can't answer > this question/help me: > > - as the result of my hardware upgrade and different (stupid) manipulations > I've got my system disk (W2K) getting I: as drive letter instead of C: > during booting (all the other five disks are OK - D:, E:, F:, G:, H:)... > > Funny? Yes - as the result when I try to logon after booting it accepts > password but then after some time instead of showing desktop icons etc. it > shows "Saving your settings" dialog and returns to Logon dialog... > > I've found that system disk gets I: drive letter instead of C: by connecting > to the problematic PC from another computer and by using Disk Management > system utility. I've also used Event viewer to see that W2K can't start > system programs and services because it expects C:\..... as system drive... > (It's interesting that it works at all... - this W2K is a good software....) > > MS probably never tested such a use case as I managed to create here!... > > Well, the question is how/and where can I set system drive letter back to > C:. I tried to find something in registry but failed. Is that written in a > system file? Which one? > > Of course I've backup and I can try to restore from it but maybe it's > quicker to replace just one(?) file where physical<->logical disk > correspondence is stored? (I've spent quite some time on all that - first > thought was that this is MSBLAST but I run MSBLAST fix and it didn't find > anything... ) > > Does anybody know how is this drive mapping system file called and is it > possible to solve my task by just overwriting this file? (of course I will > boot from another drive and use problematic drive as slave and use backup > copy to overwrite system file keeping drives mappings)... > > TIA for any info, tips and tricks, > I hope there are real NT gurus here, > Shamil > > -- > e-mail: shamil at smsconsulting.spb.ru > Web: http://www.smsconsulting.spb.ru/shamil_s _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com