Using Integrated Security for Accessing SQL on Remote Server

E

eRic

Hello,

I am currently trying to use integrated security to access the SQL database for the ASP.NET application (deployed on an intranet)

I am following this article
http://msdn.microsoft.com/library/d...kaccessingsqlserverwithexplicitcredentials.as

So far I hav
1. Set the Web.config file to impersonate a specific domain use
<identity impersonate="true" userName = "myDomain\myUserName" password="password"/
2. Created the login in the SQL server and given it appropriate permission
3. Used Integrated Security = SSPI in the connection strin
4. IIS does not allow anonymous access on the site and is using Windows Integrated Securit

So far it's a no go

I've also gone as far as to set the same user (that maps to the SQL login) as the user for the processModel and still nothing
(do you need to reboot the box before changes in machine.config take place?

I read a previous thread that said you need to enable Kerberos delegation for any identity to be passed acrossed machines. Is that the case? If so I really don't understand how the article that I mentioned above could work

Thank
- e
 
K

Kunal

What is the error you are getting ? "Login Failed for NT Authority/System" ?

--
-------------------------------------------------------
http://www.qnal.net/inkabletype

eRic said:
Hello,

I am currently trying to use integrated security to access the SQL
database for the ASP.NET application (deployed on an intranet).
I am following this article:
http://msdn.microsoft.com/library/d...accessingsqlserverwithexplicitcredentials.asp

So far I have
1. Set the Web.config file to impersonate a specific domain user
<identity impersonate="true" userName = "myDomain\myUserName" password="password"/>
2. Created the login in the SQL server and given it appropriate permissions
3. Used Integrated Security = SSPI in the connection string
4. IIS does not allow anonymous access on the site and is using Windows Integrated Security

So far it's a no go.

I've also gone as far as to set the same user (that maps to the SQL login)
as the user for the processModel and still nothing.
(do you need to reboot the box before changes in machine.config take place?)

I read a previous thread that said you need to enable Kerberos delegation
for any identity to be passed acrossed machines. Is that the case? If so I
really don't understand how the article that I mentioned above could work.
 
K

Kunal

When you step through the code..the application is probably throwing a
SQLException with some message indicating the login failure....see if you
can post that here..
 
E

eRic

Thanks for the article, the issue I am having, however, involves the SQL Server on a remote computer(not the same box as the web server)

Thanks
eRic
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top