August 18, 2015 at 4:10 am
Hello guys i'm quite new to SQL Server, and some terms, i mean like still climbing and now im giving the first step ^^.
My user is, U326399 i should be able to login "Windows Login", as EURO\U326399.
Anyway when i ever i try to login it gives an error "sql server error 18456", i rly donno why...since im listed on the "Database_name/Users/" and even in the Database Roles "db_securityadmin" as part os the role members.
I currently using my colleague details user and password to login to windows, so i could take some screenshots .
Still i hope you guys got a glimpse what im talking about x/
Thanks for your time.
August 18, 2015 at 4:13 am
What is the full error message you get?
August 18, 2015 at 4:18 am
The full error is
"TITLE: Connect to Server
------------------------------
Cannot connect to
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'Euro\u326399'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
"
State: 1
August 18, 2015 at 4:56 am
Can you use another user who can log in, and if you look in the SQL logs there should be entries in here to do with the failed login that will provide more information. Can you post them here.
August 18, 2015 at 5:10 am
FridayNightGiant (8/18/2015)
Can you use another user who can log in, and if you look in the SQL logs there should be entries in here to do with the failed login that will provide more information. Can you post them here.
Well this another downer...the current user im using, my colleague user, don't have permission to see the SQL Logs :w00t:
"The user does not have permission to perform this action."
August 18, 2015 at 5:40 am
You may have a user in this database, but do you have a login to the SQL Server? You'll find that in SSMS under <<instance>>...Security...Logins. If you don't have permission to see this, your DBA should be able to help you with it.
August 18, 2015 at 5:53 am
Ed Wagner (8/18/2015)
You may have a user in this database, but do you have a login to the SQL Server? You'll find that in SSMS under <<instance>>...Security...Logins. If you don't have permission to see this, your DBA should be able to help you with it.
Hum like i though, i did a printscreen but i forgot to post...
See plz the attachment.
Thanks for your time,
v4let20
August 18, 2015 at 6:44 am
your login may not be mapped to the user account. Have you switched servers lately?
August 18, 2015 at 6:55 am
ARC211 (8/18/2015)
your login may not be mapped to the user account. Have you switched servers lately?
Good point about the login-user map.
Also, is the user on the same domain as the SQL Server? From what I can see, the login ends in -C and the server is on EURO.
August 18, 2015 at 7:09 am
Ed Wagner (8/18/2015)
ARC211 (8/18/2015)
your login may not be mapped to the user account. Have you switched servers lately?Good point about the login-user map.
Also, is the user on the same domain as the SQL Server? From what I can see, the login ends in -C and the server is on EURO.
Nah since im here, at the office.
Same server, different day.
I still trying to figure that out to, although it says "something-C\U990220" i log with windows login so its "Euro\U990220"
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply