Try 10.1.1.100,1433

What happends if you run excel as an administrator?

In your first post you mentioned experiencing the problem when connecting via a program and you mentioned EXCEL as...

dbarkley (3/12/2012)

---

The error in the first part is from when I try using an ODBC connection using the IBM drivers that came with client access.

The second part is...

Howard, do you...

Yes! Check this link.

Still no error on the SQL Server Errorlog? You may also try enabling only the TCP/IP Protocol,...

Do you have the same problem when you use the IP address and the port number instead of the servername?

You may also try to connect the ip address and the port number instead of the Servername.

Hi Howard, could you please tell me if you are using Windows authentication or SQL Server authentication? Thanks in advance!

dbarkley (3/6/2012)

---

I have been trying to get linked tables working in SQL 2008r2 to an AS400 with very limited success. Can anyone help point me in the right direction....

hmbtx (3/11/2012)

---

I am running Windows Small Business Server 2012 (Windows 2008R2 OS) with SQL Server 2008R2 running on the server.

I have one XP client PC and 1 Windows 7 client...

In case you don't find the missing backup, you can restore a full backup again and leave the secondary database in restoring state.

Gmamata7, why would you like to use native backup if you are already using LiteSpeed? licenses? just wondering!

Could you please let us know if you were able to solve the issue? and if so could you please mention how you did it? Thanks in advance!