[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 817
  • Last Modified:

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

0
twomey_paul
Asked:
twomey_paul
  • 4
2 Solutions
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now