Here is the situation: I have a Server 2008 box that is trying to connect to a Sql Server 2005 instance. Connections from websites running in the context of IIS work fine to the Sql Server machine using Sql Server authentication. Rockin'.

However, using the same connection string, I cannot get a windows service on the same box to communicate with the Sql Server. Nor can I get management studio to connect from the same box. IIS great, other options no so much.

For grins I have tried monkeying with the user accounts in the IIS app pools to match that of the service to get the sites to break and that hasn't worked, so it doesn't appear to be a user account issue.

Since this is happening with two different programs and not with IIS, I'm assuming there is something shut down on the Sql Server that needs to allow non-IIS connecting things to communicate, but I have no idea what that would be. Any help would be appreciated.


A most astute friend helped me debug the problem and we figured it out (thanks Darren!).

Everything connecting from the machine connects through a sql alias. I didn't know this before but you setup an alias for both 64-bit and 32-bit. We had an alias setup for 64-bit and it was that alias that IIS was using. However, SMS and my service were running under 32-bit and so looked for the alias in the 32-bit configuration, which was missing. Ergo, we could connect with IIS but not through the other programs.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.