Greetings all,

I'm working on a custom DNN module in C# that will communicate with a server running Sql Server 2005.  I cannot get it to connect to the server, however.  Essentially what happens is I create the connection (object type SqlConnection), run SqlConnection.Open on the object, and that's pretty much it.  When I check the connection state, it says it's closed.  When I run the exact same code (with the same Sql connection string) in a standalone application, it has no problem connecting to Sql Server.

I am running the most recent version of DotNetNuke.  The computer I'm using is running Windows Vista.  I should point out that Sql Server is on a different machine.

Also,  I would recommend you include parts of the code with the post.  Depending on what your code looks like, it may be the way your code is working.  I work with both standalone pages and modules, using the same pattern for connecting to a database, and have never ran into any problems so it leads me to think it is a mistake in the code itself not the database connection. 

The problem with the connection string, I think, is Trusted_Connection=yes;.  I tried this in my own connection string and it failed to connect.  I think it should be Trusted_Connection=true;.  I am not 100% sure on this but fairly sure.  Everything else looks okay with the connection string.