July 14, 2009 at 6:52 pm
Hello, Everyone.
Long time no talk to. I hope this post finds all of you doing well.
I have an application that I need to access the backend to using SSIS. However, the application upon installation places its own SQL Server 2005 Express instance on the server (you cannot change this behavior) and removes the Administrator from the sysadmin group then passwords the sa login. Needless to say, you aren't getting in using the app's SQL instance.
I come up with the idea of installing a second instance of SQL Server on the machine and mounting the databases using it.
Should I shut down the app's instance of SQL Server 2005 Express before allowing mine to mount the database or can they both share?
Thank You,
JamesNT
July 14, 2009 at 9:23 pm
I don't see why not..
But absolutely only one can be running at a time..
CEWII
July 15, 2009 at 12:33 am
A SQL instance needs exclusive access to its data files, hence only one SQL instance at a time can be using a particular data file.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply