.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Specify Instance Port Number on Command Line Install

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
Is there a way to specify which port we want our named SQL Express instance to run on during a command line install with no interaction from the user?  If not, is there a way we can change the dynamic port selected after the install without any user interaction?Nick's Programming Tips

View Complete Post

More Related Resource Links


Platform:   2 servers (clustered) with windows server 2008 x64 r2 (enterprise) Application: sql2008 x64 enterprise with SP1 (slip streamed) Problem: sql2008 new cluster install fails using the COMMAND LINE with a CONFIGURATIONFILE.INI The install starts but stops with the log file in the setup bootstrap folder  => (Detail_ComponentUpdate.txt) below. Bottom lines indicate a REBOOT is required; did a reboot on both nodes and still have the same problem. Used the following command line to launch sql2008 setup: Setup.exe /Q /SQLSVCPASSWORD="**********" /AGTSVCPASSWORD="**********" /ASSVCPASSWORD="**********" /ISSVCPASSWORD="**********" /RSSVCPASSWORD="**********" /ConfigurationFile=ConfigurationFile.ini Anyone has any success installing sql2008 using command line and command file? thanks john ------------------------------- tail end of the Detail_ComponentUpdate.txt file ----------------------------------------------- 2010-09-01 15:59:44 Slp: ------------------------------------------------------------ 2010-09-01 15:59:44 Slp: C:\SQL2008 Enterprise with SP1\x64\FixSqlRegistryKey_x64.exe exit code: 0 2010-09-01 15:59:44 Slp: Launching external tool: C:\SQL2008 Enterprise with SP1\x64\FixSqlRegistryKey_x86.exe 2010-09-01 15:59:44 Slp: ------------------------------------------------------------ 2010-09-01 15:59

Error on install : The INSTANCESHAREDWOWDIR command line value was not specified.

Hi,I'm trying to upgrade my dev pc for SQL Server 2008. I've removed all previous installations of sql server 2005, then installed Business Intelligence Studio & Management Tools.During setup (when selecting features), I received the following error : "The INSTANCESHAREDWOWDIR command line value was not specified. This value must be specified when the INSTANCESHAREDDIR value is specified."I plan to install sql server 2008 on another drive (D:\Microsoft Sql Server\).I'll try to set manually parameters (D:\Microsoft Sql Server\...) in the command-line arguments. FailAny hint from the team ?

can only connect to instance via port number

I can connect to an instance by specifying the port but not by the instance name. Becuase of this, no replication is occuring. Please see porqry and sqlcmd output below ...   d:\>portqry -n MDLEXPSV02 -p udp -e 1434 Querying target system called:  MDLEXPSV02 Attempting to resolve name to IP address... Name resolved to querying... UDP port 1434 (ms-sql-m service): LISTENING or FILTERED Sending SQL Server query to UDP port 1434... Server's response: ServerName MDLEXPSV02 InstanceName SQLEXPRESS IsClustered No Version 9.00.4035.00 tcp 1184 np \\MDLEXPSV02\pipe\MSSQL$SQLEXPRESS\sql\query      ?  ?P'   % ==== End of SQL Server query response ==== UDP port 1434 is LISTENING d:\>sqlcmd -U sa -S MDLEXPSV02\SQLEXPRESS -P sapwd HResult 0xFFFFFFFF, Level 16, State 1 SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi shing a connection to the server. When connecting to SQL Server 2005, this failu re may be caused by the fact that under the default settings SQL Server does not  allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired. d:\>sqlcmd -U sa -S MDLEXPSV02\SQLEXPRESS,1184 -P sapwd 1> exit d:\>

Driving install of standard web install project from command-line

I have a VS project (web service) for which I created a standard VS Web Setup project.  That project creates the typical setup.exe and project.msi files.  When run interactively, the setup prompts the user to select an IIS Site, a Virtual directory and the Application Pool.  I'd like to drive this setup silently from a script, passing the necessary args on the command-line such that the user isn't prompted.  I've played some with the args in an attempt to set those three prompts using properties, but without luck. Can anyone tell me if there are public properies on the MSI that would allow me to set those prompts via the command-line?    

Can't install SQL Server 2008 R2 Express Edition x64 from Command Line


I can't get R2 Express (x64) installed from the command line... x86 using this same command line works fine, just x64 is broken.

Using this:


Everytime it fails with:

2010-09-19 15:30:48 SQLEngine: : Checking Engine checkpoint 'ConfigureServiceBroker'
2010-09-19 15:30:48 Slp: --SafeSqlCommand: ALTER DATABASE tempdb SET NEW_BROKER ALTER DATABASE msdb SET NEW_BROKER
2010-09-19 15:30:48 Slp: Sco: SqlException: Message:The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Template Data\MSDBData.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Onlin

Install SQL Server 2008 x64 The INSTANCESHAREDWOWDIR command line value is not valid

My objective is to install SQL 2008 x64 on a brand new server running under Windows 2008.
VS 2008 and .NET 3.5 are installed and work fine.

I performed the following steps:

1.    Downloaded SQLFULL_X64_ENU.EXE from http://msdn.microsoft.com/en-us/bb851668.aspx
2.    Unpacked;
3.    run setup.exe as admin
4.    on SQL Server Installation Center: Installation | click "New SQL Server stand-alone"
5.    I didn't change the installation folder (grayed anyway)
6.    Followed the instructions. I selected Database Engine Services

I get the error message "The INSTANCESHAREDWOWDIR command line value is not valid".

I then tried to install with command prompt, with identical results:
For command prompt install I used the following bat file:

c:\users\public\downloads\mssql2008\setup.exe ^
-/Action=Install ^

I also tried to use setup100 (including the parameter /Timestamp) but I get the error message "the timestamp must be set before its first use".

Install SQL 2005 from command line using a INI file.


I'm new to SQL customization and I'm currently trying to do a SLQ 2005 install using an INI file.  I'm trying to accomplish two things using the INI file.

1.  Install SQL Native client on drive D:

2.  Install SQL 2005 & all components on D:

Below is the syntax string for my INI file.  When excuted, the SQL Native client is installed in

C:\PROGRAMFILES\Microsoft SQL Server\100\SDK followed by a Windows Installer error screen after the SQL checcks are ran.

Any and all assistance would be appreciated.


INSTALLSQLDIR="D:\Program Files\Microsoft SQL Server\"; "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\"; "D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\"; "D:\Program Files\Microsoft SQL Server\MSSQL.3\RS\"
INSTALLSQLSHAREDDIR="D:\Program Files\Microsoft SQL Server\90\DTS\"; "D:\Program Files\Microsoft SQL Server\90\Notification\"; "D:\Program Files\Microsoft SQL Server\90\Tools\"
INSTALLOLAPDATADIR="D:\Program Files\Microsoft SQL Server\MSSQL\OLAP\Data"

Article commenting by line number


I'm wondering what's the best way to approach an online article system that allows users to comment by clicking on the line they are commenting about? Essentially the same way Adobe Acrobat works with comments where you can click anywhere and the text is saved for that location.

I'm assuming a mix of jQuery would be the crux of the interface. The system would need to save comments so that when another user logs in, they will also see the other comments but they can´t edit them - only add their own.

Any suggestions would be great.

IIS - sharepoint/default website port number confusion



I have MOSS 2007 installed with IIS V7.

My default web site port is 80. When I created a new web application for my main sharepoint portal I also set it to 80. So obviously now the default web site port shows as stopped in IIS and it won't start.

What are the best practices. Should I change the port number for my portal to something else? I mean is it even a good idea to have sharepoint on port 80? If so, how do I go about changing the port number for my portal site?

any help appreciated.

sql command line

i have a problm about mysql command line;it is desapeared at once when i enter the password to my sql command line how is that happening?

named instance sql server 2008 install on cluster

I have a production two-node cluster with sql server 2008 sp1 cu7 running over windows server 2008 sp2. If I were to install a new named instance on this live environment, would it impair the default sql server instance functionality? I'm not referring to processor/io while the install is in progress. My question specifically is would the install process by its nature bring down the default instance. I'm pretty sure it won't, but don't see any documentation that would confirm this. thanks.

Ping IpAddress with Port number?

I am using System.Net.NetworkInformation with Ping method.   But it seems like it can only ping IPAddress. What should I need to do if I need to find out whether a port of the IPaddress is available?   Let me know. I will reward you.   Thanks

How do I obfuscate .Net IL code using command line program?

How do I obfuscate .Net IL code using command line program? I want free tool that can be deployed to obfuscate DLL generated from compiled tool?

Visual studio 2005 - Port Number is difference during run time.

Hi, When I debug(F5), the port number display in the URL is difference from the ASP.net development server. Eg: URL address port number is  - 1084, while for the Server is 1088 I have tried difference ways such as trying to set the dynamic port to false, so that I can configure my own port, but it is not able to work. I have also turned off the ESet Firewall however the port number is still difference.  Need your help in this area.. Thank you! 

Use Report Builder 3.0 with SharePoint site using a port number

We are currently working with SSRS R2 and SharePoint 2010.  SharePoint 2010 has been deployed a multitenant solution.  SharePoint and SSRS are on separate servers.  We have successfully integrated the two products but are experiencing some anomolies.  The SharePoint site we are deploying to uses a port number (e.g. http://mysharepointsvr:2222).  When you launch Report Builder from this site, it does not open connected to a Report Server.  When you try to connect to a Report Server the obvious choice is to put in http://mysharepointsvr:2222 for the Report Server service.  However, this does not work.  We are getting the following error: Connection Failed.  Unable to connect to the server that is specified in the URL, 'http://mysharepointsvr:2222'.  Make sure the server is running, the URL is correct, and you have permission to use the server. However, if we use the SharePoint address without the port number it will connect.  This does not work as the SharePoint port determines which site we are directed to for resources.  In our case, we need to be able to browse the folders on port 2222 not port 80 (default).  As far as the error above is concerned, we are able to browse to the report server (http://sql101/reportserver) and see all of the SharePoint sites.  In all cases, identical credentials are being u

How to know when a process run through the command line is finished - C#

Hi , I'm developing a web application in asp.net using  C# and running a .bat file from the command line. The .bat file runs another 3rd party software which resides in the server.Need to know whether the 3rd party software ran successfully to the end.Here is the code I used to run .bat file through the command line.bool RunBat(){            bool success= false;          try{            System.Diagnostics.Process proc = new System.Diagnostics.Process();           proc.StartInfo.WorkingDirectory = @"E:\test";                      proc .StartInfo.FileName = "ABC.bat";                               proc .Start();                     proc .Close();               success= true;          }       

Command line publish

HiI am new to DOT NET web publishing (not to software development).  We need through command line to build our site (which we already do using msbuild.exe), but the resulting files are way too many and it takes our to ftp it to the server.I am able to publish the website and reduce its size by ~90%; however, we need to do this through command line not manually using the GUI.I have read many postings but noone is clear on how to do it (and msbuild seems to no be able to do this). Can anyone provide me a link.Thank youPS. We are using Visual Studio 2010 and DOT NET4.0
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend