We have a comprehensive windows based application which uses a database othe
r
than SQL Server. We have been considering moving our application to SQL
server but have been stymied by limitations in the ANS SQL implementation as
well has hidden restrictions in Decalarative Referential integrity.
One statement we use a lot in reporting is the ANS List statment (a scalar
aggregate function for strings which can return a set of results in a
appropriate delimited string).
Does anyone know if the List statement is implemented fully in SQL Server
2005.
If not, we would be interested in what techniques others use to get around
this limitation.
Thanks> One statement we use a lot in reporting is the ANS List statment (a scalar
> aggregate function for strings which can return a set of results in a
> appropriate delimited string).
> Does anyone know if the List statement is implemented fully in SQL Server
> 2005.
NO, it is not.
> If not, we would be interested in what techniques others use to get around
> this limitation.
http://www.aspfaq.com/2529|||"Glenn" wrote:
> We have a comprehensive windows based application which uses a database ot
her
> than SQL Server. We have been considering moving our application to SQL
> server but have been stymied by limitations in the ANS SQL implementation
as
> well has hidden restrictions in Decalarative Referential integrity.
> One statement we use a lot in reporting is the ANS List statment (a scalar
> aggregate function for strings which can return a set of results in a
> appropriate delimited string).
> Does anyone know if the List statement is implemented fully in SQL Server
> 2005.
> If not, we would be interested in what techniques others use to get around
> this limitation.
> Thanks
When you say "ANS SQL" do you mean ANSI SQL? If so, I think you are
mistaken. The LIST "aggregate" has never been part of standard SQL. It is a
proprietary feature in DB2 I believe (and possibly others).
There are a number of logical and practical problems with the concept of a
"string concatenation aggregate". The problems are to do with the fact that
concatentation implies order, which implies sorting. Furthermore, determinis
m
requires unique sorting. This means that "LIST" is A) potentially expensive
on performance B) difficult to ensure reliable results in queries C) totally
contrary to the way other SQL queries and aggregates work.
The ANSI response to "ordered" functions is the Windowed functions and these
*are* supported by SQL Server 2005. Theoretically you can kludge your own
string aggregate using standard SQL, provided you can set some reasdonable
upper limit to the number of items to be concatenated. Allternatively there
are non-standard workarounds in TSQL as there apparently are in your current
database.
Rather than try to support such a potential kludge in the database I suggest
you look at doing this client-side. In ADO you have the GetString method to
serve that purpose.
David Portas
SQL Server MVP
--|||Thanks very much for your response. This is a bit disappointing. We had so
hoped they would address this item as it is so commonly used in other SQL
implementations.
I took a look at the faq sample - and though helpful - and it looks like it
might add quite a lot of complexity to the SQL in many of our queries. I
think it is unfortunate that Microsoft continues to add many new features to
its SQL implementation, yet seems to have long ignored the ANS standard SQL.
It makes it difficult for developers and ISV's to move their applications
from other vendors to the M/S platform.
Glenn
"Aaron Bertrand [SQL Server MVP]" wrote:
> NO, it is not.
>
> http://www.aspfaq.com/2529
>
>|||> yet seems to have long ignored the ANS standard SQL.
Why do you think LIST is ANSI standard?
A|||Hi, this is pretty helpful, although it was my understanding that the SELECT
LIST command was ANSI standard although there were various vendor extensions
to the feature added for control of concatenation, separators, and order.
We are a bit spoiled by the iAnywhere implementation which works very
efficiently for our application and allows for ordering of the result (an
obvious Vendor extention). We have also tried doing this on the client side
,
and it was much-much slower.
Thanks for your help, looks like we are going to need to engage a SQL port
specialist.
BTW - We utilize quite a few Scalar Subqueries in our application, do you
feel that using these on SQL Server 2005 will introduce any special
performance or implementation problems.
Glenn
"David Portas" wrote:
> "Glenn" wrote:
>
> When you say "ANS SQL" do you mean ANSI SQL? If so, I think you are
> mistaken. The LIST "aggregate" has never been part of standard SQL. It is
a
> proprietary feature in DB2 I believe (and possibly others).
> There are a number of logical and practical problems with the concept of a
> "string concatenation aggregate". The problems are to do with the fact tha
t
> concatentation implies order, which implies sorting. Furthermore, determin
ism
> requires unique sorting. This means that "LIST" is A) potentially expensiv
e
> on performance B) difficult to ensure reliable results in queries C) total
ly
> contrary to the way other SQL queries and aggregates work.
> The ANSI response to "ordered" functions is the Windowed functions and the
se
> *are* supported by SQL Server 2005. Theoretically you can kludge your own
> string aggregate using standard SQL, provided you can set some reasdonable
> upper limit to the number of items to be concatenated. Allternatively ther
e
> are non-standard workarounds in TSQL as there apparently are in your curre
nt
> database.
> Rather than try to support such a potential kludge in the database I sugge
st
> you look at doing this client-side. In ADO you have the GetString method t
o
> serve that purpose.
> --
> David Portas
> SQL Server MVP
> --
>|||In our database documentation it was descibed as ANS 92/99 with optional
vendor extensions.
--
Glenn
"Aaron Bertrand [SQL Server MVP]" wrote:
> Why do you think LIST is ANSI standard?
> A
>
>|||LIST isn't ANSI Standard and never has been - I just checked the
standards docs. The reason is probably related to some of the logical
problems I mentioned. It just doesn't make sense as an "aggregate"
function.
I think SQL Server is actually reasonably good on standard SQL
compliance, and it goes further with 2005 - the SQL1999 OLAP functions
for example -although it certainly could do better.
David Portas
SQL Server MVP
--|||I do not wish to offend anyone, but this is - after all - the 21st century:
consider using XML (e.g. in SQL 2005) to replace the less useful LIST
function, if you really need to move sets of data about on the server.
ML|||Can you give me link to the ANSI SQL specification documents?
Thanks
--
Glenn
"David Portas" wrote:
> LIST isn't ANSI Standard and never has been - I just checked the
> standards docs. The reason is probably related to some of the logical
> problems I mentioned. It just doesn't make sense as an "aggregate"
> function.
> I think SQL Server is actually reasonably good on standard SQL
> compliance, and it goes further with 2005 - the SQL1999 OLAP functions
> for example -although it certainly could do better.
> --
> David Portas
> SQL Server MVP
> --
>
Showing posts with label windows. Show all posts
Showing posts with label windows. Show all posts
Tuesday, March 27, 2012
Does SQL Server 2005 run on Red Hat Linux?
Hello Everyone -
This may be a silly question, but does SQL Server 2005 run on any other platforms besides Windows? Will SQL Server 2005 run on Red Hat Linux? Or any other flavor of UNIX? Thank you for your time and assistance. I appreciate the help.
No, SQL Server requires a Windows operating system.
The requirements are listed here:
SQL Server 2005 Installation Requirements (Hardware/Software)
http://msdn2.microsoft.com/en-us/library/ms143506.aspx
Sunday, March 25, 2012
Does SQL 7 server run well in Win Server 2k3 or do I have to upgra
I currently have one machine running windows 2000 server that I promoted to a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db
Db
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:
> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>
|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db
Db
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:
> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>
|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db
Does SQL 7 server run well in Win Server 2k3 or do I have to upgra
I currently have one machine running Windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003
,
and I want to migrate the win2k pdc to win server 2k3, that I will promote t
o
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in II
S
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:
> I currently have one machine running Windows 2000 server that I promoted t
o a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 200
03,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sit
es
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running Windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running Windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Dbsql
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003
,
and I want to migrate the win2k pdc to win server 2k3, that I will promote t
o
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in II
S
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:
> I currently have one machine running Windows 2000 server that I promoted t
o a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 200
03,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sit
es
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running Windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running Windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Dbsql
Does SQL 7 server run well in Win Server 2k3 or do I have to upgra
I currently have one machine running windows 2000 server that I promoted to a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:
> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:
> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db
Does SQL 2005 runs on other platforms them MS windows ?
I could not find in the documentation but someone told me that there is a way.
YOu will be able to connect to the SQL Server from any platform where you can find an appropiate driver, but the shipped client tools from MS and the service will only run on WIndows platforms.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Does SQL 2005 runs on other platforms them MS windows ?
I could not find in the documentation but someone told me that there is a way.
YOu will be able to connect to the SQL Server from any platform where you can find an appropiate driver, but the shipped client tools from MS and the service will only run on WIndows platforms.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Does SQL 2000 clustering work properly?
Howdy,
Is SQL 2000 clustering on windows 2000 any good ??
We are looking at spending *quite* a bit of money to implement it, but I need opinions of what its like from the people that actually use it & look after it.
e.g.
DOES IT WORK LIKE IT SHOULD????
Is it reliable?
Is it resource hungry?
Are there lots of bugs?
All repsonses very welcome. No response too small.
Thanks for your help.
Cheers,
SG.I can't offer too much advise except to say,... a few of the projects I have been involved in have used it. I have never had to set it up or admin it or anything. I have heard that setup can be a pain in the butt, but once it is going things tend to run okie.
As a developer I have never had any problems with what others have set up in the way of clusters.|||Hey,
This is a bit long, so I apologise for that,
but this is some text I found on www.sqlteam.com which I think is particularly relevant in this case:
//direct paste from: http://www.sqlteam.com/item.asp?ItemID=5137
Notes from the Field
I sent out an email to a few people that I know run a cluster in production and have done so for a while. Here's the information I got back from JohnDeere:
I have found the biggest shortfall to be the lack of monitoring tools for Microsoft Cluster Services. There is no built in notification if a node fails, but at least on Win2K you can install the cluster admin tool on your local workstation so you don't have to go to the server room. Terminal services does not work in the cluster.
Be sure your backup strategy will work in a cluster and be sure it will work for Sql server. Our original strategy was Compaq's virtual replicator. It does not work in a cluster and I was never sure how these snapshots would work for SQL server. We switched to a Spectra 10000 4 drive AIT backup unit.
If your cluster is not fully redundant make sure you have the spare parts in stock or on a quick delivery time frame. Our cluster is not redundant but Compaq has all the parts on a 4 hour delivery time. (SAN controllers, SAN Switch, fiber cable, disk drives We have one hot spare but none on the shelf) The basic idea is to survive a CPU fault but if any of the shared disk pieces fail and you have no redundancy the whole cluster is down. (Management really does not like this)
Be sure to mention only start and stop services from the cluster administrator. Never start or stop SQL or its related services from enterprise manager, Sql service control or the services applet from control panel. The only way I have been able to recover from this is a reboot of both nodes on the cluster.
One of the biggest issues on our cluster is disk contention. You have 2 servers fighting for time on a single physical disk cabinet. In my cluster if I start 2 backups at the same time. The time to backup doubles or If we start a major import operation on node1 the performance of node2 suffers. (graz: I'm lucky. We have two physical disk cabinets.)
I would also mention hardware sizing (# of CPU's & RAM). Make sure one of your servers has enough horsepower to run both instances of SQL Server in the event of a fail over. In the 7 world this is a little different but in 2000 you are running 2 separate instances of mssql.exe and its associated programs.
If you cluster 2000 you must name the instances and change the port from 1433 on one of the instances. If you don't have MDAC 2.6 then you must alias the non-1433 server via client network utility|||Actually, re-reading it, lol, the first paragraph is all i needed to paste (sorry it's been a long day), and this forum doesn't seem to have an edit function. Oh well... ops *slaps himself*|||it must have been a long day, check the edit link at the bottom right of your post. ;)|||The company that I'm working for has the SQL cluster servers with active to active. Like rokslide said, the setup is very tough, especially for active to active. We had Microsoft consultants to set up and cost much time and money. After it is up, that is really good.|||Oh yea, the one that says Edit, LOL...
*slaps himself again*
I thought I'd used it before, couldn't believe it when I couldn't find it.
Just think, if I can't find the edit button on this forum, imagine the quality of my code, lol (hm, i better get testing tomorrow, lol)
Is SQL 2000 clustering on windows 2000 any good ??
We are looking at spending *quite* a bit of money to implement it, but I need opinions of what its like from the people that actually use it & look after it.
e.g.
DOES IT WORK LIKE IT SHOULD????
Is it reliable?
Is it resource hungry?
Are there lots of bugs?
All repsonses very welcome. No response too small.
Thanks for your help.
Cheers,
SG.I can't offer too much advise except to say,... a few of the projects I have been involved in have used it. I have never had to set it up or admin it or anything. I have heard that setup can be a pain in the butt, but once it is going things tend to run okie.
As a developer I have never had any problems with what others have set up in the way of clusters.|||Hey,
This is a bit long, so I apologise for that,
but this is some text I found on www.sqlteam.com which I think is particularly relevant in this case:
//direct paste from: http://www.sqlteam.com/item.asp?ItemID=5137
Notes from the Field
I sent out an email to a few people that I know run a cluster in production and have done so for a while. Here's the information I got back from JohnDeere:
I have found the biggest shortfall to be the lack of monitoring tools for Microsoft Cluster Services. There is no built in notification if a node fails, but at least on Win2K you can install the cluster admin tool on your local workstation so you don't have to go to the server room. Terminal services does not work in the cluster.
Be sure your backup strategy will work in a cluster and be sure it will work for Sql server. Our original strategy was Compaq's virtual replicator. It does not work in a cluster and I was never sure how these snapshots would work for SQL server. We switched to a Spectra 10000 4 drive AIT backup unit.
If your cluster is not fully redundant make sure you have the spare parts in stock or on a quick delivery time frame. Our cluster is not redundant but Compaq has all the parts on a 4 hour delivery time. (SAN controllers, SAN Switch, fiber cable, disk drives We have one hot spare but none on the shelf) The basic idea is to survive a CPU fault but if any of the shared disk pieces fail and you have no redundancy the whole cluster is down. (Management really does not like this)
Be sure to mention only start and stop services from the cluster administrator. Never start or stop SQL or its related services from enterprise manager, Sql service control or the services applet from control panel. The only way I have been able to recover from this is a reboot of both nodes on the cluster.
One of the biggest issues on our cluster is disk contention. You have 2 servers fighting for time on a single physical disk cabinet. In my cluster if I start 2 backups at the same time. The time to backup doubles or If we start a major import operation on node1 the performance of node2 suffers. (graz: I'm lucky. We have two physical disk cabinets.)
I would also mention hardware sizing (# of CPU's & RAM). Make sure one of your servers has enough horsepower to run both instances of SQL Server in the event of a fail over. In the 7 world this is a little different but in 2000 you are running 2 separate instances of mssql.exe and its associated programs.
If you cluster 2000 you must name the instances and change the port from 1433 on one of the instances. If you don't have MDAC 2.6 then you must alias the non-1433 server via client network utility|||Actually, re-reading it, lol, the first paragraph is all i needed to paste (sorry it's been a long day), and this forum doesn't seem to have an edit function. Oh well... ops *slaps himself*|||it must have been a long day, check the edit link at the bottom right of your post. ;)|||The company that I'm working for has the SQL cluster servers with active to active. Like rokslide said, the setup is very tough, especially for active to active. We had Microsoft consultants to set up and cost much time and money. After it is up, that is really good.|||Oh yea, the one that says Edit, LOL...
*slaps himself again*
I thought I'd used it before, couldn't believe it when I couldn't find it.
Just think, if I can't find the edit button on this forum, imagine the quality of my code, lol (hm, i better get testing tomorrow, lol)
Does sp3a Pretected SQL Server 2000 from Slammer?
We have a SQL Server 2000 with SP1 installation on a Windows 2000 Server PC,
which is connected to the internet. Everytime after the PC is rebooted, in
about 10 to 20 minutes, it starts sending out data packets to random IP addr
esses at a very high rate.
After I installed SP3a, it still does the same except at a much slower rate.
It looks like the PC is infected by the slammer virus. How can I tell for s
ure? If it is slammer virus, why doesn't SP3a fix it completely? Thanks.Make sure you actually have installed the service pack. What do you get if
you run @.@.Version?
Andrew J. Kelly SQL MVP
"Frank" <frankxchen@.yahoo.com> wrote in message
news:363A6A75-D250-401C-A708-8E58604E86C1@.microsoft.com...
> We have a SQL Server 2000 with SP1 installation on a Windows 2000 Server
PC, which is connected to the internet. Everytime after the PC is rebooted,
in about 10 to 20 minutes, it starts sending out data packets to random IP
addresses at a very high rate. After I installed SP3a, it still does the
same except at a much slower rate. It looks like the PC is infected by the
slammer virus. How can I tell for sure? If it is slammer virus, why doesn't
SP3a fix it completely? Thanks.|||SP3a will resolve the problem with Slammer.
You should scan the machine to see what other patches your missing.
http://www.microsoft.com/technet/se...s/mbsahome.mspx
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
which is connected to the internet. Everytime after the PC is rebooted, in
about 10 to 20 minutes, it starts sending out data packets to random IP addr
esses at a very high rate.
After I installed SP3a, it still does the same except at a much slower rate.
It looks like the PC is infected by the slammer virus. How can I tell for s
ure? If it is slammer virus, why doesn't SP3a fix it completely? Thanks.Make sure you actually have installed the service pack. What do you get if
you run @.@.Version?
Andrew J. Kelly SQL MVP
"Frank" <frankxchen@.yahoo.com> wrote in message
news:363A6A75-D250-401C-A708-8E58604E86C1@.microsoft.com...
> We have a SQL Server 2000 with SP1 installation on a Windows 2000 Server
PC, which is connected to the internet. Everytime after the PC is rebooted,
in about 10 to 20 minutes, it starts sending out data packets to random IP
addresses at a very high rate. After I installed SP3a, it still does the
same except at a much slower rate. It looks like the PC is infected by the
slammer virus. How can I tell for sure? If it is slammer virus, why doesn't
SP3a fix it completely? Thanks.|||SP3a will resolve the problem with Slammer.
You should scan the machine to see what other patches your missing.
http://www.microsoft.com/technet/se...s/mbsahome.mspx
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Wednesday, March 21, 2012
Does Personal Edition Includes Analisys Services??
Does Personal Edition Includes Analisys Services'
Which versions of sql include analisys services and can be installed on
Windows XP?Developer Edition of SQL 2000 has the analysis serverices and it can be
installed on Windows XP.
hth
--
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"Luis Esteban Valencia" <levalencia@.avansoft.com> wrote in message
news:%23TKxj6jjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Does Personal Edition Includes Analisys Services'
> Which versions of sql include analisys services and can be installed on
> Windows XP?
>|||Books Online lists what is ant what is not supported of AS in PE:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_ts_1cdv.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Luis Esteban Valencia" <levalencia@.avansoft.com> wrote in message
news:%23TKxj6jjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Does Personal Edition Includes Analisys Services'
> Which versions of sql include analisys services and can be installed on
> Windows XP?
>
Which versions of sql include analisys services and can be installed on
Windows XP?Developer Edition of SQL 2000 has the analysis serverices and it can be
installed on Windows XP.
hth
--
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"Luis Esteban Valencia" <levalencia@.avansoft.com> wrote in message
news:%23TKxj6jjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Does Personal Edition Includes Analisys Services'
> Which versions of sql include analisys services and can be installed on
> Windows XP?
>|||Books Online lists what is ant what is not supported of AS in PE:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_ts_1cdv.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Luis Esteban Valencia" <levalencia@.avansoft.com> wrote in message
news:%23TKxj6jjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Does Personal Edition Includes Analisys Services'
> Which versions of sql include analisys services and can be installed on
> Windows XP?
>
Monday, March 19, 2012
does not install SQL Query Analyzer
Hi,
I am developing and application in pocket pc windows mobile 2003. I have added a reference to System.Data.SqlServerCe.dll but when i deploy the application query analyzer doesnt seem to install. Any help please?
cheers,
michael
Hi,
Sorry... for info I am using CS VS2005 and SQL Mobile.
Thank you.
michael
|||Query Analyzer 3.0 should deploy automatically if you are building and deploying a DEBUG build in VS2005 given your reference to System.Data.SqlServerCe.dll version 2.0. You can also just grab the dev tools CAB and install it to your device/emulator to save time. it is located (depending on your device's WinCE kernel) at:
<drive:>\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4\sqlce30.dev.ENU.ppc.wce4.armv4.CAB
or
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\<device CPU architecture>\
Darren
Does not have permission to register endpoint
I came across with the problem that I cannot create an endpoint on Windows Server 2003 (SP1). It's said:
Msg 7850, Level 16, State 1, Line 2
The user 'yyyyy\xxxx' does not have permission to register endpoint 'zzzzzz' on the specified URL. Please ensure the URL refers to a namespace that is reserved for listening by SQL.
Msg 7807, Level 16, State 1, Line 2
An error ('0x80070005') occurred while attempting to register the endpoint 'SecurityServices'.
My code looks loke this:
IF EXISTS (
SELECT name from sys.http_endpoints
WHERE name = 'zzzzzz'
)
DROP ENDPOINT zzzzzz
GO
CREATE ENDPOINT zzzzzz
STATE = STARTED
AS HTTP (
path='/sql/zzzzzz',
AUTHENTICATION=(INTEGRATED),
PORTS = (CLEAR)
)
FOR SOAP(
WEBMETHOD 'http://servername/' . 'sp1' (NAME = 'dbName.dbo.sp1'),
WEBMETHOD 'http://servername/' . 'sp2' (NAME = 'dbName.dbo.sp2'),
WSDL = DEFAULT,
BATCHES=ENABLED)
GO
-- End of Script --
The script that I use is correct and it works fine on my local machine (Windows XP). The user that I used to crete an endpoint on the server has 'sysadmin' level. The IIS was already turned off. Also I run the script by using the RemoteDesktop to connect to the server (Windows 2003) that has SQL Server 2005.
If anyone has an idea about my problem, please help me !!!
Thank you,
POP
To reserve it, you run the un-doc:ed stored procedure sp_reserve_http_namespace. You run it with the macine name (as it will appear in the site param in CREATE ENDPOINT), portnumber and virtual directory name as in the path param in CREATE ENDPOINT.
An example would be:
sp_reserve_http_namespace N'http://Perth:80/emp', which then would have the following CREATE ENPOINT statement:
<<<<<<<<<<<<<<<
create endpoint EmpClass
state = started
as HTTP (
site = 'Perth',
path = '/emp',
authentication = (INTEGRATED),
ports = (CLEAR))
FOR SOAP...
>>>>>>>>>>>>>>>
Hope this helps!!
Niels
|||Thank you so much Niels (again),
It's works !!!!
At first, I try to use >> sp_reserve_http_namespace N'http://Perth:80/emp'
first but it said >> A reservation for this HTTP namespace (http://Perth:80/emp) already exists
But when I look at your code
as HTTP (
site = 'Perth',
path = '/emp',
authentication = (INTEGRATED),
ports = (CLEAR))
FOR SOAP...
I don't have the value of the site (yellow highlighted part). Then I add that part and when I run the code on the server, it works !!!!.
Without that line, I can create an end point on my local computer but not on the server (Cluster Servers). So from now on, I'll have that line all the time.
Thank you again Niels,
POP|||It works. Thank you.
Does not have permission to register endpoint
I came across with the problem that I cannot create an endpoint on Windows Server 2003 (SP1). It's said:
Msg 7850, Level 16, State 1, Line 2
The user 'yyyyy\xxxx' does not have permission to register endpoint 'zzzzzz' on the specified URL. Please ensure the URL refers to a namespace that is reserved for listening by SQL.
Msg 7807, Level 16, State 1, Line 2
An error ('0x80070005') occurred while attempting to register the endpoint 'SecurityServices'.
My code looks loke this:
IF EXISTS (
SELECT name from sys.http_endpoints
WHERE name = 'zzzzzz'
)
DROP ENDPOINT zzzzzz
GO
CREATE ENDPOINT zzzzzz
STATE = STARTED
AS HTTP (
path='/sql/zzzzzz',
AUTHENTICATION=(INTEGRATED),
PORTS = (CLEAR)
)
FOR SOAP(
WEBMETHOD 'http://servername/' . 'sp1' (NAME = 'dbName.dbo.sp1'),
WEBMETHOD 'http://servername/' . 'sp2' (NAME = 'dbName.dbo.sp2'),
WSDL = DEFAULT,
BATCHES=ENABLED)
GO
-- End of Script --
The script that I use is correct and it works fine on my local machine (Windows XP). The user that I used to crete an endpoint on the server has 'sysadmin' level. The IIS was already turned off. Also I run the script by using the RemoteDesktop to connect to the server (Windows 2003) that has SQL Server 2005.
If anyone has an idea about my problem, please help me !!!
Thank you,
POP
To reserve it, you run the un-doc:ed stored procedure sp_reserve_http_namespace. You run it with the macine name (as it will appear in the site param in CREATE ENDPOINT), portnumber and virtual directory name as in the path param in CREATE ENDPOINT.
An example would be:
sp_reserve_http_namespace N'http://Perth:80/emp', which then would have the following CREATE ENPOINT statement:
<<<<<<<<<<<<<<<
create endpoint EmpClass
state = started
as HTTP (
site = 'Perth',
path = '/emp',
authentication = (INTEGRATED),
ports = (CLEAR))
FOR SOAP...
>>>>>>>>>>>>>>>
Hope this helps!!
Niels
|||Thank you so much Niels (again),
It's works !!!!
At first, I try to use >> sp_reserve_http_namespace N'http://Perth:80/emp'
first but it said >> A reservation for this HTTP namespace (http://Perth:80/emp) already exists
But when I look at your code
as HTTP (
site = 'Perth',
path = '/emp',
authentication = (INTEGRATED),
ports = (CLEAR))
FOR SOAP...
I don't have the value of the site (yellow highlighted part). Then I add that part and when I run the code on the server, it works !!!!.
Without that line, I can create an end point on my local computer but not on the server (Cluster Servers). So from now on, I'll have that line all the time.
Thank you again Niels,
POP|||It works. Thank you.
Does MSDE run ok on Windows XP Home, Media Edition?
We can't seem to get TCP/IP working...
Hi Jon,
Have you enabled tcp/ip using svrnetcn.exe?
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:%23QouccA6EHA.3708@.TK2MSFTNGP14.phx.gbl...
> We can't seem to get TCP/IP working...
|||Yep, and Named Pipes. It's listening on the default port of 1433, but
when SQL starts, in the log, it doesn't say it's listening on TCP. There
are no warnings/errors either.
The PC does have a firewall on it, would that make any difference?
Greg Low [MVP] wrote:
> Hi Jon,
> Have you enabled tcp/ip using svrnetcn.exe?
> HTH,
>
|||Hi Jon,
Yep, sure would. Have you put an exception for port 1433 (assuming you're
using the default port) ?
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:e24tD0M6EHA.3376@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Yep, and Named Pipes. It's listening on the default port of 1433, but when
> SQL starts, in the log, it doesn't say it's listening on TCP. There are no
> warnings/errors either.
> The PC does have a firewall on it, would that make any difference?
> Greg Low [MVP] wrote:
Hi Jon,
Have you enabled tcp/ip using svrnetcn.exe?
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:%23QouccA6EHA.3708@.TK2MSFTNGP14.phx.gbl...
> We can't seem to get TCP/IP working...
|||Yep, and Named Pipes. It's listening on the default port of 1433, but
when SQL starts, in the log, it doesn't say it's listening on TCP. There
are no warnings/errors either.
The PC does have a firewall on it, would that make any difference?
Greg Low [MVP] wrote:
> Hi Jon,
> Have you enabled tcp/ip using svrnetcn.exe?
> HTH,
>
|||Hi Jon,
Yep, sure would. Have you put an exception for port 1433 (assuming you're
using the default port) ?
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:e24tD0M6EHA.3376@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Yep, and Named Pipes. It's listening on the default port of 1433, but when
> SQL starts, in the log, it doesn't say it's listening on TCP. There are no
> warnings/errors either.
> The PC does have a firewall on it, would that make any difference?
> Greg Low [MVP] wrote:
Does MSDE (SP4) support Full Text Research?
How can i install eand run Full text research Service in Windows xp Sp2
hi,
S. Luca wrote:
> How can i install eand run Full text research Service in Windows xp
> Sp2
MSDE does not support (and provide) Full Text engine..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
hi,
S. Luca wrote:
> How can i install eand run Full text research Service in Windows xp
> Sp2
MSDE does not support (and provide) Full Text engine..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
does microsoft offer new updatable version of MSDTC?
hi all
microsoft offers new updatable version of MSDTC
not by the windows service pack or sql server service pack?
cjpark
---
cjpark's Profile: http://www.msmcse.ms/member.php?userid=543
View this thread: http://www.msmcse.ms/t-1869428251Hi
On Windows 2000 and later, MSDTC is the responsibility of the OS and will be
updated with OS Service Packs.
If you need a hotfix for DTC, call Microsoft PSS in your area.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cjpark" <cjpark.1no03y@.no-mx.msmcse.ms> wrote in message
news:cjpark.1no03y@.no-mx.msmcse.ms...
> hi all
> microsoft offers new updatable version of MSDTC
> not by the windows service pack or sql server service pack?
>
> --
> cjpark
> ---
> cjpark's Profile: http://www.msmcse.ms/member.php?userid=543
> View this thread: http://www.msmcse.ms/t-1869428251
>|||thank you much Mike
cjpark
---
cjpark's Profile: http://www.msmcse.ms/member.php?userid=543
View this thread: http://www.msmcse.ms/t-1869428251
microsoft offers new updatable version of MSDTC
not by the windows service pack or sql server service pack?
cjpark
---
cjpark's Profile: http://www.msmcse.ms/member.php?userid=543
View this thread: http://www.msmcse.ms/t-1869428251Hi
On Windows 2000 and later, MSDTC is the responsibility of the OS and will be
updated with OS Service Packs.
If you need a hotfix for DTC, call Microsoft PSS in your area.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cjpark" <cjpark.1no03y@.no-mx.msmcse.ms> wrote in message
news:cjpark.1no03y@.no-mx.msmcse.ms...
> hi all
> microsoft offers new updatable version of MSDTC
> not by the windows service pack or sql server service pack?
>
> --
> cjpark
> ---
> cjpark's Profile: http://www.msmcse.ms/member.php?userid=543
> View this thread: http://www.msmcse.ms/t-1869428251
>|||thank you much Mike
cjpark
---
cjpark's Profile: http://www.msmcse.ms/member.php?userid=543
View this thread: http://www.msmcse.ms/t-1869428251
Sunday, March 11, 2012
Does it possibile use SQL Client 2000 and connect to the SQL7?
I'd like to know if SQL 2000 client and SQL 7 Server are compatible.
I need to connect a Windows 2003 Std Edition to the SQL Server 7.0, but as
you it is not possibile to install SQL 7.0 Client on the Windows server2003.
Tx
Suzana
Hi
Yes it is. SQL Server 2000 components are backward compatible with SQL
Server 7.0
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Suzan" <Suzan@.discussions.microsoft.com> wrote in message
news:D5D97C69-033D-4AF6-9343-22C11FA7F625@.microsoft.com...
> I'd like to know if SQL 2000 client and SQL 7 Server are compatible.
> I need to connect a Windows 2003 Std Edition to the SQL Server 7.0, but as
> you it is not possibile to install SQL 7.0 Client on the Windows
> server2003.
> Tx
> Suzana
>
|||Could you please tell me where can I find more information about
compatibility between SQL Client2000 and SQL server 7.0.
I found some information about how to connect a SQL Server 7.0 client to a
SQL Server 2000 but not vice versa
Thanks,
Suzan
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Yes it is. SQL Server 2000 components are backward compatible with SQL
> Server 7.0
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Suzan" <Suzan@.discussions.microsoft.com> wrote in message
> news:D5D97C69-033D-4AF6-9343-22C11FA7F625@.microsoft.com...
>
>
|||Hi
This is all I found:
http://msdn.microsoft.com/library/de...bckwd_3vlc.asp
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Suzan" <Suzan@.discussions.microsoft.com> wrote in message
news:90E6271F-C04C-40F6-B0CC-E9D66D9A800F@.microsoft.com...[vbcol=seagreen]
> Could you please tell me where can I find more information about
> compatibility between SQL Client2000 and SQL server 7.0.
> I found some information about how to connect a SQL Server 7.0 client to a
> SQL Server 2000 but not vice versa
> Thanks,
> Suzan
>
> "Mike Epprecht (SQL MVP)" wrote:
I need to connect a Windows 2003 Std Edition to the SQL Server 7.0, but as
you it is not possibile to install SQL 7.0 Client on the Windows server2003.
Tx
Suzana
Hi
Yes it is. SQL Server 2000 components are backward compatible with SQL
Server 7.0
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Suzan" <Suzan@.discussions.microsoft.com> wrote in message
news:D5D97C69-033D-4AF6-9343-22C11FA7F625@.microsoft.com...
> I'd like to know if SQL 2000 client and SQL 7 Server are compatible.
> I need to connect a Windows 2003 Std Edition to the SQL Server 7.0, but as
> you it is not possibile to install SQL 7.0 Client on the Windows
> server2003.
> Tx
> Suzana
>
|||Could you please tell me where can I find more information about
compatibility between SQL Client2000 and SQL server 7.0.
I found some information about how to connect a SQL Server 7.0 client to a
SQL Server 2000 but not vice versa
Thanks,
Suzan
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Yes it is. SQL Server 2000 components are backward compatible with SQL
> Server 7.0
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Suzan" <Suzan@.discussions.microsoft.com> wrote in message
> news:D5D97C69-033D-4AF6-9343-22C11FA7F625@.microsoft.com...
>
>
|||Hi
This is all I found:
http://msdn.microsoft.com/library/de...bckwd_3vlc.asp
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Suzan" <Suzan@.discussions.microsoft.com> wrote in message
news:90E6271F-C04C-40F6-B0CC-E9D66D9A800F@.microsoft.com...[vbcol=seagreen]
> Could you please tell me where can I find more information about
> compatibility between SQL Client2000 and SQL server 7.0.
> I found some information about how to connect a SQL Server 7.0 client to a
> SQL Server 2000 but not vice versa
> Thanks,
> Suzan
>
> "Mike Epprecht (SQL MVP)" wrote:
Wednesday, March 7, 2012
Does AWE is needed ?
I have a server with Windows server 2003 enterprise edition, 6gb ram.
(32bit)
I installed SQL 2000 with SP4 on it, i configured it to use only 5gb of
memory.
Do i have to enable AWE for this box or this is enough for optimal
performance ?
my server show in the boot.ini "/PAE"
Thanks,,,Hi
http://support.microsoft.com/kb/274750
Aslo , read about hotfix
http://support.microsoft.com/kb/899761
"Mahmoud Amin" <mm.amin@.gmail.com> wrote in message
news:eE0c1aZYIHA.1212@.TK2MSFTNGP05.phx.gbl...
>I have a server with Windows server 2003 enterprise edition, 6gb ram.
>(32bit)
> I installed SQL 2000 with SP4 on it, i configured it to use only 5gb of
> memory.
> Do i have to enable AWE for this box or this is enough for optimal
> performance ?
> my server show in the boot.ini "/PAE"
> Thanks,,,
>
(32bit)
I installed SQL 2000 with SP4 on it, i configured it to use only 5gb of
memory.
Do i have to enable AWE for this box or this is enough for optimal
performance ?
my server show in the boot.ini "/PAE"
Thanks,,,Hi
http://support.microsoft.com/kb/274750
Aslo , read about hotfix
http://support.microsoft.com/kb/899761
"Mahmoud Amin" <mm.amin@.gmail.com> wrote in message
news:eE0c1aZYIHA.1212@.TK2MSFTNGP05.phx.gbl...
>I have a server with Windows server 2003 enterprise edition, 6gb ram.
>(32bit)
> I installed SQL 2000 with SP4 on it, i configured it to use only 5gb of
> memory.
> Do i have to enable AWE for this box or this is enough for optimal
> performance ?
> my server show in the boot.ini "/PAE"
> Thanks,,,
>
Does anyone know if guest account must be enabled?
Hi a user is not able to run a windows application that uses SQL
authentication and was just wondering if the guest account have to be enabled
on the SQL Server for SQL authentication to work?
Thanks.
Paul G
Software engineer.
There is a thread from Kimberly:
http://groups.google.de/group/micros...b922f9b1e2a009
HTH, Jens Suessmeyer.
"Paul" wrote:
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enabled
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.
|||No need for any type of guest account.
Only time I heard about that is if you are in separate domains and you don't have trusts and you are
using the Named Pipes netlib, which depends on the IPC$ share). I don't know if this is still the
case, but in any case moving to the IP netlib should remove that need.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:690F2DCE-4020-48A3-ACE7-36006029871C@.microsoft.com...
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enabled
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.
|||ok thanks for the information. Sounds like it does not effect SQL login
Paul G
Software engineer.
"Jens Sü?meyer" wrote:
[vbcol=seagreen]
> There is a thread from Kimberly:
> http://groups.google.de/group/micros...b922f9b1e2a009
> HTH, Jens Suessmeyer.
> "Paul" wrote:
|||To me it wasn't clear whether you refer to the guest user inside a database, if so see Jens' reply.
Or if you refer to a Gust Windows account, if so, see my reply.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:C9EE6BC1-2F9B-4E9B-A585-DABB6A6F22B6@.microsoft.com...[vbcol=seagreen]
> ok thanks for the information. Sounds like it does not effect SQL login
> --
> Paul G
> Software engineer.
>
> "Jens Sü?meyer" wrote:
authentication and was just wondering if the guest account have to be enabled
on the SQL Server for SQL authentication to work?
Thanks.
Paul G
Software engineer.
There is a thread from Kimberly:
http://groups.google.de/group/micros...b922f9b1e2a009
HTH, Jens Suessmeyer.
"Paul" wrote:
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enabled
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.
|||No need for any type of guest account.
Only time I heard about that is if you are in separate domains and you don't have trusts and you are
using the Named Pipes netlib, which depends on the IPC$ share). I don't know if this is still the
case, but in any case moving to the IP netlib should remove that need.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:690F2DCE-4020-48A3-ACE7-36006029871C@.microsoft.com...
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enabled
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.
|||ok thanks for the information. Sounds like it does not effect SQL login
Paul G
Software engineer.
"Jens Sü?meyer" wrote:
[vbcol=seagreen]
> There is a thread from Kimberly:
> http://groups.google.de/group/micros...b922f9b1e2a009
> HTH, Jens Suessmeyer.
> "Paul" wrote:
|||To me it wasn't clear whether you refer to the guest user inside a database, if so see Jens' reply.
Or if you refer to a Gust Windows account, if so, see my reply.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:C9EE6BC1-2F9B-4E9B-A585-DABB6A6F22B6@.microsoft.com...[vbcol=seagreen]
> ok thanks for the information. Sounds like it does not effect SQL login
> --
> Paul G
> Software engineer.
>
> "Jens Sü?meyer" wrote:
Does anyone know if guest account must be enabled?
Hi a user is not able to run a windows application that uses SQL
authentication and was just wondering if the guest account have to be enable
d
on the SQL Server for SQL authentication to work?
Thanks.
--
Paul G
Software engineer.There is a thread from Kimberly:
http://groups.google.de/group/micro...8b922f9b1e2a009
HTH, Jens Suessmeyer.
"Paul" wrote:
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enab
led
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.|||No need for any type of guest account.
Only time I heard about that is if you are in separate domains and you don't
have trusts and you are
using the Named Pipes netlib, which depends on the IPC$ share). I don't know
if this is still the
case, but in any case moving to the IP netlib should remove that need.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:690F2DCE-4020-48A3-ACE7-36006029871C@.microsoft.com...
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enab
led
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.|||ok thanks for the information. Sounds like it does not effect SQL login
--
Paul G
Software engineer.
"Jens Sü?meyer" wrote:
[vbcol=seagreen]
> There is a thread from Kimberly:
> http://groups.google.de/group/micro...8b922f9b1e2a009
> HTH, Jens Suessmeyer.
> "Paul" wrote:
>|||To me it wasn't clear whether you refer to the guest user inside a database,
if so see Jens' reply.
Or if you refer to a Gust Windows account, if so, see my reply.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:C9EE6BC1-2F9B-4E9B-A585-DABB6A6F22B6@.microsoft.com...[vbcol=seagreen]
> ok thanks for the information. Sounds like it does not effect SQL login
> --
> Paul G
> Software engineer.
>
> "Jens Sü?meyer" wrote:
>
authentication and was just wondering if the guest account have to be enable
d
on the SQL Server for SQL authentication to work?
Thanks.
--
Paul G
Software engineer.There is a thread from Kimberly:
http://groups.google.de/group/micro...8b922f9b1e2a009
HTH, Jens Suessmeyer.
"Paul" wrote:
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enab
led
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.|||No need for any type of guest account.
Only time I heard about that is if you are in separate domains and you don't
have trusts and you are
using the Named Pipes netlib, which depends on the IPC$ share). I don't know
if this is still the
case, but in any case moving to the IP netlib should remove that need.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:690F2DCE-4020-48A3-ACE7-36006029871C@.microsoft.com...
> Hi a user is not able to run a windows application that uses SQL
> authentication and was just wondering if the guest account have to be enab
led
> on the SQL Server for SQL authentication to work?
> Thanks.
> --
> Paul G
> Software engineer.|||ok thanks for the information. Sounds like it does not effect SQL login
--
Paul G
Software engineer.
"Jens Sü?meyer" wrote:
[vbcol=seagreen]
> There is a thread from Kimberly:
> http://groups.google.de/group/micro...8b922f9b1e2a009
> HTH, Jens Suessmeyer.
> "Paul" wrote:
>|||To me it wasn't clear whether you refer to the guest user inside a database,
if so see Jens' reply.
Or if you refer to a Gust Windows account, if so, see my reply.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:C9EE6BC1-2F9B-4E9B-A585-DABB6A6F22B6@.microsoft.com...[vbcol=seagreen]
> ok thanks for the information. Sounds like it does not effect SQL login
> --
> Paul G
> Software engineer.
>
> "Jens Sü?meyer" wrote:
>
Subscribe to:
Posts (Atom)