adding database

I am trying to add a database to our site but get the following error message:

CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error:262)

any ideas?

 

then just create a new user to login in with for the blog only?

 

Hi,
You'll need to fill in a few more details so we can understand what you are attempting.
For instance, you are assigned a DB with your account.
You can Add-on additional DBs.
If you are creating a blog or adding a Blog it will use your assigned DB, but it can create and use new Tables in that assigned DB.
'Create Database' is a server tree function where your account's DB currently exists, unlike a local DB server.
Salute,
Mark

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

 

Hi,
Don't specify the DB name, let it result to your default DB, which is not the Master.
Salute,
Mark

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

 

I am 'trying' to add WordPress to our website for a blog. We are currently only using 12% of our database, and really don't want to double our database to create a new one.

I think I understand.....let me restate to make sure.

The blog can use the database that the website is currently on. (Instructions for WordPress say to create a new database, but I can do it without)
The blog will create new tables within the current DB separate/in addition to the current website information.
I can create a user login id for the blog that is separate from the main login.

Is there a chance for any of the tables from the blog to have the same name as a table from the current website? That could be the reason WordPress is wanting another DB. Does it make a difference to do a subweb for the site? Would using the same DB with the subweb address eliminate the possibility of the tables having the same names?

Thanks again for the help.

 

after looking further into it, you were right!!!! (don't you love hearing that?)

Are there any blogs out there that can be used on msSQL and not mySQL?

 

Hi,
There are several very good ASP.NET blogs that use SQL and Access.
Good list here: www.asp.net/community/projects/
Look towards the bottom, SubText is one you will probably like.
Salute,
Mark

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

 

Hi,
Wordpress works with SQL Server? Did not know that.

General rules for your accounts Database should be to always use a prefix if you can.
Most of the time a setup package, like Forums or Blogs, will allow you to add a prefix.
This way when new objects are created they won't conflict with existing objects.
Also helps you when it comes time for any house cleaning, i.e. blog_fn, blog_sn, blog_badwords.
Salute,
Mark

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx