Last post May 11, 2017 06:39 AM by wmec
May 10, 2017 06:36 AM|Lazy_Perfectionist|LINK
Hello. I create database, add GridView then bind it with SQLDatasource.But when start, it gives an error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 -.
I have read in forums, check Microsoft SQLServer is runnig. And when I go to All programs, I don't find Microsoft SQLServer . But Microsoft SQLServer has benn installed in Programms and feature Please help.:((
May 10, 2017 07:13 AM|kaushalparik27|LINK
There can be any out of multiple issue that can cause this, quick check is, go to Start » Run » type services.msc » This will open Services » check if SQL Server service is running or not.
Also, check below thread to troubleshoot the issue:
May 10, 2017 07:26 AM|Lazy_Perfectionist|LINK
Is it "SQL server browser"? I don't find it in services. I only find "SQL version control service". And in Firewall Inbound Rules I find neither SQL-SSMS nor SQL-Telnet.
May 10, 2017 07:36 AM|PatriceSc|LINK
You installed SQL Server or just Visual Studio? In the later case this is SQL Local Db that should be installed. You could try to run :
to see which SQL Server Local Db version are installed on your computer.
Edit: Which value are you using for the "Data Source" in your connection string?
May 10, 2017 07:36 AM|kaushalparik27|LINK
Most important is the SQL Server service itself. Check if that service exists there and it is up and running:
May 10, 2017 08:25 AM|Lazy_Perfectionist|LINK
It is not at all.
May 10, 2017 08:26 AM|Lazy_Perfectionist|LINK
I installed Visual studio. I don't understand:
You could try to run :
You could try to run :
May 10, 2017 08:39 AM|kaushalparik27|LINK
It is not at all.
By this, I understand you do not have SQL Server installed on machine, you should try to re-install or fresh install again.
May 10, 2017 08:48 AM|PatriceSc|LINK
I meant from the command line.
When installing Visual Studio you should have
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-2016-express-localdb installed rather than a service based version of SQL Server.
More likely you are currently using a connection string for SQL Server or SQL Server Express. For LocalDb it would be rather :
May 10, 2017 09:43 AM|Lazy_Perfectionist|LINK
How to re-install SQLServer? I think it installed with VS.
May 10, 2017 09:54 AM|PatriceSc|LINK
This is SQL Server LocalDb which is not service based.
If you want the service based version you'll have to install it explicitely from
If the final application will run against a SQL Server Enterprise version and you need its particular features you also have https://www.microsoft.com/en-us/sql-server/application-development (which
is free for development).
Or fix your connection string to use the LocalDb version which is currently installed.
May 10, 2017 10:22 AM|kaushalparik27|LINK
How to re-install SQLServer? I think it installed with VS
This is not what you are thinking, as fully installed SQL Server. From here you should be able to download SQL Server 2014 Express Edition:
Download Microsoft® SQL Server® 2014 Express from Official Microsoft Download Center
May 10, 2017 10:51 AM|Lazy_Perfectionist|LINK
Is these two enough? Express 32BIT WoW64\SQLEXPR32_x86.exe and Express 32BIT\SQLEXPR_x86.exe. And which of them run first?
May 10, 2017 10:57 AM|kaushalparik27|LINK
I believe you should download below setup exe files and install in this order:
May 11, 2017 06:39 AM|wmec|LINK
You can try to create different Connection which is something like
<add name="conn2" connectionString="Data Source=192.168.?.?\your_db_instance;Initial Catalog=your_db_schema;Integrated Security=False;User ID=your_db_login;Password=??????" providerName="System.Data.SqlClient"/>
within Web.config/app.config file in your project.