<\/p>\n
As a high-level security measure in SQL Server,<\/p>\n
if you do not want application developers to know the application’s user password, this article will be helpful.<\/p>\n
With this method, the application will only be able to connect to the database from specific application servers.<\/p>\n
We need to identify the application servers that need to be connected to the database as login to SQL Server as follows.<\/p>\n
CREATE LOGIN [Domain\u0130smi\\TESTSERVER$] FROM WINDOWS;<\/pre>\n<\/p>\n
You should write your server name in the section titled TESTSERVER above.<\/p>\n
I’m referring to an important point.<\/p>\n
You should type the server name in uppercase letters.<\/p>\n
<\/p>\n
When you create Login this way, application developers need to write “
Integrated Security = SSPI<\/code>” or “Trusted_Connection = True<\/code>” instead of userid and password in the connection string.<\/p>\n\n<\/div>\n