SQL Server Logins

[arshesander]

here are the list of logins in my sql server


when i use to login


i encounter this error:


pls help me to create new login w/ new user? help me pls? not SQLExpress

[jmcilhinney]

BUILTIN\Administrators is the name of a User Group, not a Server. The name of your Server looks like its SQLEXPRESS, or maybe SYSTEM\SQLEXPRESS.

A User Group is, as the name suggests, a group of users. It enables you to assign privileges to a group and then every user you add to that group receives those privileges.

If you were using SQL Server Authentication, rather than Windows Authentication, then you'd put the name of one of your Users into the User Name field. if you wanted to log on with administrative privileges then you'd use one of the Users in the BUILTIN\Administrators group, which would include the 'sa' user.

[arshesander]

thanks, kindly give me an idea so that i can log on that using builtin/administrations logins?

[szlamany]

What do you mean by "NOT SQL EXPRESS"? It's obviously SQL EXPRESS from all that you have shown...

You put BUILTIN\ADMINISTRATORS into the SERVER name field - that's not what goes there.

What goes there is the name of the SQL instance - which most likely is

SYSTEM\SQLExpress

Have you tried that? Actually - I can see that it's SYSTEM\SQLExpress from the first image you posted.

Which leads me to ask - if you got that first image you must have gotten into Management Studio Express - right?

If that's the case then are you trying to connect from a different PC? Is that what's showing in the second image? If so - then you need to allow remote connections which is done with the SQL Server Surface Configuration Utility - found under START>PROGRAMS.

[jmcilhinney]

It's like my previous post never happened. I could repeat what I've already posted, or you could just go back and read it again.