开发者

how do i connect to SQL server in SQL Server Mgmt Studio with SSPI Integrated Security

开发者 https://www.devze.com 2023-01-02 11:15 出处:网络
i have an asp.n开发者_开发技巧et web app that has this in the web.config file in the project server=[server],15001;Integrated Security=SSPI;Database=DB_NAME

i have an asp.n开发者_开发技巧et web app that has this in the web.config file in the project

server=[server],15001;Integrated Security=SSPI;Database=DB_NAME

how do i connect to this database from Sql server mgmt studio since there is not use or password in the connection string. i am connecting from a remote machine


When you connect using "Integrated Security", it uses the current Windows credentials of the process - in the case of connecting to SSMS, it will use your current Windows user. If your Windows user has rights to the SQL Server, then you can connect using Intergrated Security.

If you need to connect to the SQL Server using Integrated Security, but as another user, you'll need to do a "Run As..." on SSMS to load it as the different user.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号