sqlcmd Login failed for user sa

sql-server-2008 ssms sa
Sachin Kainth picture Sachin Kainth · Jun 7, 2012 · Viewed 10.7k times · Source

I am trying to run this command 

sqlcmd -U "sa" -P "mypassword" -S (local)\SQLEXPRESS -Q "ALTER DATABASE mydatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE"

from a .bat file but it is failing with the error

"Login failed for user 'sa'

I have gone to the Login tab under the Security tab in SSMS and changed the password of the sa account to the password in the .bat file, but still get this error.

I have tried to log into SSMS with the sa account using these credentials and with SQL Server authentication but I get the same error. I have stopped and started the SQL Server service, nothing works.

Any idea what I must do?

Answer

Related questions

How to find server name of SQL Server Management Studio

I installed Microsoft SQL Server 2008. When I start SQL Server Management Studio (SSMS), I get the Connect to Server login window with a blank textbox for Server name. I have tried a lot of names, but I couldn't solve it. …

Read More
How to connect to local instance of SQL Server 2008 Express

I just installed SQL Server 2008 Express on my Vista SP1 machine. I previously had 2005 on here and used it just fine with the old SQL Server Management Studio Express. I was able to connect with no problems to my PC-NAME\…

Read More
Sql Server 'Saving changes is not permitted' error ► Prevent saving changes that require table re-creation

When I create a table in SQL Server and save it, if I try to edit the table design, like change a column type from int to real, I get this error: Saving changes is not permitted. The change you …

Read More