Search : in
By :

Remote Access to SQL express db

Sandra_ch84, on May 12, 2009 8:02:22 am BST 
 Report this message to moderators

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!

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Remote Access to SQL express db » in :
Automatic backup of a Database in SQL EXPRESS 2005 Show Automatic backup of a Database in SQL EXPRESS 2005 If you want to automate a backup of a database in SQL Server Express, there is a simple solution using a .bat. file. Create a new text file. This file should contain the following...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Do you need a fix IP for remote connection? ShowDo you need a fix IP for remote connection? Myth Truth How does it work? An Internet Service Provider will usually provide a user with a fix IP address that cannot be changed by the user himself. This number is used by another...
Log in remotely with SSH (Linux) ShowLog in remotely with SSH (Linux) Issue Solution Using SSH through a proxy: Issue Log in remotely with SSH under Linux. Solution The commands below are relevant only if you have an existing account on the PC you want to connect and...
Installing a VPN server in Windows XP ShowAdvantages of a VPN The set-up of a virtual private network enables the secure connection of remote computers through an unreliable connection (Internet), as if they were on the same local area network. This process is used by a variety of...
Random access memory (RAM or PC memory) ShowTypes of random access memory There are generally two broad categories of random access memory: DRAM memories (Dynamic Random Access Module), which are inexpensive. They are used essentially for the computer's main memory SRAM memories (Static...
PCI Express Bus (PCI-E) ShowThe PCI Express Bus The PCI Express bus (Peripheral Component Interconnect Express, written PCI-E or 3GIO for "Third Generation I/O"), is an interconnect bus that allows you to add expansion boards to a computer. The PCI Express bus was developed...