If the above does no help, please change the service account for the SQL Server agent service to account with proper permissions. This may be happening because the service account for SQL Server Agent service is a local account.
When I browse through the Server properties, my 'Domain\User' account's Effective tab says that it cannot retrieve it user information. This happens whether I log into my machine as a local user or as a domain user.
Perhaps I am missing some settings in SQL server. I am using Windows Authentication with everything (code and DB) on the same machine. can you please provide mesome other pointer in this direction.
Warning SQL0: A project which specifies SQL Server 2008 as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12.
Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe, command: /setup Now is this part of cluster installation? have you entered valid key? Have you logged into system as administrator.?
I know what was wrong. I installed a codeplex version on another PC that uses the same SQL server. The codeplex version must changed the DB schema that the MS version doesn't support. I installed another SQL server, reinstalled the MS version and pointed to the new server, and now it works fine.
Do you get this error, when you run the task in BIDS or from SSIS? Also, have you used a program like HTTPWatch or Fiddler to see, what is being passed between the two systems?
I am trying to setup a linked server in my 64-bit instance of SQL 2008 to a Pervasive v11 database. In the past, this worked fine on another server. We moved the application to a Windows Server 2008 R2 unit running SQL 2008. When I attempt to create the link I get the following error:
I have two instances of SQL Server 2005. I have backup a database in once instance. And now trying to restore to another. Process worked fine for 2 of databases, but I got problem with one database. This one is 13GB big database. Others are small ones.
