stay password in connection string

Hot Topic

Making our SQL Server 2000 application ready for SQL Server 2005
system error 126
How to call Integration Services Project from Web UI
Add a DateLoaded column to input data
Logical functions in SELECT clause
Please Help!!!
Memory allocation to SQL Server - AWE under 32 GB
What should the maintenance plans be on your mirror server?
Problems with sending Event Notifications to remote service
Can not connect to SQL Server

SQL Server

Formating bound data
Database Version
Failed to generate a user instance of SQL Server
How can I connect to SQL Server 2005 analysis services server programmatically?
Query:Source from multiple tables to a Fact table
How to hide a column in chart
Look up transformation
Fit dataset on one page
Oracle 9i -> SQL Server 2005: Initialization of table failes
Using ExecutionInstanceGUID as query paramter

stay password in connection string

Hi
after connect to SQL database from .NET the password is removed from connection string, what can i do for stay it in connection string
thank you




Answer this question

stay password in connection string

  • Vaxman2

    Use the 'Persist Security Info' keyword and set it to true, for example:

    "Persist Security Info=True;User Id=mysuser;Password=mypassword;database=northwind;server=mySQLServer"

  • stay password in connection string
Answer this question