Solved

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

Posted on 2009-07-06
5
773 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 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Creating and Managing Databases with phpMyAdmin in cPanel.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now