Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Have a problem to Connect to server

Author  Topic 

thethraine
Starting Member

5 Posts

Posted - 2008-06-05 : 18:10:31
hi
i have a problem of coonecting.i need to study to my lesson on University
but i cant connect to my sql server.im using Database Engine but there is no Server Name above the Database Engine.
my server name should be thraine\sqlexpress but it doesnt work !
the error is
(provider:SQL Network interfaces ,error : 26- Error Locating Server/Instance Specified(Microsoft SQL Server)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-05 : 18:13:56
Is the SQL Server service started?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page

thethraine
Starting Member

5 Posts

Posted - 2008-06-05 : 18:24:20
its about computer name and just simple connecting and i need to use my computer name for connect to sql.
Server Type:Database Engine
Server Name:thraine\sqlexpress
it should be connect but i get an error !
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-05 : 18:37:24
You didn't answer my question.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page

thethraine
Starting Member

5 Posts

Posted - 2008-06-05 : 18:43:33
i have a diffrent error msg
No Sql Server 2005 component were found on the spesific computer !
Go to Top of Page

thethraine
Starting Member

5 Posts

Posted - 2008-06-05 : 18:44:14
quote:
Originally posted by tkizer

You didn't answer my question.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx



yes its
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-05 : 21:38:43
Did you install correctly?
Go to Top of Page

thethraine
Starting Member

5 Posts

Posted - 2008-06-06 : 02:19:23
i guess yes
but like a default install ,i chose all programs and next
whene i install the sql there wasnt any advance options !
Go to Top of Page

monty
Posting Yak Master

130 Posts

Posted - 2008-06-06 : 02:41:14
hope this link helps you

http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx

its me monty
Go to Top of Page

mdubey
Posting Yak Master

133 Posts

Posted - 2008-06-09 : 10:04:37
Try to check the TCP/IP and namedpipe is enabled on the server and read this article.

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


Manoj
MCP, MCTS
Go to Top of Page
   

- Advertisement -