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 |
|
talkaspx
Starting Member
3 Posts |
 Posted - 2005-09-09 : 01:06:11
|
| Hi all,Sorry if this have been done before, does anyone know why I cannot connect to query analyzer using localhost? If I use my computer name, it would be fine. But not localhost. I think it might be something to do with protocols or security settings??Thanks very much in advance. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-09 : 01:19:19
|
because the link server or reference to 'localhost' has been replaced by your computer name,to verify:select * from master..sysserversfor your servername, select @@servernameHTHquote:
Originally posted by talkaspx
Hi all,Sorry if this have been done before, does anyone know why I cannot connect to query analyzer using localhost? If I use my computer name, it would be fine. But not localhost. I think it might be something to do with protocols or security settings??Thanks very much in advance.
--------------------keeping it simple... |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-09-09 : 02:12:48
|
| use (local) instead of localhost.-ec |
|
|
|
talkaspx
Starting Member
3 Posts |
Posted - 2005-09-09 : 10:30:38
|
| Thanks jen and ec for your reply.Had checked in a few sites on this problem and while some had got it working by adding a server alias, it didn't work for me. However, I realized as I had a fresh install and need to patch it, I install service pack 3a and it is working well for me now.Thanks. |
|
|
|
|
|
|
connecting using localhost