MakeDatabase command line - erroring out

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

MakeDatabase command line - erroring out

Postby Sue_W » Mon Feb 04, 2008 11:47 pm

I am trying to run our sql packager 5.4 executable on a Windows Vista OS with SQL Express 2005 using command line. I ran the same executable successfully on other installations of Vista/Sql Express but not this particular computer. The executable creates the database with username and roles fine: however, an error pops up immediately after saying that the username / login already exists. I know that the login does exist on this machine and is applied to other databases. I tried deleting the login and users from the other databases but I still get the same error message. It almost appears to be a permission issue but I ran the command line with a sql authenication that has sysadmin priviledges.

There is a reference to (sp_grantloginaccess N'UserName') as part of the error.

The windows user is an administrator on their machine.

Does anyone know what else this could be?
Sue_W
 
Posts: 4
Joined: Mon Feb 04, 2008 11:25 pm

Postby Brian Donahue » Sat Feb 09, 2008 10:56 pm

Hi Sue,

It sounds like the problem that you always have with Packager migrating Windows database users from one machine to another. Packager picks up the difference in the machine names as a difference, but the SQL Server only sees the user names and can't create the login.

My best advice is to exclude all user and role objects from the database and use the SQL Options to ignore all permissions. If the user has no explicit permissions in the database, you can try tracking down the role memberships for the user and remove them as well as the user itself.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Sue_W » Mon Feb 11, 2008 5:10 pm

Hi Brian,

I read your reply and I tried removing the login and user from this sql server and the install still fails. It's not an option for me to remove the login, user, role and permissions from this executable as a general rule we are creating new single databases and need those. The odd thing about this issue is that we successfully installed the same package on another user's machine with the same OS/Sql setup and the user also had pre-existing databases with user, etc already installed.

I appreciate the help.

Thanks!
Sue_W
 
Posts: 4
Joined: Mon Feb 04, 2008 11:25 pm


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests