SQL Auth. Login

I have Window 7 and MS SQL Server 2012 in the PC 1 called winserver, and I already enabled below setting:

Enable SQL Server Browser
Enable TCP/IP
Enable mixed mode authentication in MS SQL

Create SQL Auth. Login called adminapp
and mapping to correct database


Now, I have another pc using visual studio 2012 and try to make a database connection, and fail...
solution1368Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PadawanDBAOperational DBACommented:
What's the error message you're getting when you try to login?  It could be a couple things, however, i would initially suspect a firewall rule blocking the traffic on the Win7 box that has sql server installed on it.
0
solution1368Author Commented:
there is no firewall ...
0
PadawanDBAOperational DBACommented:
What is the error you're getting?
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

solution1368Author Commented:
No error. when I try to get the database in the dropdown. it shows nothing.
And I already map the login to the particular database i want...

See attached
9-19-2013-10-06-33-AM.jpg
0
Aneesh RetnakaranDatabase AdministratorCommented:
can you check the sql server error logs ?
0
solution1368Author Commented:
how?
0
PadawanDBAOperational DBACommented:
On the computer with SQL Server installed on it, log in via SQL Server Management Studio, go to Management > SQL Server Logs > double click log file that is appropriate for looking for the error.  Once in there, you're going to check around the times when you tried to log in to the database from the remote machine and see if you can find any errors/warnings.
0
solution1368Author Commented:
checked it but i don't see any logs that related to what i am doing.
Look like the connection never working.
0
PadawanDBAOperational DBACommented:
Can you try connecting to it by IP?  And is this on the default instance or a named instance?
0
solution1368Author Commented:
default instance. the pc is dhcp. how can i find out the ip address?
0
solution1368Author Commented:
actually, i found the IP. but it does not seem working...actually, the screenshot i shown you. the visual studio is able to find the PC.
0
PadawanDBAOperational DBACommented:
Whenever you logged into SSMS earlier to check the log files, did you use the same credentials as what is in the screenshot?
0
solution1368Author Commented:
yes. always t he same credentials
0
solution1368Author Commented:
0
PadawanDBAOperational DBACommented:
Just for grins, can you try the test connection button with the connection info and see if it errors?
0
David ToddSenior DBACommented:
Hi,

After you enabled SQL authentication, did you run the reconfigure command?

And have you tried restarting SQL?

HTH
  David
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.