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 |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2007-11-07 : 08:04:36
|
| I have had to format my laptop and re-install server 2005 developer edition. Im having trouble logging on. My computer name is 28NEWMANSLANE. I installed sql server with a default instance, where as last time i installed with a named instance.I can not find out with name it has given itself.am i correct saying that the logging in format would becomputername/instancename ?? using windows authenticationRegardsRob |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-11-07 : 08:16:12
|
| If it is default instance, you can't specify instance name. Just use your computername as Servername to connect.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2007-11-07 : 08:34:53
|
| I try to use my computer name and i just get an error message 18456I cant understand it, it was ok before. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2007-11-07 : 08:36:13
|
| I think i will re-install it again but use a named instance instead |
|
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2007-11-07 : 13:35:22
|
| By default, SQL Server 2005 names the default instance SQLEXPRESS. In your case, then, you'd connect to either 28NEWMANSLANE\SQLEXPRESS, or more easily, (local)\SQLEXPRESS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-07 : 22:53:11
|
| No, developer edition doesn't use sqlexpress as instance name.masterdineen, did you apply sp2 and fixes? They fixed several 18456 type bugs. |
|
|
|
|
|
|
Connecting to my Instance