Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vkc12uec
Starting Member
5 Posts |
 Posted - 2009-03-26 : 07:37:03
|
| Hi allI made a database instance on MSSQL 2005, name SQL_TEST1. The Log On permissions are given to windows account user = sql1 ( password = sql2)This instance is made under mixed mode authentication. i.e user sa can also access this db by sa/getinIs there any method ( using osql queries by which the Administrator/ NT Authority system user can access SQL_TEST1 ?One method which I can think of is using the query"C:\Program Files\Microsoft SQL Server\90\Tools\binn\osql.exe" -U sa -P getin -S ccsesx1win64\SQL_TEST1 -u -i 1.sql -o 2.sql -I -n -w 2048where the query file 1.sql contains:select * from master.dbo.sysdatabasesThe result will be produced in 2.sqlIs there any other method by which Adminuser can use query like "C:\Program Files\Microsoft SQL Server\90\Tools\binn\osql.exe" -S ccsesx1win64\SQL_TEST1 -u -i 1.sql -o 2.sql -I -n -w 2048 -E? |
|
|
vkc12uec
Starting Member
5 Posts |
Posted - 2009-03-26 : 07:47:15
|
| NT AUTHORITY\SYSTEM does not have proper login permissions. I have removed the nt authority\system from the status role of sysadmin.Now, does there exists a query or any way such that the Administrator can impersonate like the User-sql1 ? |
 |
|
|
|
|
|
How to permit Nt Authority\system