I installed a second copy of MS SQL 2008 on a server to provide failover access to a database but I am having issues connecting to it. The original database is connected from clients via ODBC without issue. I can't recreate this on this second server. It must be permissions or share based issue but I can't figure it . The program I am using to connect to the database is Xytech. Xytech speaks to SQL server via ODBC connection. I set up the second backup via subscription so the data replicates to the second server as long as change the server pointer in ODBC it should connect but this second SQL database will not share. Not sure what else to do at this point or what's different.