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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 not able to connect to database after installing

Author  Topic 

ann06
Posting Yak Master

171 Posts

Posted - 2008-11-11 : 05:44:00

after i installed sql 2005 and choosing the authentication mode to windows authentication i was not able to connect to the database with the current username(the user name and password are grayed ii can't edit)
choosing connect made login failed for user... with error 18456
computer is running under vista workgroup will this not work if workgroup?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-11 : 05:46:26
nope. system should be part of domain and sql server should have a login corresponding to domain account.
Go to Top of Page

ann06
Posting Yak Master

171 Posts

Posted - 2008-11-11 : 05:51:19
so what shall i do in this case unistall sql server then install with mixed mode with supplying an sa password?
Go to Top of Page
   

- Advertisement -