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

javascript - THREE.js reposition vertices for RingGeometry -

javascript - I need to update the text of a paragraph by inline edit -

assembly - What is the addressing mode for ld, add, and rjmp instructions? -