SQL Server : No access and no SA password you say ?

If you have SQL installed and you have not been given access to the SQL instance so when you connect tot SQL you get the error:

"Access deined" or "You have no permissions"

If you SQL DBA is not around, try this hack, which should not work but does....

PsExec.exe -s -i "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

This assumes you have the management console installed, weirdly this works as it runs the "Enterprise Studio" and the system account and by default the SYSTEM account has access to SQL.

If you have "prevented" the system account from accessing SQL and you use a service account, then run the Enterprise Studio as that service account.

They you can grant yourself access and get back in.
Previous Post Next Post

Ω†Ω…ΩˆΨ°Ψ¬ Ψ§Ω„Ψ§ΨͺΨ΅Ψ§Ω„