Have you ever wanted to configure a remote database instead of using a local one in Microsoft Enterprise Desktop Virtualization (MED-V) but couldn’t find the steps on how to do it? If so this one’s for you:
1. First you have to make sure the SQL installation on the remote server is configured the following way:
- Instance Name: Default instance
- Service account: Use the built in user account
- Authentication mode: Mixed mode or Windows authentication.
- User: the default user created is 'sa'
- Password: <Desired Password>
- Collation Settings: default.
- Error and usage report settings: default.
2. Next comes configuring the MED-V server. The following files need to be installed on the MED-V server:
- Microsoft SQL server native client. This installs the prerequisites for the management objects collection.
- Microsoft SQL server management objects collection. This includes the required DLL files.
3. Then just configure the connection String used in MED-V:
Data Source=<ServerName>;Initial Catalog=<DBName>;uid=sa;pwd=<Password>;
That’s it; you should be good to go.
Hope this helps,
Steve Thomas | Senior Support Escalation Engineer