Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
flchico
Starting Member
46 Posts |
 Posted - 2006-10-03 : 14:27:33
|
| Hi,How do I create a new instance for SQL Express? Also the machine also has MSDE Installed if that should be taken into consideration.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-03 : 14:54:51
|
| You just run setup.exe and specify a new instance name.Do you have specific questions as to the installation?Tara Kizer |
 |
|
|
flchico
Starting Member
46 Posts |
Posted - 2006-10-03 : 15:01:03
|
| Thanks for the response.Where do I get this setup.exe? The only file that I get from the microsoft website is "SQLEXPR.EXE". For MSDE I ran the setup.exe but can't find this file for SQL Express. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-03 : 15:05:08
|
| SQLEXPR.EXE is probably the compressed file. Whatever you downloaded from their site, you will need to double click on. It might launch the actual setup or you may need to look for it in the directory that you specified to extract the files to. The SQLEXPR.EXE should be explained in detail on the MS site on the page where you downloaded it. Check the instructions.Tara Kizer |
|
|
|
flchico
Starting Member
46 Posts |
Posted - 2006-10-03 : 15:23:57
|
| It launched the setup automatically but I'm afraid to override the current installation (another database is there) b/c it was behaving as an actual new installation, I just want to create a New Instance to it. Maybe I just need to go forward with the installation and it automatically knows that there's one there already, leaves it alone and guides me to create a new instance?All the things that I've read doing searches on the net is creating a new instance at installation, I haven't found anything post-installation.Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-03 : 15:28:48
|
| Yes. In the installation you tell it the new instance name.Tara Kizer |
|
|
|
flchico
Starting Member
46 Posts |
Posted - 2006-10-03 : 15:54:55
|
| Thanks again,One last question just to make sure. This will not try to upgrade an existing msde installation, right? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-03 : 15:59:57
|
| As long as you answer the installation questions correctly.Tara Kizer |
|
|
|
flchico
Starting Member
46 Posts |
Posted - 2006-10-03 : 16:01:46
|
| Thanks for all the help. |
|
|
|
|
|
|
Installing a New Instance of SQL Express