RE: Will I be able to connect?

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

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: Local datastore for visual basic .net aplication on a pda
    ... In other words, if you don't need to sync your datastore with the desktop, ... SqlServerCe is what you want. ... >> database file as an local datastore without the SQL server running? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Upgraded to Visual C# Express 2005 SP1, can no longer persist data in SQL Server Express
    ... none of my apps will persist data to ... SQL Server Express (have not yet applied the Service ... Just off the top of my head, could it be that your database file is copied to the bin directory each time you build/run, so that you always start with the same version? ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Getting 5105 error when I try to attach database
    ... check SQL Server does to detect if I'm accessing a database file through a ... database file over a network share anyway. ... >> activation error), it gives the same path that I gave it, and says that the ...
    (microsoft.public.sqlserver.server)
  • Re: How can I check..
    ... from sysindexes s inner join sysfilegroups fg ... Wayne Snyder, MCDBA, SQL Server MVP ... community of SQL Server professionals. ... > How can I check which table is a part of this database file? ...
    (microsoft.public.sqlserver.server)
  • Re: MS Access function in SQL Server?
    ... SQL Server pre-allocates storage, for performance reasons. ... would require the database file to grow and growing files is an expensive operation. ... "rodchar" wrote in message ...
    (microsoft.public.sqlserver.server)