Re: How do I remove my development server log from my client site during login?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

What do you mean when logging in? How are you logging in and what tool are you using? The mdf & ldf files know nothing of the server they may have been attached to. There is no information stored in them at the server level. I suspect you are using SSMS on your laptop and when you open it the last server you were connected to is chosen in the dropdown. But if you try to connect to it you will find it fails unless you have access to it from your client.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Robert Johnson" <johnson_r@xxxxxxxxxxxxx> wrote in message news:umVfkCsDIHA.5360@xxxxxxxxxxxxxxxxxxxxxxx
Hi all. I have devleoped a MSSQL 2005 database for my client. I detached and copied the mdf and ldf files a CD then attached to my clients MSSQL. However when logging in it shows a list of servers and my server is on the list. How do I remove /edit this ? This happends after we have connected to MSSQL and are now attempting to connect to the database it seems. Clear as mud? It has to be something in the mdf or ldf files because it is the name of my server at my office and nothing at my client matches.

Robert



.

Relevant Pages

  • Re: Removing SQL Instance Name
    ... copy off the mdf and ldf files to a safe location ... "Senthil" wrote in message ... I've the server as an instance. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 express security issue
    ... Only if they then get hold of the MDF and LDF files and attach them to their ... instance of SQL Server - if you allow access to the underlying files then ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 express security issue
    ... It is a local standalone application, ... Only if they then get hold of the MDF and LDF files and attach them to their instance of SQL Server - if you allow access to the underlying files then you're at risk no matter what software you use. ...
    (microsoft.public.sqlserver.security)
  • Re: sp_attach_single_file_db
    ... You can put the MDF and LDF files wherever you want and attach them with ... sp_attach_single_file_db (which is for MDF file only). ... > Is there a way to specify NEW file locations when using ... > You see the issue I have here is that, on one of my server ...
    (microsoft.public.sqlserver.server)
  • Re: RDP Sessions not "disconnecting"
    ... You can logon to the Console as Admin and Disconnect instead of logging off and this will leave Admin logged on to Synch Act and will leave 2 more Remote slots open. ... The other choice is to disconnect from a normal session as Admin instead of Logging off and when you connect again you will resume your session. ... server based apps - she also hits it from remote. ...
    (microsoft.public.windows.server.sbs)