Announcement

Collapse
No announcement yet.

How to access SQL Application on workgroup

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to access SQL Application on workgroup

    i install SQL server 2005 on work-group server.
    i have application connect to sql server using ADO.net connection string but the error i have ConnectionString not initialized
    but is working if i access directly from server

    <Settings>
    <ConnectionString>Data Source=SQLServer;Initial Catalog=TestDB;Integrated Security=SSPI;Pooling=true;Enlist=false;MultipleAc tiveResultSets=true;</ConnectionString>

    </Settings>

  • #2
    Re: How to access SQL Application on workgroup

    What is the server OS (Possible firewall issues)?
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: How to access SQL Application on workgroup

      The OS: Windows Server 2003 std x64
      no firewall... local server


      i access application on local computer shared folder
      when i connect to shared the server ask user name and password i type local user name and password on that's server
      Last edited by bustanji83; 19th February 2011, 11:01.

      Comment


      • #4
        Re: How to access SQL Application on workgroup

        What sort of application is it -- web based or stand alone?
        What client OS are you using?
        Can you connect to the database OK using ODBC?
        Tom Jones
        MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
        PhD, MSc, FIAP, MIITT
        IT Trainer / Consultant
        Ossian Ltd
        Scotland

        ** Remember to give credit where credit is due and leave reputation points where appropriate **

        Comment


        • #5
          Re: How to access SQL Application on workgroup

          is stand alone application
          and after test i find when .exe run check the log in user and take log in user and use it to access the application
          since the log in users not part of local users of server the error appear so how can...
          i guess the solution in mapping the log in user with one on local server users.

          Comment

          Working...
          X