November 29, 2008 at 9:34 am
Cannot connect to MYPC.
Login failed for user 'MYPC\Jaiparaman'. (Microsoft SQL Server, Error: 18456)
I have installed the SQL server 2005 on my machine
and the service pack SQLServer2005 SP2
Operating sytem : Window Vista Home Premium , SP1
while try to connect the Database using the windows authentication
I am getting the above error and I checked that SQL Server Agent is running
Please advise me to fix this issue
November 29, 2008 at 9:42 am
Is that login an administrator on the PC? If not you would need to have granted that login access to the SQL Server explicitly.
Also, the SQL Server Agent service has nothing to do with logging in. The SQL Server Service is what you actually connect to and the SQL Server Agent is mainly a job scheduler.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 29, 2008 at 10:12 am
When you installed SP2, there should have been a utility launch at the end to allow you to specify which windows accounts are sysadmin. On Vista and Server 2008, members of the local administrators group are not automatically sysadmin in SQL. You have to specify exactly what accounts are admin during installation (for SQL 2008) or after the SP2 patch (SQL 2005)
If you didn't set an admin, you can use the SQLprov.exe tool to do so. It's somewhere in the installation directory of SQL. Search for it, it's not hard to find.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 2, 2008 at 6:40 pm
Hi guys,
Now It is working fine for your reply. I Installed the SP2 patch again and granted the admin role
to window user.This would be most useful for the beginner who installing the sql server 2005.
Cheers
Jai
February 5, 2010 at 11:24 pm
Hi, i also having the same error.iam able to login sqlserver with my windows account but iam not able to login with sa account.even thogh i changed password and login.iam able to create any user but not able to login with sql server.and am also not able to login with windows account for maintanance plan.i installed sql server standard version in my laptop.
Malleswarareddy
I.T.Analyst
MCITP(70-451)
February 6, 2010 at 1:56 am
Please post new questions in a new thread. Thank you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply