can not install MSDE

Hi
I have installed .net framework 1.1 and .net web matrix from 'sams teach yourself asp.net' CD. I installed MSDE from the same CD, its not giving any error, but at the end it does not promt to restart the computer, even after restarting I can not see the MSDE icon in the system tray, also I dont see MSDE in the add/remove programs in control panel.I installed sql2kdesksp3.exe from www.asp.net/msde/, but the same thing repeats.

1. Shld I install the sql2kasp3.exe(Analysis services companents) and sql2ksp3.exe(Databasre components) also?

I am new to asp,It will be helpful if somebody can tell me how to install MSDE.

ThanksHere are step-by-step instructions. Try going over them again in case the machine didn't install it properly:

http://www.asp.net/webmatrix/guidedtour/Appendices/installMsde.aspx|||Hii

I Installed MSDE via command line as given in tht site and there was no error but dint get tht MSDE icon in system tray.
I tried to install MSDE via batch file, there was no error, but when started the MSDE service, I couldnt see the "MSSQLSERVER", there is only MSSQLServiceASHelper, when clicked on it it gives the error as

"could not start the MSSQLServerADHelper service on Local Computer
eror2:The system cannot find the file specified"

Now wht shld I do??Can I download the missing file separately.I installed from the cd again and the same repeated.plzz tell me whtt I shld do now.
Thank You|||Yeah, follow the directions here to reinstall:
http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1|||Hi
I tried by installing from tht site, to install it again it takes another 8 to 10hours as I use dialup connection.Cant I download the missing file separately?|||The files you point to are Service Pack 3 files for SQL Server 2000. You need this file to patch MSDE with SP3: Sql2kdesksp3.exe

Check out the SQL Server and MSDE Service Pack 3a update page:
http://www.microsoft.com/sql/downloads/2000/SP3.asp

You may be able to order on CD, or at least download the correct file.|||Thanks a lot for answering me, I am downloading it again from the given site, if the same problem repeates then I'll buy the Cd.
Does SQL server 2000 and MSDE work the same way?

Thank you.|||Pretty much. MSDE doesn't have all the high-end features that SQL Server has, nor does it have a graphical interface designer like Query Analyzer or Enterprise Manager.

Can not create views, tables etc * URGENT*

Hi,

I am not getting option as 'new view' and 'new table' when I right
click on
views and tables option in VisualStudio.net IDE server explorer
sqlservers database to create new objects.

Looks like some setup issue in my database.

Thanks for your help in advance.

Rgds
CVCV (chaitu_m7@.yahoo.co.in) writes:
> I am not getting option as 'new view' and 'new table' when I right
> click on
> views and tables option in VisualStudio.net IDE server explorer
> sqlservers database to create new objects.
> Looks like some setup issue in my database.

Does this happen in every database, including tempdb? How do you connect
to the server? I don't use VS .Net to access SQL Server normally, so I
don't have much idea what it could be, but one possibility is that the
you don't have rights to create new objects in the database in question.

Personally, I prefer to use Query Analyzer to create tables, using
the CREATE TABLE statement, and this is also what I recommend in general.
In the long run, you are more effective with this than using a graphic
tool. Also, this is the only option if you want to put you tables under
source control - which you should.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.aspsql

Can not create a database in VS.Net using SQL

I am taking a course in ASP.Net at Finger Lakes Community
College. I am trying to create a database in VS.Net using
SQL. In the computer lab we have the class in I can
create a database in VS.Net using SQL. In the open lab
and at home on my P.C. I have VS.Net and SQL Server 2000
loaded. Every is the same BUT I cannot create a database
using SQL on my P.C. or in the open lab. I am set up as
the administrator and have all the rights I need to creat
a database. The permissions are the same from one lab to
the other and on my P.C. and the server is on. My System
Admininstrator and Teacher are just as confused as I am.
We need to resolve this issue before the start of the
fall semester. Does anyne have an idea on why this is
happening?Please be a bit more clear as to what is happening. How are you trying to
create the database? What error are you getting when you try?
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"mmoon" <anonymous@.discussions.microsoft.com> wrote in message
news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
> I am taking a course in ASP.Net at Finger Lakes Community
> College. I am trying to create a database in VS.Net using
> SQL. In the computer lab we have the class in I can
> create a database in VS.Net using SQL. In the open lab
> and at home on my P.C. I have VS.Net and SQL Server 2000
> loaded. Every is the same BUT I cannot create a database
> using SQL on my P.C. or in the open lab. I am set up as
> the administrator and have all the rights I need to creat
> a database. The permissions are the same from one lab to
> the other and on my P.C. and the server is on. My System
> Admininstrator and Teacher are just as confused as I am.
> We need to resolve this issue before the start of the
> fall semester. Does anyne have an idea on why this is
> happening?|||I start VS.Net and open a new project for ASP.Net. I then
go to Server Explorer and right click on Data Connections
and select Create a new SQL Database. In the window where
you enter the server I type in the local server's name
and then type in the name of the database I want to
create. It may take a moment or two but I'll get an error
message stating "Can not create a databse on this
server". when I check the permissions in Enterprise
Manager I see that all the permissions are set for me to
e able to create a database.
>--Original Message--
>Please be a bit more clear as to what is happening. How
are you trying to
>create the database? What error are you getting when you
try?
>--
>Andrew C. Madsen
>Information Architect
>Harley-Davidson Motor Company
>"mmoon" <anonymous@.discussions.microsoft.com> wrote in
message
>news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
>> I am taking a course in ASP.Net at Finger Lakes
Community
>> College. I am trying to create a database in VS.Net
using
>> SQL. In the computer lab we have the class in I can
>> create a database in VS.Net using SQL. In the open lab
>> and at home on my P.C. I have VS.Net and SQL Server
2000
>> loaded. Every is the same BUT I cannot create a
database
>> using SQL on my P.C. or in the open lab. I am set up as
>> the administrator and have all the rights I need to
creat
>> a database. The permissions are the same from one lab
to
>> the other and on my P.C. and the server is on. My
System
>> Admininstrator and Teacher are just as confused as I
am.
>> We need to resolve this issue before the start of the
>> fall semester. Does anyne have an idea on why this is
>> happening?
>
>.
>|||Ok. Are you using SQL Authentication? Is the server in the open lab in the
same domain as your PC? Is the SQL Server and the home PC in the same
domain? VS.net will not move across domains.
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
<anonymous@.discussions.microsoft.com> wrote in message
news:2283801c45d41$8d809c50$a401280a@.phx.gbl...
> I start VS.Net and open a new project for ASP.Net. I then
> go to Server Explorer and right click on Data Connections
> and select Create a new SQL Database. In the window where
> you enter the server I type in the local server's name
> and then type in the name of the database I want to
> create. It may take a moment or two but I'll get an error
> message stating "Can not create a databse on this
> server". when I check the permissions in Enterprise
> Manager I see that all the permissions are set for me to
> e able to create a database.
>
> >--Original Message--
> >Please be a bit more clear as to what is happening. How
> are you trying to
> >create the database? What error are you getting when you
> try?
> >
> >--
> >Andrew C. Madsen
> >Information Architect
> >Harley-Davidson Motor Company
> >"mmoon" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
> >> I am taking a course in ASP.Net at Finger Lakes
> Community
> >> College. I am trying to create a database in VS.Net
> using
> >> SQL. In the computer lab we have the class in I can
> >> create a database in VS.Net using SQL. In the open lab
> >> and at home on my P.C. I have VS.Net and SQL Server
> 2000
> >> loaded. Every is the same BUT I cannot create a
> database
> >> using SQL on my P.C. or in the open lab. I am set up as
> >> the administrator and have all the rights I need to
> creat
> >> a database. The permissions are the same from one lab
> to
> >> the other and on my P.C. and the server is on. My
> System
> >> Admininstrator and Teacher are just as confused as I
> am.
> >> We need to resolve this issue before the start of the
> >> fall semester. Does anyne have an idea on why this is
> >> happening?
> >
> >
> >.
> >sql

