Steve,

Are you confident that on the "normal" server build, you can install same version of the SQL on the same version of Windows server without any issues?

Have you checked local...

Steve,

1)when you were un-installing the express, were you doing from the control panel?

was it normal - ie you can see the server name?

2) is it being run...

1) Check that your account has got administrative priviledges & you have got full access to all the drives on the server

2)Check there is no "unknown" policy running on the...

regarding memory not releasing, same server build

this is the result of the sys.dm_os_performance_counters

object_nameCounter_namecntr_valuecntr_value_MB

SQLServer:Buffer Manager ...

read the specification, read the specification:)

Hi Geoff,

Thank you for your help, well I have come to the conclusion that this is a "feature" or bug of Microsoft build - having played around and having...

Hi Adi,

These are my sysadmin role members

sysadminsaSQL_LOGIN

sysadminNT AUTHORITY\SYSTEM WINDOWS_LOGIN

sysadminNT SERVICE\MSSQLSERVER ...

Hi Geoff,

Thank you for your advice

But this account is a sql server account, not a windows one.

I assume when I login to SSMS va SQL Server Account - I should...

Hi Duran,

I would recommend to uninstall it - (you just test throuroughly:)))

Also check your permissions - domain admin, can create computer names etc etc.

And maybe follow this

Hi Duran,

Please see below:

You have created a 2 node sql server cluster - as long as you have got just one instance your set up is active/passive.

When you add...

well the question to ask is really are your SQL Server instances going to use it regularly or sporadically?

if regularly then follow Perry's advice add them as a resource, map...

program files cannot be installed on shared drives on a failover cluster instance, so it leaves you either with c:\ or depending on your server configuration you may have a...

anyway the solution - an account didn't have the permission to login as service

thank you, Perry

good post, do you have some other resorces especially regarding cluster resources configuration:

we have got service going down and not being restarted

Thank you

hi Perry,

Thank you for your previous reply.

New questions though...

Halcyon (10/11/2010)

--------------------------------------------------------------------------------

Or whatever I do I still need to map resource via your link?

Yes you need to use the MSDTC.exe command line...