Login failed for user 'Boopathi-PC\Marimuthu'. (Microsoft SQL Server, Error: 18456)
-
I am new to sqlserver 2008. recently i have installed sql2008 in vista and successful. While connect default instance named (computer name) as "Boopathi-PC' & getting error is :
TITLE: Connect to Server
------------------------------
Cannot connect to BOOPATHI-PC.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'Boopathi-PC\Marimuthu'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
-
check the log of the server and this will give you the error code and from that you can work out why you cant login. eg. bad password, user does not exist etc..
-
Did you install SQL Server with same user account 'Boopathi-PC\Marimuthu'? If not, try with the user account you used for installation.
-
It’s a known behavior on Vista.
SQL Server installs with the BUILTIN\Administrators group as the default system administration group. By default, users on Windows Vista that are members of the Windows Administrators group are not automatically granted permission to connect to SQL Server, and they are not automatically granted SQL Server administrator privileges. On Windows Vista, when a user tries to connect to SQL Server, a message is returned that states that the account does not have rights to log in to SQL Server.
How to: Connect to SQL Server from Windows Vista
-
If you can connect to the server with the SA account, login to the Server and grant your Windows user the rights you want it to have on the SQL Server.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply