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 |
|
SanjeevBaranwal
Starting Member
14 Posts |
 Posted - 2008-12-17 : 08:19:30
|
| Hi, I have installed SQL server 2005 Developer edition on my XP OS SP2 but it is not getting connected. I tried with both the Local user account in my first installation and then Network services(Domain/Username/Password) in my second installation.Can anybody help in installing this). |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-17 : 09:33:23
|
| Did you get any errors?Did you reboot after install? |
 |
|
|
SanjeevBaranwal
Starting Member
14 Posts |
Posted - 2008-12-18 : 00:47:01
|
| Yes I rebooted the machine. The error is coming as:Login failed for user 'Domain\Username'.(Microsoft SQL Server, Error:18456)I am able to connect to other servers trough other logins but not to the instance of the machine where it is installed with Domain/Username/Password which was given at the time of installation. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-18 : 01:11:52
|
| whats the authentication mode used? is there a valid login existing for domain account? |
|
|
|
SanjeevBaranwal
Starting Member
14 Posts |
Posted - 2008-12-18 : 02:31:51
|
| During installation no window came to select windoes authentication or MIxed mode only it cam to select whether the local account/network service etc. and other option Domain/Username/Password it asked. and I provided Domain/Username and password which I use for my windows login. OS is XP professional SP2. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-18 : 02:38:41
|
| go to start->programs->sql server->congiurations->surface configuration manager and see what authentication mode is used. |
|
|
|
SanjeevBaranwal
Starting Member
14 Posts |
Posted - 2008-12-18 : 03:45:35
|
| I am not seeing anything like authentication there.When going through Surface Area Configuration for Services and COnnections I found that Analysis services and SQL Server Vrowser are stopped but Integration services is showing as Started. |
|
|
|
|
|
|
SQL Srv 2K5 Dev Edition Installation