>Hello,
>
>I have a asp.net Application developed with VS 2005 and MM 2.3. Webserver ans MS SQL Server are running on two different machines.
>With SQL Server 2003 and User authentication everything works fine.
>Now we want to switch to a SQL Server 2008 and Windows Authentication. I tried now all kind of connection strings and nothing worked.
>
>The only working combination was on my local machine. Here I change the identity in the web.config to me as user and use the trusted_connection=true in the connection string.
>
>Is there another way to do that?
>
>To get it even more complex. The Webserver is not in the domain of the SQL Server. Is there a chance to connect via windows authentication to the SQL Server???
>
>
>Regards
>Thomas
This may be better answered from one of the SQL Server guys, but are you opposed to just using SQL Server Authentication?
Tim
Timothy Bryan