Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

windows vs sql server authentification ms sql 2005

I connect remotely to may SQL server.

To export, import, make connections, etc it asks me every tiem for the login user and password. This login is an SQL server authentification. No matter that I clcik on save password.

Can I have this set so I do not have to write my user and password every time I want to do something

or

Can I setup a Windows authentification for a remote machine to acces the SQL server?
0
robrodp
Asked:
robrodp
1 Solution
 
dqmqCommented:
The system will always prompt for a username and password. If you click Save Password, then it is filled in automatically for next time. Or you can use windows authentication.  Either way, you just need to click connect on the login prompt.
0
 
robrodpAuthor Commented:
I need details to connect with windows authentication. What user? What password?
0
 
SQL_SERVER_DBACommented:
this can be really helpful

http://support.microsoft.com/kb/247931

good luck...shouldn't take you long at all
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
robrodpAuthor Commented:
Ok.... I want  windows authentication in a remote pc to acces wia the sql server management studio. There is no web site involved

Any ideas, what am I missing?
0
 
YveauCommented:
SQL 2005 has two security options:
1. Windows authentication only
2. Both Windows authentication and SQL authentication together.

So either way (you have option 2 obviously) Windows Authentication is possible !
All you need to do is add you domain account as a login and user.

Connect to the server and go to the security folder, open it and right click on logins.
Then select 'New Login' and fill in the login name (YourDomain\YourAccount), select the 'Windows Authentication' option and set the default database and language.
Then go to the 'user mapping' page and select the database and membership(s) you want.
Click OK to confirm and try to connect using the windows authentication ... it should work ...

Hope this helps ...
0
 
YveauCommented:
Glad I could be of any help !
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now