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 |
|
MickG
Starting Member
4 Posts |
 Posted - 2003-12-04 : 08:47:09
|
| All the MSDN Detail I could find...Could not execute procedure on remote server '%.*ls' because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access.&Severity Level 17: Insufficient ResourcesThese messages indicate that the statement caused SQL Server to run out of resources (such as locks or disk space for the database) or to exceed some limit set by the system administrator.I'm try to do an insert on a remote server....does this mean its maxed out??? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-04 : 12:19:26
|
| Have you ever been able to execute the stored procedure remotely?And yes it means that it is maxed out.Tara |
 |
|
|
MickG
Starting Member
4 Posts |
Posted - 2003-12-05 : 03:24:43
|
| Hi Tara, Yes ...I have a development and integration enviornment.Its working fime on dev with the 'same' setup.Using the same sp & target db.Have checked the liked server properties & dbo access etc. Looking at services packs on the push servers now...any ideas? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-05 : 12:16:29
|
| Did you try rebooting the remote server?Tara |
|
|
|
MickG
Starting Member
4 Posts |
Posted - 2003-12-08 : 06:25:57
|
| No..Should this make a difference? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-08 : 12:16:00
|
| It would clear up the resource problem on the remote server. So would adding hardware. Rebooting the server will be just a temporary fix. Performance Monitor would be able to tell you where you are having bottleneck problems.Tara |
|
|
|
MickG
Starting Member
4 Posts |
Posted - 2003-12-08 : 12:27:56
|
| Only thing is ,it's working fine from the dev environment to the same server...looks like local setup rather than target.Trying to see if the service packs make any difference at the moment.Thanks & Regards Mick |
|
|
|
|
|
|
Server: Msg 7201, Level 17, State 4, Line 1