Multi Server Jobs

I am running two instances of SQL Server 2005 Developer Edition (SP1) on the
same machine. Both SQL Server and Agent services use a local user account
which is member of Windows Administrators. The wizard for Enlisting TSX
fails with the following report:
Enlist TSX Progress
- Create MSXOperator (Success)
Checking for an existing MSXOperator.
Updating existing MSXOperator.
Successfully updated MSXOperator.
- Make sure the Agent service for 'NIMA\sql2005_1' is running (Success)
The service 'SQLAgent$SQL2005_1' is running.
- Enlist 'NIMA\sql2005_2' into 'NIMA\sql2005_1' (Error)
Enlisting target server 'NIMA\sql2005_2' with master server
'NIMA\sql2005_1'.
Using new enlistment method.
Messages
MSX enlist failed for JobServer 'NIMA\sql2005_2'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=MSX+enlist+JobServer&LinkId=20476
--
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The enlist operation failed (reason: SQLServerAgent Error: Unable to connect
to server. .) (Microsoft SQL Server, Error: 22026)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=22026&LinkId=20476
Any help would be greatly appreciated,
leilaHello Leila,
Personally MSX is really bad in RTM and SP1. a huge number of fixes are in
SP2.
Have you tried a domain account for SQL Agent?
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> I am running two instances of SQL Server 2005 Developer Edition (SP1)
> on the same machine. Both SQL Server and Agent services use a local
> user account which is member of Windows Administrators. The wizard for
> Enlisting TSX fails with the following report:
> Enlist TSX Progress
> - Create MSXOperator (Success)
> Checking for an existing MSXOperator.
> Updating existing MSXOperator.
> Successfully updated MSXOperator.
> - Make sure the Agent service for 'NIMA\sql2005_1' is running
> (Success)
> The service 'SQLAgent$SQL2005_1' is running.
> - Enlist 'NIMA\sql2005_2' into 'NIMA\sql2005_1' (Error)
> Enlisting target server 'NIMA\sql2005_2' with master server
> 'NIMA\sql2005_1'.
> Using new enlistment method.
> Messages
> MSX enlist failed for JobServer 'NIMA\sql2005_2'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9
> .00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplat
> es.FailedOperationExceptionText&EvtID=MSX+enlist+JobServer&LinkId=2047
> 6
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> --
> The enlist operation failed (reason: SQLServerAgent Error: Unable to
> connect to server. .) (Microsoft SQL Server, Error: 22026)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=0
> 9.00.2047&EvtSrc=MSSQLServer&EvtID=22026&LinkId=20476
> Any help would be greatly appreciated,
> leil|||Actually I don't have a domain on my notebook, I have used .\username for
agents.
"Simon Sabin" <SimonSabin@.noemail.noemail> wrote in message
news:62959f1a43cc68c90a27d3a103d4@.msnews.microsoft.com...
> Hello Leila,
> Personally MSX is really bad in RTM and SP1. a huge number of fixes are in
> SP2.
> Have you tried a domain account for SQL Agent?
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
>> I am running two instances of SQL Server 2005 Developer Edition (SP1)
>> on the same machine. Both SQL Server and Agent services use a local
>> user account which is member of Windows Administrators. The wizard for
>> Enlisting TSX fails with the following report:
>> Enlist TSX Progress
>> - Create MSXOperator (Success)
>> Checking for an existing MSXOperator.
>> Updating existing MSXOperator.
>> Successfully updated MSXOperator.
>> - Make sure the Agent service for 'NIMA\sql2005_1' is running
>> (Success)
>> The service 'SQLAgent$SQL2005_1' is running.
>> - Enlist 'NIMA\sql2005_2' into 'NIMA\sql2005_1' (Error)
>> Enlisting target server 'NIMA\sql2005_2' with master server
>> 'NIMA\sql2005_1'.
>> Using new enlistment method.
>> Messages
>> MSX enlist failed for JobServer 'NIMA\sql2005_2'.
>> (Microsoft.SqlServer.Smo)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9
>> .00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplat
>> es.FailedOperationExceptionText&EvtID=MSX+enlist+JobServer&LinkId=2047
>> 6
>> --
>> ADDITIONAL INFORMATION:
>> An exception occurred while executing a Transact-SQL statement or
>> batch. (Microsoft.SqlServer.ConnectionInfo)
>> --
>> The enlist operation failed (reason: SQLServerAgent Error: Unable to
>> connect to server. .) (Microsoft SQL Server, Error: 22026)
>> For help, click:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=0
>> 9.00.2047&EvtSrc=MSSQLServer&EvtID=22026&LinkId=20476
>> Any help would be greatly appreciated,
>> leila
>

Multi Server Jobs

