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 |
|
jlagos
Starting Member
1 Post |
 Posted - 2011-01-13 : 10:26:58
|
| Where i could change the config in 2005 in order to allow remote conections? - Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-01-13 : 10:58:50
|
| Run the Surface Area Configuration tool. |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-13 : 10:59:31
|
IN SMSS..Right click the server>properties>connections ..check the box which says "Allow remote connections to the server"
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-01-13 : 11:02:46
|
quote:
Originally posted by dataguru1971
IN SMSS..Right click the server>properties>connections ..check the box which says "Allow remote connections to the server"
Poor planning on your part does not constitute an emergency on my part.
Errrmmmm, I think the OP meant in SQL 2005, theres the bloody awful SAC tool.. |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-13 : 17:22:28
|
quote:
Originally posted by RickD
quote:
Originally posted by dataguru1971
IN SMSS..Right click the server>properties>connections ..check the box which says "Allow remote connections to the server"
Poor planning on your part does not constitute an emergency on my part.
Errrmmmm, I think the OP meant in SQL 2005, theres the bloody awful SAC tool..
Same answer. SMSS is way better than SQL 2000 Enterprise manager.You can slso just execute[code]EXEC sys.sp_configure N'remote access', N'1'GORECONFIGURE WITH OVERRIDEGO[code]
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
ERROR 53