jaebo.blogg.se

#Sql server sa account for remote login disable password#

In the SQL Server log file on my computer I see this error: Login failed for user sa.

Then any server you try to connect to from that instance of SSMS will be using the account you ran it as. I am trying to connect to SQL Server 2008 from a remote server using sa username and its password (I can log in normally with this username and password from my own computer - so 'SQL Server and Windows authentication mode' is chosen). It will then prompt you for the password and if correct will launch SSMS as that user.Įither option you choose, the user has to have permissions to run SSMS on that machine and, of course, the password has to be correct.

Open a command window and type the RUNAS command: runas /user: SSMS.

Check Server Login User Name to determine the login name of the account used to access SQL. It will then ask you for the user and password of the other user and if successful, it will launch SSMS as that user. The Remote Configuration dialog box appears. So you either disable 'sa' in general or you'll have give the login a really strong password.

Hold down the shift button while right-clicking on the SSMS executable or shortcut and clicking on "Run as a different user". As far as i know SQL Server lets you diable single sql server logins, but that means the login is disabled in general, regardless of the machine the user is trying to connect from. Remote SQL Server must have a user that have read and write privileges (Here Im using sa user).

The other way is to use RUNAS to run SSMS as a different user.

The easiest way to log in with a different Windows account is to be logged in to the machine with the different Windows account. If that's the case, then the SQL Agent was never given the permissions it needs to run everything it does in SQL Server.

Restart the SQL Services and then try to login with sa details. Sounds like you are logged in to the machine as the local admin. The SQL Server Brower service is disabled by default so you need to enable and start.

#Sql server sa account for remote login disable password#