user3616544
user3616544

Reputation: 1069

Visual Studio 2019 v16.2.1 can't open sql script file in SSDT project

I just installed the latest Visual Studio 2019. I can open my SQL database project. But when I try to open a SQL script file, I got the error:

Failed to create an editor. Value cannot be null. Parameter name: Password. 

Any idea how to fix it?

Upvotes: 1

Views: 1785

Answers (2)

Mister X
Mister X

Reputation: 29

This error occurred for me too when I had a connection setup in my database project, where the password is blank.

Even though the database server I use is perfectly fine with no password, the editor in Visual Studio is not able to handle this.

For me as a workaround, I use another connection for my development process. If you can't do that, I recommend creating a new user for this purpose - where the password is set.

Upvotes: 1

Yones Mehrban
Yones Mehrban

Reputation: 91

delete the file with "user" extension in your application root.

Upvotes: 7

Related Questions