Unattended Installation Woes

Feb 14, 2006

Hi,

I have tried to do a new SQL 2005 install via an unattended install script. I have tried both a modified version of the template.ini and just from the command line.

The installation starts and successfully installs some of the components I have selected through the ADDLOCAL option. Unfortunately it then reports an execution error and exits.

The errors I find in the install log files are as follows...

SQLSetup..._Core.log:

Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1603
Aborting queue processing as nested installer has completed
Message pump returning: 1603

SQLSetup..._Core(Local).log

Running: InstallToolsAction.10 at: 2006/1/14 14:58:11
Error: Action "InstallToolsAction.10" threw an exception during execution. Error information reported during run:
Target collection includes the local machine.
Fatal Exception caught while installing package: "10"
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: sqlchainingsqlprereqpackagemutator.cpp
Compiler Timestamp: Tue Aug 9 01:14:20 2005
Function Name: sqls::SqlPreReqPackageMutator::modifyRequest
Source Line Number: 196

---- Context -----------------------------------------------
sqls::InstallPackageAction::perform

WinException caught while installing package. : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

Source File Name: packageengineinstallpackageaction.cpp
Compiler Timestamp: Fri Jul 1 01:28:25 2005
Function Name: sqls::InstallPackageAction::perform
Source Line Number: 167

---- Context -----------------------------------------------
sqls::InstallPackageAction::perform

Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework 2.0.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework 2.0 LangPack.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework Upgrade Advisor.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework Upgrade Advisor LangPack.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework Windows Installer.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_Server_.NET Framework Windows Installer LangPack.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2006/1/14 14:58:39
Message pump returning: 1603


The files reported as failing to be added to the .cab file do not exist, although .Net 2.0 was successfully installed. All other log files do not seem to contain errors.

When calling the install from the command line I am running the following

setup /qb ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,SQL_DTS,Client_Components,Connectivity,SQL_Tools90,SDK,SQLXML,SQL_WarehouseDevWorkbench,Tools_Legacy,SQL_Documentation,SQL_BooksOnline INSTALLSQLDIR="D:NTAppsMicrosoft SQL Server" INSTALLSQLSHAREDDIR="D:NTAppsMicrosoft SQL Server" INSTALLSQLDATADIR="F:Data" INSTANCENAME=MSSQLSERVER SQLBROWSERACCOUNT="DomainSQL" SQLBROWSERPASSWORD="******" SQLACCOUNT="DomainSQL" SQLPASSWORD=="******" AGTACCOUNT="DomainSQL" AGTPASSWORD="******" SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 AGTAUTOSTART=1 SECURITYMODE=SQL SAPWD="*******" SQLCOLLATION=SQL_Latin1_General_Cp1_CI_AI

Note: I've changed the usernames and passwords

Any ideas anyone?

View 7 Replies


ADVERTISEMENT

Unattended SQL Installation

Apr 27, 2004

Does anybody know of any good links

Cheers

View 2 Replies View Related

Unattended INstallation OF SQL SERVER

Nov 28, 2007

Hi guys i am trying to install 2005 SQL server(enterprise) on 80-100 servers, mostly with default instances and some with named instances( may be 30 of htem) on 2003 Windpws enterprise platform. i wanted to unattended installation and also if all the configurations are the same, can i install on all servers at time.

Some pros and cons are appreciated and also if you got better scripts please do share it,
Thanks
Derek

View 3 Replies View Related

Problem With Unattended Installation

Aug 16, 2007



Hello,

I have a problem with an unattended installation of the SQL Server 2005. I am trying to convert a manual-installation to unattended but am stuck with the service accounts. According to the manual I have to install the server using the built-in system account without customization for each service account.

Installation takes place on a machine with German Windows XP Professional Service Pack 2. It stopped the installation with a message telling me to specify sqlaccount, rsaccount, etc.

I did this and still get an error. According to http://msdn2.microsoft.com/en-us/library/ms144259.aspx I tried NT AuthoritySystem and Nt Authority, but I can't get the unattended install to work.

The manual installation works fine on this system so I think it must be a problem with the parameters I'm using.

Best Regards

Dominik Brosent

View 3 Replies View Related

Unattended SQL 7 Service Pack 3 Installation

Nov 1, 2001

