locked
VB.Net 2008 using SQL server 2005 Express with more then 1 user? RRS feed

  • Question

  • I using VB.Net 2008 to connect to SQL server 2005 express edition database file using this connection string:

    Code:
    Data Source=.\SQLEXPRESS;AttachDbFilename=" & mCurrentDB & ";Integrated Security=True;Connect Timeout=30;User Instance=True

    When

    Code:
    mCurrentDB

    is the full path to the database file.
    But this works only for one user so if i want to run the application from 2 computers and to connect it to one same database file i just cant since the second application will not connect to it.

    Is this something that can be fixed in my connection string?
    Do i need to install any aditional files\options in the SQL server setup?
    Please help me to understand it...
    Thanks

    Wednesday, August 18, 2010 5:53 AM

Answers

  • Do you mean it does not work from remote machine? And locally on the server  you do succeed to connect? What exact error  you are getting? I hope SQL Server Browser service is running up as well
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, August 18, 2010 6:28 AM