An interesting and relevant question it is indeed, and an issue I'm struggling with nowadays.

I tend to create an AD-group for every single role that I discover, but it leads...

I just found out the answer (http://technet.microsoft.com/en-us/library/bb693954.aspx).

Thanks to all who tool the effort to read this post.

Topic can be closed.

regards,

Hans

Thank you for replying Marcus.

Do you also know if there is any difference in a database that still has level 80 and the same database that I have created by...

In reply to my own post:

I stopped the existing SQL Server services and changed the account under which these services run to the acoount that I used to log on...

Thank you for this swifft reply Markus.

What I noticed is that I did not have to grant access rights explicitly to stored procedures when I added the domain account directly...

Thank you for the reply.

I have tried this, but it does not work. I get the message 'Unable to retrieve steps for job ...' .

Only when I enable BUILTIN\Administrator...

I found a warning about the job in the Windows Event Viewer.

It says:

'

The job failed. Unable to determine if the owner ( ) of job DB Backup...

Some extra information about the job: the job is a backup task to makes a backup on a different server. So I realize that the owner needs access to the...

I tried that, but I'm missing something and I can't figure it out.

To recap:

- The job is running under the SQLSERVERAGENT service

- Apparently it is important who is the owner...

I will try to change the owner and keep you posted.

Thanks.

Hans

Thanks for swift reply michaela.

The owner is a domain group account, who is also member of the domain admin group.

The job is a maintenance plan job, backups and optimizations.

The...

I have tried to connect from another client, this also results in the same error.

I have not installed Management Studio on the server itself (our company has the policy not...

Try the folowing Transact SQL query to find the license information:

SELECT serverproperty('LicenseType')

Also see Books Online: http://msdn2.microsoft.com/en-us/library/ms174396.aspx

Hans

I am using SQL2005 Standard Edition SP1.

In the meantime, I found the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\BackupDirectory

that holds the default location, but somehow it seems to me a bit...

I experienced that working with an 'internal mutiplication factor' works out quite alright for me.

When estimating how much time a project would take, most of the time I've got...