Remote connection on SQL Server 2005 Express
Home > IT Answers > SQL Server > Remote connection on SQL Server 2005 Express
9995595347
35 pts.
0
Q:
Remote connection on SQL Server 2005 Express
SQL Express 2005, Remote connection, SQL Server 2005 Express
shibu.govind is online.
shahina: http://support.microsoft.com/kb/914277


Sent at 11:26 PM on Tuesday
shahina: F:\C#PROJECTS\QMSED2.0\QMSED\BIN\DEBUG\QMSED\QMSED.MDF


Sent at 11:52 PM on Tuesday
shahina: firewall.cpl


Sent at 12:20 AM on Wednesday
shahina: C:\Program Files\VMS\Rlink SMS Ed V2.0
3:35 AM NODE3\SQLEXPRESS;Initial Catalog=G:\C#Projects\VMSClinic1.0\QMSEd\bin\VMSClinic\VMSClinic.MDF;Integrated Security=True" />-->

--------------------------------------------------------------------------------




shahina: Hello,

I have microsoft sql express installed on one computer running on windows authentication.

I am trying to access the tables in one of the databases on it from another computer.

When i enter the server ip and use windows authentication, it logs in successfully. and i am able to view the databases on the other pc. however i am only able to view system tables. and not the ones i want (which are user tables).

can anyone help? I would be grateful. i have been stuck on this for days and i've searched every possible site on the internet. thanks in advance!

.
ASKED: May 19 2009  8:19 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
The Windows account that you are using to access the remote doesn't have access to the tables which is why you can't see them. The person who's computer you are accessing will need to give you access to the tables.
Last Answered: May 20 2009  0:41 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29845 pts.  |   May 19 2009  11:19PM GMT

Is the user you are connecting with the owner of the tables ? have you tried accessing the tables this way ?

schema_name.table_name

 
0