<div>
You could grant windows account running IIS service access to SQL Server.<br />
If SQL Server is located on remote machine you will need to configure IIS site service account to run under domain account. Here is one more example of connection string:<br />
&quot;Provider=SQLOLEDB;Integra<wbr />ted Security=SSPI;Initial Catalog=pubs;Data Source=.&quot;
</div>


You could grant windows account running IIS service access to SQL Server.
If SQL Server is located on remote machine you will need to configure IIS site service account to run under domain account. Here is one more example of connection string:
"Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=pubs;Data Source=."

<div>
<div class="content wysiwyg-content">
Hallo Expert,<br />
<br />
I am relatively new in ASP and need to switch from username+password ADODB authentication to integrated authentication ADODB.<br />
<br />
My database is MSSQL 2005<br />
<br />
My username+password ADODB authentication looks like this. And it is included in all my ASP sites.<br />
Can someone please tell me how to change the code so it works with authentication to integrated authentication ADODB?<br />
<br />
And do I have to change other parts in my code as well or only this part? &nbsp;<br />
<br />
Thanks,<br />
<br />
Steynsk<br />
<br />
<br />

<pre><code id="code-189514">Set CS = Server.CreateObject(&quot;ADODB.Connection&quot;)
CS.Open &quot;DSN=MyDNS;Uid=MyUsername;Pwd=MyPassword&quot;  
query = &quot;SELECT * FROM tablename&quot;
Set RS = Server.CreateObject(&quot;ADODB.Recordset&quot;)
RS.Open query, CS
</code></pre>
</div>
</div>


Hallo Expert,

I am relatively new in ASP and need to switch from username+password ADODB authentication to integrated authentication ADODB.

My database is MSSQL 2005

My username+password ADODB authentication looks like this. And it is included in all my ASP sites.
Can someone please tell me how to change the code so it works with authentication to integrated authentication ADODB?

And do I have to change other parts in my code as well or only this part?  

Thanks,

Steynsk



ADODB integrated authenticantion instead of username and password authenticantion

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.