I am running two instances of SQL Server 2005 Developer Edition (SP1) on the
same machine. Both SQL Server and Agent services use a local user account
which is member of Windows Administrators. The wizard for Enlisting TSX
fails with the following report:
Enlist TSX Progress
- Create MSXOperator (Success)
Checking for an existing MSXOperator.
Updating existing MSXOperator.
Successfully updated MSXOperator.
- Make sure the Agent service for 'NIMA\sql2005_1' is running (Success)
The service 'SQLAgent$SQL2005_1' is running.
- Enlist 'NIMA\sql2005_2' into 'NIMA\sql2005_1' (Error)
Enlisting target server 'NIMA\sql2005_2' with master server
'NIMA\sql2005_1'.
Using new enlistment method.
Messages
MSX enlist failed for JobServer 'NIMA\sql2005_2'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The enlist operation failed (reason: SQLServerAgent Error: Unable to connect
to server. .) (Microsoft SQL Server, Error: 22026)
For help, click:
http://go.microsoft.com/fwlink?Prod...26&LinkId=20476
Any help would be greatly appreciated,
leilaHello Leila,
Personally MSX is really bad in RTM and SP1. a huge number of fixes are in
SP2.
Have you tried a domain account for SQL Agent?
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> I am running two instances of SQL Server 2005 Developer Edition (SP1)
> on the same machine. Both SQL Server and Agent services use a local
> user account which is member of Windows Administrators. The wizard for
> Enlisting TSX fails with the following report:
> Enlist TSX Progress
> - Create MSXOperator (Success)
> Checking for an existing MSXOperator.
> Updating existing MSXOperator.
> Successfully updated MSXOperator.
> - Make sure the Agent service for 'NIMA\sql2005_1' is running
> (Success)
> The service 'SQLAgent$SQL2005_1' is running.
> - Enlist 'NIMA\sql2005_2' into 'NIMA\sql2005_1' (Error)
> Enlisting target server 'NIMA\sql2005_2' with master server
> 'NIMA\sql2005_1'.
> Using new enlistment method.
> Messages
> MSX enlist failed for JobServer 'NIMA\sql2005_2'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...erver&ProdVer=9
> .00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplat
> es.FailedOperationExceptionText&EvtID=MSX+enlist+JobServer&LinkId=2047
> 6
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> --
> The enlist operation failed (reason: SQLServerAgent Error: Unable to
> connect to server. .) (Microsoft SQL Server, Error: 22026)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...erver&ProdVer=0
> 9.00.2047&EvtSrc=MSSQLServer&EvtID=22026&LinkId=20476
> Any help would be greatly appreciated,
> leila|||Actually I don't have a domain on my notebook, I have used .\username for
agents.
"Simon Sabin" <SimonSabin@.noemail.noemail> wrote in message
news:62959f1a43cc68c90a27d3a103d4@.msnews
.microsoft.com...
> Hello Leila,
> Personally MSX is really bad in RTM and SP1. a huge number of fixes are in
> SP2.
> Have you tried a domain account for SQL Agent?
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
>sql

Multi Server Jobs

I am running two instances of SQL Server 2005 Developer Edition (SP1) on the
same machine. Both SQL Server and Agent services use a local user account
which is member of Windows Administrators. The wizard for Enlisting TSX
fails with the following report:
Enlist TSX Progress
- Create MSXOperator (Success)
Checking for an existing MSXOperator.
Updating existing MSXOperator.
Successfully updated MSXOperator.
- Make sure the Agent service for 'NIMA\sql2005_1' is running (Success)
The service 'SQLAgent$SQL2005_1' is running.
- Enlist 'NIMA\sql2005_2' into 'NIMA\sql2005_1' (Error)
Enlisting target server 'NIMA\sql2005_2' with master server
'NIMA\sql2005_1'.
Using new enlistment method.
Messages
MSX enlist failed for JobServer 'NIMA\sql2005_2'. (Microsoft.SqlServer.Smo)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=MSX+enlist+JobServer&LinkId=20476[/url]
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The enlist operation failed (reason: SQLServerAgent Error: Unable to connect
to server. .) (Microsoft SQL Server, Error: 22026)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .2047&EvtSrc=MSSQLServer&EvtID=22026&LinkId=20476[ /url]
Any help would be greatly appreciated,
leila
Hello Leila,
Personally MSX is really bad in RTM and SP1. a huge number of fixes are in
SP2.
Have you tried a domain account for SQL Agent?
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> I am running two instances of SQL Server 2005 Developer Edition (SP1)
> on the same machine. Both SQL Server and Agent services use a local
> user account which is member of Windows Administrators. The wizard for
> Enlisting TSX fails with the following report:
> Enlist TSX Progress
> - Create MSXOperator (Success)
> Checking for an existing MSXOperator.
> Updating existing MSXOperator.
> Successfully updated MSXOperator.
> - Make sure the Agent service for 'NIMA\sql2005_1' is running
> (Success)
> The service 'SQLAgent$SQL2005_1' is running.
> - Enlist 'NIMA\sql2005_2' into 'NIMA\sql2005_1' (Error)
> Enlisting target server 'NIMA\sql2005_2' with master server
> 'NIMA\sql2005_1'.
> Using new enlistment method.
> Messages
> MSX enlist failed for JobServer 'NIMA\sql2005_2'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9
> .00.2047.00&EvtSrc=Microsoft.SqlServer.Management. Smo.ExceptionTemplat
> es.FailedOperationExceptionText&EvtID=MSX+enlist+J obServer&LinkId=2047
> 6
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> --
> The enlist operation failed (reason: SQLServerAgent Error: Unable to
> connect to server. .) (Microsoft SQL Server, Error: 22026)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=0
> 9.00.2047&EvtSrc=MSSQLServer&EvtID=22026&LinkId=20 476
> Any help would be greatly appreciated,
> leila
|||Actually I don't have a domain on my notebook, I have used .\username for
agents.
"Simon Sabin" <SimonSabin@.noemail.noemail> wrote in message
news:62959f1a43cc68c90a27d3a103d4@.msnews.microsoft .com...
> Hello Leila,
> Personally MSX is really bad in RTM and SP1. a huge number of fixes are in
> SP2.
> Have you tried a domain account for SQL Agent?
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
>

