This server version is not supported. Only servers up to Microsoft SQL Server 2012 are supported [closed]

mwkjh3gx  于 2023-05-21  发布在  SQL Server
关注(0)|答案(2)|浏览(251)

Closed. This question is not reproducible or was caused by typos . It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 10 hours ago.
Improve this question

I have SQL Server 2014, VS 2012 and VS 2013. Both VS are ultimate versions. I can not access SQL server from either VS.

Example:

  1. Open VS. From Tools menu, select "Create Database". Enter SQL Server name, select a database (all the DBs are listed OK). Click on Test connection button. Connection is OK.

Now when I click the OK button, I get the following error.
Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0, Culture=neutral....... The system cannot find the file specified.

  1. From VS, Server Explorer, right click on Data Connections, "Create a new SQL Server database". Enter Server name, enter new database name. Error message appears:
    This server version is not supported. Only servers up to Microsoft SQL Server 2012 are supported.
o2g1uqev

o2g1uqev1#

Please try this once:

  1. Go to Sql Sever Configuration Manager
  2. Then SQL Server Network Configuration -->Protocols for SQL Server
  3. Then Named pipes --> Rc Properties
  4. Copy the Pipe Name.

  1. then go to Visual Studio--> Server Explorer-->Data Connection-->Rc Add Connection

  1. Then Paste the Copied Pipe Name in Server name
  2. Test the Connection.
jhdbpxl9

jhdbpxl92#

  1. Go to Server Explorer (View > Server Explorer)
  2. Right click on Data Connection
  3. Click "Add Connection"
  4. Fill Server name
  5. Fill database name
  6. press "OK"

相关问题