Post reply

SQL Server on home network

  • October 21, 2011 at 5:13 pm

    #245641

    I have a sql server set up on one of my computer at home and would like to access the server/db's with other computers. The server name is using the name of the computer plus the sql name I assigned [ComputerName]\[Server1]

    I can see this server from the computer is is loaded on with other applications (access/excel etc.) but not from another computer. When I try to do a query from excel from a different computer I get "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." I can share files between computers and use remote desktop but not sql.

    I think the issue may be the domain that it is assigning (computer name) so when I try to login from a different computer it is reading it as a different domain. Is there anyway to work around this?

    Thanks for any help.

  • October 21, 2011 at 5:50 pm

    #1398286

    SQL authentication.

    You don't have a domain that both machines are part of, hence you can't use windows authentication

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 21, 2011 at 10:52 pm

    #1398297

    Thanks, that is what I though just wanted to verify it.

    I appreciate the quick response!

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

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