Problem with domain group and diagrams

I have a problem and I dont have an idea to solve it. I work with SQL Server and my students on Faculty of Information Technology.

I have create SQL Server login for domain group of users (about 60 od them). That mean I have SQL Server login like this Domain\Users To whole group of users I had grant server role (dbcreator). I dont wish to import 60 login one by one and gice that permision. Ok, student can create database without any problems But, when they try to create database diagram (expanding database diagram node). They get a message that database need to have a valid owner (Hmm..ok its not a big deal to do it) Quick check to some of database (Right click-->properties-->General-->Owner (ther is a Domain\UserName (not name of group)..and that is ok (Right click-->properties-->Files-->TextBox Owner. I try to enter same Domain\UserName from step 5. But I get this message

TITLE: Microsoft SQL Server Management Studio

Set owner failed for Database '1110_EvidencijaKnjiga'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Set+owner+Database&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred in SMO. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

The login 'Domein\UserName' does not exist on this server.

BUTTONS:

OK

This is wired. Ok I know that that user is not login but group is. Step 5 show that user, but step 6 have empty owner options and dose not allowe me to enter same user.

How to fix this?

Thank you

Try changing the database owner to a valid login by executing the following SQL statement:

ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO sa

-Sue

|||

Sue Hoegemeier wrote:

Try changing the database owner to a valid login by executing the following SQL statement:

ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO sa

-Sue

Thank you Sue for your advice and solution of my problem.

But I am not happy with your solution of problem. Here is why.

Ok, I change owner to sa. But now domain user who is create that database, have not aprorpiate permission. (dont forget I have import doman group on SQL Server..not user one by one). Now I must cretae account on SQL Server for that doman user and give him (or her) db_owner database role. In my case that step I need to repeat about 30 times. In that case doman groups on SQL Server are not cool solution in cases like mine.

Is there any other solution or if somene can expplan why this is hapening? Why user from doman gruop with create database role, can not be a valid owner (in terms of SQL error message)?

Jasmin

|||

Make sure the latest service packs have been applied to all the PCs with the client tools. There were some fixes for related issues on SP1. Other than that, you could have them use Visio instead of the diagram tool in Management Studio.

-Sue