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
Related Q & A:
- How To Connect Two Different Network Segments Using A Switch And A Router?Best solution by Super User
- How to connect Sql Server Database from android app?Best solution by Stack Overflow
- How Do I Configure SQL Server 2005 Backend?Best solution by Server Fault
- How to connect to a Pervasive Database using javascript?Best solution by Stack Overflow
- How to connect a psp go to a PS3 controller using a computer?Best solution by eHow old
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
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.