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 |
|
bandguy001
Starting Member
12 Posts |
 Posted - 2010-09-23 : 14:53:06
|
| Hi All,I want to run queries against multiple sql servers at the same time so I set up a central management server. The problem I have is that the 150ish databases I need to connect authentica via SQL authentication. When I try to register a new server in the server group I can only use Windows Authentication. Is there any way to use sql authentication? I tried adding mydomain\myusername but using windows authentication is not a viable option as there are about 50 users that need to access all 150+ db's. Any ideas? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bandguy001
Starting Member
12 Posts |
Posted - 2010-09-23 : 15:01:11
|
| is there any other way to query multiple servers with sql authentication? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Server 2008 R2 - Central Server Question