I have upgraded SQL SERVER 2000 standard edition server to SQL server 2008 with SP1 standard edition. No errors noticed. OS is Windows server 2003 with sp2, Service accounts
are configured using domain user account, and mixed mode authentication is enabled.
Both windows and SQL authentications are working fine from the local (server), able to access all SQL server resources.
Server is accessible remotely using SQL authentication, but unable to connect with windows authentication, though user has local admin and SQL admin rights on the
Let me know any solutions for this. Appreciate your support
View Complete Post