Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-11 : 07:34:22
|
| Daniel writes "I want to reigster all my SLQ instances(7 and 2000) to a Server running Sql 2000 with W2K. So all my team member can share it. By doing this, I only need to register a new instance once and be shared by everyone. I followed the steps provided in the online help and made it work only if the remote server runs NT 4 with SQL server 2000. I can not get it work on W2k and Win 2003 running SQL Server 2000. I am using my own NT Id which has Admin priv on that remote server. The SQL Server group created on the remote server shows up. But there are no items under the group name. Thx a lot for your help. Daniel" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-11 : 07:36:59
|
| Anyone who registers a SQL Server via Windows Authentication requires access and permissions to that SQL Server. If they don't have those permissions then you'd have to create a SQL login that they can use to register. And unless your team members are all administrators (i.e. they make backups, set up replication, create new databases) they should not be using Enterprise Manager at all. If all they will be doing is developing code, all they need is Query Analyzer. |
 |
|
|
|
|
|
Share Server Rigistration Information