December 18, 2009 at 4:32 am
Hi Friends,
I have created a linked server in my 64 bit SQL Server to connect oracle.
connectivity is succeeded no issue but problem is while i m going to expand the linked server (to view tables in SQL server management studio)
it getting error of time out and system get hanged.
found below error in eventvwr is
(Timeout (30000 milliseconds) waiting for a transaction response from the MSSQL SERVER service)
my Server configuration is
4 CPU
10GB RAM
Regards,
Shivrudra W
December 18, 2009 at 4:57 am
Can you change the service start account to Local System and try staring the
SQL Server Agent service. Use SQL Server configuration manager to chnage
the service startup account.
December 18, 2009 at 5:31 am
SQL server and SQL server agent is allready running by Local system only...
Regards,
Shivrudra W
December 18, 2009 at 6:16 am
please help to resolve this....
Regards,
Shivrudra W
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply