January 14, 2007 at 8:30 pm
I have SQL Server 2000 Developer Edition set up on an old machine with a Windows 2000 Server OS and it seems to be working with no problem. I have a new PC with Windows XP Professional Edition and I recently installed SQL Server 2000 (DE) on this computer, but am unable to export data from a remote SQL database to the local machine. When running the DTS package, it exports objects, but no data. I get an error message that is:
[Microsoft][ODBC SQL Server Driver][SQL Server]SQL Server specified owner name 'name' either does not exist or you do not have permission to use it.
Any help anyone can provide would be greatly appreciated. All I'm trying to do is create a backup of my remote SQL database to my local machine. Thanks!
January 15, 2007 at 3:40 am
Have you tried doing a backup and restore? That many times can be easier. When trying to move an entire database I get into problems with relationships.
Do you have logins in the Server database server that have not been created in the XP database server? Also, if you have users in the database, do they link up to the logins in the server. I look in the "user" section for your database. Every user in that list (except perhaps dbo and guest) should have a login listed. If not, then you need to create a link from the login to the user in the database.
Russel Loski, MCSE Business Intelligence, Data Platform
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply