I have a virtual server on a home machine. The network is a workgroup, not a domain, so I use SQL Authentication. When I run the following code:
I get the following message:
Cannot open database requested by login. Unable to login. Login failed for user "mylogin".
Here is my ConnectionString:
Dim ConnectionString As String = "Data Source=VirtualServer; Initial Catalog=Service History; User ID=myUserID; Password=myPassword"
Thanks in advance for any assistance!