My application can connect using another SQL Server login, but no 'sa'įinally, if we don't find a solution I will remove this instance and install it again, but I'd really like to find out what's the problem. I'm connecting using VNC, so I can't really use SSMS They have some password policies enabled, I remember that I needed to change the default 'sa' password my application uses when it installs SQL Server to another one more complex.
In this article, I will explain how to execute SSIS packages using: SQL Server Management Studio (SSMS), DTEXECUI.EXE Utility DTEXEC. What else should I check? Thanks in advance. These packages can be stored on the Integration Services server, in the SSIS Package Store, msdb database, and in the file system, outside the location that is part of the package store. Login using Windows authentication and changing the sa password:ĪLTER LOGIN sa WITH PASSWORD = 'newpassword' Ĭhecked the Windows Registry to ensure that mixed authentication is enabled. I think someone changed something but I cannot figure out what is it. I must add that it's been working for months. I can connect just fine using the -E switch. While these tasks can be completed with SQL PowerShell and T-SQL statements, I chose the prior three methods because I felt they were easier to use when it came to applying. I get the error: Login failed for user 'sa'. Below are examples of how to Start, Pause, Stop, and Restart the SQL Services using SQL Server Configuration Manager, the Command Prompt, and SQL Server Management Studio. I dont believe there is a way around this. It will support, access to basic data sources, but not the full suite that is included in the Standard edition of MSSQL Server 2008. I'm trying to log in to a SQL Server 2005 Express instance using the following command: osql -S. Microsoft SQL Server 2008 Express doesnt support Integration Services at its fullest.