I need to install the above to various PC's in our company. Has anyone done this before and could they give share any advice please.

Thanks in advance..

View 1 Replies View Related

SQL 2005 Server Unattended Installation

Sep 22, 2006

Hey guys -
I am busy testing SQL 2005 Server Unattended installations and have a quick question. Microsoft specifies the following code for command line installation:

Start /wait <CD or DVD Drive>serverssetup.exe /qb INSTANCENAME=<InstanceName> ADDLOCAL=All PIDKEY=<pidkey value with no "-"> SAPWD=<StrongPassword>

SQLACCOUNT=<domainuser>
SQLPASSWORD=<DomainUserPassword>
AGTACCOUNT=<domainuser>
AGTPASSWORD=<DomainUserPassword> SQLBROWSERACCOUNT=<domainuser>
SQLBROWSERPASSWORD=<DomainUserPassword>

Here is a link to the installation pages: Click Here (http://msdn2.microsoft.com/en-us/library/ms144259.aspx)
My question is what are all the different accounts for?
Any help will be appreciated.
Thanks
Reghardt

View 1 Replies View Related

Unattended Installation Of SQL 2000 Fails

Mar 23, 2004

We're trying to use the unattended installation method for installing SQL 2000 on Windows 2000 servers. I've installed it (through terminal server) on two machines successfully, and two machines unsuccessfully. On the unsuccessful machines, it fails with no errors, and no SQL files are installed (bombs out almost immediately).

Anyone else had this problem? Could it possibly be a hardware issue?

View 8 Replies View Related

More Installation Woes

Apr 19, 2006

We have releases a shrink wrapped winforms application that uses SQL Express as its backend. The product has a fairly large take up, and consequently it is being installed on a large numbre of different machines and configurations. We seem to be having quite a common problem with the installation of SQL Express, we launch the installation from our own installation package with the following command line



SQLEXPR.EXE /qb ADDLOCAL=ALL SQLAUTOSTART=1 INSTANCENAME="OURInstanceName" SQLCOLLATION="Latin1_General_BIN"

We are seeing time after time that the install fails with the message "The SQL Server service failed to start."

Summary.txt points to

SQLSetupNNNN_COMPUTERNAME_SQL.log

and this in turn looks like this

<snipped>

PerfTime Start: Do_sqlScript : Mon Apr 10 14:06:07 2006
Service MSSQL$OURINSTANCENAME with parameters '-m SqlSetup -Q -qLatin1_General_BIN -T4022 -T3659 -T3610 -T4010' is being started at Mon Apr 10 14:06:07 2006
Service failed unexpectedly (1067)
Error Code: 0x8007042b (1067)
Windows Error Text: The process terminated unexpectedly.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: sqls::Service::Start
Source Line Number: 301


</snipped>



The ERRORLOG looks something like this



2006-04-10 13:55:47.07 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2006-04-10 13:55:47.07 Server (c) 2005 Microsoft Corporation.
2006-04-10 13:55:47.07 Server All rights reserved.
2006-04-10 13:55:47.07 Server Server process ID is 1732.
2006-04-10 13:55:47.07 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2006-04-10 13:55:47.07 Server Registry startup parameters:
2006-04-10 13:55:47.07 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2006-04-10 13:55:47.07 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2006-04-10 13:55:47.07 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2006-04-10 13:55:47.07 Server Command Line Startup Parameters:
2006-04-10 13:55:47.07 Server -m SqlSetup
2006-04-10 13:55:47.07 Server SqlSetup
2006-04-10 13:55:47.07 Server -Q
2006-04-10 13:55:47.07 Server -q Latin1_General_BIN
2006-04-10 13:55:47.07 Server -T 4022
2006-04-10 13:55:47.07 Server -T 3659
2006-04-10 13:55:47.07 Server -T 3610
2006-04-10 13:55:47.07 Server -T 4010
2006-04-10 13:55:47.08 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-04-10 13:55:47.08 Server Detected 2 CPUs. This is an informational message; no user action is required.
2006-04-10 13:55:47.24 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-04-10 13:55:47.26 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-04-10 13:55:47.27 spid5s Warning ******************
2006-04-10 13:55:47.27 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.
2006-04-10 13:55:47.27 spid5s Starting up database 'master'.
2006-04-10 13:55:47.36 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2006-04-10 13:55:47.49 spid5s SQL Trace ID 1 was started by login "sa".
2006-04-10 13:55:47.54 spid5s Starting up database 'mssqlsystemresource'.
2006-04-10 13:55:47.76 spid5s Error: 15209, Severity: 16, State: 1.
2006-04-10 13:55:47.76 spid5s An error occurred during encryption.
2006-04-10 13:55:47.76 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.



I can't quite understand what the problem is, has anybody got an idea?



Thanks

View 14 Replies View Related

SQL Server 2005 SP1 Installation Woes!

Jun 15, 2006

I am having problems installing SP1 successfully. So far I've tried it on two separate Windows 2003 server boxes running SQL Server 2005 Standard v9.0.1399.

The first upgraded successfully all over services except the SQL server itself. Reporting services then failed due to database version mismatch but that was easily fixed. The other box doesn't have anything other than SQL2005 and components were upgraded but the database upgrade failed. I got the generic "send this error to microsoft" message.



I've tried other suggested fixes on this board but none have worked so far.

The Logfile seems to go haywire at about this point:

Property(S): REINSTALLMODE = omus
Property(S): Privileged = 1
Property(S): RedirectedDllSupport = 2
Property(S): REINSTALL = All
Property(S): PATCH = \TESTC$SP1HotFixSQLFilessqlrun_sql.msp
Property(S): MsiWin32AssemblySupport = 5.2.3790.1830
Property(S): MsiNetAssemblySupport = 2.0.50727.42
Property(S): Date = 6/15/2006
Property(S): ProductToBeRegistered = 1
Property(S): Time = 13:52:47
Property(S): ProductState = 5
Property(S): TTCSupport = 1
Property(S): TRANSFORMS = :SqlRun01.mst;:InstID01.mst;:InstName01.mst
Property(S): ColorBits = 32
Property(S): TextHeight = 16
Property(S): PackageCode = {3185FC73-41E0-43F4-97DF-2254C4D7C667}
Property(S): BorderSide = 1
Property(S): BorderTop = 1
Property(S): CaptionHeight = 19
Property(S): ScreenY = 1024
Property(S): ScreenX = 1280
Property(S): SystemLanguageID = 1033
Property(S): SQL200532Hotfix2047 = \TESTC$SP1HotFixSQLFilessqlrun_sql.msp
Property(S): BrowseAuto.2FC2D269_8625_4826_BB3F_F9059090CB38 = 0
MSI (s) (C4:30) [13:52:47:807]: Note: 1: 1729
MSI (s) (C4:30) [13:52:47:807]: Transforming table Error.

MSI (s) (C4:30) [13:52:47:807]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (C4:30) [13:52:47:807]: Transforming table Error.

MSI (s) (C4:30) [13:52:47:807]: Transforming table Error.

MSI (s) (C4:30) [13:52:47:807]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (C4:30) [13:52:47:807]: Transforming table Error.

MSI (s) (C4:30) [13:52:47:807]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (C4:30) [13:52:47:807]: Transforming table Error.

MSI (s) (C4:30) [13:52:47:807]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (C4:30) [13:52:47:807]: Transforming table Error.

MSI (s) (C4:30) [13:52:47:807]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (C4:30) [13:52:47:807]: Transforming table Error.

MSI (s) (C4:30) [13:52:47:807]: Transforming table Error.

MSI (s) (C4:30) [13:52:47:807]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (C4:30) [13:52:47:807]: Transforming table Error.

MSI (s) (C4:30) [13:52:47:807]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (C4:30) [13:52:47:807]: Transforming table Error.

MSI (s) (C4:30) [13:52:47:807]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (C4:30) [13:52:47:807]: Product: Microsoft SQL Server 2005 -- Configuration failed.

MSI (s) (C4:30) [13:52:47:807]: Attempting to delete file C:WINDOWSInstaller6770f.msp
MSI (s) (C4:30) [13:52:47:807]: Unable to delete the file. LastError = 32
MSI (s) (C4:30) [13:52:47:839]: Cleaning up uninstalled install packages, if any exist
MSI (s) (C4:30) [13:52:47:839]: MainEngineThread is returning 1602
MSI (s) (C4:08) [13:52:47:839]: Destroying RemoteAPI object.
MSI (s) (C4:B0) [13:52:47:839]: Custom Action Manager thread ending.
=== Logging stopped: 6/15/2006 13:52:47 ===
MSI (c) (D4:90) [13:52:47:854]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (D4:90) [13:52:47:854]: MainEngineThread is returning 1602
=== Verbose logging stopped: 6/15/2006 13:52:47 ===



Help!

View 5 Replies View Related

Silent - Unattended Setup - Getting Informed About Running Installation Progress Status.

Apr 10, 2007

I 'm trying to install Sql Server 2005 Express Edition using c# 2.0 by starting a process and launching setup. I also want to informed about installation progress. For instance i want to inform end user if any installation error return or if setup has successfully completed etc. I think i need a callback... I have no problem about silent - unattended install but how can i informed about running installation progress ? and send these info to end user 's form ?

Regards.

Yusuf Incekara

View 5 Replies View Related

SQL Server 2005 Installation Woes For Workstation Components And Client Tools

Apr 27, 2008


Hello,

I have installed successfully Microsoft SQL server 2005 in MSCS.

However the set up did not install Workstation components (client tools - SSMS etc).

I have successfully installed workstation components in one node of cluster.

However setup is giving following error while installing workstation components on other node. (From this node MS SQL server 2005 was installed).

Product: Microsoft SQL Server 2005 Tools -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup

There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.

I did "C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, /setup".

It executed but no error, no output.

Any gues, help in isolating issue?

Any more information required.(Media is ok. Setup has been tried after reboot. There is enough disk space.)

Regards.

Mahesh
===========
Setup

1) Microsoft Cluster of two nodes.
2) Hardare - HP Blade servers
3) OS - Windows 2003 EE with SP2
4) SQL Server 2005 Standard Edition with SP2.

=============================

MSI (s) (B0:7C) [17:40:20:390]: Note: 1: 1722 2: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A 3: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe 4: /setup
MSI (s) (B0:7C) [17:47:23:609]: Product: Microsoft SQL Server 2005 Tools -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup


MSI (s) (B0:7C) [17:47:35:921]: Note: 1: 1729
MSI (s) (B0:7C) [17:47:35:921]: Product: Microsoft SQL Server 2005 Tools -- Configuration failed.

MSI (s) (B0:7C) [17:47:35:953]: Cleaning up uninstalled install packages, if any exist
MSI (s) (B0:7C) [17:47:35:953]: MainEngineThread is returning 1603
MSI (s) (B0:A0) [17:47:36:062]: Destroying RemoteAPI object.
MSI (s) (B0:80) [17:47:36:062]: Custom Action Manager thread ending.

View 1 Replies View Related

Unattended Upgrade To SQL 7.0

Jul 7, 1999

How can one perform upgrade to SQL 7.0 from 6.x without using the upgrade wizard? Is there any unattended upgrade option that one can exercise?

Also, if SQL 7.0 is already installed, can one do a selective upgrade of some SQL 6.5 objects? For instance, can one upgrade only the tables, views and triggers from 6.5 to a 7.0 database?

Any pointers, help, info in this regard would be greatly appreciated!

