Problem in connection to server ( SQL SERVER 2008 Express)

Question

when I  connect the server to".\SQLEXPRESS" I have error message :

"

TITLE: Connect to Server
------------------------------

Cannot connect to .\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

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: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
" ...

please help me, how can i solve this problem.

 

Answer 1

Please check this out - http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

---

Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

Answer 2

Check if the SQL Server Express service is running.

Answer 3

Check if the SQL Server Express service is running.

I want to check but when i go to "SQL Server Configuration Manager" to check . there no servers in the list . So What can I do?

Answer 4

Please check this out - http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

---

Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

in the your article the put in  server name filed "\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query" .

what do you mean by ##?is it the computer name ? 

 

Answer 5

in the your article the put in  server name filed "\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query" .

what do you mean by ##?is it the computer name ? 

Just copy and paste it in the server name....

---

Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

Answer 6

in the your article the put in  server name filed "\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query" .

what do you mean by ##?is it the computer name ? 

Just copy and paste it in the server name....

---

Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

 i try . But it does not work?

Answer 7

are you sure that you've instaled SQL Server Express and not only SQL Server Management Studio (Express)?

where did you download the setup and what was the file called?

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 8

are you sure that you've instaled SQL Server Express and not only SQL Server Management Studio (Express)?

where did you download the setup and what was the file called?

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

i downloaded from the microsoft  downloads center . and the file name was "SQLManagementStudio_x86_ENU"

if that was wrong how i instal SQL Server Express  as free . 

if you can the righ link.

Answer 9

Please check out Paradox1's answer in below thread

http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/8a5ff5b7-1098-41a5-b9a1-417f102ae441/

 I would download and install Microsoft® SQL Server® 2008 Express with Advanced Services

from

http://www.microsoft.com/en-us/download/details.aspx?id=1842

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 10

you've installed the SQL Server Management Express only and no database engine.

you need to download and install SQL Server Express from the link mention by Ahmed.

Instead of SQL Server 2008 Express you can also install SQL Server 2008 R2 Express SP1 edition by downloading it from this link:

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=26729

download the file SQLEXPRADV_x64_ENU.exe (64-bit) or SQLEXPRADV_x86_ENU.exe (32-bit)

this setup includes SQL Server 2008 R2 Expression SP1 integrated and includes SQL Server Management Studio, Integration FullText Search and Reporting Services.

If you don't need all those feature can download other installation on the abve download page.

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.