Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Guy007
Starting Member
6 Posts |
 Posted - 2007-04-17 : 03:45:22
|
| I am writing a DB-driven application, using Visual Studio. I have a database that i want to be able to move from one computer to another, and still be able to access it. It's probably something simple, but I must be missing out something.The problem is that if i choose windows authentication, then the DB cannot be used on another computer. I also had no luck when using SQL Authentication.How can this be done? What form of authentication should be used and how, so that I can just copy my DB from one computer to another, then log into the DB using a username and password?*Any* help would be greatly appreciated! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-17 : 11:02:27
|
| Did you cerate sql login for the account you used on target server? |
 |
|
|
Guy007
Starting Member
6 Posts |
Posted - 2007-04-17 : 11:17:05
|
Yes, but when i tried to access a table that i had added to the database from on another computer, i could not access it from my C# code. If i create the table locally, then everything works fine!  very strange...! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-17 : 14:11:21
|
| Did you get any error message? Did you grant permission after adding table? |
|
|
|
|
|
|
Sharing a database - authentication!?