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

Question

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 1

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!

Answer 2

It is easy. MS SQL Server password Unlocker can instantly reset the sa password.

Answer 3

Hi,



In this case, it does not matter if you have set your windows password or not. Every sql database has a default user named 'SA'. To connect remotely, following connectionstring will do a great job:



ConnectionString=(value="Provider=SQLOLEDB;Data Source= Office_server_ip;User ID=sa;Password='';Initial Catalog=Database Name;Trusted_Connection=True");



I hope it helps you.



Good Luck.