My problem is that I have a Visual Web Developer Express 2005 web site that uses a SQL Server 2005 Express database that is required to use an integrated security connection. The account that has access to that database is the windows user name and password that I have on my home computer (\\Bills\Ryan pwd:xxxxxx). When I try to work on this web site from my office computer, I can not access the database since the computer is on a different network that gives me a different windows account and password and the computer name is different (\\CPTCPSW2VX7P11\rc71030 pwd:yyyyyy). Since the windows accounts are differnt, I can not get client access to my database in the App_Data folder. I basically have three questions numbered below:
1) When using SQL Server Express 2005 with an integrated security connection (is this required ), is the server name part of the database's user name and password that was created from the current windows account when the database is originally created Or is my problem only related to different windows user name and password
2) How do I give both accounts client access to the database, I realize I can use user instance, but that is only for server side DBO access. Is that true Can I set user instance to true, integrated security to false, and provide the user name and password I use on my home computer
3)If the computer name is not part of the user name and account, can I create a local user on my office computer with the name of ryan and give it the same password. I am thinking this is not possible since my office computer is on a domain network, and my home comuter is in a workgroup.
If someone can answer these three questions, I would greatly appreciate it. Also, if you have a simple solution, I would love to have it, but please answer the questions as well so I understand the solution as well as use the solution.
Thanks so much,
RPC
Using SQL Server 2005 Express on two different machines with different widows accounts
Kileran
(1) Integrated security have better security feature. But it is not mendated. Server name is not part of user name. You can use SQL authentication too, you need to create SQL username and pass to use it. You are also require to install sql express in mixed authentication mode.
(2) I don't understand your question.
(3) To make integrated security work, you can create a local account with same user name and pass on both server and client machines. Make sure you grant the local account access to your SQL Exress service. Then you can use that account to access the server remotely, no matter wether they are in same domain, different domains or from workgroup to a domain. Keep-in-mind, this feature is to provide back-comp for lower SKU of windows, it might change in the future. Use domain account won't work.