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-10 : 12:02:50
|
| Hi gang,Another question. I'm using SQL Server Express and I went to the Configuration Manager and don't find anywhere the default instance 'SQLEXPRESS', instead I see things like "SQL Server 2005 Network Configuration" and under that "Protocols for MSSQLSERVER". Does this mean that whoever installed Express named the default instance "MSSQLSERVER"?Also from my application I use a connection string to connect to SQL Express using "SERVER=MYSERVER" and it connects fine but when I try to use "SERVER=MYSERVER\MSSQLSERVER" or "SERVER=MYSERVER\SQLEXPRESS" it doesn't connect. Any ideas?Thanks. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-10 : 12:21:46
|
| Have a look at sql server 2005 services in the configuration manager. After SQL Server you should see the instance name in brackets.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
flchico
Starting Member
46 Posts |
Posted - 2006-10-10 : 12:56:31
|
| Thanks for the response. It's 'MSSQLSERVER'. I tried to connect with that instance name but I can't connect, but when I use only the server name it connects fine. MSDE is also installed on this computer also by the way. |
|
|
|
flchico
Starting Member
46 Posts |
Posted - 2006-10-10 : 13:08:08
|
| By the way, I ran 'srvnetcn.exe' and I saw the server name as the instance but is this referring only to MSDE Instances or does it look at SQL Express instances too? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-10 : 14:43:32
|
| MSSQLSERVER means that the SQL instance is the same as the server name. So there is no named instance, just the default instance.Tara Kizer |
|
|
|
flchico
Starting Member
46 Posts |
Posted - 2006-10-10 : 15:59:00
|
| Any idea on why I can connect to 'MYSERVER' but not 'MYSERVER\MSSQLSERVER'? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-10 : 16:01:36
|
| I just explained it. MSSQLSERVER is not the named instance name. It means you have installed the default instance, which is just MYSERVER.Tara Kizer |
|
|
|
flchico
Starting Member
46 Posts |
Posted - 2006-10-10 : 16:29:00
|
| oh ok, I was reading articles on the net about 'SQLEXPRESS' being the default instance and being able to change the name, thinking that a named instance is required, that kind of confused me.Thanks. |
|
|
|
|
|
|
Instance Name