Re: smo create database object

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"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


.

Relevant Pages

  • Re: Quick Question on SQL Server 2005 Express
    ... you can't attach a database in a remote machine in your network as Andrew has already mantioned. ... One database can be used only by one SQL Server instance and as far as I understand the database in question is already attached to a SQL Server instance. ... Why not installing only SQL Server Management Studio and connect to your remote instance and perform actions this way? ... The Client can live anywhere as long as it has TCP access to the server. ...
    (microsoft.public.sqlserver.setup)
  • 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: Quick Question on SQL Server 2005 Express
    ... I have been away all week, but I can report that I did manage to connect to the "remote" version of SQL Server. ... I have now set up an Express version on our LOCAL server, and have linked a second Express version to this server via the network, as above for my client. ... We had discussed having our own licenced copy SQL Server 20052008, but with the cost etc, it was suggested that we use the licenced central server and a copy of Express to just hook up and do a bit of manipulation of our database. ...
    (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 ... not sure why smo needs remote connectivity to do this? ...
    (microsoft.public.dotnet.languages.csharp)