General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
>I was mistaken in my previous message. I was using SQL Server authentication for connection
>
>Here is what I found in my notes of how I get it done:
>
>1. Enabled Mixed Mode of Authentication (SSMS -> Properties -> Security)
>2. Enable the TCP/IP protocol using the Surface Area Configuration Utility In SQL Server 2008 this is part of the SSMS
>3. Add new log-in (in SSMS Security -> Logins -> New Login. Set new login to have SQl Server Authentication.
>4. Give this new log-in permissions to your database.
>
>That is pretty much what I did and it worked.
>
>Let me know if I can help more.
Thank you, I will try SQL Server authentication.
BTW, how do you build the connection string to connect to the SQL server? If a user has to enter a password for the SQL server authentication, do they enter it when they login or you have some sort of config file where you keep the connection information? I am struggling with the security part. Another question are you keeping your connection open throughout the life of the application?
Thank you again.
>
>
>>>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