Hello
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.
Thank you
Martin
7  3666 
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 <--
"Stefan Hoffmann" <st****@ste5an.dewrote in message
news:eD**************@TK2MSFTNGP04.phx.gbl...
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
"Martin" <tr****************@shaw.cawrote in message
news:WY6vh.824924$R63.66669@pd7urf1no...
>
"Stefan Hoffmann" <st****@ste5an.dewrote in message
news:eD**************@TK2MSFTNGP04.phx.gbl...
>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.
"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:8J******************************@comcast.com. ..
>
"Martin" <tr****************@shaw.cawrote in message
news:WY6vh.824924$R63.66669@pd7urf1no...
>>
"Stefan Hoffmann" <st****@ste5an.dewrote in message
news:eD**************@TK2MSFTNGP04.phx.gbl...
>>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
"Martin" <tr****************@shaw.cawrote in message
news:c0xvh.821965$1T2.115134@pd7urf2no...
>
"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:8J******************************@comcast.com. ..
>>
"Martin" <tr****************@shaw.cawrote in message
news:WY6vh.824924$R63.66669@pd7urf1no...
>>>
"Stefan Hoffmann" <st****@ste5an.dewrote in message
news:eD**************@TK2MSFTNGP04.phx.gbl...
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.
"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:rp******************************@comcast.com. ..
>
"Martin" <tr****************@shaw.cawrote in message
news:c0xvh.821965$1T2.115134@pd7urf2no...
>>
"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:8J******************************@comcast.com ...
>>>
"Martin" <tr****************@shaw.cawrote in message
news:WY6vh.824924$R63.66669@pd7urf1no...
"Stefan Hoffmann" <st****@ste5an.dewrote in message
news:eD**************@TK2MSFTNGP04.phx.gbl...
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
"Martin" <tr****************@shaw.cawrote in message
news:guSvh.827273$1T2.276879@pd7urf2no...
>
"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:rp******************************@comcast.com. ..
>>
"Martin" <tr****************@shaw.cawrote in message
news:c0xvh.821965$1T2.115134@pd7urf2no...
>>>
"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:8J******************************@comcast.co m...
"Martin" <tr****************@shaw.cawrote in message
news:WY6vh.824924$R63.66669@pd7urf1no...
>
"Stefan Hoffmann" <st****@ste5an.dewrote in message
news:eD**************@TK2MSFTNGP04.phx.gbl.. .
>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
Yay! Congratulations.
Robin S. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: lkrubner |
last post by:
I have a webserver through Rackspace. I create a domain. I create an
FTP user. I upload some files. I create a database called
testOfSetupScript and then I create a database user named setup.
I...
|
by: intl04 |
last post by:
I am getting strange print-related error messages when trying to
create (not print!) reports. For example, when I click 'new' to create
a report then choose 'design view', I get an error message...
|
by: John Hughes |
last post by:
Hi,
Is it possible to create an object from a stored (database,xml or variable)
name?
For instance I have 2 class names stored in my database. Depending on the
application settings I want to...
|
by: ASP Yaboh |
last post by:
I have an ArrayList of data gathered from a database. I want to create a web
page from this data by creating a <table>, each cell in each row displays the
appropriate data. One of those cells in...
|
by: max |
last post by:
Hello,
I am a newbye, and I'm trying to write a simple application.
I have five tables with three columns; all tables are identical; I need to
change some data in the first table and let VB...
|
by: Big Charles |
last post by:
Hello,
I would like to create an array-class to be able to call like:
Dim oMyCar as New MyCar
' After initializing oMyCar, the object has to be like:
oMyCar(0).Brand...
|
by: etuncer |
last post by:
Hello All,
I have Access 2003, and am trying to build a database for my small
company. I want to be able to create a word document based on the data
entered through a form. the real question is...
|
by: Hetal |
last post by:
Hi...
I am a newbie VB.NET developer and i am looking at working with
ADO.NET rather than ADO. In one of our native VB application with ADO,
we used to create 1 connection object and that would...
|
by: Dave |
last post by:
I have multiple forms that will create an object. Basically a energy
efficiency measure object. The measure object will have a couple of
required properties set but after that it can have 10-20...
|
by: TG |
last post by:
Hi!
I have an application in which I have some checkboxes and depending
which ones are checked those columns will show in the datagridview
from sql server or no.
After that I have 2 buttons:...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
