September 1, 2006 at 11:44 am
Has anyone had to access files on someones SQL Personal Edition from SQL server management? I don't think it is possible but this is a bit of a crisis here. A former employee developed several production jobs off of his personal edition on his pc. We have not had any luck yet. Any ideas?
September 1, 2006 at 12:19 pm
What exactly are you trying to do? You can map the drive and access the files that way...
can you use sqlcmd to access the server?
sqlcmd -?
Please EXPAND on what it is you are trying to do...
...Michelle
September 1, 2006 at 12:26 pm
we found that a user had placed a database, dts scripts and sp's onto his pc to run production jobs. Attempting to add a new server registration with Enterprise Manager has failed. It cannot find the pc even via the ip address.
September 1, 2006 at 12:37 pm
Can you PING his PC or remote desktop to his PC to get the files? You could use the sp_attach_db proc to recover it...
Just trying to grasp for ideas here :+)...
September 1, 2006 at 12:47 pm
I will have to let our IT director ping it. This is at a remote site outside of my firewall and within a different firewall. I was thinking that what we may have to do is make his pc a server, and upgrade him to standard then do a copy to a proper server. Any ideas?
September 1, 2006 at 1:07 pm
Try sqlping and see if you can ping the server...is the PC in the SAME domain as the your server?
http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
...Michelle
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply