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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2007-11-29 : 12:02:05
|
| Hi,I have installed SQL 2005(Developer Edition) in Windows vista.While Installing I have choosen Mixed mode and i gave the password too.The installation was finised successfully. But i cant able to login It says "Login failed". I have applied Sp2 also. Windows vista home editionSQL 2005 Developer edition.What is the problem and How can solve this issue.Can any one help me..?Thankskrishna |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-30 : 02:46:24
|
| How did you login? |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-30 : 03:42:44
|
| Have you run the surface area configuration? |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2007-11-30 : 09:55:49
|
| I cant login. While login its saying login failedRickD, In SAC, I have seen Services are Running, in remote connections the Local and remote connection option is enabled. Under the Local and remote connections "Using both TCP/IP and Named pipes " is enabledThankskrishna |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-01 : 14:55:40
|
On VISTA, local administrator is not longer automatically given SA rights in SQL Server.You have to add yourself to SQL administrators with the SURFACE AREA tool.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
SQL 2005 In Vista Error