How to silently uninstall SQL Server 2005 Express

Hi.

I'm trying to perform a silent install/uninstall of SQL Server 2005 Express.
I manage to install silently, but when trying to uninstall with the following command line:

sqlexpr.exe /qb REMOVE=ALL INSTANCENAME=<INSTANCENAME>

there is one item left behind - "Microsoft SQL Server Native Client"

Does anyone know how to uninstall this as well?

Also, if MSXML 6.0 is already installed when installing SQL Server 2005 Express, when performing an uninstall with the above command line, MSXML 6.0 is also uninstalled, which may not be the desired outcome.

SQL Server Native Client remains on the box after SQL uninstall if another program is relying on it. If you know no other apps are using it, you can use msiexec to uninstall sqlncli.msi (the native client installer/uninstaller).

Thanks,
Sam Lester (MSFT)

|||Hm,
did a full search for "sqlncli.msi" after uninstalling SQL Server 2005 Express - including hidden files, but I cannot find it?

How to silently uninstall SQL Server 2005 Express

Hi.

I'm trying to perform a silent install/uninstall of SQL Server 2005 Express.
I manage to install silently, but when trying to uninstall with the following command line:

sqlexpr.exe /qb REMOVE=ALL INSTANCENAME=<INSTANCENAME>

there is one item left behind - "Microsoft SQL Server Native Client"

Does anyone know how to uninstall this as well?

Also, if MSXML 6.0 is already installed when installing SQL Server 2005 Express, when performing an uninstall with the above command line, MSXML 6.0 is also uninstalled, which may not be the desired outcome.

SQL Server Native Client remains on the box after SQL uninstall if another program is relying on it. If you know no other apps are using it, you can use msiexec to uninstall sqlncli.msi (the native client installer/uninstaller).

Thanks,
Sam Lester (MSFT)

|||Hm,
did a full search for "sqlncli.msi" after uninstalling SQL Server 2005 Express - including hidden files, but I cannot find it?

How to silently uninstall SQL Server 2005 Express

Hi.

I'm trying to perform a silent install/uninstall of SQL Server 2005 Express.
I manage to install silently, but when trying to uninstall with the following command line:

sqlexpr.exe /qb REMOVE=ALL INSTANCENAME=<INSTANCENAME>

there is one item left behind - "Microsoft SQL Server Native Client"

Does anyone know how to uninstall this as well?

Also, if MSXML 6.0 is already installed when installing SQL Server 2005 Express, when performing an uninstall with the above command line, MSXML 6.0 is also uninstalled, which may not be the desired outcome.

SQL Server Native Client remains on the box after SQL uninstall if another program is relying on it. If you know no other apps are using it, you can use msiexec to uninstall sqlncli.msi (the native client installer/uninstaller).

Thanks,
Sam Lester (MSFT)

|||Hm,
did a full search for "sqlncli.msi" after uninstalling SQL Server 2005 Express - including hidden files, but I cannot find it?
sql

How to set-up sql server 2000 in win2k3 Server to store big-5 Chinese data

I am using Windows 2003 Server English Version. I wanna store the big-5
data so I install the sql server 2000 as if i install it in the Windows
2000 with Server Collation of the Chinese_Taiwan_Stroke_CL_AS.
However, the data are stored into the database server in unicode
instead of big-5 in that of windows 2000 OS.

I would like to ask how i can set so that the Sql Server 2000 can store
the big-5 data(micmic.chion@.gmail.com) writes:
> I am using Windows 2003 Server English Version. I wanna store the big-5
> data so I install the sql server 2000 as if i install it in the Windows
> 2000 with Server Collation of the Chinese_Taiwan_Stroke_CL_AS.
> However, the data are stored into the database server in unicode
> instead of big-5 in that of windows 2000 OS.
> I would like to ask how i can set so that the Sql Server 2000 can store
> the big-5 data

First of all, my knowledge and experience of Chinese and its character
sets is very limited, so bear with me.

I was under the impression that for non-Unicode characters sets, East
Asian languages are stored in varchar as double-byte character sets.
Unicode is stored in nvarchar. So you would probably use varchar for
your data. Could this be the answer?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I am using the varchar for the fields of table which i wanna save big-5
data.

When i entered the chinese data, the data can be saved. But when i read
the data from the web boswer (ie. IE ), i need to change the encoding
from unicode instead of big-5 in order to viewing it

Is it due to the language of the OS (ie. WIndows 2003)?|||(micmic.chion@.gmail.com) writes:
> I am using the varchar for the fields of table which i wanna save big-5
> data.
> When i entered the chinese data, the data can be saved. But when i read
> the data from the web boswer (ie. IE ), i need to change the encoding
> from unicode instead of big-5 in order to viewing it
> Is it due to the language of the OS (ie. WIndows 2003)?

