SQL Server Performance

SQLServer Connections

Discussion in 'General DBA Questions' started by Radhikadatla, Dec 11, 2005.

  1. Radhikadatla New Member

    Hi I am new to administration and I am trying to connect 2 sql servers in 2 diff systems not in a domain but in LAN.IS there any posibility for those to be connected? If not, why the OSQL command listing all the servers in the intranet.Do I need to re-install SQLServer2000 if I want to change it to multiuser mode from single user mode when I logged in?

    Radhika
  2. derrickleggett New Member

    Are you using SQL Server authentication? If so, you should be able to connect using the SQL Server username and password with the IP addressinstance name beween the computers. And....YES.....if the server is in single user mode (or the database) you will have to change it before anyone else can use it.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  3. Radhikadatla New Member

    When I use 'ping' to find out other SQLServers connected or not, it is successfully communicating with all other SQLServers but when I try to connect the other system's SQLServer from my Enterprise Manager it is warning that 'SQLServer not exist or access denied'. Both systems are using windowsXP PROF.I am using windows authentication and TCP/IP everywhere. Is there any other option to change from single user mode to multiuser mode than re-installing SQLServer.

    Radhika
    Radhikadatla2k5@yahoo.com.au
  4. derrickleggett New Member

    Yes. Go to Books Online, look on the index tab, and type in SINGLE_USER. You will get a full explanation including sample code.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  5. ghemant Moderator

    Hi,<br /><br />here is a link FYI for Potential Causis of SQL Server Doesn't exist or Access Denied :<br /<a target="_blank" href=http://support.microsoft.com/default.aspx?scid=kb;en-us;328306>http://support.microsoft.com/default.aspx?scid=kb;en-us;328306</a><br /><br />and you need to set your SQL Server to Mixed Authentication Mode , here is a reference how to do it :<br /<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331</a><br /><br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  6. satya Moderator

    Why do you want to enable single-user on the server, rather tighten the security using ROLES.
    Check other posts about security in this regard.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  7. Radhikadatla New Member

    Thank you very much. Using SQLServer authentication everywhere I am able to connect the SQLServers in intranet but not in domain. But,... If I use windows authentication with proper username and password why this is not possible?

    Radhika
  8. ghemant Moderator

    Hi,<br />this is possible in Domains tooo , if you can communicate between two domains its possible to do work with SQLAuthentication ,And if you are using Windows Authentication then you must have a Trust Relationship between two domains , and if your client / workstation is pre windows 2000 system then your domain(DC) have to have Mixed Mode Authentication and have to allowed Pre Windows 2000 client explicitly.<br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  9. gkrishn New Member

    About Winodws authentication, BOL says ...

    A user's network security attributes are established at network login time and are validated by a Windows domain controller. When a network user tries to connect, SQL Server uses Windows-based facilities to determine the validated network user name. SQL Server then verifies that the person is who they say they are, and then permits or denies login access based on that network user name alone, without requiring a separate login name and password.

    --Rajiv
  10. vsnreddi New Member

    Hi..Radhika.

    I am looking the same answer for my question..thanx



    SURYA



  11. satya Moderator

    If you are using any application with ASP flavour, then refer to KBAhttp://support.microsoft.com/default.aspx?ID=kb;en-us;Q247931 for infocation on connecting the application.

    http://www.databasejournal.com/features/mssql/article.php/3341651
    http://www.databasejournal.com/features/mssql/article.php/3334851

    One of the post related to similar issue refers
    When you use Windows authentication, the accounts must be set up as domainID in SQL Server. This can easily be done in Enterprise Manager.

    Assign your users to NT groups, and use Windows group level authentication in SQL Server. The account entries in this case are in the form domainGROUP. We use Windows authentication with group authorisation for everything bar some 3-party applications that only support mixed mode SQL logins.


    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  12. Radhikadatla New Member

    Is there any posibility for all the SQLServers instances in LAN(Not connected in domain)to access all the other instances of other SQLServers? Is there any chance for a SQLServer instance to act as a server and client at the same time? I am able to access server1 from server2 but, can not access server2 from server1. Is it acceptable?

    Radhika
  13. ghemant Moderator

    Hi,
    when you access your server2 from server1 , what error it throws ?!what is a authentication mode set to at server1 and server2 ?! it its a Windows Authentication mode set it to Mixed Mode , one more thing look in to client network utility.


    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  14. Adriaan New Member

    If you register a remote server, this is a one-way registration: it does not register your current server on the remote server. You can refer to server2 from server1, but not the other way around - unless you register server1 as a remote server on server2.
  15. satya Moderator

  16. Radhikadatla New Member

    I registered server1 in server2 and server2 in server1. It was successful. But at a time I can make a connection in one way. but when I try connect in the other way at the same time it is showing the error like---"couldn't able to access server2. check edit server registration properties". If an SQLServer instance is having both client and server network utilities why it is not possible to access both servers from both systems at the same time? With proper authentication and permissions it must be possible. Is this acceptale?

    Radhika
  17. Adriaan New Member

    You need to give us more details about what you are doing - is this happening in a batch script? are you executing a stored procedure on server1 that references something on server2 that is referencing server1? etc. etc.
  18. Radhikadatla New Member

    Hi I want to access all the SQLServer databases from the intranet.I am not using any stored procedures or any coding. I can access server1's databases from server2 but at the same time I am trying to access server2's databases from server1. Though I used same client and server settings in both SQLServers, One is working but why the other way is not working?WHY many-to-many relationship does not work?In both servers I am using SQLServer authentication. mixed mode.

    Radhika
  19. satya Moderator

Share This Page