June 28, 2004 at 9:59 am
Hi,
I have a fairly new server and I keep experiencing the same problem. When using enterprise manager (i've tried different client pcs) I get 'Communication link failure' when trying to alter a table. This server isn't part of a cluster.
I know I can script this but is this the start of something more serious?? Any suggestions please ....
Thanks.
June 28, 2004 at 10:15 am
Check your timeouts.
Also how are you connecting to the server? Named pipes? Try changing to/adding TCP/IP. Are you connecting using the IP address or a DNS name? Check your DNS resolution. Is your network slow? Is the subnet on the server correct? Is the server's IP address static?
Just throwing out a few ideas.
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 28, 2004 at 10:34 am
Thanks for your reply...
Timeouts are as for any other server. TCP/IP is there. Tried connecting by IP but same problem. Subnet is correct. IP is static.
This happens locally on the server too...
E.
June 28, 2004 at 10:51 am
TCP/IP should be setup in the client network utility under sql server group. Just having TCP/IP present (loaded on the workstation) is not enough.
Create an entry in the network utility cross walking that server to an ip address. Otherwise SQL will default to using named pipes which can be very slow depending on your network configuration.
June 28, 2004 at 12:02 pm
On the server with SQL Server installed:
Open Enterprise Manager
expand the tree until you see the instance
right click on the instance
select properties
on the General tab, click on Network Properties.
In the right window, what Protocols are listed? TCP/IP needs to be there. Select TCP/IP and click on Properties. Make sure the settings are correct.
-SQLBill
June 29, 2004 at 2:48 am
All of these settings appear to be OK or certainly as for other servers with which I don't have a problem. Also, the problem also occurs when logged on to the server and running enterprise manager.
I had a look in the logs (perhaps I should have done this first!) and found the following for the time I was trying to alter a table:
Error: 0, Severity: 19, State: 0
language_exec: Process 52 generated an access violation. SQL Server is terminating this process
Any thoughts?
June 29, 2004 at 6:51 am
Any errors in the Windows Event Viewer logs?
Would you please re-check permissions and confirm that you have permission to access the database, the table and to alter the table?
-SQLBill
June 29, 2004 at 7:05 am
yes I do, I'm sa and can make changes in query analyzer it would appear that I can't make changes via em wherever it may be installed.
Also, I've just right clicked to go to properties on a number of databases and get error 0. SQL-DMO error - but that is all that it says.
June 29, 2004 at 12:44 pm
This isn't the exact error, but check this out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;327424
Are you using network library protocol?
http://support.microsoft.com/default.aspx?scid=kb;en-us;312948
I suggest applying the latest MDAC on each of your systems. But first download Component Checker from Microsoft:
Run this on your SQL Server, that will show you what version is there. Then run it everywhere else and make sure the versions are the same as on SQL Server. If not, load the correct version.
-SQLBill
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply