ASP.net insists on using dbo. to call aspnet_* stored procedures
- From: "Pedro Vera" <pedro.vera@xxxxxxxxx>
- Date: 30 Mar 2007 06:30:50 -0700
I am helping somebody setup one of the asp.net starter kits. I
converted it from sql express to sql server with no real issues, and I
got it running local perfectly.
On my first attempt to run it remotely I noticed that a lot of the
queries had dbo. hardcoded and that SQL server on the remote server
was not allowing my sql account access to these. I removed all
mentions of dbo. and again it still runs local. I have posted it to
the remote server once again, but I still get errors like this:
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'
Now, the common sense answer here is that the remote database was not
primed properly with:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe
But this is not true. The remote db was primed properly and I can run
aspnet_* stored procedures from enterprise manager logged in using the
same account used in the connection string.
Any idea how I can go around this? My worst case scenario is to grab a
clean copy of the starter kit and instead of removing dbo., changing
it from dbo. to mysqlusername. and see if that helps.
Thanks,
Pedro Vera
http://veraperez.com
.
- Follow-Ups:
- Re: ASP.net insists on using dbo. to call aspnet_* stored procedures
- From: Cowboy \(Gregory A. Beamer\)
- Re: ASP.net insists on using dbo. to call aspnet_* stored procedures
- Prev by Date: Re: InnerHTML drops leading tag in SELECT
- Next by Date: Re: what is 8.3000000000000004E-2
- Previous by thread: About masked text box
- Next by thread: Re: ASP.net insists on using dbo. to call aspnet_* stored procedures
- Index(es):
Relevant Pages
|
