SQL Server Windows Authentication (Intregrated Security True) not working in hosted site

Vasanth

I have created a website which has sql server 2008 r2 version as my back end and i am using windows authendication for that.

When I host my website in iis, it leaves me an error,

but when i run locally it is running.

Can any one give me an idea about how to fix this issue.

After than i have replaced to the sql server authendication, i have replaced the files in the folder that is mapped with the iis.

But it is leaving the same error that is shown in the old files.

but i have replaced the files in the corresponding folder.

Here my questuion is

- whethere i can host my website with the back end authendication as windows.

- After the replacing of files, it is showing the same error that shown in the old files.

Can any one give me an idea please ASAP.

Please let me know if this is not clear.

thanks.

Advance Happy New Year to all.

Andrea

0 1

Vasanth

0 2

Thanks for the reply @Andrea

But the link you provided does not fully satisfied my requirement.

Can you please give me a link about how to host a website in iis that has back end as sql server 2008 and log in type is "Windows Authendication".

Mudassar

0 3

In hosting you cannot have Windows Authentication unless your provider supports it. And if they support ask them to give you the connection string.

But generally no hosting provider will give you windows authentcation and also it is a bad practice to have it on server