Unable to Access SQL Server 2008 R2 Database via management studio
I am unable to access a database via the management studio.
I have tried logging in using windows authentication and SQL authentication.
I believe the default SQL user name is SA and a blank password.
The problem we have is that this was set up by a 3rd party who we are now officially in dispute with and they simply aren't talking to us at the moment. We usually set up our SQL databases to use windows authentication but my gut feeling is that they have used sql authentication and a non standard password.
Is there any way we can access this or at least confirm the level of authentication used?
Any assistance with this would be greatly received!