Rnathan

View 2 Replies View Related

Unattended Install WITH SP3 Using .iss

Mar 31, 2004

Using an unattended file (.iss) is there a way to incorporate the SP3 (or any) patch within an .iss file so that there is only only install that incorporates the patch?

View 1 Replies View Related

Problem With Unattended Install

Mar 23, 2007

I am trying to do an unattended install using the following commad

Setup.EXE /settings C:/setup.ini /qn

but i am getting a messaged saying

"Please go through control panel to install and configure system component"

I already have one instance of sql server installed on the server.

Please can some one help with this

View 2 Replies View Related

Cannot Set Unattended Execution Account For RS

Apr 21, 2008

We cannot set the "Unattended Execution Account" on any Sql Server 2005 Report Server. This problem occurs on new installations and existing installations of Report Server. We have several servers that have the account already set from prior install and configuration, but now it cannot be changed. No domain policy changes have been applied, only MS Patches.

All attempts to set the account using the Report Server config tools return a UnauthroizedAccessException, as shown below. I have been unable to find any documentation on the permissions required for this action. Can anybody help?



System.UnauthorizedAccessException
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetUnattendedExecutionAccount(String userName, String password)

View 1 Replies View Related

How Do I Do An Unattended Install Of MSDE 1.0 Sp4?

Jul 19, 2006

I am trying to upgrade an MSDE 1.0 db with the Service Pack 4 patch
but I need to do either a Silent or Unattended install.
Does anyone know how to do this? Does anyone know the
command-line command to do this?



I tried using...

sql70sp4.exe -a -f1 "unattend.iss"



....but that didn't work. It popped up a window asking where I
should extract the contents of the .exe (that shouldn't be appearing
either) and then after it extracted it didn't do anything else.



Any help is greatly appreciated.

View 1 Replies View Related

Unattended SQL Server 2005 Installs

Sep 10, 2007

Hello,

I have a quick question about automating installation of SQL 2005. This question doesn't relate as much to SQL 2005 as it does setting up a database server.

I know that it's usually standard practice to allow SQL to "lock pages in memory". What I am trying to do is find a command line utility that will allow me to add this step to the SQL install script. Any help is appreciated. Thank you.

View 3 Replies View Related

Unattended Install Of Client Components

Jun 20, 2006

I'm trying to do an unattended install of the client components for SLQ2005. I have read the document on doing a install from the command prompt but when I use the "ADDLOCAL" switches I get some components that I don't require. For example, I am using the following command to run the setup - "start /wait <path>setup.exe ADDLOCAL=Client_Components,SQL_Tools90,Connectivity". When I look at the Add/Remove Programs list I can see that it has installed "MSXML 6.0 Parser", "SQL 2005 Backward Compatibilty" and "Office 2003 Web Components". The only components I require are the "SQL Support Files", "SQL Server Native Client" and " CLient Tools". If I run "start /wait <path>setup.exe REMOVE=SQLXML,TOOLS_BC_DEP" it will remove "Office 2003 Web Components" and "SQL 2005 Backward Compatibilty" but not the "MSXML 6.0 Parser". How can I get rid of this?

Thanks for any help.

View 1 Replies View Related

How To Configure TCP Port For Unattended Install

Jul 24, 2006

I've looked through every source of material on SQL Server Express unattended installs that I could get my hands on, but so far, I've come up with nothing that shows how to set the server engine's TCP port to 1433.

Since the SQL Server setup is part of a (considerably) larger install, requiring the customer to set this by hand is not really acceptable.

Is there a way to do this with a command-line parameter (etc)?

Thanks in advance

Josh

View 6 Replies View Related

Connecting To SQL Express After Unattended Install

Oct 13, 2007

Good afternoon,

I have written a .NET app that kicks off an unattended install of SQL Server Express Advanced. After the install, the same app tries to connect to SQL Express adn run a script that creates a database plus a few other things.

However, the problem I am having is that my app cannot connect. I get the error:

"An error has occurrred while establishing a connection to the server. This failure may be casued by the fact that under the default settings SQL Server does not allow remote connections."

However, the unattended install goes great. No problems there. I know this because I can Open SSMS, run queries, created DB's, etc. I also know that it is not the remote connections issue because the unattended install is set to allow remote connections (both names pipes and TCP/IP).

So, why can't i connect? I don't need to reboot after the install do I? Please tell me i don't...and please tell me it is something simple I am overlooking.

Thanks...

View 3 Replies View Related

Unattended Install From Commad Line W/o IIS

Mar 6, 2008

Hello SQL Knowledgeable Crowd,

I'm trying to install SQL Server 2005 from the command line without using an .ini file and without having IIS installed. I know that I need to pass all the parmeters and I think I have them all.

My .bat file will install when IIS is installed, but I can not get it to install without IIS. The GUI gives me a warning and allows me to ignore this, but I can't figure out the switch that will do the same thing.

Can someone please point out my mistakes.

Here are my command line parameters:
(Win 2k3 x64, SQL2005 Enterprise)

"P:SoftwareMicrosoftSQL Server 200564-bitEnterpriseCD1setup.exe" /qn
INSTANCENAME="MSSQLSERVER" ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_FullText,Notification_Services,NS_Engine,NS_Client,SQL_DTS,Client_Components,Connectivity,SQL_Tools90,SDK,SQL_Documentation,SQL_BooksOnline,SQL_Samples,SQL_AdventureWorksSamples,SQL_AdventureWorksDWSamples,SQL_AnalysisServiceSamples,SQL_Samples
PIDKEY=
SAPWD="NT AUTHORITY"
SQLACCOUNT="NT AUTHORITY"
AGTACCOUNT="NT AUTHORITY"
RSACCOUNT="NT AUTHORITY"
SQLBROWSERACCOUNT="NT AUTHORITY"
SQLAUTOSTART=1
AGTAUTOSTART=1
ASAUTOSTART=1
RSAUTOSTART=1

View 2 Replies View Related

DTS Woes

Nov 26, 2001

I have a DTS setup that copies a couple of databases from one server to another in order to have a hot backup server. When I execute the DTS package from the DTS portion of the Enterprise Manager tree it runs fine. When I schedule it, it fails with the following error:

DTSRun OnStart: DTSStep_OMWCustomTasks.OMWTransferLogins_1
DTSRun OnError: DTSStep_OMWCustomTasks.OMWTransferLogins_1, Error = -2147467259 (80004005)

Error string: Unspecified error

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700

I cannot find anywhere where this error is explained or even referenced. Any help would be greatly appreciated.

View 2 Replies View Related

BCP Woes!

Mar 9, 2000

Here's the table:

Create Table{
id int
comments text}

Much of the data in the Comments field already has carriage return in it. When I use bcp out -c, it uses as a new record to figure out when the new row stats. However, the data in that column has carriage returns! Hence, when it detects the carriage return in the user data(comments) itself, it is pushing the remainder of that text to the 2nd line. Then, when I try to BCP IN, it is trying to push it into ID column!

The text file looks something like this:

ID COMMENTS
-- ---------
1 This is a very long comment with a line return now. User hits return here.
This should be part of the previous record but gets detected as a new row
2 Some Text
3 Some Text

So, in the BCP IN, it is trying to put 'This should be part of..' into the ID column and I am getting an error.

Is there any way I can get BCP to NOT recognize in user data as end of a record??

Thanks
Joyce

View 1 Replies View Related

SSL Woes

Jan 10, 2007

We've had RS running on an internal network for a while now and initially
installed it with no SSL certificate.  We recently decided that we would like
to make some reports available through the web, and that we should secure the
data with SSL.  So, we registered and set up the subdomain, bought and
installed the certificate, closed off all but port 443 on the box in
question, and opened it up to the world.  We tweaked a few options in the RS
config files (after reading around):

RSReportServer.config:
-  SecureConnectionLevel changed from 0 to 2 (recommended) - this changed
all but the help file links to https://.
-  UrlRoot changed from HTTP to HTTPS, and also changed from internal to
external name (to match the SSL certificate)

RSWebApplication.config:
- ReportServerUrl changed from HTTP to HTTPS and changed from internal to
external name.

After this was changed, along with some IIS tweaks, we were able to get to
the report manager through the web, and force SSL only.  The problem right
now is that we are intermittently getting "Underlying connection closed"
errors (described here:  http://support.microsoft.com/kb/915599). ; The odd
thing is that we first get the Windows login prompt, wait about a minute then
get the error (which is encapsulated by the Report Manager page style). 
After a quick browser refresh, the Report Manager appears almost instantly,
with no 2nd request for a windows login.

My question:  Are there any IIS or RS config settings I can look at, or any
log file entries I should look for in order to determine the cause of this
problem?  My guess at this point is the error has to do with some sort of
timeout, but to be honest, I have no clue.

Thanks in advance!

View 1 Replies View Related

Scripting Unattended Install In A Batch-file

Nov 28, 2006

Hi!

I'm trying to do the following in a batch-file:

1) Install SQLExpress unattended providing settings in an .ini-file

2) Run an osql-command which creates a database and some tables etc.

My batch-script looks like the following:

REM Install SQLExpress

start /wait .SQLExpresssetup.exe /qb /settings %CD%mysettings.ini

osql -S (local)MyExpress -U sa -P passwd -i .createdb.sql

...

The problem is that the SQLExpress setup updates the %PATH%, but the change is not visible in my cmd-context . So, the osql-command fails.

It seems like I have to start a new cmd-window from the windows shell to get the updated environment.

Is there any way to make the environment changes visible to my script?

This might be more a sort of general batch-programming topic, but any help is appreciated. :)

Regards,

Sigurd Ringbakken

View 4 Replies View Related

SQL 2005 Unattended Install TCP Port Number

Oct 19, 2007

Hi All,

I am having an issue with SQL 2005 unattended install, I cannot see where in the template.ini file you can specify the TCP port number for SQL 2005 to listen to I want to change it to a specific port number, I know you can do this in an unattended install on SQL 2000.

Also in an unattended install of SQL 2000 and 2005 is there any way you can specify the database and transaction logs location for new databases to be installed on another drive then the system databases. I know you can change this later in SQL server properties but I wanted this to be done during the install or is there a T-SQL script which can do this after?

Any help on this will be great.

Cheers

Raxso

View 3 Replies View Related

Unattended/Silent Install - Enable TCP/IP Property

Mar 15, 2007

I'm able to install SQL 2005 Express using a template.ini, and use the option DISABLENETWORKPROTOCOLS=2 in order to enable TCP/IP. However, I then manually need to open SQL Server Config Manager > SQL Network Config > Protocols for SQL > TCP/IP > "IP Addresses" tab > change all "enabled" options to "yes".

Is there an automated way to do this?

Thanks,

James

View 1 Replies View Related

Intersect Woes.

Oct 18, 2006

I want to be able to intersect many tables. I am building my query from vb code in asp .net based on key fields entered in a search engine box.my query should look like this, which will return the rows that will have the values var, var_2, var_3 in any columns.  All three must be in a row for it to be a hit.  I cant get this to work in ms sql.  I don't know if it supports this feature.select * from t where column1 Like '%var%' or column2 like '%var%' or column3 like '%var%'intersect select * from t where column1 Like '%var_2%' or column2 like '%var_2%' or column3 like '%var_2%'intersectselect * from t where column1 Like '%var_3%' or column2 like '%var_3%' or column3 like '%var_3%'  I also googled around and found a where exists... But cant seem to figure out how to do multiple tables:select * from t where exists (select * from t where column1 Like '%var_3%' or column2 like '%var_3%' or column3 like '%var_3%') i would like to add multiple conditions to the where exists table.  Could anyone please tell me what I am doing wrong.

View 2 Replies View Related

Transaction Log Woes 1/24/00

Jan 24, 2000

Taking the advise from one of the postings I removed the setting for checkpoint log
on checkpoint. I have set up a batch job that does a dbcc checktable (syslogs)
and a dump transaction with no_log every 15 minutes. We are a development
shop and do not need the transaction log, I would have liked to use the truncate
log on checkpoint. I found that the transaction log seems to grow indefinitely by
viewing DBCC sqlPerf and sp_spaceused if I do not first issue the checktable
command. Why is this needed? This is the same problem I had with the truncate log
on checkpoint option. Has anyone else encountered a similar problem? We have an
application that does single row inserts multithreaded at a rate of 2500 rows a second.
Without performing the dbcc checktable the log filled to over 80% in a 45 minute period.
Running the stored procedure with the two commands the logs stays under 40%.

View 1 Replies View Related

SQLAgentMail Woes!

Nov 10, 2004

Trying to get my jobs to send mail when job fails. Should be easy but it's giving me headache

Had a whole slew of issues. Outlook is installed with a n outlook mail profile set up that can send mail in outlook. I can create a SendMail DTS and execute it to send mail

Email works in these scenarios
1. I create a DTS package in SQL Server with just SendMail with the same Profile "ABC" and click Execute and it sends
2. I can send using Outlook with the same profile "ABC"
3. I can run DTSRun with command prompt calliing the DTS package and it sends fine

However it wont send in these 3 scenarios (where I need it!):

1. I go to Operator, and put my Profile "ABC" in the Email Name, click Test and I get this error "Error 22022: SQLServerAgent Error: The SQLSErverAgent mails ession is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLSErverAGent Properties
sQLServer Agent is running

2. If I add the DTS Package "EmailTest" to one of my jobs as a step to go to if the 1st step fails, nothing gets sent

3. In JObs -- Notificatioin, If I set the E-maill operator to my operator, nothing gets sent

I set the Mail Profile to the Mail Profile (in SQL Server AGent' properties)
However when I click Test, I get this error:
Error 0: Cannot load the DLL sqlmap70.dll, or one of the DLLs it references

I am using
SQLServer Version 8.00.194,
OS Windows 2003

Help!

View 1 Replies View Related

OpenXML Woes - 2Q's

Dec 16, 2006

Hi everybody.

I don't know if anyone can help me but I have two issues with SQL Server 2000 SP4 (version 8.00.2039 - Desktop Engine) running on W2K and W2K3. I'm also running SQLXML 3.0 (msxml2.dll version is 8.30.9530.0).

Is it me or is sp_xml_preparedocument a crippled fat dog that is blind?...not that I have anything against crippled fat dogs that are blind :)

In all the stored procs I have developed, I pass a text var as an input parameter and return an IStream to ADO (using an sqlxml provider) in COM+. All has been very well and fine...until the passed text parameter resembles a data object of any decent size.

The first error I was noticing was a "XML Parsing Error: not enough storage is available to complete this operation". Well, I thought I would debug logically in a step fashion and just prepare the doc first and then do a return and then do a return on the next segment of code to find out where the issue is. I was amazed to find that sp_xml_preparedocument is taking 7 seconds to load a simple 1MByte text input var and around three minutes to load a 7 MByte file.

I believe these long load times are causing issues with transaction timouts etc so I thought I would try to solve the speed issue with sp_xml_preparedocument and then see if the "XML Parsing Error" continues.

So, my first question is:

Should sp_xml_preparedocument take 7 seconds to load a 1MByte text variable and nearly three odd minutes to load a 7 MByte file? Surely there is something wrong somewhere?

I'm also running these tests on two machines - one is 2 GHz and the other is 2.4 GHz P4's.

Cheers and thanks for any info.

Erron

View 2 Replies View Related

WHERE Statement Woes.

May 28, 2008

SELECT T1.*
FROM Cust_Table T1
INNER JOIN
(
SELECT Family_Name
FROM Cust_Table
WHERE Cust_Name IN ('Billy', 'John')
AND RowNum < 100
GROUP BY Family_Name
HAVING COUNT(*) > 1
)
T2 ON T1.Family_Name= T2.Family_Name
WHERE RowNum < 100



( This code above finds all the familys that contain either multiple billys and/or multiple Johns and displays all the duplicates ordered by the family_name. )

The problem is that what I want it to do is search through the whole table and find within each Family (Family_ID) who has both a sibling called Billy AND John (Cust_Name) wether they have multiple johns and multiple billys I don't mind as long as they have a minimum of 1 of each. I then want to just output all those examples only not anything else. An example of the table is bellow, I hope this helps. Thanks for your advice.


BEFORE
Family_Name CUST_Name
Bruce Billy
Bruce John
Bruce Mike
Bruce Oli
Smith Billy
Smith Billy
Harold John

AFTER
Family_Name CUST_Name
Bruce Billy
Bruce John

View 4 Replies View Related

SQLMail Woes !

Jul 20, 2005

Trying to get my jobs to send mail when job fails. Should be easy butit's giving me headacheHad a whole slew of issues. Outlook is installed with a n outlookmail profile set up that can send mail in outlook. I can create aSendMail DTS and execute it to send mailEmail works in these scenarios1. I create a DTS package in SQL Server with just SendMail with thesame Profile "ABC" and click Execute and it sends2. I can send using Outlook with the same profile "ABC"3. I can run DTSRun with command prompt calliing the DTS package andit sends fineHowever it wont send in these 3 scenarios (where I need it!):1. I go to Operator, and put my Profile "ABC" in the Email Name,click Test and I get this error "Error 22022: SQLServerAgent Error:The SQLSErverAgent mails ession is not running; check the mail profileand/or the SQLServerAgent service startup account in theSQLSErverAGent PropertiessQLServer Agent is running2. If I add the DTS Package "EmailTest" to one of my jobs as a stepto go to if the 1st step fails, nothing gets sent3. In JObs -- Notificatioin, If I set the E-maill operator to myoperator, nothing gets sentI set the Mail Profile to the Mail Profile (in SQL Server AGent'properties)However when I click Test, I get this error:Error 0: Cannot load the DLL sqlmap70.dll, or one of the DLLs itreferencesI am usingSQLServer Version 8.00.194,OS Windows 2003Help!

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved