Thank you Ten Centuries:

Our networking dept. applied some patched to this server 4 days prior to the backups failing. A developer had been using visual studio on this server...

We don't have a SubscriptionID with Microsoft, we purchase Sql server licenses from a 3rd party vendor.. I'm still receiving the error however my co-worker found the following...

I'm getting errors that are somewhat similar to the above posts... Backups are failing with the following error: Wanting to open up a case with Microsoft.. Can...

Hi Everyone:

Can someone help me... I'm trying to use the free product Reporting Services Scripter (2.0.0.17). I installed it made sure the id that I was using...

Thank you for your reply,

I tried your second suggestion to create it in the input/export wizard and save it before it creates the ssis package.

I don't even get as far...

TCP.

Hello everyone,

Had to work on something else.. back to this now.. I set it up using the alias. I also have the ports open (1433 and a different one)....

I tried that but that does not seem to work, our firewall guy has opened the firewall. I have both servers set to allow remote connections. I have...

Entering telnet IP port works however when I try to enter this command "

select * from serverA.dbo.database1.tableA

I get the following error?

Msg 10054, Level 20, State...

Cath,

Ok so in the linked server definition under security you used a Local sql logon (impersonate)? And that created the connection for you? Do you have a firewall...

I never completed it import/export wizard since it would not take the destination server name. I figured I better get the connection working first.

Possibly... I'm in the initial stages trying to figure out how to define the connection first. Right now I'm defining a 'linked server'. I hope this the...

Hi Everyone,

I'm wanting to do something similar in SQL 2005. From Server A (in the network) I want to connect to Server B (in it's own DMZ); while on...