Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009

    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
    SQLSTATE: '42000'
    SQL Server Error: 18456
    Login failed for user 'MASTERPC\Guest'.

    I appreciate help.

  2. #2
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts