I have a database that runs sql 7. Most of our workstations are running on a windows 98 platform, however, a few are running windows 2000. I am trying to set up a new sql registration in enterprise manager, but the connection is failing. All of the 98 machines are logging in with a sql user name, but I was told to log the 2000 machine as a NT server. If you can understand what my problem is, could you please advise me?
thanks :confused:What's the error you're getting? "Server doesn't exist or access is denied" or something else?|||It really isn't a error. IN the final box where you click finish, it says "SQL-unable to establish a connection, registration failed"
thanks
joyce|||You trying to register a 2000 server in 7.0 EM ?
Aint gonna happen !!!|||I THINK what they meant was that the Windoze-2000 machine should connect to your SQL 7.0 Server using NT authentication. If that is the case, In the "Connect Using" dialog you should use the NT Account instead of a SQL Login like you use on your Windoze-98 machines.
-PatP|||I THINK what they meant was that the Windoze-2000 machine should connect to your SQL 7.0 Server using NT authentication. If that is the case, In the "Connect Using" dialog you should use the NT Account instead of a SQL Login like you use on your Windoze-98 machines.
-PatP
Yes that is what I mean.
I did use the NT auth, but it still won't connect, any other ideas??
thanks
joyce|||My first guess would be that you need to enable NT Authentication (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp) for the NT login that the user of the Windoze-2000 machine will be using.
-PatP|||Well I thought it was enabled, is there a way to tell whether it is or not?|||Check in Enterprise Manglerto see if you can see the user's NT login in the list that is under the Server | Security | Logins.
-PatP|||ok, yes, the NT auth. is enabled. The user says NT user under type.|||You should check server properties for authentication. It's also not a dynamic property, which means Configured maybe different from Running (needs service bounced)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment