SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Cannot connect to server Error Number: 18456
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

imughal
Posting Yak Master

192 Posts

Posted - 07/05/2013 :  03:40:51  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 07/05/2013 :  04:03:26  Show Profile  Reply with Quote
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
Go to Top of Page

imughal
Posting Yak Master

192 Posts

Posted - 07/05/2013 :  06:44:14  Show Profile  Reply with Quote
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

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 07/05/2013 :  06:50:02  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000