Can not create a database in VS.Net using SQL

I am taking a course in ASP.Net at Finger Lakes Community
College. I am trying to create a database in VS.Net using
SQL. In the computer lab we have the class in I can
create a database in VS.Net using SQL. In the open lab
and at home on my P.C. I have VS.Net and SQL Server 2000
loaded. Every is the same BUT I cannot create a database
using SQL on my P.C. or in the open lab. I am set up as
the administrator and have all the rights I need to creat
a database. The permissions are the same from one lab to
the other and on my P.C. and the server is on. My System
Admininstrator and Teacher are just as confused as I am.
We need to resolve this issue before the start of the
fall semester. Does anyne have an idea on why this is
happening?Please be a bit more clear as to what is happening. How are you trying to
create the database? What error are you getting when you try?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"mmoon" <anonymous@.discussions.microsoft.com> wrote in message
news:2266a01c45d38$c2973e20$a101280a@.phx
.gbl...
> I am taking a course in ASP.Net at Finger Lakes Community
> College. I am trying to create a database in VS.Net using
> SQL. In the computer lab we have the class in I can
> create a database in VS.Net using SQL. In the open lab
> and at home on my P.C. I have VS.Net and SQL Server 2000
> loaded. Every is the same BUT I cannot create a database
> using SQL on my P.C. or in the open lab. I am set up as
> the administrator and have all the rights I need to creat
> a database. The permissions are the same from one lab to
> the other and on my P.C. and the server is on. My System
> Admininstrator and Teacher are just as confused as I am.
> We need to resolve this issue before the start of the
> fall semester. Does anyne have an idea on why this is
> happening?|||I start VS.Net and open a new project for ASP.Net. I then
go to Server Explorer and right click on Data Connections
and select Create a new SQL Database. In the window where
you enter the server I type in the local server's name
and then type in the name of the database I want to
create. It may take a moment or two but I'll get an error
message stating "Can not create a databse on this
server". when I check the permissions in Enterprise
Manager I see that all the permissions are set for me to
e able to create a database.

>--Original Message--
>Please be a bit more clear as to what is happening. How
are you trying to
>create the database? What error are you getting when you
try?
>--
>Andrew C. Madsen
>Information Architect
>Harley-Davidson Motor Company
>"mmoon" <anonymous@.discussions.microsoft.com> wrote in
message
> news:2266a01c45d38$c2973e20$a101280a@.phx
.gbl...
Community[vbcol=seagreen]
using[vbcol=seagreen]
2000[vbcol=seagreen]
database[vbcol=seagreen]
creat[vbcol=seagreen]
to[vbcol=seagreen]
System[vbcol=seagreen]
am.[vbcol=seagreen]
>
>.
>|||Ok. Are you using SQL Authentication? Is the server in the open lab in the
same domain as your PC? Is the SQL Server and the home PC in the same
domain? VS.net will not move across domains.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
<anonymous@.discussions.microsoft.com> wrote in message
news:2283801c45d41$8d809c50$a401280a@.phx
.gbl...[vbcol=seagreen]
> I start VS.Net and open a new project for ASP.Net. I then
> go to Server Explorer and right click on Data Connections
> and select Create a new SQL Database. In the window where
> you enter the server I type in the local server's name
> and then type in the name of the database I want to
> create. It may take a moment or two but I'll get an error
> message stating "Can not create a databse on this
> server". when I check the permissions in Enterprise
> Manager I see that all the permissions are set for me to
> e able to create a database.
>
> are you trying to
> try?
> message
> Community
> using
> 2000
> database
> creat
> to
> System
> am.

Can not create a database in VS.Net using SQL

I am taking a course in ASP.Net at Finger Lakes Community
College. I am trying to create a database in VS.Net using
SQL. In the computer lab we have the class in I can
create a database in VS.Net using SQL. In the open lab
and at home on my P.C. I have VS.Net and SQL Server 2000
loaded. Every is the same BUT I cannot create a database
using SQL on my P.C. or in the open lab. I am set up as
the administrator and have all the rights I need to creat
a database. The permissions are the same from one lab to
the other and on my P.C. and the server is on. My System
Admininstrator and Teacher are just as confused as I am.
We need to resolve this issue before the start of the
fall semester. Does anyne have an idea on why this is
happening?
Please be a bit more clear as to what is happening. How are you trying to
create the database? What error are you getting when you try?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"mmoon" <anonymous@.discussions.microsoft.com> wrote in message
news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
> I am taking a course in ASP.Net at Finger Lakes Community
> College. I am trying to create a database in VS.Net using
> SQL. In the computer lab we have the class in I can
> create a database in VS.Net using SQL. In the open lab
> and at home on my P.C. I have VS.Net and SQL Server 2000
> loaded. Every is the same BUT I cannot create a database
> using SQL on my P.C. or in the open lab. I am set up as
> the administrator and have all the rights I need to creat
> a database. The permissions are the same from one lab to
> the other and on my P.C. and the server is on. My System
> Admininstrator and Teacher are just as confused as I am.
> We need to resolve this issue before the start of the
> fall semester. Does anyne have an idea on why this is
> happening?
|||Please be a bit more clear as to what is happening. How are you trying to
create the database? What error are you getting when you try?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"mmoon" <anonymous@.discussions.microsoft.com> wrote in message
news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
> I am taking a course in ASP.Net at Finger Lakes Community
> College. I am trying to create a database in VS.Net using
> SQL. In the computer lab we have the class in I can
> create a database in VS.Net using SQL. In the open lab
> and at home on my P.C. I have VS.Net and SQL Server 2000
> loaded. Every is the same BUT I cannot create a database
> using SQL on my P.C. or in the open lab. I am set up as
> the administrator and have all the rights I need to creat
> a database. The permissions are the same from one lab to
> the other and on my P.C. and the server is on. My System
> Admininstrator and Teacher are just as confused as I am.
> We need to resolve this issue before the start of the
> fall semester. Does anyne have an idea on why this is
> happening?
|||I start VS.Net and open a new project for ASP.Net. I then
go to Server Explorer and right click on Data Connections
and select Create a new SQL Database. In the window where
you enter the server I type in the local server's name
and then type in the name of the database I want to
create. It may take a moment or two but I'll get an error
message stating "Can not create a databse on this
server". when I check the permissions in Enterprise
Manager I see that all the permissions are set for me to
e able to create a database.

>--Original Message--
>Please be a bit more clear as to what is happening. How
are you trying to
>create the database? What error are you getting when you
try?
>--
>Andrew C. Madsen
>Information Architect
>Harley-Davidson Motor Company
>"mmoon" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
Community[vbcol=seagreen]
using[vbcol=seagreen]
2000[vbcol=seagreen]
database[vbcol=seagreen]
creat[vbcol=seagreen]
to[vbcol=seagreen]
System[vbcol=seagreen]
am.
>
>.
>
|||I start VS.Net and open a new project for ASP.Net. I then
go to Server Explorer and right click on Data Connections
and select Create a new SQL Database. In the window where
you enter the server I type in the local server's name
and then type in the name of the database I want to
create. It may take a moment or two but I'll get an error
message stating "Can not create a databse on this
server". when I check the permissions in Enterprise
Manager I see that all the permissions are set for me to
e able to create a database.

>--Original Message--
>Please be a bit more clear as to what is happening. How
are you trying to
>create the database? What error are you getting when you
try?
>--
>Andrew C. Madsen
>Information Architect
>Harley-Davidson Motor Company
>"mmoon" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
Community[vbcol=seagreen]
using[vbcol=seagreen]
2000[vbcol=seagreen]
database[vbcol=seagreen]
creat[vbcol=seagreen]
to[vbcol=seagreen]
System[vbcol=seagreen]
am.
>
>.
>
|||Ok. Are you using SQL Authentication? Is the server in the open lab in the
same domain as your PC? Is the SQL Server and the home PC in the same
domain? VS.net will not move across domains.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
<anonymous@.discussions.microsoft.com> wrote in message
news:2283801c45d41$8d809c50$a401280a@.phx.gbl...[vbcol=seagreen]
> I start VS.Net and open a new project for ASP.Net. I then
> go to Server Explorer and right click on Data Connections
> and select Create a new SQL Database. In the window where
> you enter the server I type in the local server's name
> and then type in the name of the database I want to
> create. It may take a moment or two but I'll get an error
> message stating "Can not create a databse on this
> server". when I check the permissions in Enterprise
> Manager I see that all the permissions are set for me to
> e able to create a database.
>
> are you trying to
> try?
> message
> Community
> using
> 2000
> database
> creat
> to
> System
> am.
|||Ok. Are you using SQL Authentication? Is the server in the open lab in the
same domain as your PC? Is the SQL Server and the home PC in the same
domain? VS.net will not move across domains.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
<anonymous@.discussions.microsoft.com> wrote in message
news:2283801c45d41$8d809c50$a401280a@.phx.gbl...[vbcol=seagreen]
> I start VS.Net and open a new project for ASP.Net. I then
> go to Server Explorer and right click on Data Connections
> and select Create a new SQL Database. In the window where
> you enter the server I type in the local server's name
> and then type in the name of the database I want to
> create. It may take a moment or two but I'll get an error
> message stating "Can not create a databse on this
> server". when I check the permissions in Enterprise
> Manager I see that all the permissions are set for me to
> e able to create a database.
>
> are you trying to
> try?
> message
> Community
> using
> 2000
> database
> creat
> to
> System
> am.

Can not connect to SQL Server 2005 Developer edition remotely

I setup a SQL Server 2005 Developer edition, which is bundled with Visual Studio .NET 2005 Professional edition. The SQL Server authentication mode is enabled in this database server. But when I try to connect it from another PC using SQL Server authentication, it failed. Is it a limitation on the developer edition?

Hi,

although you didn′t post the erro rmessage, I assume that remote connectivity is not enabled, change the remote flag which can be see in this screen:

http://www.sqlserver2005.de/SharedFiles/Remoteconnection.jpg

HTH, jens suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

I still can't login remotely to the server, the error message is:

Cannot connect to 137.xxx.xx.xx\STD2005
error: 26 - Error Locating Sever/Instance Specified

I setup a MSSQL Server 2005 Standard edition on a remote computer 137.xxx.xx.xx (I'm sure the network has no any problem, since this remote computer has a SQL2000 server that I can use the Enterprise Manager in my PC to connect to it), and the named instance called STD2005. I try to connect to it through the Management Studio in my PC, using the sa account and one acccount that I created before, both not work. Any idea?

|||Hi,

so you are usinga named instance. I assume you didn′t put the named instance on the defaulport, which is as a default used to connect to a sql server instance. If the named instances has another port you have to specify it with the syntax:

Servername\InstanceName,Portnumber

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Also: Can we rule out a firewall problem? Is the SQL Browser service running on the server machine?

Best,
Nils Loeber
|||

In SQL 2005 Developer Edition TCP\IP is disabled by default. You can go to Server Configuration and enable it. I hope that helps.

JB

can not connect to remote SQL Express 2005

Hi,
I am having problems with my Visual Studio 2005 VB.net win app connecting
to SQL Express. I have configured my SQL Express to enable remote
connections, I believe it is correct, since others in the office can connect
to it using MS SQL Server Management Studio, and I can make a successful test
ODBC connection from the client computer, using both named pipes and tcpip.
But my VB.net app can not connect on the client computer, I get error -
System.Data.SqlClient.SqlException: An error has occurred while establishing
a connection to the server. When connecting to SQL Server 2005, this failure
may be caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: Named Pipes Provider, error: 40 - Could
not open a connection to SQL Server).
This app runs fine on the machine the SQL Express is running on (Windows
2000). My connection code is: Data Source=xxx\sqlexpress;Initial
Catalog=xxx;User ID=xxx;Password=xxx. I have tried putting np: and tcp: with
the port on the data source, but then the code doesn't run on the app on the
server...
Anybody know what I am doing wrong?
Thank you for any help.
Sandy
Hi,
any blocking firewall in the machine ? See if you can open up a
connction using the SQLCMD application from the command prompt.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Hi, Yes I can open a connection using SQLCMD, specifying both tcp with port,
and specifying np. The client machine doesn't have SQL installed, but the
odbc connections worked.
Sandy
"Jens" wrote:

> Hi,
> any blocking firewall in the machine ? See if you can open up a
> connction using the SQLCMD application from the command prompt.
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>

can not connect to remote SQL Express 2005

Hi,
I am having problems with my Visual Studio 2005 VB.net win app connecting
to SQL Express. I have configured my SQL Express to enable remote
connections, I believe it is correct, since others in the office can connec
t
to it using MS SQL Server Management Studio, and I can make a successful tes
t
ODBC connection from the client computer, using both named pipes and tcpip.
But my VB.net app can not connect on the client computer, I get error -
System.Data.SqlClient.SqlException: An error has occurred while establishing
a connection to the server. When connecting to SQL Server 2005, this failur
e
may be caused by the fact that under the default settings SQL Server does no
t
allow remote connections. (provider: Named Pipes Provider, error: 40 - Could
not open a connection to SQL Server).
This app runs fine on the machine the SQL Express is running on (Windows
2000). My connection code is: Data Source=xxx\sqlexpress;Initial
Catalog=xxx;User ID=xxx;Password=xxx. I have tried putting np: and tcp: wit
h
the port on the data source, but then the code doesn't run on the app on the
server...
Anybody know what I am doing wrong?
Thank you for any help.
SandyHi,
any blocking firewall in the machine ? See if you can open up a
connction using the SQLCMD application from the command prompt.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--|||Hi, Yes I can open a connection using SQLCMD, specifying both tcp with port
,
and specifying np. The client machine doesn't have SQL installed, but the
odbc connections worked.
Sandy
"Jens" wrote:

> Hi,
> any blocking firewall in the machine ? See if you can open up a
> connction using the SQLCMD application from the command prompt.
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>

Can not connect to database

I am new to windows apps in .net 2.0. I am trying to create a windows service that will connect to a database and email info out to people that have had status changes.

Right now, I can not connect to the database. Here is the connection string:

Private cnnAsNew SqlClient.SqlConnection("Data Source=IPAddress;Initial Catalog=TheServer;Persist Security Info=True;User ID=userid;Password=password provider=SQLOLEDB.1;connect timeout=3600")

This is how I am trying to connect:

cnn.Open()

myCMD.CommandTimeout = 0

dr = myCMD.ExecuteReader

I keep getting an error message that I can not be logged on. I know that the credentials are correct because I use them for the web app. Something has to be wrong with my connection string, but what?

Thanks,

enak

Seehttp://www.connectionstrings.com for examples of properly formatted connection strings. You do not need the "provider" parameter, and if you did it should be separated from the other parameters by a semicolon (not a space).

If you are still having trouble you should post the exact error message (or better yet, first search the forums or Google for that error message).|||Took out the provider and it worked. Thanks.sql

Can not access SQL database for Website security settings

I'm using Visual Studio 2005 (8.0.50727.42) and going into the menu option Website > ASP.Net Configuration, access the security tab and all I get is an error message stating that there is a problem with the selected data store "Unable to Connect to the SQL Server Database"

I have SQL Server 2005 (Express Edition). I have created a database "NetDev" with the right connection, etc.

I can use the SQL server fine for my Windows applications, but somehow this ASp.Net Configuration tool is not making any sense.

I also used the aspnet_regsql command from framework 2.0 to create a DataBase to no avail.

Does anyone out there knows if there is a bug with this tool?

Responding to my own question.

I finally reinstalled everything from scratch, IIS first, and then Visual Studio and my problem went away. It obviously had some corruption as I havce deleted and recreated many apps I may have induced some problems. Also the NET Service had to be added to the APP-Data dir with write permissions (this may have been the real cause).

sql

Can my ASP.NET dev workstation see remote SQL server?

I would like to develop my ASP.NET application against a SQL 2000 database
residing on another server, rather than against the SQL server installed
locally. We're using Windows integrated security. When I'm using Visual
Studio the ASP.NET user belongs to my XP machine's local domain, which is
not recognized by the remote SQL server as belong to its domain. It is
possible to set up the SQL Server, my local XP machine, or my web.config
file so that when I develop an app in Visual Studio (Debug -> Start), I can
access the remote SQL database?
Thanks !You should be able to register the server using the format domain\username
and then develop against it. NOTE that, by default, the method of security
is windows and not mixed, but that sounds fine in your case.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
****************************************
******************************
Think Outside the Box!
****************************************
******************************
"Timo" <timo@.anonymous.com> wrote in message
news:uPs3ZS4BEHA.624@.TK2MSFTNGP10.phx.gbl...
> I would like to develop my ASP.NET application against a SQL 2000 database
> residing on another server, rather than against the SQL server installed
> locally. We're using Windows integrated security. When I'm using Visual
> Studio the ASP.NET user belongs to my XP machine's local domain, which is
> not recognized by the remote SQL server as belong to its domain. It is
> possible to set up the SQL Server, my local XP machine, or my web.config
> file so that when I develop an app in Visual Studio (Debug -> Start), I
can
> access the remote SQL database?
> Thanks !
>|||Timo wrote:

