In appsettings.json
file, I have this connection string:
"ConnectionStrings": {
"erasmus": "Data Source=VIPER\\DBSERVER;Initial Catalog=erasmus;Integrated Security=True;"
}
VIPER
is my computer's name and DBSERVER
is my database server's name. erasmus
is the database that I want to connect to.
I've tried so many different type of connection string styles but it still doesn't work. Also i want to make an user named admin but it won't work either.
Like
"ConnectionStrings": {
"erasmus": "Data Source=DBSERVER;Initial Catalog=erasmus;Integrated Security=True;"
},
"ConnectionStrings": {
"erasmus": "(local)\\DBSERVER;Initial Catalog=erasmus;Persist Security Info=True;"
},
"ConnectionStrings": {
"erasmus": "Data Source=VIPER\\DBSERVER;Initial Catalog=erasmus;Persist Security Info=True;User ID=VIPER\\ofadu;"
,"ConnectionStrings": {
"erasmus": "(local)\\DBSERVER;Initial Catalog=erasmus;Persist Security Info=True;User ID=erasmus; Password=123456;"
},
"ConnectionStrings": {
"erasmus": "DBSERVER,1433;Initial Catalog=erasmus;Persist Security Info=True;"
},
"ConnectionStrings": {
"erasmus": "DataSource=VIPER\\DBSERVER;Database=erasmus;Persist Security Info=True;"
},
"ConnectionStrings": {
"erasmus": "Data Source=DBSERVER;Database=erasmus;Integrated Security=True;"
}
None are working.