Solved

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

Posted on 2009-07-06
5
801 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 50 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

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

734 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