Tagged Questions
6
votes
4answers
682 views
Connect to SQL Server behind NAT from remote machine
The scenario is that this is a SQL Server behind a corporate firewall with your standard setup to allow only minimal outbound traffic and zero inbound. However, port 80/443 are open, per the usual ...
0
votes
3answers
347 views
Can a RDBMS connect to a remote server, execute a select query and copy them into a local table just with SQL commands?
I'm sorry it may sound stupid but I've been wondering about how multiple databases are automated before the virtualization era. Can a DB Adminsitrator make a stored procedure to get data from a remote ...
3
votes
2answers
5k views
How to add a user with access to a single view?
I'm working with MSSQL Server Management Studio 2008 and I need to expose a view to a third party for their data reconciliation. I have created the appropriate view but I'm having trouble creating a ...
2
votes
2answers
146 views
Connecting to SQL Server 2008 on windows server 2008
Hell all
I am new to windows server 2008 and we are trying to transfer our website from hosting to virtual server.
I installed SQL Server 2008 Express edition and I did the things like opening port ...
2
votes
1answer
171 views
What do I need to sync a local site office SQL Server with the Head Office SQL Server
The company has a desktop application powered by SQL Server from the head office that is dependent on an internet connection to our remote sites. Usually when we move to a new site there is a good ...
4
votes
1answer
1k views
Remote Debugging
I'm having an issue with remote debugging. I have a non-domain server and a non-domain client PC. The client PC can successfully connect to the server and the instance, and it even runs SSMS as the ...
