solution1368
asked on
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...
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...
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.
ASKER
there is no firewall ...
What is the error you're getting?
ASKER
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
And I already map the login to the particular database i want...
See attached
9-19-2013-10-06-33-AM.jpg
can you check the sql server error logs ?
ASKER
how?
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.
ASKER
checked it but i don't see any logs that related to what i am doing.
Look like the connection never working.
Look like the connection never working.
Can you try connecting to it by IP? And is this on the default instance or a named instance?
ASKER
default instance. the pc is dhcp. how can i find out the ip address?
ASKER
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.
Whenever you logged into SSMS earlier to check the log files, did you use the same credentials as what is in the screenshot?
ASKER
yes. always t he same credentials
ASKER
https://www.experts-exchange.com/questions/28244668/SQL-Server-conversion.html
one more question posted if u have time.
one more question posted if u have time.
Just for grins, can you try the test connection button with the connection info and see if it errors?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.