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 |
|
ddouglas
Starting Member
1 Post |
 Posted - 2007-11-03 : 04:11:19
|
| I already asked this question at the MSDN forums, but I'm asking it here because I got conflicting answers.I want to configure my server to allow remote connections. For some unknown reason, I'm unable to do this with the Surface Configuration Tool. My understanding is that I can accomplish this using the sp_configure stored procedure. Is this correct? If so, can someone please give me an example of the correct syntax? BTW, I'm running SQL Server 2005 on winxp pro sp2.Thanks in advance. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-11-03 : 18:11:44
|
| there is a remote access entry that should do the same as the surface area configsp_configure 'remote access', 1There may be other things stopping remote connections though.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-03 : 20:12:20
|
| Start sql server browser service. |
|
|
|
|
|
|
configure a server to allow remote connections?