Can't connect to SQL Server with my vb.net program -
i'm trying test sql server (i've never used before), , annoying error:
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")