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.
| Author |
Topic |
|
BendJoe
Posting Yak Master
128 Posts |
 Posted - 2008-05-05 : 15:34:56
|
| Hi,I reinstalled SQL Server 2005 and am unable to connect to the server.I am using Windows authentication Mode. My computer Name is NINJA.So I used the server name as NINJA\SQLEXPRESS. It is giving Error 26. TITLE: Connect to Server------------------------------Cannot connect to ninja\sqlexpress.------------------------------ADDITIONAL INFORMATION:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not 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 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-05 : 16:30:02
|
| enable remote connections in SQL surface config and TCP/IP protocol. |
 |
|
|
BendJoe
Posting Yak Master
128 Posts |
Posted - 2008-05-05 : 16:40:01
|
quote:
Originally posted by sodeep
enable remote connections in SQL surface config and TCP/IP protocol.
My installattion is on my Local Machine.It says TITLE: Surface Area Configuration------------------------------No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)------------------------------BUTTONS:OK------------------------------Please Advice |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-05 : 23:06:29
|
| Looks like you installed sql client only. Did you see sql services on the machine? |
|
|
|
|
|
|
Cannot Connect to Server