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)
Showing posts with label workstations. Show all posts
Showing posts with label workstations. Show all posts
Wednesday, March 21, 2012
New sql registration
Subscribe to:
Posts (Atom)