multi processors

I have a quad processor machine not running hyperthreading. I am also
running sQL enterprise additions. I would like to understand why the
processing load is not distrubuted evenly. The second and third processors
seem to have most of the utilization.
I assume that you have configured SQL Server to use all processors via
sp_configure and the affinity mask. SQL Server will split and distribute
the query load as it sees fit. You might not end up with a perfect
distribution of processor utilization.
exec sp_configure 'affinity mask'
/*
to use all processors:
exec sp_configure 'affinity mask' , 0
*/
Keith
"Ruth Henderson" <Ruth Henderson@.discussions.microsoft.com> wrote in message
news:2BB0F14B-CA24-4EB4-B120-F88044A2B55F@.microsoft.com...
> I have a quad processor machine not running hyperthreading. I am also
> running sQL enterprise additions. I would like to understand why the
> processing load is not distrubuted evenly. The second and third
processors
> seem to have most of the utilization.
|||There can be several reasons. First, all threads do not require the same
amount of processor resource so there will always be some imbalance.
Second, Windows binds physical processors to service particular IO cards, so
your NIC and Disk subsystems are likely bound to the second and third
processors. On very-multi-processor systems (16-way and up) excluding
certain processors from SQL because of this OS binding can improve
performance. On a four-way box, you are best to leave things as is.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ruth Henderson" <Ruth Henderson@.discussions.microsoft.com> wrote in message
news:2BB0F14B-CA24-4EB4-B120-F88044A2B55F@.microsoft.com...
> I have a quad processor machine not running hyperthreading. I am also
> running sQL enterprise additions. I would like to understand why the
> processing load is not distrubuted evenly. The second and third
processors
> seem to have most of the utilization.

multi processors

I have a quad processor machine not running hyperthreading. I am also
running sQL enterprise additions. I would like to understand why the
processing load is not distrubuted evenly. The second and third processors
seem to have most of the utilization.I assume that you have configured SQL Server to use all processors via
sp_configure and the affinity mask. SQL Server will split and distribute
the query load as it sees fit. You might not end up with a perfect
distribution of processor utilization.
exec sp_configure 'affinity mask'
/*
to use all processors:
exec sp_configure 'affinity mask' , 0
*/
--
Keith
"Ruth Henderson" <Ruth Henderson@.discussions.microsoft.com> wrote in message
news:2BB0F14B-CA24-4EB4-B120-F88044A2B55F@.microsoft.com...
> I have a quad processor machine not running hyperthreading. I am also
> running sQL enterprise additions. I would like to understand why the
> processing load is not distrubuted evenly. The second and third
processors
> seem to have most of the utilization.|||There can be several reasons. First, all threads do not require the same
amount of processor resource so there will always be some imbalance.
Second, Windows binds physical processors to service particular IO cards, so
your NIC and Disk subsystems are likely bound to the second and third
processors. On very-multi-processor systems (16-way and up) excluding
certain processors from SQL because of this OS binding can improve
performance. On a four-way box, you are best to leave things as is.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ruth Henderson" <Ruth Henderson@.discussions.microsoft.com> wrote in message
news:2BB0F14B-CA24-4EB4-B120-F88044A2B55F@.microsoft.com...
> I have a quad processor machine not running hyperthreading. I am also
> running sQL enterprise additions. I would like to understand why the
> processing load is not distrubuted evenly. The second and third
processors
> seem to have most of the utilization.

multi processors

I have a quad processor machine not running hyperthreading. I am also
running sQL enterprise additions. I would like to understand why the
processing load is not distrubuted evenly. The second and third processors
seem to have most of the utilization.I assume that you have configured SQL Server to use all processors via
sp_configure and the affinity mask. SQL Server will split and distribute
the query load as it sees fit. You might not end up with a perfect
distribution of processor utilization.
exec sp_configure 'affinity mask'
/*
to use all processors:
exec sp_configure 'affinity mask' , 0
*/
Keith
"Ruth Henderson" <Ruth Henderson@.discussions.microsoft.com> wrote in message
news:2BB0F14B-CA24-4EB4-B120-F88044A2B55F@.microsoft.com...
> I have a quad processor machine not running hyperthreading. I am also
> running sQL enterprise additions. I would like to understand why the
> processing load is not distrubuted evenly. The second and third
processors
> seem to have most of the utilization.|||There can be several reasons. First, all threads do not require the same
amount of processor resource so there will always be some imbalance.
Second, Windows binds physical processors to service particular IO cards, so
your NIC and Disk subsystems are likely bound to the second and third
processors. On very-multi-processor systems (16-way and up) excluding
certain processors from SQL because of this OS binding can improve
performance. On a four-way box, you are best to leave things as is.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ruth Henderson" <Ruth Henderson@.discussions.microsoft.com> wrote in message
news:2BB0F14B-CA24-4EB4-B120-F88044A2B55F@.microsoft.com...
> I have a quad processor machine not running hyperthreading. I am also
> running sQL enterprise additions. I would like to understand why the
> processing load is not distrubuted evenly. The second and third
processors
> seem to have most of the utilization.sql

multi instances of sql server

Hi,
if I have 3 instances of sql server 2000 on a machine, how to use Enterprise
Manager - sql query analyzer to get a list of them all (name, current status,
the databases under each of them)? or have to use some other tool to do it?
thank you very much!
As I gather they are not showing up, check to see if these instances are
using TCP/IP or NAMED PIPES. [Start Programs - Microsoft SQL Server - SERVER
NETWORK UTILITY]. They may not show in the active directory - or at least
not allow connections - if one of these two protocols is not enabled.
Regards,
Jamie
"bangwo" wrote:

> Hi,
> if I have 3 instances of sql server 2000 on a machine, how to use Enterprise
> Manager - sql query analyzer to get a list of them all (name, current status,
> the databases under each of them)? or have to use some other tool to do it?
> thank you very much!
sql

multi instances of sql server

Hi,
if I have 3 instances of sql server 2000 on a machine, how to use Enterprise
Manager - sql query analyzer to get a list of them all (name, current status
,
the databases under each of them)? or have to use some other tool to do it?
thank you very much!As I gather they are not showing up, check to see if these instances are
using TCP/IP or NAMED PIPES. [Start Programs - Microsoft SQL Server - S
ERVER
NETWORK UTILITY]. They may not show in the active directory - or at least
not allow connections - if one of these two protocols is not enabled.
--
Regards,
Jamie
"bangwo" wrote:

> Hi,
> if I have 3 instances of sql server 2000 on a machine, how to use Enterpri
se
> Manager - sql query analyzer to get a list of them all (name, current stat
us,
> the databases under each of them)? or have to use some other tool to do i
t?
> thank you very much!

Multable database on one machine

Total newbie question i know.
The company i just started working for has SQL 2000 installed on four
machines. Is there any info i can get about putting all database on one
machine, Then having an application server running the apps (Great Plains
7.5, Sharepoint, track-it, and a custom made database)
Thanks
LeeYes, you can have multiple databases on the same machine, and on the same
instance of SQL Server. Your limitations are: (a) two databases can't have
the same name, or expect their data/log files to have the same path, and (b)
the available resources on the server. If it's a low-powered box it may
perform acceptably hosting one application's database
As for the right way to perform the consolidation, if you are comfortable
that it is the right move, there are several options. Andrew Kelly has
posted this list of KB articles that should help you out:
http://tinyurl.com/up5ok
"Lee J" <faked@.fc.com> wrote in message
news:ejg6to$5ap@.dispatch.concentric.net...
> Total newbie question i know.
> The company i just started working for has SQL 2000 installed on four
> machines. Is there any info i can get about putting all database on one
> machine, Then having an application server running the apps (Great Plains
> 7.5, Sharepoint, track-it, and a custom made database)
> Thanks
> Lee
>|||Great, Thank you, I am looking to be buying some new blade servers
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
> Yes, you can have multiple databases on the same machine, and on the same
> instance of SQL Server. Your limitations are: (a) two databases can't
> have the same name, or expect their data/log files to have the same path,
> and (b) the available resources on the server. If it's a low-powered box
> it may perform acceptably hosting one application's database
> As for the right way to perform the consolidation, if you are comfortable
> that it is the right move, there are several options. Andrew Kelly has
> posted this list of KB articles that should help you out:
> http://tinyurl.com/up5ok
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great Plains
>> 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>|||Wow, I don't think I've come across anyone successfully running SQL Server
on a blade, but hey, all the best.
Actually I'm sitting with Geoff at PASS and he said that, unfortunately, he
has seen this, and it didn't work out too well. But again, all the best.
If it works out, please let us know. :-)
"Lee J" <faked@.fc.com> wrote in message
news:ejg8fo$5s5@.dispatch.concentric.net...
> Great, Thank you, I am looking to be buying some new blade servers
>
> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>> Yes, you can have multiple databases on the same machine, and on the same
>> instance of SQL Server. Your limitations are: (a) two databases can't
>> have the same name, or expect their data/log files to have the same path,
>> and (b) the available resources on the server. If it's a low-powered box
>> it may perform acceptably hosting one application's database
>> As for the right way to perform the consolidation, if you are comfortable
>> that it is the right move, there are several options. Andrew Kelly has
>> posted this list of KB articles that should help you out:
>> http://tinyurl.com/up5ok
>>
>> "Lee J" <faked@.fc.com> wrote in message
>> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great
>> Plains 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>>
>|||well, thats good to know, i am just in the discovery stage.
what kind of specs do you recommed?
My most heavly used database is on a dual 1GHz intel with 2GB of RAM. The
blades i was looking at were dual 1.8 xeons with 2GB.
this kind has landed on my lap
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OQi6PFRCHHA.4908@.TK2MSFTNGP03.phx.gbl...
> Wow, I don't think I've come across anyone successfully running SQL Server
> on a blade, but hey, all the best.
> Actually I'm sitting with Geoff at PASS and he said that, unfortunately,
> he has seen this, and it didn't work out too well. But again, all the
> best. If it works out, please let us know. :-)
>
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg8fo$5s5@.dispatch.concentric.net...
>> Great, Thank you, I am looking to be buying some new blade servers
>>
>> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>> Yes, you can have multiple databases on the same machine, and on the
>> same instance of SQL Server. Your limitations are: (a) two databases
>> can't have the same name, or expect their data/log files to have the
>> same path, and (b) the available resources on the server. If it's a
>> low-powered box it may perform acceptably hosting one application's
>> database
>> As for the right way to perform the consolidation, if you are
>> comfortable that it is the right move, there are several options.
>> Andrew Kelly has posted this list of KB articles that should help you
>> out:
>> http://tinyurl.com/up5ok
>>
>> "Lee J" <faked@.fc.com> wrote in message
>> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great
>> Plains 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>>
>>
>

Multable database on one machine

Total newbie question i know.
The company i just started working for has SQL 2000 installed on four
machines. Is there any info i can get about putting all database on one
machine, Then having an application server running the apps (Great Plains
7.5, Sharepoint, track-it, and a custom made database)
Thanks
Lee
Yes, you can have multiple databases on the same machine, and on the same
instance of SQL Server. Your limitations are: (a) two databases can't have
the same name, or expect their data/log files to have the same path, and (b)
the available resources on the server. If it's a low-powered box it may
perform acceptably hosting one application's database
As for the right way to perform the consolidation, if you are comfortable
that it is the right move, there are several options. Andrew Kelly has
posted this list of KB articles that should help you out:
http://tinyurl.com/up5ok
"Lee J" <faked@.fc.com> wrote in message
news:ejg6to$5ap@.dispatch.concentric.net...
> Total newbie question i know.
> The company i just started working for has SQL 2000 installed on four
> machines. Is there any info i can get about putting all database on one
> machine, Then having an application server running the apps (Great Plains
> 7.5, Sharepoint, track-it, and a custom made database)
> Thanks
> Lee
>
|||Great, Thank you, I am looking to be buying some new blade servers
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
> Yes, you can have multiple databases on the same machine, and on the same
> instance of SQL Server. Your limitations are: (a) two databases can't
> have the same name, or expect their data/log files to have the same path,
> and (b) the available resources on the server. If it's a low-powered box
> it may perform acceptably hosting one application's database
> As for the right way to perform the consolidation, if you are comfortable
> that it is the right move, there are several options. Andrew Kelly has
> posted this list of KB articles that should help you out:
> http://tinyurl.com/up5ok
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg6to$5ap@.dispatch.concentric.net...
>
|||Wow, I don't think I've come across anyone successfully running SQL Server
on a blade, but hey, all the best.
Actually I'm sitting with Geoff at PASS and he said that, unfortunately, he
has seen this, and it didn't work out too well. But again, all the best.
If it works out, please let us know. :-)
"Lee J" <faked@.fc.com> wrote in message
news:ejg8fo$5s5@.dispatch.concentric.net...
> Great, Thank you, I am looking to be buying some new blade servers
>
> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>
|||well, thats good to know, i am just in the discovery stage.
what kind of specs do you recommed?
My most heavly used database is on a dual 1GHz intel with 2GB of RAM. The
blades i was looking at were dual 1.8 xeons with 2GB.
this kind has landed on my lap
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OQi6PFRCHHA.4908@.TK2MSFTNGP03.phx.gbl...
> Wow, I don't think I've come across anyone successfully running SQL Server
> on a blade, but hey, all the best.
> Actually I'm sitting with Geoff at PASS and he said that, unfortunately,
> he has seen this, and it didn't work out too well. But again, all the
> best. If it works out, please let us know. :-)
>
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg8fo$5s5@.dispatch.concentric.net...
>

