Thursday, March 8, 2012
Another Login after restoring database
I have created a backup of a database and Restored as a new database in another machine.
Primary login of the database was X , now after restoring as a new database I dont want X as the login name i want it to be Y ...
how to do that ?
I can create other login as y and Give necessary premissions...but the Problem is i have to manually issue all the permissions to the new user which i feel is a time taking process.
Please let me know about it..
Thanks and Regards
saiI am not sure but u can try this :
script the login and user for the database in question,after generating the script for the user X,delete the the user X from the database ,Replace the user/login name X from the script with Y and run the script on the database.
I think this should work after some enhancements in the script.|||Use roles!
Or sp_change_users_login SP
Monday, February 13, 2012
Analysis Services Migration Wizard
I backedup an SQL2K OLAP database. Learned that I can not use the cab file to restore it to an SQL2005. So I've restored it to another SQL2K. Now I am trying to migrate this to my 2005. Here are my tests and results.
1. Welcome screen works fine. :)
2. I have severel SQL2K servers here which have their OLAP services running.
a.) SQL 2000 Source Server: xxxxxxxxx (no such server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .
b.) SQL 2000 Source Server: SABRI (right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .
c.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: ActiveX component can't create object
d.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: xxxxxxxxx (no such server)
Error: Source server: ActiveX component can't create object
e.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: (local) (got bored of typing AATIK)
Error: Source server: ActiveX component can't create object
I've also tried "localhost", ".", "aatik", "aatik\aatik" etc. for destination server.
Is it a bug in Turkish for letters I and i ?
By the way SP1 is installed.
Thanks.
You can take destination out of the picture by specifying script file as a destination.
Looks like you are having problem connecting to AS2000 source server.
Take a look if you can access AS2000 sever remotely. Can you access it from Analysis Manager running on another machine?
You also have an option of running AS2000 and AS2005 on the same machine.
You can rename your AS2005 sever to become a named instance. Install AS2000 locally, restore your databases and then migrate a databases.
Uninstall AS2000 and then rename back AS2005 to be a default instance.
To rename AS2005 instance you can use ASInstanceRename.exe located in your C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE folder.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Edward.
Tried the scriptfile option but again got the same ActiveX error message.
Analysis Services Migration Wizard
I backedup an SQL2K OLAP database. Learned that I can not use the cab file to restore it to an SQL2005. So I've restored it to another SQL2K. Now I am trying to migrate this to my 2005. Here are my tests and results.
1. Welcome screen works fine. :)
2. I have severel SQL2K servers here which have their OLAP services running.
a.) SQL 2000 Source Server: xxxxxxxxx (no such server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .
b.) SQL 2000 Source Server: SABRI (right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .
c.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: ActiveX component can't create object
d.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: xxxxxxxxx (no such server)
Error: Source server: ActiveX component can't create object
e.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: (local) (got bored of typing AATIK)
Error: Source server: ActiveX component can't create object
I've also tried "localhost", ".", "aatik", "aatik\aatik" etc. for destination server.
Is it a bug in Turkish for letters I and i ?
By the way SP1 is installed.
Thanks.
You can take destination out of the picture by specifying script file as a destination.
Looks like you are having problem connecting to AS2000 source server.
Take a look if you can access AS2000 sever remotely. Can you access it from Analysis Manager running on another machine?
You also have an option of running AS2000 and AS2005 on the same machine.
You can rename your AS2005 sever to become a named instance. Install AS2000 locally, restore your databases and then migrate a databases.
Uninstall AS2000 and then rename back AS2005 to be a default instance.
To rename AS2005 instance you can use ASInstanceRename.exe located in your C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE folder.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Edward.
Tried the scriptfile option but again got the same ActiveX error message.