microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 899 forks source link

Failed to change kernel. Kernel SQL will be used. Error was: Notebook process exited prematurely with error code: 1 #19419

Open RhinoDBA opened 2 years ago

RhinoDBA commented 2 years ago

Steps to Reproduce:

  1. Downloaded fresh install of ADS from Microsoft.com
  2. Installed
  3. CNTRL SHFT P image

Selected All Kernels image

Install appears to have installed all dependencies

image

Opened a new Notebook, added a Code Cell and attempted to switch to the PowerShell Kernel

image

Does this issue occur when all extensions are disabled?: Yes/No

RhinoDBA commented 2 years ago

I helped a friend yesterday with a new install of ADS, and configured the notebooks to run the kernel dependencies and he was able to switch kernels to PowerShell on his first attempt and it works great. I have uninstalled and reinstalled several times. I have picked different directories to do the install as well as different directories to configure the kernel dependencies. But I keep getting the same error. I even ran ADS As Administrator. Same error

RhinoDBA commented 2 years ago

I was finally able to fix this. I took a few screen shots of the directories that the installer was using. I then went to my Users profile and had to manually delete all folders for Python, Jupyter, Azure Data Studio etc.... in my Local profile and my roaming profile, then did the re-install. When you uninstall ADS, it appears that those profile dependencies are not removed after an uninstall is complete. After this last install, since the user profile directories were not there, it laid down a new install

chlafreniere commented 2 years ago

Interesting issue. @lucyzhang929, @corivera have you seen this occur before?