and I cannot start the SQL server when the instance name is other than the
default. Can someone tell me what is wrong?
Hi Yiannis,
From your descriptions, I understood that you could not start SQL Server's
instance when this instance is not the default one by MSDE. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know
Based on my knowledge, database engine operates as a service or process
that is separate from any application using MSDE 2000. Either MSDE 2000 or
any other version of SQL Server can be running at the same time on the same
computer. Each copy is called an instance. Each instance is installed,
started, stopped, configured, and patched independently of the other
instances.
However, I am not sure your steps about the installation and start-up for
the instance and what error messages could you find Event Log. Would you
please give me detailed descriptions about it, which I believe, will get us
closer to the resolution
Could you give me a descriptions, with which Icould reproduce it on my machine?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Here is how things are. With a setup project I am using all the merge
modules to install the SQL MSDE to the machine. When I configure the server
to use the default instance everything is going fine. When I change the
instance name and I use a named one then when I try to start the server
(same command "start") the server doesn;t start at all. I am trying to start
the server with the command from the instance binn dir "sqlservr -scommerce"
and I cannot start it. When I use the sqlmanagr to start the server it is
starting but the command doesn't start it.
Running machine is an XP Professional version 2002.
From the command prompt the command is going till "SQL Server is ready for
client connections" and never gets to an end.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> From your descriptions, I understood that you could not start SQL Server's
> instance when this instance is not the default one by MSDE. Have I
> understood you? If there is anything I misunderstood, please feel free to
> let me know
> Based on my knowledge, database engine operates as a service or process
> that is separate from any application using MSDE 2000. Either MSDE 2000 or
> any other version of SQL Server can be running at the same time on the
same
> computer. Each copy is called an instance. Each instance is installed,
> started, stopped, configured, and patched independently of the other
> instances.
> However, I am not sure your steps about the installation and start-up for
> the instance and what error messages could you find Event Log. Would you
> please give me detailed descriptions about it, which I believe, will get
us
> closer to the resolution
Could you give me a descriptions, with which I> could reproduce it on my machine?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
|||Hi Yiannis,
Thanks for you update!
However, I am still not sure about the root cause of this issue, Would you
please help me collection more detailed information? More detailed
information, I believe, will get us closer to the resolutions
First of all, could you start MSSQL Services by means of Control Panel ->
Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
Services by running Command "net start mssqlserver" (without quotation
marks)?
Secondly, could you see some error logs when you are starting up the SQL
Server? Error Number will be the most helpful ones for us to
troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
about the startup and post it here?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer?
Yes I can.
Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
The server is doesn't start. When I press Enter a dialog opens and closes
but I don';t have a chance to see anything.
> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
>
Here is the log file.
2004-05-28 16:34:39.69 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: )
2004-05-28 16:34:39.72 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-05-28 16:34:39.73 server All rights reserved.
2004-05-28 16:34:39.74 server Server Process ID is 2680.
2004-05-28 16:34:39.74 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$COMMERCE\LOG\ERRORLOG'.
2004-05-28 16:34:39.78 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-05-28 16:34:39.82 server SQL Server configured for thread mode
processing.
2004-05-28 16:34:39.84 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2004-05-28 16:34:39.89 spid3 Starting up database 'master'.
2004-05-28 16:34:40.26 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-05-28 16:34:40.29 spid5 Starting up database 'model'.
2004-05-28 16:34:40.34 spid3 Server name is 'MANOSVMXP\COMMERCE'.
2004-05-28 16:34:40.35 spid3 Skipping startup of clean database id 4
2004-05-28 16:34:40.37 server SQL server listening on 192.5.129.70: 1041.
2004-05-28 16:34:40.38 server SQL server listening on 127.0.0.1: 1041.
2004-05-28 16:34:40.58 spid5 Clearing tempdb database.
2004-05-28 16:34:41.41 spid5 Starting up database 'tempdb'.
2004-05-28 16:34:41.76 spid3 Recovery complete.
2004-05-28 16:34:41.77 spid3 SQL global counter collection task is
created.
2004-05-28 16:34:42.67 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-05-28 16:34:42.69 server SQL Server is ready for client connections
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for you update!
> However, I am still not sure about the root cause of this issue, Would you
> please help me collection more detailed information? More detailed
> information, I believe, will get us closer to the resolutions
> First of all, could you start MSSQL Services by means of Control Panel ->
> Administrative Tools -> Services -> MSSQLServer? Could you start MSSQL
> Services by running Command "net start mssqlserver" (without quotation
> marks)?
> Secondly, could you see some error logs when you are starting up the SQL
> Server? Error Number will be the most helpful ones for us to
> troubleshooting. Could you find what in DISK:\\Path\MSSQL$InstanceName\LOG
> about the startup and post it here?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
|||Hi Yiannis,
Thanks for your updates!
Since you could start MSSQL Services, could you tell me what's the command
in "Path to executable"? (You could find Path to executeable in Control
Panel -> Services -> Right Click MSSQLServer\InstanceName)
Secondly, try to find what's the result of command "net start
mssqlserver\InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
Finally, it seems OK with your Log files. Would you please tell me when if
hangs in "SQL Server is ready for client connections", Could you login the
server? If not, what's the error message and error number you will get?
Anyway, Would you please show me why do you like to startup
MSSQLServer\InstanceName with command? Maybe it will be easier for us
finding a workaround
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
MSSQL. "Commerce" is the instance name.
Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
System error 123 has occured.
> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
it is hanging the command from a dos prompt and then I am trying from the
services by right clicking to start and I get an error (message actually)
which says "The MSSQL$COMMERCE service on Local Computer started and then
stopped. Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service."
> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround
>
I am using InstallShield to install an application to the target machine. I
have configured the merge modules of the SQL Server 2k with sp3 to install
and everything is working fine if I use the default instance name. Sinse
other software manufacturers are using the default instance name there is a
problem installing all software in one machine. So I thought that changing
the instance name of my app would solve this problem and I could have my app
running with a different instance name. There is where the problem started
and I cannot start the SQL server with this instance name. From my code I am
usinf the command to start the SQL.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for your updates!
> Since you could start MSSQL Services, could you tell me what's the command
> in "Path to executable"? (You could find Path to executeable in Control
> Panel -> Services -> Right Click MSSQLServer\InstanceName)
> Secondly, try to find what's the result of command "net start
> mssqlserver\InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> Finally, it seems OK with your Log files. Would you please tell me when if
> hangs in "SQL Server is ready for client connections", Could you login the
> server? If not, what's the error message and error number you will get?
> Anyway, Would you please show me why do you like to startup
> MSSQLServer\InstanceName with command? Maybe it will be easier for us
> finding a workaround
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||I am trying to start the SQL with SQL Server object and command start to
start it but since I cannot do it like this I am trying with command line
and this is not working either.
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Since you could start MSSQL Services, could you tell me what's the command
> The Command is "sqlservr -sCOMMERCE" the one I am using in order to start
> MSSQL. "Commerce" is the instance name.
>
> Secondly, try to find what's the result of command "net start
> System error 123 has occured.
>
if[vbcol=seagreen]
the
> it is hanging the command from a dos prompt and then I am trying from the
> services by right clicking to start and I get an error (message actually)
> which says "The MSSQL$COMMERCE service on Local Computer started and then
> stopped. Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service."
>
> I am using InstallShield to install an application to the target machine.
I
> have configured the merge modules of the SQL Server 2k with sp3 to install
> and everything is working fine if I use the default instance name. Sinse
> other software manufacturers are using the default instance name there is
a
> problem installing all software in one machine. So I thought that changing
> the instance name of my app would solve this problem and I could have my
app
> running with a different instance name. There is where the problem started
> and I cannot start the SQL server with this instance name. From my code I
am[vbcol=seagreen]
> usinf the command to start the SQL.
>
>
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl...
command[vbcol=seagreen]
if[vbcol=seagreen]
the[vbcol=seagreen]
rights.
>
|||Hi Yiannis,
Oops, It's an type that you shoud use $ instead of \
try to find what's the result of command "net start
mssqlserver$InstanceName" you could do it in the following ways
1. Strat -> Run -> typing "cmd" , without quatation marks
2. "net start mssqlserver\InstanceName"
What's the result of it? Could you start SQL Server successfully?
If you could, will this satisfy your requirements?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
I did it and I get an error "The service name is invalid"
I was looking at my previous post and I realize that it doesn;t make sense
what I wrote. The way I am trying to start SQL is with the Server object
from SQL-DMO. Since I cannot do it like this I am trying to start the server
with the command line.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Oops, It's an type that you shoud use $ instead of \
> try to find what's the result of command "net start
> mssqlserver$InstanceName" you could do it in the following ways
> 1. Strat -> Run -> typing "cmd" , without quatation marks
> 2. "net start mssqlserver\InstanceName"
> What's the result of it? Could you start SQL Server successfully?
> If you could, will this satisfy your requirements?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
No comments:
Post a Comment