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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Can a user with SQL express deploy a SSIS to a remote SQL server (how)

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server
 

sql express does not have integration services.

dtutil does not work without integration services.  This is therefore not an option.

The deployment manifest needs dtutil to execute.  This is also not an option.

The documentation on microsoft states that a person can connect to remote integration services by editing the ini file and then connecting locally. http://msdn.microsoft.com/en-us/library/ms137789.aspx.  Without integration service, one can not connect locally to integration services so using the transfer package of sql server is also not an option.

Also connecting remotely to an integration without editing the ini seems to require local admin rights on the target server.  This is a bit too much to ask.  (this is what I experimented let me know if you know the exact requirements)

Is there a possibility for a person with sql express, without local admin rights to the target server, to push his ssis to his sql server test instance?




View Complete Post


More Related Resource Links

Having problems installing/setting up SQL Server 2008 Express/R2 for ASP.NET user management on deve

  
I'm a bit new to installing and configuring, well, just about anything regarding databases, so please bear with me. I'm currently building a couple of ASP.NET MVC 2 sites.  I'm following along with the MVCMusicStore tutorial, and am trying to set up user management using ASP.NET's configuration tool.  The problem is that ASP.NET can't 'see' the database. I have SQL Server 2008 installed on my laptop.  It's the version which is available on the Web Platform Installer (I believe it's Express).  When I try running the aspnet_sqlreg.exe program to set up my user management database, it can't tell that I'm running any version of SQL Server at all.  I get an exception about 'named pipes', and some other things I don't understand at the moment. Obviously, this is all a bit over my head.  Is there an idiot proof guide or tutorial available that describes, step-by-step, how to: 1. Install SQL Server 2008 on a development PC 2. How to configure it to be used by Visual Studio 2010 Professional 3. How to properly upload/modify the db on the production server with what's on the development PC Essentially, all the things that the ASP.NET tutorials gloss over.  Any suggestions, links to documentation, or other nudges in the right direction would be immensely appreciated.

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

  
I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

Execute SSIS PAckage on Remote Server

  
I've seen several posts pertaining to this topic, but none of them covers what I'm having an issue with. I'm trying to create a "master job server". Essentially, I want to control all maintenance jobs from one central location. I've created SSIS packages that handle full backups, transaction log backups, index rebuilding, etc. on all of my production boxes. I've stored those packages in SQL Server. What I'd like to do now is create a separate job for each of those tasks on one central SQL Server and run those packages from there. I've been successful in creating a test job. The only step in the job is an SSIS PAckage execution step. The step successfully found the package I want to execute on the target server. When the job ran, I got the follwoing error: The job failed.  Unable to determine if the owner (ADMINSYS\arobinsf) of job SFO2PQE03 - Database Backup (FULL) has server access (reason: Could not obtain information about Windows NT group/user 'ADMINSYS\arobinsf', error code 0x2751. [SQLSTATE 42000] (Error 15404)). I want to make sure this job is executing on the remote server and not trying to execute locally. Is there something I'm missing in the set up of this job? I should also mention that the SSIS packages were created in SQL2K5, but I'm executing them from SSMS for SQL2K8. Any help would be appreciated! Thanks! A. M. Robinson

Failed to generate a user instance of SQL Server 2008 Express with Advance Services in Visual Studio

  
I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

How to deploy and configure ssis packages using sql server table in testing server and production en

  
Hi We have three environments (development, testing and production ) I have to configure and deploy the ssis packages using sqlserver table in different environments(development, testing and production).   Three environments database structures  are same But database names are different like (DEVSERVER,SITSERVER,UATSERVER) We have 14 packages and one master package. In master package we called all 14 packages question1 First time i will deploy all (master and 14 packages). If i modify one package we need to deploy all the packages or single package deployment is enough    Please help me thanks in advance          

SQL Server Express 2008 idling user logout facility

  

please let me  know whether there is a  facility in SQL SERVER EXPRESS 2008 to logout idling users automatically.My problem here is that due to limited no of license other needy users can not log in to the system 

 


How to enable SSIS functions from MS SQL Server R2 Express Business Intelligence Studio Express

  

My MS SQL Server R2 Business Intelligence Studio Express can not support SSIS functions after I install MS SQL Server Full Evaluation instance and the SSIS service is running well on my Window 7 professional laptop. Is there anyway to enable the SSIS functionalities from the original Business Intelligence Studio Express? Thanks for your help.

 

Kevin

 


how to make my sql server express 2005 a remote server

  

hi.......

how can i access my sql express 2005 database from other computers...

thanks

sachin


User failed to connect remote sql server DB

  

Hi,

I have an Prod issue that,sql server user not bale to login from his machine to Remote SQL server DB.

I am getting the below message as an error:

 

Date 11/29/2010 1:09:52 PM

Log SQL Server (Current - 11/29/2010 12:47:00 PM)

Source Logon

Message

Login failed for user 'test'. Reason: Login-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 10.13.204.6]

 

 

