SQL Server - Integration services doesn't run under Management Studio
Asked By max damico
20-Nov-09 01:58 PM
Hi Lads,
I work with SQL2005 on WindowsServer 2003/R2 32bit and I'm also have admin privileges.
I can run Integration Services and design my package.
When I try to run Integration services under Management Studio, It doesn't work because I cannot select sql authentication but only windows authentication. When I try to launch with this limitation, always appears a msg that I cannot run it.
It's strange because in sql server manament I can't see the service.
What do I have to do ?
Thanks for your Help
The problem i think is
with the SQL Server and not with the Integration services or the Management Studio that you run all this under.
If the SQL Server that you are trying to work with supports only Windows Authentication, then the SQL Authentication would be disabled as in your case. So the easiest way out, is to allow "Mixed Authentication" on the SQL Server.
You can do this by doing a right-click on the SQL Server - Server Properties - Security page. Set the authentication type accordingly.
.
.
There is an error like Error :The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. i m not able to deploy. Plz tell me wht are the configuration of this http: / / msdn.microsoft.com / en-us / library / ms175672.aspx For cube building, you can use SQL Server 2000 Analysis Services, SQL Server 2005 Analysis Services, or SQL Server 2008 Analysis Services. This article describes requirements for using
Any one send frequently asked Important questions in C# .Net, ADO .Net, Asp .Net and Sql Server. . . . . . . . tx in Advance. . . . . . Hi, Find this. . (B)What is an IL? (B)What is a objects in Remoting? (A) What are the ways in which client can create object on server in CAO model? (A) Are CAO stateful in nature? (A) To create objects in CAO page ? (I) Can we post and access view state in another application? (I) What is SQL Cache Dependency in ASP.NET 2.0? (I) How do we enable SQL Cache Dependency in ASP.NET 2.0? (I) What is Post Cache substitution? (I) Why Config”? (B) What is a SESSION and APPLICATION object? (A) What is the difference between ‘Server.Transfer’ and ‘response. Redirect’ ? (A)What is the difference between Authentication and authorization? (I) what proper? (A) If client side validation is enabled in your Web page, does that mean server side code is not run. (A)Which JavaScript file is referenced for validating the validators A)What is the use of <%@ page aspcompat = true %> attribute? B) Explain the differences between Server-side and Client-side code? (I)Can you explain Forms authentication in detail? (A)How
Error while installing SQL 2005 on Win 2003 Server Hi, I have installed Win 2003 Server standard edition to work with MOSS 2007. When i tried to install SQL server 2005, it is throwing error like "Your Operating system does not meet service pack requirement for this SQL server for this release." Can any one direct me, which version of Win 2003 Service
JIT Error (29053 code) during the installation of Sql Server 2005 Database Services RSS I have also got the same problem . . . this is my log file. . . My server is core to quad and having windows server 2003 installed & it is connected in Domain . I have tried to install enterprise edition and standard edition , but both holds same problem. . . . Do needful Microsoft SQL Server 2005 9.00.1399.06 = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = OS Version : Microsoft Windows Server 2003 family, Enterprise Edition Service Pack
How to find the password of my sql server Hi, I forgot the password of my sql server 2008 R2(express edition) but I kept remember password as marked so that I can To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the it. Try this and let me know. Hi, Option 1 : If there is any other SQL Server Login that is a member of sysadmin role, you can log in using that account