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 |
|
naushi44
Starting Member
12 Posts |
 Posted - 2011-02-13 : 11:48:42
|
| I have my sql server 2008 express service running. I have all network protocol enabled.However I cant connect to database engine. I am using windows authentication. the error is 40 - My OS ia windows 7 an I used the 64bit installation. any help will be appreciatednaushi hussain |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-13 : 12:27:19
|
| the erros is 40??? .... Can you post the complete error message?? Did you provide Named Instance during installation or Default one? are you trying to connect to the SQL server via same machine where the instance is installed or connecting via remote application?CheersMIK |
 |
|
|
naushi44
Starting Member
12 Posts |
Posted - 2011-02-13 : 12:37:52
|
| thanks MIK for fast response - here is the error. It never asked me for an instance while installing - in Mgmt-Studio log in window I see server type as 'databae engine' and server name as 'nausshi-pc' which is my computer name. 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 connection (provider: named pipes provider, error: 40- could not open a connection to sql server)(Microsoft sql server , error : 2)naushi hussain |
|
|
|
naushi44
Starting Member
12 Posts |
Posted - 2011-02-13 : 12:38:33
|
| same machine - I am on my lap top.naushi hussain |
|
|
|
naushi44
Starting Member
12 Posts |
Posted - 2011-02-13 : 14:48:05
|
| Hello MIK - I changed the server name to NAUSHI-PC\sqlexpress and it worked. I believe the instance name was default as sqlexpress and naushi-pc iss my computer name.naushi hussain |
|
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-13 : 23:58:57
|
| :) yup, default instance name can be accessed without specifying it, however a named instance must be specified along with the server name.CheersMIK |
|
|
|
|
|
|
management studio