Using a Table located in a different DataBase

fractal · Feb 25, 2011

I have bougth 3 Data Bases in Discountasp.net all of them are used by the same web applcation (.net) they work perfect in my machines but when I uploaded the DB to the discountasp servers since sometimes Store Procedures that are in one of the Data Bases refer to a Table that is in the other Data Base I get the error:
The server principal "SQL2008_803472_fractalplat_user" is not able to access the database "SQL2008_803472_portfolio" under the current security context.

How can I avoid this problem? meaning I need some kind of trus mechanism since the 3 Data Bases are mine and belong to the same project I would like they to behave like they behave in my local machines.

RayH · Feb 25, 2011

Please see the following links:

http://blogs.msdn.com/b/lcris/archi...ity-concepts-logins-users-and-principals.aspx

http://msdn.microsoft.com/en-us/library/ms187096.aspx

Bruce · Feb 28, 2011

i notice that you are trying to connect to database "SQL2008_803472_portfolio" using a login with another database of yours.

By default, only the primary database user is given access to the database. If you want to use another login to access the database, you'll have to assign permission for the user.

See http://support.discountasp.net/KB/a189/how-do-i-assign-additional-sql-logins-to-my-sql-2008.aspx

Log in or Sign up

Using a Table located in a different DataBase

fractal

RayH DiscountASP.NET Lackey DiscountASP.NET Staff

Bruce DiscountASP.NET Staff

Share This Page

Log in or Sign up

Using a Table located in a different DataBase

fractal

RayH DiscountASP.NET Lackey DiscountASP.NET Staff

Bruce DiscountASP.NET Staff

Share This Page

Useful Searches