Please provide solution for the above error.

 

Thanks,

Ron.


What End-User products install Sql Server Express?

  

I have been trying to find/create a list of End-User (not developer or Server) products that install SQL Server Express (or any edition of Sql Server really), but I have not been able to find this information.

The reason for this is to justify to the corporate standards group for one of my clients, to allow one of their internal end-user products to do so also.  It would be easier to do this if I could point to commercial products (either Microsoft or third-party) that already do this.  I know that VS and BIDS do this, but the targeted desktops are not classified as "developer's clients", but "end-user clients".  And no, they cannot just use MS-Access instead, as it does not have the necessary features.

Thanks,

 


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."

VS 2010 One-Click Deploy uses different SQL Server user from packaged deploy?

  

I'm working on an ASP.NET MVC 3 project which uses One-Click Deploy, with Web Deploy running on the development server I'm deploying to.  The project includes a SQL Server database.  I have it set up in the project properties, completely with a deployment-only connection string (in Connection string for destination database) with a SQL Server login (call it BuildGuy) that has dbcreator rights.

I'm also using a build server (Jenkins).  I have it set up to use the command line to build my project, run tests, create a deployment package, and then deploy to our shared development server.

All of this works from the build server except the SQL Server deployment piece.  I'm using ScriptDropsFirst in Presource in my project to drop the tables, then re-create them.  When I do the one-click deployment from Visual Studio 2010, it works fine.  When the build server deploys from the package, the SQL Server piece fails with this message: "The user does not have permission to perform this action."  The SQL Server deploy only succeeds from the build server if the login, BuildGuy, has the sysadmin role.

Meanwhile, I tried removing both sysadmin and dbcreator from BuildGuy and found that the deploy still works when I do it from Visual Studio 2010.  It appears that Visual Studio 2010 is using *my* creden

Search Server 2010 Express - To Deploy Or Not To Deploy

  

We want to deploy (brand new deployment) on Search Server 2010 Express but I need to determine if SSE will be supported in the same manner as SPF?  In other words, will CU's and Service Packs be available for SSE as required? 

Currently I see CU's (KB 2475880 and KB 2459125) for SharePoint Foundation 2010 and a CU (KB 983319) for Search Server 2010 but nothing specifically for Search Server 2010 Express.  Is this product being maintained?

Can SharePoint Foundation CU's and Service Packs be applied to SSE installations to keep SSE up-to-date?

Any insight into this would be greatly appreciated,

Thanks,

Grant. 


CommunicationException was unhandled by user code;The remote server returned an error: NotFound

  
Hi ,

Getting an err :CommunicationException was unhandled by user code;The remote server returned an error: NotFound.

scenario:

1. we are sending large amount of data from Silverlight client to wcf svc and storing in DB.
2. when the data size is less its working fine.
3. But when we send large data we get an err like

CommunicationException was unhandled by user code

The remote server returned an error: NotFound

4. we also increased the Buffer Sizes in the binding part in the config files.


most of the google results , forums are saying to increase the Buffer Sizes, but still we face the same proble.


Any clues on how to overcome this err will be a gr8 help!

Thanks
Senthil

http://dotnetcrunch.blogspot.com


Is SQL Server 2008 R2 Express - mult-user ?

  

Hi,

We have an application that we ship and include a version of sql express on the CD.  In the old days we used to ship MSDE and this worked fine with mult-users; we have since shipped 2005 & 2008 express editions and have had no issues.  BUT I have read somewhere ( though can't find the article again ) that something changed in 2008 R2 Express with regards to using it in a multi-user environment and I remember that the article suggested that "buying" the workgroup edition might be the way forward, if you want to use it in a multi-user system.  Obviously this has drastic impact, in that we can not give away free editions of Workgroup !! 

I have searched high and low on the Microsoft sites to find any information that might lead us to believe that R2 Express is not designed for multi-user systems, but can not find anything saying this; so just wanted to know if anyone knows of such information or why people may believe R2 Express is not suitable ?

Thanks,

Chris.

 



MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Configuring User Profiles in SharePoint Server 2010

  
Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

User Defined Functions in Microsoft SQL Server

  
User Defined Functions are compact pieces of Transact SQL code, which can accept parameters, and return either a value, or a table. They are saved as individual work units, and are created using standard SQL commands. Data transformation and reference value retrieval are common uses for functions. LEFT, the built in function for getting the left part of a string, and GETDATE, used for obtaining the current date and time, are two examples of function use. User Defined Functions enable the developer or DBA to create functions of their own, and save them inside SQL Server.
Categories: 
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