SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

2
kudos

Kudos

SQL Server discovery: How to find edition of SQL Server without connecting to that instance?

published 500 days, 7 hours, 59 minutes ago posted by

sa 509 days, 9 hours, 43 minutes ago

SQL Server discovery: How to find edition of SQL Server without connecting to that instance?

This is an interesting question in the recent times that I have seen in the forums, that how to find such information even without connecting to that SQL instance. There are plenty of ways to get information about SQL instance name using OSQL -L or find about odbc32.dll to get list of SQL names if they are registered. Also the local instance is resolved by registry entry and remote instances are resolved by UDP broadcast (port 1434), using sqlbrowser -c can help some extent to obtain the information....(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: discovery report, installallation, instance, port, Security, SQL Server, SSMS, Tools

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL Server discovery: How to find edition of SQL Server without connecting to that instance?

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up