CODEWITHSUNDEEP
sql-servervisual-studio
bap
bap

Reputation: 25

SQL Server Management Studio VS Visual Studio - Different version of SQL

I would love to manage and create my databases in SQL Server using SQL Server Management Studio and use them in Visual Studio but I can't connect to the same database :

Different Version of SQL used

As you can see, Visual Studio is connected to SQL Server 13.0 and Management Studio is connected to SQL Server 12.0.

Can someone help me to figure this out and make the two programs using the same database.

Thanks in advance for your help

Upvotes: 2

Views: 1538

Answers (1)

Hao Vo
Hao Vo

Reputation: 188

You are connected to different instances of SQL Server. Visual Studio is connected to a LocalDB instance while SQL Server Management Studio is connected to SQL Server Express instance. To resolve this issue you just select local instance at login step of SQL Server Management Studio tool.

Upvotes: 3

Related Questions