Re: sql server express on same workstation as ssl 2005



Wendy,

I am not well versed on licensing Microsoft products. (That is a very
special body of knowledge, I believe.)

However, you mention that you have Visual Studio 2005 Professional Edition.
Looking through the specs at
http://msdn2.microsoft.com/en-us/vstudio/aa700921.aspx reveals that your
Professional Edition license also includes a copy of SQL Server 2005
Developer Edition. This has all (or almost all?) of the features of
Enterprise Edition, but is only licensed for development.

Therefore, since you have a Developer Edition license, use that instead of
SQL Server Express.

RLF

"Wendy Elizabeth" <WendyElizabeth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:61183626-EB4E-48B2-90D1-E19C01654F85@xxxxxxxxxxxxxxxx
RLF:

Thank you very much for your answer! Is this the only way that I can
setup
a test sql server on my workstation and be in compliance with licensing
laws?
if you are not certain about the licensing rules for Visual Studio.net
2005 professional version, can you tell me who I should contact to ask
this
question to?

Thanks!

"Russell Fields" wrote:

Wendy,

You already have SQL Server 2005 Management Studio and other tools
installed. These tools can also manage the local SQL Express
installation
that you would like to install.

To avoid any problems, when you install SQL 2005 Express Edition you
should
choose not to install
the Express Management tools. You should be able to manage this through
the
install tool. (If you install the Express Management Tools, they will
conflict with the full tools that you have now.)

RLF
"Wendy Elizabeth" <WendyElizabeth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:7C39BDEC-2F03-4B61-9C30-FE1CBF5F1B49@xxxxxxxxxxxxxxxx
I wanted to know if the following setup would work and/or if you have
any
other suggestions:
(**Note: I am asking this question since I am currently the only .net
programmer at my new company. I have the professional version of visual
studio.net 2005 and sql server 2005 managment studio installed on my
workstation. What I am trying to do is find a way to use a 'test' sql
version
for 'development testing' only. The only place that is available to put
a
test sql server is on my workstation. My job says they only have a
license
for two sql server 2000 in the production environment and no
'test/developemtn' license is available that they are aware of unless
it
is
part of visual studion.net 2005.)
Thus can I install both sql server express 2005 and sql server 2005
managment studio on my workstation and each one of them would run. They
would
not interfer with the function they were setup for?

Thanks!





.



Relevant Pages

  • RE: Installed VS 2005 want to Manage SQL 2005 Server
    ... Studio 2005 Development machine but received an "Edition Version Conflict" ... Based on my experience and test, I am able to install the SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Setup problem with SQL Server BI Studio
    ... to get VS Studio 2005 installed in order to have the tool SQL Server ... Business Development Studio. ... You should be able to install "everything" on one machine. ...
    (microsoft.public.sqlserver.setup)
  • Re: replacing SQL Server 2005 Mgmt Studio Express
    ... Yep, uninstall SSMSE and then start SQL Server 2005 setup from your media and from the Components to Install window, click Advanced... ... A client has SQL Server 2005 Standard Edition. ... SQL Server 2005 Management Studio is the express edition studio. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL server 2005 license question
    ... If there is only one Physical CPU then it's enough buying only one Processor License for your SQL Server. ... you don't need to install the License. ...
    (microsoft.public.sqlserver.setup)
  • Re: How can I get the Management Studio
    ... a SQL Server server; however, a SQL Server Tool is going to be used on it. ... According to this Q & A, I'll need another SQL Server license because I'll be using a SQL Server Tool on it? ... "any device that has SQL Server tools or technologies installed must have a valid license" ... It would basically mean we can buy one per processor SQL Server and install SSMS on all the machines in the world? ...
    (microsoft.public.sqlserver.tools)