| Author |
Topic |
|
SQL_MAZFS
Starting Member
9 Posts |
 Posted - 2012-11-29 : 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
38200 Posts |
|
|
SQL_MAZFS
Starting Member
9 Posts |
Posted - 2012-11-30 : 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
38200 Posts |
|
|
SQL_MAZFS
Starting Member
9 Posts |
Posted - 2012-11-30 : 02:56:50
|
| i want to use database which is located on other computer through sql server 2000 enterprose managermazfs |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SQL_MAZFS
Starting Member
9 Posts |
Posted - 2012-11-30 : 03:13:15
|
| please tell me complete procedure... plzmazfs |
|
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
SQL_MAZFS
Starting Member
9 Posts |
Posted - 2012-12-01 : 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
39 Posts |
Posted - 2012-12-01 : 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/888228That 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
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-12-01 : 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
9 Posts |
Posted - 2012-12-02 : 00:16:11
|
| THANK U TO ALL.. I HAVE DO IT..mazfs |
|
|
|
|
how do i use shared database