Hi,

SQL 2005 has option to block remote connection, make sure that "Allow Remote Connection" is enabled in SAC Tool

Steve,

True still there are lot of CRT's mainly used in home computers... Not sure about USA but I'm sure of the same in developing countries like...

Steve,

For Eco-Friendly we need to click the Eco-Friendly version link in the main page which will bring full black window. So normal CRT monitors will consume...

Try running the same query in SQL Plus directly connecting to Oracle Database and see whether you are getting same error. If the same error is coming then you need...

Hi,

This is how it goes... When we create DNS alias of old hostname to point to new server, TCP/IP connections will work but not Named...

Hi Manu,

No manu.. actually the aim is that there should not be any change in the application code or client that's why we create a CNAME...

Hi,

Just noticed that "smartbiz" is a database and not server is it? It is supposed to be instance name... Below is the sample code

EXEC sp_addlinkedserver...

Hi,

I had already done sp_drop.. sp_add and rebooted the server so that both of above commands are returning same new name.. 🙂

Anyways thanks for...

Hi,

AFAIK we cannot specify WITH (NOLOCK) when you are querying linked servers.. So which means the locking options won't work while querying linked...

Hi,

It is pure Memory Pressure problem which we also have faced.. Above said is one of the quick & easy & effective option.. Incase...

Hi,

You should make the @useself parameter to TRUE this will impersonate local logins to connect to remote server.

exec sp_addlinkedsrvlogin 'remotesrv', 'true'

Hi,

Run Profiler on this SQL Server and try to see from which client you are getting this error.. Take help of network...

Hi,

Old server is already retired. DNS is updated since it is almost one week since this server is live now... Also SP4 is there...

Hi,

Just check my reply above your reply, I have attached the rdl file... Sorry for the inconvenience...

Hi,

1) Share the folder in the HR Prod Server where .bak files are present.

2) In the security of the sharing give read permission to...