Silent Deployment: A Few Questions About Settings.ini File
Dec 13, 2007
I've read quite a few KB articles on deploying SQL Express silently using the command line and a .ini file. Unfortunately I still have some questions before I can make my own .ini file. This is for a local sql server.
What is the INSTANCENAME attribute meant to be? If it is different from the server installed on my local machine which I have coded the application on, would it be an issue?
What should USERNAME/SQLACCOUNT and SQLPASSWORD be? I can't remember having to setup these for the local database so I can't imagine what it's meant to be set as.
What is the PIDKEY?Thank you in advance.
View 1 Replies
ADVERTISEMENT
Jul 20, 2005
I'm going to write an application for a friend's business using VS .NET andSQL Server 2000. I'm confused though as to how I can write everything on mylaptop, then copy to their server. I have an MSDN subscription and did notrealize that I cannot install the Enterprise Edition of SQL Server on XPPro. I can install the development edition, but am I then going to run intoproblems trying to copy it over to their server?My experience lies in Informix / DB2 and Java / JDBC, so this is newterritory for me and I appreciate the help.Derrick Lathem
View 2 Replies
View Related
Apr 14, 2008
I'm slowing coming up to speed on configurations and deployment.
I have 2 questions for this thread.
Question 1:
When I create the deployment manifest (the file that gets created when I build) and then run it on the destination machine, there's a step in the wizard that asks for a folder location. The exact page on the wizard is called "Select Installation Folder", just to make it clear what I'm talking about.
What significance does this folder have? I noticed that when I was using the XML config option, the config file appeared there (and nothing else). When I use the SQL Server config option, I didnt see anything going into that folder. Are these the expected results in each case?
The description on that wizard page says, "The installer will install the SSIS package dependencies in the following folder." I'm not sure what this means and if I should expect more than the XML config file to appear in there (in the case when I used XLM config option). What are the "dependencies", other than the config file, that the wizard is saying that the folder will have?
Question 2:
I've been playing with deployment and there's a bunch of "play" packages that are on my test server. How do I clean these up?
View 10 Replies
View Related
Jun 29, 2006
I've been doing some VB6 app development against a SqlExpress database, but have confusion with issues of deployment and configuration. It's my intention to distribute the app and db to client installations, both as stand-alone and network-ready shared access. Here's basically what's occurred thus far:
The database originated as an Access mdb file.
Downloaded and installed SqlExpress, Tools, Manager, and sample database(s).
Used the Upsizing Wizard in Access to create a SqlExpress db.
Attached to the database in Express Manager so I could examine and access the table data.
Hit the data through the application with the following connection string:
Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=.sqlexpress; AttachDBFileName=(MyDataPathAndFileNameHere)
Been developing against this db ever since.
Now, some points of my confusion thus far with regard to deployment:
1. Named Instance and User Instance. I assume I'm using a Named instance with the preceding connection string. Honestly, I don't recall doing any kind of adminstative setup/configuration of the db except attaching to it in Express Manager, so I'm confused over why I would need a User Instance for a local copy of the database. Are there setup steps I've missed or did the Upsizing Wizard do them for me? I've read the white paper on user instance usage, but it raises as many questions to me as it answers. I do understand User instance is intended for local copy of the db, even though I'm not using it that way in development.
2. Do I distribute both the MDF and LDF files? I saw mention somewhere not to distribute the LDF log file, but the app doesn't work without it being there.
3. What has to be done for deployment to a server for shared acccess. Aside from installing SqlExpress, and possibly Manager, I'll need to configure for remote connection usage using Configuration Manager or Surface Area Configuation tools. Does this need an administrator to create and establish users accounts, rights, and such?
4. Are there any reference books out on this stuff yet, besides books online, which I don't find satisfactory.
5. Can SqlExpress coexist on Sql 2000 server? I realize SqlExpress is essentially Sql 2005, but our existing server is Sql 2000. Should it go on a different server?
Sorry for the myriad of newbie questions, but I'm a programmer and not a db admin.
TIA,
Rick
View 6 Replies
View Related
Aug 15, 2007
Hi,
Please can you let me know which of the following 2 is a better method to deploy SSIS packages
File System deplyment OR SQL Server deployment
What are the advantages of one over the other?
Thanks,
Mrinali
View 4 Replies
View Related
Dec 7, 2007
Hi All
Well I have some queries as a newbie to SRSS 2000 reports deployment.
1) I have to build a VB .NET application with a web interface to display reports in that program. Is it possible? Is there any example codeing floating around which I can take a look? Or how to do it?
2) I have to pass the parameters for the report via a VB text box into the report and the report should be displayed. So the parameter bar in the report as it comes in IE7 should not come. How can I do that?
Or in simpler terms
- How to turn the SQL 2000 reporting features off to allow a
simpler report display
- How to display the report in a Microsoft Windows Form
application.
Hope I have made myself clear.
Thanks
View 4 Replies
View Related
Sep 21, 2006
Hello All,
I experienced a weird error while deploying my SSIS package. After running the manifest file, i noticed that one of the configuration file's path was not updated in the dtsx file. My solution has 8 packages and almost every package has 2 configuration files. Except 1 file every other config file's path is being updated. Has anybody experieced such a problem?
Thank you in advance for your help
Sumesh
View 1 Replies
View Related
Dec 4, 2005
I'm having some problems with SQL Server 2005. I installed the Personal Starter kit but don't have the Express edition installed so I attached the .mdf file to SQL Server 2005. That's ok and I also changed the connection string to integrated security.<add name="Personal" connectionString="Data Source=MyTestServer;Initial Catalog=Personal;Integrated Security=True" providerName="System.Data.SqlClient"/>I tried setting the security settings in the Management studio under Security | Logins | BUILTINAdministrators where I select the User mapping and check the checkbox before the Personal.mdf file. But this doesn't seem to do the trick. How can I set the correct security settings?
View 2 Replies
View Related
Aug 10, 2006
Suppose 2 environments on a single machine.
Each environment has different configuration settings....different
databases etc.
All the packages in the first environment have a hardcoded config files
referencing the local drive.
In order to create the second environment do I have to
go into each package and manually change the location of the
hardcoded config files. If I don't it will it not use the config files
from the first environment.
Thanks
View 1 Replies
View Related
Aug 7, 2006
I have packages with the execute process task. I have included the exe-file from path A using add->existing item to the SSIS-project so that it lies under miscellaneous files. Deploying these packages using the deployment utility the file gets in the deployment folder that I copy to the server. Running the package installer and installing to SQL Server all files get copied to the B path (dtspackages under sql server by default). Trying to run the package however results in complaints about the file not being at location A. I thus changed the path in the execute process task to a relative one and then I get a complaint that the file "is not in path". So how do I do to make sure it finds the executable at location B where it actually is? I thought the deployment utility would handle this on it's own?
View 1 Replies
View Related
Jul 25, 2006
Hallo,
i created a solution that is working fine in development. I would now like to deploy it on an other server.
We have choosen for a file system -based deployment because this seems to require the least specialized SQL Server-knowledge from the user who will be utilizing this system. I changed the properties of the solution to
CreateDeploymentUtility: true
DeploymentOutputPath : binDeployment
Subsequently I build the solution and in the binDeployment-folder dtsx-files have been created.
Can anyone tell me what I need to do next to deploy them on an other machine?
Do I need to deploy a complete version of SQL SERVER 2005 Devenv included or is there a lighter installation possible that only contains what I need to run the packages?
Can I shedule the packages to run at a specified moment without DTultil coming up?
When you once found an answer to these many questions i would be most gratefull if you woulkd let me know.
Kind regards,
Paul
View 4 Replies
View Related
Sep 13, 2007
Hello All,
I had VS2005 in my machine and was working with a mobile device using Sql Server CE. While compiling and deploying device application to my mobile device it used to deploy the Sql Server CE cab files also.
But now i have migrated to another machine ( Vista OS ) and installed VS2005 newly etc., Now when i try out the deployment of device application to my mobile device it is not deploying the Sql Server CE cab files but just copies the SqlServerCe dll file.
So when my application launches in the mobile device i get an error can't PInvoke sqlceme30.dll etc.,
I know that i can manually copy the cab files to my device and work. Its little tedious. Can anyone tell me how to achieve the behavior of my old VS2005 wherein it automatically deploys the SqlServer CE cab files? Is there a setting in VS2005 to enable this. I read in one of the posts that we can go modify the option Tools->Options->Smart device and enable an option to deploy the latest updates etc., But i couldn't find such an option in my VS2005.
P.S: I have installed my SqlServer Mobile edition 3.0 SDK to the default path under program files. Should i install it under VS2005 smartdevices SDK or something like that? I tried that also but still no success.
View 2 Replies
View Related
Nov 10, 2006
Hello
I am using XML config file to store the values e.g. Server name.... it runs fine with BIDS (Development enviroment)... but when I deploy and run it to test that XML config files values are being read by e.g. giving the wrong server name, it runs fine (may be retrieving some old values). then I come bak and test it again in the development enviroment to test, it fails ( as it supposed to be caz server name is wrong in config file)
can ne one tell me wr is the problem?
ur help and support is appreciated
regards,
Anas
View 1 Replies
View Related
Jan 18, 2008
Trying to build a deployment package. I have a number of dtsx in a project that share a connection config file. When I build, the error states: 'Could not copy file "whatever.dtsconfig" to the deployment utility output directory. ... The file already exists'
What am I doing wrong?
View 7 Replies
View Related
Nov 15, 2007
Hello,
I was hoping that someone may be able to help me with an issue that I am having while trying to deploy my projects using MSI. Here is what I am trying to do.
I have two programs that are using MS SQL CE to share information. The first program is a windows service. The second program is a windows application that I am using mainly as a UI for the service. Each program has a seperate MSI setup program. I am using windows vista and VS 2005 on my developement machine.
The issue that I am having is when I deploy the programs. The windows service is working fine. It reads and writes to the database as expected. I know this because when I debug the UI program through VS 2005, I can read and write from the common SQL CE database with no issues. I am also pretty confident in the MSI program for the UI program because if I install the UI program on the developement computer and run the UI program as administrator it runs fine.
The issue arises when I simply open the UI program or when I try to run the UI program on a windows xp sp2 machine. I am no longer able to access the database file. I have tried many diffent things, but so far with no luck. Most of the attempts to fix this so far have been concerning the location of the database file these have had little or no effect. Again if I open the UI program using the right click option of 'Run as Administrator' in windows vista, the problem disappears.
Thanks in advance for any help. Even a push in the right direction would be helpful at this point. I will keep working on this issue, if I find a solution myself I will repost it here.
View 3 Replies
View Related
Oct 22, 2006
does email task only work with sql server deployment? I have an email task in my ssis package and i want go for file system deployment.
thanks,
kushpaw
View 1 Replies
View Related
Sep 12, 2006
My parent package calls packages stored in the file system. While developing, I would like to call packages in the project bin directory. In production, I would like to call packages in a different development. Is this possible?
I can change the package connection string with an expression that refers to user variables PackageLocation1 or PackageLocation2. I would like to do this automatically. Is this something that should be done at deployment time? Or is there a run time value that I can check and conditionally use PackageLocation1 or PackageLocation2?
Development and deployment is done on the same server, so the same enivronment variable value would be used in an indirect configuration. Same thing applies to a file configuration.
Another question: Is it possible to set up a different Installation Folder for use during deployment? Every time I deploy, I have to navigate the folders, you can't even paste in the folder name.
View 4 Replies
View Related
Sep 9, 2015
I have a doubt in file system deployment in ssis. I read msdn articles like "MsDtsSrvr.ini.xml" will decide the default folder for ssis packages those are deployed to "File System".Â
I have installed SQL server 2012 of 64 bit in my system. My "MsDtsSrvr.ini.xml" file was reside in the path"C:Program FilesMicrosoft SQL Server110DTSBinn". This means when we try to deploy my packages to File System default path should come like "C:Program FilesMicrosoft SQL Server110DTSPackages".Â
But in my case path was coming like "C:Program Files (x86)Microsoft SQL Server100DTSPackages" even though my "MsDtsSrvr.ini.xml" reside in "C:Program FilesMicrosoft SQL Server110DTSBinn". i can't able to see my packages in SSMS when i connected to integration services.
View 2 Replies
View Related
Jul 10, 2007
Hi:
I am trying to utilize DTUtil command to automate deployment of SSIS Package from the Build Server to Dev Server. I am getting an invalid option error, when I try to run the following command:
dtutil /FILE C:Program FilesABCABC ABC CADETL PackagesLoad_Staging_FromWCF.dtsx /MOVE FILE;\serverAC$Program FilesABCABC ABC CADETL PackagesLoad_Staging_FromWCF.dtsx /QUIET
Currently I have a .CMD file, in which I have the above command, and I am trying to run the CMD file and it returns an error. Can someone help me the DTUtil switches. My goal is to move a DTSX file from Server A(Build Server) to Server B(Dev Server). Also is there a switch to specify the server name, if UNC path is not supported. Also I am using File System Deployment, and running the file as an Administrator. I have admin privs on both Build and Dev Server. Thanks and I appreciate some help on this.
View 3 Replies
View Related
Jan 22, 2007
Hi,
We are trying to create a deployment utility for a solution. The issue we are facing is, we are using a single package configuration file and when we try to build the solution to create the deployment utility, the build process fails saying that the package configuration file already exists. THe reason for this is while trying to build, the utility copies the configation fiel for the packages, it copies for one, but for the second onward, when it tries to copies, it fails saying the file already exists.
Any idea how to overcome this, or else any suggestions how to perform the similar steps to create a deployment utility for a solution in which the packages share a single package configuration file.
Any suggestion would be really appreciated.
Thanks in Advance,
Manish Singh
View 5 Replies
View Related
Jun 4, 2008
Not sure this is the correct forum, but I'll give it a go. I am in the process of deploying a series of databases from a development environment to a production environment. I've done some searching around best practices, but haven't found anything specifically calls out what is best. I am looking to find out the best approach for moving the code/tables/views/SP's, well everything from my dev environment to the production environment. Due to the complexity and large number of objects to be created, would a backup/restore to the production server be more prudent than creating a batch file type thing that creates all the objects through a series of scripts?
View 3 Replies
View Related
Nov 3, 2015
We deployed the ssis package to SQL server and now trying to configure but it only allow use to change environmental variables there is no option to browse and select XML configuration file. Does this mean when you  are using SQL server deployment mode u can only use environmental variable ?
View 3 Replies
View Related
May 16, 2008
We are setting up a new box and when we deploy the cube we are getting the error "File system error: The following error occured during a file operation: Access is denied. ."
We are part of an AD group that is a member of the administrators group on the box, and it looks like we have rights to the data directory where AS deploys cube data to. The account that AS service runs as is also an administrator on the box. It is a domain account. The cube does have one assembly - might that be the problem? We have set up a few boxes in the past without problems - we didn't have control over how this box was setup, so obviously we are missing a permission. If anyone has any insights / ideas, I'm all ears.
Thanks!
John
View 4 Replies
View Related
Sep 28, 2005
I am getting following error when "CreateDeploymentUtility" is set to true and I try building the solution. It tries to copy a file that already exits in inDeployment folder. I am using Sept. CTP.
View 4 Replies
View Related
Jul 23, 2005
Hi All,I have several questions about checking backup file :a. When SQL Server receive a command :BACKUP DATABASE test to DISK = '\pc1etdbBTEST',does it verify BTEST file before ending the job ?b. Is there any special command for checking / verifyinga backup file ?c. If I send a restore command using a file infectedby a virus, what action will SQL Server take ?Thanks in advanceJohn S*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Mar 21, 2007
Hi,
I have a FOREACHLOOP container that contains an EXECUTE SQL TASK. The EXECUTE SQL TASK is executing a list of stored procedures from a table. This part is working.
However, I now need to send the output of each stored stored procedure to a flat file.
I dropped a DATA FLOW task inside the FOREACHLOOP container, and then created an OLEDB source and FLAT FILE destination on the Data Flow tab.
However, I'm not sure how this is going to work. When I click on the OLEDB source, Connection Manager, I thought I should select the Data Access Mode as SQL Command from variable. Then select the variable name.
But I get this error when I try to save:
Error at Data Flow Task [OLE DB Source [42]]:SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E0C
An OLE DB Recored is available. Source: blah
"Command text was not set for the command object"
What to do??
Thanks
View 5 Replies
View Related
Sep 13, 2007
Could someone tell me what a silent inatallation is please?
Many thanks
View 2 Replies
View Related
May 22, 2006
Hello,
The need is to redistribute and install SQL Express in the silent mode. Looks like the current license does not allow to redistribute SQL Express in a way other than self-unpacking archive (we need sqlexpr_adv.exe). It seems that the way to do it is:
1. Unpack this archive in the silent mode to the default temp directory, without any dialogs popping up.
2. Proceed with the installation of the unpacked files in the silent mode.
No prob with 2), but we don€™t really know how to deal with 1).
Is there any way to get a full list of command-line parameters for sqlexpr_adv.exe, including the parameter for the silent unpacking?
Thanks,
Alexander.
View 6 Replies
View Related
Dec 7, 2006
Hi:
Is it possible to install a 64 bit SQL Server 2005 silently?. I am wondering what are the command options that are needed to do a quiet Install of Enterprise Edition of SQL Server 2005 (x64) on a x64 OS.
Any info is appreciated.
Thanks
Ankith
View 1 Replies
View Related
May 29, 2007
I have a desktop application in which I use Sql Server CE.
It all works well on my development machine.
It also works on other machines if I copy the sql dll files in the same path as the .exe
I'm trying to avoid all kinds of user interaction. They don't need to know that I'm about to install Sql Server CE really
So I'm hoping to avoid writing in the manual that the user should install SQLServerCE31-EN.msi, which I think is the correct install package.
So my question is: How do you silently/unattended install Sql Server CE on the desktop?
View 1 Replies
View Related
Mar 14, 2006
I am writing an application that requires SQL Express to be installed alongside.
So I try to do the following - Before installing my application, I pop-up a link which leads to "SQLEXPR.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLServer <other parameters> /qb " .
But this displays only a basic GUI, which means that the pre-requisite checks for SQL express are not displayed to the user. So if MDAC version 2.8 is not present on the system the installation of SQLexpress fails without any error messages (except in the log files).
( This is not a problem with all pre-requisites :: If .NET is not present on the system, the failure is much more elegant. There is a nice GUI pop-up which requests the user to install .NET 2.0 before installing SQL express.)
On the other hand, If I remove the "/qb" switch, I can get the pre-requisites GUI to display and the end-user can figure out the cause of failure easily enough. But this means that the optional parameters I use, for example the instancename or the authentication mode will not be used during the install
Is there a good commandline switch I can use so that
1) The pre-requisites check screen is displayed
2) All the commandline options are used for installation.
Thanks
View 5 Replies
View Related
Apr 16, 2007
Hi There,
My ASP.Net application needs AJAX and SQL Server to be installed on the server.
How can I make AJAX and SQL Server installation as a part of my application installation?
Is it possible to automate the install of SQL Server? So user dont need to write in anything, all the answers will be prewritten.
I heard, using Microsoft Setup manager we can generate Setup.iss files to automate the silent install of SQL Server. But I cant find information about how to implement and where can I find this tool.
My main motive is to save my client from installation questions of SQL Server.
One version of my application uses SQL Server 2005 Express and another one uses Standard version.
Please help and guide me.
View 3 Replies
View Related
Aug 21, 2007
Hi..
i am new to vbscripting.i need to create the vbscript for
( .netframework2.0,MDAC2.7,XML4.0,VC++2005,windowsinstaller3.0,OWC10)
with silent installation via VBscript.before that i need to check the
machine have my pre-requisites or not,which machine does not have my
pre-requisites through script i have to install.
Kindly provide any solution for this.you can reach me at
senthil...@tcs.com.
thanks,
N.senthil
View 1 Replies
View Related
