"A network related or instance specific error occurred while establishing a connection to SQL server..."
If you have ever installed SQL server, you could be a victim of this error. There could be many reasons for this. New developer could stuck in to this error and may lost much time in resolving it. I had also been to this :), so I decided to write this blog.
If your installation is not fresh and you have used SQL Server before with this installation, then :
1. Check the SQL Server services in the services.msc, whether its services are running.
2. Check the credentials and server name, if it is correct.
If your installation is Fresh:
Make sure that you have installed SQL Express, not the SQL Server Management. The difference between them is that, SQL Express is the actual database and the SQL Server Management is just the interface for managing the database. If you have installed only SQL Server Management, then SQL Server would not work.
You can install SQL Express and SQL Server Management both together, but make sure, both belongs to the same version of SQL Server.
Hope this article worth for you !
If you have ever installed SQL server, you could be a victim of this error. There could be many reasons for this. New developer could stuck in to this error and may lost much time in resolving it. I had also been to this :), so I decided to write this blog.
If your installation is not fresh and you have used SQL Server before with this installation, then :
1. Check the SQL Server services in the services.msc, whether its services are running.
2. Check the credentials and server name, if it is correct.
If your installation is Fresh:
Make sure that you have installed SQL Express, not the SQL Server Management. The difference between them is that, SQL Express is the actual database and the SQL Server Management is just the interface for managing the database. If you have installed only SQL Server Management, then SQL Server would not work.
You can install SQL Express and SQL Server Management both together, but make sure, both belongs to the same version of SQL Server.
Hope this article worth for you !
No comments:
Post a Comment