Collation in SQL Server

Is there a way the collation can be changed just for a particular database
rather that on the whole Database Instance. If So, then how and would I be
able to do the same to any number of databases no matter what the collation
is at the Instance Level.
Regards
RV
You can set the collation for a database only on SQL Server 2000, it can't
be done on earlier versions.
If you have SQL Server 2000, you can change the collation for the database
with:
ALTER DATABASE <database name> COLLATE < collation_name >
Note that this will only change the default collation for new columns
created in the database with no explicit collation. All existing columns
will keep the collation they have already.
I have a script that can change the collation of existing columns (not a
trivial affair). I can post this here if you want or you can just Google
this group, as it has been posted before.
Jacco Schalkwijk
SQL Server MVP
"RV" <RV@.discussions.microsoft.com> wrote in message
news:F2E3C62A-0AC5-4EA9-8BA9-CB6866063C77@.microsoft.com...
> Is there a way the collation can be changed just for a particular database
> rather that on the whole Database Instance. If So, then how and would I be
> able to do the same to any number of databases no matter what the
> collation
> is at the Instance Level.
> Regards
> RV

Collation in SQL Server

Is there a way the collation can be changed just for a particular database
rather that on the whole Database Instance. If So, then how and would I be
able to do the same to any number of databases no matter what the collation
is at the Instance Level.
Regards
RVYou can set the collation for a database only on SQL Server 2000, it can't
be done on earlier versions.
If you have SQL Server 2000, you can change the collation for the database
with:
ALTER DATABASE <database name> COLLATE < collation_name >
Note that this will only change the default collation for new columns
created in the database with no explicit collation. All existing columns
will keep the collation they have already.
I have a script that can change the collation of existing columns (not a
trivial affair). I can post this here if you want or you can just Google
this group, as it has been posted before.
--
Jacco Schalkwijk
SQL Server MVP
"RV" <RV@.discussions.microsoft.com> wrote in message
news:F2E3C62A-0AC5-4EA9-8BA9-CB6866063C77@.microsoft.com...
> Is there a way the collation can be changed just for a particular database
> rather that on the whole Database Instance. If So, then how and would I be
> able to do the same to any number of databases no matter what the
> collation
> is at the Instance Level.
> Regards
> RV

Collation in SQL Server

Is there a way the collation can be changed just for a particular database
rather that on the whole Database Instance. If So, then how and would I be
able to do the same to any number of databases no matter what the collation
is at the Instance Level.
Regards
RVYou can set the collation for a database only on SQL Server 2000, it can't
be done on earlier versions.
If you have SQL Server 2000, you can change the collation for the database
with:
ALTER DATABASE <database name> COLLATE < collation_name >
Note that this will only change the default collation for new columns
created in the database with no explicit collation. All existing columns
will keep the collation they have already.
I have a script that can change the collation of existing columns (not a
trivial affair). I can post this here if you want or you can just Google
this group, as it has been posted before.
Jacco Schalkwijk
SQL Server MVP
"RV" <RV@.discussions.microsoft.com> wrote in message
news:F2E3C62A-0AC5-4EA9-8BA9-CB6866063C77@.microsoft.com...
> Is there a way the collation can be changed just for a particular database
> rather that on the whole Database Instance. If So, then how and would I be
> able to do the same to any number of databases no matter what the
> collation
> is at the Instance Level.
> Regards
> RV

Collation Conflict Error 368 (I think)

We just upgraded an instance of SQL Server 2000 to SQL Server 2005. When using our application to login, we are receiving an error 368, which refers to a collation conflict. Has anyone seen this?

I'm moving your thread to the database engine forum, where it may get more attention.

Paul

|||Run the profiler to see which statement your application is issuing against the database. Are you sure you are using the same collation on the new server than on the old one ? Normally this happens if you are comparing two different collation with each other (like in joins or equal expressions).

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Unfortunately, only this message got moved for those of us using NNTP. Any chance that when you move a thread, you can mention where the thread was moved *from*, so we can see it? That will certainly increase the chance that it gets more attention after being moved. Steve Kass Drew University Paul Nicholson - MSFT@.discussions.microsoft.com wrote:
> I'm moving your thread to the database engine forum, where it may get
> more attention.
>
> Paul
>
>

Collates - CP437 - ADO - Visual Basic

Hello, I am workink with a Database that has the Collate SQL_Latin1_General_CP437_CI_AS (Instance and Database-SQL2000), this convert the Database in a OEM Server.
I Can save Characters From 0 to 256 ASCII code CP 437 very well on the database (I import this Data with an DTS) but when i retrive the information with Visual Basic 6.0 with ADO some character > 127 are changed.
Did you know how I can fix It ?
I know that the problem is that Windows is ANSI and my SQL Server OEM, but .. a dontt know how yo fix it.
Thanks I sorry because my poor english. :(

Walter
ArgentinaThe easy answer is to do the transfer using Unicode (16 bit characters). This allows any character that Windows recognizes to pass through without problem.

If you've already got the file that was produced from the table using the 437 collation and want to import it into a server with a different collation, then things get a bit tricky, but they can still be done.

-PatP|||The problem is that I must work with the Hexadecimal code of the character, because I need to send this code (Hexa of ASCII) to a Printer (Special Printer).
All the program is around this printer and I need manipulate ASCII codes.
Thanks you :D

Walter|||Take the data from the table using the 437 collation in a Unicode (16 bit) text file. This format allows the easy transportation of any character that Windows supports, regardless of the character's collation or character set.

The Unicode format will preserve the exact character, although sometimes moving a character from one 8 bit character set to another will cause the hex value of the character to change even though it preserves the glyph (the printed form) of the character exactly. You need to decide if it is more important to preserve the hex value or the glyph for your purposes.

-PatP|||You can replace DTS transformation task with Win32 task and call a batch that contains BCP. In the BCP call you can include -C <code_page>.

And Pat, it's not collation, it's a code page, and with BCP there are no "tricks" ;)|||A code page is definitely one way to implement part of a collation. I see a collation as a lot more complex and flexible than a code page.

I find it interesting that you suggested one of what I consider the tricks for using BCP (specifying a code page) and noted that you feel that BCP has no tricks in the same posting. I have a hard time understanding that apparent contradiction.

-PatP|||How can it be a contradiction if this is part of the syntax?

I see a collation as a lot more complex and flexible than a code page.One has nothing to do with the other, so do tell, - how do you see them? In blue?|||Gracias a Todos, pude resolver el problema.
En el string de conexion con el servidor SQL Server 2000 hay un parametro que se puede indicar para que al momento de recuperar los caracteres, el servidor no los modifique. Este parametro se llama Auto Translate.
Al poner Auto Translate = No los valores Hexadecimales de los caracteres que se guardan en la base permanecen intactos. Probe de Generar una Tabla con 2 columnas, la primera tiene un valor entero de 0 a 255 y la segunda es un caracter en el cual puse un codigo ASCII de 0 a 255, al tomarlo desde Visual Basic muestro el valor entero de 0 a 255, el caracter y luego con una funcion de visual muestro el valor Hexadecimal del caracter y vi muy felizmente que en los 255 casos permanecia igual.

>You can replace DTS transformation task with Win32 task and call a batch that contains BCP. In the BCP call you can include -C <code_page>.

Con respecto al DST, yo no tengo problemas con el DTS ya que al importar un archivo de texto, el mismo se importa exactamente con los cdigos exadecimales que este tiene.

>You need to decide if it is more important to preserve the hex value or the glyph for your purposes.

Para mi es mucho mas importante preservar el codigo Hexadecimal porque este codigo es un caracter de control para la impresora, independientemente de como se vea visualmente en pantalla, la impresora interpreta el codigo Hexadecimal.

Now, I will try to translate all the text but.. its very hard.
Thanks to all of you, I can fix the problem.
There is a parameter In the String of conexion with the SQL Server 2000 that indicate that don`t change the Hexadecimal code when you retrieve the characters from the server. This parameters is call "Auto Translate"

I don`t have problem with the DTS. The DTS imports Ok the characters from the ASCII file.

For me, it`s more important the Hex value that the glymp value because the printer interpretes the Hex value, not the Glyp.

Sorry because my poor english, I cant translate all exactly but i think that the idea is the same.
Thanks !!!

Walter|||Based on how you've described your needs, my first choice would be to use BCP, using the -c trick that rdjabarov suggested earlier for both export and import. The -c parameter allows you to control exactly which Windows code page is used for the file, and as long as the code page/collation mapping operation supports the charcters you need going both ways, you should be fine.

My second choice would be to extract the data using a view, converting the column to VARBINARY to preserve the hex values exactly. This usually means that you need to import the output of that view into a scratch table, then convert the hexadecimal value back to a character value inside of SQL Server.

If you can extract the data directly from one server to another, using a linked server, that would be my next suggestion.

-PatP

Co-Existence of MSDE Instances

My server has an instance of MSDE that was installed by the VERITAS backup
software.I have a new application now thats to be deployed which will need
MSDE,Is it ok to load another instance of MSDE for the new application or can
I use the one instance to run both VERITAS and the New application...any
suggestions will be much appreciated.
Thank you all.
hi Maverick,
"maverick" <maverick@.discussions.microsoft.com> ha scritto nel messaggio
news:2239EDC1-15D6-4F6E-B0DC-093D5199D97E@.microsoft.com...
> My server has an instance of MSDE that was installed by the VERITAS backup
> software.I have a new application now thats to be deployed which will need
> MSDE,Is it ok to load another instance of MSDE for the new application or
can
> I use the one instance to run both VERITAS and the New application...any
> suggestions will be much appreciated.
> Thank you all.
as you already know, technically you can install up to 16 MSDE/SQL Server
instances on the same server... only 1 instance can be the default
instances, where all others will be named instances..
legally, it's all another story.
since MSDE has become rellay free, the original constraint that each ISV
MUST install his/her own instance has become obsolete, but....
but each ISV can legally protect his/her own installed instance so that it
can not be used by other applications/external databases
so you have to check Verits documentation or directly ask them for such an
info
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You don't really want to share another application's instance anyway. What
is the SA password they are using? Even if you are granted access (which I
doubt), what happens when the software is updated and they replace the
database or you uninstall the application and the database (and the MSDE)
instance is removed?
No, you really should install your own instance until we get to SQL Express
which does suggest/encourage use of a common instance.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2q2sltFqoea4U1@.uni-berlin.de...
> hi Maverick,
> "maverick" <maverick@.discussions.microsoft.com> ha scritto nel messaggio
> news:2239EDC1-15D6-4F6E-B0DC-093D5199D97E@.microsoft.com...
> can
> as you already know, technically you can install up to 16 MSDE/SQL Server
> instances on the same server... only 1 instance can be the default
> instances, where all others will be named instances..
> legally, it's all another story.
> since MSDE has become rellay free, the original constraint that each ISV
> MUST install his/her own instance has become obsolete, but....
> but each ISV can legally protect his/her own installed instance so that it
> can not be used by other applications/external databases
> so you have to check Verits documentation or directly ask them for such an
> info
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Well, it worked for me. I installed the MSCRM Outlook Sales client on my
laptop. It installs MSDE for it's database.
They I installed Microsoft Small business Manager which will also create a
MSDE database.
It worked and the machine did not complain too much.
But beyond that I did not do much.
Also this worked with full SqL and MSDE on the same laptop.
MSDE supported Sales Outlook Client for MSCRM and I had the Great Plains 7.5
running and connecting the client to the full MSSQL Databases.
I slowed the laptop down but that was about it.
Hope that helps.
"maverick" wrote:

> My server has an instance of MSDE that was installed by the VERITAS backup
> software.I have a new application now thats to be deployed which will need
> MSDE,Is it ok to load another instance of MSDE for the new application or can
> I use the one instance to run both VERITAS and the New application...any
> suggestions will be much appreciated.
> Thank you all.
|||With the MSDE, you are encouraged to run your application in its own
instance. This also avoids issues with administrative passwords, etc. In the
future (with SQL Express), the situation changes though and you'll be
encouraged to use the single SQLExpress instance.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Curt Spanburgh" <CurtSpanburgh@.discussions.microsoft.com> wrote in message
news:D42533B2-F027-40F4-B2B8-E05E3299857F@.microsoft.com...
> Well, it worked for me. I installed the MSCRM Outlook Sales client on my
> laptop. It installs MSDE for it's database.
> They I installed Microsoft Small business Manager which will also create a
> MSDE database.
> It worked and the machine did not complain too much.
> But beyond that I did not do much.
> Also this worked with full SqL and MSDE on the same laptop.
> MSDE supported Sales Outlook Client for MSCRM and I had the Great Plains
7.5[vbcol=seagreen]
> running and connecting the client to the full MSSQL Databases.
> I slowed the laptop down but that was about it.
> Hope that helps.
>
> "maverick" wrote:
backup[vbcol=seagreen]
need[vbcol=seagreen]
or can[vbcol=seagreen]

Cnot start SQL Server 2000sp3

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...[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!
>

Cnot start SQL Server 2000sp3

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