I have installed MSDE version of SQL server 2000 and sp3 with merge modules
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 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!|||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...
> 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!
> >
>|||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!
>|||Hi Yiannis,
Thanks for your updates!
Unfortunatly, I am still not sure why you could not open your server with
"net start mssqlserver$COMMERCE". Would you please show me some detailed
information about it?
From your deccriptions, I understood you would like to start SQL Server
with SQL-DMO. Have I understood you? If there is anything I misunderstood,
please feel free to let me know :)
Based on my knowledge, SQL-DMO have Start method to do the job
Start Method (SQLServer)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
ef_m_s_7vg2.asp
Hope this helps and 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!|||> Unfortunatly, I am still not sure why you could not open your server with
> "net start mssqlserver$COMMERCE". Would you please show me some detailed
> information about it?
What kind of detailed information would you like?
> From your deccriptions, I understood you would like to start SQL Server
> with SQL-DMO. Have I understood you? If there is anything I misunderstood,
> please feel free to let me know :)
>
It is not that I would like to start SQL Server with SQL-DMO. It is that the
application I have starts SQL with SQL-DMO and when the instance name is the
default then everything is fine. The problem starts when the instance name
is other ther the default ie. COMMERCE.
Is there any possibility that the COMMERCE as an instance name is not an
allowed to use word?
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> Hi Yiannis,
> Thanks for your updates!
> Unfortunatly, I am still not sure why you could not open your server with
> "net start mssqlserver$COMMERCE". Would you please show me some detailed
> information about it?
> From your deccriptions, I understood you would like to start SQL Server
> with SQL-DMO. Have I understood you? If there is anything I misunderstood,
> please feel free to let me know :)
> Based on my knowledge, SQL-DMO have Start method to do the job
> Start Method (SQLServer)
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
> ef_m_s_7vg2.asp
> Hope this helps and 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!
>|||Considering that the instance name of the SQL is "Commerce" can you please
tell me the exact command to start the SQL server with SQL-DMO.
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> > Unfortunatly, I am still not sure why you could not open your server
with
> > "net start mssqlserver$COMMERCE". Would you please show me some detailed
> > information about it?
> What kind of detailed information would you like?
> > From your deccriptions, I understood you would like to start SQL Server
> > with SQL-DMO. Have I understood you? If there is anything I
misunderstood,
> > please feel free to let me know :)
> >
> It is not that I would like to start SQL Server with SQL-DMO. It is that
the
> application I have starts SQL with SQL-DMO and when the instance name is
the
> default then everything is fine. The problem starts when the instance name
> is other ther the default ie. COMMERCE.
> Is there any possibility that the COMMERCE as an instance name is not an
> allowed to use word?
>
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> > Hi Yiannis,
> >
> > Thanks for your updates!
> >
> > Unfortunatly, I am still not sure why you could not open your server
with
> > "net start mssqlserver$COMMERCE". Would you please show me some detailed
> > information about it?
> >
> > From your deccriptions, I understood you would like to start SQL Server
> > with SQL-DMO. Have I understood you? If there is anything I
misunderstood,
> > please feel free to let me know :)
> >
> > Based on my knowledge, SQL-DMO have Start method to do the job
> >
> > Start Method (SQLServer)
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
> > ef_m_s_7vg2.asp
> >
> > Hope this helps and 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,
We are looking for somebody who is familar with SQL DMO and will reply him with more information as soon as possible. Thanks very much.
Best regards,
Yanhong Huang
Microsoft Community Support
Get Secure! ¨C www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Yiannis,
Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
information.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
ef_con01_5qup.asp?frame=true
SQL-DMO Syntax to start SQL server is ,
--Syntax
object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
Also, the SQL Server Service name of the instance can be accessed as
"MSSQL$<instance name>"
Here is a sample code snippet using C++ to start the sqlserver instace of
name "Commerce",
HRESULT hr;
LPSQLDMOSERVER pSQLServer;
WCHAR* szServiceName = L"MSSQL$Commerce";
BOOL fConnect=0;
WCHAR* szLogin= L"Login";
WCHAR* szPassword = L"pswd";
hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**) &pSQLServer);
if (SUCCEEDED(hr))
pSQLServer->SetName (szServiceName);
pSQLServer->Start(fConnect,szLogin,szPassword);
pSQLServer->Release();
Please let me know if this resolves the problem, else feel free to post
further questions,
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
>References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
<L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
<eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
<8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
<O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
<vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
<eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
<#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
<D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
<uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
<57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
<uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
>Subject: Re: Cnot start SQL Server 2000sp3
>Date: Sat, 5 Jun 2004 13:58:01 +0300
>Lines: 73
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.0
>X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
>Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 62.103.238.182
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11
.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Considering that the instance name of the SQL is "Commerce" can you please
>tell me the exact command to start the SQL server with SQL-DMO.
>
>
>"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
>news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
>> > Unfortunatly, I am still not sure why you could not open your server
>with
>> > "net start mssqlserver$COMMERCE". Would you please show me some
detailed
>> > information about it?
>> What kind of detailed information would you like?
>> > From your deccriptions, I understood you would like to start SQL Server
>> > with SQL-DMO. Have I understood you? If there is anything I
>misunderstood,
>> > please feel free to let me know :)
>> >
>> It is not that I would like to start SQL Server with SQL-DMO. It is that
>the
>> application I have starts SQL with SQL-DMO and when the instance name is
>the
>> default then everything is fine. The problem starts when the instance
name
>> is other ther the default ie. COMMERCE.
>> Is there any possibility that the COMMERCE as an instance name is not an
>> allowed to use word?
>>
>> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
message
>> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
>> > Hi Yiannis,
>> >
>> > Thanks for your updates!
>> >
>> > Unfortunatly, I am still not sure why you could not open your server
>with
>> > "net start mssqlserver$COMMERCE". Would you please show me some
detailed
>> > information about it?
>> >
>> > From your deccriptions, I understood you would like to start SQL Server
>> > with SQL-DMO. Have I understood you? If there is anything I
>misunderstood,
>> > please feel free to let me know :)
>> >
>> > Based on my knowledge, SQL-DMO have Start method to do the job
>> >
>> > Start Method (SQLServer)
>> >
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
r
>> > ef_m_s_7vg2.asp
>> >
>> > Hope this helps and 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!
>> >
>>
>
>|||> pSQLServer->Start(fConnect,szLogin,szPassword);
You are missing one parameter which is the server (2nd parameter).
"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in message
news:o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl...
> Hello Yiannis,
> Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
> information.
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmor
> ef_con01_5qup.asp?frame=true
>
> SQL-DMO Syntax to start SQL server is ,
> --Syntax
> object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
> Also, the SQL Server Service name of the instance can be accessed as
> "MSSQL$<instance name>"
> Here is a sample code snippet using C++ to start the sqlserver instace of
> name "Commerce",
> HRESULT hr;
> LPSQLDMOSERVER pSQLServer;
> WCHAR* szServiceName = L"MSSQL$Commerce";
> BOOL fConnect=0;
> WCHAR* szLogin= L"Login";
> WCHAR* szPassword = L"pswd";
> hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
> CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**) &pSQLServer);
> if (SUCCEEDED(hr))
> pSQLServer->SetName (szServiceName);
> pSQLServer->Start(fConnect,szLogin,szPassword);
> pSQLServer->Release();
> Please let me know if this resolves the problem, else feel free to post
> further questions,
> Thanks for using MSDN Managed Newsgroup.
> Vikrant Dalwale
> Microsoft SQL Server Support Professional
>
> Microsoft highly recommends to all of our customers that they visit the
> http://www.microsoft.com/protect site and perform the three
straightforward
> steps listed to improve your computer?s security.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --
> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> >Subject: Re: Cnot start SQL Server 2000sp3
> >Date: Sat, 5 Jun 2004 13:58:01 +0300
> >Lines: 73
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> >X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> >Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> >Newsgroups: microsoft.public.sqlserver.server
> >NNTP-Posting-Host: 62.103.238.182
> >Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11
> phx.gbl
> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >
> >Considering that the instance name of the SQL is "Commerce" can you
please
> >tell me the exact command to start the SQL server with SQL-DMO.
> >
> >
> >
> >
> >
> >"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
> >news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> >> > Unfortunatly, I am still not sure why you could not open your server
> >with
> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> detailed
> >> > information about it?
> >>
> >> What kind of detailed information would you like?
> >>
> >> > From your deccriptions, I understood you would like to start SQL
Server
> >> > with SQL-DMO. Have I understood you? If there is anything I
> >misunderstood,
> >> > please feel free to let me know :)
> >> >
> >> It is not that I would like to start SQL Server with SQL-DMO. It is
that
> >the
> >> application I have starts SQL with SQL-DMO and when the instance name
is
> >the
> >> default then everything is fine. The problem starts when the instance
> name
> >> is other ther the default ie. COMMERCE.
> >> Is there any possibility that the COMMERCE as an instance name is not
an
> >> allowed to use word?
> >>
> >>
> >> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
> message
> >> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> >> > Hi Yiannis,
> >> >
> >> > Thanks for your updates!
> >> >
> >> > Unfortunatly, I am still not sure why you could not open your server
> >with
> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> detailed
> >> > information about it?
> >> >
> >> > From your deccriptions, I understood you would like to start SQL
Server
> >> > with SQL-DMO. Have I understood you? If there is anything I
> >misunderstood,
> >> > please feel free to let me know :)
> >> >
> >> > Based on my knowledge, SQL-DMO have Start method to do the job
> >> >
> >> > Start Method (SQLServer)
> >> >
> >>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
> r
> >> > ef_m_s_7vg2.asp
> >> >
> >> > Hope this helps and 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!
> >> >
> >>
> >>
> >
> >
> >
>|||Hello Yiannis,
Server Paramter is one of the 'optional' parameters. Since I set the
Service Name in
pSQLServer->SetName (szServiceName); I didn't use the Server Param.
Does that answer your question ?
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
>References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
<L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
<eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
<8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
<O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
<vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
<eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
<#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
<D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
<uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
<57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
<uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
<uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
<o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
>Subject: Re: Cnot start SQL Server 2000sp3
>Date: Tue, 8 Jun 2004 22:40:15 +0300
>Lines: 186
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.0
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
>Message-ID: <uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 62.103.183.221
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09|||I have been trying to find an example (like the one you gave me) how I can
start an SQL server using SQL-DMO and I couldn't find anywhere.
I am not saying the MSDN but an example.
Thanks a lot for your help
"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in message
news:OMi9fEcTEHA.308@.cpmsftngxa10.phx.gbl...
>
> Hello Yiannis,
> Server Paramter is one of the 'optional' parameters. Since I set the
> Service Name in
> pSQLServer->SetName (szServiceName); I didn't use the Server Param.
> Does that answer your question ?
> Thanks for using MSDN Managed Newsgroup.
> Vikrant Dalwale
> Microsoft SQL Server Support Professional
>
> Microsoft highly recommends to all of our customers that they visit the
> http://www.microsoft.com/protect site and perform the three
straightforward
> steps listed to improve your computer?s security.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --
> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> <o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
> >Subject: Re: Cnot start SQL Server 2000sp3
> >Date: Tue, 8 Jun 2004 22:40:15 +0300
> >Lines: 186
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> >Message-ID: <uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
> >Newsgroups: microsoft.public.sqlserver.server
> >NNTP-Posting-Host: 62.103.183.221
> >Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09
> phx.gbl
> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344998
> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >
> >> pSQLServer->Start(fConnect,szLogin,szPassword);
> >
> >
> >You are missing one parameter which is the server (2nd parameter).
> >
> >
> >
> >
> >"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in
message
> >news:o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl...
> >>
> >> Hello Yiannis,
> >>
> >> Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
> >> information.
> >>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
> r
> >> ef_con01_5qup.asp?frame=true
> >>
> >>
> >> SQL-DMO Syntax to start SQL server is ,
> >>
> >> --Syntax
> >> object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
> >>
> >> Also, the SQL Server Service name of the instance can be accessed as
> >> "MSSQL$<instance name>"
> >>
> >> Here is a sample code snippet using C++ to start the sqlserver instace
> of
> >> name "Commerce",
> >>
> >> HRESULT hr;
> >> LPSQLDMOSERVER pSQLServer;
> >> WCHAR* szServiceName = L"MSSQL$Commerce";
> >> BOOL fConnect=0;
> >> WCHAR* szLogin= L"Login";
> >> WCHAR* szPassword = L"pswd";
> >>
> >> hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
> >> CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**) &pSQLServer);
> >>
> >> if (SUCCEEDED(hr))
> >> pSQLServer->SetName (szServiceName);
> >> pSQLServer->Start(fConnect,szLogin,szPassword);
> >>
> >> pSQLServer->Release();
> >>
> >> Please let me know if this resolves the problem, else feel free to post
> >> further questions,
> >>
> >> Thanks for using MSDN Managed Newsgroup.
> >>
> >> Vikrant Dalwale
> >>
> >> Microsoft SQL Server Support Professional
> >>
> >>
> >> Microsoft highly recommends to all of our customers that they visit
the
> >> http://www.microsoft.com/protect site and perform the three
> >straightforward
> >> steps listed to improve your computer?s security.
> >> This posting is provided "AS IS" with no warranties, and confers no
> >rights.
> >>
> >>
> >>
> >> --
> >> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> >> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> >> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> >> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> >> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> >> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> >> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> >> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> >> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> >> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> >> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> >> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> >> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> >> >Subject: Re: Cnot start SQL Server 2000sp3
> >> >Date: Sat, 5 Jun 2004 13:58:01 +0300
> >> >Lines: 73
> >> >X-Priority: 3
> >> >X-MSMail-Priority: Normal
> >> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> >> >X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> >> >Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> >> >Newsgroups: microsoft.public.sqlserver.server
> >> >NNTP-Posting-Host: 62.103.238.182
> >> >Path:
> >>
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
> 1
> >> phx.gbl
> >> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
> >> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >> >
> >> >Considering that the instance name of the SQL is "Commerce" can you
> >please
> >> >tell me the exact command to start the SQL server with SQL-DMO.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
> >> >news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> >> >> > Unfortunatly, I am still not sure why you could not open your
server
> >> >with
> >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> >> detailed
> >> >> > information about it?
> >> >>
> >> >> What kind of detailed information would you like?
> >> >>
> >> >> > From your deccriptions, I understood you would like to start SQL
> >Server
> >> >> > with SQL-DMO. Have I understood you? If there is anything I
> >> >misunderstood,
> >> >> > please feel free to let me know :)
> >> >> >
> >> >> It is not that I would like to start SQL Server with SQL-DMO. It is
> >that
> >> >the
> >> >> application I have starts SQL with SQL-DMO and when the instance
name
> >is
> >> >the
> >> >> default then everything is fine. The problem starts when the
instance
> >> name
> >> >> is other ther the default ie. COMMERCE.
> >> >> Is there any possibility that the COMMERCE as an instance name is
not
> >an
> >> >> allowed to use word?
> >> >>
> >> >>
> >> >> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
> >> message
> >> >> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> >> >> > Hi Yiannis,
> >> >> >
> >> >> > Thanks for your updates!
> >> >> >
> >> >> > Unfortunatly, I am still not sure why you could not open your
server
> >> >with
> >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> >> detailed
> >> >> > information about it?
> >> >> >
> >> >> > From your deccriptions, I understood you would like to start SQL
> >Server
> >> >> > with SQL-DMO. Have I understood you? If there is anything I
> >> >misunderstood,
> >> >> > please feel free to let me know :)
> >> >> >
> >> >> > Based on my knowledge, SQL-DMO have Start method to do the job
> >> >> >
> >> >> > Start Method (SQLServer)
> >> >> >
> >> >>
> >>
>>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dm
> o
> >> r
> >> >> > ef_m_s_7vg2.asp
> >> >> >
> >> >> > Hope this helps and 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!
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >>
> >
> >
> >
>|||I tried the command and I cannot make it work. I still have a problem
starting SQL. By the way I found a solution on an XP machine to start it by
the "net start MSSQL$COMMERCE". The problem now is on Windows 98. What
should I do?
"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
news:OPvc#AfTEHA.644@.tk2msftngp13.phx.gbl...
> I have been trying to find an example (like the one you gave me) how I can
> start an SQL server using SQL-DMO and I couldn't find anywhere.
> I am not saying the MSDN but an example.
> Thanks a lot for your help
>
> "Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in
message
> news:OMi9fEcTEHA.308@.cpmsftngxa10.phx.gbl...
> >
> >
> > Hello Yiannis,
> >
> > Server Paramter is one of the 'optional' parameters. Since I set the
> > Service Name in
> > pSQLServer->SetName (szServiceName); I didn't use the Server Param.
> >
> > Does that answer your question ?
> >
> > Thanks for using MSDN Managed Newsgroup.
> >
> > Vikrant Dalwale
> >
> > Microsoft SQL Server Support Professional
> >
> >
> > Microsoft highly recommends to all of our customers that they visit the
> > http://www.microsoft.com/protect site and perform the three
> straightforward
> > steps listed to improve your computer?s security.
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> >
> > --
> > >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> > >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> > <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> > <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> > <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> > <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> > <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> > <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> > <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> > <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> > <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> > <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> > <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> > <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> > <o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
> > >Subject: Re: Cnot start SQL Server 2000sp3
> > >Date: Tue, 8 Jun 2004 22:40:15 +0300
> > >Lines: 186
> > >X-Priority: 3
> > >X-MSMail-Priority: Normal
> > >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> > >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> > >Message-ID: <uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
> > >Newsgroups: microsoft.public.sqlserver.server
> > >NNTP-Posting-Host: 62.103.183.221
> > >Path:
> >
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09
> > phx.gbl
> > >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344998
> > >X-Tomcat-NG: microsoft.public.sqlserver.server
> > >
> > >> pSQLServer->Start(fConnect,szLogin,szPassword);
> > >
> > >
> > >You are missing one parameter which is the server (2nd parameter).
> > >
> > >
> > >
> > >
> > >"Vikrant V Dalwale [MSFT]" <vikrantd@.online.microsoft.com> wrote in
> message
> > >news:o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl...
> > >>
> > >> Hello Yiannis,
> > >>
> > >> Please read "Getting Started with SQL-DMO" for detailed SQL-DMO
> > >> information.
> > >>
> >
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmo
> > r
> > >> ef_con01_5qup.asp?frame=true
> > >>
> > >>
> > >> SQL-DMO Syntax to start SQL server is ,
> > >>
> > >> --Syntax
> > >> object.Start( StartMode , [ Server ] , [ Login ] , [ Password ] )
> > >>
> > >> Also, the SQL Server Service name of the instance can be accessed as
> > >> "MSSQL$<instance name>"
> > >>
> > >> Here is a sample code snippet using C++ to start the sqlserver
instace
> > of
> > >> name "Commerce",
> > >>
> > >> HRESULT hr;
> > >> LPSQLDMOSERVER pSQLServer;
> > >> WCHAR* szServiceName = L"MSSQL$Commerce";
> > >> BOOL fConnect=0;
> > >> WCHAR* szLogin= L"Login";
> > >> WCHAR* szPassword = L"pswd";
> > >>
> > >> hr = CoCreateInstance(CLSID_SQLDMOServer, NULL,
> > >> CLSCTX_INPROC_SERVER, IID_ISQLDMOServer, (void**)
&pSQLServer);
> > >>
> > >> if (SUCCEEDED(hr))
> > >> pSQLServer->SetName (szServiceName);
> > >> pSQLServer->Start(fConnect,szLogin,szPassword);
> > >>
> > >> pSQLServer->Release();
> > >>
> > >> Please let me know if this resolves the problem, else feel free to
post
> > >> further questions,
> > >>
> > >> Thanks for using MSDN Managed Newsgroup.
> > >>
> > >> Vikrant Dalwale
> > >>
> > >> Microsoft SQL Server Support Professional
> > >>
> > >>
> > >> Microsoft highly recommends to all of our customers that they visit
> the
> > >> http://www.microsoft.com/protect site and perform the three
> > >straightforward
> > >> steps listed to improve your computer?s security.
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >rights.
> > >>
> > >>
> > >>
> > >> --
> > >> >From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
> > >> >References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
> > >> <L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
> > >> <eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
> > >> <8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
> > >> <O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
> > >> <vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
> > >> <eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
> > >> <#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
> > >> <D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
> > >> <uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
> > >> <57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
> > >> <uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
> > >> >Subject: Re: Cnot start SQL Server 2000sp3
> > >> >Date: Sat, 5 Jun 2004 13:58:01 +0300
> > >> >Lines: 73
> > >> >X-Priority: 3
> > >> >X-MSMail-Priority: Normal
> > >> >X-Newsreader: Microsoft Outlook Express 6.00.3790.0
> > >> >X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.132
> > >> >Message-ID: <uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
> > >> >Newsgroups: microsoft.public.sqlserver.server
> > >> >NNTP-Posting-Host: 62.103.238.182
> > >> >Path:
> > >>
> >
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
> > 1
> > >> phx.gbl
> > >> >Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:344441
> > >> >X-Tomcat-NG: microsoft.public.sqlserver.server
> > >> >
> > >> >Considering that the instance name of the SQL is "Commerce" can you
> > >please
> > >> >tell me the exact command to start the SQL server with SQL-DMO.
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >
> > >> >"Yiannis Patrikaidis" <yiannis@.arion.gr> wrote in message
> > >> >news:uFUjRifSEHA.644@.tk2msftngp13.phx.gbl...
> > >> >> > Unfortunatly, I am still not sure why you could not open your
> server
> > >> >with
> > >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> > >> detailed
> > >> >> > information about it?
> > >> >>
> > >> >> What kind of detailed information would you like?
> > >> >>
> > >> >> > From your deccriptions, I understood you would like to start SQL
> > >Server
> > >> >> > with SQL-DMO. Have I understood you? If there is anything I
> > >> >misunderstood,
> > >> >> > please feel free to let me know :)
> > >> >> >
> > >> >> It is not that I would like to start SQL Server with SQL-DMO. It
is
> > >that
> > >> >the
> > >> >> application I have starts SQL with SQL-DMO and when the instance
> name
> > >is
> > >> >the
> > >> >> default then everything is fine. The problem starts when the
> instance
> > >> name
> > >> >> is other ther the default ie. COMMERCE.
> > >> >> Is there any possibility that the COMMERCE as an instance name is
> not
> > >an
> > >> >> allowed to use word?
> > >> >>
> > >> >>
> > >> >> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in
> > >> message
> > >> >> news:57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl...
> > >> >> > Hi Yiannis,
> > >> >> >
> > >> >> > Thanks for your updates!
> > >> >> >
> > >> >> > Unfortunatly, I am still not sure why you could not open your
> server
> > >> >with
> > >> >> > "net start mssqlserver$COMMERCE". Would you please show me some
> > >> detailed
> > >> >> > information about it?
> > >> >> >
> > >> >> > From your deccriptions, I understood you would like to start SQL
> > >Server
> > >> >> > with SQL-DMO. Have I understood you? If there is anything I
> > >> >misunderstood,
> > >> >> > please feel free to let me know :)
> > >> >> >
> > >> >> > Based on my knowledge, SQL-DMO have Start method to do the job
> > >> >> >
> > >> >> > Start Method (SQLServer)
> > >> >> >
> > >> >>
> > >>
> >
>>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dm
> > o
> > >> r
> > >> >> > ef_m_s_7vg2.asp
> > >> >> >
> > >> >> > Hope this helps and 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!
> > >> >> >
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >> >
> > >>
> > >
> > >
> > >
> >
>|||Hello Yiannis,
Thanks for your patience.
On win98 OS, MSDE runs only as an application and NOT as a Service. With
Net start MSSQL$Commerce you are trying to run the MSDE as a service and it
won't work.
FYI..following are the limitations of MSDE running on Win9x box,
Microsoft Windows® 98 does not provide support for the following features:
Microsoft Windows NT® authentication
-Fiber mode scheduling
-Asynchronous I/O
-Read ahead
-Performance Monitor counters
-Scatter/Gather I/O
-Named pipes server network library
-Appletalk server or client network library
-Banyan Vines server network library
-Runs as application not as service.
So, you might wanna run the MSDE app along with the OS start ( By including
it in the autoexe.bat) or may wanna start it as a seperate application
(just like
any other apps.exe )
Does that answer your question ?
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Yiannis Patrikaidis" <yiannis@.arion.gr>
>References: <O90PkN3QEHA.1388@.TK2MSFTNGP09.phx.gbl>
<L7bQM84QEHA.752@.cpmsftngxa10.phx.gbl>
<eZ4LOA7QEHA.1620@.TK2MSFTNGP12.phx.gbl>
<8Jl0KIJREHA.3468@.cpmsftngxa10.phx.gbl>
<O74pNoLREHA.3596@.tk2msftngp13.phx.gbl>
<vCpgCsuREHA.3804@.cpmsftngxa10.phx.gbl>
<eGTy3zvREHA.1388@.TK2MSFTNGP09.phx.gbl>
<#w6pP2vREHA.3420@.TK2MSFTNGP11.phx.gbl>
<D5pHwn4REHA.2164@.cpmsftngxa10.phx.gbl>
<uTgOZ26REHA.3420@.TK2MSFTNGP11.phx.gbl>
<57AMPpTSEHA.3960@.cpmsftngxa10.phx.gbl>
<uFUjRifSEHA.644@.tk2msftngp13.phx.gbl>
<uaLxkxuSEHA.504@.TK2MSFTNGP11.phx.gbl>
<o8KAqlXTEHA.304@.cpmsftngxa10.phx.gbl>
<uvKvtBZTEHA.2128@.TK2MSFTNGP09.phx.gbl>
<OMi9fEcTEHA.308@.cpmsftngxa10.phx.gbl>
<OPvc#AfTEHA.644@.tk2msftngp13.phx.gbl>
>Subject: Re: Cnot start SQL Server 2000sp3
>Date: Thu, 10 Jun 2004 09:54:39 +0300
>Lines: 294
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.0
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132
>Message-ID: <#EGtKfrTEHA.3012@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: athei53-b-338.otenet.gr 62.103.183.98
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13
