Answering my own question, but
Called M$ support and this is the solution
Log into the SQL server, go to Enterprise Manger,
Find the database associated ‘Databasename’ > Right click on it > Click on Properties
Once Properties is open click on the Options Tab
From the Options tab, Uncheck the Restrict Access, click apply and click Ok.