I am looking forsomeone with patience to step me through sharing an mdf file on a Windows 7 laptop withe a vb 2010 Express application on an xp laptop. I am using sql 2008 R2 express on the W7 laptop and have enabled TCP/IP and SQL Browser.
I have allowed SQL Server Port and SQL Browser through the firewall on W7. I have given a Guest login a server role of sysadmin. My W7 laptop name is "BandMJ-PC" and both laptops are connected via ethernet on a workgroup called BAAWGROUP. I am
able to file share between the laptops. I feel my problem stems from the connection string which is:
""Data Source=BandMJ-PC\SQLEXPRESS;Initial Catalog=" & FileName & ";uid = Guest; User Instance=False"
Where FileName is the path and pfile picked up from the vb OpenFileDialog on the application running on the xp laptop.
I get the "Logon failed for user Guest" message. I hav ...
Go to the complete details ...