SQL Server :: Windows Shared Hosting Error: Create Database Permission Denied In Database 'master'?
Mar 1, 2011
how I can correct an error. I've built the MVCMusicStore tutorial here:
The first time I visit the site and attempt a database connection I get this error:
Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.
But when I refresh, it all works fine. I'm at a bit of a loss. I don't believe I'm attempting to create a database, but I realise that the error may not really have anything to do with that. This is hosted at GoDaddy shared hosting. The database was created and I used an SQL script to create the tables initially and populate the data. My connection string works as I can pull data from the database, but I do have
a feeling it will be a web.config setting that will correct this.
Using VS 2008, and i downloaded sql server 2008 that came with installation. I created an applicaton, which runs perfectly when i click run from VS. but when i moved it to wwwroot folder, this error poped up:
CREATE DATABASE permission denied in database 'master'. Cannot attach the file 'C:InetpubwwwrootooksApp_Dataooks.mdf' as database 'books'. This is my <connectionStrings> <add name="books" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:InetpubwwwrootooksApp_Dataooks.mdf; Integrated Security=True; trusted_connection = true; User Instance=False; Initial Catalog=books" providerName="System.Data.SqlClient"/>
I am getting the error message "SELECT permission denied on object 'MyTable', database 'MyDB', owner 'dbo'.", when trying to run a small asp.net application via a browser where i work.
I built it on my local machine(VS 2008, C#) and transferred over to an IIS server(i.e. Windows Server 2003) and I have also enabled the application folder in IIS.
It runs fine on my local machine. Connection string in web.config on my local machine <add name="connstring" connectionString="Data Source=DBASE;Initial Catalog=MyDB;Integrated Security=true" providerName="System.Data.SqlClient"/>
on the server, connection string is <.......;User Id=userid;Password="mypassword" />.
But when i swapped connection string on server to use <Integrated Security=true>, and tried to run from a browser again, i get:
Login failed for user 'SVRSERVERNAME$'
I have a couple of other apps I built in the past and they are running fine, I didn't do anything special, just transferred them as normal to server and ran through browser
In fact, one of my previous apps even uses the same table and database. but with this new app, I don't know why it wouldn't work even though it runs perfect on my local machine
I can access the database manually from SQL Management studio, i connect to it using my Windows account or the given username/password credentials.
Other thing I noticed, when I changed the connection string on my local machine web.config to use <User Id=userid;Password="mypassword">, i then get same error as if it was running from the server:
SELECT permission denied on object 'MyTable', database 'MyDB', owner 'dbo'.
I am trying to deploy crystal reports 2008 on shared server. Before publishing on the remote server i published it on the localhost while connecting it to remote sql server 2008 database. The report is shown perfactly but when i publish it on shared server it prompt me for login credentials. My hosting provider is arvixe and it support crystal report. In my popup database field is empty and locked use name field show the correct user name and password field is empty. I read somewhere it may be due to version conflict between my version and version on server.
i have database that is stored on local.user should also be able to upload the database to online server . i am able to save it on local .But it is not saving on server.It shows request time out. Is it due to server not allowing external access.
I have upload my files in domain.after uploading,i run the site.i get the following error The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'. what reason for this error raised and how to solve it?.
I am writing an internal web app for a company who wont to use their existing Active Directory Logins (rather than a seperate SQL Database User Login Table).
To do this I have done the following
web.config <authentication mode="Windows"> <identity impersonate="true"/> <authorization> <deny users="?"/> <!-- Allow Public Users to Access --> <allow users="*"/> </authorization> <roleManager enabled="true" defaultProvider="AspNetWindowsTokenRoleProvider"/> End
This seems to work on my localhost but I have a couple of questions for you guys.
1) How does this process know which active directory to authenticate against? I know in code you can do
LdapAuthentication adAuth = new LdapAuthentication("LDAP://Server");
But there seems to be no way to do this in the web.config (I'm guessing it will just use the active directory on current machine it's running on?). Is there away to specify which active directory I'd like it to authenticate against?
2) If a user tries to access this remotely (i.e. not on their native windows account) what will happen, will it just default to a login form or just throw a "Permission Denied" error?
I'm wanting to use DB4o on an asp.net MVC project i'm working on but wondering if anyone has got this working on shared hosting plan, have contacted discountasp and asked them and they said go to the forum as they were not sure if they supported it or not or any configuration that would be needed. but the forum wont let my post on because its all filtered to only show comments they like the look of? anyone had any joy with this with another host and one that runs asp.net MVC as it should be run?
When I created table on the shared SQL server on hosting server using management studio, I right click mouse on the table, it pops up create table. However, the table schema is my user name but not dbo. I wnat to create table with dbo schema.
I have a windows shared hosting and i need to run some scheduled c# executable every day for create sitemap, send newsletter,etc...The provider tell me that i can't run executable for security reason.Whay can i do?The provider suggest me to buy a VPS, but do not think it makes sense to spend more money just to run some scheduled task.
I have a web application with a textbox and a button. When i click the button with a folder name in textbox a .xml file should be created in C: folder getting all the data from a method which retrives data from DAL. But clicking on button gives the error of access denied. I dont have sufficient permission. But when i run visual studio as administrator, this permission error does not occur, instead some other error i get. How can i get this permission to run this application?
I have recently succeeded doing a Publish to server from my local sql db and run the sql script on my web host's sql server 2005 db. Now, I get the "The EXECUTE permission was denied on the object 'MyStoredproc', database 'db12345', schema 'dbo'." error.I have Visual Studio Professional 2010, and that's where I create and manage my tables (in Server Explorer). However, when I right-click a stored procedure, I don't get a Seurity option or the like, where I could possibly set permissions.
I'm a bit usure of what SqlServer applications I have installed (as they are intertwingled with the Aps.Net stuff somewhat). When I look at Add/Remove software, this is what I find:
Microsoft Sql Server 2008 (562 MB) Microsoft Sql Server 2008 Native Client Microsoft Sql Server 2008 R2 Data-Tier Application Framework Microsoft Sql Server 2008 R2 Data-Tier Application Project Microsoft Sql Server 2008 R2 Management Objects Microsoft Sql Server 2008 R2 Transact-Sql Language Service Microsoft Sql Server 2008 Setup Support Files Microsoft Sql Server Compact 3.5 SP2 ENU Microsoft Sql Server Database Publishing Wizard 1.3 Microsoft Sql Server Database Publishing Wizard 1.4 Microsoft Sql Server System CLR Types Microsoft Sql Server CSS Writer
Can I use any of these apps to set the security settings? Or would I possibly not be allowed to change any settings at the web host's Sqlserver 2005 server anyway (due to security reasons)? Frankly I don't think I could ask them to change the settings for over a hundred stored procedures, and then call them each time I create a new one.
And also, I can't understand what the point would be in setting different security levels on SELECTs and UPDATEs etc. After all, all my pages call UPDATE statements (for collecting statistics). I guess that the host could set execute permissions on the entire folder (not sure though) but it would of course be a stupid idea if I'm wrong regarding this matter.
i am currently developing an asp.net mvc 2 web application and i would like to create new foldersprogrammatically with access rights, in order to enable loged on users upload their image files.My question has to do with how to assign write access using Directory.CreateDirectory function and assigning DirectorySecurity rules (meaning for which user should i enable user rights, etc...). Note that the hosting envirnoment uses IIS 7.
I used visual webdeveloper 2008 express edition to make a new WCF Service Application.If I test it on my pc it works perfectly , But if I publish it to my shared hosting site I get this erroris has a BuildProviderAppliesToAttribute attribute which includes the value 'Web' or 'All'.
The error is mentioned below, the cssfriendly.dll is in bin, and browser file is in there app_browsers folder. And it is working in same PC (developping PC), on remote server that belong to my company (i just installed .net 3.5 on that server)
I tried uploading the same site on 2 dufferents hosting, and finally i got the same error. What could gone wrong ? I tried contacting the hosting support but they work in ticketing system and this is extremely slow.
Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load type 'CSSFriendly.MenuAdapter'.
I built a website using SQL 2008 Express. I want to deploy it to a hosting company (shared server). If I change the SQL 2008 Express database on my local machine (further development of the website), how can i synchronize the local SQL database with the one on the server without loosing data?