New db permission errors

jrpucla

I am using SQL 2005 and NAV 4.0 SP3. I am not a dba so bear with me.

I created a new db. I imported the data I needed through SSIS. I don't need all of it and SSIS seemed simpler than dataports. When I go to login to the new db I get an error about the object table and permissions. I don't remember the exact error but I can't get ino the db at all.

When I check the new db, there are no users or application roles in the permissions area of the properties. I know they don't appear magically. My question is how do I get the users and application roles in the new db?

I tried to add them but the only things that show up are the guest user and the public application role.

Thanks in advance for any help.

stryk

Hi,

well, even though you are not a DBA I hope you have read the "NAV Installation & System Management (SQL)" PDF so that you have at least created the new database correctly, fulfilling all requirements.
Make sure you are using the "Standard" Security Model, this will reduce the amout of trouble.
Also, whenever you setup a new DB etc., make sure you are logged on to the SQL Server using a "sysadmin" role. Actually you should have taken care about the user/role setup - SQL site - even before importing the data ...

To transfer the logins from one SQL Server to another you could use this MS feature: http://support.microsoft.com/kb/246133

Once you have create the Logins on SQL Server, the you could create the Users in the DB (SQL site); then you could setup the Logins in NAV. Then "Synchronize".

Does this work?

Regards,
Jörg

jrpucla

I was able to remedy this on my own.

For future reference:

1. Create new db
1. Generate scripts from "copy from" database.
2. Run script on new database by changing the name of the db to the new db in the script
3. Run export on "copy from" database to new database