Author |
Topic |
dirkdiggler
Starting Member
24 Posts |
Posted - 2006-09-11 : 14:19:32
|
I am really sorry about this but I seem to be having a little trouble and I wondered if someone could help?I have just installed SQL server 2005 but I cannot seem to connect to it in Managment studio, is there something that I am missing?It is asking for a server name, and if I click browse it does not seem to find anything.Thanks in advance. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-11 : 14:25:18
|
What is the error?Tara Kizer |
|
|
dirkdiggler
Starting Member
24 Posts |
Posted - 2006-09-11 : 14:39:44
|
Hi Tara thanks for the reply.Here is the erro info: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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)Cheers |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-11 : 14:44:27
|
Did you try enabling remote connections via the Surface Area Configuration tool?Also, are you trying to connect to a SQL Server that is local or remote? If it is local, did you verify that the SQL Server services were started via the Services applet in Admin Tools in Control Panel?Tara Kizer |
|
|
dirkdiggler
Starting Member
24 Posts |
Posted - 2006-09-11 : 14:51:16
|
Yes this is local.How do I verify that the services have started? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-11 : 14:54:06
|
quote: via the Services applet in Admin Tools in Control Panel
Tara Kizer |
|
|
dirkdiggler
Starting Member
24 Posts |
Posted - 2006-09-11 : 14:58:08
|
Thanks Again Tara.Unfortunatly I do not have any entries in services for SQL server.The install did say it was a success.Should I reinstall? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-11 : 15:04:51
|
You probably only installed the client tools and not the database engine. So yes you must do the install, this time selecting the option to install the database server.Tara Kizer |
|
|
dirkdiggler
Starting Member
24 Posts |
Posted - 2006-09-11 : 15:07:16
|
Ok Thanks Tara I will reinstall and get back to you.By the way I do have visual studio 2003 and 2005 installed on this machine too.Would that make any difference? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-11 : 15:09:42
|
If you don't have the SQL Server services listed, then no.Tara Kizer |
|
|
dirkdiggler
Starting Member
24 Posts |
Posted - 2006-09-12 : 14:33:08
|
HI there again,I have reinstalled with no luck unfortuantly.The edition I am trying to install is Enterprise will that make any diference? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-12 : 14:37:21
|
No it does not make a difference what version you are trying to install. After this installation, do the services appear this time?Tara Kizer |
|
|
dirkdiggler
Starting Member
24 Posts |
Posted - 2006-09-12 : 14:44:19
|
Hi Tara and thanks again for the reply.No there is nothing when I look at the services.Also if I try and run the surface area tool I get the following message: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------------------------------I am the administrator by the way. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-12 : 14:47:32
|
You didn't install the database engine then. The services would exist otherwise.Tara Kizer |
|
|
dirkdiggler
Starting Member
24 Posts |
Posted - 2006-09-12 : 15:36:08
|
Thanks for bearing with me through this Tara!Any suggestions I have run the Setup.exe from the insatllation DVD.Oh I just saw a error about the fact that I am running Windows XP.Is this my issue? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-12 : 15:40:04
|
With Enterprise Edition, yes that's the issue!Tara Kizer |
|
|
dirkdiggler
Starting Member
24 Posts |
Posted - 2006-09-12 : 15:48:16
|
Yes that is deffiantly it.Sorry to be so dense, I thought it would be ok.I have now installed the dev edition.So be prepared for some more questions!!You help was very much appreciated.Thanks again. |
|
|
sanchin82
Starting Member
3 Posts |
|
|