We have a project when multiple people in the company will
want to look at Word documents, other text files, maybe
Excel spreadsheets.
Would it be best to put the location of the files in a
database and have our network mappings set up for anyone
in the company can see these files
or
Has anyone put the actual Word document in a SQL Server
(store the binary data in an Image data type) and then
tried using that to bring up the Word document? I think
storing the data from the file into an Image data type
should be fine, but I'm not sure how you'd get Word to
work with the data in the database and display the
contents.
The first option will work but there are some networking
issues. I'm just wondering if a database solution might
work and how you'd do that.
TIA,
Doughttp://www.aspfaq.com/show.asp?id=2149
"Doug" <anonymous@.discussions.microsoft.com> wrote in message
news:5a3e01c4009a$e6919280$a501280a@.phx.gbl...
> We have a project when multiple people in the company will
> want to look at Word documents, other text files, maybe
> Excel spreadsheets.
> Would it be best to put the location of the files in a
> database and have our network mappings set up for anyone
> in the company can see these files
> or
> Has anyone put the actual Word document in a SQL Server
> (store the binary data in an Image data type) and then
> tried using that to bring up the Word document? I think
> storing the data from the file into an Image data type
> should be fine, but I'm not sure how you'd get Word to
> work with the data in the database and display the
> contents.
> The first option will work but there are some networking
> issues. I'm just wondering if a database solution might
> work and how you'd do that.
> TIA,
> Dougsql
Showing posts with label company. Show all posts
Showing posts with label company. Show all posts
Friday, March 30, 2012
putting Word docs, etc in DB
We have a project when multiple people in the company will
want to look at Word documents, other text files, maybe
Excel spreadsheets.
Would it be best to put the location of the files in a
database and have our network mappings set up for anyone
in the company can see these files
or
Has anyone put the actual Word document in a SQL Server
(store the binary data in an Image data type) and then
tried using that to bring up the Word document? I think
storing the data from the file into an Image data type
should be fine, but I'm not sure how you'd get Word to
work with the data in the database and display the
contents.
The first option will work but there are some networking
issues. I'm just wondering if a database solution might
work and how you'd do that.
TIA,
Doughttp://www.aspfaq.com/show.asp?id=2149
"Doug" <anonymous@.discussions.microsoft.com> wrote in message
news:5a3e01c4009a$e6919280$a501280a@.phx.gbl...
> We have a project when multiple people in the company will
> want to look at Word documents, other text files, maybe
> Excel spreadsheets.
> Would it be best to put the location of the files in a
> database and have our network mappings set up for anyone
> in the company can see these files
> or
> Has anyone put the actual Word document in a SQL Server
> (store the binary data in an Image data type) and then
> tried using that to bring up the Word document? I think
> storing the data from the file into an Image data type
> should be fine, but I'm not sure how you'd get Word to
> work with the data in the database and display the
> contents.
> The first option will work but there are some networking
> issues. I'm just wondering if a database solution might
> work and how you'd do that.
> TIA,
> Doug
want to look at Word documents, other text files, maybe
Excel spreadsheets.
Would it be best to put the location of the files in a
database and have our network mappings set up for anyone
in the company can see these files
or
Has anyone put the actual Word document in a SQL Server
(store the binary data in an Image data type) and then
tried using that to bring up the Word document? I think
storing the data from the file into an Image data type
should be fine, but I'm not sure how you'd get Word to
work with the data in the database and display the
contents.
The first option will work but there are some networking
issues. I'm just wondering if a database solution might
work and how you'd do that.
TIA,
Doughttp://www.aspfaq.com/show.asp?id=2149
"Doug" <anonymous@.discussions.microsoft.com> wrote in message
news:5a3e01c4009a$e6919280$a501280a@.phx.gbl...
> We have a project when multiple people in the company will
> want to look at Word documents, other text files, maybe
> Excel spreadsheets.
> Would it be best to put the location of the files in a
> database and have our network mappings set up for anyone
> in the company can see these files
> or
> Has anyone put the actual Word document in a SQL Server
> (store the binary data in an Image data type) and then
> tried using that to bring up the Word document? I think
> storing the data from the file into an Image data type
> should be fine, but I'm not sure how you'd get Word to
> work with the data in the database and display the
> contents.
> The first option will work but there are some networking
> issues. I'm just wondering if a database solution might
> work and how you'd do that.
> TIA,
> Doug
Wednesday, March 21, 2012
Purchasing SQL
I've looked through a number of sites trying to find the difference between
the different "types" of SQL Server. We have a company that has
approximately 50 internal website users and approximately 2-3000 external
website users (no idea how many concurrent).
What type of SQL Server software will we need? My last company had SQL
2000 Enterprise, but they had a legitimate budget. This company is
searching on pricegrabber for Standard Edition 1 processor licenses and
trying to find the cheapest deal (you wouldn't believe this if you saw it).
Anyway, I'd like to provide some insight...as I know they're about to get
ripped off, but I figured I'd do some homework first. Any info would be
fantastic. Thanks.
James
"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
One of the biggest drawbacks of standard vs. enterprise is the 2 gig memory
limit on standard. Of course, there are other features/benefits of
enterprise, but that is a deciding factor for a lot of people.
-John Oakes
> James
>
|||"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
One of the biggest drawbacks of standard vs. enterprise is the 2 gig memory
limit on standard. Of course, there are other features/benefits of
enterprise, but that is a deciding factor for a lot of people.
-John Oakes
> James
>
|||How many SQL Server boxes are you going to have? You could have thousands
of websites pointing to one SQL Server if you wanted. Or you could have one
SQL Server box per web site.
You mention that "they're about to get ripped off." What does that mean?
Are "they" spending too much? Do "they" think that they need to purchase
one copy of SQL Server for every web server?
You are correct in searching for the Per Processor license, as this is what
you will need in order to use it to drive a web site (or sites).
The standard Edition of SQL Server is usually sufficient for most people.
Enterprise does have some additional high availability features (clustering)
and some other features that can improve performance (indexed views, greater
memory support), but those features come at a cost.
Only you can determine what features you require. These features will
determine what version of SQL Server to purchase.
Keith
"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
> James
>
|||Thanks for the reply. We'll only have one SQL Server box. When I said
they're about to get ripped off...I meant that they're searching for the
software on sketchy sites with rather large discounts. Microsoft is selling
the processor license for $5000 if I'm reading this anywhere near right, and
they're looking at copies that are barely over $1000. It just doesn't seem
"kosher" to me. The 2 Gig limit...that refers to the amount of memory the
box itself can have? I don't know that this would be a problem or not.
I'll have to look into that.
Thanks,
James
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OGZW8nSXEHA.1000@.TK2MSFTNGP12.phx.gbl...
> How many SQL Server boxes are you going to have? You could have thousands
> of websites pointing to one SQL Server if you wanted. Or you could have
one
> SQL Server box per web site.
> You mention that "they're about to get ripped off." What does that mean?
> Are "they" spending too much? Do "they" think that they need to purchase
> one copy of SQL Server for every web server?
> You are correct in searching for the Per Processor license, as this is
what
> you will need in order to use it to drive a web site (or sites).
> The standard Edition of SQL Server is usually sufficient for most people.
> Enterprise does have some additional high availability features
(clustering)
> and some other features that can improve performance (indexed views,
greater[vbcol=seagreen]
> memory support), but those features come at a cost.
> Only you can determine what features you require. These features will
> determine what version of SQL Server to purchase.
> --
> Keith
>
> "James Baker" <cppjames@.hotmail.com> wrote in message
> news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> between
external[vbcol=seagreen]
> it).
get
>
|||How many SQL Server boxes are you going to have? You could have thousands
of websites pointing to one SQL Server if you wanted. Or you could have one
SQL Server box per web site.
You mention that "they're about to get ripped off." What does that mean?
Are "they" spending too much? Do "they" think that they need to purchase
one copy of SQL Server for every web server?
You are correct in searching for the Per Processor license, as this is what
you will need in order to use it to drive a web site (or sites).
The standard Edition of SQL Server is usually sufficient for most people.
Enterprise does have some additional high availability features (clustering)
and some other features that can improve performance (indexed views, greater
memory support), but those features come at a cost.
Only you can determine what features you require. These features will
determine what version of SQL Server to purchase.
Keith
"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
> James
>
|||Thanks for the reply. We'll only have one SQL Server box. When I said
they're about to get ripped off...I meant that they're searching for the
software on sketchy sites with rather large discounts. Microsoft is selling
the processor license for $5000 if I'm reading this anywhere near right, and
they're looking at copies that are barely over $1000. It just doesn't seem
"kosher" to me. The 2 Gig limit...that refers to the amount of memory the
box itself can have? I don't know that this would be a problem or not.
I'll have to look into that.
Thanks,
James
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OGZW8nSXEHA.1000@.TK2MSFTNGP12.phx.gbl...
> How many SQL Server boxes are you going to have? You could have thousands
> of websites pointing to one SQL Server if you wanted. Or you could have
one
> SQL Server box per web site.
> You mention that "they're about to get ripped off." What does that mean?
> Are "they" spending too much? Do "they" think that they need to purchase
> one copy of SQL Server for every web server?
> You are correct in searching for the Per Processor license, as this is
what
> you will need in order to use it to drive a web site (or sites).
> The standard Edition of SQL Server is usually sufficient for most people.
> Enterprise does have some additional high availability features
(clustering)
> and some other features that can improve performance (indexed views,
greater[vbcol=seagreen]
> memory support), but those features come at a cost.
> Only you can determine what features you require. These features will
> determine what version of SQL Server to purchase.
> --
> Keith
>
> "James Baker" <cppjames@.hotmail.com> wrote in message
> news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> between
external[vbcol=seagreen]
> it).
get
>
the different "types" of SQL Server. We have a company that has
approximately 50 internal website users and approximately 2-3000 external
website users (no idea how many concurrent).
What type of SQL Server software will we need? My last company had SQL
2000 Enterprise, but they had a legitimate budget. This company is
searching on pricegrabber for Standard Edition 1 processor licenses and
trying to find the cheapest deal (you wouldn't believe this if you saw it).
Anyway, I'd like to provide some insight...as I know they're about to get
ripped off, but I figured I'd do some homework first. Any info would be
fantastic. Thanks.
James
"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
One of the biggest drawbacks of standard vs. enterprise is the 2 gig memory
limit on standard. Of course, there are other features/benefits of
enterprise, but that is a deciding factor for a lot of people.
-John Oakes
> James
>
|||"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
One of the biggest drawbacks of standard vs. enterprise is the 2 gig memory
limit on standard. Of course, there are other features/benefits of
enterprise, but that is a deciding factor for a lot of people.
-John Oakes
> James
>
|||How many SQL Server boxes are you going to have? You could have thousands
of websites pointing to one SQL Server if you wanted. Or you could have one
SQL Server box per web site.
You mention that "they're about to get ripped off." What does that mean?
Are "they" spending too much? Do "they" think that they need to purchase
one copy of SQL Server for every web server?
You are correct in searching for the Per Processor license, as this is what
you will need in order to use it to drive a web site (or sites).
The standard Edition of SQL Server is usually sufficient for most people.
Enterprise does have some additional high availability features (clustering)
and some other features that can improve performance (indexed views, greater
memory support), but those features come at a cost.
Only you can determine what features you require. These features will
determine what version of SQL Server to purchase.
Keith
"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
> James
>
|||Thanks for the reply. We'll only have one SQL Server box. When I said
they're about to get ripped off...I meant that they're searching for the
software on sketchy sites with rather large discounts. Microsoft is selling
the processor license for $5000 if I'm reading this anywhere near right, and
they're looking at copies that are barely over $1000. It just doesn't seem
"kosher" to me. The 2 Gig limit...that refers to the amount of memory the
box itself can have? I don't know that this would be a problem or not.
I'll have to look into that.
Thanks,
James
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OGZW8nSXEHA.1000@.TK2MSFTNGP12.phx.gbl...
> How many SQL Server boxes are you going to have? You could have thousands
> of websites pointing to one SQL Server if you wanted. Or you could have
one
> SQL Server box per web site.
> You mention that "they're about to get ripped off." What does that mean?
> Are "they" spending too much? Do "they" think that they need to purchase
> one copy of SQL Server for every web server?
> You are correct in searching for the Per Processor license, as this is
what
> you will need in order to use it to drive a web site (or sites).
> The standard Edition of SQL Server is usually sufficient for most people.
> Enterprise does have some additional high availability features
(clustering)
> and some other features that can improve performance (indexed views,
greater[vbcol=seagreen]
> memory support), but those features come at a cost.
> Only you can determine what features you require. These features will
> determine what version of SQL Server to purchase.
> --
> Keith
>
> "James Baker" <cppjames@.hotmail.com> wrote in message
> news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> between
external[vbcol=seagreen]
> it).
get
>
|||How many SQL Server boxes are you going to have? You could have thousands
of websites pointing to one SQL Server if you wanted. Or you could have one
SQL Server box per web site.
You mention that "they're about to get ripped off." What does that mean?
Are "they" spending too much? Do "they" think that they need to purchase
one copy of SQL Server for every web server?
You are correct in searching for the Per Processor license, as this is what
you will need in order to use it to drive a web site (or sites).
The standard Edition of SQL Server is usually sufficient for most people.
Enterprise does have some additional high availability features (clustering)
and some other features that can improve performance (indexed views, greater
memory support), but those features come at a cost.
Only you can determine what features you require. These features will
determine what version of SQL Server to purchase.
Keith
"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
> James
>
|||Thanks for the reply. We'll only have one SQL Server box. When I said
they're about to get ripped off...I meant that they're searching for the
software on sketchy sites with rather large discounts. Microsoft is selling
the processor license for $5000 if I'm reading this anywhere near right, and
they're looking at copies that are barely over $1000. It just doesn't seem
"kosher" to me. The 2 Gig limit...that refers to the amount of memory the
box itself can have? I don't know that this would be a problem or not.
I'll have to look into that.
Thanks,
James
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OGZW8nSXEHA.1000@.TK2MSFTNGP12.phx.gbl...
> How many SQL Server boxes are you going to have? You could have thousands
> of websites pointing to one SQL Server if you wanted. Or you could have
one
> SQL Server box per web site.
> You mention that "they're about to get ripped off." What does that mean?
> Are "they" spending too much? Do "they" think that they need to purchase
> one copy of SQL Server for every web server?
> You are correct in searching for the Per Processor license, as this is
what
> you will need in order to use it to drive a web site (or sites).
> The standard Edition of SQL Server is usually sufficient for most people.
> Enterprise does have some additional high availability features
(clustering)
> and some other features that can improve performance (indexed views,
greater[vbcol=seagreen]
> memory support), but those features come at a cost.
> Only you can determine what features you require. These features will
> determine what version of SQL Server to purchase.
> --
> Keith
>
> "James Baker" <cppjames@.hotmail.com> wrote in message
> news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> between
external[vbcol=seagreen]
> it).
get
>
Purchasing SQL
I've looked through a number of sites trying to find the difference between
the different "types" of SQL Server. We have a company that has
approximately 50 internal website users and approximately 2-3000 external
website users (no idea how many concurrent).
What type of SQL Server software will we need? My last company had SQL
2000 Enterprise, but they had a legitimate budget. This company is
searching on pricegrabber for Standard Edition 1 processor licenses and
trying to find the cheapest deal (you wouldn't believe this if you saw it).
Anyway, I'd like to provide some insight...as I know they're about to get
ripped off, but I figured I'd do some homework first. Any info would be
fantastic. Thanks.
James"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
One of the biggest drawbacks of standard vs. enterprise is the 2 gig memory
limit on standard. Of course, there are other features/benefits of
enterprise, but that is a deciding factor for a lot of people.
-John Oakes
> James
>|||How many SQL Server boxes are you going to have? You could have thousands
of websites pointing to one SQL Server if you wanted. Or you could have one
SQL Server box per web site.
You mention that "they're about to get ripped off." What does that mean?
Are "they" spending too much? Do "they" think that they need to purchase
one copy of SQL Server for every web server?
You are correct in searching for the Per Processor license, as this is what
you will need in order to use it to drive a web site (or sites).
The standard Edition of SQL Server is usually sufficient for most people.
Enterprise does have some additional high availability features (clustering)
and some other features that can improve performance (indexed views, greater
memory support), but those features come at a cost.
Only you can determine what features you require. These features will
determine what version of SQL Server to purchase.
Keith
"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
> James
>|||Thanks for the reply. We'll only have one SQL Server box. When I said
they're about to get ripped off...I meant that they're searching for the
software on sketchy sites with rather large discounts. Microsoft is selling
the processor license for $5000 if I'm reading this anywhere near right, and
they're looking at copies that are barely over $1000. It just doesn't seem
"kosher" to me. The 2 Gig limit...that refers to the amount of memory the
box itself can have? I don't know that this would be a problem or not.
I'll have to look into that.
Thanks,
James
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OGZW8nSXEHA.1000@.TK2MSFTNGP12.phx.gbl...
> How many SQL Server boxes are you going to have? You could have thousands
> of websites pointing to one SQL Server if you wanted. Or you could have
one
> SQL Server box per web site.
> You mention that "they're about to get ripped off." What does that mean?
> Are "they" spending too much? Do "they" think that they need to purchase
> one copy of SQL Server for every web server?
> You are correct in searching for the Per Processor license, as this is
what
> you will need in order to use it to drive a web site (or sites).
> The standard Edition of SQL Server is usually sufficient for most people.
> Enterprise does have some additional high availability features
(clustering)
> and some other features that can improve performance (indexed views,
greater
> memory support), but those features come at a cost.
> Only you can determine what features you require. These features will
> determine what version of SQL Server to purchase.
> --
> Keith
>
> "James Baker" <cppjames@.hotmail.com> wrote in message
> news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> between
external[vbcol=seagreen]
> it).
get[vbcol=seagreen]
>
the different "types" of SQL Server. We have a company that has
approximately 50 internal website users and approximately 2-3000 external
website users (no idea how many concurrent).
What type of SQL Server software will we need? My last company had SQL
2000 Enterprise, but they had a legitimate budget. This company is
searching on pricegrabber for Standard Edition 1 processor licenses and
trying to find the cheapest deal (you wouldn't believe this if you saw it).
Anyway, I'd like to provide some insight...as I know they're about to get
ripped off, but I figured I'd do some homework first. Any info would be
fantastic. Thanks.
James"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
One of the biggest drawbacks of standard vs. enterprise is the 2 gig memory
limit on standard. Of course, there are other features/benefits of
enterprise, but that is a deciding factor for a lot of people.
-John Oakes
> James
>|||How many SQL Server boxes are you going to have? You could have thousands
of websites pointing to one SQL Server if you wanted. Or you could have one
SQL Server box per web site.
You mention that "they're about to get ripped off." What does that mean?
Are "they" spending too much? Do "they" think that they need to purchase
one copy of SQL Server for every web server?
You are correct in searching for the Per Processor license, as this is what
you will need in order to use it to drive a web site (or sites).
The standard Edition of SQL Server is usually sufficient for most people.
Enterprise does have some additional high availability features (clustering)
and some other features that can improve performance (indexed views, greater
memory support), but those features come at a cost.
Only you can determine what features you require. These features will
determine what version of SQL Server to purchase.
Keith
"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
> James
>|||Thanks for the reply. We'll only have one SQL Server box. When I said
they're about to get ripped off...I meant that they're searching for the
software on sketchy sites with rather large discounts. Microsoft is selling
the processor license for $5000 if I'm reading this anywhere near right, and
they're looking at copies that are barely over $1000. It just doesn't seem
"kosher" to me. The 2 Gig limit...that refers to the amount of memory the
box itself can have? I don't know that this would be a problem or not.
I'll have to look into that.
Thanks,
James
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OGZW8nSXEHA.1000@.TK2MSFTNGP12.phx.gbl...
> How many SQL Server boxes are you going to have? You could have thousands
> of websites pointing to one SQL Server if you wanted. Or you could have
one
> SQL Server box per web site.
> You mention that "they're about to get ripped off." What does that mean?
> Are "they" spending too much? Do "they" think that they need to purchase
> one copy of SQL Server for every web server?
> You are correct in searching for the Per Processor license, as this is
what
> you will need in order to use it to drive a web site (or sites).
> The standard Edition of SQL Server is usually sufficient for most people.
> Enterprise does have some additional high availability features
(clustering)
> and some other features that can improve performance (indexed views,
greater
> memory support), but those features come at a cost.
> Only you can determine what features you require. These features will
> determine what version of SQL Server to purchase.
> --
> Keith
>
> "James Baker" <cppjames@.hotmail.com> wrote in message
> news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> between
external[vbcol=seagreen]
> it).
get[vbcol=seagreen]
>
Purchasing SQL
I've looked through a number of sites trying to find the difference between
the different "types" of SQL Server. We have a company that has
approximately 50 internal website users and approximately 2-3000 external
website users (no idea how many concurrent).
What type of SQL Server software will we need? My last company had SQL
2000 Enterprise, but they had a legitimate budget. This company is
searching on pricegrabber for Standard Edition 1 processor licenses and
trying to find the cheapest deal (you wouldn't believe this if you saw it).
Anyway, I'd like to provide some insight...as I know they're about to get
ripped off, but I figured I'd do some homework first. Any info would be
fantastic. Thanks.
James"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
One of the biggest drawbacks of standard vs. enterprise is the 2 gig memory
limit on standard. Of course, there are other features/benefits of
enterprise, but that is a deciding factor for a lot of people.
-John Oakes
> James
>|||How many SQL Server boxes are you going to have? You could have thousands
of websites pointing to one SQL Server if you wanted. Or you could have one
SQL Server box per web site.
You mention that "they're about to get ripped off." What does that mean?
Are "they" spending too much? Do "they" think that they need to purchase
one copy of SQL Server for every web server?
You are correct in searching for the Per Processor license, as this is what
you will need in order to use it to drive a web site (or sites).
The standard Edition of SQL Server is usually sufficient for most people.
Enterprise does have some additional high availability features (clustering)
and some other features that can improve performance (indexed views, greater
memory support), but those features come at a cost.
Only you can determine what features you require. These features will
determine what version of SQL Server to purchase.
--
Keith
"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
> James
>|||Thanks for the reply. We'll only have one SQL Server box. When I said
they're about to get ripped off...I meant that they're searching for the
software on sketchy sites with rather large discounts. Microsoft is selling
the processor license for $5000 if I'm reading this anywhere near right, and
they're looking at copies that are barely over $1000. It just doesn't seem
"kosher" to me. The 2 Gig limit...that refers to the amount of memory the
box itself can have? I don't know that this would be a problem or not.
I'll have to look into that.
Thanks,
James
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OGZW8nSXEHA.1000@.TK2MSFTNGP12.phx.gbl...
> How many SQL Server boxes are you going to have? You could have thousands
> of websites pointing to one SQL Server if you wanted. Or you could have
one
> SQL Server box per web site.
> You mention that "they're about to get ripped off." What does that mean?
> Are "they" spending too much? Do "they" think that they need to purchase
> one copy of SQL Server for every web server?
> You are correct in searching for the Per Processor license, as this is
what
> you will need in order to use it to drive a web site (or sites).
> The standard Edition of SQL Server is usually sufficient for most people.
> Enterprise does have some additional high availability features
(clustering)
> and some other features that can improve performance (indexed views,
greater
> memory support), but those features come at a cost.
> Only you can determine what features you require. These features will
> determine what version of SQL Server to purchase.
> --
> Keith
>
> "James Baker" <cppjames@.hotmail.com> wrote in message
> news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> > I've looked through a number of sites trying to find the difference
> between
> > the different "types" of SQL Server. We have a company that has
> > approximately 50 internal website users and approximately 2-3000
external
> > website users (no idea how many concurrent).
> >
> > What type of SQL Server software will we need? My last company had SQL
> > 2000 Enterprise, but they had a legitimate budget. This company is
> > searching on pricegrabber for Standard Edition 1 processor licenses and
> > trying to find the cheapest deal (you wouldn't believe this if you saw
> it).
> > Anyway, I'd like to provide some insight...as I know they're about to
get
> > ripped off, but I figured I'd do some homework first. Any info would be
> > fantastic. Thanks.
> >
> > James
> >
> >
>|||Yeah, $1000 seems pretty cheap. Are they looking at the processor license,
or the 5 client license?
I jumped out to Buy.com (what I would consider a reputable vendor) and here
are the prices for Standard Edition SQL2k:
5 client license$1360
http://www.buy.com/retail/product.asp?sku=20321483&loc=105&sp=1
processor license $4440
http://www.buy.com/retail/product.asp?sku=20321507&loc=105&sp=1
The 2GB memory limit refers to what SQL Server Standard Edition will use.
Search Books Online (the SQL Server documentation) for "maximum capacity
specifications"
If you don't have Books Online you can download it here:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
--
Keith
"James Baker" <cppjames@.hotmail.com> wrote in message
news:e734erSXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Thanks for the reply. We'll only have one SQL Server box. When I said
> they're about to get ripped off...I meant that they're searching for the
> software on sketchy sites with rather large discounts. Microsoft is
selling
> the processor license for $5000 if I'm reading this anywhere near right,
and
> they're looking at copies that are barely over $1000. It just doesn't
seem
> "kosher" to me. The 2 Gig limit...that refers to the amount of memory the
> box itself can have? I don't know that this would be a problem or not.
> I'll have to look into that.
> Thanks,
> James
>
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:OGZW8nSXEHA.1000@.TK2MSFTNGP12.phx.gbl...
> > How many SQL Server boxes are you going to have? You could have
thousands
> > of websites pointing to one SQL Server if you wanted. Or you could have
> one
> > SQL Server box per web site.
> >
> > You mention that "they're about to get ripped off." What does that
mean?
> > Are "they" spending too much? Do "they" think that they need to
purchase
> > one copy of SQL Server for every web server?
> >
> > You are correct in searching for the Per Processor license, as this is
> what
> > you will need in order to use it to drive a web site (or sites).
> >
> > The standard Edition of SQL Server is usually sufficient for most
people.
> > Enterprise does have some additional high availability features
> (clustering)
> > and some other features that can improve performance (indexed views,
> greater
> > memory support), but those features come at a cost.
> >
> > Only you can determine what features you require. These features will
> > determine what version of SQL Server to purchase.
> >
> > --
> > Keith
> >
> >
> > "James Baker" <cppjames@.hotmail.com> wrote in message
> > news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> > > I've looked through a number of sites trying to find the difference
> > between
> > > the different "types" of SQL Server. We have a company that has
> > > approximately 50 internal website users and approximately 2-3000
> external
> > > website users (no idea how many concurrent).
> > >
> > > What type of SQL Server software will we need? My last company had
SQL
> > > 2000 Enterprise, but they had a legitimate budget. This company is
> > > searching on pricegrabber for Standard Edition 1 processor licenses
and
> > > trying to find the cheapest deal (you wouldn't believe this if you saw
> > it).
> > > Anyway, I'd like to provide some insight...as I know they're about to
> get
> > > ripped off, but I figured I'd do some homework first. Any info would
be
> > > fantastic. Thanks.
> > >
> > > James
> > >
> > >
> >
>
the different "types" of SQL Server. We have a company that has
approximately 50 internal website users and approximately 2-3000 external
website users (no idea how many concurrent).
What type of SQL Server software will we need? My last company had SQL
2000 Enterprise, but they had a legitimate budget. This company is
searching on pricegrabber for Standard Edition 1 processor licenses and
trying to find the cheapest deal (you wouldn't believe this if you saw it).
Anyway, I'd like to provide some insight...as I know they're about to get
ripped off, but I figured I'd do some homework first. Any info would be
fantastic. Thanks.
James"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
One of the biggest drawbacks of standard vs. enterprise is the 2 gig memory
limit on standard. Of course, there are other features/benefits of
enterprise, but that is a deciding factor for a lot of people.
-John Oakes
> James
>|||How many SQL Server boxes are you going to have? You could have thousands
of websites pointing to one SQL Server if you wanted. Or you could have one
SQL Server box per web site.
You mention that "they're about to get ripped off." What does that mean?
Are "they" spending too much? Do "they" think that they need to purchase
one copy of SQL Server for every web server?
You are correct in searching for the Per Processor license, as this is what
you will need in order to use it to drive a web site (or sites).
The standard Edition of SQL Server is usually sufficient for most people.
Enterprise does have some additional high availability features (clustering)
and some other features that can improve performance (indexed views, greater
memory support), but those features come at a cost.
Only you can determine what features you require. These features will
determine what version of SQL Server to purchase.
--
Keith
"James Baker" <cppjames@.hotmail.com> wrote in message
news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> I've looked through a number of sites trying to find the difference
between
> the different "types" of SQL Server. We have a company that has
> approximately 50 internal website users and approximately 2-3000 external
> website users (no idea how many concurrent).
> What type of SQL Server software will we need? My last company had SQL
> 2000 Enterprise, but they had a legitimate budget. This company is
> searching on pricegrabber for Standard Edition 1 processor licenses and
> trying to find the cheapest deal (you wouldn't believe this if you saw
it).
> Anyway, I'd like to provide some insight...as I know they're about to get
> ripped off, but I figured I'd do some homework first. Any info would be
> fantastic. Thanks.
> James
>|||Thanks for the reply. We'll only have one SQL Server box. When I said
they're about to get ripped off...I meant that they're searching for the
software on sketchy sites with rather large discounts. Microsoft is selling
the processor license for $5000 if I'm reading this anywhere near right, and
they're looking at copies that are barely over $1000. It just doesn't seem
"kosher" to me. The 2 Gig limit...that refers to the amount of memory the
box itself can have? I don't know that this would be a problem or not.
I'll have to look into that.
Thanks,
James
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OGZW8nSXEHA.1000@.TK2MSFTNGP12.phx.gbl...
> How many SQL Server boxes are you going to have? You could have thousands
> of websites pointing to one SQL Server if you wanted. Or you could have
one
> SQL Server box per web site.
> You mention that "they're about to get ripped off." What does that mean?
> Are "they" spending too much? Do "they" think that they need to purchase
> one copy of SQL Server for every web server?
> You are correct in searching for the Per Processor license, as this is
what
> you will need in order to use it to drive a web site (or sites).
> The standard Edition of SQL Server is usually sufficient for most people.
> Enterprise does have some additional high availability features
(clustering)
> and some other features that can improve performance (indexed views,
greater
> memory support), but those features come at a cost.
> Only you can determine what features you require. These features will
> determine what version of SQL Server to purchase.
> --
> Keith
>
> "James Baker" <cppjames@.hotmail.com> wrote in message
> news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> > I've looked through a number of sites trying to find the difference
> between
> > the different "types" of SQL Server. We have a company that has
> > approximately 50 internal website users and approximately 2-3000
external
> > website users (no idea how many concurrent).
> >
> > What type of SQL Server software will we need? My last company had SQL
> > 2000 Enterprise, but they had a legitimate budget. This company is
> > searching on pricegrabber for Standard Edition 1 processor licenses and
> > trying to find the cheapest deal (you wouldn't believe this if you saw
> it).
> > Anyway, I'd like to provide some insight...as I know they're about to
get
> > ripped off, but I figured I'd do some homework first. Any info would be
> > fantastic. Thanks.
> >
> > James
> >
> >
>|||Yeah, $1000 seems pretty cheap. Are they looking at the processor license,
or the 5 client license?
I jumped out to Buy.com (what I would consider a reputable vendor) and here
are the prices for Standard Edition SQL2k:
5 client license$1360
http://www.buy.com/retail/product.asp?sku=20321483&loc=105&sp=1
processor license $4440
http://www.buy.com/retail/product.asp?sku=20321507&loc=105&sp=1
The 2GB memory limit refers to what SQL Server Standard Edition will use.
Search Books Online (the SQL Server documentation) for "maximum capacity
specifications"
If you don't have Books Online you can download it here:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
--
Keith
"James Baker" <cppjames@.hotmail.com> wrote in message
news:e734erSXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Thanks for the reply. We'll only have one SQL Server box. When I said
> they're about to get ripped off...I meant that they're searching for the
> software on sketchy sites with rather large discounts. Microsoft is
selling
> the processor license for $5000 if I'm reading this anywhere near right,
and
> they're looking at copies that are barely over $1000. It just doesn't
seem
> "kosher" to me. The 2 Gig limit...that refers to the amount of memory the
> box itself can have? I don't know that this would be a problem or not.
> I'll have to look into that.
> Thanks,
> James
>
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:OGZW8nSXEHA.1000@.TK2MSFTNGP12.phx.gbl...
> > How many SQL Server boxes are you going to have? You could have
thousands
> > of websites pointing to one SQL Server if you wanted. Or you could have
> one
> > SQL Server box per web site.
> >
> > You mention that "they're about to get ripped off." What does that
mean?
> > Are "they" spending too much? Do "they" think that they need to
purchase
> > one copy of SQL Server for every web server?
> >
> > You are correct in searching for the Per Processor license, as this is
> what
> > you will need in order to use it to drive a web site (or sites).
> >
> > The standard Edition of SQL Server is usually sufficient for most
people.
> > Enterprise does have some additional high availability features
> (clustering)
> > and some other features that can improve performance (indexed views,
> greater
> > memory support), but those features come at a cost.
> >
> > Only you can determine what features you require. These features will
> > determine what version of SQL Server to purchase.
> >
> > --
> > Keith
> >
> >
> > "James Baker" <cppjames@.hotmail.com> wrote in message
> > news:u7lhHaSXEHA.2408@.tk2msftngp13.phx.gbl...
> > > I've looked through a number of sites trying to find the difference
> > between
> > > the different "types" of SQL Server. We have a company that has
> > > approximately 50 internal website users and approximately 2-3000
> external
> > > website users (no idea how many concurrent).
> > >
> > > What type of SQL Server software will we need? My last company had
SQL
> > > 2000 Enterprise, but they had a legitimate budget. This company is
> > > searching on pricegrabber for Standard Edition 1 processor licenses
and
> > > trying to find the cheapest deal (you wouldn't believe this if you saw
> > it).
> > > Anyway, I'd like to provide some insight...as I know they're about to
> get
> > > ripped off, but I figured I'd do some homework first. Any info would
be
> > > fantastic. Thanks.
> > >
> > > James
> > >
> > >
> >
>
Purchasing Microsoft SQL Server for small company
I currently have a database through a company that has been upkeeping SQL an
d
storing data. I am cancelling subscription and want to retrieve data. They
are sending me a backup DVD with all the files. How easy is it to use
Microsoft SQL and can the files be transfered to another program such as
Access or Excel'
ThanksAre you saying that you have data stored in a SQL Server database, which is
hosted by other company, and you now want to sotre your data by yourself? If
so, the best way to do is to set up your own SQL Server, have you data on
the other SQL Server backed up and restore it on your own SQL Server. (or
use detach/attach database from/to SQL Server).
There are different edition of SQL Server, from very expensive Enterprise
Edition, to free version of SQL Server Express/MSDE. If your data value is
not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
course, some basic knowledge on SQL Server is required (I mean a bit more
and complicated that required by using Access).
If you want those data being transferred to Access DB, then you can ask your
SQL Server host to export it to a *.mdb file. However, in general, only data
can be transferred, server object used in that database (view, sp... they
may contain critical logics for using the database) would not be
transferred. So, you would need to build a sort of front end app inorder to
use your data. Unless the only thing you need is the data.
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>I currently have a database through a company that has been upkeeping SQL
>and
> storing data. I am cancelling subscription and want to retrieve data.
> They
> are sending me a backup DVD with all the files. How easy is it to use
> Microsoft SQL and can the files be transfered to another program such as
> Access or Excel'
> Thanks|||You are taking a big step backward going from SQL Server to MS Access and an
even bigger step if you go to Excel.
Microsoft SQL Server is an enterprise level relational database management
system.
Microsoft Access is a database engine but it is not quite enterprise level.
MS Excel is can be used to display information to management types and
create pretty reports, but it is by no means an enterprise storage
technology.
IF your host sends you the correct information -- backup files created via
the T-SQL BACKUP command OR database and log files after they ran
sp_detach_db -- you should be able to restore the database(s) to a SQL
Server in your environment.
SQL Server does not have "files" (like Excel). It is more similar to MS
Access in that it has tables within one container (a database).
Keith Kratochvil
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>I currently have a database through a company that has been upkeeping SQL
>and
> storing data. I am cancelling subscription and want to retrieve data.
> They
> are sending me a backup DVD with all the files. How easy is it to use
> Microsoft SQL and can the files be transfered to another program such as
> Access or Excel'
> Thanks|||The company is not using the system to it's fullest potential. The users ar
e
not computer savvy and would prefer a more simple system ie: Access. They
don't want to be paying the fees associated to a program they don't use.
They have 7 years of data they need to access and I have to figure out how.
Once we access the data and can retrieve the reports and pictures we won't b
e
using the system. We want to transfer it to Access.
Thanks
"Norman Yuan" wrote:
> Are you saying that you have data stored in a SQL Server database, which i
s
> hosted by other company, and you now want to sotre your data by yourself?
If
> so, the best way to do is to set up your own SQL Server, have you data on
> the other SQL Server backed up and restore it on your own SQL Server. (or
> use detach/attach database from/to SQL Server).
> There are different edition of SQL Server, from very expensive Enterprise
> Edition, to free version of SQL Server Express/MSDE. If your data value is
> not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
> course, some basic knowledge on SQL Server is required (I mean a bit more
> and complicated that required by using Access).
> If you want those data being transferred to Access DB, then you can ask yo
ur
> SQL Server host to export it to a *.mdb file. However, in general, only da
ta
> can be transferred, server object used in that database (view, sp... they
> may contain critical logics for using the database) would not be
> transferred. So, you would need to build a sort of front end app inorder t
o
> use your data. Unless the only thing you need is the data.
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>
>|||The company is not using the system to it's fullest potential. The users are
not computer savvy and would prefer a more simple system ie: Access. They
don't want to be paying the fees associated to a program they don't use.
They have 7 years of data they need to access and I have to figure out how.
Once we access the data and can retrieve the reports and pictures we won't b
e
using the system. We want to transfer it to Access.
Thanks
"Keith Kratochvil" wrote:
> You are taking a big step backward going from SQL Server to MS Access and
an
> even bigger step if you go to Excel.
> Microsoft SQL Server is an enterprise level relational database management
> system.
> Microsoft Access is a database engine but it is not quite enterprise level
.
> MS Excel is can be used to display information to management types and
> create pretty reports, but it is by no means an enterprise storage
> technology.
>
> IF your host sends you the correct information -- backup files created via
> the T-SQL BACKUP command OR database and log files after they ran
> sp_detach_db -- you should be able to restore the database(s) to a SQL
> Server in your environment.
>
> SQL Server does not have "files" (like Excel). It is more similar to MS
> Access in that it has tables within one container (a database).
>
> --
> Keith Kratochvil
>
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>
>|||Eddie,
You can certainly use Access as the front-end program for
your users, even if you maintain the data in SQL Server.
SQL Server in fact has no front-end, really - just a set of
management tools, so you have many options for your
users.
Since no one has mentioned it, don't overlook the Workgroup
Edition of SQL Server, which might be good for your needs.
http://www.microsoft.com/sql/prodin...e-features.mspx
Steve Kass
Drew University
Eddie wrote:
[vbcol=seagreen]
>The company is not using the system to it's fullest potential. The users a
re
>not computer savvy and would prefer a more simple system ie: Access. They
>don't want to be paying the fees associated to a program they don't use.
>They have 7 years of data they need to access and I have to figure out how.
>Once we access the data and can retrieve the reports and pictures we won't
be
>using the system. We want to transfer it to Access.
>Thanks
>"Norman Yuan" wrote:
>
>|||Maybe SQL Server Express combined with MS Access front-ends is the answer.
SS Express is free.
Randall Arnold
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:49490C53-3ADC-418F-8E8F-A7468A98DEE4@.microsoft.com...[vbcol=seagreen]
> The company is not using the system to it's fullest potential. The users
> are
> not computer savvy and would prefer a more simple system ie: Access. They
> don't want to be paying the fees associated to a program they don't use.
> They have 7 years of data they need to access and I have to figure out
> how.
> Once we access the data and can retrieve the reports and pictures we won't
> be
> using the system. We want to transfer it to Access.
> Thanks
> "Keith Kratochvil" wrote:
>|||So, summarize what you want:
1. You have data stored in database of someone's SQL Server;
2. You need to get all data out in this database and svae them in some
formats you choose;
3. You do not need application related server objects/logics in the database
(views, stored procedures, UDFs) once you retrieved the data;
4. The SQL Server host would not do the data retrieving for you. They can
only give you the backup or data file of the database.
Since you want to transfer data from SQL Server to Access (more accurately,
Jet database), there may be some degree of data or data type or data
accuracy loss because of the differences of the two data engine.
Here is what I would do:
1. Get full backup or detached database file (latter would be better);
2. Install a MSDE, which is free version of SQL Server, if the data file of
the database (*.mdf) is less than 2GB.
3. Restore/attach the databse to MSDE.
4. Use Access as tool to connect to MSDE and start retrieve data. You can
create an Access ADP project to use as MSDE front end UI. Then you can open
each table to export, or write some macro/VBA code to retireve specific data
and output to specific format.
5. Since I have the database on my onw, no-cost MSDE engine, I can try and
try until satisfied totally (of course do it on a copy of the data).
6, Do the final retrieving and then uninstall the MSDE.
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:E426270B-5851-456C-B190-1D747BAFA433@.microsoft.com...[vbcol=seagreen]
> The company is not using the system to it's fullest potential. The users
> are
> not computer savvy and would prefer a more simple system ie: Access. They
> don't want to be paying the fees associated to a program they don't use.
> They have 7 years of data they need to access and I have to figure out
> how.
> Once we access the data and can retrieve the reports and pictures we won't
> be
> using the system. We want to transfer it to Access.
> Thanks
> "Norman Yuan" wrote:
>
d
storing data. I am cancelling subscription and want to retrieve data. They
are sending me a backup DVD with all the files. How easy is it to use
Microsoft SQL and can the files be transfered to another program such as
Access or Excel'
ThanksAre you saying that you have data stored in a SQL Server database, which is
hosted by other company, and you now want to sotre your data by yourself? If
so, the best way to do is to set up your own SQL Server, have you data on
the other SQL Server backed up and restore it on your own SQL Server. (or
use detach/attach database from/to SQL Server).
There are different edition of SQL Server, from very expensive Enterprise
Edition, to free version of SQL Server Express/MSDE. If your data value is
not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
course, some basic knowledge on SQL Server is required (I mean a bit more
and complicated that required by using Access).
If you want those data being transferred to Access DB, then you can ask your
SQL Server host to export it to a *.mdb file. However, in general, only data
can be transferred, server object used in that database (view, sp... they
may contain critical logics for using the database) would not be
transferred. So, you would need to build a sort of front end app inorder to
use your data. Unless the only thing you need is the data.
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>I currently have a database through a company that has been upkeeping SQL
>and
> storing data. I am cancelling subscription and want to retrieve data.
> They
> are sending me a backup DVD with all the files. How easy is it to use
> Microsoft SQL and can the files be transfered to another program such as
> Access or Excel'
> Thanks|||You are taking a big step backward going from SQL Server to MS Access and an
even bigger step if you go to Excel.
Microsoft SQL Server is an enterprise level relational database management
system.
Microsoft Access is a database engine but it is not quite enterprise level.
MS Excel is can be used to display information to management types and
create pretty reports, but it is by no means an enterprise storage
technology.
IF your host sends you the correct information -- backup files created via
the T-SQL BACKUP command OR database and log files after they ran
sp_detach_db -- you should be able to restore the database(s) to a SQL
Server in your environment.
SQL Server does not have "files" (like Excel). It is more similar to MS
Access in that it has tables within one container (a database).
Keith Kratochvil
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>I currently have a database through a company that has been upkeeping SQL
>and
> storing data. I am cancelling subscription and want to retrieve data.
> They
> are sending me a backup DVD with all the files. How easy is it to use
> Microsoft SQL and can the files be transfered to another program such as
> Access or Excel'
> Thanks|||The company is not using the system to it's fullest potential. The users ar
e
not computer savvy and would prefer a more simple system ie: Access. They
don't want to be paying the fees associated to a program they don't use.
They have 7 years of data they need to access and I have to figure out how.
Once we access the data and can retrieve the reports and pictures we won't b
e
using the system. We want to transfer it to Access.
Thanks
"Norman Yuan" wrote:
> Are you saying that you have data stored in a SQL Server database, which i
s
> hosted by other company, and you now want to sotre your data by yourself?
If
> so, the best way to do is to set up your own SQL Server, have you data on
> the other SQL Server backed up and restore it on your own SQL Server. (or
> use detach/attach database from/to SQL Server).
> There are different edition of SQL Server, from very expensive Enterprise
> Edition, to free version of SQL Server Express/MSDE. If your data value is
> not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
> course, some basic knowledge on SQL Server is required (I mean a bit more
> and complicated that required by using Access).
> If you want those data being transferred to Access DB, then you can ask yo
ur
> SQL Server host to export it to a *.mdb file. However, in general, only da
ta
> can be transferred, server object used in that database (view, sp... they
> may contain critical logics for using the database) would not be
> transferred. So, you would need to build a sort of front end app inorder t
o
> use your data. Unless the only thing you need is the data.
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>
>|||The company is not using the system to it's fullest potential. The users are
not computer savvy and would prefer a more simple system ie: Access. They
don't want to be paying the fees associated to a program they don't use.
They have 7 years of data they need to access and I have to figure out how.
Once we access the data and can retrieve the reports and pictures we won't b
e
using the system. We want to transfer it to Access.
Thanks
"Keith Kratochvil" wrote:
> You are taking a big step backward going from SQL Server to MS Access and
an
> even bigger step if you go to Excel.
> Microsoft SQL Server is an enterprise level relational database management
> system.
> Microsoft Access is a database engine but it is not quite enterprise level
.
> MS Excel is can be used to display information to management types and
> create pretty reports, but it is by no means an enterprise storage
> technology.
>
> IF your host sends you the correct information -- backup files created via
> the T-SQL BACKUP command OR database and log files after they ran
> sp_detach_db -- you should be able to restore the database(s) to a SQL
> Server in your environment.
>
> SQL Server does not have "files" (like Excel). It is more similar to MS
> Access in that it has tables within one container (a database).
>
> --
> Keith Kratochvil
>
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>
>|||Eddie,
You can certainly use Access as the front-end program for
your users, even if you maintain the data in SQL Server.
SQL Server in fact has no front-end, really - just a set of
management tools, so you have many options for your
users.
Since no one has mentioned it, don't overlook the Workgroup
Edition of SQL Server, which might be good for your needs.
http://www.microsoft.com/sql/prodin...e-features.mspx
Steve Kass
Drew University
Eddie wrote:
[vbcol=seagreen]
>The company is not using the system to it's fullest potential. The users a
re
>not computer savvy and would prefer a more simple system ie: Access. They
>don't want to be paying the fees associated to a program they don't use.
>They have 7 years of data they need to access and I have to figure out how.
>Once we access the data and can retrieve the reports and pictures we won't
be
>using the system. We want to transfer it to Access.
>Thanks
>"Norman Yuan" wrote:
>
>|||Maybe SQL Server Express combined with MS Access front-ends is the answer.
SS Express is free.
Randall Arnold
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:49490C53-3ADC-418F-8E8F-A7468A98DEE4@.microsoft.com...[vbcol=seagreen]
> The company is not using the system to it's fullest potential. The users
> are
> not computer savvy and would prefer a more simple system ie: Access. They
> don't want to be paying the fees associated to a program they don't use.
> They have 7 years of data they need to access and I have to figure out
> how.
> Once we access the data and can retrieve the reports and pictures we won't
> be
> using the system. We want to transfer it to Access.
> Thanks
> "Keith Kratochvil" wrote:
>|||So, summarize what you want:
1. You have data stored in database of someone's SQL Server;
2. You need to get all data out in this database and svae them in some
formats you choose;
3. You do not need application related server objects/logics in the database
(views, stored procedures, UDFs) once you retrieved the data;
4. The SQL Server host would not do the data retrieving for you. They can
only give you the backup or data file of the database.
Since you want to transfer data from SQL Server to Access (more accurately,
Jet database), there may be some degree of data or data type or data
accuracy loss because of the differences of the two data engine.
Here is what I would do:
1. Get full backup or detached database file (latter would be better);
2. Install a MSDE, which is free version of SQL Server, if the data file of
the database (*.mdf) is less than 2GB.
3. Restore/attach the databse to MSDE.
4. Use Access as tool to connect to MSDE and start retrieve data. You can
create an Access ADP project to use as MSDE front end UI. Then you can open
each table to export, or write some macro/VBA code to retireve specific data
and output to specific format.
5. Since I have the database on my onw, no-cost MSDE engine, I can try and
try until satisfied totally (of course do it on a copy of the data).
6, Do the final retrieving and then uninstall the MSDE.
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:E426270B-5851-456C-B190-1D747BAFA433@.microsoft.com...[vbcol=seagreen]
> The company is not using the system to it's fullest potential. The users
> are
> not computer savvy and would prefer a more simple system ie: Access. They
> don't want to be paying the fees associated to a program they don't use.
> They have 7 years of data they need to access and I have to figure out
> how.
> Once we access the data and can retrieve the reports and pictures we won't
> be
> using the system. We want to transfer it to Access.
> Thanks
> "Norman Yuan" wrote:
>
Purchasing Microsoft SQL Server for small company
I currently have a database through a company that has been upkeeping SQL and
storing data. I am cancelling subscription and want to retrieve data. They
are sending me a backup DVD with all the files. How easy is it to use
Microsoft SQL and can the files be transfered to another program such as
Access or Excel'
ThanksAre you saying that you have data stored in a SQL Server database, which is
hosted by other company, and you now want to sotre your data by yourself? If
so, the best way to do is to set up your own SQL Server, have you data on
the other SQL Server backed up and restore it on your own SQL Server. (or
use detach/attach database from/to SQL Server).
There are different edition of SQL Server, from very expensive Enterprise
Edition, to free version of SQL Server Express/MSDE. If your data value is
not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
course, some basic knowledge on SQL Server is required (I mean a bit more
and complicated that required by using Access).
If you want those data being transferred to Access DB, then you can ask your
SQL Server host to export it to a *.mdb file. However, in general, only data
can be transferred, server object used in that database (view, sp... they
may contain critical logics for using the database) would not be
transferred. So, you would need to build a sort of front end app inorder to
use your data. Unless the only thing you need is the data.
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>I currently have a database through a company that has been upkeeping SQL
>and
> storing data. I am cancelling subscription and want to retrieve data.
> They
> are sending me a backup DVD with all the files. How easy is it to use
> Microsoft SQL and can the files be transfered to another program such as
> Access or Excel'
> Thanks|||You are taking a big step backward going from SQL Server to MS Access and an
even bigger step if you go to Excel.
Microsoft SQL Server is an enterprise level relational database management
system.
Microsoft Access is a database engine but it is not quite enterprise level.
MS Excel is can be used to display information to management types and
create pretty reports, but it is by no means an enterprise storage
technology.
IF your host sends you the correct information -- backup files created via
the T-SQL BACKUP command OR database and log files after they ran
sp_detach_db -- you should be able to restore the database(s) to a SQL
Server in your environment.
SQL Server does not have "files" (like Excel). It is more similar to MS
Access in that it has tables within one container (a database).
Keith Kratochvil
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>I currently have a database through a company that has been upkeeping SQL
>and
> storing data. I am cancelling subscription and want to retrieve data.
> They
> are sending me a backup DVD with all the files. How easy is it to use
> Microsoft SQL and can the files be transfered to another program such as
> Access or Excel'
> Thanks|||The company is not using the system to it's fullest potential. The users are
not computer savvy and would prefer a more simple system ie: Access. They
don't want to be paying the fees associated to a program they don't use.
They have 7 years of data they need to access and I have to figure out how.
Once we access the data and can retrieve the reports and pictures we won't be
using the system. We want to transfer it to Access.
Thanks
"Norman Yuan" wrote:
> Are you saying that you have data stored in a SQL Server database, which is
> hosted by other company, and you now want to sotre your data by yourself? If
> so, the best way to do is to set up your own SQL Server, have you data on
> the other SQL Server backed up and restore it on your own SQL Server. (or
> use detach/attach database from/to SQL Server).
> There are different edition of SQL Server, from very expensive Enterprise
> Edition, to free version of SQL Server Express/MSDE. If your data value is
> not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
> course, some basic knowledge on SQL Server is required (I mean a bit more
> and complicated that required by using Access).
> If you want those data being transferred to Access DB, then you can ask your
> SQL Server host to export it to a *.mdb file. However, in general, only data
> can be transferred, server object used in that database (view, sp... they
> may contain critical logics for using the database) would not be
> transferred. So, you would need to build a sort of front end app inorder to
> use your data. Unless the only thing you need is the data.
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
> >I currently have a database through a company that has been upkeeping SQL
> >and
> > storing data. I am cancelling subscription and want to retrieve data.
> > They
> > are sending me a backup DVD with all the files. How easy is it to use
> > Microsoft SQL and can the files be transfered to another program such as
> > Access or Excel'
> >
> > Thanks
>
>|||The company is not using the system to it's fullest potential. The users are
not computer savvy and would prefer a more simple system ie: Access. They
don't want to be paying the fees associated to a program they don't use.
They have 7 years of data they need to access and I have to figure out how.
Once we access the data and can retrieve the reports and pictures we won't be
using the system. We want to transfer it to Access.
Thanks
"Keith Kratochvil" wrote:
> You are taking a big step backward going from SQL Server to MS Access and an
> even bigger step if you go to Excel.
> Microsoft SQL Server is an enterprise level relational database management
> system.
> Microsoft Access is a database engine but it is not quite enterprise level.
> MS Excel is can be used to display information to management types and
> create pretty reports, but it is by no means an enterprise storage
> technology.
>
> IF your host sends you the correct information -- backup files created via
> the T-SQL BACKUP command OR database and log files after they ran
> sp_detach_db -- you should be able to restore the database(s) to a SQL
> Server in your environment.
>
> SQL Server does not have "files" (like Excel). It is more similar to MS
> Access in that it has tables within one container (a database).
>
> --
> Keith Kratochvil
>
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
> >I currently have a database through a company that has been upkeeping SQL
> >and
> > storing data. I am cancelling subscription and want to retrieve data.
> > They
> > are sending me a backup DVD with all the files. How easy is it to use
> > Microsoft SQL and can the files be transfered to another program such as
> > Access or Excel'
> >
> > Thanks
>
>|||Maybe SQL Server Express combined with MS Access front-ends is the answer.
SS Express is free.
Randall Arnold
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:49490C53-3ADC-418F-8E8F-A7468A98DEE4@.microsoft.com...
> The company is not using the system to it's fullest potential. The users
> are
> not computer savvy and would prefer a more simple system ie: Access. They
> don't want to be paying the fees associated to a program they don't use.
> They have 7 years of data they need to access and I have to figure out
> how.
> Once we access the data and can retrieve the reports and pictures we won't
> be
> using the system. We want to transfer it to Access.
> Thanks
> "Keith Kratochvil" wrote:
>> You are taking a big step backward going from SQL Server to MS Access and
>> an
>> even bigger step if you go to Excel.
>> Microsoft SQL Server is an enterprise level relational database
>> management
>> system.
>> Microsoft Access is a database engine but it is not quite enterprise
>> level.
>> MS Excel is can be used to display information to management types and
>> create pretty reports, but it is by no means an enterprise storage
>> technology.
>>
>> IF your host sends you the correct information -- backup files created
>> via
>> the T-SQL BACKUP command OR database and log files after they ran
>> sp_detach_db -- you should be able to restore the database(s) to a SQL
>> Server in your environment.
>>
>> SQL Server does not have "files" (like Excel). It is more similar to MS
>> Access in that it has tables within one container (a database).
>>
>> --
>> Keith Kratochvil
>>
>> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
>> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>> >I currently have a database through a company that has been upkeeping
>> >SQL
>> >and
>> > storing data. I am cancelling subscription and want to retrieve data.
>> > They
>> > are sending me a backup DVD with all the files. How easy is it to use
>> > Microsoft SQL and can the files be transfered to another program such
>> > as
>> > Access or Excel'
>> >
>> > Thanks
>>|||Eddie,
You can certainly use Access as the front-end program for
your users, even if you maintain the data in SQL Server.
SQL Server in fact has no front-end, really - just a set of
management tools, so you have many options for your
users.
Since no one has mentioned it, don't overlook the Workgroup
Edition of SQL Server, which might be good for your needs.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Steve Kass
Drew University
Eddie wrote:
>The company is not using the system to it's fullest potential. The users are
>not computer savvy and would prefer a more simple system ie: Access. They
>don't want to be paying the fees associated to a program they don't use.
>They have 7 years of data they need to access and I have to figure out how.
>Once we access the data and can retrieve the reports and pictures we won't be
>using the system. We want to transfer it to Access.
>Thanks
>"Norman Yuan" wrote:
>
>>Are you saying that you have data stored in a SQL Server database, which is
>>hosted by other company, and you now want to sotre your data by yourself? If
>>so, the best way to do is to set up your own SQL Server, have you data on
>>the other SQL Server backed up and restore it on your own SQL Server. (or
>>use detach/attach database from/to SQL Server).
>>There are different edition of SQL Server, from very expensive Enterprise
>>Edition, to free version of SQL Server Express/MSDE. If your data value is
>>not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
>>course, some basic knowledge on SQL Server is required (I mean a bit more
>>and complicated that required by using Access).
>>If you want those data being transferred to Access DB, then you can ask your
>>SQL Server host to export it to a *.mdb file. However, in general, only data
>>can be transferred, server object used in that database (view, sp... they
>>may contain critical logics for using the database) would not be
>>transferred. So, you would need to build a sort of front end app inorder to
>>use your data. Unless the only thing you need is the data.
>>"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
>>news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>>
>>I currently have a database through a company that has been upkeeping SQL
>>and
>>storing data. I am cancelling subscription and want to retrieve data.
>>They
>>are sending me a backup DVD with all the files. How easy is it to use
>>Microsoft SQL and can the files be transfered to another program such as
>>Access or Excel'
>>Thanks
>>
>>|||So, summarize what you want:
1. You have data stored in database of someone's SQL Server;
2. You need to get all data out in this database and svae them in some
formats you choose;
3. You do not need application related server objects/logics in the database
(views, stored procedures, UDFs) once you retrieved the data;
4. The SQL Server host would not do the data retrieving for you. They can
only give you the backup or data file of the database.
Since you want to transfer data from SQL Server to Access (more accurately,
Jet database), there may be some degree of data or data type or data
accuracy loss because of the differences of the two data engine.
Here is what I would do:
1. Get full backup or detached database file (latter would be better);
2. Install a MSDE, which is free version of SQL Server, if the data file of
the database (*.mdf) is less than 2GB.
3. Restore/attach the databse to MSDE.
4. Use Access as tool to connect to MSDE and start retrieve data. You can
create an Access ADP project to use as MSDE front end UI. Then you can open
each table to export, or write some macro/VBA code to retireve specific data
and output to specific format.
5. Since I have the database on my onw, no-cost MSDE engine, I can try and
try until satisfied totally (of course do it on a copy of the data).
6, Do the final retrieving and then uninstall the MSDE.
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:E426270B-5851-456C-B190-1D747BAFA433@.microsoft.com...
> The company is not using the system to it's fullest potential. The users
> are
> not computer savvy and would prefer a more simple system ie: Access. They
> don't want to be paying the fees associated to a program they don't use.
> They have 7 years of data they need to access and I have to figure out
> how.
> Once we access the data and can retrieve the reports and pictures we won't
> be
> using the system. We want to transfer it to Access.
> Thanks
> "Norman Yuan" wrote:
>> Are you saying that you have data stored in a SQL Server database, which
>> is
>> hosted by other company, and you now want to sotre your data by yourself?
>> If
>> so, the best way to do is to set up your own SQL Server, have you data on
>> the other SQL Server backed up and restore it on your own SQL Server. (or
>> use detach/attach database from/to SQL Server).
>> There are different edition of SQL Server, from very expensive Enterprise
>> Edition, to free version of SQL Server Express/MSDE. If your data value
>> is
>> not so big (2G or 4G), you can use MSDE or SQL Server Express for free.
>> Of
>> course, some basic knowledge on SQL Server is required (I mean a bit more
>> and complicated that required by using Access).
>> If you want those data being transferred to Access DB, then you can ask
>> your
>> SQL Server host to export it to a *.mdb file. However, in general, only
>> data
>> can be transferred, server object used in that database (view, sp... they
>> may contain critical logics for using the database) would not be
>> transferred. So, you would need to build a sort of front end app inorder
>> to
>> use your data. Unless the only thing you need is the data.
>> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
>> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>> >I currently have a database through a company that has been upkeeping
>> >SQL
>> >and
>> > storing data. I am cancelling subscription and want to retrieve data.
>> > They
>> > are sending me a backup DVD with all the files. How easy is it to use
>> > Microsoft SQL and can the files be transfered to another program such
>> > as
>> > Access or Excel'
>> >
>> > Thanks
>>
storing data. I am cancelling subscription and want to retrieve data. They
are sending me a backup DVD with all the files. How easy is it to use
Microsoft SQL and can the files be transfered to another program such as
Access or Excel'
ThanksAre you saying that you have data stored in a SQL Server database, which is
hosted by other company, and you now want to sotre your data by yourself? If
so, the best way to do is to set up your own SQL Server, have you data on
the other SQL Server backed up and restore it on your own SQL Server. (or
use detach/attach database from/to SQL Server).
There are different edition of SQL Server, from very expensive Enterprise
Edition, to free version of SQL Server Express/MSDE. If your data value is
not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
course, some basic knowledge on SQL Server is required (I mean a bit more
and complicated that required by using Access).
If you want those data being transferred to Access DB, then you can ask your
SQL Server host to export it to a *.mdb file. However, in general, only data
can be transferred, server object used in that database (view, sp... they
may contain critical logics for using the database) would not be
transferred. So, you would need to build a sort of front end app inorder to
use your data. Unless the only thing you need is the data.
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>I currently have a database through a company that has been upkeeping SQL
>and
> storing data. I am cancelling subscription and want to retrieve data.
> They
> are sending me a backup DVD with all the files. How easy is it to use
> Microsoft SQL and can the files be transfered to another program such as
> Access or Excel'
> Thanks|||You are taking a big step backward going from SQL Server to MS Access and an
even bigger step if you go to Excel.
Microsoft SQL Server is an enterprise level relational database management
system.
Microsoft Access is a database engine but it is not quite enterprise level.
MS Excel is can be used to display information to management types and
create pretty reports, but it is by no means an enterprise storage
technology.
IF your host sends you the correct information -- backup files created via
the T-SQL BACKUP command OR database and log files after they ran
sp_detach_db -- you should be able to restore the database(s) to a SQL
Server in your environment.
SQL Server does not have "files" (like Excel). It is more similar to MS
Access in that it has tables within one container (a database).
Keith Kratochvil
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>I currently have a database through a company that has been upkeeping SQL
>and
> storing data. I am cancelling subscription and want to retrieve data.
> They
> are sending me a backup DVD with all the files. How easy is it to use
> Microsoft SQL and can the files be transfered to another program such as
> Access or Excel'
> Thanks|||The company is not using the system to it's fullest potential. The users are
not computer savvy and would prefer a more simple system ie: Access. They
don't want to be paying the fees associated to a program they don't use.
They have 7 years of data they need to access and I have to figure out how.
Once we access the data and can retrieve the reports and pictures we won't be
using the system. We want to transfer it to Access.
Thanks
"Norman Yuan" wrote:
> Are you saying that you have data stored in a SQL Server database, which is
> hosted by other company, and you now want to sotre your data by yourself? If
> so, the best way to do is to set up your own SQL Server, have you data on
> the other SQL Server backed up and restore it on your own SQL Server. (or
> use detach/attach database from/to SQL Server).
> There are different edition of SQL Server, from very expensive Enterprise
> Edition, to free version of SQL Server Express/MSDE. If your data value is
> not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
> course, some basic knowledge on SQL Server is required (I mean a bit more
> and complicated that required by using Access).
> If you want those data being transferred to Access DB, then you can ask your
> SQL Server host to export it to a *.mdb file. However, in general, only data
> can be transferred, server object used in that database (view, sp... they
> may contain critical logics for using the database) would not be
> transferred. So, you would need to build a sort of front end app inorder to
> use your data. Unless the only thing you need is the data.
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
> >I currently have a database through a company that has been upkeeping SQL
> >and
> > storing data. I am cancelling subscription and want to retrieve data.
> > They
> > are sending me a backup DVD with all the files. How easy is it to use
> > Microsoft SQL and can the files be transfered to another program such as
> > Access or Excel'
> >
> > Thanks
>
>|||The company is not using the system to it's fullest potential. The users are
not computer savvy and would prefer a more simple system ie: Access. They
don't want to be paying the fees associated to a program they don't use.
They have 7 years of data they need to access and I have to figure out how.
Once we access the data and can retrieve the reports and pictures we won't be
using the system. We want to transfer it to Access.
Thanks
"Keith Kratochvil" wrote:
> You are taking a big step backward going from SQL Server to MS Access and an
> even bigger step if you go to Excel.
> Microsoft SQL Server is an enterprise level relational database management
> system.
> Microsoft Access is a database engine but it is not quite enterprise level.
> MS Excel is can be used to display information to management types and
> create pretty reports, but it is by no means an enterprise storage
> technology.
>
> IF your host sends you the correct information -- backup files created via
> the T-SQL BACKUP command OR database and log files after they ran
> sp_detach_db -- you should be able to restore the database(s) to a SQL
> Server in your environment.
>
> SQL Server does not have "files" (like Excel). It is more similar to MS
> Access in that it has tables within one container (a database).
>
> --
> Keith Kratochvil
>
> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
> >I currently have a database through a company that has been upkeeping SQL
> >and
> > storing data. I am cancelling subscription and want to retrieve data.
> > They
> > are sending me a backup DVD with all the files. How easy is it to use
> > Microsoft SQL and can the files be transfered to another program such as
> > Access or Excel'
> >
> > Thanks
>
>|||Maybe SQL Server Express combined with MS Access front-ends is the answer.
SS Express is free.
Randall Arnold
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:49490C53-3ADC-418F-8E8F-A7468A98DEE4@.microsoft.com...
> The company is not using the system to it's fullest potential. The users
> are
> not computer savvy and would prefer a more simple system ie: Access. They
> don't want to be paying the fees associated to a program they don't use.
> They have 7 years of data they need to access and I have to figure out
> how.
> Once we access the data and can retrieve the reports and pictures we won't
> be
> using the system. We want to transfer it to Access.
> Thanks
> "Keith Kratochvil" wrote:
>> You are taking a big step backward going from SQL Server to MS Access and
>> an
>> even bigger step if you go to Excel.
>> Microsoft SQL Server is an enterprise level relational database
>> management
>> system.
>> Microsoft Access is a database engine but it is not quite enterprise
>> level.
>> MS Excel is can be used to display information to management types and
>> create pretty reports, but it is by no means an enterprise storage
>> technology.
>>
>> IF your host sends you the correct information -- backup files created
>> via
>> the T-SQL BACKUP command OR database and log files after they ran
>> sp_detach_db -- you should be able to restore the database(s) to a SQL
>> Server in your environment.
>>
>> SQL Server does not have "files" (like Excel). It is more similar to MS
>> Access in that it has tables within one container (a database).
>>
>> --
>> Keith Kratochvil
>>
>> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
>> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>> >I currently have a database through a company that has been upkeeping
>> >SQL
>> >and
>> > storing data. I am cancelling subscription and want to retrieve data.
>> > They
>> > are sending me a backup DVD with all the files. How easy is it to use
>> > Microsoft SQL and can the files be transfered to another program such
>> > as
>> > Access or Excel'
>> >
>> > Thanks
>>|||Eddie,
You can certainly use Access as the front-end program for
your users, even if you maintain the data in SQL Server.
SQL Server in fact has no front-end, really - just a set of
management tools, so you have many options for your
users.
Since no one has mentioned it, don't overlook the Workgroup
Edition of SQL Server, which might be good for your needs.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Steve Kass
Drew University
Eddie wrote:
>The company is not using the system to it's fullest potential. The users are
>not computer savvy and would prefer a more simple system ie: Access. They
>don't want to be paying the fees associated to a program they don't use.
>They have 7 years of data they need to access and I have to figure out how.
>Once we access the data and can retrieve the reports and pictures we won't be
>using the system. We want to transfer it to Access.
>Thanks
>"Norman Yuan" wrote:
>
>>Are you saying that you have data stored in a SQL Server database, which is
>>hosted by other company, and you now want to sotre your data by yourself? If
>>so, the best way to do is to set up your own SQL Server, have you data on
>>the other SQL Server backed up and restore it on your own SQL Server. (or
>>use detach/attach database from/to SQL Server).
>>There are different edition of SQL Server, from very expensive Enterprise
>>Edition, to free version of SQL Server Express/MSDE. If your data value is
>>not so big (2G or 4G), you can use MSDE or SQL Server Express for free. Of
>>course, some basic knowledge on SQL Server is required (I mean a bit more
>>and complicated that required by using Access).
>>If you want those data being transferred to Access DB, then you can ask your
>>SQL Server host to export it to a *.mdb file. However, in general, only data
>>can be transferred, server object used in that database (view, sp... they
>>may contain critical logics for using the database) would not be
>>transferred. So, you would need to build a sort of front end app inorder to
>>use your data. Unless the only thing you need is the data.
>>"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
>>news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>>
>>I currently have a database through a company that has been upkeeping SQL
>>and
>>storing data. I am cancelling subscription and want to retrieve data.
>>They
>>are sending me a backup DVD with all the files. How easy is it to use
>>Microsoft SQL and can the files be transfered to another program such as
>>Access or Excel'
>>Thanks
>>
>>|||So, summarize what you want:
1. You have data stored in database of someone's SQL Server;
2. You need to get all data out in this database and svae them in some
formats you choose;
3. You do not need application related server objects/logics in the database
(views, stored procedures, UDFs) once you retrieved the data;
4. The SQL Server host would not do the data retrieving for you. They can
only give you the backup or data file of the database.
Since you want to transfer data from SQL Server to Access (more accurately,
Jet database), there may be some degree of data or data type or data
accuracy loss because of the differences of the two data engine.
Here is what I would do:
1. Get full backup or detached database file (latter would be better);
2. Install a MSDE, which is free version of SQL Server, if the data file of
the database (*.mdf) is less than 2GB.
3. Restore/attach the databse to MSDE.
4. Use Access as tool to connect to MSDE and start retrieve data. You can
create an Access ADP project to use as MSDE front end UI. Then you can open
each table to export, or write some macro/VBA code to retireve specific data
and output to specific format.
5. Since I have the database on my onw, no-cost MSDE engine, I can try and
try until satisfied totally (of course do it on a copy of the data).
6, Do the final retrieving and then uninstall the MSDE.
"Eddie" <Eddie@.discussions.microsoft.com> wrote in message
news:E426270B-5851-456C-B190-1D747BAFA433@.microsoft.com...
> The company is not using the system to it's fullest potential. The users
> are
> not computer savvy and would prefer a more simple system ie: Access. They
> don't want to be paying the fees associated to a program they don't use.
> They have 7 years of data they need to access and I have to figure out
> how.
> Once we access the data and can retrieve the reports and pictures we won't
> be
> using the system. We want to transfer it to Access.
> Thanks
> "Norman Yuan" wrote:
>> Are you saying that you have data stored in a SQL Server database, which
>> is
>> hosted by other company, and you now want to sotre your data by yourself?
>> If
>> so, the best way to do is to set up your own SQL Server, have you data on
>> the other SQL Server backed up and restore it on your own SQL Server. (or
>> use detach/attach database from/to SQL Server).
>> There are different edition of SQL Server, from very expensive Enterprise
>> Edition, to free version of SQL Server Express/MSDE. If your data value
>> is
>> not so big (2G or 4G), you can use MSDE or SQL Server Express for free.
>> Of
>> course, some basic knowledge on SQL Server is required (I mean a bit more
>> and complicated that required by using Access).
>> If you want those data being transferred to Access DB, then you can ask
>> your
>> SQL Server host to export it to a *.mdb file. However, in general, only
>> data
>> can be transferred, server object used in that database (view, sp... they
>> may contain critical logics for using the database) would not be
>> transferred. So, you would need to build a sort of front end app inorder
>> to
>> use your data. Unless the only thing you need is the data.
>> "Eddie" <Eddie@.discussions.microsoft.com> wrote in message
>> news:389AA3B8-1996-487C-A65D-29F4E5404246@.microsoft.com...
>> >I currently have a database through a company that has been upkeeping
>> >SQL
>> >and
>> > storing data. I am cancelling subscription and want to retrieve data.
>> > They
>> > are sending me a backup DVD with all the files. How easy is it to use
>> > Microsoft SQL and can the files be transfered to another program such
>> > as
>> > Access or Excel'
>> >
>> > Thanks
>>
Wednesday, March 7, 2012
publish sql on the internet
Hi,
I need to publish my computer on the internet which is on a company network.
in the network we have a server that connects to the internet and gives
internet access to all the company computers.
I'm running a sql server on my compuer and I need to access it through the
internet.
Also, I need to know how do I secure the connection to my
server/computer/company.
Any info on this would be great!!Tomer,
Don't cross post, answered in .server.
You really MUST read this page:
http://www.aspfaq.com/5003
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> I need to publish my computer on the internet which is on a company networ
k.
> in the network we have a server that connects to the internet and gives
> internet access to all the company computers.
> I'm running a sql server on my compuer and I need to access it through the
> internet.
> Also, I need to know how do I secure the connection to my
> server/computer/company.
> Any info on this would be great!!
>
I need to publish my computer on the internet which is on a company network.
in the network we have a server that connects to the internet and gives
internet access to all the company computers.
I'm running a sql server on my compuer and I need to access it through the
internet.
Also, I need to know how do I secure the connection to my
server/computer/company.
Any info on this would be great!!Tomer,
Don't cross post, answered in .server.
You really MUST read this page:
http://www.aspfaq.com/5003
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> I need to publish my computer on the internet which is on a company networ
k.
> in the network we have a server that connects to the internet and gives
> internet access to all the company computers.
> I'm running a sql server on my compuer and I need to access it through the
> internet.
> Also, I need to know how do I secure the connection to my
> server/computer/company.
> Any info on this would be great!!
>
Saturday, February 25, 2012
Publish Sql on the internet
Hi,
I need to publish my computer on the internet which is on a company network.
in the network we have a server that connects to the internet and gives
internet access to all the company computers.
I'm running a sql server on my compuer and I need to access it through the
internet.
Also, I need to know how do I secure the connection to my
server/computer/company.
Any info on this would be great!!
Tomer,
I had a bit of trouble understanding what you are asking, I will recap.
You have a corporate network connected to the internet via a proxy
server (let's call this PROXY1). You want to "publish" your computer on
the internet, which resides behind PROXY1. What do you mean by
"publish"? Is it a web site, an FTP site, a database, remote desktop
connection, what?
You are running SQL Server on "my computer". Is this in the corporate
network or on the internet at home? Please clarify these points very
carefully (take a bit of time) as they will have a significant bearing
on the accuracy of the responses you will get.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> I need to publish my computer on the internet which is on a company network.
> in the network we have a server that connects to the internet and gives
> internet access to all the company computers.
> I'm running a sql server on my compuer and I need to access it through the
> internet.
> Also, I need to know how do I secure the connection to my
> server/computer/company.
> Any info on this would be great!!
>
|||Hi,
My computer is part of the company computer network and connects to the
internet through the company server which connects to the internet with an
adsl modem installed on it.
I have a sql server 2000 installed on my computer and I wish to access it
from 'outside' through the internet and access its databases.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Tomer,
> I had a bit of trouble understanding what you are asking, I will recap.
> You have a corporate network connected to the internet via a proxy
> server (let's call this PROXY1). You want to "publish" your computer on
> the internet, which resides behind PROXY1. What do you mean by
> "publish"? Is it a web site, an FTP site, a database, remote desktop
> connection, what?
> You are running SQL Server on "my computer". Is this in the corporate
> network or on the internet at home? Please clarify these points very
> carefully (take a bit of time) as they will have a significant bearing
> on the accuracy of the responses you will get.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
network.[vbcol=seagreen]
the[vbcol=seagreen]
|||Tomer,
You will need to use NAT to allow your computer to act as a server. I
would only do this sort of thing at home and never on a corporate network.
On a corporate network you should have a demilitarised zone (DMZ) that
allows incoming connections from the internet. I really do not recommend
allow people from the public internet to connect directly to your LAN,
you are asking for trouble. The DMZ should not be able to initiate
connections to your LAN.
I would go further and not even allow any form of direct access to a
database server from the internet. Use a web server in a DMZ to connect
to your db server (also in a separate DMZ) to serve information. If you
need to manage a SQL Server from the internet you could use the web
administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
(http://www.mylittletools.net).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> My computer is part of the company computer network and connects to the
> internet through the company server which connects to the internet with an
> adsl modem installed on it.
> I have a sql server 2000 installed on my computer and I wish to access it
> from 'outside' through the internet and access its databases.
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...
>
> network.
>
> the
>
>
|||Hi,
First thing, thanks alot for the info! I know that this is a problematic
issue in security, but I need to connect a pocket pc device with a gprs
modem directly to the sql server, and I'd rather not use a web service
application.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OOIKLZsfEHA.1424@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Tomer,
> You will need to use NAT to allow your computer to act as a server. I
> would only do this sort of thing at home and never on a corporate network.
> On a corporate network you should have a demilitarised zone (DMZ) that
> allows incoming connections from the internet. I really do not recommend
> allow people from the public internet to connect directly to your LAN,
> you are asking for trouble. The DMZ should not be able to initiate
> connections to your LAN.
> I would go further and not even allow any form of direct access to a
> database server from the internet. Use a web server in a DMZ to connect
> to your db server (also in a separate DMZ) to serve information. If you
> need to manage a SQL Server from the internet you could use the web
> administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
> (http://www.mylittletools.net).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
an[vbcol=seagreen]
it[vbcol=seagreen]
|||OK,
What you need to do is NOT allow connections into your LAN. Create a DMZ
and place the SQL Server there. Do not allow the DMZ to initiate
connections into the LAN. Only allow connections from the LAN TO the DMZ.
Do not allow SQL Server to connect to anything else on your network.
Remember, if this machine is compromised, you could be in trouble. On
the firewall, only open one port to the SQL Server, and make sure this
is not 1433. Make it a high port number such as 56378 (or whatever).
Ensure SQL Server is listening on this port.
This will put you out of range of port scanners that are only looking
for common ports such as 139, 1433, etc, however will not protect you
from someone scanning every port on your machine, but then there are
intrusion detection tools available to protect you from this.
Another way to do this is to use a VPN tunnel from the client on the
internet, through a VPN server in a DMZ on your corporate network, and
then you can use the entire LAN. This might be easier to set up and
configure, then again it might not.
Whatever you do, do not allow direct connections from the public
internet, unencrypted into your LAN.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> First thing, thanks alot for the info! I know that this is a problematic
> issue in security, but I need to connect a pocket pc device with a gprs
> modem directly to the sql server, and I'd rather not use a web service
> application.
>
|||Thanks a bunch!! this helps alot
Tomer.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u$IWGX4fEHA.632@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> OK,
> What you need to do is NOT allow connections into your LAN. Create a DMZ
> and place the SQL Server there. Do not allow the DMZ to initiate
> connections into the LAN. Only allow connections from the LAN TO the DMZ.
> Do not allow SQL Server to connect to anything else on your network.
> Remember, if this machine is compromised, you could be in trouble. On
> the firewall, only open one port to the SQL Server, and make sure this
> is not 1433. Make it a high port number such as 56378 (or whatever).
> Ensure SQL Server is listening on this port.
> This will put you out of range of port scanners that are only looking
> for common ports such as 139, 1433, etc, however will not protect you
> from someone scanning every port on your machine, but then there are
> intrusion detection tools available to protect you from this.
> Another way to do this is to use a VPN tunnel from the client on the
> internet, through a VPN server in a DMZ on your corporate network, and
> then you can use the entire LAN. This might be easier to set up and
> configure, then again it might not.
> Whatever you do, do not allow direct connections from the public
> internet, unencrypted into your LAN.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
I need to publish my computer on the internet which is on a company network.
in the network we have a server that connects to the internet and gives
internet access to all the company computers.
I'm running a sql server on my compuer and I need to access it through the
internet.
Also, I need to know how do I secure the connection to my
server/computer/company.
Any info on this would be great!!
Tomer,
I had a bit of trouble understanding what you are asking, I will recap.
You have a corporate network connected to the internet via a proxy
server (let's call this PROXY1). You want to "publish" your computer on
the internet, which resides behind PROXY1. What do you mean by
"publish"? Is it a web site, an FTP site, a database, remote desktop
connection, what?
You are running SQL Server on "my computer". Is this in the corporate
network or on the internet at home? Please clarify these points very
carefully (take a bit of time) as they will have a significant bearing
on the accuracy of the responses you will get.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> I need to publish my computer on the internet which is on a company network.
> in the network we have a server that connects to the internet and gives
> internet access to all the company computers.
> I'm running a sql server on my compuer and I need to access it through the
> internet.
> Also, I need to know how do I secure the connection to my
> server/computer/company.
> Any info on this would be great!!
>
|||Hi,
My computer is part of the company computer network and connects to the
internet through the company server which connects to the internet with an
adsl modem installed on it.
I have a sql server 2000 installed on my computer and I wish to access it
from 'outside' through the internet and access its databases.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Tomer,
> I had a bit of trouble understanding what you are asking, I will recap.
> You have a corporate network connected to the internet via a proxy
> server (let's call this PROXY1). You want to "publish" your computer on
> the internet, which resides behind PROXY1. What do you mean by
> "publish"? Is it a web site, an FTP site, a database, remote desktop
> connection, what?
> You are running SQL Server on "my computer". Is this in the corporate
> network or on the internet at home? Please clarify these points very
> carefully (take a bit of time) as they will have a significant bearing
> on the accuracy of the responses you will get.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
network.[vbcol=seagreen]
the[vbcol=seagreen]
|||Tomer,
You will need to use NAT to allow your computer to act as a server. I
would only do this sort of thing at home and never on a corporate network.
On a corporate network you should have a demilitarised zone (DMZ) that
allows incoming connections from the internet. I really do not recommend
allow people from the public internet to connect directly to your LAN,
you are asking for trouble. The DMZ should not be able to initiate
connections to your LAN.
I would go further and not even allow any form of direct access to a
database server from the internet. Use a web server in a DMZ to connect
to your db server (also in a separate DMZ) to serve information. If you
need to manage a SQL Server from the internet you could use the web
administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
(http://www.mylittletools.net).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> My computer is part of the company computer network and connects to the
> internet through the company server which connects to the internet with an
> adsl modem installed on it.
> I have a sql server 2000 installed on my computer and I wish to access it
> from 'outside' through the internet and access its databases.
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...
>
> network.
>
> the
>
>
|||Hi,
First thing, thanks alot for the info! I know that this is a problematic
issue in security, but I need to connect a pocket pc device with a gprs
modem directly to the sql server, and I'd rather not use a web service
application.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OOIKLZsfEHA.1424@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Tomer,
> You will need to use NAT to allow your computer to act as a server. I
> would only do this sort of thing at home and never on a corporate network.
> On a corporate network you should have a demilitarised zone (DMZ) that
> allows incoming connections from the internet. I really do not recommend
> allow people from the public internet to connect directly to your LAN,
> you are asking for trouble. The DMZ should not be able to initiate
> connections to your LAN.
> I would go further and not even allow any form of direct access to a
> database server from the internet. Use a web server in a DMZ to connect
> to your db server (also in a separate DMZ) to serve information. If you
> need to manage a SQL Server from the internet you could use the web
> administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
> (http://www.mylittletools.net).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
an[vbcol=seagreen]
it[vbcol=seagreen]
|||OK,
What you need to do is NOT allow connections into your LAN. Create a DMZ
and place the SQL Server there. Do not allow the DMZ to initiate
connections into the LAN. Only allow connections from the LAN TO the DMZ.
Do not allow SQL Server to connect to anything else on your network.
Remember, if this machine is compromised, you could be in trouble. On
the firewall, only open one port to the SQL Server, and make sure this
is not 1433. Make it a high port number such as 56378 (or whatever).
Ensure SQL Server is listening on this port.
This will put you out of range of port scanners that are only looking
for common ports such as 139, 1433, etc, however will not protect you
from someone scanning every port on your machine, but then there are
intrusion detection tools available to protect you from this.
Another way to do this is to use a VPN tunnel from the client on the
internet, through a VPN server in a DMZ on your corporate network, and
then you can use the entire LAN. This might be easier to set up and
configure, then again it might not.
Whatever you do, do not allow direct connections from the public
internet, unencrypted into your LAN.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> First thing, thanks alot for the info! I know that this is a problematic
> issue in security, but I need to connect a pocket pc device with a gprs
> modem directly to the sql server, and I'd rather not use a web service
> application.
>
|||Thanks a bunch!! this helps alot
Tomer.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u$IWGX4fEHA.632@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> OK,
> What you need to do is NOT allow connections into your LAN. Create a DMZ
> and place the SQL Server there. Do not allow the DMZ to initiate
> connections into the LAN. Only allow connections from the LAN TO the DMZ.
> Do not allow SQL Server to connect to anything else on your network.
> Remember, if this machine is compromised, you could be in trouble. On
> the firewall, only open one port to the SQL Server, and make sure this
> is not 1433. Make it a high port number such as 56378 (or whatever).
> Ensure SQL Server is listening on this port.
> This will put you out of range of port scanners that are only looking
> for common ports such as 139, 1433, etc, however will not protect you
> from someone scanning every port on your machine, but then there are
> intrusion detection tools available to protect you from this.
> Another way to do this is to use a VPN tunnel from the client on the
> internet, through a VPN server in a DMZ on your corporate network, and
> then you can use the entire LAN. This might be easier to set up and
> configure, then again it might not.
> Whatever you do, do not allow direct connections from the public
> internet, unencrypted into your LAN.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
Publish Sql on the internet
Hi,
I need to publish my computer on the internet which is on a company network.
in the network we have a server that connects to the internet and gives
internet access to all the company computers.
I'm running a sql server on my compuer and I need to access it through the
internet.
Also, I need to know how do I secure the connection to my
server/computer/company.
Any info on this would be great!!Tomer,
I had a bit of trouble understanding what you are asking, I will recap.
You have a corporate network connected to the internet via a proxy
server (let's call this PROXY1). You want to "publish" your computer on
the internet, which resides behind PROXY1. What do you mean by
"publish"? Is it a web site, an FTP site, a database, remote desktop
connection, what?
You are running SQL Server on "my computer". Is this in the corporate
network or on the internet at home? Please clarify these points very
carefully (take a bit of time) as they will have a significant bearing
on the accuracy of the responses you will get.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> I need to publish my computer on the internet which is on a company networ
k.
> in the network we have a server that connects to the internet and gives
> internet access to all the company computers.
> I'm running a sql server on my compuer and I need to access it through the
> internet.
> Also, I need to know how do I secure the connection to my
> server/computer/company.
> Any info on this would be great!!
>|||Hi,
My computer is part of the company computer network and connects to the
internet through the company server which connects to the internet with an
adsl modem installed on it.
I have a sql server 2000 installed on my computer and I wish to access it
from 'outside' through the internet and access its databases.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Tomer,
> I had a bit of trouble understanding what you are asking, I will recap.
> You have a corporate network connected to the internet via a proxy
> server (let's call this PROXY1). You want to "publish" your computer on
> the internet, which resides behind PROXY1. What do you mean by
> "publish"? Is it a web site, an FTP site, a database, remote desktop
> connection, what?
> You are running SQL Server on "my computer". Is this in the corporate
> network or on the internet at home? Please clarify these points very
> carefully (take a bit of time) as they will have a significant bearing
> on the accuracy of the responses you will get.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
network.[vbcol=seagreen]
the[vbcol=seagreen]|||Tomer,
You will need to use NAT to allow your computer to act as a server. I
would only do this sort of thing at home and never on a corporate network.
On a corporate network you should have a demilitarised zone (DMZ) that
allows incoming connections from the internet. I really do not recommend
allow people from the public internet to connect directly to your LAN,
you are asking for trouble. The DMZ should not be able to initiate
connections to your LAN.
I would go further and not even allow any form of direct access to a
database server from the internet. Use a web server in a DMZ to connect
to your db server (also in a separate DMZ) to serve information. If you
need to manage a SQL Server from the internet you could use the web
administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
(http://www.mylittletools.net).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> My computer is part of the company computer network and connects to the
> internet through the company server which connects to the internet with an
> adsl modem installed on it.
> I have a sql server 2000 installed on my computer and I wish to access it
> from 'outside' through the internet and access its databases.
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...
>
> network.
>
> the
>
>
>|||Hi,
First thing, thanks alot for the info! I know that this is a problematic
issue in security, but I need to connect a pocket pc device with a gprs
modem directly to the sql server, and I'd rather not use a web service
application.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OOIKLZsfEHA.1424@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Tomer,
> You will need to use NAT to allow your computer to act as a server. I
> would only do this sort of thing at home and never on a corporate network.
> On a corporate network you should have a demilitarised zone (DMZ) that
> allows incoming connections from the internet. I really do not recommend
> allow people from the public internet to connect directly to your LAN,
> you are asking for trouble. The DMZ should not be able to initiate
> connections to your LAN.
> I would go further and not even allow any form of direct access to a
> database server from the internet. Use a web server in a DMZ to connect
> to your db server (also in a separate DMZ) to serve information. If you
> need to manage a SQL Server from the internet you could use the web
> administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
> (http://www.mylittletools.net).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
an[vbcol=seagreen]
it[vbcol=seagreen]|||OK,
What you need to do is NOT allow connections into your LAN. Create a DMZ
and place the SQL Server there. Do not allow the DMZ to initiate
connections into the LAN. Only allow connections from the LAN TO the DMZ.
Do not allow SQL Server to connect to anything else on your network.
Remember, if this machine is compromised, you could be in trouble. On
the firewall, only open one port to the SQL Server, and make sure this
is not 1433. Make it a high port number such as 56378 (or whatever).
Ensure SQL Server is listening on this port.
This will put you out of range of port scanners that are only looking
for common ports such as 139, 1433, etc, however will not protect you
from someone scanning every port on your machine, but then there are
intrusion detection tools available to protect you from this.
Another way to do this is to use a VPN tunnel from the client on the
internet, through a VPN server in a DMZ on your corporate network, and
then you can use the entire LAN. This might be easier to set up and
configure, then again it might not.
Whatever you do, do not allow direct connections from the public
internet, unencrypted into your LAN.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> First thing, thanks alot for the info! I know that this is a problematic
> issue in security, but I need to connect a pocket pc device with a gprs
> modem directly to the sql server, and I'd rather not use a web service
> application.
>|||Thanks a bunch!! this helps alot
Tomer.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u$IWGX4fEHA.632@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> OK,
> What you need to do is NOT allow connections into your LAN. Create a DMZ
> and place the SQL Server there. Do not allow the DMZ to initiate
> connections into the LAN. Only allow connections from the LAN TO the DMZ.
> Do not allow SQL Server to connect to anything else on your network.
> Remember, if this machine is compromised, you could be in trouble. On
> the firewall, only open one port to the SQL Server, and make sure this
> is not 1433. Make it a high port number such as 56378 (or whatever).
> Ensure SQL Server is listening on this port.
> This will put you out of range of port scanners that are only looking
> for common ports such as 139, 1433, etc, however will not protect you
> from someone scanning every port on your machine, but then there are
> intrusion detection tools available to protect you from this.
> Another way to do this is to use a VPN tunnel from the client on the
> internet, through a VPN server in a DMZ on your corporate network, and
> then you can use the entire LAN. This might be easier to set up and
> configure, then again it might not.
> Whatever you do, do not allow direct connections from the public
> internet, unencrypted into your LAN.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
I need to publish my computer on the internet which is on a company network.
in the network we have a server that connects to the internet and gives
internet access to all the company computers.
I'm running a sql server on my compuer and I need to access it through the
internet.
Also, I need to know how do I secure the connection to my
server/computer/company.
Any info on this would be great!!Tomer,
I had a bit of trouble understanding what you are asking, I will recap.
You have a corporate network connected to the internet via a proxy
server (let's call this PROXY1). You want to "publish" your computer on
the internet, which resides behind PROXY1. What do you mean by
"publish"? Is it a web site, an FTP site, a database, remote desktop
connection, what?
You are running SQL Server on "my computer". Is this in the corporate
network or on the internet at home? Please clarify these points very
carefully (take a bit of time) as they will have a significant bearing
on the accuracy of the responses you will get.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> I need to publish my computer on the internet which is on a company networ
k.
> in the network we have a server that connects to the internet and gives
> internet access to all the company computers.
> I'm running a sql server on my compuer and I need to access it through the
> internet.
> Also, I need to know how do I secure the connection to my
> server/computer/company.
> Any info on this would be great!!
>|||Hi,
My computer is part of the company computer network and connects to the
internet through the company server which connects to the internet with an
adsl modem installed on it.
I have a sql server 2000 installed on my computer and I wish to access it
from 'outside' through the internet and access its databases.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Tomer,
> I had a bit of trouble understanding what you are asking, I will recap.
> You have a corporate network connected to the internet via a proxy
> server (let's call this PROXY1). You want to "publish" your computer on
> the internet, which resides behind PROXY1. What do you mean by
> "publish"? Is it a web site, an FTP site, a database, remote desktop
> connection, what?
> You are running SQL Server on "my computer". Is this in the corporate
> network or on the internet at home? Please clarify these points very
> carefully (take a bit of time) as they will have a significant bearing
> on the accuracy of the responses you will get.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
network.[vbcol=seagreen]
the[vbcol=seagreen]|||Tomer,
You will need to use NAT to allow your computer to act as a server. I
would only do this sort of thing at home and never on a corporate network.
On a corporate network you should have a demilitarised zone (DMZ) that
allows incoming connections from the internet. I really do not recommend
allow people from the public internet to connect directly to your LAN,
you are asking for trouble. The DMZ should not be able to initiate
connections to your LAN.
I would go further and not even allow any form of direct access to a
database server from the internet. Use a web server in a DMZ to connect
to your db server (also in a separate DMZ) to serve information. If you
need to manage a SQL Server from the internet you could use the web
administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
(http://www.mylittletools.net).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> My computer is part of the company computer network and connects to the
> internet through the company server which connects to the internet with an
> adsl modem installed on it.
> I have a sql server 2000 installed on my computer and I wish to access it
> from 'outside' through the internet and access its databases.
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...
>
> network.
>
> the
>
>
>|||Hi,
First thing, thanks alot for the info! I know that this is a problematic
issue in security, but I need to connect a pocket pc device with a gprs
modem directly to the sql server, and I'd rather not use a web service
application.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OOIKLZsfEHA.1424@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Tomer,
> You will need to use NAT to allow your computer to act as a server. I
> would only do this sort of thing at home and never on a corporate network.
> On a corporate network you should have a demilitarised zone (DMZ) that
> allows incoming connections from the internet. I really do not recommend
> allow people from the public internet to connect directly to your LAN,
> you are asking for trouble. The DMZ should not be able to initiate
> connections to your LAN.
> I would go further and not even allow any form of direct access to a
> database server from the internet. Use a web server in a DMZ to connect
> to your db server (also in a separate DMZ) to serve information. If you
> need to manage a SQL Server from the internet you could use the web
> administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
> (http://www.mylittletools.net).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
an[vbcol=seagreen]
it[vbcol=seagreen]|||OK,
What you need to do is NOT allow connections into your LAN. Create a DMZ
and place the SQL Server there. Do not allow the DMZ to initiate
connections into the LAN. Only allow connections from the LAN TO the DMZ.
Do not allow SQL Server to connect to anything else on your network.
Remember, if this machine is compromised, you could be in trouble. On
the firewall, only open one port to the SQL Server, and make sure this
is not 1433. Make it a high port number such as 56378 (or whatever).
Ensure SQL Server is listening on this port.
This will put you out of range of port scanners that are only looking
for common ports such as 139, 1433, etc, however will not protect you
from someone scanning every port on your machine, but then there are
intrusion detection tools available to protect you from this.
Another way to do this is to use a VPN tunnel from the client on the
internet, through a VPN server in a DMZ on your corporate network, and
then you can use the entire LAN. This might be easier to set up and
configure, then again it might not.
Whatever you do, do not allow direct connections from the public
internet, unencrypted into your LAN.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> First thing, thanks alot for the info! I know that this is a problematic
> issue in security, but I need to connect a pocket pc device with a gprs
> modem directly to the sql server, and I'd rather not use a web service
> application.
>|||Thanks a bunch!! this helps alot
Tomer.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u$IWGX4fEHA.632@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> OK,
> What you need to do is NOT allow connections into your LAN. Create a DMZ
> and place the SQL Server there. Do not allow the DMZ to initiate
> connections into the LAN. Only allow connections from the LAN TO the DMZ.
> Do not allow SQL Server to connect to anything else on your network.
> Remember, if this machine is compromised, you could be in trouble. On
> the firewall, only open one port to the SQL Server, and make sure this
> is not 1433. Make it a high port number such as 56378 (or whatever).
> Ensure SQL Server is listening on this port.
> This will put you out of range of port scanners that are only looking
> for common ports such as 139, 1433, etc, however will not protect you
> from someone scanning every port on your machine, but then there are
> intrusion detection tools available to protect you from this.
> Another way to do this is to use a VPN tunnel from the client on the
> internet, through a VPN server in a DMZ on your corporate network, and
> then you can use the entire LAN. This might be easier to set up and
> configure, then again it might not.
> Whatever you do, do not allow direct connections from the public
> internet, unencrypted into your LAN.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
Publish Sql on the internet
Hi,
I need to publish my computer on the internet which is on a company network.
in the network we have a server that connects to the internet and gives
internet access to all the company computers.
I'm running a sql server on my compuer and I need to access it through the
internet.
Also, I need to know how do I secure the connection to my
server/computer/company.
Any info on this would be great!!Tomer,
I had a bit of trouble understanding what you are asking, I will recap.
You have a corporate network connected to the internet via a proxy
server (let's call this PROXY1). You want to "publish" your computer on
the internet, which resides behind PROXY1. What do you mean by
"publish"? Is it a web site, an FTP site, a database, remote desktop
connection, what?
You are running SQL Server on "my computer". Is this in the corporate
network or on the internet at home? Please clarify these points very
carefully (take a bit of time) as they will have a significant bearing
on the accuracy of the responses you will get.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> I need to publish my computer on the internet which is on a company network.
> in the network we have a server that connects to the internet and gives
> internet access to all the company computers.
> I'm running a sql server on my compuer and I need to access it through the
> internet.
> Also, I need to know how do I secure the connection to my
> server/computer/company.
> Any info on this would be great!!
>|||Hi,
My computer is part of the company computer network and connects to the
internet through the company server which connects to the internet with an
adsl modem installed on it.
I have a sql server 2000 installed on my computer and I wish to access it
from 'outside' through the internet and access its databases.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...
> Tomer,
> I had a bit of trouble understanding what you are asking, I will recap.
> You have a corporate network connected to the internet via a proxy
> server (let's call this PROXY1). You want to "publish" your computer on
> the internet, which resides behind PROXY1. What do you mean by
> "publish"? Is it a web site, an FTP site, a database, remote desktop
> connection, what?
> You are running SQL Server on "my computer". Is this in the corporate
> network or on the internet at home? Please clarify these points very
> carefully (take a bit of time) as they will have a significant bearing
> on the accuracy of the responses you will get.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
> > Hi,
> > I need to publish my computer on the internet which is on a company
network.
> > in the network we have a server that connects to the internet and gives
> > internet access to all the company computers.
> > I'm running a sql server on my compuer and I need to access it through
the
> > internet.
> > Also, I need to know how do I secure the connection to my
> > server/computer/company.
> >
> > Any info on this would be great!!
> >
> >|||Tomer,
You will need to use NAT to allow your computer to act as a server. I
would only do this sort of thing at home and never on a corporate network.
On a corporate network you should have a demilitarised zone (DMZ) that
allows incoming connections from the internet. I really do not recommend
allow people from the public internet to connect directly to your LAN,
you are asking for trouble. The DMZ should not be able to initiate
connections to your LAN.
I would go further and not even allow any form of direct access to a
database server from the internet. Use a web server in a DMZ to connect
to your db server (also in a separate DMZ) to serve information. If you
need to manage a SQL Server from the internet you could use the web
administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
(http://www.mylittletools.net).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> My computer is part of the company computer network and connects to the
> internet through the company server which connects to the internet with an
> adsl modem installed on it.
> I have a sql server 2000 installed on my computer and I wish to access it
> from 'outside' through the internet and access its databases.
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...
>>Tomer,
>>I had a bit of trouble understanding what you are asking, I will recap.
>>You have a corporate network connected to the internet via a proxy
>>server (let's call this PROXY1). You want to "publish" your computer on
>>the internet, which resides behind PROXY1. What do you mean by
>>"publish"? Is it a web site, an FTP site, a database, remote desktop
>>connection, what?
>>You are running SQL Server on "my computer". Is this in the corporate
>>network or on the internet at home? Please clarify these points very
>>carefully (take a bit of time) as they will have a significant bearing
>>on the accuracy of the responses you will get.
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>Tomer wrote:
>>Hi,
>>I need to publish my computer on the internet which is on a company
> network.
>>in the network we have a server that connects to the internet and gives
>>internet access to all the company computers.
>>I'm running a sql server on my compuer and I need to access it through
> the
>>internet.
>>Also, I need to know how do I secure the connection to my
>>server/computer/company.
>>Any info on this would be great!!
>>
>
>|||Hi,
First thing, thanks alot for the info! I know that this is a problematic
issue in security, but I need to connect a pocket pc device with a gprs
modem directly to the sql server, and I'd rather not use a web service
application.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OOIKLZsfEHA.1424@.tk2msftngp13.phx.gbl...
> Tomer,
> You will need to use NAT to allow your computer to act as a server. I
> would only do this sort of thing at home and never on a corporate network.
> On a corporate network you should have a demilitarised zone (DMZ) that
> allows incoming connections from the internet. I really do not recommend
> allow people from the public internet to connect directly to your LAN,
> you are asking for trouble. The DMZ should not be able to initiate
> connections to your LAN.
> I would go further and not even allow any form of direct access to a
> database server from the internet. Use a web server in a DMZ to connect
> to your db server (also in a separate DMZ) to serve information. If you
> need to manage a SQL Server from the internet you could use the web
> administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
> (http://www.mylittletools.net).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
> > Hi,
> >
> > My computer is part of the company computer network and connects to the
> > internet through the company server which connects to the internet with
an
> > adsl modem installed on it.
> > I have a sql server 2000 installed on my computer and I wish to access
it
> > from 'outside' through the internet and access its databases.
> >
> >
> > "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> > news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...
> >
> >>Tomer,
> >>
> >>I had a bit of trouble understanding what you are asking, I will recap.
> >>You have a corporate network connected to the internet via a proxy
> >>server (let's call this PROXY1). You want to "publish" your computer on
> >>the internet, which resides behind PROXY1. What do you mean by
> >>"publish"? Is it a web site, an FTP site, a database, remote desktop
> >>connection, what?
> >>
> >>You are running SQL Server on "my computer". Is this in the corporate
> >>network or on the internet at home? Please clarify these points very
> >>carefully (take a bit of time) as they will have a significant bearing
> >>on the accuracy of the responses you will get.
> >>--
> >>Mark Allison, SQL Server MVP
> >>http://www.markallison.co.uk
> >>
> >>Looking for a SQL Server replication book?
> >>http://www.nwsu.com/0974973602.html
> >>
> >>
> >>
> >>Tomer wrote:
> >>
> >>Hi,
> >>I need to publish my computer on the internet which is on a company
> >
> > network.
> >
> >>in the network we have a server that connects to the internet and gives
> >>internet access to all the company computers.
> >>I'm running a sql server on my compuer and I need to access it through
> >
> > the
> >
> >>internet.
> >>Also, I need to know how do I secure the connection to my
> >>server/computer/company.
> >>
> >>Any info on this would be great!!
> >>
> >>
> >
> >
> >|||OK,
What you need to do is NOT allow connections into your LAN. Create a DMZ
and place the SQL Server there. Do not allow the DMZ to initiate
connections into the LAN. Only allow connections from the LAN TO the DMZ.
Do not allow SQL Server to connect to anything else on your network.
Remember, if this machine is compromised, you could be in trouble. On
the firewall, only open one port to the SQL Server, and make sure this
is not 1433. Make it a high port number such as 56378 (or whatever).
Ensure SQL Server is listening on this port.
This will put you out of range of port scanners that are only looking
for common ports such as 139, 1433, etc, however will not protect you
from someone scanning every port on your machine, but then there are
intrusion detection tools available to protect you from this.
Another way to do this is to use a VPN tunnel from the client on the
internet, through a VPN server in a DMZ on your corporate network, and
then you can use the entire LAN. This might be easier to set up and
configure, then again it might not.
Whatever you do, do not allow direct connections from the public
internet, unencrypted into your LAN.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> First thing, thanks alot for the info! I know that this is a problematic
> issue in security, but I need to connect a pocket pc device with a gprs
> modem directly to the sql server, and I'd rather not use a web service
> application.
>|||Thanks a bunch!! this helps alot
Tomer.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u$IWGX4fEHA.632@.TK2MSFTNGP12.phx.gbl...
> OK,
> What you need to do is NOT allow connections into your LAN. Create a DMZ
> and place the SQL Server there. Do not allow the DMZ to initiate
> connections into the LAN. Only allow connections from the LAN TO the DMZ.
> Do not allow SQL Server to connect to anything else on your network.
> Remember, if this machine is compromised, you could be in trouble. On
> the firewall, only open one port to the SQL Server, and make sure this
> is not 1433. Make it a high port number such as 56378 (or whatever).
> Ensure SQL Server is listening on this port.
> This will put you out of range of port scanners that are only looking
> for common ports such as 139, 1433, etc, however will not protect you
> from someone scanning every port on your machine, but then there are
> intrusion detection tools available to protect you from this.
> Another way to do this is to use a VPN tunnel from the client on the
> internet, through a VPN server in a DMZ on your corporate network, and
> then you can use the entire LAN. This might be easier to set up and
> configure, then again it might not.
> Whatever you do, do not allow direct connections from the public
> internet, unencrypted into your LAN.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
> > Hi,
> >
> > First thing, thanks alot for the info! I know that this is a problematic
> > issue in security, but I need to connect a pocket pc device with a gprs
> > modem directly to the sql server, and I'd rather not use a web service
> > application.
> >
I need to publish my computer on the internet which is on a company network.
in the network we have a server that connects to the internet and gives
internet access to all the company computers.
I'm running a sql server on my compuer and I need to access it through the
internet.
Also, I need to know how do I secure the connection to my
server/computer/company.
Any info on this would be great!!Tomer,
I had a bit of trouble understanding what you are asking, I will recap.
You have a corporate network connected to the internet via a proxy
server (let's call this PROXY1). You want to "publish" your computer on
the internet, which resides behind PROXY1. What do you mean by
"publish"? Is it a web site, an FTP site, a database, remote desktop
connection, what?
You are running SQL Server on "my computer". Is this in the corporate
network or on the internet at home? Please clarify these points very
carefully (take a bit of time) as they will have a significant bearing
on the accuracy of the responses you will get.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> I need to publish my computer on the internet which is on a company network.
> in the network we have a server that connects to the internet and gives
> internet access to all the company computers.
> I'm running a sql server on my compuer and I need to access it through the
> internet.
> Also, I need to know how do I secure the connection to my
> server/computer/company.
> Any info on this would be great!!
>|||Hi,
My computer is part of the company computer network and connects to the
internet through the company server which connects to the internet with an
adsl modem installed on it.
I have a sql server 2000 installed on my computer and I wish to access it
from 'outside' through the internet and access its databases.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...
> Tomer,
> I had a bit of trouble understanding what you are asking, I will recap.
> You have a corporate network connected to the internet via a proxy
> server (let's call this PROXY1). You want to "publish" your computer on
> the internet, which resides behind PROXY1. What do you mean by
> "publish"? Is it a web site, an FTP site, a database, remote desktop
> connection, what?
> You are running SQL Server on "my computer". Is this in the corporate
> network or on the internet at home? Please clarify these points very
> carefully (take a bit of time) as they will have a significant bearing
> on the accuracy of the responses you will get.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
> > Hi,
> > I need to publish my computer on the internet which is on a company
network.
> > in the network we have a server that connects to the internet and gives
> > internet access to all the company computers.
> > I'm running a sql server on my compuer and I need to access it through
the
> > internet.
> > Also, I need to know how do I secure the connection to my
> > server/computer/company.
> >
> > Any info on this would be great!!
> >
> >|||Tomer,
You will need to use NAT to allow your computer to act as a server. I
would only do this sort of thing at home and never on a corporate network.
On a corporate network you should have a demilitarised zone (DMZ) that
allows incoming connections from the internet. I really do not recommend
allow people from the public internet to connect directly to your LAN,
you are asking for trouble. The DMZ should not be able to initiate
connections to your LAN.
I would go further and not even allow any form of direct access to a
database server from the internet. Use a web server in a DMZ to connect
to your db server (also in a separate DMZ) to serve information. If you
need to manage a SQL Server from the internet you could use the web
administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
(http://www.mylittletools.net).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> My computer is part of the company computer network and connects to the
> internet through the company server which connects to the internet with an
> adsl modem installed on it.
> I have a sql server 2000 installed on my computer and I wish to access it
> from 'outside' through the internet and access its databases.
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...
>>Tomer,
>>I had a bit of trouble understanding what you are asking, I will recap.
>>You have a corporate network connected to the internet via a proxy
>>server (let's call this PROXY1). You want to "publish" your computer on
>>the internet, which resides behind PROXY1. What do you mean by
>>"publish"? Is it a web site, an FTP site, a database, remote desktop
>>connection, what?
>>You are running SQL Server on "my computer". Is this in the corporate
>>network or on the internet at home? Please clarify these points very
>>carefully (take a bit of time) as they will have a significant bearing
>>on the accuracy of the responses you will get.
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>Tomer wrote:
>>Hi,
>>I need to publish my computer on the internet which is on a company
> network.
>>in the network we have a server that connects to the internet and gives
>>internet access to all the company computers.
>>I'm running a sql server on my compuer and I need to access it through
> the
>>internet.
>>Also, I need to know how do I secure the connection to my
>>server/computer/company.
>>Any info on this would be great!!
>>
>
>|||Hi,
First thing, thanks alot for the info! I know that this is a problematic
issue in security, but I need to connect a pocket pc device with a gprs
modem directly to the sql server, and I'd rather not use a web service
application.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OOIKLZsfEHA.1424@.tk2msftngp13.phx.gbl...
> Tomer,
> You will need to use NAT to allow your computer to act as a server. I
> would only do this sort of thing at home and never on a corporate network.
> On a corporate network you should have a demilitarised zone (DMZ) that
> allows incoming connections from the internet. I really do not recommend
> allow people from the public internet to connect directly to your LAN,
> you are asking for trouble. The DMZ should not be able to initiate
> connections to your LAN.
> I would go further and not even allow any form of direct access to a
> database server from the internet. Use a web server in a DMZ to connect
> to your db server (also in a separate DMZ) to serve information. If you
> need to manage a SQL Server from the internet you could use the web
> administrator (http://tinyurl.com/3cuzt) or even MyLittleTools
> (http://www.mylittletools.net).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
> > Hi,
> >
> > My computer is part of the company computer network and connects to the
> > internet through the company server which connects to the internet with
an
> > adsl modem installed on it.
> > I have a sql server 2000 installed on my computer and I wish to access
it
> > from 'outside' through the internet and access its databases.
> >
> >
> > "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> > news:eaZoMCsfEHA.140@.TK2MSFTNGP12.phx.gbl...
> >
> >>Tomer,
> >>
> >>I had a bit of trouble understanding what you are asking, I will recap.
> >>You have a corporate network connected to the internet via a proxy
> >>server (let's call this PROXY1). You want to "publish" your computer on
> >>the internet, which resides behind PROXY1. What do you mean by
> >>"publish"? Is it a web site, an FTP site, a database, remote desktop
> >>connection, what?
> >>
> >>You are running SQL Server on "my computer". Is this in the corporate
> >>network or on the internet at home? Please clarify these points very
> >>carefully (take a bit of time) as they will have a significant bearing
> >>on the accuracy of the responses you will get.
> >>--
> >>Mark Allison, SQL Server MVP
> >>http://www.markallison.co.uk
> >>
> >>Looking for a SQL Server replication book?
> >>http://www.nwsu.com/0974973602.html
> >>
> >>
> >>
> >>Tomer wrote:
> >>
> >>Hi,
> >>I need to publish my computer on the internet which is on a company
> >
> > network.
> >
> >>in the network we have a server that connects to the internet and gives
> >>internet access to all the company computers.
> >>I'm running a sql server on my compuer and I need to access it through
> >
> > the
> >
> >>internet.
> >>Also, I need to know how do I secure the connection to my
> >>server/computer/company.
> >>
> >>Any info on this would be great!!
> >>
> >>
> >
> >
> >|||OK,
What you need to do is NOT allow connections into your LAN. Create a DMZ
and place the SQL Server there. Do not allow the DMZ to initiate
connections into the LAN. Only allow connections from the LAN TO the DMZ.
Do not allow SQL Server to connect to anything else on your network.
Remember, if this machine is compromised, you could be in trouble. On
the firewall, only open one port to the SQL Server, and make sure this
is not 1433. Make it a high port number such as 56378 (or whatever).
Ensure SQL Server is listening on this port.
This will put you out of range of port scanners that are only looking
for common ports such as 139, 1433, etc, however will not protect you
from someone scanning every port on your machine, but then there are
intrusion detection tools available to protect you from this.
Another way to do this is to use a VPN tunnel from the client on the
internet, through a VPN server in a DMZ on your corporate network, and
then you can use the entire LAN. This might be easier to set up and
configure, then again it might not.
Whatever you do, do not allow direct connections from the public
internet, unencrypted into your LAN.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tomer wrote:
> Hi,
> First thing, thanks alot for the info! I know that this is a problematic
> issue in security, but I need to connect a pocket pc device with a gprs
> modem directly to the sql server, and I'd rather not use a web service
> application.
>|||Thanks a bunch!! this helps alot
Tomer.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:u$IWGX4fEHA.632@.TK2MSFTNGP12.phx.gbl...
> OK,
> What you need to do is NOT allow connections into your LAN. Create a DMZ
> and place the SQL Server there. Do not allow the DMZ to initiate
> connections into the LAN. Only allow connections from the LAN TO the DMZ.
> Do not allow SQL Server to connect to anything else on your network.
> Remember, if this machine is compromised, you could be in trouble. On
> the firewall, only open one port to the SQL Server, and make sure this
> is not 1433. Make it a high port number such as 56378 (or whatever).
> Ensure SQL Server is listening on this port.
> This will put you out of range of port scanners that are only looking
> for common ports such as 139, 1433, etc, however will not protect you
> from someone scanning every port on your machine, but then there are
> intrusion detection tools available to protect you from this.
> Another way to do this is to use a VPN tunnel from the client on the
> internet, through a VPN server in a DMZ on your corporate network, and
> then you can use the entire LAN. This might be easier to set up and
> configure, then again it might not.
> Whatever you do, do not allow direct connections from the public
> internet, unencrypted into your LAN.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Tomer wrote:
> > Hi,
> >
> > First thing, thanks alot for the info! I know that this is a problematic
> > issue in security, but I need to connect a pocket pc device with a gprs
> > modem directly to the sql server, and I'd rather not use a web service
> > application.
> >
Subscribe to:
Posts (Atom)