Hm, if the columns in the database are varchar, then you just cannot
get Unicode into them. So my guess is that you do have Big-5 in the
database, and then something happens on the way to the web browser.

You could verify this by looking in Qurey Analyzer and doing a
SELECT on the table. If it looks OK, then I would guess it is
Big-5. Do run it even further you could do:

select convert(varbinary, big5col)

and the see whether the codes are Big-5 or Unicode. (This presumes that
you actually knows the codes for some characters.)

If my theory is correct that the data in the database is Big5, then
we need to find out why you get Unicode in the browser. Unfortunately,
I know almost as little about web servers as I know Chinese.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||(micmic.chion@.gmail.com) writes:
> I am using the varchar for the fields of table which i wanna save big-5
> data.
> When i entered the chinese data, the data can be saved. But when i read
> the data from the web boswer (ie. IE ), i need to change the encoding
> from unicode instead of big-5 in order to viewing it
> Is it due to the language of the OS (ie. WIndows 2003)?

Hm, if the columns in the database are varchar, then you just cannot
get Unicode into them. So my guess is that you do have Big-5 in the
database, and then something happens on the way to the web browser.

You could verify this by looking in Qurey Analyzer and doing a
SELECT on the table. If it looks OK, then I would guess it is
Big-5. Do run it even further you could do:

select convert(varbinary, big5col)

and the see whether the codes are Big-5 or Unicode. (This presumes that
you actually knows the codes for some characters.)

If my theory is correct that the data in the database is Big5, then
we need to find out why you get Unicode in the browser. Unfortunately,
I know almost as little about web servers as I know Chinese.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I try the method you mentioned in both MS SQL Server in Windows 2000
server and Windows 2K3.

select convert(varbinary, big5col)

It is found that the binary is the same.

I have found out that if you add the following in the heading of the
page,
this page can show the big-5 character.

<%@. codepage=950 %
As the string stored in database is in unicode format, if you set the
codepage as big-5 format, the data will be changed as big-5 and show in
the webpage.

Thank you for your great sugegstion

Ref: Chinese-simpified version:
http://www.evget.com/articles/evget_1092.html

Erland Sommarskog 寫道：
> (micmic.chion@.gmail.com) writes:
> > I am using the varchar for the fields of table which i wanna save big-5
> > data.
> > When i entered the chinese data, the data can be saved. But when i read
> > the data from the web boswer (ie. IE ), i need to change the encoding
> > from unicode instead of big-5 in order to viewing it
> > Is it due to the language of the OS (ie. WIndows 2003)?
> Hm, if the columns in the database are varchar, then you just cannot
> get Unicode into them. So my guess is that you do have Big-5 in the
> database, and then something happens on the way to the web browser.
> You could verify this by looking in Qurey Analyzer and doing a
> SELECT on the table. If it looks OK, then I would guess it is
> Big-5. Do run it even further you could do:
> select convert(varbinary, big5col)
> and the see whether the codes are Big-5 or Unicode. (This presumes that
> you actually knows the codes for some characters.)
> If my theory is correct that the data in the database is Big5, then
> we need to find out why you get Unicode in the browser. Unfortunately,
> I know almost as little about web servers as I know Chinese.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||(micmic.chion@.gmail.com) writes:
> I try the method you mentioned in both MS SQL Server in Windows 2000
> server and Windows 2K3.
> select convert(varbinary, big5col)
> It is found that the binary is the same.
> I have found out that if you add the following in the heading of the
> page,
> this page can show the big-5 character.
><%@. codepage=950 %>
>
> As the string stored in database is in unicode format, if you set the
> codepage as big-5 format, the data will be changed as big-5 and show in
> the webpage.
>
> Thank you for your great sugegstion

I'm glad to have been to help about something I hardly know at all!

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

How to setup integration services on a cluster

Does anyone know how to install SQL 2005 integration services on a cluster machine?

I have an a-a cluster machine. Both nodes are using SQL 2005 naming instance. During the SQL installation, I did include integration services option as one of my setup items. The setup process was running fine but I can’t connect to integration services via MS SQL Server management studio. I see below errors:

“Invalid server name "TESTServer\B123". SSIS service does not support multi-instance, use just server name instead of "server name\instance".

Looks like I must use default instance for 2005 integration services. I re-ran the setup program and added a default instance on the same cluster node. (On that node I have one default instance and one naming instance). Now I can connect to the default SQL Server but when I click on “stored packages”, I don’t see file system and MSDB. It shows nothing at all. Any idea how to make integration services running on a cluster machine?

Thanks

I had the same error when I tried to view an SSIS package on my server with 2 instances but I had no default instance, so my case was a little different than yours. The way I resolved my problem was by hard coding both instances into my XML configuration file. I did not have a cluster in this case but the principle should be the same, you'll just have to play around with it a little bit. You may also have to modify the XML file on both nodes of your cluster.

<ServerName>my-server-01\instance1</ServerName>
<ServerName>my-server-01\instance2</ServerName>

If you have a default instance and a named instance you might try something like this:

<ServerName>my-server-01</ServerName>
<ServerName>my-server-01\instance1</ServerName>

Microsoft SQL Server 2005 Integration Services (SSIS) includes a configuration file for configuring the Integration Services service.

By default, the file is located in the folder, Program Files\Microsoft SQL Server\90\DTS\Binn, and the file name is MsDtsSrvr.ini.xml.

http://msdn2.microsoft.com/en-us/library/ms137789.aspx

|||

Microsoft has a document published on how to install Integration Services on a cluster.

http://msdn2.microsoft.com/en-us/library/ms345193.aspx

|||

I have the same problem in that I have set up SSIS on the cluster using the microsoft instructions. The SSIS service starts and fails over between nodes just fine. The problem is that I cannot see the MSDB or File System under Stored Packages. I've double (tripple) checked the path to the XML in the registry, the registry path in the cluster service properties, and the XML itself. Everything seems in order.

Any ideas?

|||

I'm in exactly the same situation. Did anyone resolve this problem ?

tia

bryn64

|||Have smae problem. Resolution?

How to setup integration services on a cluster

Does anyone know how to install SQL 2005 integration services on a cluster machine?

I have an a-a cluster machine. Both nodes are using SQL 2005 naming instance. During the SQL installation, I did include integration services option as one of my setup items. The setup process was running fine but I can’t connect to integration services via MS SQL Server management studio. I see below errors:

“Invalid server name "TESTServer\B123". SSIS service does not support multi-instance, use just server name instead of "server name\instance".

Looks like I must use default instance for 2005 integration services. I re-ran the setup program and added a default instance on the same cluster node. (On that node I have one default instance and one naming instance). Now I can connect to the default SQL Server but when I click on “stored packages”, I don’t see file system and MSDB. It shows nothing at all. Any idea how to make integration services running on a cluster machine?

Thanks

I had the same error when I tried to view an SSIS package on my server with 2 instances but I had no default instance, so my case was a little different than yours. The way I resolved my problem was by hard coding both instances into my XML configuration file. I did not have a cluster in this case but the principle should be the same, you'll just have to play around with it a little bit. You may also have to modify the XML file on both nodes of your cluster.

<ServerName>my-server-01\instance1</ServerName>
<ServerName>my-server-01\instance2</ServerName>

If you have a default instance and a named instance you might try something like this:

<ServerName>my-server-01</ServerName>
<ServerName>my-server-01\instance1</ServerName>

Microsoft SQL Server 2005 Integration Services (SSIS) includes a configuration file for configuring the Integration Services service.

By default, the file is located in the folder, Program Files\Microsoft SQL Server\90\DTS\Binn, and the file name is MsDtsSrvr.ini.xml.

http://msdn2.microsoft.com/en-us/library/ms137789.aspx

|||

Microsoft has a document published on how to install Integration Services on a cluster.

http://msdn2.microsoft.com/en-us/library/ms345193.aspx

|||

I have the same problem in that I have set up SSIS on the cluster using the microsoft instructions. The SSIS service starts and fails over between nodes just fine. The problem is that I cannot see the MSDB or File System under Stored Packages. I've double (tripple) checked the path to the XML in the registry, the registry path in the cluster service properties, and the XML itself. Everything seems in order.

Any ideas?

|||

I'm in exactly the same situation. Did anyone resolve this problem ?

tia

bryn64

|||Have smae problem. Resolution?sql

How to setup integration services on a cluster

Does anyone know how to install SQL 2005 integration services on a cluster machine?

I have an a-a cluster machine. Both nodes are using SQL 2005 naming instance. During the SQL installation, I did include integration services option as one of my setup items. The setup process was running fine but I can’t connect to integration services via MS SQL Server management studio. I see below errors:

“Invalid server name "TESTServer\B123". SSIS service does not support multi-instance, use just server name instead of "server name\instance".

Looks like I must use default instance for 2005 integration services. I re-ran the setup program and added a default instance on the same cluster node. (On that node I have one default instance and one naming instance). Now I can connect to the default SQL Server but when I click on “stored packages”, I don’t see file system and MSDB. It shows nothing at all. Any idea how to make integration services running on a cluster machine?

Thanks

I had the same error when I tried to view an SSIS package on my server with 2 instances but I had no default instance, so my case was a little different than yours. The way I resolved my problem was by hard coding both instances into my XML configuration file. I did not have a cluster in this case but the principle should be the same, you'll just have to play around with it a little bit. You may also have to modify the XML file on both nodes of your cluster.

<ServerName>my-server-01\instance1</ServerName>
<ServerName>my-server-01\instance2</ServerName>

If you have a default instance and a named instance you might try something like this:

<ServerName>my-server-01</ServerName>
<ServerName>my-server-01\instance1</ServerName>

Microsoft SQL Server 2005 Integration Services (SSIS) includes a configuration file for configuring the Integration Services service.

By default, the file is located in the folder, Program Files\Microsoft SQL Server\90\DTS\Binn, and the file name is MsDtsSrvr.ini.xml.

http://msdn2.microsoft.com/en-us/library/ms137789.aspx

|||

Microsoft has a document published on how to install Integration Services on a cluster.

http://msdn2.microsoft.com/en-us/library/ms345193.aspx

|||

I have the same problem in that I have set up SSIS on the cluster using the microsoft instructions. The SSIS service starts and fails over between nodes just fine. The problem is that I cannot see the MSDB or File System under Stored Packages. I've double (tripple) checked the path to the XML in the registry, the registry path in the cluster service properties, and the XML itself. Everything seems in order.

Any ideas?

|||

I'm in exactly the same situation. Did anyone resolve this problem ?

tia

bryn64

|||Have smae problem. Resolution?

how to set Default instant of sql server 2005

Dear All,
I install sql 2005 that instant name give Harshad but after installation
come as harshad\harshad
my pc name harshad. Now I want to set as harshad or (local) instant without
reinstalation.
thanks,
harshadharshad,
The bad news is that you cannot rename an instance. You will have to
reinstall to get a (local) instance. In the installation process do not
give an instance name but choose the default instance.
RLF
"harshad" <harshad7_jp@.hotmail.com> wrote in message
news:274295E6-1EE8-445E-B3A8-73655BD467AD@.microsoft.com...
> Dear All,
> I install sql 2005 that instant name give Harshad but after installation
> come as harshad\harshad
> my pc name harshad. Now I want to set as harshad or (local) instant
> without reinstalation.
> thanks,
> harshad
>

how to set collation to SQL_Latin1_General_CP1_CI_AS at install ?

help
All my USER DB have been created using the following collationL
SQL_Latin1_General_CP1_CI_AS
My "SQL instance 1" uses :
Latin1_General_CI_AS
Im in the process of setting up "SQL instance 2" and cannot find an option
to set the collation to SQL_Latin1_General_CP1_CI_AS
At install the "COLLATION DESIGNATOR and sort order" field shows
LATIN1_GENERAL.
The "SQL collations...." option below shows various options.
I cannot see an options to setup as "SQL_Latin1_General_CP1_CI_AS" or
"Latin1_General_CI_AS".
How can i use the setup wizard to select "SQL_Latin1_General_CP1_CI_AS"
Thanks for any help
Scott
(SQL 2005 standard - english)CP1 specifies code page 1252, for all other code pages the complete code
page number is specified.
CI specifies case-insensitive
AS specifies accent-sensitive.
Sort order ID SQL collation name
52 SQL_Latin1_General_Cp1_CI_AS
For more information about this topic, you can refer to the following link:
http://msdn2.microsoft.com/en-us/library/ms180175.aspx
Ekrem Önsoy
"Scott" <s@.yahoo.co.uk> wrote in message
news:O2pRP4%23CIHA.1212@.TK2MSFTNGP05.phx.gbl...
> help
> All my USER DB have been created using the following collationL
> SQL_Latin1_General_CP1_CI_AS
> My "SQL instance 1" uses :
> Latin1_General_CI_AS
> Im in the process of setting up "SQL instance 2" and cannot find an option
> to set the collation to SQL_Latin1_General_CP1_CI_AS
> At install the "COLLATION DESIGNATOR and sort order" field shows
> LATIN1_GENERAL.
> The "SQL collations...." option below shows various options.
> I cannot see an options to setup as "SQL_Latin1_General_CP1_CI_AS" or
> "Latin1_General_CI_AS".
> How can i use the setup wizard to select "SQL_Latin1_General_CP1_CI_AS"
> Thanks for any help
> Scott
> (SQL 2005 standard - english)
>
>|||thats helpful, many thanks
scott