| Author |
 Topic  |
|
|
SQL_MAZFS
Starting Member
Pakistan
6 Posts |
 Posted - 11/29/2012 : 11:28:02
|
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
35017 Posts |
|
|
SQL_MAZFS
Starting Member
Pakistan
6 Posts |
Posted - 11/30/2012 : 02:34:20
|
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 |
 |
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
|
|
SQL_MAZFS
Starting Member
Pakistan
6 Posts |
Posted - 11/30/2012 : 02:56:50
|
i want to use database which is located on other computer through sql server 2000 enterprose manager
mazfs |
|
|
|
tkizer
Almighty SQL Goddess
USA
35017 Posts |
|
|
SQL_MAZFS
Starting Member
Pakistan
6 Posts |
Posted - 11/30/2012 : 03:13:15
|
please tell me complete procedure... plz
mazfs |
|
|
|
bandi
Flowing Fount of Yak Knowledge
India
1700 Posts |
|
|
SQL_MAZFS
Starting Member
Pakistan
6 Posts |
Posted - 12/01/2012 : 04:56:29
|
SERVER IS NOT CONNECTING FOLLOWING ERROR IS COMING... HOW I DO RESOLVE THIS???
Servername-SQLSERVER does not exist or access denied.ConnectionOpen[connect[]]
mazfs |
|
|
|
Elizabeth B. Darcy
Starting Member
United Kingdom
39 Posts |
Posted - 12/01/2012 : 08:34:45
|
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" |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1795 Posts |
Posted - 12/01/2012 : 08:56:22
|
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 |
|
|
|
SQL_MAZFS
Starting Member
Pakistan
6 Posts |
Posted - 12/02/2012 : 00:16:11
|
THANK U TO ALL.. I HAVE DO IT..
mazfs |
|
|
| |
Topic |
|
how do i use shared database
