开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