Post reply

howto install for access across internet in a non-domain setting?

  • June 21, 2007 at 12:45 pm

    #174192

    I am trying to access my sql server from a different location without a domain controller across tcp/ip.

    So far I know to:

    Open port 1433 in the firewall

    enable remote connections

    What else?

    What service account do I set up sql server to use? network?

  • June 21, 2007 at 3:21 pm

    #714465

    You would need to create a local admin account - create a normal local account then add it to the local admin group - for your sqlserver service. If your sql server instance is for let's say unit testing purposes only then you can use the same account for your sql server agent service. The integration services service runs under the network account and you need it to be up and running even you're not using ssis: your database maintenance plans use that service. However, for a complete description of how to define service accounts please read my yesterday post at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=375444#bm375453

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply