What type of connection are you attempting ? Has it worked before ? Can you use the ODBC administrator on the IIS server to connect successfully to the database server...

So many responses, so many ideas. I've worked at small shops to fortune 100 shops and have seen at least 15-16  different archival strategies throughout my career. I've also fought...

Just one additional point. You'll probably have to investigate the front-end application (or whereever the data originates) to make sure it is functioning properly as well. If the front-end is...

Justification for individual servers comes by functionality in our organization (like most organizations, it takes time and pain to realize this). We know SQL Server database servers need to be...

Before posting at least try 'googling' for an answer first ...

I googled on your error string:

    "System.Security.SecurityException: Requested registry access is not allowed."

And received this link:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;329291

Why not just make a copy of the database on another SQL Server ? If you do not have one avilable, then make another atabase on the same SQL Server...

Great information Phil !!!

(and very professional handling of this 'individual')

Cheers

LSN = log sequence number

(Since I didn't know the acronym positivelty I googled for "SQL Server LSN")

If you are going through a secure vpn into a secure network with encryption then nothing really. I've been a DBA for 20+ years and had VPN via the internet...

Check out this link as well ...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991

Oh, I almost forgot. You're probably changing the account because a DBA left. Well that is really not neccessary if you simply remove interactive logon rights from the domain user...

You can change the password on any of the services for SQL without restarting. It just does not take affect until you restart the service. Usually this is not an...

Your situation is unfortunate. Now you need to turn to 'religion' for the answers. For the present, you can 'pray' that a media restoration company (for about 5k per 36gb disk)...

Just curious ... couldn't you just:

1) stop replication

2) detach the database

3) move the mdf/ldf files

4) attach the database

5) restart reoplication ?

I'm no replication expert but it seems that you've taken the hard way...

quoted_identifier has nothing to do with it. It's basic rules about using single and double quotes with literal strings (string constants). These rules exist in all programming languages. Granted 'esoteric' in some ways...