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

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

twomey_paulAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RiteshShahCommented:
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
twomey_paulAuthor Commented:
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
twomey_paulAuthor Commented:
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
twomey_paulAuthor Commented:
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
twomey_paulAuthor Commented:
Perhaps a bit tooo tricky for you experts:)   Decided to start again and reinstall imss.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.