« Previous Next »

• 03-27-2008, 9:05 AM

  infodon Joined on 03-27-2008, 12:59 PM Posts 3

  2008 member srv needs trusted SQL connection on domain member server Reply Contact I have 2 servers a 2008 IIS7 member server (not in a domain) and a 2003 server with SQL (member server in a domain). I know the easiest way is to join them both in the domain and use a service account....yep OK . Unfortunately, we cannot do it at this time, so I need an interim solution to be able to connect the ASP application to the SQL server...securely. Is there a way to establish a trusted connection between the two servers?? The only thing I have come up with is to move the SQL server to the same box.  Any Ideas

• 03-27-2008, 9:52 AM

  In reply to

  jeff@zina.com Joined on 09-26-2003, 10:43 AM Naples, FL, USA Posts 2,063	Re: 2008 member srv needs trusted SQL connection on domain member server Reply Contact Use SQL accounts, not Windows accounts.  Domain membership won't matter.  Connection string as appropriate, see www.connectionstrings.com for examples. Jeff Look for Wrox's new book Professional IIS 7 in your local bookstore, or order now at Amazon.com

• 04-02-2008, 9:09 AM

  In reply to

  infodon Joined on 03-27-2008, 12:59 PM Posts 3	Re: 2008 member srv needs trusted SQL connection on domain member server Reply Contact Yeah I thought of that. Anyway using windows credentials??

• 04-04-2008, 2:26 PM

  In reply to

  Ken Schaefer Joined on 09-17-2002, 9:05 PM Sydney, Australia Posts 53

  Re: 2008 member srv needs trusted SQL connection on domain member server Reply Contact Create a Windows account on the member server that has the name username and password as in the domain (or corresponding local account on the SQL Server) Specify the username and password in the connection string without using the doman or servername prefix. That works with two servers that are both in a workgroup (IIS and SQL), so I suspect it should work. Cheers Ken Microsoft MVP - Window Server (IIS) MCITP (EA, SA), MCTS (ISA, SQL Server, Hyper-V, MOSS, Ops Manager), MCSE+Security, MCDBA