| Author |
Topic |
|
MTech8
Starting Member
10 Posts |
 Posted - 2005-10-25 : 20:19:20
|
| Hello. I am very new to SQL Server. I've tried to look through other posts on the forum but did not find the solution I needed. Please help.I have SQL Server running on Machine1 which I am able to connect to. What I want to do is connect to this server through a Machine2 that is on my network.Both Machines run on WindowXP ProfessionalOn the server of Machine1, I have:1. Under the security tab, I have created a New Login using SQL Server Authentication (general tab), checked all server roles (server roles tab) and checked to permit all databases (in the database access tab)2. On the server, went to properties -> security tab and allowed for SQL Server and Windows authenticationOn Machine2 when I try to register the server of Machine1 through the Register SQL Server Wizard, I am able to see the server. However, when I use the newly created Login Name and password (from step 1 of above). I get a Login Failed for user message. When I try to connect to the server through Query Analyzer I also get an unable to connect to server message (Server: Msg 18456, Level 16, State1)What else do I need to configure to make it work?Thank you! |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-26 : 00:22:36
|
| Hi,are you able to connect from QA (from machine1 with SA login) ! have you check Server And Client Network Utility ! are TCP/IP Enabled !?-----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
 |
|
|
MTech8
Starting Member
10 Posts |
Posted - 2005-10-26 : 00:50:00
|
| Yes. With the QA on Machine1, I can connect to Machine1 with SA login & with Windows Authentication. And I have also checked the Server and Client Network Utility. The TCP/IP is enabled.What could be the problem? Does this have anything to do with IIS settings/permissions or with Windows itself? or is there something I'm missing in Enterprise Manager? I think I read some articles of granting permissions. Is this a missing step that I have forgotten? How would I do that (and would it be possible to do it via Enterprise Manager). |
|
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-26 : 01:07:26
|
| Hi,what error message it show ! its necessary to get a good answers Are you able to ping SQL Server (machine1) from machine2 ?! Are they on same network segment ! is NetBios disable on machine1 !?-----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
|
|
|
MTech8
Starting Member
10 Posts |
Posted - 2005-10-26 : 12:45:03
|
| The error message I get when I try to connect with QA is:Unable to Connect to Server G1:Server: Msg 18456, Level 16, State 1[Microsoft][ODBC SQL Server Driver][Sql Sever] Login failed for user 'V1'From the cmd prompt I was able to successfully ping machine1 from machine2 (although I'm not sure how to ping the SQL Server itself). The IP addresses from the pings of machine1 and machine2 are different (if that answers the question regarding being on the same network segement) and not sure how to check if NetBios is disabled. |
|
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-26 : 23:10:45
|
| Hi,when it says login fail for user *v1* that means username / password doesnt match .to check if it on same network segment run ipconfing/all to cmd prompt to machine1 and machine2 and check if subnet mask are same and then ping machine1's ip from machine2 or vise-versa if it pings its on same segment .and in result of ipconfig/all look for netbios over tcpip : ????? (disable / enable)HTH-----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
|
|
gkrishn
Starting Member
16 Posts |
Posted - 2005-10-27 : 13:41:52
|
| That is the issue with Login you have created, not anythign due to Network/protocol .Are you able to connect from the same machine with that SQL login/password ?-Rajiv |
|
|
|
MTech8
Starting Member
10 Posts |
Posted - 2005-10-27 : 17:53:54
|
gkrishn: You rock! I was not able to login using that username&password from that same machine. What I had previously did was to go into Enterprise Manager -> Security -> Logins ->(right click) New Login -> and created the user (password, permission, etc). This didn't allow me to login. I'm not sure what additional steps are necessary to allow this created user to login. But what I realized was that during the entry of the name (during user creation) if I clicked on the ellipse that if I choose a user from the (system?) list of users. Then everything was fine. So I proceeded to add my user first to the (system?) list via the control panels -> administrative tools -> computer management -> local users and groups -> users -> (right click) New User. And then followed my previous steps that I was able to create a valid username that allows me to login from the local and remote computer.Thanxs for directing me in the right direction in helping me find the solution. (If there is anything that I'm not correctly understanding, please clarify my above explanation)  Afrika: Thanxs for yours tips. My current setup is with workgroups and not domains. So I'm not sure if your explanation would have helped me. But I did find your article very informative and will reference it when I'm ready to move to a domain setup in a couple months. ActiveCrypt: Thanxs for trying to help.  |
|
|
|
kchandarana
Starting Member
2 Posts |
Posted - 2008-01-14 : 15:20:16
|
| Hey I saw your prob and then how did you solve it. i m having almost same kind of prob. i m using SQL Server Management Stdio Express. I am able to login thru only windows authentication. i changed setting to SQL authentication and windows both. i m creating the new login like the way you did. security- logins - right click - new login- sqlauthentication and permission and all other opetion that i can checked i did but even though i m not able to connect. i have created a account from control panel and then try to do the same thign then it is giving me error that that login already excists. Plz help me here , it is driving me crazy. I am new in SQL Server |
|
|
|
|
Unable to connect to server