Connections via Windows service

Question

I created a service in C# that opens a connection to SQL and continually reads from a table...I now need a second independent process to do the same thing to a different table (either same or different database doesn't matter). The first service runs like a charm but the second one won't complete the open...I assume because the PC already has a connection open... Is there a way to do this?

John Wiese · Answer

At a high level I don't know that I'd recommend and architecture like you are describing. The question to ask is why does your service need to continually read from the table? and then what other ways could we accomplish this goal?. That said you should be able to do what you are trying to do. You should be able to get multiple connections into the SQL Server from your service server. How did you create the code for the second service? Is it a copy of the project with changes made? Did you start from scratch? What error message are you getting back?