Unanswered: Access SQL server remotely from a PC on the network.
I would like to access the tables inside SQL database from a networked computer. The main computer on which the server is installed is called MASTERPC.
The following is the connection string used locally on the PC. When I use the same string on any of the other PC connected to the network it produced error message.
<odc:ConnectionString>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Data Source=MASTERPC\MONSOON;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MASTERPC;Use Encryption for Data=False;Tag with column collation when possible=False;Initial Catalog=Monsoon</odc:ConnectionString>
To be specific I get the following error when I drop the connection file in Excel
SQL Server Error: 18456
Login failed for user 'MASTERPC\Guest'.