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
  • 732,580
  • 175
  • 1,330
  • 1,459
RahulB
  • 2,070
  • 1
  • 18
  • 26
  • 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,587
  • 14
  • 24