SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 how do i use shared database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SQL_MAZFS
Starting Member

Pakistan
9 Posts

Posted - 11/29/2012 :  11:28:02  Show Profile  Reply with Quote
Hello every one, i am little bit confused that how i use shared database on other computer using sql server 2000. i have need complete details. thank you.

mazfs

tkizer
Almighty SQL Goddess

USA
36594 Posts

Posted - 11/29/2012 :  14:44:39  Show Profile  Visit tkizer's Homepage  Reply with Quote
I don't understand the question.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

SQL_MAZFS
Starting Member

Pakistan
9 Posts

Posted - 11/30/2012 :  02:34:20  Show Profile  Reply with Quote
Suppose two computers are connected to each other, on both computers SQL SERVER 2000 is installed, i want to access database from A computer to B computer. HOW IS IT POSSIBLE????

mazfs
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36594 Posts

Posted - 11/30/2012 :  02:46:28  Show Profile  Visit tkizer's Homepage  Reply with Quote
Do you mean how to connect via Enterprise Manager or Query Analyzer? Or are you referring to some other software package? For EM/QA, just type in the hostname (if default instance) or hostname\instancename (if named instance).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

SQL_MAZFS
Starting Member

Pakistan
9 Posts

Posted - 11/30/2012 :  02:56:50  Show Profile  Reply with Quote
i want to use database which is located on other computer through sql server 2000 enterprose manager

mazfs
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36594 Posts

Posted - 11/30/2012 :  02:59:56  Show Profile  Visit tkizer's Homepage  Reply with Quote
Then connect with hostname or hostname\instancename. You'll need to given access though.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

SQL_MAZFS
Starting Member

Pakistan
9 Posts

Posted - 11/30/2012 :  03:13:15  Show Profile  Reply with Quote
please tell me complete procedure... plz

mazfs
Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2202 Posts

Posted - 11/30/2012 :  03:42:24  Show Profile  Reply with Quote
See the process of connecting with SQL server
http://www.serverintellect.com/support/sqlserver/connect-database-enterprise.aspx

http://www.hosting.com/support/sql/enterprise-manager
--
Chandu

Edited by - bandi on 11/30/2012 03:55:44
Go to Top of Page

SQL_MAZFS
Starting Member

Pakistan
9 Posts

Posted - 12/01/2012 :  04:56:29  Show Profile  Reply with Quote
SERVER IS NOT CONNECTING FOLLOWING ERROR IS COMING... HOW I DO RESOLVE THIS???
Servername-SQLSERVER does not exist or access denied.ConnectionOpen[connect[]]

mazfs
Go to Top of Page

Elizabeth B. Darcy
Starting Member

United Kingdom
39 Posts

Posted - 12/01/2012 :  08:34:45  Show Profile  Reply with Quote
Most often, if you google for the EXACT error message, you will get to Microsoft KB articles, blogs, or other discussion boards where people have encountered this problem. The first page I got when I copied your error message string is this: http://support.microsoft.com/kb/888228

That KB article seems to address a problem with named instances, so unless you are using a named instance, that may not be your problem. However, google around a bit and you will bump into someone or other who ran into exactly the same problem and resolved it.

______________________________________________
-- "If a book is well written, I always find it too short"
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2004 Posts

Posted - 12/01/2012 :  08:56:22  Show Profile  Visit jackv's Homepage  Reply with Quote
a) Ping test - Can you ping to the server?

b) Telnet test - Can you make a telnet connection connection?

c) Are the SQL services started ?

d) Can you connect from the server where the SQL Server is based?

e) Checked the Authentication Mode settings on SQL Server. Are you using the correct setting? The setting must be in Mixed Mode to accept SQL usernames and passwords.



Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

SQL_MAZFS
Starting Member

Pakistan
9 Posts

Posted - 12/02/2012 :  00:16:11  Show Profile  Reply with Quote
THANK U TO ALL.. I HAVE DO IT..

mazfs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000