lunedì 12 marzo 2012 13:00
I have downloaded SQL 2012 Express to do some testing on a test environment. Install went fine and used an old database backup was used to restore the database from. However, I can only log in to the management studio by using windows authentication - SA login gives the following error...
Cannot connect to <servername>.
A connection was successfully established with the server, but then an error occurred during the login process. (Provider: shared memory provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
After googling this error, many articles pointed towards an incorrect password being used. I tried a different password and realised that the error message is exactly the same whether I type the right password or not. I tried editing the SA password via security/logins to ensure that the password was correct, but this hasn't helped.
I am running SQL 2012 Express on a Windows 7 Laptop
Any help would be greatly appreciated.
Tutte le risposte
lunedì 12 marzo 2012 13:03
By default a SQL Server is installed with "Windows only" authentification mode, so you can use SQL Logins. Have you change the mode during installation and set a strong password for the "sa" account?
lunedì 12 marzo 2012 13:28
I don't recall making any selection for authentication mode during installation. Is the installation is set up as 'windows only' , where would I find the setting for authentication mode? Yes, I have set a strong password for SA
lunedì 12 marzo 2012 13:37
In SSMS logon to SQL Server with your windows account and connect the SQL Server in "Object Explorer". Open the properties of the SQL Server (by right mouse click) and in that dialog goto tab "Security"; at the top you will find the server authentification mode.
If it was "Windows only" then you also have to activate the "sa" account and set a strong password; that's done in node "Security" in Object Explorer for that instance.
- Contrassegnato come risposta Steve_Flynn lunedì 12 marzo 2012 14:49
lunedì 12 marzo 2012 14:45
Enable SQL authentication in SQL server by after you connect using windows authentication right click on the server name (in SSMS) and choose properties then security and change it to SQL Server and Windows Authentication Mode
and then go to security and make sure sa login is enabled.
I hope this is helpful.
Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
lunedì 12 marzo 2012 14:49Fixed! Thanks for your help
martedì 13 marzo 2012 20:14
Be warned: there are malicious people out there who know "sa" is the default system administrator for SQL Server. If your SQL port is open to the world and login via "sa" is enabled, you can expect robo-attacks against your server.
mercoledì 14 marzo 2012 15:39Thanks for the reply, yes I am aware of this. This instance is to be used purely for testing purposes with a backup of the live database on our local network only.