I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?
1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
Showing posts with label second. Show all posts
Showing posts with label second. Show all posts
Wednesday, March 28, 2012
installing hotfix SQL2000-KB810185-8.00.0780-ENU
I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC
.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>sql
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC
.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>sql
installing hotfix SQL2000-KB810185-8.00.0780-ENU
I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
Friday, March 23, 2012
Installing a Second Instance
Hi,
I'm trying to install a 2nd instance on a cluster.
We've setup two cluster groups C101TC001 and C101TC002, one for each instance.
I've stopped all the services and managed to get the installation to run,
but it won't allow me to apply the Service Pack (3a).
It reports an error
An error has occurred while creating virtual resources for clustering. Can
not create a file when that file already exists.
This then invalidates the instance.
Can anyone assist?
Thanks
Bev
After this I'm unable to get the instance registered or even started.
The error message that you got can be due to various reasons. Here is one Microsoft Knowledge base articles that has the same error (but as I said you may be having a
different issue)
BUG: The Setup program of SQL Server 2000 Service Pack 2 or a later version may stop responding in a Windows clustering environment if there is an offline database
http://support.microsoft.com/default...B;EN-US;320524
This KB says the cause is "This problem occurs because Setup program cannot access the database.
During installation in a Windows Clustering environment, Setup program must query the user databases to make sure that all the database files are on disk resources that
have the correct dependencies and the virtual SQL Server resource. The virtual SQL Server resource is required for the failover support. When a database is offline, Setup
program cannot access the database. "
I understand you are installing SP3a and the above KB is for SP2 but one can still get similar error message.
You last point stated that "After this I'm unable to get the instance registered or even started." I think you will need to first concentrate on why this instance is not starting.
Anyways to be able to apply SP3a, the sql instance needs to be running. So, need to troubleshoot why this instance is not coming online. See what errors you get when
you try to being this SQL Server resource online. Try starting it from command promt and see if that works outside the cluster. The errors in SQL Errorlog, NT App, System
logs and cluster.log should be helpful to troubleshoot this further.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
sql
I'm trying to install a 2nd instance on a cluster.
We've setup two cluster groups C101TC001 and C101TC002, one for each instance.
I've stopped all the services and managed to get the installation to run,
but it won't allow me to apply the Service Pack (3a).
It reports an error
An error has occurred while creating virtual resources for clustering. Can
not create a file when that file already exists.
This then invalidates the instance.
Can anyone assist?
Thanks
Bev
After this I'm unable to get the instance registered or even started.
The error message that you got can be due to various reasons. Here is one Microsoft Knowledge base articles that has the same error (but as I said you may be having a
different issue)
BUG: The Setup program of SQL Server 2000 Service Pack 2 or a later version may stop responding in a Windows clustering environment if there is an offline database
http://support.microsoft.com/default...B;EN-US;320524
This KB says the cause is "This problem occurs because Setup program cannot access the database.
During installation in a Windows Clustering environment, Setup program must query the user databases to make sure that all the database files are on disk resources that
have the correct dependencies and the virtual SQL Server resource. The virtual SQL Server resource is required for the failover support. When a database is offline, Setup
program cannot access the database. "
I understand you are installing SP3a and the above KB is for SP2 but one can still get similar error message.
You last point stated that "After this I'm unable to get the instance registered or even started." I think you will need to first concentrate on why this instance is not starting.
Anyways to be able to apply SP3a, the sql instance needs to be running. So, need to troubleshoot why this instance is not coming online. See what errors you get when
you try to being this SQL Server resource online. Try starting it from command promt and see if that works outside the cluster. The errors in SQL Errorlog, NT App, System
logs and cluster.log should be helpful to troubleshoot this further.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
sql
installing 2nd instance
I am trying to install a second instance of sql server 2000. I am running xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't remember
now the limitations on the Developer Edition, is this one of them or is there
another problem? I am using mixed mode with an sa login.
JB
What did the error log say was the issue?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"JB" <JB@.discussions.microsoft.com> wrote in message
news:03A65A47-1ADD-42AD-86A5-B937A651A346@.microsoft.com...
I am trying to install a second instance of sql server 2000. I am running
xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't
remember
now the limitations on the Developer Edition, is this one of them or is
there
another problem? I am using mixed mode with an sa login.
JB
|||Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't remember
> now the limitations on the Developer Edition, is this one of them or is there
> another problem? I am using mixed mode with an sa login.
> --
> JB
|||Have you tried applying SP3a or SP4? It's not clear what the build number
of SQL Server is. This is on Windows 2003, right?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"JB" <JB@.discussions.microsoft.com> wrote in message
news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running
> xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I
> try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not
> exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't
> remember
> now the limitations on the Developer Edition, is this one of them or is
> there
> another problem? I am using mixed mode with an sa login.
> --
> JB
|||Per your suggestion. I first installed sp3a on the existing instance of SQL
Server(default instance). This ran without problems and the instance runs
ok. Then I ran the install for 2nd (named) instance. There aren't many
options during the install. I generally clicked Next. On one page, my user
name was displayed along with the domain. I entered my password. A page or
two later, I selected mixed mode and entered the sa password. The intall
seemed to go without any problems. When I then started Enterprise manager to
register the server, first it does not list the new instance in the select a
server page. If I type in the name and continue, I eventually get the
error, "sql server does not exist or access denied
ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on the
just installed named instance. The setup sees the new instance(i.e. it shows
in a list of instances to upgrade) but when I select the instance and
proceed, eventually I get the error "a service control operation failed for
MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
failure." I am running windows xp pro sp 2.
JB
"Tom Moreau" wrote:
> Have you tried applying SP3a or SP4? It's not clear what the build number
> of SQL Server is. This is on Windows 2003, right?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> Here is the whole lot:
> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2006-09-24 20:56:50.54 server All rights reserved.
> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> processing.
> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
> Blocks, [5000] Lock Owner Blocks.
> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2006-09-24 20:56:50.60 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2006-09-24 20:56:50.62 spid3 Warning ******************
> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
> Named Pipes.
> 2006-09-24 20:56:51.06 server SQL Server is ready for client connections
> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> skipped.
> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> changed from 0 to 1. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> changed from 1 to 0. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
> --
> JB
>
> "JB" wrote:
>
>
|||What are you typing in for the name? ServerName\InstanceName
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
"JB" <JB@.discussions.microsoft.com> wrote in message
news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...[vbcol=seagreen]
> Per your suggestion. I first installed sp3a on the existing instance of
> SQL
> Server(default instance). This ran without problems and the instance runs
> ok. Then I ran the install for 2nd (named) instance. There aren't many
> options during the install. I generally clicked Next. On one page, my
> user
> name was displayed along with the domain. I entered my password. A page
> or
> two later, I selected mixed mode and entered the sa password. The intall
> seemed to go without any problems. When I then started Enterprise manager
> to
> register the server, first it does not list the new instance in the select
> a
> server page. If I type in the name and continue, I eventually get the
> error, "sql server does not exist or access denied
> ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> the
> just installed named instance. The setup sees the new instance(i.e. it
> shows
> in a list of instances to upgrade) but when I select the instance and
> proceed, eventually I get the error "a service control operation failed
> for
> MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> failure." I am running windows xp pro sp 2.
> --
> JB
>
> "Tom Moreau" wrote:
|||I typed in just the instance name. I am on the road for a day or two and
won't be able to try servername\instancename until I return to my office.
However, when I tried to run sp3a againt the new instance, it showed
instancename in the selection list. sp3a was then was unable to connect to
the instance and as a result, the sp3a upgrade failed to run. It that case,
there was no issue with servername\instancename since I didn't need to type
anything. In both the sp3a upgrade and register server cases, sql recognizes
that the instance is there, it just cannot make a connection. The failure
has to do with logon but I can't see what the problem is.
JB
"Roger Wolter[MSFT]" wrote:
> What are you typing in for the name? ServerName\InstanceName
> --
> 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
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
>
>
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't remember
now the limitations on the Developer Edition, is this one of them or is there
another problem? I am using mixed mode with an sa login.
JB
What did the error log say was the issue?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"JB" <JB@.discussions.microsoft.com> wrote in message
news:03A65A47-1ADD-42AD-86A5-B937A651A346@.microsoft.com...
I am trying to install a second instance of sql server 2000. I am running
xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't
remember
now the limitations on the Developer Edition, is this one of them or is
there
another problem? I am using mixed mode with an sa login.
JB
|||Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't remember
> now the limitations on the Developer Edition, is this one of them or is there
> another problem? I am using mixed mode with an sa login.
> --
> JB
|||Have you tried applying SP3a or SP4? It's not clear what the build number
of SQL Server is. This is on Windows 2003, right?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"JB" <JB@.discussions.microsoft.com> wrote in message
news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running
> xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I
> try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not
> exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't
> remember
> now the limitations on the Developer Edition, is this one of them or is
> there
> another problem? I am using mixed mode with an sa login.
> --
> JB
|||Per your suggestion. I first installed sp3a on the existing instance of SQL
Server(default instance). This ran without problems and the instance runs
ok. Then I ran the install for 2nd (named) instance. There aren't many
options during the install. I generally clicked Next. On one page, my user
name was displayed along with the domain. I entered my password. A page or
two later, I selected mixed mode and entered the sa password. The intall
seemed to go without any problems. When I then started Enterprise manager to
register the server, first it does not list the new instance in the select a
server page. If I type in the name and continue, I eventually get the
error, "sql server does not exist or access denied
ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on the
just installed named instance. The setup sees the new instance(i.e. it shows
in a list of instances to upgrade) but when I select the instance and
proceed, eventually I get the error "a service control operation failed for
MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
failure." I am running windows xp pro sp 2.
JB
"Tom Moreau" wrote:
> Have you tried applying SP3a or SP4? It's not clear what the build number
> of SQL Server is. This is on Windows 2003, right?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> Here is the whole lot:
> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2006-09-24 20:56:50.54 server All rights reserved.
> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> processing.
> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
> Blocks, [5000] Lock Owner Blocks.
> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2006-09-24 20:56:50.60 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2006-09-24 20:56:50.62 spid3 Warning ******************
> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
> Named Pipes.
> 2006-09-24 20:56:51.06 server SQL Server is ready for client connections
> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> skipped.
> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> changed from 0 to 1. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> changed from 1 to 0. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
> --
> JB
>
> "JB" wrote:
>
>
|||What are you typing in for the name? ServerName\InstanceName
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
"JB" <JB@.discussions.microsoft.com> wrote in message
news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...[vbcol=seagreen]
> Per your suggestion. I first installed sp3a on the existing instance of
> SQL
> Server(default instance). This ran without problems and the instance runs
> ok. Then I ran the install for 2nd (named) instance. There aren't many
> options during the install. I generally clicked Next. On one page, my
> user
> name was displayed along with the domain. I entered my password. A page
> or
> two later, I selected mixed mode and entered the sa password. The intall
> seemed to go without any problems. When I then started Enterprise manager
> to
> register the server, first it does not list the new instance in the select
> a
> server page. If I type in the name and continue, I eventually get the
> error, "sql server does not exist or access denied
> ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> the
> just installed named instance. The setup sees the new instance(i.e. it
> shows
> in a list of instances to upgrade) but when I select the instance and
> proceed, eventually I get the error "a service control operation failed
> for
> MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> failure." I am running windows xp pro sp 2.
> --
> JB
>
> "Tom Moreau" wrote:
|||I typed in just the instance name. I am on the road for a day or two and
won't be able to try servername\instancename until I return to my office.
However, when I tried to run sp3a againt the new instance, it showed
instancename in the selection list. sp3a was then was unable to connect to
the instance and as a result, the sp3a upgrade failed to run. It that case,
there was no issue with servername\instancename since I didn't need to type
anything. In both the sp3a upgrade and register server cases, sql recognizes
that the instance is there, it just cannot make a connection. The failure
has to do with logon but I can't see what the problem is.
JB
"Roger Wolter[MSFT]" wrote:
> What are you typing in for the name? ServerName\InstanceName
> --
> 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
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
>
>
installing 2nd instance
I am trying to install a second instance of sql server 2000. I am running x
p
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't remembe
r
now the limitations on the Developer Edition, is this one of them or is ther
e
another problem? I am using mixed mode with an sa login.
--
JBWhat did the error log say was the issue?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:03A65A47-1ADD-42AD-86A5-B937A651A346@.microsoft.com...
I am trying to install a second instance of sql server 2000. I am running
xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't
remember
now the limitations on the Developer Edition, is this one of them or is
there
another problem? I am using mixed mode with an sa login.
--
JB|||Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] L
ock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running
xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I tr
y
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not exi
st
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't remem
ber
> now the limitations on the Developer Edition, is this one of them or is th
ere
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Have you tried applying SP3a or SP4? It's not clear what the build number
of SQL Server is. This is on Windows 2003, right?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] L
ock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running
> xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I
> try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not
> exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't
> remember
> now the limitations on the Developer Edition, is this one of them or is
> there
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Per your suggestion. I first installed sp3a on the existing instance of SQL
Server(default instance). This ran without problems and the instance runs
ok. Then I ran the install for 2nd (named) instance. There aren't many
options during the install. I generally clicked Next. On one page, my user
name was displayed along with the domain. I entered my password. A page or
two later, I selected mixed mode and entered the sa password. The intall
seemed to go without any problems. When I then started Enterprise manager t
o
register the server, first it does not list the new instance in the select a
server page. If I type in the name and continue, I eventually get the
error, "sql server does not exist or access denied
ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on the
just installed named instance. The setup sees the new instance(i.e. it show
s
in a list of instances to upgrade) but when I select the instance and
proceed, eventually I get the error "a service control operation failed for
MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
failure." I am running Windows XP pro sp 2.
--
JB
"Tom Moreau" wrote:
> Have you tried applying SP3a or SP4? It's not clear what the build number
> of SQL Server is. This is on Windows 2003, right?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> Here is the whole lot:
> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2006-09-24 20:56:50.54 server All rights reserved.
> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> processing.
> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500]
Lock
> Blocks, [5000] Lock Owner Blocks.
> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2006-09-24 20:56:50.60 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2006-09-24 20:56:50.62 spid3 Warning ******************
> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memor
y,
> Named Pipes.
> 2006-09-24 20:56:51.06 server SQL Server is ready for client connection
s
> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> skipped.
> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> changed from 0 to 1. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> changed from 1 to 0. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
> --
> JB
>
> "JB" wrote:
>
>|||What are you typing in for the name? ServerName\InstanceName
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
"JB" <JB@.discussions.microsoft.com> wrote in message
news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...[vbcol=seagreen]
> Per your suggestion. I first installed sp3a on the existing instance of
> SQL
> Server(default instance). This ran without problems and the instance runs
> ok. Then I ran the install for 2nd (named) instance. There aren't many
> options during the install. I generally clicked Next. On one page, my
> user
> name was displayed along with the domain. I entered my password. A page
> or
> two later, I selected mixed mode and entered the sa password. The intall
> seemed to go without any problems. When I then started Enterprise manager
> to
> register the server, first it does not list the new instance in the select
> a
> server page. If I type in the name and continue, I eventually get the
> error, "sql server does not exist or access denied
> ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> the
> just installed named instance. The setup sees the new instance(i.e. it
> shows
> in a list of instances to upgrade) but when I select the instance and
> proceed, eventually I get the error "a service control operation failed
> for
> MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> failure." I am running Windows XP pro sp 2.
> --
> JB
>
> "Tom Moreau" wrote:
>|||I typed in just the instance name. I am on the road for a day or two and
won't be able to try servername\instancename until I return to my office.
However, when I tried to run sp3a againt the new instance, it showed
instancename in the selection list. sp3a was then was unable to connect to
the instance and as a result, the sp3a upgrade failed to run. It that case,
there was no issue with servername\instancename since I didn't need to type
anything. In both the sp3a upgrade and register server cases, sql recognize
s
that the instance is there, it just cannot make a connection. The failure
has to do with logon but I can't see what the problem is.
--
JB
"Roger Wolter[MSFT]" wrote:
> What are you typing in for the name? ServerName\InstanceName
> --
> 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
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
>
>
p
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't remembe
r
now the limitations on the Developer Edition, is this one of them or is ther
e
another problem? I am using mixed mode with an sa login.
--
JBWhat did the error log say was the issue?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:03A65A47-1ADD-42AD-86A5-B937A651A346@.microsoft.com...
I am trying to install a second instance of sql server 2000. I am running
xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't
remember
now the limitations on the Developer Edition, is this one of them or is
there
another problem? I am using mixed mode with an sa login.
--
JB|||Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] L
ock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running
xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I tr
y
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not exi
st
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't remem
ber
> now the limitations on the Developer Edition, is this one of them or is th
ere
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Have you tried applying SP3a or SP4? It's not clear what the build number
of SQL Server is. This is on Windows 2003, right?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] L
ock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running
> xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I
> try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not
> exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't
> remember
> now the limitations on the Developer Edition, is this one of them or is
> there
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Per your suggestion. I first installed sp3a on the existing instance of SQL
Server(default instance). This ran without problems and the instance runs
ok. Then I ran the install for 2nd (named) instance. There aren't many
options during the install. I generally clicked Next. On one page, my user
name was displayed along with the domain. I entered my password. A page or
two later, I selected mixed mode and entered the sa password. The intall
seemed to go without any problems. When I then started Enterprise manager t
o
register the server, first it does not list the new instance in the select a
server page. If I type in the name and continue, I eventually get the
error, "sql server does not exist or access denied
ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on the
just installed named instance. The setup sees the new instance(i.e. it show
s
in a list of instances to upgrade) but when I select the instance and
proceed, eventually I get the error "a service control operation failed for
MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
failure." I am running Windows XP pro sp 2.
--
JB
"Tom Moreau" wrote:
> Have you tried applying SP3a or SP4? It's not clear what the build number
> of SQL Server is. This is on Windows 2003, right?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> Here is the whole lot:
> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2006-09-24 20:56:50.54 server All rights reserved.
> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> processing.
> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500]
Lock
> Blocks, [5000] Lock Owner Blocks.
> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2006-09-24 20:56:50.60 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2006-09-24 20:56:50.62 spid3 Warning ******************
> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memor
y,
> Named Pipes.
> 2006-09-24 20:56:51.06 server SQL Server is ready for client connection
s
> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> skipped.
> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> changed from 0 to 1. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> changed from 1 to 0. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
> --
> JB
>
> "JB" wrote:
>
>|||What are you typing in for the name? ServerName\InstanceName
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
"JB" <JB@.discussions.microsoft.com> wrote in message
news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...[vbcol=seagreen]
> Per your suggestion. I first installed sp3a on the existing instance of
> SQL
> Server(default instance). This ran without problems and the instance runs
> ok. Then I ran the install for 2nd (named) instance. There aren't many
> options during the install. I generally clicked Next. On one page, my
> user
> name was displayed along with the domain. I entered my password. A page
> or
> two later, I selected mixed mode and entered the sa password. The intall
> seemed to go without any problems. When I then started Enterprise manager
> to
> register the server, first it does not list the new instance in the select
> a
> server page. If I type in the name and continue, I eventually get the
> error, "sql server does not exist or access denied
> ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> the
> just installed named instance. The setup sees the new instance(i.e. it
> shows
> in a list of instances to upgrade) but when I select the instance and
> proceed, eventually I get the error "a service control operation failed
> for
> MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> failure." I am running Windows XP pro sp 2.
> --
> JB
>
> "Tom Moreau" wrote:
>|||I typed in just the instance name. I am on the road for a day or two and
won't be able to try servername\instancename until I return to my office.
However, when I tried to run sp3a againt the new instance, it showed
instancename in the selection list. sp3a was then was unable to connect to
the instance and as a result, the sp3a upgrade failed to run. It that case,
there was no issue with servername\instancename since I didn't need to type
anything. In both the sp3a upgrade and register server cases, sql recognize
s
that the instance is there, it just cannot make a connection. The failure
has to do with logon but I can't see what the problem is.
--
JB
"Roger Wolter[MSFT]" wrote:
> What are you typing in for the name? ServerName\InstanceName
> --
> 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
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
>
>
installing 2nd instance
I am trying to install a second instance of sql server 2000. I am running xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't remember
now the limitations on the Developer Edition, is this one of them or is there
another problem? I am using mixed mode with an sa login.
--
JBWhat did the error log say was the issue?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:03A65A47-1ADD-42AD-86A5-B937A651A346@.microsoft.com...
I am trying to install a second instance of sql server 2000. I am running
xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't
remember
now the limitations on the Developer Edition, is this one of them or is
there
another problem? I am using mixed mode with an sa login.
--
JB|||Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
--
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't remember
> now the limitations on the Developer Edition, is this one of them or is there
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Have you tried applying SP3a or SP4? It's not clear what the build number
of SQL Server is. This is on Windows 2003, right?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
--
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running
> xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I
> try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not
> exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't
> remember
> now the limitations on the Developer Edition, is this one of them or is
> there
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Per your suggestion. I first installed sp3a on the existing instance of SQL
Server(default instance). This ran without problems and the instance runs
ok. Then I ran the install for 2nd (named) instance. There aren't many
options during the install. I generally clicked Next. On one page, my user
name was displayed along with the domain. I entered my password. A page or
two later, I selected mixed mode and entered the sa password. The intall
seemed to go without any problems. When I then started Enterprise manager to
register the server, first it does not list the new instance in the select a
server page. If I type in the name and continue, I eventually get the
error, "sql server does not exist or access denied
ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on the
just installed named instance. The setup sees the new instance(i.e. it shows
in a list of instances to upgrade) but when I select the instance and
proceed, eventually I get the error "a service control operation failed for
MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
failure." I am running windows xp pro sp 2.
--
JB
"Tom Moreau" wrote:
> Have you tried applying SP3a or SP4? It's not clear what the build number
> of SQL Server is. This is on Windows 2003, right?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> Here is the whole lot:
> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2006-09-24 20:56:50.54 server All rights reserved.
> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> processing.
> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
> Blocks, [5000] Lock Owner Blocks.
> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2006-09-24 20:56:50.60 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2006-09-24 20:56:50.62 spid3 Warning ******************
> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
> Named Pipes.
> 2006-09-24 20:56:51.06 server SQL Server is ready for client connections
> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> skipped.
> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> changed from 0 to 1. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> changed from 1 to 0. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
> --
> JB
>
> "JB" wrote:
> > I am trying to install a second instance of sql server 2000. I am running
> > xp
> > pro and using the developer edition. When I run the install, it completes
> > normally. The registry has entries for the new named instance. When I
> > try
> > to register the new server using enterprise manager and add it to a group,
> > first the wizard does not list the new name. If I type in the name and
> > proceed, I eventually get an error message saying "sql server does not
> > exist
> > or access denied. ..." The error log shows that it gets part way with
> > starting the service but then is stopped before completing. I don't
> > remember
> > now the limitations on the Developer Edition, is this one of them or is
> > there
> > another problem? I am using mixed mode with an sa login.
> > --
> > JB
>|||What are you typing in for the name? ServerName\InstanceName
--
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
"JB" <JB@.discussions.microsoft.com> wrote in message
news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
> Per your suggestion. I first installed sp3a on the existing instance of
> SQL
> Server(default instance). This ran without problems and the instance runs
> ok. Then I ran the install for 2nd (named) instance. There aren't many
> options during the install. I generally clicked Next. On one page, my
> user
> name was displayed along with the domain. I entered my password. A page
> or
> two later, I selected mixed mode and entered the sa password. The intall
> seemed to go without any problems. When I then started Enterprise manager
> to
> register the server, first it does not list the new instance in the select
> a
> server page. If I type in the name and continue, I eventually get the
> error, "sql server does not exist or access denied
> ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> the
> just installed named instance. The setup sees the new instance(i.e. it
> shows
> in a list of instances to upgrade) but when I select the instance and
> proceed, eventually I get the error "a service control operation failed
> for
> MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> failure." I am running windows xp pro sp 2.
> --
> JB
>
> "Tom Moreau" wrote:
>> Have you tried applying SP3a or SP4? It's not clear what the build
>> number
>> of SQL Server is. This is on Windows 2003, right?
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> ..
>> "JB" <JB@.discussions.microsoft.com> wrote in message
>> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
>> Here is the whole lot:
>> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
>> Corporation.
>> 2006-09-24 20:56:50.54 server All rights reserved.
>> 2006-09-24 20:56:50.54 server Server Process ID is 160.
>> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
>> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
>> 'normal'(2 CPUs detected).
>> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
>> processing.
>> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500]
>> Lock
>> Blocks, [5000] Lock Owner Blocks.
>> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
>> Transaction Coordinator.
>> 2006-09-24 20:56:50.60 server Failed to obtain
>> TransactionDispenserInterface: Result Code = 0x8004d01b
>> 2006-09-24 20:56:50.62 spid3 Warning ******************
>> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
>> Updates allowed to system catalogs.
>> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
>> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
>> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
>> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
>> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
>> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
>> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
>> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
>> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared
>> Memory,
>> Named Pipes.
>> 2006-09-24 20:56:51.06 server SQL Server is ready for client
>> connections
>> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
>> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
>> 2006-09-24 20:56:52.84 spid3 Recovery complete.
>> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
>> skipped.
>> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
>> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
>> changed from 0 to 1. Run the RECONFIGURE statement to install..
>> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
>> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
>> changed from 1 to 0. Run the RECONFIGURE statement to install..
>> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
>> request from Service Control Manager.
>> --
>> JB
>>
>> "JB" wrote:
>> > I am trying to install a second instance of sql server 2000. I am
>> > running
>> > xp
>> > pro and using the developer edition. When I run the install, it
>> > completes
>> > normally. The registry has entries for the new named instance. When I
>> > try
>> > to register the new server using enterprise manager and add it to a
>> > group,
>> > first the wizard does not list the new name. If I type in the name and
>> > proceed, I eventually get an error message saying "sql server does not
>> > exist
>> > or access denied. ..." The error log shows that it gets part way with
>> > starting the service but then is stopped before completing. I don't
>> > remember
>> > now the limitations on the Developer Edition, is this one of them or is
>> > there
>> > another problem? I am using mixed mode with an sa login.
>> > --
>> > JB
>>|||I typed in just the instance name. I am on the road for a day or two and
won't be able to try servername\instancename until I return to my office.
However, when I tried to run sp3a againt the new instance, it showed
instancename in the selection list. sp3a was then was unable to connect to
the instance and as a result, the sp3a upgrade failed to run. It that case,
there was no issue with servername\instancename since I didn't need to type
anything. In both the sp3a upgrade and register server cases, sql recognizes
that the instance is there, it just cannot make a connection. The failure
has to do with logon but I can't see what the problem is.
--
JB
"Roger Wolter[MSFT]" wrote:
> What are you typing in for the name? ServerName\InstanceName
> --
> 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
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
> > Per your suggestion. I first installed sp3a on the existing instance of
> > SQL
> > Server(default instance). This ran without problems and the instance runs
> > ok. Then I ran the install for 2nd (named) instance. There aren't many
> > options during the install. I generally clicked Next. On one page, my
> > user
> > name was displayed along with the domain. I entered my password. A page
> > or
> > two later, I selected mixed mode and entered the sa password. The intall
> > seemed to go without any problems. When I then started Enterprise manager
> > to
> > register the server, first it does not list the new instance in the select
> > a
> > server page. If I type in the name and continue, I eventually get the
> > error, "sql server does not exist or access denied
> > ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> > the
> > just installed named instance. The setup sees the new instance(i.e. it
> > shows
> > in a list of instances to upgrade) but when I select the instance and
> > proceed, eventually I get the error "a service control operation failed
> > for
> > MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> > failure." I am running windows xp pro sp 2.
> > --
> > JB
> >
> >
> > "Tom Moreau" wrote:
> >
> >> Have you tried applying SP3a or SP4? It's not clear what the build
> >> number
> >> of SQL Server is. This is on Windows 2003, right?
> >>
> >> --
> >> Tom
> >>
> >> ----
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> >> SQL Server MVP
> >> Toronto, ON Canada
> >> ..
> >> "JB" <JB@.discussions.microsoft.com> wrote in message
> >> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> >> Here is the whole lot:
> >>
> >> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> >> Corporation.
> >> 2006-09-24 20:56:50.54 server All rights reserved.
> >> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> >> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> >> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> >> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> >> 'normal'(2 CPUs detected).
> >> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> >> processing.
> >> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500]
> >> Lock
> >> Blocks, [5000] Lock Owner Blocks.
> >> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> >> Transaction Coordinator.
> >> 2006-09-24 20:56:50.60 server Failed to obtain
> >> TransactionDispenserInterface: Result Code = 0x8004d01b
> >> 2006-09-24 20:56:50.62 spid3 Warning ******************
> >> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> >> Updates allowed to system catalogs.
> >> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> >> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> >> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> >> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> >> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> >> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> >> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> >> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> >> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared
> >> Memory,
> >> Named Pipes.
> >> 2006-09-24 20:56:51.06 server SQL Server is ready for client
> >> connections
> >> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> >> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> >> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> >> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> >> skipped.
> >> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> >> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> >> changed from 0 to 1. Run the RECONFIGURE statement to install..
> >> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> >> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> >> changed from 1 to 0. Run the RECONFIGURE statement to install..
> >> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> >> request from Service Control Manager.
> >>
> >> --
> >> JB
> >>
> >>
> >> "JB" wrote:
> >>
> >> > I am trying to install a second instance of sql server 2000. I am
> >> > running
> >> > xp
> >> > pro and using the developer edition. When I run the install, it
> >> > completes
> >> > normally. The registry has entries for the new named instance. When I
> >> > try
> >> > to register the new server using enterprise manager and add it to a
> >> > group,
> >> > first the wizard does not list the new name. If I type in the name and
> >> > proceed, I eventually get an error message saying "sql server does not
> >> > exist
> >> > or access denied. ..." The error log shows that it gets part way with
> >> > starting the service but then is stopped before completing. I don't
> >> > remember
> >> > now the limitations on the Developer Edition, is this one of them or is
> >> > there
> >> > another problem? I am using mixed mode with an sa login.
> >> > --
> >> > JB
> >>
> >>
>
>
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't remember
now the limitations on the Developer Edition, is this one of them or is there
another problem? I am using mixed mode with an sa login.
--
JBWhat did the error log say was the issue?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:03A65A47-1ADD-42AD-86A5-B937A651A346@.microsoft.com...
I am trying to install a second instance of sql server 2000. I am running
xp
pro and using the developer edition. When I run the install, it completes
normally. The registry has entries for the new named instance. When I try
to register the new server using enterprise manager and add it to a group,
first the wizard does not list the new name. If I type in the name and
proceed, I eventually get an error message saying "sql server does not exist
or access denied. ..." The error log shows that it gets part way with
starting the service but then is stopped before completing. I don't
remember
now the limitations on the Developer Edition, is this one of them or is
there
another problem? I am using mixed mode with an sa login.
--
JB|||Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
--
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't remember
> now the limitations on the Developer Edition, is this one of them or is there
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Have you tried applying SP3a or SP4? It's not clear what the build number
of SQL Server is. This is on Windows 2003, right?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"JB" <JB@.discussions.microsoft.com> wrote in message
news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
Here is the whole lot:
2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
Corporation.
2006-09-24 20:56:50.54 server All rights reserved.
2006-09-24 20:56:50.54 server Server Process ID is 160.
2006-09-24 20:56:50.54 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
2006-09-24 20:56:50.56 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2006-09-24 20:56:50.56 server SQL Server configured for thread mode
processing.
2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2006-09-24 20:56:50.59 server Attempting to initialize Distributed
Transaction Coordinator.
2006-09-24 20:56:50.60 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2006-09-24 20:56:50.62 spid3 Warning ******************
2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2006-09-24 20:56:51.06 server SQL Server is ready for client connections
2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
2006-09-24 20:56:52.84 spid3 Recovery complete.
2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
skipped.
2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
changed from 0 to 1. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
changed from 1 to 0. Run the RECONFIGURE statement to install..
2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
--
JB
"JB" wrote:
> I am trying to install a second instance of sql server 2000. I am running
> xp
> pro and using the developer edition. When I run the install, it completes
> normally. The registry has entries for the new named instance. When I
> try
> to register the new server using enterprise manager and add it to a group,
> first the wizard does not list the new name. If I type in the name and
> proceed, I eventually get an error message saying "sql server does not
> exist
> or access denied. ..." The error log shows that it gets part way with
> starting the service but then is stopped before completing. I don't
> remember
> now the limitations on the Developer Edition, is this one of them or is
> there
> another problem? I am using mixed mode with an sa login.
> --
> JB|||Per your suggestion. I first installed sp3a on the existing instance of SQL
Server(default instance). This ran without problems and the instance runs
ok. Then I ran the install for 2nd (named) instance. There aren't many
options during the install. I generally clicked Next. On one page, my user
name was displayed along with the domain. I entered my password. A page or
two later, I selected mixed mode and entered the sa password. The intall
seemed to go without any problems. When I then started Enterprise manager to
register the server, first it does not list the new instance in the select a
server page. If I type in the name and continue, I eventually get the
error, "sql server does not exist or access denied
ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on the
just installed named instance. The setup sees the new instance(i.e. it shows
in a list of instances to upgrade) but when I select the instance and
proceed, eventually I get the error "a service control operation failed for
MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
failure." I am running windows xp pro sp 2.
--
JB
"Tom Moreau" wrote:
> Have you tried applying SP3a or SP4? It's not clear what the build number
> of SQL Server is. This is on Windows 2003, right?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> Here is the whole lot:
> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> Corporation.
> 2006-09-24 20:56:50.54 server All rights reserved.
> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> processing.
> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500] Lock
> Blocks, [5000] Lock Owner Blocks.
> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2006-09-24 20:56:50.60 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2006-09-24 20:56:50.62 spid3 Warning ******************
> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared Memory,
> Named Pipes.
> 2006-09-24 20:56:51.06 server SQL Server is ready for client connections
> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> skipped.
> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> changed from 0 to 1. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> changed from 1 to 0. Run the RECONFIGURE statement to install..
> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> request from Service Control Manager.
> --
> JB
>
> "JB" wrote:
> > I am trying to install a second instance of sql server 2000. I am running
> > xp
> > pro and using the developer edition. When I run the install, it completes
> > normally. The registry has entries for the new named instance. When I
> > try
> > to register the new server using enterprise manager and add it to a group,
> > first the wizard does not list the new name. If I type in the name and
> > proceed, I eventually get an error message saying "sql server does not
> > exist
> > or access denied. ..." The error log shows that it gets part way with
> > starting the service but then is stopped before completing. I don't
> > remember
> > now the limitations on the Developer Edition, is this one of them or is
> > there
> > another problem? I am using mixed mode with an sa login.
> > --
> > JB
>|||What are you typing in for the name? ServerName\InstanceName
--
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
"JB" <JB@.discussions.microsoft.com> wrote in message
news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
> Per your suggestion. I first installed sp3a on the existing instance of
> SQL
> Server(default instance). This ran without problems and the instance runs
> ok. Then I ran the install for 2nd (named) instance. There aren't many
> options during the install. I generally clicked Next. On one page, my
> user
> name was displayed along with the domain. I entered my password. A page
> or
> two later, I selected mixed mode and entered the sa password. The intall
> seemed to go without any problems. When I then started Enterprise manager
> to
> register the server, first it does not list the new instance in the select
> a
> server page. If I type in the name and continue, I eventually get the
> error, "sql server does not exist or access denied
> ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> the
> just installed named instance. The setup sees the new instance(i.e. it
> shows
> in a list of instances to upgrade) but when I select the instance and
> proceed, eventually I get the error "a service control operation failed
> for
> MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> failure." I am running windows xp pro sp 2.
> --
> JB
>
> "Tom Moreau" wrote:
>> Have you tried applying SP3a or SP4? It's not clear what the build
>> number
>> of SQL Server is. This is on Windows 2003, right?
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> ..
>> "JB" <JB@.discussions.microsoft.com> wrote in message
>> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
>> Here is the whole lot:
>> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
>> Corporation.
>> 2006-09-24 20:56:50.54 server All rights reserved.
>> 2006-09-24 20:56:50.54 server Server Process ID is 160.
>> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
>> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
>> 'normal'(2 CPUs detected).
>> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
>> processing.
>> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500]
>> Lock
>> Blocks, [5000] Lock Owner Blocks.
>> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
>> Transaction Coordinator.
>> 2006-09-24 20:56:50.60 server Failed to obtain
>> TransactionDispenserInterface: Result Code = 0x8004d01b
>> 2006-09-24 20:56:50.62 spid3 Warning ******************
>> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
>> Updates allowed to system catalogs.
>> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
>> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
>> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
>> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
>> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
>> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
>> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
>> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
>> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared
>> Memory,
>> Named Pipes.
>> 2006-09-24 20:56:51.06 server SQL Server is ready for client
>> connections
>> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
>> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
>> 2006-09-24 20:56:52.84 spid3 Recovery complete.
>> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
>> skipped.
>> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
>> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
>> changed from 0 to 1. Run the RECONFIGURE statement to install..
>> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
>> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
>> changed from 1 to 0. Run the RECONFIGURE statement to install..
>> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
>> request from Service Control Manager.
>> --
>> JB
>>
>> "JB" wrote:
>> > I am trying to install a second instance of sql server 2000. I am
>> > running
>> > xp
>> > pro and using the developer edition. When I run the install, it
>> > completes
>> > normally. The registry has entries for the new named instance. When I
>> > try
>> > to register the new server using enterprise manager and add it to a
>> > group,
>> > first the wizard does not list the new name. If I type in the name and
>> > proceed, I eventually get an error message saying "sql server does not
>> > exist
>> > or access denied. ..." The error log shows that it gets part way with
>> > starting the service but then is stopped before completing. I don't
>> > remember
>> > now the limitations on the Developer Edition, is this one of them or is
>> > there
>> > another problem? I am using mixed mode with an sa login.
>> > --
>> > JB
>>|||I typed in just the instance name. I am on the road for a day or two and
won't be able to try servername\instancename until I return to my office.
However, when I tried to run sp3a againt the new instance, it showed
instancename in the selection list. sp3a was then was unable to connect to
the instance and as a result, the sp3a upgrade failed to run. It that case,
there was no issue with servername\instancename since I didn't need to type
anything. In both the sp3a upgrade and register server cases, sql recognizes
that the instance is there, it just cannot make a connection. The failure
has to do with logon but I can't see what the problem is.
--
JB
"Roger Wolter[MSFT]" wrote:
> What are you typing in for the name? ServerName\InstanceName
> --
> 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
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:C333117C-0509-4459-AD9D-5DEB8566E122@.microsoft.com...
> > Per your suggestion. I first installed sp3a on the existing instance of
> > SQL
> > Server(default instance). This ran without problems and the instance runs
> > ok. Then I ran the install for 2nd (named) instance. There aren't many
> > options during the install. I generally clicked Next. On one page, my
> > user
> > name was displayed along with the domain. I entered my password. A page
> > or
> > two later, I selected mixed mode and entered the sa password. The intall
> > seemed to go without any problems. When I then started Enterprise manager
> > to
> > register the server, first it does not list the new instance in the select
> > a
> > server page. If I type in the name and continue, I eventually get the
> > error, "sql server does not exist or access denied
> > ConnectionOpen(Connect()). Same as before. Then I tried to run sp3a on
> > the
> > just installed named instance. The setup sees the new instance(i.e. it
> > shows
> > in a list of instances to upgrade) but when I select the instance and
> > proceed, eventually I get the error "a service control operation failed
> > for
> > MSSQL$LJDESIGNS_SC service: 1069 The service did not start due to a logon
> > failure." I am running windows xp pro sp 2.
> > --
> > JB
> >
> >
> > "Tom Moreau" wrote:
> >
> >> Have you tried applying SP3a or SP4? It's not clear what the build
> >> number
> >> of SQL Server is. This is on Windows 2003, right?
> >>
> >> --
> >> Tom
> >>
> >> ----
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> >> SQL Server MVP
> >> Toronto, ON Canada
> >> ..
> >> "JB" <JB@.discussions.microsoft.com> wrote in message
> >> news:1B35467F-FEA8-47E1-BB94-3DA14D172E97@.microsoft.com...
> >> Here is the whole lot:
> >>
> >> 2006-09-24 20:56:50.54 server Copyright (C) 1988-2000 Microsoft
> >> Corporation.
> >> 2006-09-24 20:56:50.54 server All rights reserved.
> >> 2006-09-24 20:56:50.54 server Server Process ID is 160.
> >> 2006-09-24 20:56:50.54 server Logging SQL Server messages in file
> >> 'C:\Program Files\Microsoft SQL Server\MSSQL$LJBUILDER_SC\log\ERRORLOG'.
> >> 2006-09-24 20:56:50.56 server SQL Server is starting at priority class
> >> 'normal'(2 CPUs detected).
> >> 2006-09-24 20:56:50.56 server SQL Server configured for thread mode
> >> processing.
> >> 2006-09-24 20:56:50.56 server Using dynamic lock allocation. [2500]
> >> Lock
> >> Blocks, [5000] Lock Owner Blocks.
> >> 2006-09-24 20:56:50.59 server Attempting to initialize Distributed
> >> Transaction Coordinator.
> >> 2006-09-24 20:56:50.60 server Failed to obtain
> >> TransactionDispenserInterface: Result Code = 0x8004d01b
> >> 2006-09-24 20:56:50.62 spid3 Warning ******************
> >> 2006-09-24 20:56:50.62 spid3 SQL Server started in single user mode.
> >> Updates allowed to system catalogs.
> >> 2006-09-24 20:56:50.62 spid3 Starting up database 'master'.
> >> 2006-09-24 20:56:50.82 server Using 'SSNETLIB.DLL' version '8.0.311'.
> >> 2006-09-24 20:56:50.82 spid3 Server name is 'LJDESIGNS\LJBUILDER_SC'.
> >> 2006-09-24 20:56:50.82 spid5 Starting up database 'model'.
> >> 2006-09-24 20:56:50.82 spid7 Starting up database 'msdb'.
> >> 2006-09-24 20:56:50.82 spid8 Starting up database 'pubs'.
> >> 2006-09-24 20:56:50.82 spid9 Starting up database 'Northwind'.
> >> 2006-09-24 20:56:51.04 server SQL server listening on 127.0.0.1: 1032.
> >> 2006-09-24 20:56:51.06 server SQL server listening on TCP, Shared
> >> Memory,
> >> Named Pipes.
> >> 2006-09-24 20:56:51.06 server SQL Server is ready for client
> >> connections
> >> 2006-09-24 20:56:51.57 spid5 Clearing tempdb database.
> >> 2006-09-24 20:56:52.70 spid5 Starting up database 'tempdb'.
> >> 2006-09-24 20:56:52.84 spid3 Recovery complete.
> >> 2006-09-24 20:56:52.89 spid3 Warning: override, autoexec procedures
> >> skipped.
> >> 2006-09-24 20:57:03.01 spid51 Error: 15457, Severity: 0, State: 1
> >> 2006-09-24 20:57:03.01 spid51 Configuration option 'allow updates'
> >> changed from 0 to 1. Run the RECONFIGURE statement to install..
> >> 2006-09-24 20:57:03.09 spid51 Error: 15457, Severity: 0, State: 1
> >> 2006-09-24 20:57:03.09 spid51 Configuration option 'allow updates'
> >> changed from 1 to 0. Run the RECONFIGURE statement to install..
> >> 2006-09-24 20:57:03.65 spid3 SQL Server is terminating due to 'stop'
> >> request from Service Control Manager.
> >>
> >> --
> >> JB
> >>
> >>
> >> "JB" wrote:
> >>
> >> > I am trying to install a second instance of sql server 2000. I am
> >> > running
> >> > xp
> >> > pro and using the developer edition. When I run the install, it
> >> > completes
> >> > normally. The registry has entries for the new named instance. When I
> >> > try
> >> > to register the new server using enterprise manager and add it to a
> >> > group,
> >> > first the wizard does not list the new name. If I type in the name and
> >> > proceed, I eventually get an error message saying "sql server does not
> >> > exist
> >> > or access denied. ..." The error log shows that it gets part way with
> >> > starting the service but then is stopped before completing. I don't
> >> > remember
> >> > now the limitations on the Developer Edition, is this one of them or is
> >> > there
> >> > another problem? I am using mixed mode with an sa login.
> >> > --
> >> > JB
> >>
> >>
>
>
Monday, March 19, 2012
Installation Question
We have a webserver running Frontpage. We have a second server running SQL
Server. I would like to install Reporting Services on the Web Server. Will
there be a problem with this? Will I need to install Visual Studio on the
Webserver first?
ThanksHolly, have you found out anything about this.
If not, consider this a bump.
Thanks,
ViperD
"HollyylloH" wrote:
> We have a webserver running Frontpage. We have a second server running SQL
> Server. I would like to install Reporting Services on the Web Server. Will
> there be a problem with this? Will I need to install Visual Studio on the
> Webserver first?
> Thanks|||I answered her. You do not need frontpage on the web server or VS. VS is
needed for designing reports, it is not needed on the server. Just ignore
the message about VS when installing the server. I do not have VS or
frontpage running on my servers.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ViperD" <ViperD@.discussions.microsoft.com> wrote in message
news:22DE367C-EF2B-43D8-BA03-559A1E810D41@.microsoft.com...
> Holly, have you found out anything about this.
> If not, consider this a bump.
> Thanks,
> ViperD
> "HollyylloH" wrote:
>> We have a webserver running Frontpage. We have a second server running
>> SQL
>> Server. I would like to install Reporting Services on the Web Server.
>> Will
>> there be a problem with this? Will I need to install Visual Studio on the
>> Webserver first?
>> Thanks
Server. I would like to install Reporting Services on the Web Server. Will
there be a problem with this? Will I need to install Visual Studio on the
Webserver first?
ThanksHolly, have you found out anything about this.
If not, consider this a bump.
Thanks,
ViperD
"HollyylloH" wrote:
> We have a webserver running Frontpage. We have a second server running SQL
> Server. I would like to install Reporting Services on the Web Server. Will
> there be a problem with this? Will I need to install Visual Studio on the
> Webserver first?
> Thanks|||I answered her. You do not need frontpage on the web server or VS. VS is
needed for designing reports, it is not needed on the server. Just ignore
the message about VS when installing the server. I do not have VS or
frontpage running on my servers.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ViperD" <ViperD@.discussions.microsoft.com> wrote in message
news:22DE367C-EF2B-43D8-BA03-559A1E810D41@.microsoft.com...
> Holly, have you found out anything about this.
> If not, consider this a bump.
> Thanks,
> ViperD
> "HollyylloH" wrote:
>> We have a webserver running Frontpage. We have a second server running
>> SQL
>> Server. I would like to install Reporting Services on the Web Server.
>> Will
>> there be a problem with this? Will I need to install Visual Studio on the
>> Webserver first?
>> Thanks
Wednesday, March 7, 2012
Installation MSDE - worked first time not second
Hello,
On my Window 2000 machine I was able to install MSDE one time. However, was
having trouble actually connecting to the new database server so I though I
would reinstall. Well, I have not had a succesful reinstall yet (I was
closer the first time around). Now, I am a long ways off from developing
anything with MSDE and the instruction on how to set this DB Server up is
not apparent!
I am very frustrated. I don't know what to do at this point.
Please help.
Karl
hi Karl,
"Karl" <karl@.meetscoresonline_no_spam.com> ha scritto nel messaggio
news:%23tFoktubEHA.2944@.TK2MSFTNGP11.phx.gbl...
> Hello,
> On my Window 2000 machine I was able to install MSDE one time. However,
was
> having trouble actually connecting to the new database server so I though
I
> would reinstall. Well, I have not had a succesful reinstall yet (I was
> closer the first time around). Now, I am a long ways off from developing
> anything with MSDE and the instruction on how to set this DB Server up is
> not apparent!
> I am very frustrated. I don't know what to do at this point.
> Please help.
please make sure that previous MSDE installation has been completely fixed,
removing all file system and registry entries as described in
http://support.microsoft.com/default...;EN-US;Q290991
this will clean up all info of previously installed and (partially) removed
instances but Window Installer registry entries..
in order to clear them to, you have to follow
http://support.microsoft.com/default...b;en-us;320873 advices,
using MSIZap.exe from Platform SDK... I never cleared that and have found no
further problems, but my registry is now dirty :-(
=;-D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, I will follow these steps. I have tried similar steps.
Just recently, I have been trying to obtain the MSIZAP.EXE application but
it is wrapped in together with another SDK. Well, this SDK as failed 2 times
now to install, using the ActiveX installer from MS. So now what? Is there
another way to obtain MSIZAP.EXE?
By the way, this is a fresh copy of Win2K loaded on this system... I'm not
having much luck.
Karl
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2m7carFjuhp7U1@.uni-berlin.de...[vbcol=seagreen]
> hi Karl,
> "Karl" <karl@.meetscoresonline_no_spam.com> ha scritto nel messaggio
> news:%23tFoktubEHA.2944@.TK2MSFTNGP11.phx.gbl...
> was
though[vbcol=seagreen]
> I
developing[vbcol=seagreen]
is
> please make sure that previous MSDE installation has been completely
fixed,
> removing all file system and registry entries as described in
> http://support.microsoft.com/default...;EN-US;Q290991
> this will clean up all info of previously installed and (partially)
removed
> instances but Window Installer registry entries..
> in order to clear them to, you have to follow
> http://support.microsoft.com/default...b;en-us;320873 advices,
> using MSIZap.exe from Platform SDK... I never cleared that and have found
no
> further problems, but my registry is now dirty :-(
> =;-D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Karl,
"Karl" <karl@.meetscoresonline_no_spam.com> ha scritto nel messaggio
news:eJ8cEM2bEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Thanks, I will follow these steps. I have tried similar steps.
> Just recently, I have been trying to obtain the MSIZAP.EXE application but
> it is wrapped in together with another SDK. Well, this SDK as failed 2
times
> now to install, using the ActiveX installer from MS. So now what? Is there
> another way to obtain MSIZAP.EXE?
> By the way, this is a fresh copy of Win2K loaded on this system... I'm not
> having much luck.
>
don't know if this is the same...
http://download.microsoft.com/downlo...-US/msicuu.exe
it's from an old KB article, id 238413, no more available, but the link
seems to work...
at your own risks =;-DDDD
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
On my Window 2000 machine I was able to install MSDE one time. However, was
having trouble actually connecting to the new database server so I though I
would reinstall. Well, I have not had a succesful reinstall yet (I was
closer the first time around). Now, I am a long ways off from developing
anything with MSDE and the instruction on how to set this DB Server up is
not apparent!
I am very frustrated. I don't know what to do at this point.
Please help.
Karl
hi Karl,
"Karl" <karl@.meetscoresonline_no_spam.com> ha scritto nel messaggio
news:%23tFoktubEHA.2944@.TK2MSFTNGP11.phx.gbl...
> Hello,
> On my Window 2000 machine I was able to install MSDE one time. However,
was
> having trouble actually connecting to the new database server so I though
I
> would reinstall. Well, I have not had a succesful reinstall yet (I was
> closer the first time around). Now, I am a long ways off from developing
> anything with MSDE and the instruction on how to set this DB Server up is
> not apparent!
> I am very frustrated. I don't know what to do at this point.
> Please help.
please make sure that previous MSDE installation has been completely fixed,
removing all file system and registry entries as described in
http://support.microsoft.com/default...;EN-US;Q290991
this will clean up all info of previously installed and (partially) removed
instances but Window Installer registry entries..
in order to clear them to, you have to follow
http://support.microsoft.com/default...b;en-us;320873 advices,
using MSIZap.exe from Platform SDK... I never cleared that and have found no
further problems, but my registry is now dirty :-(
=;-D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, I will follow these steps. I have tried similar steps.
Just recently, I have been trying to obtain the MSIZAP.EXE application but
it is wrapped in together with another SDK. Well, this SDK as failed 2 times
now to install, using the ActiveX installer from MS. So now what? Is there
another way to obtain MSIZAP.EXE?
By the way, this is a fresh copy of Win2K loaded on this system... I'm not
having much luck.
Karl
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2m7carFjuhp7U1@.uni-berlin.de...[vbcol=seagreen]
> hi Karl,
> "Karl" <karl@.meetscoresonline_no_spam.com> ha scritto nel messaggio
> news:%23tFoktubEHA.2944@.TK2MSFTNGP11.phx.gbl...
> was
though[vbcol=seagreen]
> I
developing[vbcol=seagreen]
is
> please make sure that previous MSDE installation has been completely
fixed,
> removing all file system and registry entries as described in
> http://support.microsoft.com/default...;EN-US;Q290991
> this will clean up all info of previously installed and (partially)
removed
> instances but Window Installer registry entries..
> in order to clear them to, you have to follow
> http://support.microsoft.com/default...b;en-us;320873 advices,
> using MSIZap.exe from Platform SDK... I never cleared that and have found
no
> further problems, but my registry is now dirty :-(
> =;-D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Karl,
"Karl" <karl@.meetscoresonline_no_spam.com> ha scritto nel messaggio
news:eJ8cEM2bEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Thanks, I will follow these steps. I have tried similar steps.
> Just recently, I have been trying to obtain the MSIZAP.EXE application but
> it is wrapped in together with another SDK. Well, this SDK as failed 2
times
> now to install, using the ActiveX installer from MS. So now what? Is there
> another way to obtain MSIZAP.EXE?
> By the way, this is a fresh copy of Win2K loaded on this system... I'm not
> having much luck.
>
don't know if this is the same...
http://download.microsoft.com/downlo...-US/msicuu.exe
it's from an old KB article, id 238413, no more available, but the link
seems to work...
at your own risks =;-DDDD
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)