Re: smo create database object


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


.

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: 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: Quick Question on SQL Server 2005 Express
    ... to the "remote" version of SQL Server. ... version to this server via the network, as above for my client. ... Express edition database and nothing else. ...
    (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: Is it possible to connect to Access Database using VPN?
    ... believe that the "Remote Desktop" is a better solution to open the Access ... However, assuming you been running a split database for some time, then ... you only are moving the data from a back end mdb file to sql server, ... "Upsizing to Microsoft SQL Server" White Paper Available in Download ...
    (microsoft.public.access.forms)