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 |
|
tarana
Starting Member
12 Posts |
 Posted - 2011-08-22 : 13:50:15
|
| I am in the process of developing a SQL Server Express 2008 database. I use XP Pro for development, but use Windows 7 to demo to client.The original DB when it was created under XP Pro has a user XPComputerName\ASPNET. The owner name is XPComputerName\XPLoginID.Each time I copy the database to Windows 7, I go to Properties=>Files & add the owner as NT AUTHORITY\SYSTEM as I am unable to access the Database Diagrams.Will there be any issues if I just change the owner to NT AUTHORITY\SYSTEM on XP? When I finally move this database to the actual web sever, what should I set the owner as? Should I leave the user XPComputerName\ASPNET? Or is this user required for VS2008? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tarana
Starting Member
12 Posts |
Posted - 2011-08-22 : 18:11:25
|
quote:
Originally posted by tkizer
I use sa as my owner. So much easier than having to worry about Windows accounts.
Windows Authentication is much more secure than SQL Server Authentication. My client security policy will not allow SQL Server Authentication. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tarana
Starting Member
12 Posts |
Posted - 2011-08-24 : 08:05:11
|
| Solution was not acceptable to client as they have a user "sa" with SQL Server Authentication.Cutomer will be using Windows Authentication.Can you give a explanation how this will be a good solution to my problem.Also what about the ASPNET user? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tarana
Starting Member
12 Posts |
Posted - 2011-08-27 : 04:10:13
|
| Let me understand this. Does this mean owner "sa" (with Windows authentication) is not the same as the user "sa" used with SQL authentication? If this is true, then I can name the owner anything I want right? I am having difficulty understanding this solution and these are the questions coming from my client.Also, with the owner "sa" alone, will the web pages have rights to read & write to the tables? |
|
|
|
|
|
|
Database Permissions