Re: Will I be able to connect?

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

Hi Charles,

Thanks for your reply.

What do you mean that I should ensure that the .mdf is from an earlier
version of SQL Server Express? The file will be moving from SQL 2005
Express to SQL 2005 Express.

I haven't tried this yet, so I can't say if I have encountered any issues.

Thanks.

"Charles Wang[MSFT]" <changliw@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:oM1Pca$LIHA.6908@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Scott,
I understand that you would like to know if you can use trusted connection
in your VB.NET application after you detach/attach your SQL Server 2005
database file from one server to another server with SQL Server 2005
Express Edition.
If I have misunderstood, please let me know.

It is no problem if the current process account has enough permissions
(read and write). However please also ensure that the .mdf file should be
from an earlier version of your current SQL Server 2005 Express Edition.

For some known issues, you may refer to the section "Common issues" in
this
article:
SQL Server 2005 Express Edition User Instances
http://msdn2.microsoft.com/en-us/library/bb264564.aspx

Did you encounter any issues when you use trusted connection after the
migration?

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.



.

Relevant Pages

  • Re: i am afraid backup log with no_truncate is useless .
    ... Also, if the whole SQL Server goes down, then you can still get up to minute recovery. ... Backup log with no truncate behaves correctly at sql server 2000, in as much as you can back up the lock even ... when the mdf is unavailable. ...
    (microsoft.public.sqlserver.server)
  • Error 1813 or "WHY didnt they call me earlier?"
    ... 3- copy the data file (mdf and ndf's) over the ones from ... 4- start sql server ... >The SQL Server 7.0 database on this server appear after ... >but I get an error telling me that ldf file and mdf file ...
    (microsoft.public.sqlserver.server)
  • Re: SQL file sizes
    ... the procedure since and the MDF is now 337MB, ... You might want to run the SBS 2003 Best Practices Analyzer (if you ... Are you using SQL Server and if so what version? ... Open SQL Server Management Studio and the Monitoring DB. ...
    (microsoft.public.windows.server.sbs)
  • Re: MDF to MDB
    ... An mdb won't help because it's limited to 2 GB. ... And you would need the mdf running under some kind of SQL Server for Access to be able to extract any data. ... But i cannot attach mdf file ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: .sdf?
    ... *.mdf is the data file of SQL Server/Express. ... you cannot use *.mdf the same way as *.sdf. ... SQL Server CE is file based database engine, aimed for single user use. ...
    (microsoft.public.dotnet.framework.windowsforms)