Showing posts with label sp1. Show all posts
Showing posts with label sp1. Show all posts

Wednesday, March 28, 2012

Installing Import/Export Wizard for SQL Express

Where do I install the necessary files to get the import/export wizard to show up in sql express management studio? I have tried installing the SP1 Toolkit, the advanced services etc but I cannot get it so that I can right click on a database and 'import data' or 'export data'

Thanks!

I am not sure but because Management studio express is for express database which does not support SSIS services and SQL agent which are used for export/import by wizard this option was removed from user interface.

Sorry

|||

It does not show up on the UI but I found it in this directory

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

I think it comes with the Toolkit download

Tony

Wednesday, March 21, 2012

installed SP1 for .NET 1.1 and got 1st SQL Server Crash ever??

I've had SQL Server 2000 8.00.818 running flawlessly for over a year on Win2000
SP4
Installed the SP1 for .NET Framework 1.1 and within an hour SQL Server crashed
(and did not re-start)
-- system log --
Event ID 7031
Source: Service Control Manager
The MSSQLSERVER service terminated unexpectedly. It has done this 1 time(s).
The following corrective action will be taken in 0 milliseconds: No action.
-- application log --
Event ID 17055
Source: MSSQLSERVER
--The MSSQLSERVER service terminated unexpectedly. It has done this 1
time(s). The following corrective action will be taken in 0 milliseconds: No
action.
Event ID 17055
Source: MSSQLSERVER
17311 :
SQL Server is aborting. Fatal exception c0000005 caught.
should I un-ghost the box?
Thanks in advance, Les Caudle
There is a known issue with the 818 build with SQLEM passwords. The official post MS03-031 release is the 819 build.
What do your last SQL Server Error Logs indicate?
Before you do anything, take time to diagnose the situation. While SS is down, make copies of all of your system and user databases. You should have backups prior to the rollout.
Sincerely,
Anthony Thomas

"Les Caudle" <very@.tiredofspam.com> wrote in message news:qddcq058jhkdt8qnjs1njb7e9nffb56vek@.4ax.com...
I've had SQL Server 2000 8.00.818 running flawlessly for over a year on Win2000
SP4
Installed the SP1 for .NET Framework 1.1 and within an hour SQL Server crashed
(and did not re-start)
-- system log --
Event ID 7031
Source: Service Control Manager
The MSSQLSERVER service terminated unexpectedly. It has done this 1 time(s).
The following corrective action will be taken in 0 milliseconds: No action.
-- application log --
Event ID 17055
Source: MSSQLSERVER
--The MSSQLSERVER service terminated unexpectedly. It has done this 1
time(s). The following corrective action will be taken in 0 milliseconds: No
action.
--
Event ID 17055
Source: MSSQLSERVER
17311 :
SQL Server is aborting. Fatal exception c0000005 caught.
--
should I un-ghost the box?
--
Thanks in advance, Les Caudle

installed SP1 for .NET 1.1 and got 1st SQL Server Crash ever??

I've had SQL Server 2000 8.00.818 running flawlessly for over a year on Win
2000
SP4
Installed the SP1 for .NET Framework 1.1 and within an hour SQL Server crash
ed
(and did not re-start)
-- system log --
Event ID 7031
Source: Service Control Manager
The MSSQLSERVER service terminated unexpectedly. It has done this 1 time(s)
.
The following corrective action will be taken in 0 milliseconds: No action.
-- application log --
Event ID 17055
Source: MSSQLSERVER
--The MSSQLSERVER service terminated unexpectedly. It has done this
1
time(s). The following corrective action will be taken in 0 milliseconds: N
o
action.
--
Event ID 17055
Source: MSSQLSERVER
17311 :
SQL Server is aborting. Fatal exception c0000005 caught.
--
should I un-ghost the box?
--
Thanks in advance, Les CaudleThere is a known issue with the 818 build with SQLEM passwords. The officia
l post MS03-031 release is the 819 build.
What do your last SQL Server Error Logs indicate?
Before you do anything, take time to diagnose the situation. While SS is do
wn, make copies of all of your system and user databases. You should have b
ackups prior to the rollout.
Sincerely,
Anthony Thomas
--
"Les Caudle" <very@.tiredofspam.com> wrote in message news:qddcq058jhkdt8qn
js1njb7e9nffb56vek@.4ax.com...
I've had SQL Server 2000 8.00.818 running flawlessly for over a year on W
in2000
SP4
Installed the SP1 for .NET Framework 1.1 and within an hour SQL Server cra
shed
(and did not re-start)
-- system log --
Event ID 7031
Source: Service Control Manager
The MSSQLSERVER service terminated unexpectedly. It has done this 1 time(
s).
The following corrective action will be taken in 0 milliseconds: No action
.
-- application log --
Event ID 17055
Source: MSSQLSERVER
--The MSSQLSERVER service terminated unexpectedly. It has done thi
s 1
time(s). The following corrective action will be taken in 0 milliseconds:
No
action.
--
Event ID 17055
Source: MSSQLSERVER
17311 :
SQL Server is aborting. Fatal exception c0000005 caught.
--
should I un-ghost the box?
--
Thanks in advance, Les Caudle

Monday, March 19, 2012

Installation to different folder issue

I have only SQL engine installed to my D drive. (SQL Server 2005 no SP1)

I want to install SSIS to my D drive but i can not.

It only gives me the option to install to the default drive C:\...

saying that "the sql shared path has already been configured"

Is this a BUG ?

No Tools nor Notification Services are installed (which i understood to be related to the same path as SSIS)

thanks,

raviv

hi raviv,

there should be an advance option

to allow to configure the destination folder.

regards,

joey

|||

there is an advanced option.

but the changing of the path is disabled since it says:

"the sql shared path has already been configured"

but as this article indicates there must be a way to configure it:
http://msdn2.microsoft.com/en-us/library/ms143547.aspx

at least when non of the next components is installed:
Integration Services
Notification Services &
Client tools

since all must have the same path.

maybe it's just a problem of uninstalling (i did it to SSIS)
that is not freeing the registry entry of the "shared path" (BUG?)
if so, i might be able to change it directly.
but i don't want to mess with registry without knowing for sure ...

did anyone succeed to install SSIS to default path
and then trying to change the path (by reinstalling or other way) ?

Installation SP1 freezes

When I try to install SP1 on W2K3 Standard Server, the installation
freezes on "Inspecting".
I downloaded the file WindowsServer2003-KB889101-SP1-x86-ENU.exe from
the Microsoft download area.
I have tried the installation twice with the same results. The only
way out was to use the hardware Reset key.
Any ideas?
TIA
Sorry, posted into wrong group.

Installation SP1 freezes

When I try to install SP1 on W2K3 Standard Server, the installation
freezes on "Inspecting".
I downloaded the file WindowsServer2003-KB889101-SP1-x86-ENU.exe from
the Microsoft download area.
I have tried the installation twice with the same results. The only
way out was to use the hardware Reset key.
Any ideas?
TIASorry, posted into wrong group.

Installation SP1 freezes

When I try to install SP1 on W2K3 Standard Server, the installation
freezes on "Inspecting".
I downloaded the file WindowsServer2003-KB889101-SP1-x86-ENU.exe from
the Microsoft download area.
I have tried the installation twice with the same results. The only
way out was to use the hardware Reset key.
Any ideas?
TIASorry, posted into wrong group.

Monday, March 12, 2012

Installation problems with Reportin Services

I'm having problem installing SQL Server 2005 Express Edition with Advanced Services SP1. Everything installs fine until I reach the installation of Reporting Services, there I get the following message --> "IID_IIMSAdminBase object error. The error code is -2147221164."

Any ideas as to how to solve this..?

Thanks in advance.

Could you post the information from the setup logs?

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

Mike

|||

Any answer to this post?....I am having the same problem.

Patrick (pdill@.clovor.com)

|||Same for you, can you post the log files of the installer ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Jens,

I uninstalled SQL Server(all parts of it), Uninstalled IIS, and the reinstalled worked fine.

Patrick.

Installation problems with Reportin Services

I'm having problem installing SQL Server 2005 Express Edition with Advanced Services SP1. Everything installs fine until I reach the installation of Reporting Services, there I get the following message --> "IID_IIMSAdminBase object error. The error code is -2147221164."

Any ideas as to how to solve this..?

Thanks in advance.

Could you post the information from the setup logs?

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

Mike

Installation Problem SQL Express 2005 on Win 2003 SP1

Hi, I've a problem to install SQL Server Express 2005 on Win 2003 SP1.
Do you know how to solve the problem ?

It displays error message after I click the setup file:

SQL Server Setup unexpetedly failed. For more information, review the Setup summary log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt

Then I open the Summary.txt, it contains:

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 1 (Build 3790)
Time : Thu Sep 21 11:17:18 2006

And review the SQLSetup0001_PCNAME_Core.txt in the Log Files directory:

