Thanks Roy, there seems to be a problem with the script as it says it cannot continue due to not having a valid account to the db. Strange because...

Thanks Roy, I have SQL 2000. Good info! I have QA already opened then I clicked on file then "connect" then entered in the SA logon id and...

Brandie Tarvin (1/16/2008)

I'm not quite sure what you mean by "when I drill down". Could you explain it a little better?

I advise creating a new user account in the...

Just thought I would add this as I was just looking at the MAS500 databases through Ent. Manager and may have found something to help solve this error:

Microsoft SQL-DMO error.

"Error...

I removed the system administrator check from the account "admin". I did not touch sa until just now by checking the box for system admin. I am still...

george sibbald (1/12/2008)

sorry to...

"My advice is to remove all fixed server roles from this account and make it DBO in the MAS databases. This will give it permissions to do everything in those...

Thanks Brandie. Then I must expect that installs or any upgrades to MAS500 will entail using the sa account and just deal with it by not giving the password...

Hello all! Thanks for the responses I will definately pdf this thread! By the way, today the MAS500 consultants got this response from the MAS500 people:

"If the customer...

Thanks all for the replies. It has been about a week now. I have found that the company aSa software (an addon to MAS500) has created some...