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 |
|
matthewphillips
Starting Member
6 Posts |
 Posted - 2009-02-01 : 16:10:42
|
| I have worked with SQL Server 2005 a bit, but I have not had to deploy it before now. I installed the developer edition (which comes with VS2008) but I don't know how to log-in. Under "server name" (in Management Studio) I write the name of my computer (I have also tried MSSQLSERVER) and I use Windows Authentication. It says log-in failed immediately. I'm not sure where to even proceed from here. The service is running. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-01 : 23:37:32
|
| Have you installed default instance?Put . in servername and see. |
 |
|
|
matthewphillips
Starting Member
6 Posts |
Posted - 2009-02-02 : 20:35:30
|
| tkizer, I am using Microsoft Vista Home Premium.Using . is no good.I am fairly certain I installed the default instance, however, how can I confirm this? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
matthewphillips
Starting Member
6 Posts |
Posted - 2009-02-03 : 11:33:01
|
| Yep, that was the problem. You have to run SSMS as an administrator to login. Good to know. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Not even sure how to log-in...