Just in case it happens again and just for plain curiosity. 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 Then we’ll download and install SQL Server. The way to do this is to run SQL Server on Docker. And because macOS is Unix based (and Linux is Unix based), you can run SQL Server for Linux on your Mac. I originally installed SQL Server Express 2014, but as I am only using it local for testing it. 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. Starting with SQL Server 2017, you can now install SQL Server directly on to a Linux machine. Wanna know how do I connect 2012 LocalDB to Sql Server. What else should I check? Thanks in advance. 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. I get the error: Login failed for user 'sa'. I'm trying to log in to a SQL Server 2005 Express instance using the following command: osql -S.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |