Check license mode sql server 2005

We want to make sure we are currently licensed properly on our SQL servers. I have tested this on 2 known SQL Server installs that we have that are either processor or seat. Thank you in advance. Join our community to see this answer! Unlock 1 Answer and 7 Comments.

Andrew Hancock - VMware vExpert. See if this solution works for you by signing up for a 7 day free trial. What do I get with a subscription? With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. If there are limited client and multiple users to connect to SQL Server this is a cost effective option. If SQL Server is used by limited numbers of Users who are working on an Intranet or behind a firewall this is a good option to pursue.

If users have multiple clients to connect to SQL Server this is a cost effective option. He holds a Masters of Science degree and numerous database certifications. Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. Improve this answer. OMG - ah nice. Goes all the way back to 6. Does anyone still use that?!

Any ideas? Looks like this is the new normal Jacob H 2, 1 1 gold badge 10 10 silver badges 29 29 bronze badges. Josean Josean 1 1 silver badge 3 3 bronze badges. Pretty solid update to an old, out of date question with a good amount of activity. I updated it to add your code from the link you posted. For SQL Server , I had to search for 'copyright' instead of 'licensing' to get one of the two rows in the screenshot.

I'm also getting the same kind of results on my SQL Server for the licensing query. Still looking for another why to find what is the licensing of my server : — Matthieu Ducorps. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.