SQL Server Performance Forum – Threads Archive

SQLServer Connections

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

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
[email protected] When life gives you a lemon, fire the DBA.

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
[email protected]

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
[email protected] When life gives you a lemon, fire the DBA.

Hi, here is a link FYI for Potential Causis of SQL Server Doesn’t exist or Access Denied : http://support.microsoft.com/default.aspx?scid=kb;en-us;328306</a> and you need to set your SQL Server to Mixed Authentication Mode , here is a reference how to do it : http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331</a> [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

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.

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

Hi, 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. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

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

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

SURYA

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.

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

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
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

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.

Radhika
PLease confirm other points raised above in order to corner the issue. http://msdn.microsoft.com/library/en-us/adminsql/ad_1_server_4uuq.asp
http://www.databasejournal.com/features/mssql/article.php/3085211 Fyi. 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.

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

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.

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

Have you checked the references from Hemant’s post
here is a link FYI for Potential Causis of SQL Server Doesn’t exist or Access Denied :
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306 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.

]]>