Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Licensing SQL Sever Management Studio. Expand / Collapse
Author
Message
Posted Monday, January 19, 2009 5:01 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 9, 2011 7:24 AM
Points: 87, Visits: 392
Here is the scenario.

We have a team of users who currently use SQL Server Mangement Studio to connect to our hosting centre to run reports on various SQL databases. We have appropriate licencing at the hosting centre to allow this.

The same users now need access to some SQL servers at different locations (MSDE 2000 licenced). Can they use the Management Studio they currently use to connect to those databases as they are or is additional licencing required (ie CALs to the 2000 servers) ?
Post #639197
Posted Monday, January 19, 2009 6:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:07 AM
Points: 11,157, Visits: 12,899
Since it is MSDE I don't believe you need any CAL's to connect to the SQL Server.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #639291
Posted Monday, January 19, 2009 6:58 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 9, 2011 7:24 AM
Points: 87, Visits: 392
Wouldn't connecting via Management Studio give you more functionality though ?

What if you were connecting to a SQL 2000 server - with a standard licence ?

Thats for the info.
Post #639294
Posted Monday, January 19, 2009 7:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:07 AM
Points: 11,157, Visits: 12,899
What do you mean by more functionality? The DBEngine isn't going to do more because you are using the full-blown management tools. If that happened, then there would have to be a version of Management Studio for each version of SQL Server (Workgroup, Standard, Enterprise) as there is different functionality available in each version.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #639311
Posted Tuesday, January 20, 2009 3:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:39 AM
Points: 1,026, Visits: 1,097
I think, as long as the Client Workstation is licensed for SSMS, and the Server is licensed for the database engine, you are covered.

Although bear in mind that remote connections to MSDBs aren't generally enabled.

Andy
Post #639747
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse