then you dont have a local instance of SQL installed which is why you cannot connect

SQL SERVER (instancename) where instancename is the name of the instance you want to connect to, if its default is MSSQLSERVER, if its named it will be the name so...

can look in config manager or services.msc, looking for a state of running or started depending which you look at

are the sql services running?

that wont work either as if they are part of group1 which has been granted, then also part of group2 which has been denied, then the DENY will take preference...

the database needs to be online for it to be backed up, so you will have to backup from your primary node, not your secondary

take it this is in a...

select top 1 b2.physical_device_name from msdb.dbo.backupset b1

inner join msdb.dbo.backupmediafamily b2

on b1.media_set_id = b2.media_set_id

where b1.type = 'I' and b1.database_name = ''

order by b1.backup_finish_date desc

if you have subsequent diff backups for the databases to restore then you need to leave them in norecovery mode, other wise you need to restore the full backup and...

for point 1, take a look at the build list on msdn

2008R2 build list is at http://support.microsoft.com/kb/981356, but a google search of SQL SERVER XXXX BUILD LIST will bring in...

please take a look here

John is right, the second note in the licencing doc details

So goes back...

remember in 2008 you licence the CPU not the CORES, so if you have 16 cores, how is that broke down? 2cpuX8cores or 2cpuX4coresHT or 1cpuX8coresHT etc etc

(note when you...

Had a PM from this user on this, and he was using UNION inserting a dummy record but also passing in 0 for a division and also getting devide by...

Looking at it your going to have to do this in the SQL batch and then pass it into the report already aggregated, I cant see a way to do...

in short no, the issue is in your design, you will never get the right value as its a string as a base data type