I had tried that when I ran into the same problem. Unfortunately, that fix didn't work for me. That's the reason I installed the standalone to get the browser account.

Without knowing the application, if it uses an ODBC connection you can add a mirror database server through the ODBC configuration in windows.

If the application uses an ADO .NET connection,...

hehe, I couldn't wait to use this answer 😀

It depends.

It depends on whether or not you are using a witness in your setup. With a witness, High Safety, either mirror...

Don't delete it from the registry, you'll just get yourself into more trouble.

A clustered instance cannot be removed through add/remove programs. You must use the installation media. Once you start...

Use the GUI, worry about scripting it later.

Start with the principal. Right click > tasks > mirror, click configure security. The wizard will walk you through specifying each database (and...

you had it right the first time.

1.full then log backup on principal.

2.restore full then log with norecovery on mirror

3.establish mirroring

when you restore with norecovery, the database will be in a...

I think you're having the same problem I ran into a while ago.

I had a 2005 standalone on server A. I then wanted to install a 2005 cluster on server...

SSMS is not a clustered tool.

Trying using the "Install a Standalone" and just choosing SSMS in the shared feature group.

Double post.

Please do not reply in this thread.

Direct replies to

http://www.sqlservercentral.com/Forums/Topic938797-391-1.aspx

pics pl0x

With the fear of answering this "wrong", I'll throw it out there anyway.

When I try to use a database dynamically, it's usually within a procedure. Then I can use dynamic...

Ensuring your tables are properly indexed and using inner joins where possible would help performance.

I'm pretty sure it's very dependant on the structure of the tables and the format...

perhaps posting the trigger script will get you more feedback? This will make it easier to troubleshoot your problem.

I apologize for not being able to explain in detail how to accomplish this, but it seems like you might be able to do it with SSIS.

Create a package that...

Might you be able to right click and script the job? Then just run the script through SSIS or run it manually on the server?

good luck