<div>
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. &nbsp;Either way, you just need to click connect on the login prompt.
</div>


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.

<div>
I need details to connect with windows authentication. What user? What password? 
</div>


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

<div>
this can be really helpful<br />
<br />
<a href="http://support.microsoft.com/kb/247931" rel="ugc nofollow">http://support.microsoft.com/kb/247931</a><br />
<br />
good luck...shouldn't take you long at all
</div>


this can be really helpful

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

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

<div>
Ok.... I want &nbsp;windows authentication in a remote pc to acces wia the sql server management studio. There is no web site involved<br />
<br />
Any ideas, what am I missing?
</div>


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?

<div>
Glad I could be of any help !
</div>


<div>
<div class="content wysiwyg-content">
I connect remotely to may SQL server.<br />
<br />
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.<br />
<br />
Can I have this set so I do not have to write my user and password every time I want to do something<br />
<br />
or<br />
<br />
Can I setup a Windows authentification for a remote machine to acces the SQL server?
</div>
</div>


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?

windows vs sql server authentification ms sql 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.