Blog Stats
  • Posts - 170
  • Articles - 4
  • Comments - 54
  • Trackbacks - 7

 

<< More on code behind in .Net 2.0 Beta2 | Home | XML Options in Microsoft SQL Server 2005 >>

SQL Server 2005 assemblies, what's about hosting ?

If I heard well Nick Grattan on Monday, you must be logged into SQL Server using an integrated security login, as opposed to a sql server account, in order to create a .NET assembly in SQL Server 2005.

But what's happens if you use a hosted SQL server? I don't see my actual provider giving me more privileges on their machines.

And how the deployment will work ?

 

Print posted @ Wednesday, January 19, 2005 12:55 PM

Feedback

# re: SQL Server 2005 assemblies, what's about hosting ?

Gravatar I though he said that you needed to be DBO to post stuff to the SQL server. In theory you dont need to use Integrated Security to login, that just makes it easer and quicker. At least i think thats whats going on. havent tried it yet, but i will be since my network at home is not a domain. 1/19/2005 4:58 PM | Tiernan OToole

# re: SQL Server 2005 assemblies, what's about hosting ?

Gravatar Well in his demo I think I remembered Nick added Integrity security stuff to his connection string, and if it's yes it could be a problem.
It also makes sense because assemblies should run under Windows privileges and not SQL logins. 1/19/2005 6:10 PM | Paschal

# re: SQL Server 2005 assemblies, what's about hosting ?

Gravatar As I read it, integrated security is required:
http://weblogs.asp.net/pwilson/archive/2005/01/08/349311.aspx
1/19/2005 6:24 PM | Paul Wilson

# re: SQL Server 2005 assemblies, what's about hosting ?

Gravatar As I see .NET assemblies in SQL Server 2005, they're a replacement for extended stored procedures known from SQL Server 2000 - and not a replacement for normal stored procs, not a way to do day-to-day development. Have you seen any hosted SQL Server 2000 environmet which allows you to deploy extended stored procedures? So I think that it is not as big problem as it seems at first glance. 1/20/2005 4:33 PM | Michal Chaniewski

# re: SQL Server 2005 assemblies, what's about hosting ?

Gravatar Actually, after reading further, it will be possible for hosters to enable this, although its a different issue about whether or not they should or will. The solution is that you can assign a Windows credentials to a Sql login -- so a hoster would need to create a Windows user account with permissions limited correctly to that user's directories and then assign those credentials to the matching Sql login. That's certainly doable, but I still have to believe that most shared hosters will not offer this functionality -- but we'll see. And I'm also still not convinced there's enough reason to allow it when you consider that opening up this door could potentially open up some security holes or hurt performance (maybe not though). 1/25/2005 1:54 PM | Paul Wilson
Comments have been closed on this topic.
 

 

Copyright © Paschal L