" Starting custom action ConfigServer
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "Latin1_General""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information. "
that is the last action before the install fail in the log
does anyone know what's wrong?
thanx
Lok
hi Lok,
"Lok" <Lok@.discussions.microsoft.com> ha scritto nel messaggio
news:7B1D91E0-00CA-4C32-AC67-267BCFF7958A@.microsoft.com
> " Starting custom action ConfigServer
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q
> "Latin1_General""
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information. "
> that is the last action before the install fail in the log
> does anyone know what's wrong?
> thanx
> Lok
please have a look at
http://support.microsoft.com/default...99&Product=sql
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
|||I have tried every resolutions found on the website and it was still not
installing.
I've always set the lanaguage for non Unicode programs to chinese( Hong
Kong) to be able to display chinese character in the system natively. I have
specified the collation to Latin1_General in order for the setup to start but
the installation was never successful.
After switching the language back to English(United States), MSDE installed
fine.
Now my question is if I switch the language back to Chinese(Hong Kong),
would that mess up the MSDE install.
thanx
Lok
"Andrea Montanari" wrote:
> hi Lok,
> "Lok" <Lok@.discussions.microsoft.com> ha scritto nel messaggio
> news:7B1D91E0-00CA-4C32-AC67-267BCFF7958A@.microsoft.com
> please have a look at
> http://support.microsoft.com/default...99&Product=sql
> --
> 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
>
Showing posts with label files. Show all posts
Showing posts with label files. Show all posts
Friday, March 23, 2012
Monday, March 19, 2012
MSDE (SQL 2000) Full Service Pack 1 (2)
I need the full Service Pack 1 (or 2) MSDE Installation files to include in an Installer. I am not interested in upgrading current MSDE RTM installs but rather need to install an MSDE SP1 (2) Instance on the client machines. I found a lot of places to get the files but the weird thing is in the supposed MSDE SP2 download files (SQL2KDeskSP2.exe) the sample.msi and samplupgr.msi files are missing that are the templates to be used to create the unique (GUID) MSI installation files for MSDE. Microsoft highly recommends creating the unique MSI files to ensure a previous instance did not use an MSI file with the same GUID.
see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
The SQL2KDeskSP2.exe does include the SQLRUN01.MSI SQLRUN16.MSI files, but nowhere does it say you can use one of these files as a template and change the GUID internally using ORCA and VC++.
Are we supposed to use the old sample and sampleupg.msi files with SP2 .. but use all the other Install files for SP 1 (2) ?
Please excuse my ignorance of the "Windows Installer" software.
Thanks very much for any information,
Billy MatlockI have been able to get the full sql server sp1 files using msdn subscriber download. I think you have to order a cd if you do not have an msdn subscription.
I have not found a full desktop download for sp2 - although the page that announced the availability of sp2 implied that it would be in the subscriber downloads and that was a while ago.
see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
The SQL2KDeskSP2.exe does include the SQLRUN01.MSI SQLRUN16.MSI files, but nowhere does it say you can use one of these files as a template and change the GUID internally using ORCA and VC++.
Are we supposed to use the old sample and sampleupg.msi files with SP2 .. but use all the other Install files for SP 1 (2) ?
Please excuse my ignorance of the "Windows Installer" software.
Thanks very much for any information,
Billy MatlockI have been able to get the full sql server sp1 files using msdn subscriber download. I think you have to order a cd if you do not have an msdn subscription.
I have not found a full desktop download for sp2 - although the page that announced the availability of sp2 implied that it would be in the subscriber downloads and that was a while ago.
Monday, March 12, 2012
MSDE & datadir
Is it possible that on the client's machine I install my MSDE instance in the default location (C:\Program Files\Microsoft SQL Server), i.e. do not specify any datadir or Targetdir location in the setup BUT still create my app's database (during installat
ion) in my app's folder, for e.g. in C:\Program Files\MyCompany\Data\ folder and then attach this database's .mdf file to my instance which I installed. Is it necessary that the database has to be in the data folder under the MSDE install location...
Please suggest.
I am asking because I want to have nothing but database in the my app's data folder.
>> still create my app's database (during installation) in my app's folder
Yes. This is possible. It is NOT mandated that the specific databases that
you create should also fall inside the default location. In event that you
create database without any specific paths then they are created in the
default location.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"qa" <anonymous@.discussions.microsoft.com> wrote in message
news:CC9D5500-4C13-45B6-9040-F4A908DAEB26@.microsoft.com...
> Is it possible that on the client's machine I install my MSDE instance in
the default location (C:\Program Files\Microsoft SQL Server), i.e. do not
specify any datadir or Targetdir location in the setup BUT still create my
app's database (during installation) in my app's folder, for e.g. in
C:\Program Files\MyCompany\Data\ folder and then attach this database's .mdf
file to my instance which I installed. Is it necessary that the database
has to be in the data folder under the MSDE install location...
> Please suggest.
> I am asking because I want to have nothing but database in the my app's
data folder.
|||Thanks Vinod for your reply. How can I specify path for the database (not the entire data folder) as C:\Program Files\MyCompany\Data\ while creating the database using scripts during the installation program. And is keeping the database away in myapp's
folder a recommended way of working..
qa
|||You have to specify the path to the database and log files in the CREATE
DATABASE statement of the script file. Example for a database called "HAS":
CREATE DATABASE [HAS] ON (NAME = N'HAS_Data', FILENAME = N'f:\Microsoft SQL
Server\MSSQL\data\HAS_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME =
N'HAS_Log', FILENAME = N'f:\Microsoft SQL Server\MSSQL\data\HAS_Log.LDF' ,
SIZE = 1, FILEGROWTH = 10%)
COLLATE Latin1_General_CI_AS
GO
Willem
"qa" <anonymous@.discussions.microsoft.com> schreef in bericht
news:A7253E41-0E31-4D5C-967F-E7483AE75304@.microsoft.com...
> Thanks Vinod for your reply. How can I specify path for the database (not
the entire data folder) as C:\Program Files\MyCompany\Data\ while creating
the database using scripts during the installation program. And is keeping
the database away in myapp's folder a recommended way of working..
> qa
ion) in my app's folder, for e.g. in C:\Program Files\MyCompany\Data\ folder and then attach this database's .mdf file to my instance which I installed. Is it necessary that the database has to be in the data folder under the MSDE install location...
Please suggest.
I am asking because I want to have nothing but database in the my app's data folder.
>> still create my app's database (during installation) in my app's folder
Yes. This is possible. It is NOT mandated that the specific databases that
you create should also fall inside the default location. In event that you
create database without any specific paths then they are created in the
default location.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"qa" <anonymous@.discussions.microsoft.com> wrote in message
news:CC9D5500-4C13-45B6-9040-F4A908DAEB26@.microsoft.com...
> Is it possible that on the client's machine I install my MSDE instance in
the default location (C:\Program Files\Microsoft SQL Server), i.e. do not
specify any datadir or Targetdir location in the setup BUT still create my
app's database (during installation) in my app's folder, for e.g. in
C:\Program Files\MyCompany\Data\ folder and then attach this database's .mdf
file to my instance which I installed. Is it necessary that the database
has to be in the data folder under the MSDE install location...
> Please suggest.
> I am asking because I want to have nothing but database in the my app's
data folder.
|||Thanks Vinod for your reply. How can I specify path for the database (not the entire data folder) as C:\Program Files\MyCompany\Data\ while creating the database using scripts during the installation program. And is keeping the database away in myapp's
folder a recommended way of working..
qa
|||You have to specify the path to the database and log files in the CREATE
DATABASE statement of the script file. Example for a database called "HAS":
CREATE DATABASE [HAS] ON (NAME = N'HAS_Data', FILENAME = N'f:\Microsoft SQL
Server\MSSQL\data\HAS_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME =
N'HAS_Log', FILENAME = N'f:\Microsoft SQL Server\MSSQL\data\HAS_Log.LDF' ,
SIZE = 1, FILEGROWTH = 10%)
COLLATE Latin1_General_CI_AS
GO
Willem
"qa" <anonymous@.discussions.microsoft.com> schreef in bericht
news:A7253E41-0E31-4D5C-967F-E7483AE75304@.microsoft.com...
> Thanks Vinod for your reply. How can I specify path for the database (not
the entire data folder) as C:\Program Files\MyCompany\Data\ while creating
the database using scripts during the installation program. And is keeping
the database away in myapp's folder a recommended way of working..
> qa
Wednesday, March 7, 2012
MSDE
I successfully installed MSDE, but I cannot open the application.
All my files and folder are installed under: C:\Program Files\Microsoft SQL
Server\MSSQL$NETSDK. My operating system is Windows XP Professional and my
Internet Explorer is version 6.0.
What do I need to do? Please advice.
Thank you!
Hi
With MSDE, there is no application you can run. It is a database engine and
does not have a UI.
Generally developers write and application that uses MSDE as the database.
You could use Microsoft Access to access it through an ODBC connection.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"gacevedo" <gacevedo@.discussions.microsoft.com> wrote in message
news:888E44C1-B974-4EC7-96B6-F52E79AE6250@.microsoft.com...
>I successfully installed MSDE, but I cannot open the application.
> All my files and folder are installed under: C:\Program Files\Microsoft
> SQL
> Server\MSSQL$NETSDK. My operating system is Windows XP Professional and
> my
> Internet Explorer is version 6.0.
> What do I need to do? Please advice.
> Thank you!
|||However, it seems we couldn't use Access 2003 to create table with MSDE 2005
express. Is it normal? Or any patch we need to install? Thanks.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:erAE1RCBGHA.3536@.TK2MSFTNGP11.phx.gbl...
> Hi
> With MSDE, there is no application you can run. It is a database engine
> and does not have a UI.
> Generally developers write and application that uses MSDE as the database.
> You could use Microsoft Access to access it through an ODBC connection.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "gacevedo" <gacevedo@.discussions.microsoft.com> wrote in message
> news:888E44C1-B974-4EC7-96B6-F52E79AE6250@.microsoft.com...
>
|||The Access 2003 tools (and the VS 2003 database tools) aren't compatible
with the SQL 2005 meta-data so you won't be able to use them. There
currently isn't a new version of this available.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Good" <good@.man.com> wrote in message
news:u95MJckHGHA.2912@.tk2msftngp13.phx.gbl...
> However, it seems we couldn't use Access 2003 to create table with MSDE
> 2005 express. Is it normal? Or any patch we need to install? Thanks.
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:erAE1RCBGHA.3536@.TK2MSFTNGP11.phx.gbl...
>
All my files and folder are installed under: C:\Program Files\Microsoft SQL
Server\MSSQL$NETSDK. My operating system is Windows XP Professional and my
Internet Explorer is version 6.0.
What do I need to do? Please advice.
Thank you!
Hi
With MSDE, there is no application you can run. It is a database engine and
does not have a UI.
Generally developers write and application that uses MSDE as the database.
You could use Microsoft Access to access it through an ODBC connection.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"gacevedo" <gacevedo@.discussions.microsoft.com> wrote in message
news:888E44C1-B974-4EC7-96B6-F52E79AE6250@.microsoft.com...
>I successfully installed MSDE, but I cannot open the application.
> All my files and folder are installed under: C:\Program Files\Microsoft
> SQL
> Server\MSSQL$NETSDK. My operating system is Windows XP Professional and
> my
> Internet Explorer is version 6.0.
> What do I need to do? Please advice.
> Thank you!
|||However, it seems we couldn't use Access 2003 to create table with MSDE 2005
express. Is it normal? Or any patch we need to install? Thanks.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:erAE1RCBGHA.3536@.TK2MSFTNGP11.phx.gbl...
> Hi
> With MSDE, there is no application you can run. It is a database engine
> and does not have a UI.
> Generally developers write and application that uses MSDE as the database.
> You could use Microsoft Access to access it through an ODBC connection.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "gacevedo" <gacevedo@.discussions.microsoft.com> wrote in message
> news:888E44C1-B974-4EC7-96B6-F52E79AE6250@.microsoft.com...
>
|||The Access 2003 tools (and the VS 2003 database tools) aren't compatible
with the SQL 2005 meta-data so you won't be able to use them. There
currently isn't a new version of this available.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Good" <good@.man.com> wrote in message
news:u95MJckHGHA.2912@.tk2msftngp13.phx.gbl...
> However, it seems we couldn't use Access 2003 to create table with MSDE
> 2005 express. Is it normal? Or any patch we need to install? Thanks.
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:erAE1RCBGHA.3536@.TK2MSFTNGP11.phx.gbl...
>
msdbdata.mdf file is over 5 GB, cannot shrink it
I have problem with my sql server developer edition.
I began reciving alerts regarding disk space, and found out that the msdb files are 5 GB!!! the data file is full, so I cannot shrink it, but the table usage shows only a few MB used by tables.
its not advisable to shrink the system dbs except tempdb,but in your case just check if any user tables are created in msdb if so just delete the same to free diskspace.... then try shrinking msdb but b4 shrinking ensure you have the latest backup of all the dbs....|||
There are no user tables on this server.
It a local developer version, I use for development and small checks, there is no back up nither.
Subscribe to:
Posts (Atom)