remote connection to SQL server issue
Posted on 2009-05-09
Im using SQLAPI++ to connect unmanaged c++ to sql. On local machine works perfect. I can get as many instances open as I need all looking at the SQL, all connections fine.
I then setup sql server 2008 to handle remote connections by enabling Named Pipes in the configuration manager and restarting as I learned by default it doesnt allow remote connections.
from another machine i want to connect to the database. I can ping the server CAVIARIS the code sees the server but the logon fails? I dont have any passwords, its windows authentification, I dont care about what authentification it has to be so if I need to change tell me.
It fails by saying Logon failed for user CAVIARIS\Guest
I want a number of machines to connect to SQL but Im stuck on the connections. Do I have to do something in Serrver Management studio? ie do I have to create a logon before I can go to the client machine and logon, is that the basic philosophy of how this works?
I need a generic logon for any machine that accesses SQL database, Im hoping I dont have to manually create a new one each time as Im trying to make a cluster of servers all see the same database. Can someone please walk me through a procedure to get me connected. its XP machines are in a network workgroup configuration.
Ive tried scores of combinations but I think Im missing a more general point, thanks