Hi dear friends,
I must to install an cluster active-active on SQL Server 2005 with reporting
services and analysis services, can any one help me with references to do it
or links about how do it?.
I know that is no possible to do under SQL 2000 cluster.
A lot of thanks in advange
Clustering Documents
Original SS2K:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
Updated SS2K5:
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
http://msdn2.microsoft.com/en-us/library/ms143736.aspx
http://msdn2.microsoft.com/en-us/library/ms157293.aspx
Sincerely,
Anthony Thomas
"WalidSQL2k5" <WalidSQL2k5@.discussions.microsoft.com> wrote in message
news:E4ACCF02-33F8-4B80-9896-978D78854B49@.microsoft.com...
> Hi dear friends,
> I must to install an cluster active-active on SQL Server 2005 with
reporting
> services and analysis services, can any one help me with references to do
it
> or links about how do it?.
> I know that is no possible to do under SQL 2000 cluster.
> A lot of thanks in advange
>
|||I'm sorry; and for SS2K Analysis Service (yes; you can).
http://support.microsoft.com/kb/308023
Anthony Thomas
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:OwQHuEGOHHA.536@.TK2MSFTNGP02.phx.gbl...
> Clustering Documents
> Original SS2K:
>
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
> Updated SS2K5:
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en[vbcol=seagreen]
> http://msdn2.microsoft.com/en-us/library/ms143736.aspx
> http://msdn2.microsoft.com/en-us/library/ms157293.aspx
> Sincerely,
>
> Anthony Thomas
>
> --
> "WalidSQL2k5" <WalidSQL2k5@.discussions.microsoft.com> wrote in message
> news:E4ACCF02-33F8-4B80-9896-978D78854B49@.microsoft.com...
> reporting
do
> it
>
|||Dear Anthony,
A lot of thanks i thing is more simple to install in this case than SQL
2000.
Best Regards
"Anthony Thomas" wrote:
> I'm sorry; and for SS2K Analysis Service (yes; you can).
> http://support.microsoft.com/kb/308023
>
> Anthony Thomas
>
> --
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:OwQHuEGOHHA.536@.TK2MSFTNGP02.phx.gbl...
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
> do
>
>
|||Yes, quite a bit actually, but it is still doable, kind of like clustering
SQL Server on 6.5 or 7.0.
Anthony Thomas
"WalidSQL2k5" <WalidSQL2k5@.discussions.microsoft.com> wrote in message
news:5BD4CE2B-E878-4329-90F4-30E300059F61@.microsoft.com...[vbcol=seagreen]
> Dear Anthony,
> A lot of thanks i thing is more simple to install in this case than SQL
> 2000.
> --
> Best Regards
>
> "Anthony Thomas" wrote:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx[vbcol=seagreen]
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx[vbcol=seagreen]
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en[vbcol=seagreen]
to[vbcol=seagreen]
sql
Showing posts with label install. Show all posts
Showing posts with label install. Show all posts
Friday, March 30, 2012
Okay to install sp3a over sp3?
We intended to install sp3a but ended up installing sp3 by mistake. According to the web site, if you have installed sp3, "you don't need to install sp3a," but my question is would there be any harm in doing so? We know that an issue we're having is fix
ed in sp3a and we don't want to pull individual hotfixes.
>> We know that an issue we're having is fixed in sp3a and we don't want to
pull individual hotfixes.
Which issue is that? AFAIK, there were no changes to the database engine
itself between sp3 and sp3a. The changes were in the setup program, MDAC
and net libraries.
A
|||It's an issue with performance on a few ERP applications. We believe it is due to MDAC 2.7 and will be fixed with MDAC 2.71a, as other ERP customers have posted along those lines. Would it make more sense/be possible simply to upgrade MDAC instead of th
e SQL service pack? Or, as per my original question, will there be any problem with just upgrading to sp3a?
"Aaron [SQL Server MVP]" wrote:
> pull individual hotfixes.
> Which issue is that? AFAIK, there were no changes to the database engine
> itself between sp3 and sp3a. The changes were in the setup program, MDAC
> and net libraries.
> A
>
>
|||> Would it make more sense/be possible simply to upgrade MDAC instead of the
SQL service pack?
Yes!
http://www.aspfaq.com/
(Reverse address to reply.)
|||Okay. But...
If we still experience the issue, is it okay to go from sp3
to sp3a?
"Aaron [SQL Server MVP]" wrote:
> SQL service pack?
> Yes!
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
|||You're more than welcome to, but I really don't think that's going to solve
any performance issues.
http://www.aspfaq.com/
(Reverse address to reply.)
"smaas@.newsgroups.nospam" <smaasnewsgroupsnospam@.discussions.microsoft.com >
wrote in message news:265021CB-C08C-4054-B0CE-B5E53FA58F1C@.microsoft.com...[vbcol=seagreen]
> Okay. But... If we still experience the issue, is it okay to go from
> sp3
> to sp3a?
> "Aaron [SQL Server MVP]" wrote:
sql
ed in sp3a and we don't want to pull individual hotfixes.
>> We know that an issue we're having is fixed in sp3a and we don't want to
pull individual hotfixes.
Which issue is that? AFAIK, there were no changes to the database engine
itself between sp3 and sp3a. The changes were in the setup program, MDAC
and net libraries.
A
|||It's an issue with performance on a few ERP applications. We believe it is due to MDAC 2.7 and will be fixed with MDAC 2.71a, as other ERP customers have posted along those lines. Would it make more sense/be possible simply to upgrade MDAC instead of th
e SQL service pack? Or, as per my original question, will there be any problem with just upgrading to sp3a?
"Aaron [SQL Server MVP]" wrote:
> pull individual hotfixes.
> Which issue is that? AFAIK, there were no changes to the database engine
> itself between sp3 and sp3a. The changes were in the setup program, MDAC
> and net libraries.
> A
>
>
|||> Would it make more sense/be possible simply to upgrade MDAC instead of the
SQL service pack?
Yes!
http://www.aspfaq.com/
(Reverse address to reply.)
|||Okay. But...
If we still experience the issue, is it okay to go from sp3to sp3a?
"Aaron [SQL Server MVP]" wrote:
> SQL service pack?
> Yes!
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
|||You're more than welcome to, but I really don't think that's going to solve
any performance issues.
http://www.aspfaq.com/
(Reverse address to reply.)
"smaas@.newsgroups.nospam" <smaasnewsgroupsnospam@.discussions.microsoft.com >
wrote in message news:265021CB-C08C-4054-B0CE-B5E53FA58F1C@.microsoft.com...[vbcol=seagreen]
> Okay. But...
If we still experience the issue, is it okay to go from> sp3
> to sp3a?
> "Aaron [SQL Server MVP]" wrote:
sql
Okay to install sp3a over sp3?
We intended to install sp3a but ended up installing sp3 by mistake. Accordi
ng to the web site, if you have installed sp3, "you don't need to install sp
3a," but my question is would there be any harm in doing so? We know that a
n issue we're having is fix
ed in sp3a and we don't want to pull individual hotfixes.>> We know that an issue we're having is fixed in sp3a and we don't want to
pull individual hotfixes.
Which issue is that? AFAIK, there were no changes to the database engine
itself between sp3 and sp3a. The changes were in the setup program, MDAC
and net libraries.
A|||It's an issue with performance on a few ERP applications. We believe it is
due to MDAC 2.7 and will be fixed with MDAC 2.71a, as other ERP customers ha
ve posted along those lines. Would it make more sense/be possible simply to
upgrade MDAC instead of th
e SQL service pack? Or, as per my original question, will there be any prob
lem with just upgrading to sp3a?
"Aaron [SQL Server MVP]" wrote:
> pull individual hotfixes.
> Which issue is that? AFAIK, there were no changes to the database engine
> itself between sp3 and sp3a. The changes were in the setup program, MDAC
> and net libraries.
> A
>
>|||> Would it make more sense/be possible simply to upgrade MDAC instead of the
SQL service pack?
Yes!
http://www.aspfaq.com/
(Reverse address to reply.)|||Okay. But... If we still experience the issue, is it okay to go from sp
3
to sp3a?
"Aaron [SQL Server MVP]" wrote:
> SQL service pack?
> Yes!
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||You're more than welcome to, but I really don't think that's going to solve
any performance issues.
http://www.aspfaq.com/
(Reverse address to reply.)
"smaas@.newsgroups.nospam" <smaasnewsgroupsnospam@.discussions.microsoft.com>
wrote in message news:265021CB-C08C-4054-B0CE-B5E53FA58F1C@.microsoft.com...[vbcol=seagreen]
> Okay. But... If we still experience the issue, is it okay to go from
> sp3
> to sp3a?
> "Aaron [SQL Server MVP]" wrote:
>
ng to the web site, if you have installed sp3, "you don't need to install sp
3a," but my question is would there be any harm in doing so? We know that a
n issue we're having is fix
ed in sp3a and we don't want to pull individual hotfixes.>> We know that an issue we're having is fixed in sp3a and we don't want to
pull individual hotfixes.
Which issue is that? AFAIK, there were no changes to the database engine
itself between sp3 and sp3a. The changes were in the setup program, MDAC
and net libraries.
A|||It's an issue with performance on a few ERP applications. We believe it is
due to MDAC 2.7 and will be fixed with MDAC 2.71a, as other ERP customers ha
ve posted along those lines. Would it make more sense/be possible simply to
upgrade MDAC instead of th
e SQL service pack? Or, as per my original question, will there be any prob
lem with just upgrading to sp3a?
"Aaron [SQL Server MVP]" wrote:
> pull individual hotfixes.
> Which issue is that? AFAIK, there were no changes to the database engine
> itself between sp3 and sp3a. The changes were in the setup program, MDAC
> and net libraries.
> A
>
>|||> Would it make more sense/be possible simply to upgrade MDAC instead of the
SQL service pack?
Yes!
http://www.aspfaq.com/
(Reverse address to reply.)|||Okay. But...
If we still experience the issue, is it okay to go from sp3
to sp3a?
"Aaron [SQL Server MVP]" wrote:
> SQL service pack?
> Yes!
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||You're more than welcome to, but I really don't think that's going to solve
any performance issues.
http://www.aspfaq.com/
(Reverse address to reply.)
"smaas@.newsgroups.nospam" <smaasnewsgroupsnospam@.discussions.microsoft.com>
wrote in message news:265021CB-C08C-4054-B0CE-B5E53FA58F1C@.microsoft.com...[vbcol=seagreen]
> Okay. But...
If we still experience the issue, is it okay to go from> sp3
> to sp3a?
> "Aaron [SQL Server MVP]" wrote:
>
Ok.. Step 2 of my clustering
I managed to successfully install the Windows clustering service on Node 1
of my active\passive setup environement on win2003.
The only thing i had done on Node 2 was install the OS and did not configure
the shared disks on the shared array...
I now powered Node 2 and wanted to go to disk management to configure those
shared disks. What am I supposed to see ? Would they be inaccessible because
Node 1 has the cluster service installed and owns this disk resource...or
should I be able to access them and configure them the same way as Node 1
with the same drive letters,etc.. and then join that node to the cluster..
Thanks
If MSCS is installed and the cluster service is running on Node 1, the disks
should be inaccessible on Node 2.
Regards,
John
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e3MBpg4EEHA.1240@.TK2MSFTNGP10.phx.gbl...
> I managed to successfully install the Windows clustering service on Node 1
> of my active\passive setup environement on win2003.
> The only thing i had done on Node 2 was install the OS and did not
configure
> the shared disks on the shared array...
> I now powered Node 2 and wanted to go to disk management to configure
those
> shared disks. What am I supposed to see ? Would they be inaccessible
because
> Node 1 has the cluster service installed and owns this disk resource...or
> should I be able to access them and configure them the same way as Node 1
> with the same drive letters,etc.. and then join that node to the cluster..
> Thanks
>
of my active\passive setup environement on win2003.
The only thing i had done on Node 2 was install the OS and did not configure
the shared disks on the shared array...
I now powered Node 2 and wanted to go to disk management to configure those
shared disks. What am I supposed to see ? Would they be inaccessible because
Node 1 has the cluster service installed and owns this disk resource...or
should I be able to access them and configure them the same way as Node 1
with the same drive letters,etc.. and then join that node to the cluster..
Thanks
If MSCS is installed and the cluster service is running on Node 1, the disks
should be inaccessible on Node 2.
Regards,
John
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e3MBpg4EEHA.1240@.TK2MSFTNGP10.phx.gbl...
> I managed to successfully install the Windows clustering service on Node 1
> of my active\passive setup environement on win2003.
> The only thing i had done on Node 2 was install the OS and did not
configure
> the shared disks on the shared array...
> I now powered Node 2 and wanted to go to disk management to configure
those
> shared disks. What am I supposed to see ? Would they be inaccessible
because
> Node 1 has the cluster service installed and owns this disk resource...or
> should I be able to access them and configure them the same way as Node 1
> with the same drive letters,etc.. and then join that node to the cluster..
> Thanks
>
Wednesday, March 28, 2012
ok to install sql2005/2000,vs2005/2003 on same machine
Hi just wondering if anyone has run into any problems installing and running
vs2005 and sql 2005 prof with a machine that already has sql2000 and vs2003,
or if it will effect sql 2000 or vs2003 in any way, thanks.
--
Paul G
Software engineer.I run this configuration. It does work. I installed a certificate on my web
server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
it was working well.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> Hi just wondering if anyone has run into any problems installing and
> running
> vs2005 and sql 2005 prof with a machine that already has sql2000 and
> vs2003,
> or if it will effect sql 2000 or vs2003 in any way, thanks.
> --
> Paul G
> Software engineer.|||thanks for the response. I think I am having problems with the installation
.
For components to install it lists SQL Server Database Services, Analysis
Services, Reporting Services, Integration Services, Workstations Components,
Books online and development tools. It seems to install without error but I
do not see SQL server management studio from the programs list.
--
Paul G
Software engineer.
"Hilary Cotter" wrote:
> I run this configuration. It does work. I installed a certificate on my we
b
> server and suddenly I couldn't connect to SQL 2000 anymore. Other than tha
t
> it was working well.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
>
>|||Chances are this is because you installed SQL Express with Visual Studio
before you installed SQL Server 2005. This leaves you with the SQL Express
client utilities which don't include Management Studio. Try uninstalling
the client utilities and then reinstalling them from the full SQL Server
2005 release.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...[vbcol=seagreen]
> thanks for the response. I think I am having problems with the
> installation.
> For components to install it lists SQL Server Database Services, Analysis
> Services, Reporting Services, Integration Services, Workstations
> Components,
> Books online and development tools. It seems to install without error but
> I
> do not see SQL server management studio from the programs list.
> --
> Paul G
> Software engineer.
>
> "Hilary Cotter" wrote:
>|||ok thanks that seemed to work!
--
Paul G
Software engineer.
"Roger Wolter[MSFT]" wrote:
> Chances are this is because you installed SQL Express with Visual Studio
> before you installed SQL Server 2005. This leaves you with the SQL Expres
s
> client utilities which don't include Management Studio. Try uninstalling
> the client utilities and then reinstalling them from the full SQL Server
> 2005 release.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
>
>sql
vs2005 and sql 2005 prof with a machine that already has sql2000 and vs2003,
or if it will effect sql 2000 or vs2003 in any way, thanks.
--
Paul G
Software engineer.I run this configuration. It does work. I installed a certificate on my web
server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
it was working well.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> Hi just wondering if anyone has run into any problems installing and
> running
> vs2005 and sql 2005 prof with a machine that already has sql2000 and
> vs2003,
> or if it will effect sql 2000 or vs2003 in any way, thanks.
> --
> Paul G
> Software engineer.|||thanks for the response. I think I am having problems with the installation
.
For components to install it lists SQL Server Database Services, Analysis
Services, Reporting Services, Integration Services, Workstations Components,
Books online and development tools. It seems to install without error but I
do not see SQL server management studio from the programs list.
--
Paul G
Software engineer.
"Hilary Cotter" wrote:
> I run this configuration. It does work. I installed a certificate on my we
b
> server and suddenly I couldn't connect to SQL 2000 anymore. Other than tha
t
> it was working well.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
>
>|||Chances are this is because you installed SQL Express with Visual Studio
before you installed SQL Server 2005. This leaves you with the SQL Express
client utilities which don't include Management Studio. Try uninstalling
the client utilities and then reinstalling them from the full SQL Server
2005 release.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...[vbcol=seagreen]
> thanks for the response. I think I am having problems with the
> installation.
> For components to install it lists SQL Server Database Services, Analysis
> Services, Reporting Services, Integration Services, Workstations
> Components,
> Books online and development tools. It seems to install without error but
> I
> do not see SQL server management studio from the programs list.
> --
> Paul G
> Software engineer.
>
> "Hilary Cotter" wrote:
>|||ok thanks that seemed to work!
--
Paul G
Software engineer.
"Roger Wolter[MSFT]" wrote:
> Chances are this is because you installed SQL Express with Visual Studio
> before you installed SQL Server 2005. This leaves you with the SQL Expres
s
> client utilities which don't include Management Studio. Try uninstalling
> the client utilities and then reinstalling them from the full SQL Server
> 2005 release.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
>
>sql
ok to install sql2005/2000,vs2005/2003 on same machine
Hi just wondering if anyone has run into any problems installing and running
vs2005 and sql 2005 prof with a machine that already has sql2000 and vs2003,
or if it will effect sql 2000 or vs2003 in any way, thanks.
--
Paul G
Software engineer.I run this configuration. It does work. I installed a certificate on my web
server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
it was working well.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> Hi just wondering if anyone has run into any problems installing and
> running
> vs2005 and sql 2005 prof with a machine that already has sql2000 and
> vs2003,
> or if it will effect sql 2000 or vs2003 in any way, thanks.
> --
> Paul G
> Software engineer.|||thanks for the response. I think I am having problems with the installation.
For components to install it lists SQL Server Database Services, Analysis
Services, Reporting Services, Integration Services, Workstations Components,
Books online and development tools. It seems to install without error but I
do not see SQL server management studio from the programs list.
--
Paul G
Software engineer.
"Hilary Cotter" wrote:
> I run this configuration. It does work. I installed a certificate on my web
> server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
> it was working well.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> > Hi just wondering if anyone has run into any problems installing and
> > running
> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
> > vs2003,
> > or if it will effect sql 2000 or vs2003 in any way, thanks.
> > --
> > Paul G
> > Software engineer.
>
>|||Chances are this is because you installed SQL Express with Visual Studio
before you installed SQL Server 2005. This leaves you with the SQL Express
client utilities which don't include Management Studio. Try uninstalling
the client utilities and then reinstalling them from the full SQL Server
2005 release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
> thanks for the response. I think I am having problems with the
> installation.
> For components to install it lists SQL Server Database Services, Analysis
> Services, Reporting Services, Integration Services, Workstations
> Components,
> Books online and development tools. It seems to install without error but
> I
> do not see SQL server management studio from the programs list.
> --
> Paul G
> Software engineer.
>
> "Hilary Cotter" wrote:
>> I run this configuration. It does work. I installed a certificate on my
>> web
>> server and suddenly I couldn't connect to SQL 2000 anymore. Other than
>> that
>> it was working well.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
>> > Hi just wondering if anyone has run into any problems installing and
>> > running
>> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
>> > vs2003,
>> > or if it will effect sql 2000 or vs2003 in any way, thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>|||ok thanks that seemed to work!
--
Paul G
Software engineer.
"Roger Wolter[MSFT]" wrote:
> Chances are this is because you installed SQL Express with Visual Studio
> before you installed SQL Server 2005. This leaves you with the SQL Express
> client utilities which don't include Management Studio. Try uninstalling
> the client utilities and then reinstalling them from the full SQL Server
> 2005 release.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
> > thanks for the response. I think I am having problems with the
> > installation.
> > For components to install it lists SQL Server Database Services, Analysis
> > Services, Reporting Services, Integration Services, Workstations
> > Components,
> > Books online and development tools. It seems to install without error but
> > I
> > do not see SQL server management studio from the programs list.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "Hilary Cotter" wrote:
> >
> >> I run this configuration. It does work. I installed a certificate on my
> >> web
> >> server and suddenly I couldn't connect to SQL 2000 anymore. Other than
> >> that
> >> it was working well.
> >>
> >> --
> >> Hilary Cotter
> >> Looking for a SQL Server replication book?
> >> http://www.nwsu.com/0974973602.html
> >>
> >> Looking for a FAQ on Indexing Services/SQL FTS
> >> http://www.indexserverfaq.com
> >>
> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> >> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> >> > Hi just wondering if anyone has run into any problems installing and
> >> > running
> >> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
> >> > vs2003,
> >> > or if it will effect sql 2000 or vs2003 in any way, thanks.
> >> > --
> >> > Paul G
> >> > Software engineer.
> >>
> >>
> >>
>
>
vs2005 and sql 2005 prof with a machine that already has sql2000 and vs2003,
or if it will effect sql 2000 or vs2003 in any way, thanks.
--
Paul G
Software engineer.I run this configuration. It does work. I installed a certificate on my web
server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
it was working well.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> Hi just wondering if anyone has run into any problems installing and
> running
> vs2005 and sql 2005 prof with a machine that already has sql2000 and
> vs2003,
> or if it will effect sql 2000 or vs2003 in any way, thanks.
> --
> Paul G
> Software engineer.|||thanks for the response. I think I am having problems with the installation.
For components to install it lists SQL Server Database Services, Analysis
Services, Reporting Services, Integration Services, Workstations Components,
Books online and development tools. It seems to install without error but I
do not see SQL server management studio from the programs list.
--
Paul G
Software engineer.
"Hilary Cotter" wrote:
> I run this configuration. It does work. I installed a certificate on my web
> server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
> it was working well.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> > Hi just wondering if anyone has run into any problems installing and
> > running
> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
> > vs2003,
> > or if it will effect sql 2000 or vs2003 in any way, thanks.
> > --
> > Paul G
> > Software engineer.
>
>|||Chances are this is because you installed SQL Express with Visual Studio
before you installed SQL Server 2005. This leaves you with the SQL Express
client utilities which don't include Management Studio. Try uninstalling
the client utilities and then reinstalling them from the full SQL Server
2005 release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
> thanks for the response. I think I am having problems with the
> installation.
> For components to install it lists SQL Server Database Services, Analysis
> Services, Reporting Services, Integration Services, Workstations
> Components,
> Books online and development tools. It seems to install without error but
> I
> do not see SQL server management studio from the programs list.
> --
> Paul G
> Software engineer.
>
> "Hilary Cotter" wrote:
>> I run this configuration. It does work. I installed a certificate on my
>> web
>> server and suddenly I couldn't connect to SQL 2000 anymore. Other than
>> that
>> it was working well.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
>> > Hi just wondering if anyone has run into any problems installing and
>> > running
>> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
>> > vs2003,
>> > or if it will effect sql 2000 or vs2003 in any way, thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>|||ok thanks that seemed to work!
--
Paul G
Software engineer.
"Roger Wolter[MSFT]" wrote:
> Chances are this is because you installed SQL Express with Visual Studio
> before you installed SQL Server 2005. This leaves you with the SQL Express
> client utilities which don't include Management Studio. Try uninstalling
> the client utilities and then reinstalling them from the full SQL Server
> 2005 release.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
> > thanks for the response. I think I am having problems with the
> > installation.
> > For components to install it lists SQL Server Database Services, Analysis
> > Services, Reporting Services, Integration Services, Workstations
> > Components,
> > Books online and development tools. It seems to install without error but
> > I
> > do not see SQL server management studio from the programs list.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "Hilary Cotter" wrote:
> >
> >> I run this configuration. It does work. I installed a certificate on my
> >> web
> >> server and suddenly I couldn't connect to SQL 2000 anymore. Other than
> >> that
> >> it was working well.
> >>
> >> --
> >> Hilary Cotter
> >> Looking for a SQL Server replication book?
> >> http://www.nwsu.com/0974973602.html
> >>
> >> Looking for a FAQ on Indexing Services/SQL FTS
> >> http://www.indexserverfaq.com
> >>
> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> >> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> >> > Hi just wondering if anyone has run into any problems installing and
> >> > running
> >> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
> >> > vs2003,
> >> > or if it will effect sql 2000 or vs2003 in any way, thanks.
> >> > --
> >> > Paul G
> >> > Software engineer.
> >>
> >>
> >>
>
>
OK to install Outlook 2003 client on an SQL Server 2005?
Hello,
I have an SQL 2005 server which is lightly used and I'd like to
install Outlook 2003 on it for a conversion utility which has nothing
to do with SQL.
Will installing Outlook cause problems for the SQL Server please?
Thanks,
- Alan.I've been using both of them on the same machine for a long time and I
haven't met a problem related to Outlook yet.
--
Ekrem Önsoy
"Alan" <bruguy@.gmail.com> wrote in message
news:1194340629.291591.23270@.k79g2000hse.googlegroups.com...
> Hello,
> I have an SQL 2005 server which is lightly used and I'd like to
> install Outlook 2003 on it for a conversion utility which has nothing
> to do with SQL.
> Will installing Outlook cause problems for the SQL Server please?
> Thanks,
> - Alan.
>|||That's good enough for me, thanks.
On Nov 6, 12:15 pm, Ekrem =D6nsoy <ek...@.btegitim.com> wrote:
> I've been using both of them on the same machine for a long time and I
> haven't met a problem related to Outlook yet.
> --
> Ekrem =D6nsoy
> "Alan" <bru...@.gmail.com> wrote in message
> news:1194340629.291591.23270@.k79g2000hse.googlegroups.com...
> > Hello,
> > I have an SQL 2005 server which is lightly used and I'd like to
> > install Outlook 2003 on it for a conversion utility which has nothing
> > to do with SQL.
> > Will installing Outlook cause problems for the SQL Server please?
> > Thanks,
> > - Alan.
I have an SQL 2005 server which is lightly used and I'd like to
install Outlook 2003 on it for a conversion utility which has nothing
to do with SQL.
Will installing Outlook cause problems for the SQL Server please?
Thanks,
- Alan.I've been using both of them on the same machine for a long time and I
haven't met a problem related to Outlook yet.
--
Ekrem Önsoy
"Alan" <bruguy@.gmail.com> wrote in message
news:1194340629.291591.23270@.k79g2000hse.googlegroups.com...
> Hello,
> I have an SQL 2005 server which is lightly used and I'd like to
> install Outlook 2003 on it for a conversion utility which has nothing
> to do with SQL.
> Will installing Outlook cause problems for the SQL Server please?
> Thanks,
> - Alan.
>|||That's good enough for me, thanks.
On Nov 6, 12:15 pm, Ekrem =D6nsoy <ek...@.btegitim.com> wrote:
> I've been using both of them on the same machine for a long time and I
> haven't met a problem related to Outlook yet.
> --
> Ekrem =D6nsoy
> "Alan" <bru...@.gmail.com> wrote in message
> news:1194340629.291591.23270@.k79g2000hse.googlegroups.com...
> > Hello,
> > I have an SQL 2005 server which is lightly used and I'd like to
> > install Outlook 2003 on it for a conversion utility which has nothing
> > to do with SQL.
> > Will installing Outlook cause problems for the SQL Server please?
> > Thanks,
> > - Alan.
OK to delete sql2ksp3 folder after install?
I'm desperate for room on my "C" drive at the moment.
I've installed the SP3 for SQL Server 2000. Is it OK to remove the sql2ksp3
folder from my C drive now?
(and even though this is off topic, does anyone know how to increase the siz
e of the "C" partition on W2K AS?
I have 2 18GB drives in a RAID1 config. They are basic disks and are going
to stay that way. The system is
running in production mode, and between Dell, MSFT, and 2 partition tools I
cannot seem to find anyone who
can give me an authoritative 'yes' and how to do it. They all just want to
point to the other guys and have me
get the answer there.)
Thanks in advance for whatever help anyone can provide.
randyRandy,
Yes you should be able to remove that folder. As for increasing the
partition that's probably not an option. If it's a Raid 1 and you created
it initially with all the space in the primary partition you have no room to
grow. Can you be more specific as to where you need the room etc?
Andrew J. Kelly
SQL Server MVP
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:B5439337-990F-4542-8EC9-FF41701FDFFB@.microsoft.com...
> I'm desperate for room on my "C" drive at the moment.
> I've installed the SP3 for SQL Server 2000. Is it OK to remove the
sql2ksp3 folder from my C drive now?
> (and even though this is off topic, does anyone know how to increase the
size of the "C" partition on W2K AS?
> I have 2 18GB drives in a RAID1 config. They are basic disks and are
going to stay that way. The system is
> running in production mode, and between Dell, MSFT, and 2 partition tools
I cannot seem to find anyone who
> can give me an authoritative 'yes' and how to do it. They all just want
to point to the other guys and have me
> get the answer there.)
> Thanks in advance for whatever help anyone can provide.
> randy|||Hi Randy,
Thanks for using the newsgroup.
Yes, you could remove the sql2ksp3 folder because it is just a folder for
install files.
As for the question space of your Windows 2000 advanced server, we do have
related newsgroup and you could ask your question at:
http://communities2.microsoft.com/c...s/default.aspx?
dg=microsoft.public.win2000.advanced_server
OR
News:microsoft.public.win2000.advanced_server
Our related engineers there will help you with this issue.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thanks Andres and Baisong -
I'll check out the other group for my partition question.
Just to close it out here, I do have more room available. The two disks in
the RAID are both 18Giggers. So, I have
approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive par
tition. Why not just create a "D" partition?
Well, we are holding out the possibility of rebuilding our cluster, and the
other server was just redone - however, this time
with a little more help from Dell using Server Asst. we got the full use of
the drive. So I'm trying to do this one the same.
At this point I'm pretty much resigned to having to blow this one away as so
on as we have the other server up.
Why do we need that big a "C" drive? Well besides having paid for the stora
ge and wanting to use it, believe it or
not there are still companies (like AVAYA) that build applications that MUST
be put in the C drive's programs folder.
ARRRRRRRGGGGGGGGGHHHHHHH. ;-)
Thanks again.|||Just FYI, it helps if you supply all the information to get correct
responses for your issue. You did not initially mention the drives only
had 4GB out of 18GB partitioned. That kind of information goes a long way.
Andrew J. Kelly
SQL Server MVP
"randyvol" <anonymous@.discussions.microsoft.com> wrote in message
news:5572D410-FF1B-43D9-BD01-EF04388DB162@.microsoft.com...
> Thanks Andres and Baisong -
> I'll check out the other group for my partition question.
> Just to close it out here, I do have more room available. The two disks
in the RAID are both 18Giggers. So, I have
> approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive
partition. Why not just create a "D" partition?
> Well, we are holding out the possibility of rebuilding our cluster, and
the other server was just redone - however, this time
> with a little more help from Dell using Server Asst. we got the full use
of the drive. So I'm trying to do this one the same.
> At this point I'm pretty much resigned to having to blow this one away as
soon as we have the other server up.
> Why do we need that big a "C" drive? Well besides having paid for the
storage and wanting to use it, believe it or
> not there are still companies (like AVAYA) that build applications that
MUST be put in the C drive's programs folder.
> ARRRRRRRGGGGGGGGGHHHHHHH. ;-)
> Thanks again.|||Since you say that they are basic disks and not dynamic, Partition Magic
should be able to resize the 4 gig partitions.
David Walker
I've installed the SP3 for SQL Server 2000. Is it OK to remove the sql2ksp3
folder from my C drive now?
(and even though this is off topic, does anyone know how to increase the siz
e of the "C" partition on W2K AS?
I have 2 18GB drives in a RAID1 config. They are basic disks and are going
to stay that way. The system is
running in production mode, and between Dell, MSFT, and 2 partition tools I
cannot seem to find anyone who
can give me an authoritative 'yes' and how to do it. They all just want to
point to the other guys and have me
get the answer there.)
Thanks in advance for whatever help anyone can provide.
randyRandy,
Yes you should be able to remove that folder. As for increasing the
partition that's probably not an option. If it's a Raid 1 and you created
it initially with all the space in the primary partition you have no room to
grow. Can you be more specific as to where you need the room etc?
Andrew J. Kelly
SQL Server MVP
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:B5439337-990F-4542-8EC9-FF41701FDFFB@.microsoft.com...
> I'm desperate for room on my "C" drive at the moment.
> I've installed the SP3 for SQL Server 2000. Is it OK to remove the
sql2ksp3 folder from my C drive now?
> (and even though this is off topic, does anyone know how to increase the
size of the "C" partition on W2K AS?
> I have 2 18GB drives in a RAID1 config. They are basic disks and are
going to stay that way. The system is
> running in production mode, and between Dell, MSFT, and 2 partition tools
I cannot seem to find anyone who
> can give me an authoritative 'yes' and how to do it. They all just want
to point to the other guys and have me
> get the answer there.)
> Thanks in advance for whatever help anyone can provide.
> randy|||Hi Randy,
Thanks for using the newsgroup.
Yes, you could remove the sql2ksp3 folder because it is just a folder for
install files.
As for the question space of your Windows 2000 advanced server, we do have
related newsgroup and you could ask your question at:
http://communities2.microsoft.com/c...s/default.aspx?
dg=microsoft.public.win2000.advanced_server
OR
News:microsoft.public.win2000.advanced_server
Our related engineers there will help you with this issue.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thanks Andres and Baisong -
I'll check out the other group for my partition question.
Just to close it out here, I do have more room available. The two disks in
the RAID are both 18Giggers. So, I have
approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive par
tition. Why not just create a "D" partition?
Well, we are holding out the possibility of rebuilding our cluster, and the
other server was just redone - however, this time
with a little more help from Dell using Server Asst. we got the full use of
the drive. So I'm trying to do this one the same.
At this point I'm pretty much resigned to having to blow this one away as so
on as we have the other server up.
Why do we need that big a "C" drive? Well besides having paid for the stora
ge and wanting to use it, believe it or
not there are still companies (like AVAYA) that build applications that MUST
be put in the C drive's programs folder.
ARRRRRRRGGGGGGGGGHHHHHHH. ;-)
Thanks again.|||Just FYI, it helps if you supply all the information to get correct
responses for your issue. You did not initially mention the drives only
had 4GB out of 18GB partitioned. That kind of information goes a long way.
Andrew J. Kelly
SQL Server MVP
"randyvol" <anonymous@.discussions.microsoft.com> wrote in message
news:5572D410-FF1B-43D9-BD01-EF04388DB162@.microsoft.com...
> Thanks Andres and Baisong -
> I'll check out the other group for my partition question.
> Just to close it out here, I do have more room available. The two disks
in the RAID are both 18Giggers. So, I have
> approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive
partition. Why not just create a "D" partition?
> Well, we are holding out the possibility of rebuilding our cluster, and
the other server was just redone - however, this time
> with a little more help from Dell using Server Asst. we got the full use
of the drive. So I'm trying to do this one the same.
> At this point I'm pretty much resigned to having to blow this one away as
soon as we have the other server up.
> Why do we need that big a "C" drive? Well besides having paid for the
storage and wanting to use it, believe it or
> not there are still companies (like AVAYA) that build applications that
MUST be put in the C drive's programs folder.
> ARRRRRRRGGGGGGGGGHHHHHHH. ;-)
> Thanks again.|||Since you say that they are basic disks and not dynamic, Partition Magic
should be able to resize the 4 gig partitions.
David Walker
OK to delete sql2ksp3 folder after install?
I'm desperate for room on my "C" drive at the moment
I've installed the SP3 for SQL Server 2000. Is it OK to remove the sql2ksp3 folder from my C drive now
(and even though this is off topic, does anyone know how to increase the size of the "C" partition on W2K AS
I have 2 18GB drives in a RAID1 config. They are basic disks and are going to stay that way. The system i
running in production mode, and between Dell, MSFT, and 2 partition tools I cannot seem to find anyone wh
can give me an authoritative 'yes' and how to do it. They all just want to point to the other guys and have m
get the answer there.
Thanks in advance for whatever help anyone can provide
randyRandy,
Yes you should be able to remove that folder. As for increasing the
partition that's probably not an option. If it's a Raid 1 and you created
it initially with all the space in the primary partition you have no room to
grow. Can you be more specific as to where you need the room etc?
--
Andrew J. Kelly
SQL Server MVP
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:B5439337-990F-4542-8EC9-FF41701FDFFB@.microsoft.com...
> I'm desperate for room on my "C" drive at the moment.
> I've installed the SP3 for SQL Server 2000. Is it OK to remove the
sql2ksp3 folder from my C drive now?
> (and even though this is off topic, does anyone know how to increase the
size of the "C" partition on W2K AS?
> I have 2 18GB drives in a RAID1 config. They are basic disks and are
going to stay that way. The system is
> running in production mode, and between Dell, MSFT, and 2 partition tools
I cannot seem to find anyone who
> can give me an authoritative 'yes' and how to do it. They all just want
to point to the other guys and have me
> get the answer there.)
> Thanks in advance for whatever help anyone can provide.
> randy|||Hi Randy,
Thanks for using the newsgroup.
Yes, you could remove the sql2ksp3 folder because it is just a folder for
install files.
As for the question space of your windows 2000 advanced server, we do have
related newsgroup and you could ask your question at:
http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?
dg=microsoft.public.win2000.advanced_server
OR
News:microsoft.public.win2000.advanced_server
Our related engineers there will help you with this issue.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thanks Andres and Baisong -
I'll check out the other group for my partition question
Just to close it out here, I do have more room available. The two disks in the RAID are both 18Giggers. So, I have
approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive partition. Why not just create a "D" partition
Well, we are holding out the possibility of rebuilding our cluster, and the other server was just redone - however, this time
with a little more help from Dell using Server Asst. we got the full use of the drive. So I'm trying to do this one the same
At this point I'm pretty much resigned to having to blow this one away as soon as we have the other server up
Why do we need that big a "C" drive? Well besides having paid for the storage and wanting to use it, believe it o
not there are still companies (like AVAYA) that build applications that MUST be put in the C drive's programs folder
ARRRRRRRGGGGGGGGGHHHHHHH. ;-
Thanks again.|||Just FYI, it helps if you supply all the information to get correct
responses for your issue. You did not initially mention the drives only
had 4GB out of 18GB partitioned. That kind of information goes a long way.
--
Andrew J. Kelly
SQL Server MVP
"randyvol" <anonymous@.discussions.microsoft.com> wrote in message
news:5572D410-FF1B-43D9-BD01-EF04388DB162@.microsoft.com...
> Thanks Andres and Baisong -
> I'll check out the other group for my partition question.
> Just to close it out here, I do have more room available. The two disks
in the RAID are both 18Giggers. So, I have
> approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive
partition. Why not just create a "D" partition?
> Well, we are holding out the possibility of rebuilding our cluster, and
the other server was just redone - however, this time
> with a little more help from Dell using Server Asst. we got the full use
of the drive. So I'm trying to do this one the same.
> At this point I'm pretty much resigned to having to blow this one away as
soon as we have the other server up.
> Why do we need that big a "C" drive? Well besides having paid for the
storage and wanting to use it, believe it or
> not there are still companies (like AVAYA) that build applications that
MUST be put in the C drive's programs folder.
> ARRRRRRRGGGGGGGGGHHHHHHH. ;-)
> Thanks again.|||Since you say that they are basic disks and not dynamic, Partition Magic
should be able to resize the 4 gig partitions.
David Walker
I've installed the SP3 for SQL Server 2000. Is it OK to remove the sql2ksp3 folder from my C drive now
(and even though this is off topic, does anyone know how to increase the size of the "C" partition on W2K AS
I have 2 18GB drives in a RAID1 config. They are basic disks and are going to stay that way. The system i
running in production mode, and between Dell, MSFT, and 2 partition tools I cannot seem to find anyone wh
can give me an authoritative 'yes' and how to do it. They all just want to point to the other guys and have m
get the answer there.
Thanks in advance for whatever help anyone can provide
randyRandy,
Yes you should be able to remove that folder. As for increasing the
partition that's probably not an option. If it's a Raid 1 and you created
it initially with all the space in the primary partition you have no room to
grow. Can you be more specific as to where you need the room etc?
--
Andrew J. Kelly
SQL Server MVP
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:B5439337-990F-4542-8EC9-FF41701FDFFB@.microsoft.com...
> I'm desperate for room on my "C" drive at the moment.
> I've installed the SP3 for SQL Server 2000. Is it OK to remove the
sql2ksp3 folder from my C drive now?
> (and even though this is off topic, does anyone know how to increase the
size of the "C" partition on W2K AS?
> I have 2 18GB drives in a RAID1 config. They are basic disks and are
going to stay that way. The system is
> running in production mode, and between Dell, MSFT, and 2 partition tools
I cannot seem to find anyone who
> can give me an authoritative 'yes' and how to do it. They all just want
to point to the other guys and have me
> get the answer there.)
> Thanks in advance for whatever help anyone can provide.
> randy|||Hi Randy,
Thanks for using the newsgroup.
Yes, you could remove the sql2ksp3 folder because it is just a folder for
install files.
As for the question space of your windows 2000 advanced server, we do have
related newsgroup and you could ask your question at:
http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?
dg=microsoft.public.win2000.advanced_server
OR
News:microsoft.public.win2000.advanced_server
Our related engineers there will help you with this issue.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thanks Andres and Baisong -
I'll check out the other group for my partition question
Just to close it out here, I do have more room available. The two disks in the RAID are both 18Giggers. So, I have
approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive partition. Why not just create a "D" partition
Well, we are holding out the possibility of rebuilding our cluster, and the other server was just redone - however, this time
with a little more help from Dell using Server Asst. we got the full use of the drive. So I'm trying to do this one the same
At this point I'm pretty much resigned to having to blow this one away as soon as we have the other server up
Why do we need that big a "C" drive? Well besides having paid for the storage and wanting to use it, believe it o
not there are still companies (like AVAYA) that build applications that MUST be put in the C drive's programs folder
ARRRRRRRGGGGGGGGGHHHHHHH. ;-
Thanks again.|||Just FYI, it helps if you supply all the information to get correct
responses for your issue. You did not initially mention the drives only
had 4GB out of 18GB partitioned. That kind of information goes a long way.
--
Andrew J. Kelly
SQL Server MVP
"randyvol" <anonymous@.discussions.microsoft.com> wrote in message
news:5572D410-FF1B-43D9-BD01-EF04388DB162@.microsoft.com...
> Thanks Andres and Baisong -
> I'll check out the other group for my partition question.
> Just to close it out here, I do have more room available. The two disks
in the RAID are both 18Giggers. So, I have
> approx. 12 GB of unallocated space just beyond the initial 4GB "C" drive
partition. Why not just create a "D" partition?
> Well, we are holding out the possibility of rebuilding our cluster, and
the other server was just redone - however, this time
> with a little more help from Dell using Server Asst. we got the full use
of the drive. So I'm trying to do this one the same.
> At this point I'm pretty much resigned to having to blow this one away as
soon as we have the other server up.
> Why do we need that big a "C" drive? Well besides having paid for the
storage and wanting to use it, believe it or
> not there are still companies (like AVAYA) that build applications that
MUST be put in the C drive's programs folder.
> ARRRRRRRGGGGGGGGGHHHHHHH. ;-)
> Thanks again.|||Since you say that they are basic disks and not dynamic, Partition Magic
should be able to resize the 4 gig partitions.
David Walker
Monday, March 19, 2012
Odbcping
Hye,
I have client tools only, install on my computers. and I wolud like to use
odbcping from my machin. does it possible to install the odbcping, because
right now i dont have it install on my computer.
Regards,
Dubka.
The odbcping utility is no longer installed by SQL Server 2000 Setup.
If you need to run odbcping utility you can run it from the x:\x86\Binn
directory on the SQL Server 2000 compact disc, or manually copy it to your
computer.
Cristian Lefter, SQL Server MVP
"??" <@.discussions.microsoft.com> wrote in message
news:B10B69C9-D831-405C-AFB0-BA58B37A282B@.microsoft.com...
> Hye,
> I have client tools only, install on my computers. and I wolud like to use
> odbcping from my machin. does it possible to install the odbcping, because
> right now i dont have it install on my computer.
> Regards,
> Dubka.
I have client tools only, install on my computers. and I wolud like to use
odbcping from my machin. does it possible to install the odbcping, because
right now i dont have it install on my computer.
Regards,
Dubka.
The odbcping utility is no longer installed by SQL Server 2000 Setup.
If you need to run odbcping utility you can run it from the x:\x86\Binn
directory on the SQL Server 2000 compact disc, or manually copy it to your
computer.
Cristian Lefter, SQL Server MVP
"??" <@.discussions.microsoft.com> wrote in message
news:B10B69C9-D831-405C-AFB0-BA58B37A282B@.microsoft.com...
> Hye,
> I have client tools only, install on my computers. and I wolud like to use
> odbcping from my machin. does it possible to install the odbcping, because
> right now i dont have it install on my computer.
> Regards,
> Dubka.
Saturday, February 25, 2012
ODBC Problem after install SP3 on SQL 2000
After install SP3 on SQL server 2000, some computers can't connect to the SQL server through ODBC.
Connection failed:
SQL State: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Open(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driber][DBNETLIB]SQL Server does not exist or
access denied
Please helpRE:
Q1 After install SP3 on SQL server 2000, some computers can't connect to the SQL server through ODBC. Please help
A1 Consider checking general network connectivity (ping the server from the workstations). If network connectivity is present consider verifying / checking the DSNs in use (verify protocol settings, etc., and test the connection) and / or use the MDAC compatibility checking tool to assess MDAC component status. See: http://www.microsoft.com/data/download.htm#CCinfo
http://download.microsoft.com/downl...XP/EN-US/cc.exe|||Ping the server OK
Already checked Client Network Utility and Server Network Utility. Both use TCP and NamePipe.
Run MDAC check already.
ODBC still don't work.
Connection failed:
SQL State: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Open(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driber][DBNETLIB]SQL Server does not exist or
access denied
Please helpRE:
Q1 After install SP3 on SQL server 2000, some computers can't connect to the SQL server through ODBC. Please help
A1 Consider checking general network connectivity (ping the server from the workstations). If network connectivity is present consider verifying / checking the DSNs in use (verify protocol settings, etc., and test the connection) and / or use the MDAC compatibility checking tool to assess MDAC component status. See: http://www.microsoft.com/data/download.htm#CCinfo
http://download.microsoft.com/downl...XP/EN-US/cc.exe|||Ping the server OK
Already checked Client Network Utility and Server Network Utility. Both use TCP and NamePipe.
Run MDAC check already.
ODBC still don't work.
Subscribe to:
Posts (Atom)