0

After right clicking on DB and trying to create a new DB this is the error I am getting

enter image description here

What am I missing? I tried re-installing SQL Server 2008 R2 already. Any other ideas?

marc_s
  • 675,133
  • 158
  • 1,253
  • 1,388
RahulB
  • 1,900
  • 1
  • 16
  • 24
  • Any previous version already installed (SQL Server 2005)? Was there any issues/warning during installation process? Which .NET framework you are using? – Kenan Zahirovic Sep 02 '14 at 09:06
  • @KenanZahirovic : Nope. No previous versions installed. .NET framework is 4.0.30319 – RahulB Sep 02 '14 at 09:16
  • Can you try to create database using T-SQL? Open new query and execute "CREATE DATABASE test" – Kenan Zahirovic Sep 02 '14 at 09:23
  • @KenanZahirovic : It is kinda stuck after executing the above mentioned query. It is showing debugging... but doesn't seem like any progress even after 10 mins. – RahulB Sep 02 '14 at 09:45

1 Answers1

0

It seems to me that you have an issues with .NET framework version. AFAIK, SQL Server 2008 needs .NET 2 and I'm not sure how is it working on your machine with .NET 4.0.3.

You can try to execute following query:

select * from sys.dm_clr_properties

and see which version you are using in SQL Server. For more details read here

Community
  • 1
  • 1
Kenan Zahirovic
  • 1,567
  • 13
  • 24