Cannot connect to server Error Number: 18456

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 2008 Forums

SQL Server Administration (2008)

Cannot connect to server Error Number: 18456

Author

Topic

imughal
Posting Yak Master

192 Posts

Posted - 2013-07-05 : 03:40:51

Hi,

Cannot connect to DATABASESERVER. [SQL Server 2008 R2]

===================================

Login failed for user 'domain\user1'. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

i have checked SQL is set for mixed mode authentication, sql browser service is running. I logged to system with domain\user1 and access management studio and used windows authentication then its work and i get login to sql server.

but when i try to use SQL Server authentication is give me error and not allow me to get login pls guide how to fix it.

thx

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-05 : 04:03:26

sorry you explanation and erro message doesnt match

you told
when i try to use SQL Server authentication is give me error
whereas error says
Login failed for user 'domain\user1'.
domain\user1 is not sql login its windows login so either you used wrong authentication mode or you use wrong login

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

imughal
Posting Yak Master

192 Posts

Posted - 2013-07-05 : 06:44:14

Hi,

Basically i want to create a database using following command

aspnet_regsql.exe -S DBSERVER -U domain\user -P userpassword -d FileNetProfile -A p

error : Login failed for user Unable to connect to SQL Server database. Even though i have logged into system with domain account
pls tell how do i fix it and how i give access to domain user.
thx

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-05 : 06:50:02

I've not used aspnet_regsql.exe before
but redaing through definitions i've few questions
have you logged into system using domain\user ? if thats the loggedin credential you could just use


aspnet_regsql.exe -E -S DBSERVER -d FileNetProfile -A p

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources