vamsi056 (10/15/2012)
Yes i read this articlehttp://support.microsoft.com/kb/2032911
i only have one Laptop , can i run sql server on a normal windows server ? i can but this makes me to not have the option of creating users and computers so that i can work with sql server assigning roles and permissions.. (which are based on windows authentication). Hope you understand what iam saying. provide me a clear cut solution with or without virtual machine
And do you read this http://msdn.microsoft.com/en-us/library/ms143506.aspx
in section: Installing SQL Server on a Domain Controller
you can read that:
For security reasons, we recommend that you do not install SQL Server 2012 on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:
You cannot run SQL Server services on a domain controller under a local service account.
After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.
After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.
SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.
SQL Server Setup cannot create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, Setup will fail.