December 6, 2013 at 9:41 am
I had by default installed express msmss with windows mode. But now I need mixed mode of authentication. I have tuned the server and checked in its properties - mixed mode.
I had also enabled (executed the query ALTER LOGIN). I have entered the same paasword into sa properties. I have entered under sa - but there is a mistake in the journal that says that The server supports only windows authentication mode.
I have cheked and restarted server several times. Under administrator rights and under not.
But it doesn't work still.
I make it because i need to connect to sql server from the Sql Developer Oracle.
December 6, 2013 at 1:21 pm
So locally can you log in with SA or not? But externally you can't. I didn't quite catch it..
CEWII
December 11, 2013 at 7:24 am
If you actually did change the authentication mode to mixed mode, entered a new password for sa and then restarted SQL Server, this has to work.
So something must have gone really wrong / been overlooked.
You can check the auth mode in the registry:
Open regedit.exe
Go to "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<INSTANCE NAME>\MSSQLServer where <INSTANCE NAME? is the name of the MS-SQL instance.
Locate the field "LoginMode"
a value of "2"is Mixed Mode Authentication
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
December 11, 2013 at 9:38 pm
Check if the SA account is disabled. If it is, then enable it using below SQL query
Use Master
Go
ALTER LOGIN [sa] WITH PASSWORD='StrongPassword'
Go
Chandu
[font="Comic Sans MS"]If you dont have question, you wont get answer[/font]
December 11, 2013 at 9:42 pm
Please use below query to enable SA login and change SA password.
Use Master
Go
ALTER LOGIN [sa] ENABLE
go
ALTER LOGIN [sa] WITH PASSWORD=N'StrongPassword'
Go
Chandu
December 16, 2013 at 10:56 am
sounds like you never created one sa account in your server., changing it to mixewd mode after installation does not create sa account automatically ! you should have a option to create either when you install or create it after install.
Login with domain or windows mode and create sa and login then.
December 16, 2013 at 11:04 am
it's not possible to NOT "install" sa. The only diofference is, whether sa is actually enabled - which he said he did manually - and whether the password is known
Let's wait for the answers on the proposed queries
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
December 17, 2013 at 9:52 pm
If you're an admin on the box, you can get in anyways and fix any mistakes you have.
.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply