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 |
|
ckim472
Starting Member
4 Posts |
 Posted - 2009-02-05 : 11:02:53
|
| I've installed a default instance of sql server 2005 on my local machine and I'm having trouble getting it to connect to my machine.for example typing in "." in Server Name. I did mixed mode when I installed. Any advice is appreciated.chul |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ckim472
Starting Member
4 Posts |
Posted - 2009-02-05 : 12:25:25
|
| Server Type : Database EngineServer Name : .Authentication : Windows AuthenticationERROR:Cannot connect to ..An error has occured while connecting to the server.When connecting to SQL server 2005, this may be caused by the fact that under the default settings sql server does not allow remote connections.....But I'm not connecting remotely, I am just trying to get a connection to my local machine.Thank you.Chul Kim |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ckim472
Starting Member
4 Posts |
Posted - 2009-02-05 : 14:42:34
|
| windows xp |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-07 : 20:37:35
|
| Enable Remote connection in Surface area config. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-08 : 00:58:48
|
Are you using any kind of virtualization software?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
sql server 2005 local install