I have used mirroring to do this in a web asp.net app with minimal downtime - you will loose a few connections but it is only for a few seconds.

What...

Have you got the right servername / instance name specified?

If you rdp into ther server can you connect to the servername using sqlcmd or ssms?

ok you don't have the sql client tools installed so that didn't help!

Can you instead try and create a system dsn (control panel-->admin tools-->Data Sources (odbc)) - make sure it...

on the server you are running the installation from if you do this from a command prompt:

sqlcmd -E -S TSharePoint

does it connect or give you an error?

I use MSA 2212fc with raid 5 at the moment and they are fine for our applications - but you need to decide how fast you need your db to...

Can you post the contents of the email as a text document and seperate image docs so we don't have to open it in outlook?

ed

also - no matter how much work it is it is always worth setting it up securely instead of just adding them to the local admin account!!

WMI is a bit of a funny animal, if you have an ms support contract I would give them a ring!

If you don't then I would run process monitor...

To encrypt traffic to sql you have two choices, they both work over the actual sql port (default instance = 1433).

The first is to enable encryption through the server configuration...

Hi - The packets are tds packets, which is documented on msdn - do a search for [ms-tds]. I have written a tds parser before if you need some...

I think it is down to how you choose to work and what works best in a specific circumstance, apart from being able to create indexes and statistics on temp...

why don't you just have that at the top of your sql command - if it does match then just have a return then the rest of the script won't...

What is the condition? If it is a variable stored in a table in a database you can include it in the sql script - if it is something...

To rule out a problem with smo you could script the restore and see what error's (if any) you get then.

Just go to restore it as normal but instead of...

here you go:

CREATE TABLE [dbo].[adusers](

[DN] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[objectClass] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[distinguishedName] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[instanceType] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[whenCreated] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[whenChanged]...