Can't connect to SQL Server with my vb.net program -


i'm trying test sql server (i've never used before), , annoying error:

enter image description here

i've traveled multiple websites, multiple questions, , not solution. user 'mrdan' windows admin... can't understand why can't connect.

dim con new mysqlconnection("server=********;database=pruebamultiple;user id=mrdan;password=*****;") 

am missing something? or using bad connection string?

first, connections sql server made using sqlconnection, not mysqlconnection. mysql , sql server different database systems. second, explicit credentials work sql accounts. you're trying log in windows user, , should therefore use integrated security=sspi in connection string (and omit user name , password). sum up:

dim con new sqlconnection("server=********;database=pruebamultiple;integrated security=sspi") 

Popular posts from this blog

php - How should I create my API for mobile applications (Needs Authentication) -

python 3.x - PyQt5 - Signal : pyqtSignal no method connect -