Author |
Topic |
stahorse
Yak Posting Veteran
86 Posts |
Posted - 2011-10-06 : 07:51:19
|
Hi EveryoneI just installed my SQL Server and Management tool 2008, but I have a problem with loging in.Server Type: Database EngineServer Name: (local)Authentication: Window Authentication I get this error:Cannot connect to local A network-related instances-specific erro occured while establishing a connection to SQL Server. The server not found or was not accessible. Verify that instance name is correct and that SQL Server is not configured to allowremote connections.(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)(Microsoft SQL Server, Error: 2) If anyone could helpThank you |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-10-06 : 07:55:49
|
Try (local) instead of local No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
stahorse
Yak Posting Veteran
86 Posts |
Posted - 2011-10-06 : 08:17:49
|
actually it is (local) |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-10-06 : 08:35:08
|
Is the SQL Service running?--Gail ShawSQL Server MVP |
|
|
stahorse
Yak Posting Veteran
86 Posts |
Posted - 2011-10-06 : 08:50:51
|
Yes t is running |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-10-06 : 09:10:07
|
Have a look in the Configuration Manager. Are the needed protocols enabled?Or another idea: did you gave another instancename at installation time? No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
stahorse
Yak Posting Veteran
86 Posts |
Posted - 2011-10-06 : 09:22:06
|
Protocol enabled with port 1433. instancename is N ATHOURITY SYSTEM |
|
|
NifflerX
Starting Member
29 Posts |
Posted - 2011-10-06 : 11:01:30
|
Are you able to log in if you change from (local) to the server's hostname? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-10-06 : 12:16:32
|
quote: Originally posted by stahorse instancename is N ATHOURITY SYSTEM
That's the service account. WebFred's asking if this is a named instance.--Gail ShawSQL Server MVP |
|
|
stahorse
Yak Posting Veteran
86 Posts |
Posted - 2011-10-07 : 01:54:32
|
I have sort it out thanks for all the help |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-10-07 : 03:19:16
|
Can you post how you solved it so other people with the same problem can read it? No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|