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 |
|
rosefrost
Starting Member
4 Posts |
 Posted - 2014-10-06 : 17:13:01
|
| hi all.Have a question regarding the ability/conflicts of installing different editions onto a windows 7 system.the system is already running sql server 3.5 compact as well as mySql 5.1the program that i created is needing to run with sql server 2008r2. this would be an install that would not require any remote access as it is a local database - only reading and writing to the machine i install my program on. can anyone tell me if im gonna run into trouble doing this? or if there is anything special that i need to do to for a successful install ? for example, do i need to use a named instance when installing the 2008r2? or can i use the default instance ...thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-06 : 17:53:24
|
| I'm not experienced with SQL Server 3.5 Compact edition, but it's likely using a named instance alredy. You can check services to see what's installed for services prefixed with SQL. If any say MSSQLSERVER, then it's the default instance. Otherwise, it's a named instance. If it is the default instance, you'll need to install a named instance.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
rosefrost
Starting Member
4 Posts |
Posted - 2014-10-06 : 18:05:20
|
| hi and thank you tkizer for your quick reply. should i need a named instance, can i name this on the fly in the install of the sqlexpress 2008r2 or do i have to rebuild my vb project with the name instance in the connection string? this is not for remote - just for local. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-06 : 18:36:01
|
| It prompts for the information during the install. The connection string in your VB project will need to be modified if you use a named instance.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
rosefrost
Starting Member
4 Posts |
Posted - 2014-10-06 : 20:07:49
|
| okay thank you tkizer :)i have installed the sql 2008 express server with a default instance(taking a chance here that the compact 3.5 was installed with a named instance) and it is working. HOWEVER, -something very odd is happening..when i reboot the system and try to launch my newly installed program..it gives me a time out error. i hit quit..and try to launch again..it takes right off then with no errors..LOLam wondering if by chance you might have a clue on that? i didnt install management studio because as i said earlier - this is just a local database..so i saw no need to install management studio.am fairly new at this and this might have been a mistake..not sure what the deal is :( |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-06 : 20:24:54
|
| Sorry, I can't help with that part. But you should be using Management Studio for any SQL work. Visual Studio can not handle the more complex queries.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
rosefrost
Starting Member
4 Posts |
Posted - 2014-10-06 : 20:51:50
|
| okay thank you so much for your time :)! |
|
|
|
|
|
|
installing different editions on same system