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 |
|
sirmilt
Starting Member
49 Posts |
 Posted - 2011-10-03 : 11:47:41
|
| The problem I'm having is probably due to my own lack of knowledge. A little background is in order. I am retired and write programs to keep myself occupied. I used Visual Basic 2008 with an SQL Server 2008 R2 database, only to find out that the deployment features in Visual Basic 2008 do not cover SQL Server R2 so I switched to an Access database. Foolishly, thinking that I had no further need for SQL Server Express on my computer, I uninstalled it. However, the uninstall left a folder "Microsoft SQL Server" which contains 2 instances of the server and which I cannot deleteI obtained and installed Visual Basic 2010 and attempted to re-install the SQL Server 2008 R2 Express and retained one of existing instances. The install went through to the end of the job.When I try to use the SSMS program the login process sees the existing instance but when I try to access one it simply does nothing.I am at a loss...I want to use the SQL Server as opposed to ACCESS 2000 but don't know how to proceed. Any help or guidance would be appreciated.Milt |
|
|
lappin
Posting Yak Master
182 Posts |
Posted - 2011-10-05 : 10:23:11
|
| You can disable the unused instances in Administration Tools / Services - look for SQL Server Express instance. Also you can enter the instance name you wish to connect to when start SSMS. For the default instance, enter a full stop "." without the speechmarks, or you can enter the ip address of machine followed by "\instancename". |
 |
|
|
|
|
|
Installing SQL Server 2008 With Tools