what is the error message and error details?

eg

error 18456, serverity 14, state 11

failed to login due to a problem

kangaroo

you granting them as an administrator on the server for RDP access? if so you are also giving them SA access as BULTIN\Administrators in SQL 2005 is a system...

yes SQLCMD does allow Windows Authentication, are you using the -E switch to force a trusted connection?

can you login to the server using SSMS to the same server ok?

Qutip (4/30/2012)

---

I've had a browse round but I've not found anything that helps me, thus I'm here.

The multi-part identifier "BFlights.TransactionID" could not be bound.

I'm getting the above error on the...

it seems that this is one of the things in 2005 you cannot create a DDL trigger for.

take a look at this topic, it details using extended events and service...

as long as you are restoring the backup to a server where litespeed is installed then yes, other wise you will need to use the extractor tool then use the...

if you dont want people to see things your going to have to start changing the security settings on the objects instead of just hiding the things you dont want...

no that is correct, you can only hide objects in tile view

dont know if you could do something fancy in dns, where if they go to

http://servername/reports it forces them to http://servername/reports/pages/folder.aspx?ViewMode=Detail

otherwise you could use something like group policy to push...

following on from this, we had our quarterly maintenance window this weekend and made this change.

so far so good, no deadlocks have been reported so far.

On Saturday we had planned DB maintenance where we failed over all of our instances to their corresponding correct primary node. In doing so all of the web/windows services...

CREATE TRIGGER NameOfTrigger ON ALL SERVER

FOR ADD_SERVER_ROLE_MEMBER

AS

IF SUSER_SNAME() NOT IN ('sa')

BEGIN

PRINT 'Only DBA''s can modify this server and it''s logins'

PRINT 'You''r statement has been logged and emailed to the...

you need to add in the ADD_SERVER_ROLE_MEMBER event to capture anything adding to a fixed server role

this URL might help in the future on finding the correct events to capture...

if you can (which will probably be a long shot) try and push for an upgrade to AX2012.

I've not had any experience with 2012 but from what I have heard...