SQL Server Express

OK, I am confused with this specific security issue. I do not have access to full SQL Server 2005, only the Express edition, which came with no documentation. I have been reading through the MSDN online files, but I get more confused than informed.

This is a 'standard' installation of SQL Express, which was performed in this case along with the Visual Studio 2005 package, so it is installed as "Beast\SQLExpress", where "Beast" is the name of the system on which it is installed.

The standard installation does not seem to have an "sa" password, and it seems to permit any valid Windows user to connect to and manage any database. I do not see any obvious way to disable this, and I would only want to do that with specific databases, and not the installation as a whole.

I have a series of questions, and if anyone can answer some or all of these, I would be most appreciative.

1. How can I disable Windows users from connecting to or accessing specific SQL Express databases, but permitting free access to others?

2. I am able to create a schema and associate it with database users so that it is their default schema, but must I decorate all table names with the schema when creating tables? Or can I set a mode where any new table created uses the default schema?

3. I create a new SQL Express database, define a login, define a user, and then create a new connection to that new database using the new login and user -- but any tables I create are still owned by dbo and marked as created by my Windows login account! Why are they not being created by the login identifier specified in the SqlConnection?

4. How can I get access to the SQL Server 2005 "Books Online" equivalent without installing the entire SQL Server 2005 product?

-ken
.

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: installing help for sql 2005
    ... you have database users that are not mapped correctly to logins. ... SQL Server Documentation Team ... installation help with snap shots because i installed the sql server ... remote connections are disabled by default. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL SERVER 2008 Express + SP1
    ... I installed the SQLXPR_X64, and before I attempted the SP1, SQLEXPRESS database was 64bit for the configuration, better yet the repair do work anymore because SP1 changed them somehow to 32 and the original install was 64 ... If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. ... And regarding your sql server installation, ...
    (microsoft.public.sqlserver.setup)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
Loading