Administration Question

[Ray1127]

If I have SQL Server set up to use Windows Authentication. I am the Network Administrator. I only have public access to SQL Server 2005? How do I get into SQL Server 2005 to do the Admin tasks? SQL Server was not set up for mixed mode according to the documentation left by the previous admin and if the SQL Server user sa is not disabled then the password left with the previous Admin. Any ideas on what I can do???

 

[JayKusch]

You would have to have some account that was granted SysAdmin privs in order to get in there and accomplish the needed tasks.

If sa is disabled and/or you do not have the password and there are no logins (NT or SQL) that have admin rigths to the server ... you may need to reinstall.

Maybe someone has a workaround that could be leveraged before having to go down the rebuild path.

Thanks

J. Kusch

 

[Ray1127]

Thanks that's what I thought I'd have to do. Not crazy about it. It means I'll be working this weekend as that's the only time I can take the system down long enough to do a full re-install but oh well. That's why they pay me my dollar.

 

[JayKusch]

LOL ... Been there ... Done that ... for the same reason.

Thanks

J. Kusch