Security

Re: 2008 member srv needs trusted SQL connection on domain member server

Ken Schaefer — Fri, 04 Apr 2008 18:26:47 GMT

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

Re: 2008 member srv needs trusted SQL connection on domain member server

infodon — Wed, 02 Apr 2008 13:09:30 GMT

Yeah I thought of that. Anyway using windows credentials??

Re: 2008 member srv needs trusted SQL connection on domain member server

jeff@zina.com — Thu, 27 Mar 2008 13:52:17 GMT

Use SQL accounts, not Windows accounts. Domain membership won't matter. Connection string as appropriate, see www.connectionstrings.com for examples.

Jeff

2008 member srv needs trusted SQL connection on domain member server

infodon — Thu, 27 Mar 2008 13:05:49 GMT

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