Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Connectionstring Windows Authentication
Message
From
25/08/2009 12:54:31
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
 
To
25/08/2009 09:16:13
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
01420441
Message ID:
01420504
Views:
46
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform