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 |
|
texas1992
Starting Member
21 Posts |
 Posted - 2012-04-19 : 10:29:59
|
| I purchased the SQL Server Developers Edition and installed it on my Windows 7 Professional machine. Everything installed fine, I thought. However, the only instance I get is the SQLExpress instance. During the installation I added a different instance. Why can't I see my instance? Do I have to use the SQLExpress instance on Windows 7?How can I use my other instance?Thanks |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-04-19 : 11:01:41
|
| You should be able to run SQL 2008 developer edition on Windows 7 Professional. http://msdn.microsoft.com/en-us/library/ms143506(v=SQL.100).aspx#Developer32It may be that the service did not start automatically. Run services.msc and look for Sql Server. You would/should see things like:SQL Server (SQLEXPRESS)SQL Server (MSSQLSERVER)SQL Server (SQLNamedInstance)First is express, second is the default instance and third is a named instance (if you installed a named instance).If the service is not running start it from services.msc. Even if the service has started, looking at services.msc lets you identify the instances and names.Then you should be able to connect to the database engine using:(local)\SQLEXPRESS(local)(local)\SQLNamedInstancerespectively for each of the above 3 scenarios (assuming you are running SSMS from the computer where you installed it). |
 |
|
|
texas1992
Starting Member
21 Posts |
Posted - 2012-04-19 : 11:14:29
|
| Thanks for the reply. The only service that I see running in the Services window is the SQL_SERVER(SQLNamedInstance). I don't see the other two. However, when I start SQL Server Management Studio the only option I have for Server Name is (local)\SQLEXPRESS. I don't understand how to get the SQLNamedIndstance to show up. |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-04-19 : 11:24:07
|
| I assume you are trying to find the server by selecting "Browse for More".If you don't see it, instead of choosing Browse for More, you can type the name of the server in the Server name box. So in your case you would type (local)\SQLNamedInstance and connect. |
|
|
|
texas1992
Starting Member
21 Posts |
Posted - 2012-04-19 : 11:32:34
|
| Yeah, I feel completely stupid. That worked. Thanks. |
|
|
|
|
|
|
Installation problem