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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2014-10-06 : 17:52:04
|
| what is name of default instance? (mssqlserver or computer name?)Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-06 : 18:34:26
|
| For your connection, it would be be the computer name. But the default instance is MSSQLSERVER in services, the registry, etc. You don't need to specify that in your connection though.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2014-10-06 : 18:39:03
|
| Thanks Tara. |
|
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-10-07 : 06:50:04
|
| Default name is MSSQLSERVER but if it is express edition it would be SQLEXPRESS.Hope this helpsRegardsShankySQL Server MVPhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
|
|
|
default instance