Client tool edition

Question

Client tool edition

Sherri

SSC Enthusiast

Points: 138
More actions
November 15, 2005 at 10:02 am

#364168

Currently, I have SQL Server client tools on my computer which I use to access servers that have licensed SQL Standard edition. I was told by the IT department to uninstall SQL Server on my local machine and install Developer edition since this is the product I have a license for.

I have a couple of questions about this.
1) Do I need a developer edition for each computer to use client tools to access the SQL servers with standard edition?
2) After the reinstall, is there a way of checking the tools for edition information? I know how to check the server but I don't know if I need a version of the tools.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

1) Do I need a developer edition for each computer to use client tools to access the SQL servers with standard edition?

No, Client tools do not require a license. and they can be used to connect to any sql server instance. Sql server developer, or Standard is the actual server instance. So if IT has you install Developer edition on your machine, then you will actually have sql server installed. If they just have the tools then you will not have sql server installed, and you Must connect to another machine with sql installed using the client tools. (Enterprise manager, or Query analyzer)

2) After the reinstall, is there a way of checking the tools for edition information? I know how to check the server but I don't know if I need a version of the tools.

Once again client tools are not "Edition" or license specific, they are Enterprise Manager, and Query analyzer, (Among other code samples templates and exe's) To check the server license of the server you are connected too open query analyzer and connect to the server, and type

Select @@Version

Mine shows

Information about Version

http://www.sqlteam.com/item.asp?ItemID=8318

Lowell SSC Guru Points: 323482 More actions · Answer 2

Isn't it true that whatever version of SQL 2K you have the disk for, if you are running a non-server version operating system, it installed as the developer version anyway?

so unless you are running Win2k server version, or Win2003, you are running the developer version?

on my machine, with the same disk:

select @@version

on the production server, with the same disk:

select @@version

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!