User-1958576363 posted
Hmm. Still no go. I had the first server generate the following:
/* For security reasons the login is created disabled and with a random password. */
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'u_iptracker')
CREATE LOGIN [u_iptracker] WITH PASSWORD=N'ðÎûÈ52Ü“:ƒ”¨‚n:3#”’wÑ¡VC*u=', DEFAULT_DATABASE=[IPTracker], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON
GO
ALTER LOGIN [u_iptracker] DISABLE
GO
USE [IPTracker]
GO
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'u_iptracker')
CREATE USER [u_iptracker] FOR LOGIN [u_iptracker] WITH DEFAULT_SCHEMA=[dbo]
But when I execute it on the second server, it runs, but I still get the same permission issue when I open the DB properties, Permissions, select u_iptracker and click Effective Permissions button. The error is:
"Cannot execute as the database principal because the principal "u_iptracker" does not exist, this type of principal cannot be impresonated, or you do not have permission. Error 15517"
The script has created a login for u_iptracker, but it is not mapped to the database. When I try to map it to the database, I get the following error: "User, group, or role 'u_iptracker' already exists in the current database Error: 15023"
So, I can't clear u_iptracker from the Permissions tab in the database properties, and I can't map the login u_iptracker to the database.
Score: SQL Server Express 2005 1 Me 0
What am I leaving out? Any help would be appreciated! Thanks!
