开发者

SQL Server 2008 R2 "Server Accounts" installation setup question

开发者 https://www.devze.com 2023-03-29 00:28 出处:网络
I am installing SQL Server 2008 R2 Web on my Mac (OS X Leopard), running Parallels 6 and Windows 7...

I am installing SQL Server 2008 R2 Web on my Mac (OS X Leopard), running Parallels 6 and Windows 7...

The database will be used for ASP.NET development purposes. I am trying to figure out what Windows Accounts to use for each SQL 2008 Service when prompted by the installation (e.g. SQL Server Agent, SQL Server Database Engine, SQL Server Reporting Services, SQL Server Full-Text Filter Daemon Launcher and SQL Server Browser). If I can simply create a new user account and use it for each service, that is okay, I've seen an example of that here. I guess my concerns are twofold:

  1. Making 开发者_开发问答sure that the accounts I wind up using have the proper privileges suitable for vs2010 development/debugging.
  2. Making sure that the accounts I wind up using do not pose any security concerns associated with my mac


Firstly, Windows 7 is not a supported OS for SQL Server Web Edition, so it's unlikely that what you're trying to do will even work. I don't know anything about Parallels, but if it is a similar concept to VMWare then I guess that your Windows 7 installation should behave like any other Windows 7 installation.

Second, the considerations for SQL Server service accounts are well documented, including security issues, and so is the setup required for debugging in Visual Studio.

Finally, and for what it's worth, developing software of any kind in an 'unusual' environment that isn't the same as the environment where the application will be deployed usually leads to problems. It's just much easier and more reliable to develop in a 'native' environment, although I appreciate that if you're doing this as a hobby then you may not be able to have exactly the resources you want. If you're doing this professionally, you should be able to justify the cost of a native development environment.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号