显示标签为“win”的博文。显示所有博文
显示标签为“win”的博文。显示所有博文

2012年3月6日星期二

Any problems with SQL Server 7 on Win 2003 server?

Are there any known problems with running SQL Server 7 on Win 2003
Server?
Thanks,
--
BillI don't believe it is supported on Win2003. You can certainly run SQL 2000
though.
Andrew J. Kelly SQL MVP
"Bill Todd" <no@.no.com> wrote in message
news:rkutc05gvq269u7h3ajlvhqgo15ovuvu9f@.
4ax.com...
> Are there any known problems with running SQL Server 7 on Win 2003
> Server?
> Thanks,
> --
> Bill|||As Andrew stated, it is an unsupported configuration. Plus, SQL Server 7.0
is a bit long in the tooth.
http://www.aspfaq.com/
(Reverse address to reply.)
"Bill Todd" <no@.no.com> wrote in message
news:rkutc05gvq269u7h3ajlvhqgo15ovuvu9f@.
4ax.com...
> Are there any known problems with running SQL Server 7 on Win 2003
> Server?
> Thanks,
> --
> Bill|||What is the estimated ship date for SQL Server 2005?
Unfortunately upgrading everything at once is not always possible for
small businesses. The goal is to get current without getting
bankrupt.<g>
Thanks for you help and insight.
--
Bill|||I would go the other way first, if you can. Update the things that run your
apps (SQL Server) and then the OS. It's easier, imho, to get the bugs out
of the app migration first, THEN test an OS upgrade. If you go the other
way it's very difficult to backtrack.
http://www.aspfaq.com/
(Reverse address to reply.)
"Bill Todd" <no@.no.com> wrote in message
news:ft6uc0d7aluvok902gu3j8hjo7eeuqf37o@.
4ax.com...
> What is the estimated ship date for SQL Server 2005?
> Unfortunately upgrading everything at once is not always possible for
> small businesses. The goal is to get current without getting
> bankrupt.<g>
> Thanks for you help and insight.
> --
> Bill|||(Plus, you'll never be in unsupported territory.)

> I would go the other way first, if you can. Update the things that run
your
> apps (SQL Server) and then the OS. It's easier, imho, to get the bugs out
> of the app migration first, THEN test an OS upgrade. If you go the other
> way it's very difficult to backtrack.|||No one explains what the problem is between the two. Why is is not compatibl
e would have been a good question. Does it run? Yes it can be loaded. I have
client apps that can not use SQL 2000 (they aren't rewritting the code). I
was in an emergency situati
on that I had to load SQL 7 to get the system back on line ASAP with the new
server they replaced (didn't have time to line MS pockets, yet). All the s
ervice packs loaded OK and the serices ran. I connected my clients with name
d pipes, and the data flowe
d. It has worked flawlessly for weeks, but I'm not doing alot of processing
with it, just data collecting. Sooner than later I will have to get the guru
s to rewrite the code on their app, but I was in a situation to where I had
to use SQL 7 like it or not
. Do I recommend using it, no. but it works in a bind.
"Bill Todd" wrote:

> Are there any known problems with running SQL Server 7 on Win 2003
> Server?
> Thanks,
> --
> Bill
>|||I don't think it is a problem with compatibility per say. SQL Server 7.0
came out before Win2003 and they will not add new functionality to 7.0 since
2000 is the current product. I am sure there are aspects of Win2003 that
7.0 knows nothing about and never will. I have never seen anything that
stated you can not get 7.0 to run but as was stated it is unsupported. So
if you have any problems at all your on your own<g>.
Andrew J. Kelly SQL MVP
"lesman" <lesman@.discussions.microsoft.com> wrote in message
news:E4841986-2E66-41F7-B79D-659B1DC1FE0E@.microsoft.com...
> No one explains what the problem is between the two. Why is is not
compatible would have been a good question. Does it run? Yes it can be
loaded. I have client apps that can not use SQL 2000 (they aren't rewritting
the code). I was in an emergency situation that I had to load SQL 7 to get
the system back on line ASAP with the new server they replaced (didn't have
time to line MS pockets, yet). All the service packs loaded OK and the
serices ran. I connected my clients with named pipes, and the data flowed.
It has worked flawlessly for weeks, but I'm not doing alot of processing
with it, just data collecting. Sooner than later I will have to get the
gurus to rewrite the code on their app, but I was in a situation to where I
had to use SQL 7 like it or not. Do I recommend using it, no. but it works
in a bind.[vbcol=seagreen]
> "Bill Todd" wrote:
>|||> No one explains what the problem is between the two. Why is is not
> compatible would have been a good question.
Nobody said it wasn't compatible. They said it wasn't supported.

> I have client apps that can not use SQL 2000 (they aren't rewritting the
> code).
Can you give an example of something that works in 7.0 and not in 2000? How
about 2000 with the db in 7.0 compat mode?
http://www.aspfaq.com/
(Reverse address to reply.)|||I agree. That is the safe way and I do not want to run an unsupported
combination, just in case... . Thanks for your help.
--
Bill

Any problems with SQL Server 7 on Win 2003 server?

Are there any known problems with running SQL Server 7 on Win 2003
Server?
Thanks,
--
BillI don't believe it is supported on Win2003. You can certainly run SQL 2000
though.
--
Andrew J. Kelly SQL MVP
"Bill Todd" <no@.no.com> wrote in message
news:rkutc05gvq269u7h3ajlvhqgo15ovuvu9f@.4ax.com...
> Are there any known problems with running SQL Server 7 on Win 2003
> Server?
> Thanks,
> --
> Bill|||As Andrew stated, it is an unsupported configuration. Plus, SQL Server 7.0
is a bit long in the tooth.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Bill Todd" <no@.no.com> wrote in message
news:rkutc05gvq269u7h3ajlvhqgo15ovuvu9f@.4ax.com...
> Are there any known problems with running SQL Server 7 on Win 2003
> Server?
> Thanks,
> --
> Bill|||What is the estimated ship date for SQL Server 2005?
Unfortunately upgrading everything at once is not always possible for
small businesses. The goal is to get current without getting
bankrupt.<g>
Thanks for you help and insight.
--
Bill|||I would go the other way first, if you can. Update the things that run your
apps (SQL Server) and then the OS. It's easier, imho, to get the bugs out
of the app migration first, THEN test an OS upgrade. If you go the other
way it's very difficult to backtrack.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Bill Todd" <no@.no.com> wrote in message
news:ft6uc0d7aluvok902gu3j8hjo7eeuqf37o@.4ax.com...
> What is the estimated ship date for SQL Server 2005?
> Unfortunately upgrading everything at once is not always possible for
> small businesses. The goal is to get current without getting
> bankrupt.<g>
> Thanks for you help and insight.
> --
> Bill|||(Plus, you'll never be in unsupported territory.)
> I would go the other way first, if you can. Update the things that run
your
> apps (SQL Server) and then the OS. It's easier, imho, to get the bugs out
> of the app migration first, THEN test an OS upgrade. If you go the other
> way it's very difficult to backtrack.|||No one explains what the problem is between the two. Why is is not compatible would have been a good question. Does it run? Yes it can be loaded. I have client apps that can not use SQL 2000 (they aren't rewritting the code). I was in an emergency situation that I had to load SQL 7 to get the system back on line ASAP with the new server they replaced (didn't have time to line MS pockets, yet). All the service packs loaded OK and the serices ran. I connected my clients with named pipes, and the data flowed. It has worked flawlessly for weeks, but I'm not doing alot of processing with it, just data collecting. Sooner than later I will have to get the gurus to rewrite the code on their app, but I was in a situation to where I had to use SQL 7 like it or not. Do I recommend using it, no. but it works in a bind.
"Bill Todd" wrote:
> Are there any known problems with running SQL Server 7 on Win 2003
> Server?
> Thanks,
> --
> Bill
>|||I don't think it is a problem with compatibility per say. SQL Server 7.0
came out before Win2003 and they will not add new functionality to 7.0 since
2000 is the current product. I am sure there are aspects of Win2003 that
7.0 knows nothing about and never will. I have never seen anything that
stated you can not get 7.0 to run but as was stated it is unsupported. So
if you have any problems at all your on your own<g>.
--
Andrew J. Kelly SQL MVP
"lesman" <lesman@.discussions.microsoft.com> wrote in message
news:E4841986-2E66-41F7-B79D-659B1DC1FE0E@.microsoft.com...
> No one explains what the problem is between the two. Why is is not
compatible would have been a good question. Does it run? Yes it can be
loaded. I have client apps that can not use SQL 2000 (they aren't rewritting
the code). I was in an emergency situation that I had to load SQL 7 to get
the system back on line ASAP with the new server they replaced (didn't have
time to line MS pockets, yet). All the service packs loaded OK and the
serices ran. I connected my clients with named pipes, and the data flowed.
It has worked flawlessly for weeks, but I'm not doing alot of processing
with it, just data collecting. Sooner than later I will have to get the
gurus to rewrite the code on their app, but I was in a situation to where I
had to use SQL 7 like it or not. Do I recommend using it, no. but it works
in a bind.
> "Bill Todd" wrote:
> > Are there any known problems with running SQL Server 7 on Win 2003
> > Server?
> >
> > Thanks,
> > --
> > Bill
> >|||> No one explains what the problem is between the two. Why is is not
> compatible would have been a good question.
Nobody said it wasn't compatible. They said it wasn't supported.
> I have client apps that can not use SQL 2000 (they aren't rewritting the
> code).
Can you give an example of something that works in 7.0 and not in 2000? How
about 2000 with the db in 7.0 compat mode?
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Hi Bill,
Based on my testing, the codes like
Provider=SQLOLEDB; Data Source=Server, 6500; Initial Catalog=pubs; User
ID=sa; Password=;
could run well on my machine. So would you please follow my suggestions in
the previous post to configure port and then try it in Access again?
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I agree. That is the safe way and I do not want to run an unsupported
combination, just in case... :). Thanks for your help.
--
Bill

Any problems with SQL Server 7 on Win 2003 server?

Are there any known problems with running SQL Server 7 on Win 2003
Server?
Thanks,
Bill
I don't believe it is supported on Win2003. You can certainly run SQL 2000
though.
Andrew J. Kelly SQL MVP
"Bill Todd" <no@.no.com> wrote in message
news:rkutc05gvq269u7h3ajlvhqgo15ovuvu9f@.4ax.com...
> Are there any known problems with running SQL Server 7 on Win 2003
> Server?
> Thanks,
> --
> Bill
|||As Andrew stated, it is an unsupported configuration. Plus, SQL Server 7.0
is a bit long in the tooth.
http://www.aspfaq.com/
(Reverse address to reply.)
"Bill Todd" <no@.no.com> wrote in message
news:rkutc05gvq269u7h3ajlvhqgo15ovuvu9f@.4ax.com...
> Are there any known problems with running SQL Server 7 on Win 2003
> Server?
> Thanks,
> --
> Bill
|||What is the estimated ship date for SQL Server 2005?
Unfortunately upgrading everything at once is not always possible for
small businesses. The goal is to get current without getting
bankrupt.<g>
Thanks for you help and insight.
Bill
|||I would go the other way first, if you can. Update the things that run your
apps (SQL Server) and then the OS. It's easier, imho, to get the bugs out
of the app migration first, THEN test an OS upgrade. If you go the other
way it's very difficult to backtrack.
http://www.aspfaq.com/
(Reverse address to reply.)
"Bill Todd" <no@.no.com> wrote in message
news:ft6uc0d7aluvok902gu3j8hjo7eeuqf37o@.4ax.com...
> What is the estimated ship date for SQL Server 2005?
> Unfortunately upgrading everything at once is not always possible for
> small businesses. The goal is to get current without getting
> bankrupt.<g>
> Thanks for you help and insight.
> --
> Bill
|||(Plus, you'll never be in unsupported territory.)

> I would go the other way first, if you can. Update the things that run
your
> apps (SQL Server) and then the OS. It's easier, imho, to get the bugs out
> of the app migration first, THEN test an OS upgrade. If you go the other
> way it's very difficult to backtrack.
|||No one explains what the problem is between the two. Why is is not compatible would have been a good question. Does it run? Yes it can be loaded. I have client apps that can not use SQL 2000 (they aren't rewritting the code). I was in an emergency situati
on that I had to load SQL 7 to get the system back on line ASAP with the new server they replaced (didn't have time to line MS pockets, yet). All the service packs loaded OK and the serices ran. I connected my clients with named pipes, and the data flowe
d. It has worked flawlessly for weeks, but I'm not doing alot of processing with it, just data collecting. Sooner than later I will have to get the gurus to rewrite the code on their app, but I was in a situation to where I had to use SQL 7 like it or not
. Do I recommend using it, no. but it works in a bind.
"Bill Todd" wrote:

> Are there any known problems with running SQL Server 7 on Win 2003
> Server?
> Thanks,
> --
> Bill
>
|||I don't think it is a problem with compatibility per say. SQL Server 7.0
came out before Win2003 and they will not add new functionality to 7.0 since
2000 is the current product. I am sure there are aspects of Win2003 that
7.0 knows nothing about and never will. I have never seen anything that
stated you can not get 7.0 to run but as was stated it is unsupported. So
if you have any problems at all your on your own<g>.
Andrew J. Kelly SQL MVP
"lesman" <lesman@.discussions.microsoft.com> wrote in message
news:E4841986-2E66-41F7-B79D-659B1DC1FE0E@.microsoft.com...
> No one explains what the problem is between the two. Why is is not
compatible would have been a good question. Does it run? Yes it can be
loaded. I have client apps that can not use SQL 2000 (they aren't rewritting
the code). I was in an emergency situation that I had to load SQL 7 to get
the system back on line ASAP with the new server they replaced (didn't have
time to line MS pockets, yet). All the service packs loaded OK and the
serices ran. I connected my clients with named pipes, and the data flowed.
It has worked flawlessly for weeks, but I'm not doing alot of processing
with it, just data collecting. Sooner than later I will have to get the
gurus to rewrite the code on their app, but I was in a situation to where I
had to use SQL 7 like it or not. Do I recommend using it, no. but it works
in a bind.[vbcol=seagreen]
> "Bill Todd" wrote:
|||> No one explains what the problem is between the two. Why is is not
> compatible would have been a good question.
Nobody said it wasn't compatible. They said it wasn't supported.

> I have client apps that can not use SQL 2000 (they aren't rewritting the
> code).
Can you give an example of something that works in 7.0 and not in 2000? How
about 2000 with the db in 7.0 compat mode?
http://www.aspfaq.com/
(Reverse address to reply.)
|||I agree. That is the safe way and I do not want to run an unsupported
combination, just in case... . Thanks for your help.
Bill

2012年2月25日星期六

Any known probs SQL2000 und Server 2003

Hello out there,
we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
not to do so? Anything, we should be aware of?
Thank you!
Bernd
We moved dozens of servers with no problems.
"Bernd Maierhofer (dato)" <bernd.maierhofer@.dato.at> wrote in message
news:Op1fE1SHEHA.3444@.TK2MSFTNGP11.phx.gbl...
> Hello out there,
> we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
> not to do so? Anything, we should be aware of?
> Thank you!
> Bernd
>
|||If you use distributed transactions - it needs additional configuration.
If two are not in same domain you need to disable rpc security.
I cannot remmeber links now - search MS KB.
Bojidar Alexandrov

Any known probs SQL2000 und Server 2003

Hello out there,
we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
not to do so? Anything, we should be aware of?
Thank you!
BerndWe moved dozens of servers with no problems.
"Bernd Maierhofer (dato)" <bernd.maierhofer@.dato.at> wrote in message
news:Op1fE1SHEHA.3444@.TK2MSFTNGP11.phx.gbl...
> Hello out there,
> we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
> not to do so? Anything, we should be aware of?
> Thank you!
> Bernd
>|||If you use distributed transactions - it needs additional configuration.
If two are not in same domain you need to disable rpc security.
I cannot remmeber links now - search MS KB.
Bojidar Alexandrov

Any known probs SQL2000 und Server 2003

Hello out there,
we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
not to do so? Anything, we should be aware of?
Thank you!
BerndWe moved dozens of servers with no problems.
"Bernd Maierhofer (dato)" <bernd.maierhofer@.dato.at> wrote in message
news:Op1fE1SHEHA.3444@.TK2MSFTNGP11.phx.gbl...
> Hello out there,
> we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
> not to do so? Anything, we should be aware of?
> Thank you!
> Bernd
>|||If you use distributed transactions - it needs additional configuration.
If two are not in same domain you need to disable rpc security.
I cannot remmeber links now - search MS KB.
Bojidar Alexandrov

2012年2月23日星期四

any installation no-no's?

We are installing MS Win Server 2003 and my old version (7?) of MSDE is not
supported. So I will download MSDE 2000 and install it. I do not have a lot
of experience installing MSDE. I installed it a few times years ago and, with
a few exceptions, it has run just fine since then.
I vaguely remember that I used all the installation defaults with MSDE. That
led to a problem whenever the administrator, or whoever the user was when it
was installed, changed thier password, the connection to the database no
longer worked.
Can anyone suggest a source of information that might be useful to me to
read before I install MSDE 2000?
Thanks for your help, John Brown
John Brown
hi John,
John Brown wrote:
> We are installing MS Win Server 2003 and my old version (7?) of MSDE
> is not supported. So I will download MSDE 2000 and install it. I do
> not have a lot of experience installing MSDE. I installed it a few
> times years ago and, with a few exceptions, it has run just fine
> since then.
> I vaguely remember that I used all the installation defaults with
> MSDE. That led to a problem whenever the administrator, or whoever
> the user was when it was installed, changed thier password, the
> connection to the database no longer worked.
> Can anyone suggest a source of information that might be useful to me
> to read before I install MSDE 2000?
> Thanks for your help, John Brown
modifying the "sa" password was a problem for MSDE 1.0 relating to Windows
account running the SQL Server Agent, but this does not apply to MSDE
2000... and there are not other problems I'm aware of.. but, of course, you
should have a look at the readme file bundled with the installation
package...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply