SQL Server DB

[USHAGGAG]

I deleted the content server database from Sql manegment studio

now when i access to database adminstration page and write the password the error apear

i cteated new database and new user from admin page but how i can create a tables >>?

 

[ggriffit]

do you have a database backup ? you may need to reset the GUIDs as they differ on SQL Server even if the usernames and DBs have the same names.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[USHAGGAG]

First i have backup

Second i created the new database with the same name for old one

and the new user for the old one and made restor for old tables in the new database from Sql manegment studio but the system did't accept this

 

[appnair]

you have to follow the article as Greg told you.SQLserver uses GUID's to differentiate like named users in databasess.The command is explained in this document

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=18007097&objAction=download&viewType=1

From that document

The next step is to create a username and password with the same credentials as the original one, and force this new user to have the exact same SID. Run the following query to create a new login and map it to the database user:
sp_addlogin '<login_name>', '<password>', '<database_name>', '<language>', sid
(The default language

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair