Re: smo create database object


"RobinS" <RobinS@xxxxxxxxxxxxxxx> wrote in message
news:rp6dnVmTnoXyciPYnZ2dnUVZ_uWlnZ2d@xxxxxxxxxxxxxx

"Martin" <trobecgeologygroup@xxxxxxx> wrote in message
news:c0xvh.821965$1T2.115134@xxxxxxxxxxxx

"RobinS" <RobinS@xxxxxxxxxxxxxxx> wrote in message
news:8Jqdna1MkJKhEyDYnZ2dnUVZ_uWlnZ2d@xxxxxxxxxxxxxx

"Martin" <trobecgeologygroup@xxxxxxx> wrote in message
news:WY6vh.824924$R63.66669@xxxxxxxxxxxx

"Stefan Hoffmann" <ste5an@xxxxxxxxx> wrote in message
news:eDG1tIwQHHA.2172@xxxxxxxxxxxxxxxxxxxxxxx
hi Martin,

Martin wrote:
Does anyone know if it is possible to use the smo db.Create() method
to create a new sql server database with sql server 2005 express? The
debugger complains that remote operations are not allowed with the
default install of sql server express.
That is correct, you have to enable it first using the Surface tool.

mfG
--> stefan <--

Thanks Stefan

I've tried the surface area configuration tool, but the database engine
settings pages states sql server express version can only be run in
local mode. Is there another surface tool I'm not aware of?

I'm only trying to use smo with my databases on my local c disk, so I'm
not sure why smo needs remote connectivity to do this?

Martin


It considers anything outside the database to be a remote connection.

When you run the Surface Area Configuration, and you go into Services
and Connections, and click on your database, does it show a line for
"Remote Connections" ? Set it to accept local and remote connections.

Robin S.


Thank you Robin

Yes it does show a 'remote connections' line but enabling this option
didn't
work. I'll try re-installing the express version and selecting the 'mixed
mode' option to see if that helps.

Cheers, Martin


Isn't there another line under that one that says something about Piped or
TCP/IP connections? I have both enabled.

Good luck.
Robin S.


Thank you Robin

As it turns out, the 'remote connections not allowed' error message was not
the cause of my problem. I spent a day trying every surface area setting and
reinstalling but the problem was actually fixed by correcting an error in my
connection string.

Smo is working fine now with my server in local mode only and I am able to
create database and tables via csharp code.

Cheers, Martin


.

Relevant Pages

  • Re: smo create database object
    ... method to create a new sql server database with sql server 2005 ... I've tried the surface area configuration tool, but the database ... When you run the Surface Area Configuration, ... Set it to accept local and remote connections. ...
    (microsoft.public.dotnet.languages.csharp)
  • 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: smo create database object
    ... to create a new sql server database with sql server 2005 express? ... I've tried the surface area configuration tool, but the database engine ... When you run the Surface Area Configuration, ... Set it to accept local and remote connections. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: smo create database object
    ... create a new sql server database with sql server 2005 express? ... debugger complains that remote operations are not allowed with the ... I've tried the surface area configuration tool, but the database engine ... Yes it does show a 'remote connections' line but enabling this option didn't ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)