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

Popular posts from this blog

node.js - Node js - Trying to send POST request, but it is not loading javascript content -

javascript - Replicate keyboard event with html button -

javascript - Web audio api 5.1 surround example not working in firefox -