June 16, 2010 at 1:03 pm
Hello comunity
When i try to connect to my sql server 2008 with Windows authentication, SQl server return the following error:
TITLE: Connect to Server
------------------------------
Cannot connect to PCLUIS.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'BIGLEVEL\LuisSantos'. (Microsoft SQL Server, Error: 18456)
I don´t understand because i configure the same on the properties with :
SQL Server and Windows Authentication mode.
Could someone explain how to resolve this problem.
Many thanks
Luis Santos
June 16, 2010 at 1:20 pm
Take a look at the server log and the following link. The error state may be able to provide more information.
http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 16, 2010 at 4:55 pm
Hello Dan
The error state = 1, and this article dont give me an answer to solve my problem, because state 1 report to "contact your system administrator".
On SQL server 2005 , i never have this problem and i sure you that i install many.
Maybe to help you, all the services of my current SQL Server 2008 are on local System, and this user name is my user name on my domain enterprise BIGLEVEL, also i´am administrator of my own machine that use OS windows 7 32 bit.
Curiously , i have my PC at home with SQL Server 2008 EXpress with all the sql services on "Local System" and i don´t have this problem. My OS is Windows XP SP2.
Could you have more ideias ?
Many thanks for your reply.
Best regards
Luis Santos
June 17, 2010 at 11:26 pm
In SQL Server 2005, Local Administrator group on the local machines would get access to SQL Server through the BuiltinAdministrators group that gets added to the SQL Server 2005.
But in SQL Server 2008, BuiltinAdministrators group has been removed. Hence during the installation we need to add one account using which we can login to the SQL Server once the installation is complete.
Please try to login to the SQL Server 2008 using sa account and try to add your account as a login to the server. Later you should be able to login to SQL Server 2008 using Windows authentication using your account credentials.
Please try this.
Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply