Today i got a very strange issue in my current organization.
We have one SQL Server Express Edition has installed on our server, The Server was installed by the Vendor Company . The Installation has done by using the Wndow Authentication Mode only and only single Login id has created ( Americas-Test ) which has Public access on the server. Now i want to change the SA Password and Also want to change the Mixed mode Authentication and how to create the SYSADMIN User on the server.
Do the User have public access ( Americas-test ) can change the authentication mode
Or How can i change the SA Password when there is no SYSADMIN User. ?
First off, have you got something like SQL Server Express Management Studio?
Connect to the server. Right-click, properties. You can change the security mode from that dialog. You'll need to restart SQL Server for the change to take effect. Once you're in mixed mode, you should have access to the sa user.
Please note: answer provided before proper application of caffeine, and so may not be 100% accurate... ;-)
Change SA password of your SQL Server 2008 version then takes the reference from this **http://howtogetpasswordofsqlserver.wordpress.com/2013/03/08/how-to-get-password-of-sql-server-mdf-file/** site which is really helpful for you. You can easily change it with new one which is easy and quick process that will greatly increase the security of your SQL Server database.
answered Apr 25 at 09:41 AM