General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
>What I had (and still have) is the same situation as you do, XP pro OS attempting to connect to SQL Server 2008 on Win 7. I only needed it for testing something so I don't have this connection working now. If I remember correctly I solved the problem by using Windows authentication. Let me see if I have any notes left from that test and I will provide you with more information later.
Thank you, I would really appreciate any information.
>
>>Hi,
>>Can you please share how you have solved the connection issue? I have SQL 2008 installed on Win 7 machine and want to run an application located on a laptop with XP pro OS, connecting to the data on the SQL server. I would prefer using windows authentication.
>>
>>Thank you in advance
>>
>>>Hi,
>>>
>>>I am stubbornly trying to connect my app from one computer to the SQL Server installed on another computer on my small LAN. With every step I think I am getting closer (just like to the horizon <g>).
>>>
>>>Anyway, in the last attempt I am getting a message "Login Failed for user 'ComputerName\Guest'" The "ComputerName is the computer where SQL Server 2008 resides. Since SQL Server is configured for Windows Authentication I am figuring (guessing) that SQL Server "sees" me as a "Guest" user. What do I need to change (in Windows Users or SQL Server) to make SQL Server 2008 allow the access?
>>>
>>>TIA.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only