I'm building a custom application on Sharepoint 2010 that runs in an IIS virtual directory under a Sharepoint site (so it has access to SPContext and such which I need). My application (Asp.net MVC by the way) is using its own SQL Server database.

Everything works as expected (application has been in development for a year now) and it came to a point when it needs to be deployed.

I've configured my SQL connection to use a single SQL DB user to access my database. But I would like to use Integrated Security = SSPI or in other words I'd like my application to access my custom DB using the Sharepoint logged on user.

I suppose I should first impersonate my user to run Sharepoint site and after that use SQL connection setting for integrated security. But I suppose that turning on impersonation in Sharepoint 2010 isn't just a switch in web.config is it?

Question tags assistance: I don't have enough reputation to create new tags so could someone please add impersonation to tag list of this question? And possibly database-connection as well.

Additional info

I'm not using any of the Sharepoint database connectivity functionality to access my database. I just use my own connection string and access my database manually. In other words I'm not using Sharepoint BCS or anything else.

I'm building a custom application on Sharepoint 2010 that runs in an IIS virtual directory under a Sharepoint site (so it has access to SPContext and such which I need). My application (Asp.net MVC by the way) is using its own SQL Server database.

Everything works as expected (application has been in development for a year now) and it came to a point when it needs to be deployed.

I've configured my SQL connection to use a single SQL DB user to access my database. But I would like to use Integrated Security = SSPI or in other words I'd like my application to access my custom DB using the Sharepoint logged on user.

I suppose I should first impersonate my user to run Sharepoint site and after that use SQL connection setting for integrated security. But I suppose that turning on impersonation in Sharepoint 2010 isn't just a switch in web.config is it?

Additional info

I'm not using any of the Sharepoint database connectivity functionality to access my database. I just use my own connection string and access my database manually. In other words I'm not using Sharepoint BCS or anything else.

I'm building a custom application on Sharepoint 2010 that runs in an IIS virtual directory under a Sharepoint site (so it has access to SPContext and such which I need). My application (Asp.net MVC by the way) is using its own SQL Server database.

Everything works as expected (application has been in development for a year now) and it came to a point when it needs to be deployed.

I've configured my SQL connection to use a single SQL DB user to access my database. But I would like to use Integrated Security = SSPI or in other words I'd like my application to access my custom DB using the Sharepoint logged on user.

I suppose I should first impersonate my user to run Sharepoint site and after that use SQL connection setting for integrated security. But I suppose that turning on impersonation in Sharepoint 2010 isn't just a switch in web.config is it?

Question tags assistance: I don't have enough reputation to create new tags so could someone please add impersonation to tag list of this question? And possibly database-connection as well.

I'm building a custom application on Sharepoint 2010 that runs in an IIS virtual directory under a Sharepoint site (so it has access to SPContext and such which I need). My application (Asp.net MVC by the way) is using its own SQL Server database.

Everything works as expected (application has been in development for a year now) and it came to a point when it needs to be deployed.

I've configured my SQL connection to use a single SQL DB user to access my database. But I would like to use Integrated Security = SSPI or in other words I'd like my application to access my custom DB using the Sharepoint logged on user.

I suppose I should first impersonate my user to run Sharepoint site and after that use SQL connection setting for integrated security. But I suppose that turning on impersonation in Sharepoint 2010 isn't just a switch in web.config is it?

Question tags assistance: I don't have enough reputation to create new tags so could someone please add impersonation to tag list of this question? And possibly database-connection as well.

Additional info

I'm not using any of the Sharepoint database connectivity functionality to access my database. I just use my own connection string and access my database manually. In other words I'm not using Sharepoint BCS or anything else.