How to check if user 'sa' (SQL Server) is enable with vb.net -


i know if possible check if user 'sa' enable (sql server 2005), vb.net.

i tried find query select * syslogins, here can´t find it.

thanks advanced

please take screenshot sa disable , hasaccess = 1 update 1

sa enable , hasaccess = 1

update 2

select * syslogins have "sa" in results.

are sure "sql authentication" enabled sql-server(instance)?

https://msdn.microsoft.com/en-us/library/ms188670%28v=sql.90%29.aspx

if windows authentication mode selected during installation, sa login disabled. if later change authentication mode sql server , windows authentication mode, sa login remains disabled. enable sa login, use alter login statement.


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

c++ - Can not find the "fiostream.h" file -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -