Deploying To Server And Other Questions...

Jul 13, 2007

Guys,
Let me first give you a little bit of background...

One of my goals for this year is to migrate all DTS packages to SSIS, those DTS packages are used across the company by different groups/users.

Since I'm still not that familiar with SSIS and like many here, was well used to the enterprise manager view (all DTS packages on 1 single place), I'm unsure on how to structure my SSIS packages in a way that I could break it down by group let's say.
The way that I'm doing right now is: I'm creating a solution for each group and creating the SSIS packages (.dtsx) relative to that group inside each solution, that's pretty easy. Now, the next thing that I'll have to figure out (and hope you guys can help) is how to deploy them structured this way and how to handle these packages to my end users. Basically, how do I handle "Group A" all of their SSIS packages? Will they have to open the package in debug mode on VS every time they need to execute a package?

Thoughts on this?

View 3 Replies


ADVERTISEMENT

Deploying SQL Server On To A CD

Sep 2, 2005

Hi Well this is my first post on this forum, in fact I have not even used SQL Server yet!

My question is.... I have been asked to produce an application which will be a VB6 application with an SQL Server database behind it. I would like to be able to put the application along with the database on to a CD and run them directly from the CD once it is distributed. So the question I guess is can this be done with SQL Server i.e. can a table be exported in a format which will allow it to be queried in a standalone fashion? Maybe I have not explained myself properly but I welcome any questions which will help clarify my problem.

Thanks Red

View 1 Replies View Related

Problem Deploying Site Developed With Sql Ex. To Server Running Sql Server 2005.

Apr 10, 2006

Can someone show me, or direct me, to a source,  that shows me how, and what to change,  when deploying a website from a development server running Sql Ex to a production server running Sql server 2005.  I can’t get the sites to run under Sql server 2005.
 
They work in Sql Ex. what must I change?  The connection string, to what format?  and what else?  I attached the dB to Sql 2005 and browsed the content in the Sql manager.  But can’t get the aspx pages to work on the server.
 
Help please

View 6 Replies View Related

SQL Server ---- Deploying A WebSite

Jun 25, 2007

Since from using my local host to view my website, I am assuming I already have SQL Server installed on my computer? Is it possible to have users access my website files directly onto there own computer, say if they type my ip address or domain name into their address bar?  What I am actually wanting to do is to host my website from my home computer... Any ideas, or good slash easy to understand articles on how to do this?

View 8 Replies View Related

Deploying Reports To Another Server

Oct 16, 2007



I have installed SSRS on my local machine with all default settings. Report manager and report server and reportserver data base and reportservertempDB all are in my local machine. Now I have already created few reports. but now the company wants to deploy them to the main server. Now can I do this? Do I have to chage the report configuration settings. Does it effect to my current reports?
If this is possible, can anyone tell me how to do this please?

Thanks

View 4 Replies View Related

Deploying With Sql Server Express

Mar 16, 2006

I have developed a windows mobile 5.0 application that is currently syncing with sql server 2005. I want to deploy the application with sql server express for the client. What do I need to do to make this work?

Thank you.

View 6 Replies View Related

Deploying App To 2003 Server With SQL2005

Feb 19, 2007

I devloped this app with vs2005 and SQL 2005 express, everything seems to work fine, when I deploied the app to my web server I got a few different error messages that I worked through but now stuck on this one. i am sure it is something with SQL 2005 server. is there anywhere that has a good check list for doing things right in asp and SQL deployment?
here is the error message i am getting from debugging.
The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'.
Source Error:
Line 33:             SqlConnection connection = CreateConnection();Line 34:             SqlCommand command = CreateCommand(connection, query, parameters);Line 35:             SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);Line 36: Line 37:             Type datatype = factory.GetDataType(); 
Source File: c:InetpublogplankroadApp_CodeUtilitiesSqlDatabase.cs    Line: 35

View 1 Replies View Related

Building With SQL Server, But Deploying With MSDE

Jan 28, 2004

I am building a site, I'd like to use SQL server, but once the site is finished it i for a organisation who do a lot of community voluntary work. So to keep the costs down I plan to install on their server a copy of MSDE as the datasource.

I know it is a simple question, but if I build the site using SQL server and deploy onto MSDE will the site still work?

View 1 Replies View Related

Deploying A Report To The Main Server

Oct 5, 2007



I have created several reports using SSRS which is installed in my local machine. But source data base is in the main server. Data source connection works properly. Report manager is also configured to local machine.

Now I tried to deploy these reports to main server. So I changed the target URL to http://mainservername/reportsserver in the internal report property change box. But it was not succeeded. I get a error message like this.



------ Build started: Project: Partner Reports -Internal, Configuration: Production ------

Build complete -- 0 errors, 0 warnings

------ Deploy started: Project: Partner Reports -Internal, Configuration: Production ------

Deploying to http://derby/ReportServer

Error rsRPCError : The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)

Deploy complete -- 1 errors, 0 warnings

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========


Reporting services was already installed in main server. Do I have to change settings of report configuration manager in my local machine?

View 4 Replies View Related

SQL Server Reporting From VS2005 Not Deploying

Feb 8, 2006

hi

I build a SQL Server Report using VS2005 in SQL Server 2005, Application is building with out any errors..I am able to preview the report data also

If I deply the application on http://localhost/ReportService I am getting the A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer) error.

please help me, what is the problem?

thanks

Rukku

View 4 Replies View Related

Deploying SQL Server 2005 Express

Feb 1, 2006

Hello
1.) Is there any solution for integrating the deployment of the sql server express into the setup project of my vb 2005 app ? 'Cause it is too much to install the framework... then the sql server and then the app....... Any help would be appreciated!

Thx

View 1 Replies View Related

Deploying Rdl Files In Prodcution Server

Nov 20, 2007

Hi All,



I generated and transfered reports using RSscripter. I created those reports in my local machine. Then I transfered to prodcution machine. But the problem is there is no Visual Studio in prodcution machine. So I'm wondering how to deploy those reports now. Can any one tell me how to do this please?

Thanks

View 10 Replies View Related

Deploying Reports On Production Server

May 9, 2007

hello experts,



i need help with deployment of reports (SSRS 2005). we need to deploy many reports (more then 100) on the production everytime we make changes in them.



"the problem is we cannot install visual studio on the server to open the project and use the deploy option from it" i tried using the script - PublishSampleReports.rss



but everytime i run i need to go and manully configure the report to map the shared datasource to it. any way to pass the information in the script itself, or is there any smart way to deploy on production.



/chandresh soni

View 2 Replies View Related

Problem Deploying SSIS To Another Server.

Feb 8, 2007

Hello, I am trying to deploy a SSIS package (using deployment utility create at build time) to a different server and ran into problem wonder if someone and direct me to the right path.

development environment: WIN XP, SQL 2005. package is built using server buisiness intelligence. Package content: connect to a "target"SQL2005server using OLE DB using SQL Login authentication to process data. The SQL 2005 DB is on a Win 2003 server (R2) as OS platform.

The package was built, install ( SQL not file system)and ran fine on the development environement; when attempt to deploy the package to the SQL 2005 server where data reside and should be processed (also install to SQL), I receive error " 0x80004005 ...description TCP Provider: No connection could be made because the target machine activily refuse it". which is an odd error since the package is on the server that it try to connect to the data base on it.

If anyone can give me some hint at what cause this problem, appreciate the help.

View 2 Replies View Related

Problem While Deploying Report On Server

Jul 14, 2005

Deploying to http://localhost/ReportServer
Deploying data source '/Report Project1/cnt_SDS_REQUEST'.
The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file.

View 28 Replies View Related

Deploying .Net / SQL Server 2005 Replication

Jun 15, 2006

Hi,

I am experiencing a problem with deployment of a VB .Net application which carries out merge replication, and would greatly appreciate any assistance. I am currently struggling to find stuff about my problem on the net, which probably means either (a) I'm missing something really simple or (b) I shouldn't be trying to do this in the first place. :)

The story so far:
1. I added the SQLMergXLib.dll COM to my Visual Studio project, allowing me access to SQL Server merge replication functionality from my code, and wrote a procedure for synchronising a given pull subscription. This worked beautifully and with minimal fuss.
2. I tried to deploy the project to a different machine. I received an error to the effect of, "Couldn't create object, it's a COM object and it's not registered correctly." I have encountered this problem a few times before when trying to use Interop, so I called myself a few names, went back to the deployment project, and specified that the object should be registered. Still no joy. I tried this a couple of different ways round but then...
3. ...found an article on MSDN suggesting that I should consider using the managed Microsoft.SqlServer.Replication, Microsoft.SqlServer.Management, Microsoft.SqlServer.RMO interfaces instead. I reasoned that this would eliminate the registry issue altogether as everything would become native to the .Net framework, and this seemed infinitely preferable anyway, so I promptly substituted the SQLMergX DLL for these, rehashing my code to match. Again, this built and ran OK on my development machine.
4. I tried to deploy the project to a different machine. I received the following error: "Could not load file or assembly 'Microsoft.SqlServer.Replication, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This application has failed to start because the application configuration is incorrect."

