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

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

html - How to custom Bootstrap grid height? -

Ruby Google Calendar Integration Watch Event / Push Notification -