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 |
|
mike86
Starting Member
24 Posts |
 Posted - 2007-07-26 : 22:01:08
|
| Hi, guys. I received an error msg while try to connect sql server 2005.TITLE: Connect to Server------------------------------Cannot connect to localhost.------------------------------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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476------------------------------BUTTONS:OK------------------------------could someone help?M i K e |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-26 : 23:05:19
|
| Ensure the instance allows remote connection and sql server browser service is running. Connect with instance name instead of localhost. |
 |
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-26 : 23:17:41
|
| wht instance? i try to connect MOBILE-SERVER. but it cant work too. any idea?M i K e |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-26 : 23:42:15
|
| Did you install sql2k5 as named instance? Check sql server configuration manager for instance name. |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-26 : 23:51:47
|
| ive tried to check the sql server configuration manager. i went to the server tab, and the start mode has been disabled. i couldnt select other options like automatic or manual, not even change the other settings as it will prompt an error msg saying that the service has been disabled or it has not an enabled device to associate with it. wht should i do? (p/s: ive actually installed sql server 6.5 on the pc. the problem occurred after the installation. ive uninstalled the 6.5, but the problem still persists. could this be the problem too?)M i K e |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-28 : 00:10:16
|
| Do you logon windows as local admin? Can you start sql2k5 service in services applet? |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-30 : 03:22:39
|
| i've uninstalled and reinstalled it. guess that's the easiest way! :DM i K e |
|
|
|
|
|
|
SQL Server connection error