Microsoft SQL Server 2005 Setup beginning at Thu Sep 21 11:17:18 2006
Process ID : 688
D:\Master\SQLExpress2005\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/8/21 11:17:18
Complete: LoadResourcesAction at: 2006/8/21 11:17:18, returned true
Running: ParseBootstrapOptionsAction at: 2006/8/21 11:17:18
Loaded DLL:D:\Master\SQLExpress2005\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/8/21 11:17:18, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "688"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/8/21 11:17:18
Complete: ValidateWinNTAction at: 2006/8/21 11:17:18, returned true
Running: ValidateMinOSAction at: 2006/8/21 11:17:18
Complete: ValidateMinOSAction at: 2006/8/21 11:17:18, returned true
Running: PerformSCCAction at: 2006/8/21 11:17:18
Complete: PerformSCCAction at: 2006/8/21 11:17:18, returned true
Running: ActivateLoggingAction at: 2006/8/21 11:17:18
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
00D3CFC8Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "688"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

hello all MSFT.. please help me...

I can install it on Windows XP.SP2.. but can't on Windows 2003 SP1..

what wrong in the Windows 2003 .. is any requirements missing ?

Friday, March 9, 2012

Installation of SQL server 2005 SP1

Hi,

We have the Windows server 2003 R2 Service PAck 2 , we got updated to this version after i installed automatic updates today,and i am having problems with setting up maintenance plan in SQL server 2005 (9.0.1399)

Hence i am trying to install Sql server 2005 SP1, but the read me file says that this installation is compatible only with Windows server 2003 SP1

Also, i received this error when i tried to install SQL server 2005 SP1 yesterday

"The image file hotfix.exe is valid, but is for a machine type other than the current machine"

I am confused, Can someone help me out in this regard?

Thanks in advance

The second part of the post (valid for another type of machine) typically refers to an error you see when you try to install an X64 (64-bit) service pack on an X86 machine (32-bit). For that one, I'd just suggest to double check that you have the corrent installation package for your machine.

Wednesday, March 7, 2012

installation of sp1. sql server integration services do not start

hi,

after installing sp1 for sql server 2005 the sql server integration services did not start. and i can`t start them manually. the installation succeeded without problems (both sql server and sp1)

the only problem was with installing sql server 2005. in the sql server configurations manager the following protocols were disabled:

- named pipes

- tcp/ip

- via

- shared memory was enabled

is this a problem. because in the "how to verify installation of sql server" is written, that tcp/ip has to be enabled. however i can manually enable it.

i can`t start the sql server integration services manually. so what can i do? i also tried reinstall sql server but i do get the same error.

hope somebody can help me!

Hi,

be sure to apply the post hotfixes, that fixes the issue around the SP1 and SSIS issue:

http://www.sqlserver2005.de/sqlserver2005/MyBlog/tabid/56/EntryID/7/Default.aspx

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

Friday, February 24, 2012

Installation hangs for MSDE2000A on XP SP1

I'm trying to install MSDE2000A on XP SP1. I issue the command:
setup /SAPWD="mypassword" /L*v C:\MSDERelA\setup.log
The installation progresses for a couple of minutes and then hangs. The
last entry in the log is:
MSI (s) (DC:34) [06:37:29:140]: Executing op:
ActionStart(Name=InstallSqlRedis.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
MSI (s) (DC:34) [06:37:29:140]: Executing op:
CustomActionSchedule(Action=InstallSqlRedis.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSqlRedis,)
MSI (s) (DC:2C) [06:37:29:156]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI66A.tmp, Entrypoint: InstallSqlRedis
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\joe\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\joe\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
If I cancel the setup, it rolls back from this point.
I noted the information at:
http://support.microsoft.com/default...b;EN-US;841061
But this really deals with running the setup from an application, not from
the Microsoft supplied installer at a command line. Anyway, I tried this as
well and wrote a small application to run the installation as shown in the
KB. No change in behavior, the end-result is the same and the last log is
the same one.
BTW, I meant to say this is XP SP2, not SP1...
Sorry
|||hi,
jwh20 wrote:
> I'm trying to install MSDE2000A on XP SP1. I issue the command:
> setup /SAPWD="mypassword" /L*v C:\MSDERelA\setup.log
> The installation progresses for a couple of minutes and then hangs.
> The last entry in the log is:
> MSI (s) (DC:34) [06:37:29:140]: Executing op:
> ActionStart(Name=InstallSqlRedis.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
> MSI (s) (DC:34) [06:37:29:140]: Executing op:
> CustomActionSchedule(Action=InstallSqlRedis.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSqlRedis,)
> MSI (s) (DC:2C) [06:37:29:156]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI66A.tmp, Entrypoint: InstallSqlRedis
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\joe\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\joe\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlredis.exe /q:a"
>
> If I cancel the setup, it rolls back from this point.
>
please verify, using thetask manager, the setupre.exe is actually hanging...
if this is the case, kill this process... the installation should go on and
proceed with success...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply