I have using 2 computer to learn C# programming, installed everything the same yet one computer have outdated SQL server. i don't understand why this happen

Rudi Hartono 116 Reputation points
2020-10-09T15:44:49.077+00:00

Hi, please forgive my bad english.

  1. i have 2 computers installed vs 2019 to learn database programming.
  2. i am using a USB drive to save my codes and database (set a fixed drive letter)
  3. idk why everytime i start vs i need to reconnect my database at data connection in server explorer (in this case usually works fine). suddenly today there was this error

31331-ss.jpg

  1. and i looked here and there and install a bunch of stuff of SQL server 2019 thing, yet no avail (at this point, i don't what i am doing already, just googling for advise and follow their instruction, and nothing goes well)
  2. randomly looking at my project folder and found a folder with history of my test run application. i copy that mdf and ldf and replace the error one, and it works. but only for 2 minute this error happen again. please help for advice. thank you.
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,631 questions
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
935 questions
0 comments
Accepted answer
  1. Rudi Hartono 116 Reputation points
    2020-10-10T16:19:05.153+00:00

    Finally i found the solution of my problem.
    I have updated my SQL server editon. but data source at vs still the Localdb of old version, when i am using new sql server data source, settled.

    thank you.

    0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Karen Payne MVP 35,031 Reputation points
    2020-10-10T22:20:18.423+00:00

    In the future you can script your database and set compatibility level to match which edition of SQL-Server being used using SSMS (SQL-Server Management Studio).

    1 person found this answer helpful.
  2. Rudi Hartono 116 Reputation points
    2020-10-09T15:51:14.727+00:00

    After i test again to replace the bin database.

    1. the connection can be established.
    2. after doing a test run, the database instantly cannot being access again. this is so weird...!!!!
    0 comments
  3. Erland Sommarskog 100.8K Reputation points MVP
    2020-10-09T22:00:09.193+00:00

    Which versions of SQL Server do you have on your machine? 904 is SQL 2019, and 852 is SQL 2017, I think.

    0 comments
  4. Rudi Hartono 116 Reputation points
    2020-10-09T23:44:28.873+00:00

    Hi, i don’t how to check my machine version, as i installed all the 2019 sql yet i didnt found application of it

    0 comments