I've been trying to find an answer to this to no avail. I'm not even sure if its possible. I like to do development at home in addition to work, like most of you do. Since it is my home computer, I like to play games, so I try to keep applications to a minimum. I would like to install sqlexpress on a virtual machine (which I have successfully done), and I can connect to it via Management Studio on my local machine (non-vm). Is there a way to set visual studio to use this connection as opposed to local host? I really do not want to load sqlexpress on my local machine and have yet another thing tying up system resources.
Your feedback is appreciated.
Barret
Visual Studio should use the same connection process (string) as SSMS.
Also, you have VM tying up resouces that are not then available to SQL or VS. Using a VM is an excellent way to constrain and protect various environments -as long as you clearly realize that you are consuming both VM and Client resouces. It is a small price for the compartmentalization, and has a performance hit. Often worth the performance hit, but use caution when setting benchmarks and performance timing...
|||The answer to the VS question is Yes and No.
If you are writing code to make a manual connection to SQL Express, you can happily use the copy of SQL Express on the VM. Make sure you have correctly enabled it for remote connectons since you are technically connecting to a different computer. If you are trying to work with the database integration features of VS that allow you to create database direclty in your project and work with them using User Instances, then you can not use the copy on your VM. User Instances are only supported via local connections, there is no way to configure VS to use a remote copy of SQL Express to support that.
Mike
|||Thanks Mike!Not the answer I was hoping for, but it is the answer I needed :)
Thanks again,
Barret
No comments:
Post a Comment