Sunday, February 19, 2012

Help me please about username and password

How to set user and password connect to Database server from other program
when Sql server 2000 authentication by Windows ?
And How Change Windows authentication to Sql server authentication.
To connect via a different user and password you have to modify the
connection string that you are connecting with, but thats only valid
for SQL Server Authentication.You can=B4t specify the Windows user and
password as though this is Integrated Authentication. As you didn=B4t
state how (with which program etc) you are connecting its hard to give
you a suggestion for that, but if you are using the .NET Framework you
could start a new thread and impersonate the thread as a special
Windows user, then you could use impersonation even you are logged on
with a different user.
HTH, jens Suessmeyer.

No comments:

Post a Comment