Unsolved
This post is more than 5 years old
16 Posts
0
4154
How to Change database :-)
Hi , :-)
Is there a specific documentation vworkspace to change the database (permission)?
After an initial backup of my database and restore on another Database (Other sql Server).
I encounter this message (SQL security is identical (dbo, pnadmin)).
(file, Database Configuration, New Configuration --> "Create Dsn only for Existing database"+ "configuration to my new base"
Yet
connection with "odbc" is Ok with sa and pnadmin(sql)
connection with sql mmc is Ok with sa and pnadmin(sql) + window authentication
Ps :this is SQL 2008-r2
+ Vworkspace 7.1
On my lab :-).
Denis.
DELL-Adam Dr
28 Posts
0
November 15th, 2010 13:00
Denis, the problem may be that the pnadmin user in the restored database is not properly linked with the pnadmin SQL login on the new SQL server. I would suggest contacting Quest support with this issue. They can instruct you on how to re-link the user to the login.
-Adam
svanbent1
13 Posts
0
November 15th, 2010 19:00
You will need to type in the following command
Exec sp_change_users_login ‘Update_one’,’pmfadmin’,’pmfadmin’
In the above example the first pmfadmin is the DBO account of the old SQL server and the second is the DBO of the new server. The names that you have may be different depending on your installation.
Hope this helps