Showing posts with label authentication. Show all posts
Showing posts with label authentication. Show all posts

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.

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.