Now it's worth pointing out that I think I know what the problem might be here: No SQL Server of any kind is installed on the target machine. However, SQL Server is not required to deploy standard database solutions in .Net, and I am hoping this is also true with the Microsoft.SqlServer... namespaces, as it is a requirement that the subscription database can be located anywhere (not necessarily the target machine), and therefore that SQL Server need not be present on the target machine. However, if this is simply impossible, please let me know so that I can look at other alternatives.

Other than that, I don't mind what method I use to get the synchronisation working as long as it works (I've been at this a good few days now...), so if anyone has done this before and can offer any assistance (any registering/files I need to include etc, I am hoping it is something that simple), it would be appreciated.

Thanks,

Steve.

View 5 Replies View Related

SQL Server Error While Deploying ASP.Net 2.0 Application To Development Server.

Apr 1, 2007

Hi Everybody,
I have made one simple application in asp.net 2.0 using VS 2005. I got following error
 Server Error in '/[applicationname]' Application. --------------------------------------------------------------------------------
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
- When i got on my local machine i solved it by deleting sqlexpress directory from user's account and it was due to that I have installed VS 2005 on machine and by default it installs sql express with it.
- But I could not solved this error on my Development Server wherein there is no VS 2005. Only .Net framework 2.0 & 1.1 are there. My all other applications are running well.
 So if any one have idea regarding the solution for this error then please reply me soon. It is very urgent.
 
Thanks to all of you.
Regards, Hardik B.

View 1 Replies View Related

SQL Cant Find Server/instance When Deploying Website.

Mar 11, 2008

Hello All, please be gentle im very new to this stuff..
So if i add a record via a sql datasource using the ConnectDB connection string it adds it the the sql 2005 database called intranet.... If i try to add to it using an onbuttonlick(Code Below) event it comes up with the "An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "I have set remote connections on and tryed it with TCP/IP and TCP/IP and Named Pipes.   SQL is installed as the default instance.
If  both ways are using the same connection string surely it should work? Im not to sure where i am going wrong here...Here is the code for the on button click event.. 'INSERT NEW EMAIL INTO NEWSLETTER TABLE




1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

Protected Sub AddEmailButton_Click(ByVal sender As Object, ByVal e As EventArgs) Handles AddEmailButton.Click
Dim ConSTRING As String = ConfigurationManager.ConnectionStrings("ConnectDB").ConnectionString
'INSERT NEW EMAIL INTO NEWSLETTER TABLE
Dim cn As SqlConnection = New SqlConnection(ConSTRING)
Dim InsertSQL As String = "INSERT INTO Newsletter (Name, Email) VALUES (@Name, @Email)"
Dim cmd As SqlCommand = New SqlCommand(InsertSQL, cn)
cmd.Parameters.AddWithValue("@Name", (TBname.Text))
cmd.Parameters.AddWithValue("@Email", (TBemail.Text))
cn.Open()
cmd.ExecuteNonQuery()
LBLstatus.Text = "Success, Email is now on Mailing List"
cn.Close()

Below is my web.config connection string<connectionStrings>  <remove name="LocalSqlServer" />  <add name="ConnectDB" connectionString="Data Source=10.130.0.11;Initial Catalog=intranet;User ID=XXXXX;Password=XXXXX;"   providerName="System.Data.SqlClient" /> </connectionStrings>
 
Any help on this would be great as im stuck..
Best Regards
Leigh

View 5 Replies View Related

Deploying ASP.net Pages With Sql Server 2005 (ASPNETDB)

Jun 15, 2008

hi,i'm new to deploying asp.net pages with built in asp.net login controls over the web server. i've uploaded my asp.net pages with web.config and placed my ASPNETDB in App_Data folder on the webserver as it was placed in local machine. but it dint work and displayed the following error
 
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:



[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735123
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102



Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
 
 
i also enabled the TCP/IP connection on my local machine to accept remote connections.. Can any1 please provide me a step to step guide on how to deploy the webiste?
Thanking u in advance.
Regards

View 1 Replies View Related

Deploying Windows App And A Sql Server Express Database

Apr 29, 2008

Hi there. I've created a windows forms app that connects to a sql server express database. now that it's working on my box, i need to install the entire solution on the end user's machine.
what's the best way to move the database? I found this article:
http://msdn.microsoft.com/en-us/library/ms165716.aspx
but i'm wondering if anyone can give me some insights based on your own experience.
I'm using ms visual studio 2005 and sql server express 2005.
I'm hoping that all i'll really have to do is copy everything over to the new machine and then edit my connection string in the .exe.config file for my app.

Thanks in advance for your help.

View 5 Replies View Related

Deploying Applciation Built On SQL Server Express

Nov 3, 2005

hi all,

Can any one clarify me the doubt in deploying the application build with SQL Server Express 2005 as database and Vb.Net 2005 as frontend with the same setup made for delopying application. will the server installation and database creation can be made automatic.

If this is possible then what are the steps in doing so and the files to be included while enbeding with vb.net setup.

thanks

harsh

View 2 Replies View Related

Installing/Deploying Windows App With SQL Server 2005 CE

Jan 17, 2007

I am a little bit confused about making an installer/deployer.

I have an application using SQL Server 2005 CE (I have just updated to the most recent version Jan 2007). It will run on a new desktop PC (windows XP) if I install the SQL CE runtime and then copy the .EXE and the .SDF database file. This is great but my client wants the whole thing to install as one operation. I thought click once could do this but it seems that is only for Pocket PC targets? Can anyone point me to a method to make an appropriate installer please?

Pete

I am using the following:
SQLServerCE31-EN.msi - installer for SQL CE server runtime
SSCE31VSTools-ENU.exe - installed over VS 2005 SP1.

View 6 Replies View Related

Error Deploying SSIS Package To SQL Server

Jun 14, 2005

I am getting strange error on deploying ssis package to SQL Server.

View 10 Replies View Related

Deploying A WinForms Application With SQL Server Compact 3.5

May 21, 2008



Hi

I create a small aplication to lookup postal codes, it uses only some basic queries. It's a Winforms (using Visual Studio 2008) application, as MS put as local datase SQL Server Compact 3.5, I use it.

The application works fine it has only tree tables (with the postal codes of USA, Canada and Mexico) using the SQL Server Compact 3.5 database file.

I create a setup project and made and installer, in this case I follow the indications from MS to copy to the application folder alld the SQL Server dll files needed.

In Windows XP, the aplication works fine after installation. But in Windows Vista not. I found that as the installer put all files unde C:Programa filesMy CompanyPostal Codes folder, the application need's administrator permission to run.

I don't know how to change the database file to another location in order to avoid this problem.

Do you know how to avoid this? Maybe using a different path for my database file (if this can you tell me how to make the connection string to works properly) Or making the app to requires the administrator permission (I know tha in VS 2008 this can be done, biy not idea of how?

Thanks for you valuable help.

View 2 Replies View Related

Deploying Packages With SQL Server Based Configuration

Oct 23, 2006

Hello,

We have been conducting some testing regarding package deployment and SQL Server based configuration. It seems there is a problem that was documented in an MS Feedback entry (

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126797

)

I searched for a viable answer, work-around, or hotfix that would address this issue but found none.

The jist is that a package that uses SQL Server based configuration must have an xml-based configuration entry to "re-point" the SQL Server based configuration connection manager to the deployment target server. We cannot use environment variable or registry as this is against internal policy. The problem is that even though the xml based config is specified first in the list of package configurations it does not get applied first at run-time. So, when the package runs from a SQL Server Agent job the package's connection manager for the configuration entries is not updated.

The package runs correctly through BIDS. You can change the connection string in the .dtsConfig file and the SQL Server based package configuration is obtained from the correct source.

Environment is SQL Server Enterprise Edition 64-bit w/ SP1, Windows Server 2003 Enterprise Ed. 64-bit.



Does anyone have any experience with this issue? Know any hotfixes, other work-arounds?



Thanks in advance!

View 9 Replies View Related

Deploying Report To Production Server In A Different Domian.

Mar 19, 2008



Hello All,
I am having an issue deploying reports to my Production server via VS 2003 IDE.

The scenario is that I have a dev box with all 3 components installed on the same server(VS 2003, SQL 2000, sp3 , IIS and Report Server). I have no problem deploying to this Dev server. Now I need to deploy them to a different server(Release) in a different Domain. The Release implementation is, IIS and Report Services installed on one Server and SQL instance on a different server , but both IIS and SQL server are in the same domain. So in my VS 2003 IDE I choose a project/solution and then right click to Deploy I get an error " A connection could not be made to the report server <server URL>". My Solution Property page "Target Server URL " is pointed to this Release server virtual directory(http://Release:81/Reports). This Relase IIS web server has different web site, I installed the RS in the Default website.
I can browse RS server(http://Release:81/Reports) from anywhere via web and get to Site settings and all, But I cannot deploy from VS2003. Am I missing anything? Earlier I used to get at least log-in credentials to enter my UID and PW, as I provide them I never got anything back, it keeps asking me for UID and PW. Now I straight away get "Conection could not be made" error.

Any insights will be very helpfull.

Thank you
Ranjit

View 2 Replies View Related

Analysis :: Deploying SSAS Cube With Different Name On Same Server

Jun 21, 2013

How can i deploy an existing cube with a new name on the same server?

View 4 Replies View Related

Deploying Custom Task To Production Server

Apr 12, 2006



This seems like a rather simple questions that I've hesitated posting for a day now, but as of yet I can't really find an answer through my searches online.

My SSIS package is using a couple of the Konesans Transforms, this worked fine on my development box with my dev SQL server. The time has come now to deploy my package to my production SQL server. The instructions on installing the transforms on my dev box all uses Visual Studio to add the components.

Is there a way to deploy 3rd party (own my own) SSIS tasks with the package? Does it require a seperate install? How can I do it without Visual Studio?

Thanks for any help,

-Dan

View 7 Replies View Related

How To Create An Installer For Deploying Sql Server Express

Jul 19, 2007

Hi,



I have created an installer for deploying Sql Server Express. My installer will start the process of installing Sql Server Express. However the installation of SqlServer Express will fail because it says another installer is currently running (which is my installer). Is there anyway to work around this problem?



The reason why I would like to create an installer for the installation of Sql Server Express is because I would like to configure the SqlServerExpress without the user fiddling with the ini file.



Thanks

View 1 Replies View Related

Deploying CLR Sps Or Functions Which Call A Web Service To A Production Server

Aug 30, 2006

Dear fellow developers,

I have successfully developed a Transact-SQL stored procedure which calls a CLR function, which calls a web service. I am using a Visual Studio 2005 SQL Server Project to perform the necessary magic.

Is there a neat way to deploy this stuff to a production server?

It is bad enough deploying the sp and function, but the web server proxy also needs to be changed to refer to the production web service.

This all looks very nasty and complicated.

Am I missing something?

View 4 Replies View Related

Proxy Authentication Error While Deploying The Report On The Same Server

Jan 11, 2007

Hello Experts,

I have a Report Server when i try to deploy my report on the same server and if i use the Fully Qualified Domain Name in my report path i get the below Error

TargetServerURL : http://jptoclq901.corpusers.net/ReportServer

Error : The request failed with HTTP Status 407 : Proxy Authentication Required (Microsoft.ReportingServices.Designer)



but if i use the TargetServerURL as http://localhost/ReportServer, things do work fine. but company requirement is to use complete path.



Is this a limitation or some way out, any Idea???



Thanks in advance for the help



/Soni



View 1 Replies View Related

Difficult Times Deploying A Few Packages To SQL Server And Running As A Job

Jan 4, 2007

Hi Guys!

I have created a big list of packages, some calling others. They all work fine from my computer using Visual Studio.

When I try to deploy them (building them with deployment turned on and running them either directly from Management Studio or as a job) I get the errors with the password of connection strings. From what I read so far its the encryption process that kills it.

I have tried to add a password to some packages, but it still didnt work (only when run directly on my computer in management studio after deploying to SQL Server, but not as a job).

I have tried to change ProtectionLevel to SecurityStorage, wouldnt let me save in Visual Studio (I understand it is ot allowed in VS because you are saving to File System, how the hell am I supposed to save it to anything else? why is it showing there if its not even valid?).

If anyone can please give me the steps to doing it properly, that would be awesome. I simply need to run the packages from SQL Server! thats all! I have no idea why it has to be soooo difficult :/

View 8 Replies View Related

How To Define Configure Info While Deploying On Remote Server?

Mar 19, 2008

I use MSSQL Server to store the configure info and create deploymentutility to deploy the package on remote server,
If the configure info could be created automatically while deploying?
or I have to create the Table on remote server to record the configure info in manully?
Thanks a lot

View 1 Replies View Related







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