Access/MSDE/SQL internet licenese?

I know that SQL Server cost plenty to license for internet use...per year. But is there the same costs for MSDE and/or Access? I was recently told that every internet user would have to have a license to use a site that had Access as the database. I'm really not sure how true that is or if its MS support fobbing me off. Anyone know?MSDE doesn't have that $5k/cpu license that sql server has. However, as a developer, you have to sign off a redistro rights thing.

http://www.microsoft.com/sql/msde/howtobuy/redistregister.asp

you were getting dragged by the nose ring by the level one support bastards.|||But isn't that just the equivalent of buying the product? What I'm unsure of is the client license side of things. So I can freely distribute MSDE but how many users can access that DB freely? Esp. from the internet...it's a mine field!|||http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp

READ! I told you already, there's no price on MSDE, but there's a price on SQL Server.|||IT DOESNT SAY! I'm obviously going blind. Show me where it says that I don't have to buy a license, even for 25 users, when it's the persistant store to a web application. Sure it says you can, but doesn't state that it's at no extra cost. For example, if you look at the SQL license stuff it says $xxx per license but you have to dig around to discover that's not true for a internet facing SQL Server. That's $xxxxxxxxxxxx!

ACCESS VIOLATION ERROR

I have been experiencing a fatal error for one of the SQL
Server services on our development server. Upon
investigating on the internet it would appear that we are
not alone in this. The only fix at present appears to be
a server reboot. The error looks something like:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 56 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process.
Until the server was rebooted, some SQL statements (from
any application) worked and others did not. Very
disturbing when using frames within IE, and the queries
running in the upper frame function correctly and the
queries running in the lower frame bomb out (with an error
message akin to 17066 :SQL Server Assertion: File:
< S:\sql\ntdbms\storeng\drs\include\record
.inl>, line=1447
Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <=
MAXDATAROW'.).
Does anybody know the cause of this error message?
ThanksHi Alex.
That seems to be a SQL Server bug. Do make sure that your development server
is fully up to date with service packs as these types of bugs are regularly
picked up & fixed in service packs.
It might help if you posted what SQL is actually being executed when the AV
occurs. If you could send the query & underlying tables someone might be
able to provide you with an equivalent / alternative query which might be an
easy work-around for your immediate problem. There's really not enough
information in your current post to go off though.
Regards,
Greg Linwood
SQL Server MVP
"Alex" <anonymous@.discussions.microsoft.com> wrote in message
news:14e6201c41571$acde15e0$a501280a@.phx
.gbl...
> I have been experiencing a fatal error for one of the SQL
> Server services on our development server. Upon
> investigating on the internet it would appear that we are
> not alone in this. The only fix at present appears to be
> a server reboot. The error looks something like:
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 56 generated fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
> is terminating this process.
> Until the server was rebooted, some SQL statements (from
> any application) worked and others did not. Very
> disturbing when using frames within IE, and the queries
> running in the upper frame function correctly and the
> queries running in the lower frame bomb out (with an error
> message akin to 17066 :SQL Server Assertion: File:
> < S:\sql\ntdbms\storeng\drs\include\record
.inl>, line=1447
> Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <=
> MAXDATAROW'.).
> Does anybody know the cause of this error message?
> Thanks
>

Access via internet?

Can someone point me to, if its possible, a means of allowing access to an
MSDE database over the internet?
I suspect it will involve a static IP address at the host, opening a port in
the firewall, and use of NAT?
a static IP address at the host (thats when the SQL Server is reachable over
the internet in the DMZ) OR opening a port in the firewall, and use of NAT?
Thats when an option when your SQL Server is located in your LAN and
tunneled through NAT (and perhaps port translation). The sense of that would
be to use the Server for your internet application. But therefore the last
option would be preferable whereas a firewall would only allow the Web
Server (which could possibe host your application) to request data.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"mikeb" <mike@.nohostanywhere.com> schrieb im Newsbeitrag
news:eHI$yPmZFHA.1868@.TK2MSFTNGP14.phx.gbl...
> Can someone point me to, if its possible, a means of allowing access to an
> MSDE database over the internet?
> I suspect it will involve a static IP address at the host, opening a port
> in the firewall, and use of NAT?
>
|||I'm not sure I follow.
I have a PC app (actually a mobile PC app using Windows Mobile) that needs
to access a database in another factory. I was thinking of opening the
database to access via the internet (securely as possible) so that the app
could access this remote database.
I'm finding quite a few messages about people doing it, but I've still not
found how.
?
thx.
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:%23c4KRnmZFHA.1412@.TK2MSFTNGP12.phx.gbl...
>a static IP address at the host (thats when the SQL Server is reachable
>over the internet in the DMZ) OR opening a port in the firewall, and use of
>NAT? Thats when an option when your SQL Server is located in your LAN and
>tunneled through NAT (and perhaps port translation). The sense of that
>would be to use the Server for your internet application. But therefore the
>last option would be preferable whereas a firewall would only allow the Web
>Server (which could possibe host your application) to request data.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "mikeb" <mike@.nohostanywhere.com> schrieb im Newsbeitrag
> news:eHI$yPmZFHA.1868@.TK2MSFTNGP14.phx.gbl...
>
|||I would use something more reliable than just opening a port in the
firewall, something like a VPN, that more secure than doing just a NATing.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"mikeb" <mike@.nohostanywhere.com> schrieb im Newsbeitrag
news:e0HWDXrZFHA.464@.TK2MSFTNGP15.phx.gbl...
> I'm not sure I follow.
> I have a PC app (actually a mobile PC app using Windows Mobile) that needs
> to access a database in another factory. I was thinking of opening the
> database to access via the internet (securely as possible) so that the app
> could access this remote database.
> I'm finding quite a few messages about people doing it, but I've still not
> found how.
> ?
> thx.
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in message news:%23c4KRnmZFHA.1412@.TK2MSFTNGP12.phx.gbl...
>
|||Thanks Jens,
Before I go down that route - I'm just curious - how unsecure is opening a
port to allow this type of access? The factory that I'm setting this up for
is small, and I'm not sure that they will afford a Windows Server to setup
VPN. I'm going to check it out with them, but I dont' think that will work.
If so, and opening a port isn't viable, we may have to resort to the old
fassioned way of using modems.
I'm very willing to continue my research - please feel free to point me
elsewhere as it sounds like maybe this topic is becoming out of scope for
this group. ?
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:uNyRnbrZFHA.3568@.TK2MSFTNGP10.phx.gbl...
>I would use something more reliable than just opening a port in the
>firewall, something like a VPN, that more secure than doing just a NATing.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "mikeb" <mike@.nohostanywhere.com> schrieb im Newsbeitrag
> news:e0HWDXrZFHA.464@.TK2MSFTNGP15.phx.gbl...
>
|||hi,
mikeb wrote:
> Thanks Jens,
> Before I go down that route - I'm just curious - how unsecure is
> opening a port to allow this type of access? The factory that I'm
> setting this up for is small, and I'm not sure that they will afford
> a Windows Server to setup VPN. I'm going to check it out with them,
> but I dont' think that will work. If so, and opening a port isn't
> viable, we may have to resort to the old fassioned way of using
> modems.
> I'm very willing to continue my research - please feel free to point
> me elsewhere as it sounds like maybe this topic is becoming out of
> scope for this group. ?
>
personally I'd never directly expose the database server on the Internet
that way... you are claiming for troubles :D
Jens already exposed the "classical" ways to protect you data, and doing
your way you are bypassing them all..
hope your customers will want to pay for their own security..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||My way? ack. No, really, I'm ignorant to this - I was just throwing out
my initial ideas.
So VPN is the best way to go then? Now I need to go find out some more info
on VPN.
Always open to further suggestion. or things to watch for.
I am curious, what are some of the fallbacks to using VPN for
SQLserver(msde) access? will the factory lose any other features of their
network use? I'll go check out a server or vpn group now too.
Thanks,
-m
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3g64bsFabhp0U1@.individual.net...
> hi,
> mikeb wrote:
> personally I'd never directly expose the database server on the Internet
> that way... you are claiming for troubles :D
> Jens already exposed the "classical" ways to protect you data, and doing
> your way you are bypassing them all..
> hope your customers will want to pay for their own security..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||VPN is one of the prefered ways to do this, because you dont need to open
any ports in your firewall and can grant full access to your network
(depends on how you setup the VPN). Its the securest thing with the most
variety (for me), because there are many features you can implement, like
smartcard authentication etc.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"mikeb" <mike@.nohostanywhere.com> schrieb im Newsbeitrag
news:Oc39DfsZFHA.3340@.TK2MSFTNGP10.phx.gbl...
> My way? ack. No, really, I'm ignorant to this - I was just throwing out
> my initial ideas.
> So VPN is the best way to go then? Now I need to go find out some more
> info on VPN.
> Always open to further suggestion. or things to watch for.
> I am curious, what are some of the fallbacks to using VPN for
> SQLserver(msde) access? will the factory lose any other features of their
> network use? I'll go check out a server or vpn group now too.
> Thanks,
> -m
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3g64bsFabhp0U1@.individual.net...
>
|||Personally I would NEVER expose to the Internet, a SQL Server/MSDE that I
wanted to keep secure. Don't do it, simple as that. There are better ways
to do this kind of thing - Remote Desktop over a VPN is one of them.
However, I recognise that people like breaking the rules so here's how you
do it:
1. Set your SQL Server/MSDE to use Mixed Mode Authentication (see
http://support.microsoft.com/default...;EN-US;Q325022 for details)
2. Open port 1433 on your firewall and tell your router's NAT to forward all
requests on port 1433 from the Internet to your SQL Server.
3. Sit around for a few hours while somebody brute force attacks your server
and destroys all your valuable corporate data
4. Er...that's it
I really cannot emphasis how dumb this is - IMHO the only reason that
Microsoft stuff gets hacked so often is not that it is fundamentally
insecure, it is that people do insecure things with it. Any of the recent
Microsoft Server products properly configured are as tough as the
competition.
The most secure way to expose data over the Intenet is through XML Web
Services. The great thing is that you can use the same technique to
securely manage your data internally too - definitely worth looking into.
hth
~Ben
"mikeb" <mike@.nohostanywhere.com> wrote in message
news:Oc39DfsZFHA.3340@.TK2MSFTNGP10.phx.gbl...
> My way? ack. No, really, I'm ignorant to this - I was just throwing out
> my initial ideas.
> So VPN is the best way to go then? Now I need to go find out some more
> info on VPN.
> Always open to further suggestion. or things to watch for.
> I am curious, what are some of the fallbacks to using VPN for
> SQLserver(msde) access? will the factory lose any other features of their
> network use? I'll go check out a server or vpn group now too.
> Thanks,
> -m
>

Access to SQL Server 2000 remotely

I have installed SQL Server at my home computer. I can access from another
computer over internet. But from my company, I can't.
I talk to IT administrator, but he doesn't understand a lot abou this issue.
Any help?
What th IT should do to I have access?
Thanks,
JoseYou will need to allow the appropiate ports on your firewall. SQL
Server uses by default 1433 (which you might have changed during
install or configuration) unless you don=B4t allow this port on the
firewall you won=B4t be able to access the Server.
Most companies do not open these ports and do not even consider doing
it (which is recommended)
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--|||IT probably has the port blocked on the firewall, as they should. Let them
know the port your SQL Server is using (viewable in the SQL Server Errorlog
if you are not sure)
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jos" <Jos@.discussions.microsoft.com> wrote in message
news:2830F020-B38D-45A1-A490-5BF48A26269A@.microsoft.com...
>I have installed SQL Server at my home computer. I can access from another
> computer over internet. But from my company, I can't.
> I talk to IT administrator, but he doesn't understand a lot abou this
> issue.
> Any help?
> What th IT should do to I have access?
> Thanks,
> Jose
>|||I'm just testing...
My SQL Server is configured to port 1433, is it possible to configure to
another port? For example port 80 only to tensting
Thanks
"Jens" wrote:

> You will need to allow the appropiate ports on your firewall. SQL
> Server uses by default 1433 (which you might have changed during
> install or configuration) unless you don′t allow this port on the
> firewall you won′t be able to access the Server.
> Most companies do not open these ports and do not even consider doing
> it (which is recommended)
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||How can i see the ports available?
Thanks
"Kevin3NF" wrote:

> IT probably has the port blocked on the firewall, as they should. Let the
m
> know the port your SQL Server is using (viewable in the SQL Server Errorlo
g
> if you are not sure)
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "José" <Jos@.discussions.microsoft.com> wrote in message
> news:2830F020-B38D-45A1-A490-5BF48A26269A@.microsoft.com...
>
>|||Most likely through the firewall configuration utility...I'm not a network
guy, so I can't really assist you much there
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:2980F9B4-FA99-4D1F-925A-42C95F039AE4@.microsoft.com...[vbcol=seagreen]
> How can i see the ports available?
> Thanks
> "Kevin3NF" wrote:
>|||You can use a microsoft telnet tool to find out whether you can telnet into
the destination server on a particular port. On the destination server side,
do a netstats to find out the list of portnumbers that are already being
used.
By default, 1433 is the port no that sql server listens on. You can change
it using server network utility. However
when the client tries to connect, make sure that the client network uility
is also configured with the port number changes.
thks,
Mani
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:2980F9B4-FA99-4D1F-925A-42C95F039AE4@.microsoft.com...[vbcol=seagreen]
> How can i see the ports available?
> Thanks
> "Kevin3NF" wrote:
>|||Where Can I find microsoft telnet tool? I tried to find microsoft downloads
but I didn't find.
Could you help me?
Thanks
"Manikanth" wrote:

> You can use a microsoft telnet tool to find out whether you can telnet int
o
> the destination server on a particular port. On the destination server sid
e,
> do a netstats to find out the list of portnumbers that are already being
> used.
> By default, 1433 is the port no that sql server listens on. You can change
> it using server network utility. However
> when the client tries to connect, make sure that the client network uility
> is also configured with the port number changes.
> thks,
> Mani
>
> "Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
> news:2980F9B4-FA99-4D1F-925A-42C95F039AE4@.microsoft.com...
>
>|||You can use the hyperterminal software to check if you can telnet into that
remote host server on tcp/ip 1433. YOu can find that hyperterminal under
accessories-->communication
thks,
Manikanth
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:95A1ADE8-C3EE-4878-A81C-3A8AE2075E64@.microsoft.com...[vbcol=seagreen]
> Where Can I find microsoft telnet tool? I tried to find microsoft
> downloads
> but I didn't find.
> Could you help me?
> Thanks
> "Manikanth" wrote:
>|||You can also try by Start -> Run -> cmd
and then write the comand
telnet <server_name> <port_number>
this will run telnet. If screen goes black and cursor will show you have
acces to the serwer.
Mariusz Koprowski
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:95A1ADE8-C3EE-4878-A81C-3A8AE2075E64@.microsoft.com...[vbcol=seagreen]
> Where Can I find microsoft telnet tool? I tried to find microsoft
> downloads
> but I didn't find.
> Could you help me?
> Thanks
> "Manikanth" wrote:
>

Access to SQL Server 2000 remotely

I have installed SQL Server at my home computer. I can access from another
computer over internet. But from my company, I can't.
I talk to IT administrator, but he doesn't understand a lot abou this issue.
Any help?
What th IT should do to I have access?
Thanks,
Jose
You will need to allow the appropiate ports on your firewall. SQL
Server uses by default 1433 (which you might have changed during
install or configuration) unless you dont allow this port on the
firewall you wont be able to access the Server.
Most companies do not open these ports and do not even consider doing
it (which is recommended)
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||IT probably has the port blocked on the firewall, as they should. Let them
know the port your SQL Server is using (viewable in the SQL Server Errorlog
if you are not sure)
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jos" <Jos@.discussions.microsoft.com> wrote in message
news:2830F020-B38D-45A1-A490-5BF48A26269A@.microsoft.com...
>I have installed SQL Server at my home computer. I can access from another
> computer over internet. But from my company, I can't.
> I talk to IT administrator, but he doesn't understand a lot abou this
> issue.
> Any help?
> What th IT should do to I have access?
> Thanks,
> Jose
>
|||I'm just testing...
My SQL Server is configured to port 1433, is it possible to configure to
another port? For example port 80 only to tensting
Thanks
"Jens" wrote:

> You will need to allow the appropiate ports on your firewall. SQL
> Server uses by default 1433 (which you might have changed during
> install or configuration) unless you don′t allow this port on the
> firewall you won′t be able to access the Server.
> Most companies do not open these ports and do not even consider doing
> it (which is recommended)
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
|||How can i see the ports available?
Thanks
"Kevin3NF" wrote:

> IT probably has the port blocked on the firewall, as they should. Let them
> know the port your SQL Server is using (viewable in the SQL Server Errorlog
> if you are not sure)
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
> "José" <Jos@.discussions.microsoft.com> wrote in message
> news:2830F020-B38D-45A1-A490-5BF48A26269A@.microsoft.com...
>
>
|||Most likely through the firewall configuration utility...I'm not a network
guy, so I can't really assist you much there
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:2980F9B4-FA99-4D1F-925A-42C95F039AE4@.microsoft.com...[vbcol=seagreen]
> How can i see the ports available?
> Thanks
> "Kevin3NF" wrote:
|||You can use a microsoft telnet tool to find out whether you can telnet into
the destination server on a particular port. On the destination server side,
do a netstats to find out the list of portnumbers that are already being
used.
By default, 1433 is the port no that sql server listens on. You can change
it using server network utility. However
when the client tries to connect, make sure that the client network uility
is also configured with the port number changes.
thks,
Mani
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:2980F9B4-FA99-4D1F-925A-42C95F039AE4@.microsoft.com...[vbcol=seagreen]
> How can i see the ports available?
> Thanks
> "Kevin3NF" wrote:
|||Where Can I find microsoft telnet tool? I tried to find microsoft downloads
but I didn't find.
Could you help me?
Thanks
"Manikanth" wrote:

> You can use a microsoft telnet tool to find out whether you can telnet into
> the destination server on a particular port. On the destination server side,
> do a netstats to find out the list of portnumbers that are already being
> used.
> By default, 1433 is the port no that sql server listens on. You can change
> it using server network utility. However
> when the client tries to connect, make sure that the client network uility
> is also configured with the port number changes.
> thks,
> Mani
>
> "Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
> news:2980F9B4-FA99-4D1F-925A-42C95F039AE4@.microsoft.com...
>
>
|||You can use the hyperterminal software to check if you can telnet into that
remote host server on tcp/ip 1433. YOu can find that hyperterminal under
accessories-->communication
thks,
Manikanth
"Jose Perdigao" <JosePerdigao@.discussions.microsoft.com> wrote in message
news:95A1ADE8-C3EE-4878-A81C-3A8AE2075E64@.microsoft.com...[vbcol=seagreen]
> Where Can I find microsoft telnet tool? I tried to find microsoft
> downloads
> but I didn't find.
> Could you help me?
> Thanks
> "Manikanth" wrote: