Puiu Posted May 31, 2007 Posted May 31, 2007 Hello, Is there a way to configure the SSMSE (SQL Server Management Studio for Express Edition) to connect to a database server using a proxy? I have the SSMSEE installed on my computer and I want to connect to a remote database but I want to use a proxy to do that. thanx Quote
Administrators PlausiblyDamp Posted May 31, 2007 Administrators Posted May 31, 2007 It would be potentially possible to get it to talk out through a firewall / proxy at your end if SOCKS proxying was enabled but you would probably need to use a tool like SOCKSCAP to enable SSMSE to work with it. Depending on what was then between your connection to the internet and the actual installed copy of SSE you would need further configuration to allow the relevant ports to access the installation. If the database is being hosted by a 3rd party ISP then then chances of this being allowed are virtually zero as it is potential security risk for them, if the DB is being hosted by your own company then you would need to speak to your network admins about gettingthe firewall / proxy configuration modified. It might be helpful if you gave a bit more detail as there may be an alternate solution. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Puiu Posted May 31, 2007 Author Posted May 31, 2007 the situation is a little strange: I have a sql server 2005 database on a remote server. The problem is that on that server there is also running a sql server 2000 instance. even if I specify the instance name in the connection dialogbox it never connects to the sql server 2005 instance (i get the error that says it could not find the server\instance). But it always connects to the sql server 2000. However if i connect from a different ISP the connection works. We couldn't find the problem exactly (if it's at my end or at theirs....). At first glance I'd say it's on my side but i don't know exactly where.... that's why i thought that if i could find a way to reach the server through another ISP (proxy) would work... Quote
Administrators PlausiblyDamp Posted May 31, 2007 Administrators Posted May 31, 2007 First thing that springs to mind is to check which ports are being allowed out as different instances will be listening on different port numbers. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.