sql server compatibilty issue

Question

when i add database it shows message given below . i have Ms sql server 2012

Anoop Kumar Sharma · Answer

Try this:- Open Microsoft Visual Studio Select Tools >> Options >> Database Tools >> Data Connections Enter the name of an installed instance in SQL Server Instance Name field. Click OK If you do not know the instance name you can follow either of the options. 1) Use the command line sqlcmd utility C:\users\...\...>sqlcmd -L 2) Using SQL Server Management Studio

romasha ali · Answer

it solve the problem but now when i m right clicking on table it sows refresh and properties option rather than create table option

Sanjeeb Lenka · Answer

If you want to add database from visual studio you have to install the express edition of sql server. just instal it and the error will solve.