cannot connect to pc-name\SQLEXPRESS

Question

While trying to connect to SQL Server 2005 Standard Edition through SQL Server Management Studio 2005 I get the following error:

screen shoot of error is given bellow

I put all my effort to solve this problem but there is no solution. On stack overflow in the following post I found this screen shot: solution of screen shot

When I see my connect to server dialog box I find the difference like

my connect to server dialog box

What is the problem?

This SQL server runs on a single machine, not on a cluster or on a client server.

Are you able to connect to your `local` or `localhost` or `.` as server name ? — praveen, Mar 11 '13 at 06:28
Are you sure that your `SQL Server(SQLEXPRESS)` service is running? — peterm, Mar 11 '13 at 06:31
you are not ablke to connect via windows as well as sa user? Check your sqlbrowser service is runing. Also check whether namedpipe and TCPIPr both are checked in surface area configuration — Kamran Shahid, Mar 11 '13 at 09:37
yes i have done you tell @KamranShahid butt same error can you help me by cumming on team viewer. or any one — Waleed Ehsan, Mar 11 '13 at 10:41

score 51 · Answer 1 · answered Mar 11 '13 at 06:30

51

enter image description here

Go to services (services.msc) and restart the services in the image and then try to connect.

answered Mar 11 '13 at 06:30

trying this but fail then restart machine but fail and even uninssall and then install again fail seeing this error 26 error – Waleed Ehsan Mar 11 '13 at 07:37

S. Mayol · Answer 2 · 2021-02-04T20:45:53.100

36

If you have Microsoft Windows 10:

Type Control Panel on Cortana search bar (which is says by default 'Type here to search'). Or click on Windows icon and type Control Panel
Click on Administrative Tools
Then double click on Services
Scroll down and look for: SQL Server (SQLEXPRESS), after that right click
And then in the pop out windows click on Start

Now you should be able to connect to your pc-name\SQLEXPRESS

edited Feb 04 '21 at 20:45

answered Aug 01 '15 at 18:46

S. Mayol

2,565
2
27
34

Run the Computer Management applet from Control Panel→Administrative Tools→Computer Management, where you should find the configuration manager installed. – live-love Feb 07 '18 at 22:10

akshay shedwad · Answer 3 · 2018-04-07T06:29:08.063

When you get this error.

Follow these steps then you solve your problem

Open command prompt by pressing (window + r) keys or Click on windows Button and Type Run then type services.msc and click OK or press Enter key.

2.Find SQL Server (SQLEXPRESS).

3.Now see left upper side and click start.

4.If Service show error then right click on SQL Express and then click on Properties.

5.Then click on Logon Tab.

6.Enter Username and Password of Windows Authentication

7.Then Start your Service

8.Problem will be solve and run your query

score 7 · Answer 4 · answered Feb 14 '19 at 12:23

7

Use (LocalDB)\MSSQLLocalDB as the server name

answered Feb 14 '19 at 12:23

Ramanujam Allam

1,300
12
11

score 5 · Answer 5 · edited Feb 13 '18 at 18:48

Follow these steps then you solve your problem 100%.

When you get this error then close everything(Microsoft SQL Server Managment):

Then open command prompt by pressing (window + r) keys and type services.msc and click OK or press Enter key.
And search **SQL Server (SQLEXPRESS) as I show in the image.

Now see left upper side and click start.
If you open Microsoft SQL Server Management then you not get any type error.

Enjoy!!!

score 3 · Answer 6 · answered Apr 10 '16 at 20:33

I'm Running Windows 10 and this worked for me:

Open services by searching in the toolbar for Services.
Right click SQL Server (SQLEXPESS)
Go To Properties - Log On
Check Local System Account & Allow service to interact with desktop.
Apply and restart service.
I was then able to connect

score 3 · Answer 7 · edited Oct 05 '16 at 00:57

3

Initialize the SQL Server Browser Service.

edited Oct 05 '16 at 00:57

orangething

708
5
16

answered Oct 04 '16 at 22:41

Luis Mata

73
6

score 1 · Answer 8 · answered Mar 12 '13 at 14:29

1

try using IP instead of pc name. If the ip working, then it might be the name pipe is not enable. If it;s still not working then the login using windows might be disabled.

answered Mar 12 '13 at 14:29

user2161455

11
1

score 1 · Answer 9 · answered Oct 23 '15 at 19:30

1

I had this problem. So I put like this: PC-NAME\SQLSERVER Since the SQLSERVER the instance name that was set at installation.

Authentication: Windows Authentication

Connects !!!

answered Oct 23 '15 at 19:30

Helder José

21
1

score 0 · Answer 10 · answered Jul 25 '14 at 15:33

0

go to services and start the ones related to SQL

answered Jul 25 '14 at 15:33

ady

19
1

4

Please provide some more details – Raja Simon Jul 25 '14 at 15:40

undrline - Reinstate Monica · Answer 11 · 2020-02-10T23:34:28.123

My issue occurs when I add a PC to a domain. Restarting the service, making sure it's running, that it has the correct credentials to run, etc, as in other answers doesn't work. I don't know exactly what the problem is, but I can't even log in with the local user anymore to give the domain user access. Here's the steps that work for me:

In SSMS

View > Registered Servers
Database Engine > Local Server Groups > right-click pcname\sqlexpress
Delete > Yes
Right-click Local Server Groups > Tasks > Register Local Servers
It confirms that it re-registered. pcname\sqlexpress reappears.

I'm then able to log in with the local windows auth'd user again, my databases are all there and everything. I then go about my business adding the domain user to Security > Logins.

score 0 · Answer 12 · answered May 31 '21 at 08:19

In my case, I was copying and pasting the server name from appsettings.json as;

DESKTOP-IVQP9DJ\\SQLEXPRESS.

So the problem was that there were two slashes in the server name which was causing the issue for me. If you are using .net core and copying/pasting server name like me make sure to use only one slash as:

DESKTOP-IVQP9DJ\SQLEXPRESS

score 0 · Answer 13 · answered Mar 28 '22 at 14:55

0

If you already did that Then just restart the service :

start menu
Microsoft SQL Server 20xx
Sql Server 20xx Configuration Manager
SQL Server Service (at left tree)
SQL Server (SQLEXPRESS) (at right region)
right click -> restart

answered Mar 28 '22 at 14:55

shdr

868
10
25

cannot connect to pc-name\SQLEXPRESS

13 Answers13

Linked