> I would like to develop my ASP.NET application against a SQL 2000 database
> residing on another server, rather than against the SQL server installed
> locally. We're using Windows integrated security. When I'm using Visual
> Studio the ASP.NET user belongs to my XP machine's local domain, which is
> not recognized by the remote SQL server as belong to its domain. It is
> possible to set up the SQL Server, my local XP machine, or my web.config
> file so that when I develop an app in Visual Studio (Debug -> Start), I ca
n
> access the remote SQL database?
> Thanks !
In order to have ASP.NET connect to the database server, you must
configure ASP.NET to run as a domain account. I believe it is the
machine.config file that you will need to modify on Windows XP to change
what user ASP.NET runs as. It is different on different OSes. The good
thing is that with Windows 2003 you configure it directly in IIS and
each application can run under a different user.
Aaron Weiker
http://blogs.sqladvice.com/aweiker
http://aaronweiker.com/|||You certainly can
A couple of ways to do it (one OR the other)
1) Edit machine.config (C:\WINNT\Microsoft.NET\Framework\v.....\Config) and
change the userName / password of the <processModel ..> element as described
in the same file
That way you can run the ASP.NET working process on the identity of a domain
account that may be allowed access to the SQL Server
2) For your Web application (on the IIS console), replace the default
anonymous user (IUSR_xxxxxxx) with a domain user / password and allow access
to that user in the SQL Server. You should also set <identity
impersonate=true> in your Web.config
Regards
Jose.
"Timo" <timo@.anonymous.com> escribi en el mensaje
news:uPs3ZS4BEHA.624@.TK2MSFTNGP10.phx.gbl...
> I would like to develop my ASP.NET application against a SQL 2000 database
> residing on another server, rather than against the SQL server installed
> locally. We're using Windows integrated security. When I'm using Visual
> Studio the ASP.NET user belongs to my XP machine's local domain, which is
> not recognized by the remote SQL server as belong to its domain. It is
> possible to set up the SQL Server, my local XP machine, or my web.config
> file so that when I develop an app in Visual Studio (Debug -> Start), I
can
> access the remote SQL database?
> Thanks !
>|||I follow step #1 below (it seems preferable to editing the live IIS server).
On my local PC, I edit the userName element replacing the value with
DOMAIN\USERNAME
This domain user has been granted login on the remote SQL server, has been
granted dbaccess, and has been added as a member of a role which can access
the relevant tables.When I try to run my ASP.NET page, I get the following
error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection
I don't know what our network admin has done when setting up my PC, which
has XP Pro on it; he is used to Win2K. He knows only a little more than I do
about Windows authentication, which has me worried :-) Why does the error
message have 'null' for the username? Because SQL does not recognize it and
so refuses to repeat the name?
Thanks
Timo
"Jose Marcenaro" <josem@.nospam.da-vinci.com.ar> wrote in message
news:eDZZXh4BEHA.3568@.tk2msftngp13.phx.gbl...
> You certainly can
> A couple of ways to do it (one OR the other)
> 1) Edit machine.config (C:\WINNT\Microsoft.NET\Framework\v.....\Config)
and
> change the userName / password of the <processModel ..> element as
described
> in the same file
> That way you can run the ASP.NET working process on the identity of a
domain
> account that may be allowed access to the SQL Server
> 2) For your Web application (on the IIS console), replace the default
> anonymous user (IUSR_xxxxxxx) with a domain user / password and allow
access
> to that user in the SQL Server. You should also set <identity
> impersonate=true> in your Web.config
> Regards
> Jose.
> "Timo" <timo@.anonymous.com> escribi en el mensaje
> news:uPs3ZS4BEHA.624@.TK2MSFTNGP10.phx.gbl...
database
Visual
is
> can
>|||Thanks for responding. But I don't know what is meant by "register the
server". Is that something I do with Visual Studio.NET? Do I need a special
"enterprise" level of VS.NET for that?
Timo
"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@.comcast.netNoSpamM> wrote in
message news:u2P1gd4BEHA.2380@.TK2MSFTNGP10.phx.gbl...
> You should be able to register the server using the format domain\username
> and then develop against it. NOTE that, by default, the method of security
> is windows and not mixed, but that sounds fine in your case.
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
> "Timo" <timo@.anonymous.com> wrote in message
> news:uPs3ZS4BEHA.624@.TK2MSFTNGP10.phx.gbl...
database
Visual
is
> can|||Login failed for user 'null' means that we were unable to 'impersonate' the
user. We need to be able to impersonate when we authenticate to SQL using
your Windows NT credentials.
Typical client server environment:
Scenario 1:
Client --> SQL
If this fails, then it may be a problem with the communication between the
client and the Domain Controller. You can make network traces from the
client and /or enable Kerberos logging to verify if this is the case. This
may occur when using sockets, but not with Named Pipes connections.
Scenario 2:
Web Server/SQL Environment
Client-->IIS-->SQL.
If your scenario looks like the Scenario 2 (Web Server/SQL Environment),
then this scenario is more complicated to configure.
The middle machine (IIS) must be trusted for Security Delegation. And the
Domain Admin needs to set the spn for SQL Server.
The client machine must use TCP/IP and authenticate via Kerberos
authentication. If it uses NTLM, then this will fail with "Login failed
for user 'null'".
This article goes over various scenarios:
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/SecNetch05.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||If you want to use step #1 (ASPNET account) make sure you dont have
<impersonate="true"> in Web.config (you should keep the default which is
false or absent).
Otherwise, the local IUSR_xxxxx identity would be used.
If you do not currently have <impersonate="true"> ... then I guess it may be
some "extra-cautious" security setting of XPPro which prevents the identity
to be passed along.. sorry for not being able to help there
"Timo" <timo@.anonymous.com> escribi en el mensaje
news:e7M3M$4BEHA.3472@.TK2MSFTNGP09.phx.gbl...
> I follow step #1 below (it seems preferable to editing the live IIS
server).
> On my local PC, I edit the userName element replacing the value with
> DOMAIN\USERNAME
> This domain user has been granted login on the remote SQL server, has been
> granted dbaccess, and has been added as a member of a role which can
access
> the relevant tables.When I try to run my ASP.NET page, I get the following
> error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection
> I don't know what our network admin has done when setting up my PC, which
> has XP Pro on it; he is used to Win2K. He knows only a little more than I
do
> about Windows authentication, which has me worried :-) Why does the error
> message have 'null' for the username? Because SQL does not recognize it
and
> so refuses to repeat the name?
> Thanks
> Timo
>
> "Jose Marcenaro" <josem@.nospam.da-vinci.com.ar> wrote in message
> news:eDZZXh4BEHA.3568@.tk2msftngp13.phx.gbl...
> and
> described
> domain
> access
> database
installed
> Visual
> is
is
web.config
I
>

Can Multiple Selection Controls be use with SqlDataSource?

 NET 2.0 

I am using Visual Studio Express 2005 for database web developement.

I have created a database with 5 tables. Two are associative tables.

They are

Software
PK SoftwareID
Title

SoftwareSolution
FK SoftwareID
FK SolutionID

Solution
PK SolutionID
Title

CategorySolution
FK Category
FK Solution

Category

PK Category
Title

Criteria for a search with three sources of input into a SqlDataSource attached to a FormView for paged out.

The following are the Search Criteria input sources:
1) ListBox in Multiple Selection Mode
2) CheckBoxList with Mutiple checks posible
2) TextBox with key word search in Title.

Each Solution has 0 or many Categories and 0 or many Software.

When the records are entered in the database, the associative information for Categories and Software are populated to filter the
returned values.

In NET 1.1, I would create a search string like the following in code behind by looping through the CheckBoxList and ListBox finally adding the TextBox:

SELECT Solution.SolutionID, Solution.Title
FROM Solution
WHERE
Solution.SolutionID IN ('2','3','5')
AND
Solution.Title LIKE '%Math%'

I am unable to update the SelectCommand in the ASPX page.

However, when I use the I have used the
System.Web.UI.WebControls.SqlDataSources
"SelectQuery Builder"
I receive the following in the Source for ASPX:

 
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString%>" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT Solution.SolutionID, Solution.Title FROM Solution INNER JOIN CategorySolution ON Solution.SolutionID = CategorySolution.SolutionID INNER JOIN SoftwareSolution ON Solution.SolutionID = SoftwareSolution.SolutionID"> <SelectParameters> <asp:ControlParameter ControlID="CheckBoxList1" DefaultValue="%" Name="CategoryID" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="ListBox1" DefaultValue="%" Name="SoftwareID" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="txtTitleSearch" DefaultValue="%" Name="Title" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource>
 

I receive duplicate records and not sure if the code generated accesses the Mutiple Selected values in the CheckBoxList1 and ListBox1.

Question:

1) If the SelectQuery generator will not access multiple selected values from the CheckBoxList1, how can I use code behind to replace

SelectCommand in the ASPX page?

2) What is the best solution for using the CheckBoxList1, ListBox1, and TextBox for filtering my results?

 Sample code, references to solutions, corrections on logic, a new approach, how to use the wizard correctly would all be greatly appreciated.

3) Can Multiple Selection Controls be use with a SqlDataSource SELECT Command?

Thanks for your time,

Sincerely,

Unhistoric

Not, these are a summary of my unsuccessful results and may have a few unintentional syntax errors as a result of the interface of publishing on this website.

After further testing, I have not found a solution upto this point.

I have tried using a SessionParameter of type string to update ('4','20') in the following code in my ASPX file:

I set session variables in the Page_PreInit on the ASPX.VB for testing purposes.

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString%>" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Solution] @.inputSolutionID"> <SelectParameters> <asp:SessionParameter Name="inputSolutionID" SessionField="SolutionSearch" type="String" /> </SelectParameters></asp:SqlDataSource>

Only Works with: session("SolutionSearch") ="" resulting in unfiltered results.

   -----------------------------------------------------------

  
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Solution] WHERE ((CAST([SolutionID] AS Nvarchar)) IN (@.inputSolutionID))"> <SelectParameters> <asp:SessionParameter Name="inputSolutionID" SessionField="SolutionSearch" type="String" /> </SelectParameters></asp:SqlDataSource>
 Only Works with a single assignment: session("SolutionSearch") ="'1'" resulting in result and not with = "'1','20'"

------------------------------------------------------------- 

The following static code works:

 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString%>" SelectCommand="SELECT * FROM [Solution] WHERE ([SolutionID] IN ('4', '20'))"> </asp:SqlDataSource>

 ****Is there a way to dynamically update the proceeding from code ASPX.VB behind?**************

Sincerely frustrated,

Unhistoric

|||

The answer to the problem was resolved with the following link:

http://forums.asp.net/thread/1604679.aspx

It was pointed out the SelectCommand could be set from the code behind in the asp.vb. The key was to leave out the SelectCommand in the "ASPX" code file and set the initial SelectCommand in the Page_Load Event. From my understanding, I was not able to set the SelectCommand initially in my tests due to the fact it existed in part in the "ASPX" code.

Special Thanks to "Yani Dzhurov",

Sincerely,

Unhistoric

Can multiple apps connect to the same database?

I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:

"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf'. (Microsoft SQL Server, Error: 5123)"

Here is the connection string in the VB application:

"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf";Integrated Security=True;User Instance=True"

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Jens, I'm confused. You say that multiple connections to user instances are not possible, but then you say to attach the database to the Express intances to make that possible. Is it possible or not? And if it is possible, could you go into more detail to explain how?

Thanks,

Tim

|||You'd need to shut down SQL before you can copy the files.|||I would suggest reading something about the priciples of user instance and regular SQl Server instances. SQL Server instances are permanatly attached to the SQL Server service, while user instances are only attached during the usage of any application. If one application gains access to the file, it is opened exclusivly for the user, therefore cannot be opened through another user instance connection. The Server permanently attached file on the other site will allow though the service to handle multiple user requests.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||I would be careful which such assumptions. Sure the files can be copied during the usage, but shutting down SQL Server will make the datafile be consistent. If you do not shut down the server service, the information of datafile and logfile can differ making the database after a restore inaccessible. So the better way would be to shutdown the service and therefore close the files.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Basically, the application needs to be running first, and then you connect to the user instance with a named pipe protocol. However, the Select statement they use in the example didn't work for me as is;

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Then, from the new connection listed in the object explorer I drilled down to the folder containing the user instance database (the folder name having the same path as my application's database) and was able to "manage objects related to your user instance" as they put it.

Tim

Can multiple apps connect to the same database?

I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:

"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf'. (Microsoft SQL Server, Error: 5123)"

Here is the connection string in the VB application:

"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf";Integrated Security=True;User Instance=True"

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens, I'm confused. You say that multiple connections to user instances are not possible, but then you say to attach the database to the Express intances to make that possible. Is it possible or not? And if it is possible, could you go into more detail to explain how?

Thanks,

Tim

|||You'd need to shut down SQL before you can copy the files.|||I would suggest reading something about the priciples of user instance and regular SQl Server instances. SQL Server instances are permanatly attached to the SQL Server service, while user instances are only attached during the usage of any application. If one application gains access to the file, it is opened exclusivly for the user, therefore cannot be opened through another user instance connection. The Server permanently attached file on the other site will allow though the service to handle multiple user requests.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||I would be careful which such assumptions. Sure the files can be copied during the usage, but shutting down SQL Server will make the datafile be consistent. If you do not shut down the server service, the information of datafile and logfile can differ making the database after a restore inaccessible. So the better way would be to shutdown the service and therefore close the files.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Basically, the application needs to be running first, and then you connect to the user instance with a named pipe protocol. However, the Select statement they use in the example didn't work for me as is;

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Then, from the new connection listed in the object explorer I drilled down to the folder containing the user instance database (the folder name having the same path as my application's database) and was able to "manage objects related to your user instance" as they put it.

Tim

Can multiple apps connect to the same database?

I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;

"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."

I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:

"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf'. (Microsoft SQL Server, Error: 5123)"

Here is the connection string in the VB application:

"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\tbarnard\My Documents\Visual Studio 2005\Projects\Lamination Phase I\LamDataBase\Lamination.mdf";Integrated Security=True;User Instance=True"

In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.

Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?

Thanks,

Tim

Multiple connections to user instances are not possible. Attach the database to the Express instances to make that possible.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens, I'm confused. You say that multiple connections to user instances are not possible, but then you say to attach the database to the Express intances to make that possible. Is it possible or not? And if it is possible, could you go into more detail to explain how?

Thanks,

Tim

|||You'd need to shut down SQL before you can copy the files.|||I would suggest reading something about the priciples of user instance and regular SQl Server instances. SQL Server instances are permanatly attached to the SQL Server service, while user instances are only attached during the usage of any application. If one application gains access to the file, it is opened exclusivly for the user, therefore cannot be opened through another user instance connection. The Server permanently attached file on the other site will allow though the service to handle multiple user requests.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||I would be careful which such assumptions. Sure the files can be copied during the usage, but shutting down SQL Server will make the datafile be consistent. If you do not shut down the server service, the information of datafile and logfile can differ making the database after a restore inaccessible. So the better way would be to shutdown the service and therefore close the files.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

Jens,

I found one way to connect to, and examine, a database with Sequel Server Management Studio Express, while it is being used by another application with a user instance. It is described at the following link, under the heading "Connecting to a SQL Server Express user instance":

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/0bd6143a-ca9d-4f36-ae23-bd35a2d22d70.htm

Basically, the application needs to be running first, and then you connect to the user instance with a named pipe protocol. However, the Select statement they use in the example didn't work for me as is;

Select owning_principle_name, instance_pipe_name from sys.dm_os_child_instances

I had to drop the field names and use this

Select * from sys.dm_os_child_instances

Then, from the new connection listed in the object explorer I drilled down to the folder containing the user instance database (the folder name having the same path as my application's database) and was able to "manage objects related to your user instance" as they put it.

Tim

can MSRS 2000 run with .NET 2.0

Can MSRS 2000 run with .NET 2.0 . If not then is there any plan for a MSRS version which is compatible with MSRS 2000?No. RS 2000 is not .Net2.0 compatible.
Reporting Services 2005 is .Net 2.0 compatible. RS 2005 is being released with SQL Server 2005.

Can MSDE trigger call a .NET remote object?

Hi,
I wonder if MSDE trigger can call a remote .NET object
,i want to get notify when a new row was added or changed
also if I have an access application(forms etc...) can I still use it with
MSDE?
thanks in advance.
hi Julia,
"Julia" <codewizard@.012.net.il> ha scritto nel messaggio
news:u6ih4$XwEHA.4048@.TK2MSFTNGP15.phx.gbl
> Hi,
> I wonder if MSDE trigger can call a remote .NET object
> ,i want to get notify when a new row was added or changed
>
actually it should not be the case... you could perhaps "shell" out to
server's local resources, but this is not a good practice :D
this is usually not the correct scenario for client server applications...
if you really need something like that, schedule a data refresh from time to
time, say, every hour :D
stop kidding, ok.. perhaps you should rely on other forms of data
investigation..

> also if I have an access application(forms etc...) can I still use it
> with MSDE?
>
usually yes... an .ADP project will manage you connection(s) to a SQL
Server/MSDE database, while the Access project only includes forms
definitions, reports and so on..
http://www.amazon.com/exec/obidos/tg...glance&s=books
... a little dated, but still valuable book by Mary Chipman
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Can mirroring be implemented using SMO.

I wanted know that is it possible to implement mirroring in C#.NET framework using SMO (I need specifically a web applicaton). which willl provide a naive user the facilities integrated in SSMS. I am using VS.NET 2005 and SQL Server 2005 SP1.
Thanks and Regards,
Adii

Can you please clarify your question.

Database mirroring is a feature provided in "SQL Server 2005 SP1". Can you please elaborate what you mean by "implementing" it?

|||Thanks Sanjay,
I wanted to know that are there any classes or APIs provided, so that I can programmatically achieve mirroring in my application. Does SMO namespace can provide any assistance in this? Please do let me know if you know or find some solution for the same. I have SQL Server 2005 SP1 installed, but I don't want to use SSMS for doing mirroring. I want to provide this facility in my application to the user programmatically.|||I too am very interested in this answer. We are looking to automate some of the setup and configuration and it would be nice to be able to use SMO or some other exposed APIs to do it with.

Can mirroring be implemented using SMO.

I wanted know that is it possible to implement mirroring in C#.NET framework using SMO (I need specifically a web applicaton). which willl provide a naive user the facilities integrated in SSMS. I am using VS.NET 2005 and SQL Server 2005 SP1.
Thanks and Regards,
Adii

Can you please clarify your question.

Database mirroring is a feature provided in "SQL Server 2005 SP1". Can you please elaborate what you mean by "implementing" it?

|||Thanks Sanjay,
I wanted to know that are there any classes or APIs provided, so that I can programmatically achieve mirroring in my application. Does SMO namespace can provide any assistance in this? Please do let me know if you know or find some solution for the same. I have SQL Server 2005 SP1 installed, but I don't want to use SSMS for doing mirroring. I want to provide this facility in my application to the user programmatically.|||I too am very interested in this answer. We are looking to automate some of the setup and configuration and it would be nice to be able to use SMO or some other exposed APIs to do it with.

Can it be a bug in SQL CE?

Hi!

I use SQL CE with VS.NET 2003. I find the following bug second time.

The table has an "ID int IDENTITY(0,1) PRIMARY KEY,". That is my row identity.

I add rows to the table, then I made some select and update queries. Then I realized that the ID order not in the general order (from 0 to ........)

For example: 6,7,8,0,1,2,3,4,5.

Of course row 6,7 and 8 was added the very last.

The content of each row is not mixed, only the ID order.

Is it a very confused, because we develop mobile invoice programs for PDAs.

What I did wrong?

Thank you!

Do you mean rows are not sorted by ID should you retrieve them with select or IDs are created not in order of insertions? Say, you have integer column in addition to ID, and you've inserted numbers from 0 to 3 into it. Do you get data like this:

2 2

1 1

0 0

3 3

Or like this:

2 0

1 1

0 2

3 3

|||

Duplicate thread from the same user: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=229153&SiteID=1

Follow only the above given thread. This thread will not be monitored any more.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation