Haslett, Andrew
andrew.haslett at ilc.gov.au
Tue Sep 23 21:07:16 CDT 2003
Oops, just saw the last line. Definitely install into a clean directory. SQL can't just 'pick' up from existing data files like that. They need to be restored or attached from a backup using the processes described in BOL. Cheers, Andrew -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Wednesday, 24 September 2003 1:14 AM To: SQLServer Subject: [dba-SQLServer]Can anyone give me personalized help Folks, I replaced my hard disk in my server and now I am not getting a successful SQL Server install. It appears that it runs, I can start the server, but as soon as I go into Enterprise manager and attempt to drill down to the server under server group, it stops the SQL Server (the icon in the toolbar goes red), hangs for a long period (60 seconds or so?) with "Establishing connection to SQL Server and checking security" in the status bar of Enterprise manager. The server eventually displays but there are no databases at all in the database window, not even the system databases, and if I attempt to look at some other pieces under there one of them causes a gpf and EM closes. Something is seriously wrong, and all my billing data is in a backup waiting to be restored. I told it to use an existing directory that already had my old database in it when I did the install. Could that be the problem? John W. Colby www.colbyconsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.