February 3, 2015 at 11:08 pm
On the server computer, I have installed SQL Server 2008 Express, I set the firewall rules for TCP and UDP port, I configured SQL Server in Mixed Authentication Mode. I set SQL Server for remote connections. I enabled TCP/IP in the list of Protocols and and set the TCP/IP port to 1433.
On the client computer, I have installed SQL Server client connectivity SDK.
On the client computer with Windows XP, all works fine, I succeeded to connect to the SQL Server from my server computer.
On the client with Windows 7, when I try to connect to SQL Server through SSMS, the SQL Server instance was detected, but when I try to connect, I received the following message:
"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)."
On this computer, the user has admin rights. I also try with firewall disabled. Same message.
In the network, I don't have a domain, the computers are all in the same workgroup.
Please, I need your help, I don't know what I do.
February 3, 2015 at 11:49 pm
You are trying to connect using Windows or SQL Server authentication?
With Thanks,
Satnam
February 3, 2015 at 11:57 pm
With Windows authentication. On Windows XP all works fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy