How to solve the system data sqlclient sqlexception 0x80131904 error

0 votes

I've used C# and SQL Server 2008 R2 to construct an application that runs flawlessly on my PC. What is my connection string?

connectionString="Data Source=KELVIN-PC;Initial Catalog=LMS;User ID=sa;Password=temperament"

However, I have installed it on a another PC and uploaded it. Additionally, I transferred the LMS.bak file to the computer and restored the database on MS SQL Server 2008 R2 there. However, it always generates the following error when attempting to connect to the database on the other machine:

System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while extablishing 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: Named pipes Provider, error:40 - Could not open a connection to SQL Server).....

I've spent hours scouring the internet, but the majority of the solutions varied somewhat from mine and some of the advice I followed wasn't actually effective. Can someone please help me with this? 

Aug 14 in Database by Kithuzzz
• 11,040 points
196 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
1 answer

How to sort the data in sql ?

Hi Akash,  If you want to sort ...READ MORE

answered May 29, 2019 in Database by sampriti
• 1,120 points
340 views
0 votes
0 answers

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

When I'm try to drop the table ...READ MORE

Sep 8 in Database by Kithuzzz
• 11,040 points
11 views
0 votes
1 answer

How to retrieve the current version of a MySQL database management system (DBMS)?

Many responses advise using mysql —version. But ...READ MORE

answered 6 days ago in Database by narikkadan
• 18,480 points
16 views
0 votes
1 answer

How to cache data in a MVC application?

Reference the System.Web dll in your model ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,830 points
1,016 views
+2 votes
1 answer

How to export data from MySql to a CSV file?

If you are using MySql workbench then ...READ MORE

answered Jan 4, 2019 in Database by Priyaj
• 58,080 points
505 views
0 votes
1 answer

How to delete duplicate rows in SQL Server?

To answer your query, note that CTEs ...READ MORE

answered Feb 10 in Others by Soham
• 9,150 points
180 views
0 votes
1 answer

Rename column SQL Server 2008

Use sp_rename EXEC sp_RENAME 'TableName.PreviousColumnName' , 'NewColumnName', 'COLUMN' See: SQL SERVER ...READ MORE

answered Feb 23 in Database by Vaani
• 7,020 points
47 views
0 votes
0 answers

How to update Identity Column in SQL Server?

With 200 records currently, I want to ...READ MORE

Aug 9 in Database by Kithuzzz
• 11,040 points
144 views
0 votes
0 answers

Query to check index on a table

I want a query to see if ...READ MORE

Aug 11 in Database by Kithuzzz
• 11,040 points
30 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP