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 |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2004-06-29 : 16:17:49
|
| User has dbo on all user databases. Goes into DTS annd creates two data sources. Adds a transform data task. selects SQL query in the source tab. Clicks the build query button and get an error ERROR SOURCE: Microsoft OLE DB Provider for Sql ServerERROR Description: Server {server name} is not configured for DATA ACCESS.Server is Win 2003 with Sql 2000 ent sp3a. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-29 : 16:23:00
|
| Is an error number provided?Tara |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-06-29 : 16:29:02
|
| This is the entire error message |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-29 : 16:30:51
|
| I couldn't find anything in Ms' knowledge base or by googling it. It could be another item turned off in Win2k3, like this one:http://www.jsiinc.com/SUBO/tip7200/rh7212.htmJust don't know what you'd need to turn on in Win2k3 to make this work.Tara |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-06-29 : 16:35:17
|
| Already have this turned on, and I can run distributed queries against this server. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-29 : 16:37:19
|
| Right, I just posted the link to show things are turned off in Win2k3 by default, a lot of things are turned off. Without the error number, it's hard to look this up in the Knowledge Base since nothing showed up when I put the error message in there.Do you have the security patch installed for sp3a? It has some bug fixes in there besides security stuff. Installed on both client and db server.Tara |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-06-30 : 04:06:25
|
| Had this problem on a linked server where i'm working currently... Never did get around to finding out what the problem was, the only thing I could find in a google search was a problem with FoxPro?!?! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-30 : 05:51:21
|
| I don't suppose its this little blighter is it?exec sp_serveroption 'MyRemoteServerName', 'data access', 'true'Kristen |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-06-30 : 11:07:04
|
| That fixed it. ran it on the server using the loacal server name. |
|
|
|
|
|
|
Error "not configured for DATA ACCESS"