SQL Auth. Login

solution1368
solution1368 used Ask the Experts™
on
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...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
PadawanDBAOperational DBA

Commented:
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.

Author

Commented:
there is no firewall ...
PadawanDBAOperational DBA

Commented:
What is the error you're getting?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

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
AneeshDatabase Consultant
Top Expert 2009

Commented:
can you check the sql server error logs ?

Author

Commented:
how?
PadawanDBAOperational DBA

Commented:
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.

Author

Commented:
checked it but i don't see any logs that related to what i am doing.
Look like the connection never working.
PadawanDBAOperational DBA

Commented:
Can you try connecting to it by IP?  And is this on the default instance or a named instance?

Author

Commented:
default instance. the pc is dhcp. how can i find out the ip address?

Author

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.
PadawanDBAOperational DBA

Commented:
Whenever you logged into SSMS earlier to check the log files, did you use the same credentials as what is in the screenshot?

Author

Commented:
yes. always t he same credentials
PadawanDBAOperational DBA

Commented:
Just for grins, can you try the test connection button with the connection info and see if it errors?
Senior Database Administrator
Commented:
Hi,

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

And have you tried restarting SQL?

HTH
  David

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial