Re: SQL Server 2005 Express Remote connection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Roy,

http://support.microsoft.com/?scid=kb;en-us;914277&x=9&y=11 could help you

Daniel


"Roy Thompson" <rothco@xxxxxxx> a écrit dans le message de news:2E71D1C3-3728-4045-8C5B-33912D657642@xxxxxxxxxxxxxxxx
Hi

I am a relative newbie to SQL Server

I have set up a SQL Server 2005 Express database on my server and am trying
to connect to it from a workstation. I did all the stuff about Surface
configuration, etc. I was still having some problems connecting through my
program so I downloaded a copy of SQL Express Management Studio to my client.
Now I can connect to the remote database fine. So the problem is not my
client seeing the server. Mgmt Studio on the client allows me to logon using
windows authentication. The trouble is that whilst I can connect using my
Windows name I cannot see the database that I want to get into from the
client. I can see and explore all the system databases but not the one I
created on the server!

On the server I have setup the user name and set the user mapping to point
to my database but when running from Mgmt Studio on the client I do not see
the database.

What have I done wrong?

Thanks
--
Roy Thompson
Independent Developer
Specialist in Sage Accounting solutions (UK)

.

Relevant Pages

  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Remobjects v KBM
    ... >> client query components) follow from that. ... Then, connections can be created to say SQL Server, Oracle, Interbase and ... can then be created from the abstract dataset definition in 'customers' to ... implicitly - this makes your code not be database connection specific). ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Help with first VB application - Data Entry form
    ... stamp from the database machine - control machine ... ... unnecessary data to the client ... ... and when building a database independent UI / Client - Server application, ... JavaScript, for example) and thus, will get the time from the web server, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Opinions needed about the best "Middleware suite" kbmMW vs. RODA
    ... kbmMW supports cross db in such way that all you need to do in your application is to set one property to switch to ... What one have to concentrate about is minimizing the amount of data moved from the app server to the client. ... C/S setup's usually have a quite active chatter going on between the client and the database, ...
    (borland.public.delphi.thirdpartytools.general)