Home / server / Questions / 55406
In Process
Jan Jongboom
Asked: 2009-08-19 01:29:11 +0800 CST

Granting rights to the sa account using osql

  • 772

I'm installing sql instances through script, and after creating a certain instance, I cannot get the sa account to be enabled through osql.

What I've tried

  1. osql -S .\INSTANCENAME -E
    use master
    ALTER LOGIN sa ENABLE
    GO

    • Using SSMS to enable the account (by logging in using Windows Auth., 'New query', and exactly the same query as in 1.)

    • Suggestions in this issue

No. 2. is actually working; and the account is enabled instantly. No 1 is not working, not even with the suggestions provided in 3., I have restarted the SQL services after executing the commands in osql.

Additional info
Windows 2003 Server, Microsoft SQL Server 2005 Enterprise, No password policies apply to the account.

sql-server osql

2 Answers

    • 1

  2. You do not state, but the syntax .\instancename implies that you are running your OSQL on your target server? Is this the case? Have you tried Servername\instancename?

    • 0