Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Trying to create a new MSDE instance name called "imss"

Posted on 2009-07-06
5
Medium Priority
?
815 Views
Last Modified: 2012-05-07
Forgot SQL MSDE password for a Trend IMSS install.

Like to keep data.

So taken a copy of database files and trying to create a new database with exactly the same name.  That name is "imss", which will be substituted back after MSDE is installed (now with new password)

First of all, uninstalled old copy of MDSE

Just ran setup.exe from the SQL MSDE distributable.  Used following command:
setup sapwd=Track1t targetdir="d:\program files\MSDE\" datadir="d:\program files\MSDE\" instancename="imss" securitymode=sql /L*v "c:\msdelog.txt"

This creates an instance called 'MSSQL$IMSS' - which appears not to be the same thing - I'm unable to sustitute the original IMSS back into it - wrong name, service won't start.
setup sapwd=Track1t targetdir="d:\program files\MSDE\" datadir="d:\program files\MSDE\" instancename="imss" securitymode=sql /L*v "c:\msdelog.txt"

Open in new window

0
Comment
Question by:twomey_paul
  • 4
5 Comments
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 200 total points
ID: 24785213
If you have uninstall copy of MSDE than how can you start service of old instance?

aren't you able to start service of new instance?

didn't understand your question clearly.
0
 

Author Comment

by:twomey_paul
ID: 24786573
Uninstalled old MSDE copy, and reinstalled (using above command), then created a dummy 'imss' instance.

would like to substitute the dummy one with the imss.mdf and ldf files to bring it back up with a different sa password.

Hope this makes sense...
0
 

Author Comment

by:twomey_paul
ID: 24786763
Just realised that I'm trying to get the instance name to be the same as the database name.

What I must do is create a default instance name and THEN attach the imss.mdb

Simples - please hold fire for an hour...

0
 

Author Comment

by:twomey_paul
ID: 24787817
I'm no dbe as you may have alreay gathered - but trying to create that imss database gives me this mess:

C:\Install\Trend\IMSS Source\5547\release\MSDE>osql -U sa
Password:
1> sp_attach_db @dbname=N'imss'
2> @filename1=N'd:\program files\msde\mssql\imss\imss.mdf'
3> @filename2=N'd:\program files\msde\mssql\imss\imss_log.ldf'
4> go
Msg 170, Level 15, State 1, Server KPUKSPAM, Line 2
Line 2: Incorrect syntax near '@filename1'.

Is this a syntax issue?
0
 

Accepted Solution

by:
twomey_paul earned 0 total points
ID: 24805527
Perhaps a bit tooo tricky for you experts:)   Decided to start again and reinstall imss.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
What we learned in Webroot's webinar on multi-vector protection.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question