Downgrade SQL 2005 Entreprise to Workgroup Edition ?

Hi

I have the following problem :

I have licensed a german version of sbs 2003 premium. With the upgrade to sbs 2003 r2, I will buy the rights to use the sql 2005 workgroup edition. But the german sbs 2003 r2 is not available by now.

I could go in production with the sql 2005 trial, this is an entreprise edition.

My question is : can I downgrade the sql server 2005 from this trial edition (entreprise) to the workgroup edition ? Is it possible ? easy ? any recommendations ?

Many thanks !

Ferrarirosso

You can upgrade Trial SQL Server 2005 to Workgroup edition but it must happen before the trial edition expires.

Domain Users Rights

I have a problem that im using Active Directory in Win2k Server, when domain users logon to workstations they can't open sql server databases, SQL server is local installed on Workstation and operating system is XP.

When i give administrator rights to users the sql server works fine.

Tell me is there is a way to use sql server without giving to the user administrative rights?

thanksYou need to login as the account that the SQL Server is running in on their boxes (set up a SQL Server "account". You then need to go into SQL Server while logged in as this account and add Domain Users as a login in SQL Server and grant permissions. They can then login and do what they need to do.