How to upgrade sql server express 2005 to 2008R2?

How to connect sql server 2005 by using windows authentication from a client computer to a server?

  • I am a beginner of sql. I try to connect from my labtop (XP home) to my office server (server 2003) to access the database in the sql express. I am using Server Management Studio Express in my laptop, and using windows authentication, and connect to another computer (server) and access the server's sql server. (by the way, where to put username and password?) But it always failed and said i have no premission to access... why?

  • Answer:

    Windows Authentication in this case implies that you're going to pass on whatever you're logged into Windows with. If when your XP machine starts, you log in as user Fred with password 'lovesql', then that's what it's going to send on to the server through Windows Authentication. If you have a user set up in SQL, you'll need to instead choose "SQL Server Authentication". Then you can type in the user and password directly. But that will need to be a user that's identified directly in the SQL Server, not a domain account. Good luck!

wyeechen at Yahoo! Answers Visit the source

Was this solution helpful to you?

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.