Sql server turns off when my pc turns off

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

Hi. I have copied my project on another PC. Project includes working with database that is on Sql Server. The app is working perfectly when my PC is turned on, but when I turn off my PC the app on another PC is not working (it comes up with an error). This is the error:

C#

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)

EDIT:This is my connection string:

C#

Data Source=JOHN-PC\SQLEXPRESS;Initial Catalog=MyDatabase;Persist Security Info=True;User ID=MyUsername;Password=MyPassword

If I change Data Source to .\SQLEXPRESS the error comes up:

C#

Login failed for MyUsername user.

What I have tried:

Since I'm new in working with SQL Server, recently I found out that there is an option in new SQL Server versions that is called AlwaysON. Is there any connection between this option and my problem? And how can I deal with my problem?

Posted 28-Feb-16 23:04pm

PeMaCN

Updated 29-Feb-16 1:01am

v2

Add a Solution

Comments

Jörgen Andersson 29-Feb-16 5:12am

Have a look at the connection string, I guess it's pointing to your pc and not a local file.

PeMaCN 29-Feb-16 5:48am

Yes, it's showing to my pc but what should I type to point it to local file

Jörgen Andersson 29-Feb-16 7:03am

Go to https://www.connectionstrings.com/sql-server-2008/ and look for "Attach a database file, located in the data directory, on connect to a local SQL Server Express instance"

PeMaCN 29-Feb-16 7:08am

I dont think attaching database is a good idea

Jörgen Andersson 29-Feb-16 7:15am

Why not?

PeMaCN 29-Feb-16 7:20am

It comes up with error: "An attempt to attach an auto-named database for file ... failed.A database with the same name exists,or specified file cannot be opened,or it is locatedon UNC share."

Richard MacCutchan 29-Feb-16 7:21am

Which machine is the server running on?

PeMaCN 29-Feb-16 7:23am

How do you mean which machine? My laptop

Richard MacCutchan 29-Feb-16 7:33am

Your question refers to two machines, one of them has SQL server running, and the other (I assume) is trying to connect to it. You say "when I turn off my PC the app on another PC is not working"; what exactly is the other PC trying to do?

PeMaCN 29-Feb-16 7:38am

While my laptop is turned on, project on another PC is working (it can connect to database and do what it is supposed to do) but when I turn off my laptop the error (which is in the question) comes up. Is it clear?

Richard MacCutchan 29-Feb-16 7:40am

So are you saying that the other PC is trying to connect to SQL Server on your laptop, when your laptop is turned off? That's like saying my car won't go when the engine is not running.

PeMaCN 29-Feb-16 7:42am

I know that question is a bit stupid but nevertheless, since I'm a beginner and still learning, can you tell me how can I deal with this.

Richard MacCutchan 29-Feb-16 7:54am

Easy: don't turn it off. Seriously, how do you expect some part of a machine to be able to run when the entire system is turned off?

PeMaCN 29-Feb-16 7:57am

Well, I understood that part but is there any other technology or way to achieve this?

Richard MacCutchan 29-Feb-16 8:15am

Like what? Do you understand the laws of physics?

Philippe Mori 3-Mar-16 7:48am

It is not clear of which PC you are talking. If JOHN-PC the laptop or the other PC? I assume that SQL server is installed on both.
Obviously, something is wrong with your connection string. Verify user name, user password and user instance.
It is hatd to follow you as it is not clear on which PC you try things... And it is not even clear if you want to use local or remote database. Usually, if one specify PC in connection string, it is to use a remote computer but it make no sense to expect that a computer that is turn off would respond to SQL queries... Thus it is very hard to understand what you are trying.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Parveen Siwach · Answer 1 · 2016-02-28T23:38:00

Solution 1

Hi,

This issue may be because of SQL Server "Services".

The Sql Server service mode may be - "Manual". You need to make that "Automatic".

Steps:

Run -> type - services.msc

Find - SQL Server - Instance and change the Startup Type from Manual to Automatic

Thanks,
Parveen Siwach

Posted 28-Feb-16 23:38pm

Parveen Siwach

Comments

PeMaCN 29-Feb-16 5:46am

No.It's already automatic

Parveen Siwach 29-Feb-16 6:04am

And what is the status --- Is it "Running"?

Parveen Siwach 29-Feb-16 6:36am

Also you can try these:

1. Make sure your database engine is configured to accept remote connections:
Start > All Programs > SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration
Click on Surface Area Configuration for Services and Connections
Select the instance that is having a problem > Database Engine > Remote Connections
Enable local and remote connections
Restart instance

2. You may need to create an exception on the firewall for the SQL Server instance and port you are using:
Start > Run > Firewall.cpl
Click on exceptions tab
Add sqlservr.exe (typically located in C:\Program Files (x86)\Microsoft SQL Server\MSSQL.x\MSSQL\Bin, check your installs for the actual folder path) and port (default is 1433)
Check your connection string as well

From FIX : ERROR : Could not open a connection to SQL Server:

3. Check if your SQL server services is up and running properly:
Go to All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager > SQL Server Services
Check to make sure SQL Server service status is Running.

In addition, ensure that your remote server is in the same network. Run sqlcmd -L to ascertain if your server is included in your network list.

4. Enable TCP/IP in SQL Server Configuration

When two or more SQL Servers are connected across network they do all communication using TCP/IP. The default port of SQL Server installation is 1433. This port can be changed through SQL Server Configuration Manager. TCP/IP should be enabled for SQL Server to be connected.
Go to All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> Select TCP/IP
Right Click on TCP/IP >> Click on Enable

You must restart SQL Server Services for all the changes to take effect. Right click and go to menu properties to select location where default port of SQL Server can be changed.

PeMaCN 29-Feb-16 6:50am

I have done all of these and the status is running