Multable database on one machine

Total newbie question i know.
The company i just started working for has SQL 2000 installed on four
machines. Is there any info i can get about putting all database on one
machine, Then having an application server running the apps (Great Plains
7.5, Sharepoint, track-it, and a custom made database)
Thanks
LeeYes, you can have multiple databases on the same machine, and on the same
instance of SQL Server. Your limitations are: (a) two databases can't have
the same name, or expect their data/log files to have the same path, and (b)
the available resources on the server. If it's a low-powered box it may
perform acceptably hosting one application's database
As for the right way to perform the consolidation, if you are comfortable
that it is the right move, there are several options. Andrew Kelly has
posted this list of KB articles that should help you out:
http://tinyurl.com/up5ok
"Lee J" <faked@.fc.com> wrote in message
news:ejg6to$5ap@.dispatch.concentric.net...
> Total newbie question i know.
> The company i just started working for has SQL 2000 installed on four
> machines. Is there any info i can get about putting all database on one
> machine, Then having an application server running the apps (Great Plains
> 7.5, Sharepoint, track-it, and a custom made database)
> Thanks
> Lee
>|||Great, Thank you, I am looking to be buying some new blade servers
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
> Yes, you can have multiple databases on the same machine, and on the same
> instance of SQL Server. Your limitations are: (a) two databases can't
> have the same name, or expect their data/log files to have the same path,
> and (b) the available resources on the server. If it's a low-powered box
> it may perform acceptably hosting one application's database
> As for the right way to perform the consolidation, if you are comfortable
> that it is the right move, there are several options. Andrew Kelly has
> posted this list of KB articles that should help you out:
> http://tinyurl.com/up5ok
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg6to$5ap@.dispatch.concentric.net...
>|||Wow, I don't think I've come across anyone successfully running SQL Server
on a blade, but hey, all the best.
Actually I'm sitting with Geoff at PASS and he said that, unfortunately, he
has seen this, and it didn't work out too well. But again, all the best.
If it works out, please let us know. :-)
"Lee J" <faked@.fc.com> wrote in message
news:ejg8fo$5s5@.dispatch.concentric.net...
> Great, Thank you, I am looking to be buying some new blade servers
>
> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>|||well, thats good to know, i am just in the discovery stage.
what kind of specs do you recommed?
My most heavly used database is on a dual 1GHz intel with 2GB of RAM. The
blades i was looking at were dual 1.8 xeons with 2GB.
this kind has landed on my lap
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OQi6PFRCHHA.4908@.TK2MSFTNGP03.phx.gbl...
> Wow, I don't think I've come across anyone successfully running SQL Server
> on a blade, but hey, all the best.
> Actually I'm sitting with Geoff at PASS and he said that, unfortunately,
> he has seen this, and it didn't work out too well. But again, all the
> best. If it works out, please let us know. :-)
>
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg8fo$5s5@.dispatch.concentric.net...
>

Mulitiple DBs

Folk
I have multiple SQL SERVERs over 15 Servers. I have couple of test machines. I don't want to go to every machine and add evry single registration of every servers in mmc. that just way too much work. can i import an mmc console from one machine to another
if yes , how can i do it
Thank
GirishI exported registry keys under
HKEY_CURRENT_USER\Software\Microsoft\MSSQLServer\SQLEW\Registered
Servers X
when I did it last time on MSSQL7
Bart Simpson
Last time
On Tue, 2 Mar 2004 08:36:07 -0800, Girish
<anonymous@.discussions.microsoft.com> wrote:
>Folks
>I have multiple SQL SERVERs over 15 Servers. I have couple of test machines. I don't want to go to every machine and add evry single registration of every servers in mmc. that just way too much work. can i import an mmc console from one machine to another ?
>if yes , how can i do it ?
>Thanks
>Girish

Mulitiple DBs

Folks
I have multiple SQL SERVERs over 15 Servers. I have couple of test machines.
I don't want to go to every machine and add evry single registration of eve
ry servers in mmc. that just way too much work. can i import an mmc console
from one machine to another
?
if yes , how can i do it ?
Thanks
GirishI exported registry keys under
HKEY_CURRENT_USER\Software\Microsoft\MSS
QLServer\SQLEW\Registered
Servers X
when I did it last time on MSSQL7
Bart Simpson
Last time
On Tue, 2 Mar 2004 08:36:07 -0800, Girish
<anonymous@.discussions.microsoft.com> wrote:

