How to determine SQL Server Instance name remotely -



How to determine SQL Server Instance name remotely -

if know sql express installed on given computer. have sa password database. not know instance name.

(so connection string "data source=[ip address]\????;user id=sa;password=[password]")

without logging box, how can determine instance name?

if have sql server tools installed locally,

osql -l

will output list of available sql servers (including instance names) in current network.

sql sql-server

Comments

Popular posts from this blog

Delphi change the assembly code of a running process -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

C++ 11 "class" keyword -