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 |
|
imsganesh
Starting Member
28 Posts |
 Posted - 2005-04-21 : 21:00:20
|
| Hi All,I am having Windows 2000 server Operating Server and Microsoft SQL Server 2000. My Server/SQL server name is 'PlanDB'When I tried to open the Build Query in the DTS Package, i m getting this error message "Server '' not found. Use sp_addlinkedserver to add server..". When i checked the sysservers table, there was no record for the local server. I don't know how did i lost the record for the local server in sysservers table. So, I added a local server using sp_addserver procedure. Now when i open the Build query window, I m getting this message "Server 'PlanDB' not configured for DATA ACCESS". I don't know how to configure the local server for Data access.Please share you thoughts asap & help in solving this problem.Thanks!Ganesh S |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-21 : 21:01:57
|
| Use sp_serveroption, it's documented in Books Online. |
 |
|
|
imsganesh
Starting Member
28 Posts |
Posted - 2005-04-22 : 13:31:36
|
| Thanks Rob! It worked! But is it the sp_serveroption should be used with Linked/Remote servers only (as it is mentioned in Books online? Anyway, its working for local servers also. Just want to know this!Thanks |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-22 : 19:09:48
|
| Yes, it works on local and remote/linked servers. |
|
|
|
|
|
|
Problem with Sysservers table!