>Folks
>I have multiple SQL SERVERs over 15 Servers. I have couple of test machines. I don'
t want to go to every machine and add evry single registration of every servers in m
mc. that just way too much work. can i import an mmc console from one machine to ano
the
r ?
>if yes , how can i do it ?
>Thanks
>Girish

MSSQLSERVER service isnt starting

Hi everybody!
I need to move data from SQL Server7 to SQLServer2000 that is installed on a different machine.
Could anybody please advise a good way to do that?

I've installed SQLServer7 on a new machine, stopped MSSQLSERVER service ,started SQLServer in a single user mode (using sqlservr.exe from Command Prompt),successfully restored master db from the backup. When I tried ro start MSSQLSERVER service via Services console, get message "Could not start the MSSQLSERVER service on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error." I have Windows 2000 server.
Thank you in advanceHave you tried a detach and attach?|||detach and attach what? I use these sps dor databases. But I even can't start server|||check your private messages for my reply I hit the private message button by mistake when replying|||Thank you for your response. I know why I can't start server after restoring master db on the new machine from backup made on the old machine -- the physical names of the system dbs in the master backup point to the drives that do not exist on the new machine.

MSSQLSERVER not showing in Services

Hello,
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
Thanks in advance,
sck10
Perhaps you installed it as a Named instance instead of a default instance. In that case, the
service name is MSSQL$InstanceName.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
> to update the logon password when we change our NT password. First, what do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>
|||Hi Tibor,
There isn't anything starting with MSSQL.
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
Services[vbcol=seagreen]
what do[vbcol=seagreen]
another
>
|||Perhaps you only installed the client components?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> instance. In that case, the
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Services
> what do
> another
>
|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?

MSSQLSERVER not showing in Services

Hello,
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
--
Thanks in advance,
sck10Perhaps you installed it as a Named instance instead of a default instance. In that case, the
service name is MSSQL$InstanceName.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
> to update the logon password when we change our NT password. First, what do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>|||Hi Tibor,
There isn't anything starting with MSSQL.
--
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> > Hello,
> >
> > We just installed SQL Server 2K on a user machine. For some reason,
> > MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use
Services
> > to update the logon password when we change our NT password. First,
what do
> > we need to do to get MSSQLSERVER to show in Services and is there
another
> > way to update the logon password?
> >
> > --
> > Thanks in advance,
> >
> > sck10
> >
> >
>|||Perhaps you only installed the client components?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
>> Perhaps you installed it as a Named instance instead of a default
> instance. In that case, the
>> service name is MSSQL$InstanceName.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "sck10" <sck10@.online.nospam> wrote in message
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
>> > Hello,
>> >
>> > We just installed SQL Server 2K on a user machine. For some reason,
>> > MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use
> Services
>> > to update the logon password when we change our NT password. First,
> what do
>> > we need to do to get MSSQLSERVER to show in Services and is there
> another
>> > way to update the logon password?
>> >
>> > --
>> > Thanks in advance,
>> >
>> > sck10
>> >
>> >
>|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?

MSSQLSERVER not showing in Services

Hello,
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
Thanks in advance,
sck10Perhaps you installed it as a Named instance instead of a default instance.
In that case, the
service name is MSSQL$InstanceName.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl..
.
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Service
s
> to update the logon password when we change our NT password. First, what
do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>|||Hi Tibor,
There isn't anything starting with MSSQL.
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
Services[vbcol=seagreen]
what do[vbcol=seagreen]
another[vbcol=seagreen]
>|||Perhaps you only installed the client components?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...

> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> instance. In that case, the
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Services
> what do
> another
>|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?

MSSQLSERVER and SQLExpress coexist?

i had sqlserver2000 (including the enterprise manager and desktop engine) and .net 2003 installed in my development machine, I developed a vb.net application that communicates with a locally hosted mssql db.

recently i had .net 2005 and MS Server 2005 installed, then I converted my application in .net 2005, after, I started having problem deploying the application and db together to client machine and even on my own development machine, it's all database communication sort of problems. (now i have SQL Server Management Studio Express CTP installed)

Did i make any mistake? should i uninstall sqlserver2000, .net 2003 before installing server2005 and .net 2005?

btw, in my explorer, C:\Program Files\Microsoft SQL Server, i have 5 subfolders: "80", "90", "MSSQL", "MSSQL.1" and "MSSQL$SETUPTESTAPPINS". i know that 80 and MSSQL are the folders for server2000, 90 and MSSQL.1 are probably server2005 folders. but what is "MSSQL$SETUPTESTAPPINS"? from the readme.txt i found it's related to server2000, but what is it about?

also, in my registry, HKEY_Local_Machine/Software/Microsoft/Microsoft SQL Server/, the value of "InstalledInstances" is MSSQL SETUP TESTAPPINS SQLEXPRESS, after i removed SQLServer2000 stuff, the key value became "SETUP TESTAPPINS SQLEXPRESS", Now i dont have server2000 in my system anymore, how come SETUP TESTAPPIN is still there?

sorry for my bad explanation, plz help

This question might be better answered in the Setup forum, but from what I can gather from your statements, I don't think you did anything wrong. SQL Server 2000 and SQL Server 2005 will coexist on a single machine, as will the .NET versions. That may be where your issue is.

If you can post the specific errors you're seeing, that might a better place to start.

Buck Woody

|||

Hi,

Yes SQL 2000 and SQL Express / 2005 can coexists, i have MSDE and SQL Express installed on my system, it works without any problem.

Can you post error message from Windows Event Viewer and SQL Server Error Log

Hemantgiri S. Goswami

MSSQLSERVER and SQLExpress coexist?

i had sqlserver2000 (including the enterprise manager and desktop engine) and .net 2003 installed in my development machine, I developed a vb.net application that communicates with a locally hosted mssql db.

recently i had .net 2005 and MS Server 2005 installed, then I converted my application in .net 2005, after, I started having problem deploying the application and db together to client machine and even on my own development machine, it's all database communication sort of problems. (now i have SQL Server Management Studio Express CTP installed)

Did i make any mistake? should i uninstall sqlserver2000, .net 2003 before installing server2005 and .net 2005?

btw, in my explorer, C:\Program Files\Microsoft SQL Server, i have 5 subfolders: "80", "90", "MSSQL", "MSSQL.1" and "MSSQL$SETUPTESTAPPINS". i know that 80 and MSSQL are the folders for server2000, 90 and MSSQL.1 are probably server2005 folders. but what is "MSSQL$SETUPTESTAPPINS"? from the readme.txt i found it's related to server2000, but what is it about?

also, in my registry, HKEY_Local_Machine/Software/Microsoft/Microsoft SQL Server/, the value of "InstalledInstances" is MSSQL SETUP TESTAPPINS SQLEXPRESS, after i removed SQLServer2000 stuff, the key value became "SETUP TESTAPPINS SQLEXPRESS", Now i dont have server2000 in my system anymore, how come SETUP TESTAPPIN is still there?

sorry for my bad explanation, plz help

This question might be better answered in the Setup forum, but from what I can gather from your statements, I don't think you did anything wrong. SQL Server 2000 and SQL Server 2005 will coexist on a single machine, as will the .NET versions. That may be where your issue is.

If you can post the specific errors you're seeing, that might a better place to start.

Buck Woody

|||

Hi,

Yes SQL 2000 and SQL Express / 2005 can coexists, i have MSDE and SQL Express installed on my system, it works without any problem.

Can you post error message from Windows Event Viewer and SQL Server Error Log

Hemantgiri S. Goswami

mssql8 AND mssql 2005

I have both 8 and 2005 installed on a windows 2003 server. However from a remote machine I can only see the 2005 instance. Is there a configuration I have missed or is this not possible?Are you using SQL Server 2005 Management Studio to connect to a remote database engine? If so, you may wanna try to select <Browse for more...> option from the Server Name dropdown list and then switch to the Network Servers tab. Let me know how you're getting along.|||I can see both instances on the Windows 2003 system and can connect to the v8 thru sql server management as you suggest. My issue is a remote machine with only 8's client cannot connect to the mssql v8 instance.|||Are you getting any error at all? Try to quickly create a .udl file on the remote machine to see if you could make and test a connection to the server.|||I get a server not found message.|||How did you name your 2000 and 2005 instances on the same box?|||2005 = server
other is server\server2003|||And server\server2003 is not visible from 2000 client, right?|||Yes. I wonder if I should name it something else maybe it doesn;t like that name. Maybe OldSQL?|||

Quote:

Originally Posted by kitspid

Yes. I wonder if I should name it something else maybe it doesn;t like that name. Maybe OldSQL?

Try to name it without slash. I doubt though it'll help. I once experienced a very funny problem with my replication whereby the distributor wouldn't connect to the subscriber. I had to enable Naming Pipes on the subscriber via the SQL config console to fix it. Just a thought.|||Tried the name pipes didn;t help. Don;t think I can rename it as the machine is called server which is where that comes from shoulf just be server2003 to connect. Going to move this db to a different machine and not worry about it anymore. Chalk it up to a 2005 quirk I think.|||Thanx for your help anyway.|||Good luck to you. Sorry couldn't help you better. Try to search in MSDN troubleshooting articles.|||I had to change the port for the mssql8 version to get it to work.