Windows 10: MSSQL base errors

Use MSSQL 2008. Need to restore this base on a more recent version MSSQL 2012-2022. When I try to restore this database from a save, errors appear in the new version and the restore is interrupted.Checking the database by the command in MSSQL 2008'DBCC CHECKDB 'AbsoDbUnicode' WITH NO_INFOMSGS, ALL_ERRORMSGS;' revealed the following errors:"Сообщение 8992, уровень 16, состояние 1, строка 1Проверьте сообщение каталога 3853, состояние 1: Атрибут object_id=1690552831 строки object_id=

:)

 

How do I delete C:\Users\MSSQL$ADK ?

Hi,

Have you installed any SQL programs? If you do, MSSQL$ADK is related to that program in
utilizing and handling data management for that specific program. Although this program is harmless to remove, we still suggest to ignore this since that there is no harm is being done to your computer. However,
if you want to remove this, follow these steps:

• 
  Open
  File Explorer
  and right click on
  Local Disk (C.
  
• 
  Choose
  Properties.
  
• 
  Under
  Security Tab,
  To change permissions, click Edit.
  
• 
  Choose
  Full Control.
  
• 
  Select
  Apply
  and click
  OK.
  

Try to check if you now see
MSSQL$ADK.

Let us know how it goes.

Regards.

 

MSSQL INSTALLATION ERROR

I'm getting this error when trying to install MS SQL. I don't know what to do can you help me?

click: mssql error photo

 

Switching from mySQL to MSSQL

Hello all,
I a have a dilemma on my hands. MY application uses mySQL, and everything woks great. I planned to list mysql server as a requirement for my application, so that I didn't have to worry about licensing issues with distribution (my app is commercial, not GPL). My app uses libmysql.dll to connect to the mysql database instance, which, come to find out, must be licensed to distribute as well says Oracle.

So:
I planned to switch everything over to MSSQL express, which is totally free to distribute and use in commercial applications. I am used to mySQL server, not MSSQL. Upon installing MSSQL server, I discovered it uses local authentication (Windows username and pass)... Is there a way to set up MSSQL server to function like mySQL server? ex: requiring my connection string to use username, pass, DB name, and table name? The DB is accessed by both my app and an IIS site runnign on the same server.

Does anyone know of any good tutorials or sample walkthroughs of building a vb.net app that connects to and uses MSSQL server?

Thanks so much guys