Groups | Blog | Home
all groups > sql server new users > december 2004 >

sql server new users : More on SQL Server Developer Edition


Kevin
12/6/2004 9:11:04 AM
I just purchased SQL Server 2000 Developer Edition and want to use it to
connect via TCP/IP to a SQL Server database located on a web host server.
The application has the Client Network Utility and allows me to go about
connecting, but I get a timeout error when I try to register to the remote
database using the Enterprise Manager part of my SQL Server DE. My web
hosting company so far has not been able to fix this. I am wondering if the
problem is at their end or if the Developer Edition just isn't permitted to
make this registration and the error is its way of telling me. I have read
the license several times and scoured the documentation but don't see where
Kevin
12/6/2004 10:07:03 AM
Thanks
This is the way I think I think it should work too. I just want to make
sure I'm not wasting the host company's time trying to figure it out.

[quoted text, click to view]
Stephen Dybing [MSFT]
12/6/2004 10:26:30 AM
It should be permitted to connect but it may not be legal if you're
attempting to use the Enterprise Manager from your Developer Edition to
"manage" your database on the web host server. The Developer Editions is
only licensed for designing, developing, and testing. Here's the FAQ from
the SQL Server 2000 Licensing FAQ at
http://www.microsoft.com/sql/howtobuy/faq.asp:

Q. What is SQL Server 2000 Developer Edition and how is it licensed?
A. SQL Server 2000 Developer Edition is licensed per developer and must be
used for designing, developing, and testing purposes only.

I would double-check the connection string that your application is using to
make sure it's the same one you're attempting to use with Enterprise
Manager.

--
Sincerely,
Stephen Dybing

This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
[quoted text, click to view]

Kevin
12/6/2004 12:21:03 PM
Thanks for all the input. Not to beat a dead horse but here's my confusion...

Assuming I can get this to connect, my reading of the license would be that
you can't use the database provided with the developer edition to be used as
a production database - which in my case would be to have my web site driven
directly from this database on my server. I don't plan to do that, but
instead need to connect to the fully licensed web server production database.
It seems that it would be OK for me to create a database locally and then
upload it the the web server, but the question is can I then use the
Developer Edition to make changes to this database as it sits on this web
server? The ambiguity here is what led to my original question - if this
edition does indeed allow you to connect to a remote database then my
assumption is that doing so would be legal under the license, but if it is
not allowed then my guess is that the timeout error is the application's
somewhat crude way of letting me know that.

[quoted text, click to view]
Stephen Dybing [MSFT]
12/6/2004 12:31:41 PM
You really need to be talking to your lawyer and/or your local Microsoft
office. I'm not a lawyer so I cannot give legal advice. What I can do is
point you at the website and the question that probably applies to your
case, which I did. :-) We didn't cripple SQL Enterprise Manager so that it
matched the particular SQL Server edition that it shipped with so don't
assume that just because you can connect to a remote SQL Server that it's
legal for you to do so.
--
Sincerely,
Stephen Dybing

This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
[quoted text, click to view]

Kevin
12/6/2004 1:05:02 PM
Thanks again. The issue remains moot since I still can't connect...

[quoted text, click to view]
Stephen Dybing [MSFT]
12/6/2004 1:40:16 PM
I'm not comfortable getting that customer specific. I'm not a lawyer and
that answer really can only come from one. As such, Kevin, I'd be really
careful about taking advice from a newsgroup on legal issues like this. You
really need to talk to your lawyer, or at least start with someone from your
local Microsoft Sales office. :-(

--
Sincerely,
Stephen Dybing

This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
[quoted text, click to view]

Stephen Dybing [MSFT]
12/6/2004 2:24:13 PM
Right, sorry, I agree with that. Testing really goes along with development,
or at least it had better. :-) My concern is that wasn't what the intentions
were.

--
Sincerely,
Stephen Dybing

This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
[quoted text, click to view]

Fredrik Wahlgren
12/6/2004 6:51:25 PM

[quoted text, click to view]

I can't see why SQL Server shouldn't be allowed to make this kind of
connection. You have to do this in order to get data from a real database so
that you can experiment with it. The EULA doesn't say that you can't
connect to other computers.
The error is either on their side or you have a bad connection. If you can,
try to connect to some opther instance to make sure you do everything right.

/ Fredrik

Fredrik Wahlgren
12/6/2004 7:33:56 PM

[quoted text, click to view]

I'm with you on this one. The UELA clearly states what the Dev Ed should be
used for.

/ Fredrik

Fredrik Wahlgren
12/6/2004 9:32:59 PM

[quoted text, click to view]

This is my understanding too.

[quoted text, click to view]

I think you can provided that you do so in order to test that it is
possible. Maybe you want to do so in order to acquire the necessary skills.
My understanding is that you would violate the EULA only if you already knew
how to do this or used the Dev Ed to manage commercial installations on a
regular basis.

[quoted text, click to view]

No. Can't be. The Developer Edition isn't crippled. The only difference is
the EULA. As long as you intentions fall under any of the three categories
mentioned, i.e. designing, developing, and testing, you don't violate the
EULA.

[quoted text, click to view]

Fredrik Wahlgren
12/6/2004 10:09:05 PM
I want to add a few thoughts to my previous reply. As mentioned, my
understanding is that if you connect to a remote server with either one of
these intentions:

1) You need to copy a database in order to test your ADO.NET skills

or

2) Connect to a database to see how it's doneMaybe you want to document each
step

you should be OK. If your intentions are beyond this, I think you need to
set up a separate database that is completely decoupled from your production
database. You may use a copy of your real database. This database must be
set up in such a way that it is a test database. In addition, it should be
on a different server so that your testing can't possibly interfere with
your production database.

Stephen, do you agree?

/ Fredrik


[quoted text, click to view]

Fredrik Wahlgren
12/6/2004 11:09:09 PM
It seems as we have come to road's end. I guess you have to follow Stephen's
advice. I still feel that if you connect to a test database with test data
and the sole intention of testing remote management, you should be OK.

/ Fredrik


[quoted text, click to view]

Fredrik Wahlgren
12/6/2004 11:29:41 PM
Thank you, Stephen.

/ Fredrik

[quoted text, click to view]

Sue Hoegemeier
12/8/2004 11:13:23 AM
In regards to the question of timeouts when you try to
register a remote server, this can sometimes happen with a
login timeout. To increase the login timeout - In Enterprise
Manager, go to the menu to Tools and select Options. On the
advanced tab, increase the login timeout to something
greater than the default 4 seconds.

-Sue

On Mon, 6 Dec 2004 09:11:04 -0800, "Kevin"
[quoted text, click to view]
AddThis Social Bookmark Button