sql server - Windows 10 and Visual Studio 2017 Integrated Security -
i used never have problem using integrated security while debugging in visual studio , connecting sql server.
now windows 10 , visual studio 2017, when use integrated security trying connect sql server exception
system.data.sqlclient.sqlexception: cannot open database "datamanagement" requested login. login failed. login failed user 'microsoftaccount\clark.l.christopher@gmail.com'.
i'm connecting sql server on own local machine. if can connect sql server using windows authentication on local. integrated security should pick same account , use it.
the server name : desktop-5regml8\sqlexpress
authentication confirmed as: windows authentication
user name : desktop-5regml8\clark
and connection string in code data source=desktop-5regml8\sqlexpress;initial catalog=datamanagement;integrated security=true
boy strange, think found work around running sql script. rather confirm integrated security working. there better solution inline previous versions of visual studio/windows?
Comments
Post a Comment