That did not seem to work. I was not able to connect to the sql server using the hostname. I am also using SQL Membership Provider. If I use Provider=SQLOLEDB.1 or Provider=SQLOLEDB in the connection string then I get the following error “Keyword not supported: 'provider' “ when calling Roles.GetAllRoles(). If I remove the Provider from the connection string, the membership and role provider works but then I get the following error when trying to connect through the DAL: “An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.”
This same code works on the development server (not my local) pointing to a Sql Server on a different box. So it seems like it has something to do with my instance of sql server.