Connect to SQL Server 2000 using Windows NT authentication

Administrator

23y2k

Almost all the articles that i had came across so far only teach us how to create a connection to SQL server using the SqlConnection by providing the User ID and password. If I am not mistaken, this way of connecting is through SQL authentication right? What I would like to know is that how to change the SqlConnection command so that it reflects the Windows NT authentication? I know that through the SQL Server Enterprise Manager we can add a linked server and login using 2 different ways. One of the login command is something like this : exec sp_addlinkedsrvlogin 'Accounts','false','Domain\Jack','JackP','Password' This command ensure that only the Windows NT user Domain\Jack connects through to the linked server. I wonder how this could be done using C# or is it possible to be done in C#. Thanks for the attention in advance.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Administrator23y ago
When you utilize windows auth, you no put userid/passwd in connection string because windows utilize userid/password of the user actullay logged in windows session, that is, using your example, your notebook is trying to login into sql server with userid=A2 and password=P2. Of course, using Sql Server's enterprise manager, you must add the username to the database's users. Without this, sql server deny access to databases info. Federico
+1
Administrator23y ago
I still have some queries about this connection method. Dont we have to enter any login name and password in the connection string? Then how do the server that we are connecting to know whether we are the authorized ones? But I have one theory of mine which i am not sure whether is it correct or not. Let me share it with you. First of all, we install an SQL server somewhere in a remote server of which runs in a Windows NT platform. So we assume the administrator ID and password to login into windows for that server are A1 and P1 respectively. Then for the SQL server 2000 installation we register it using both windows and SQL authentication which by now we have another user id and password (i put it the user id as sa and password as pwd1). So, then I have another notebook (running Win XP Pro) which i install SQL Server 2000 as well using the same setting as the previous one (using both authentication) and the user id is sa and password is pwd2. And the windows login id and password for that notebook are assumed as A2 and P2 respeectively. As for now I have successully login and access the data from my notebook to the remote server using the connection string below: SqlConnection conn = new SqlConnection("Data source=server;user id=sa;pwd=pwd1;initial catalog=myDB"); which by my guess is using the sql authentication for that remote server. I try to use the connection string that you have provided but it has failed to login and retrieve any data. So what actually confuse me is why isn't there any parameters for me to key in the user id and password (A1 and P1)like when i login to windows for that remote server? (since i would like to access using windows authentication) Please help me out. Thanks
+1
Administrator23y ago
You need to use Integrated Security=SSPI in connection string. Here is connection string private string ConnectionString ="Integrated Security=SSPI;" + "Initial Catalog=;" + "Data Source=localhost;"; Sample: http://www.c-sharpcorner.com/Code/2002/Mar/CreatingDBProgrammaticallyMCB.asp
+1