Did you try using (local)\SQLEXPRESS in the name? I've not seen that . notation before.
Scott Anderson
2009-05-19 21:09:39
A:
yes I have tried that also. The dot is its equivalent.
waqasahmed
2009-05-19 21:13:32
A:
There is a possibility that you installed as Default instance. In this case, try connecting using (local) - just (local). Then go to Programs/Microsoft SQL Server/Configuration Tools/SQL Server Configuration Manager. Go to SQL Server Network Configuration/Protocols for MSSQLSERVER and enable Named Pipes.
a programmer
2009-05-19 21:12:33
I believe it is something to do with instance. So what do I type in: Just "(local)" - I get error "Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)" if so. Any other I get Error 26 again.
waqasahmed
2009-05-19 21:15:44
A:
you can look for your instance name in SQL Server Configuration Manager. It is written between brackets after SQL Server service in the services list.
the . notation is correct and it's the same as (local)
Apparently, "there are no items to show in this view" in the Sql Server Services section in the Configuration Manager.
waqasahmed
2009-05-19 21:22:59
Is a service not running perhaps? If so, how can I start it? I don't see SQL Server in the services section in Admin tools either?
waqasahmed
2009-05-19 21:24:05
t just shows "There are no items to show in this view." for SQL Server Network Configuration. ANd it has no sub items. In client protocols (in SQL native client 10 configuration section), Shared Memory, TCP/IP and Named Pipes are all enabled. ANd VIA is disabled.
waqasahmed
2009-05-19 21:28:12
I don't see it in Windows Services or the Sql Server configuration manager. Is there a way to start it?
waqasahmed
2009-05-19 21:33:19
If you don't see it in Windows Services, then it is not installed. You sould try to re-install.
a programmer
2009-05-19 21:45:49
A:
Have you tried looking at the SQL Server Surface Area Configuration? You might only have SQL Authentication setup and might need to enable Network and SQL Authentication.
-JFV
JFV
2009-05-19 21:34:23
is there a standalone for SQL Server Surface Area Configuration in 2008 ( i think there was in 2005, can't find it for 2008). But in Configuration Manager, I see no items in SQL Server Services and SQL Server Network Configuration.
waqasahmed
2009-05-19 21:40:43
+1
A:
Scott,
I had to enable SQL Server Browser in services once I did that I was able to connect on My recent install.
after that I only had to use the computer name as the server.
edit, while researching further on finding sql server browser, noted that reporting services, service showed its instance as .\computer name.
try that as the server name.
edit again change to backslash been playing with linux recently :)
DouglasH
2009-05-19 21:39:25
I can't find "SQL Server Browser" in Windows Services (Admin Tools).How can I start/enable this?
waqasahmed
2009-05-19 21:43:23
you installed sql server express with advanced tools correct, sql server browser even shows up on the standard install. so it should be in services. if not sounds like something happened with install.not an expert on this fumbled around until I found that in services and it worked even found my sql server instance on the laptop.
DouglasH
2009-05-19 21:51:19
I am running the installation again. Apparantly, I do not have any of the Instance Based installation installed (i.e. the Database engine). I suspect this is the problem: I will let you know when the installation is complete.
waqasahmed
2009-05-19 22:04:19
Also had this problem tonight, and it was the browser service that got it sorted.
kdmurray
2009-07-26 09:17:32
A:
Check this post. Once I did what in the post, Everything works fine. http://praveenbattula.blogspot.com/2010/01/sql-express-instance-is-not-in-list-of.html
A:
I have an application that uses a connection string trough VSOT in Word 2007. The application gave a connection error. I allways install Sql server 2008 Express R2 in mixed mode so that i can use the build in sa with i password to connect. I re-entered the password to be sure its correct. In a next step i opened: ‘Configuration manager’ in ‘Program files’ ‘Microsoft Sql Server 2008’ –->’ Configuration Tools’ and set all the other instances on the properties --> hide instance 'yes' That solved the problem in my case. Danny
Danny Zeegers
2010-05-16 04:48:19