Re: smo create database object


"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.


.

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: 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: 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
    ... 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: Cant connect to sql server 2005 after sysprep
    ... > 2005 and after using sysprep, the SQL ... Open SQL Server Surface Area Configuration ... > Extend Database Engine and make sure Remote Connections is enabled for ...
    (microsoft.public.sqlserver.connect)