windows vs sql server authentification ms sql 2005

Posted on 2007-10-06
Last Modified: 2010-03-19
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


Can I setup a Windows authentification for a remote machine to acces the SQL server?
Question by:robrodp
    LVL 42

    Expert Comment

    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.

    Author Comment

    I need details to connect with windows authentication. What user? What password?
    LVL 16

    Expert Comment

    this can be really helpful

    good luck...shouldn't take you long at all

    Author Comment

    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?
    LVL 18

    Accepted Solution

    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 ...
    LVL 18

    Expert Comment

    Glad I could be of any help !

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Suggested Solutions

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now