Connect from WIN2000 TO WINNT/SQL2000 using WIndows authentication

Hello,

we develop on Powerbuilder 7.03. We want to use WIndows authentication to connect to a SQL server 2000 with WIN NT 4.0. as OS.
When I want to connect from my PC WIN2000 to SQL2000 with WINNT operating system, I can't ( login failed ).
but when I connect to my PC win2000 to a sql server 2000 with WIN 2000 OS, the connection goes well. ??
Someone encountered the same problem ?? and found a solution ??

Any help will be appreciate.
Thanks in advance.Try this - talks about Windows NT and SQL Server Security

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modadmin/html/deconwindowsntsqlserverlogins.asp|||Originally posted by ascollins
Try this - talks about Windows NT and SQL Server Security

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modadmin/html/deconwindowsntsqlserverlogins.asp

Thanks for your reply.
My connection from NT to WIN2000/SQL SRV2000 is OK. my problem is I can't connect from WIN2000 to WIN2000/SQL SRV2000 using windows authentication with PowerBuilder 7.03.

connect

Hello,
I'm having the strangest problem.
SQL 2000 on a Win 2003 server.
I'm trying to connect via the query analyzer to the sql server on
another box. It was working all fine yesterday. Actually, it didn't
work initially. But I restarted the service MSSQLSERVER and I was able
to connect.
I can ping the SQL server IP. I can even ping it by the computer name,
WINBOX. The SQLServer is named WINBOX too.
Any ideas?BTW I looked at this KB article http://support.microsoft.com/?id=328306
and none of that seems to be my situation.|||Interesting find today.
If I log in or map a drive on the win 2003k machine I'm fine.
But if I don't I get an connection error.
This is beyond the my access rights to the SQL server itself.
Won Lee wrote:
> Hello,
> I'm having the strangest problem.
> SQL 2000 on a Win 2003 server.
> I'm trying to connect via the query analyzer to the sql server on
> another box. It was working all fine yesterday. Actually, it didn't
> work initially. But I restarted the service MSSQLSERVER and I was able
> to connect.
> I can ping the SQL server IP. I can even ping it by the computer name,
> WINBOX. The SQLServer is named WINBOX too.
> Any ideas?
>

Configure SQL server client

Hi,
I have installed MS SQL Server on a win XP and a MS SQL Server client on a win2000. I dont know how to configure this client to access the server remotely.
Any pointer?
Thanks.
I am very new to SQL Server.That's kind of a backward installation isn't it??

On the client, you need to go open Enterprise Manager.
Expand the Microsoft SQL Servers.
Right-click on SQL Server Group and click New SQL Server Registration.
When you get to the area that says "Available Servers", type in the name of the machine with the SQL Server.

You should then be able to access it.|||Thanks.

I tried and I always get:

Login failed for null. Reason: not associated with a trusted SQL server connection.

If I provide a user it would say: Login failed for xxx.|||Are you on a domain? If not, go to the sql server and set up a SQL Server username and password, giving it the access you want or grant MACHINENAME/username access to the SQL Server.

If I provide a user it would say: Login failed for xxx.

Was this a SQLServer username and password, or an NT username?|||Make sure you have the following Security Settings on your server.

Note: Here, the Windows User is the local user account that is used to connect to your instance of SQL Server.

1. Click "Start", point to "Settings",and then click "Control Panel".
2. In "Control Panel", double-click "Administrative Tools".
3. In "Administrative Tools", double-click "Local Security Policy".
4. In the "Local Security Settings" window, in the left pane, expand
"Local Policies", and then click "User Rights Assignments".

Also you can use sql standard user to connect to the database. In this case make sure that your sql server authentication is set to mixed.|||>> In this case make sure that your sql server authentication is set to mixed

How to do this?
I am using SQL Server 2000 developer edition.
Thanks.|||Its part of the set up procedure for SQL Server. You change in Enterprise Manager. Open EM on the box the server is on. It should already be configured/registered to access the server. Right click on server name and go to properties. Click on the Security tab. Under Authenication, select SQL Server and Windows. That's Mixed Mode, meaning it will allow Windows Authenication mode (obviously) as well as logins defined in the database.

To define your own login to the DB, go to security in the expanding tree. Then click on Logins. Right click on the blank space in the right pane and select new Login. Type a name, and select SQL Server Authenication, then type a password. On the next tab (Server Roles), check the System Administrators box. Now click OK.

Go back to your dev box. Open EM and do the registration process for the server using the username and password you just created.

Let me know if any of this isn't clear. Its late on a Thursday, so its about time that stuff makes sense in my head, but when it makes it out, I end up confusing others to no end.

Thanks,
Tim C|||Thank you all!
I got my client to talk to server following your instructions.
Thanks Tim!