msde AlaptopND sql server on save

I have SQL Server Developer edition on my laptop. Want to install MSDE on
same laptop (so VB .NET 2003 will work.
Any issues here with two versions/inmstances of "SQL Server" on same box?
On Sat, 16 Apr 2005 13:11:28 -0700, rOBBY wrote:

>I have SQL Server Developer edition on my laptop. Want to install MSDE on
>same laptop (so VB .NET 2003 will work.
>Any issues here with two versions/inmstances of "SQL Server" on same box?
Hi Robby,
I have never tried it myself, but I *think* that it should work. Though
I can imagine your poor laptop having a hard time, attempting to serve
two memory-intensive applications. :-)
For a more authorative answer, I suggest you repeat your question in
microsoft.public.sqlserver.msde, or microsoft.public.sqlserver.setup.
This group (microsoft.public.sqlserver.mseq) is actually about English
Query, so most MSDE and setup experts don't hang around here.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

MSDE access denied error

I set up MSDE that came with VS.NET and, using the Server Explorer, created a database called 'pubs' on my server. The MSSQLServer icon is lit up in the System Tray and has been started. When I created 'pubs', I was prompted whether I wanted to use NT Integrated Security or SQL Server Authentication. I was forced to choose the NT option because any login name that I used, including my administrator account, the 'aspnet_wp account', 'SQLDebugger' and 'sa'. Every time I tried to use the SQL Server Auth. option, I would get the following error prompt:

ADO Error: '
Login failed for user 'whateverItried'. Reason: Not associated with a trusted SQL Server connection.

When running the following:

Dim myConnection As SqlConnection = New SqlConnection("server=(local);database=pubs;uid=sa;pwd=")

it would result in this error message:

Index #0
Error: System.Data.SqlClient.SqlError: SQL Server does not exist or access denied.

I also tried using 'localhost' and <my-computername>\<my-servername> for the server. For my database name, I tried both pubs and dbo.pubs. I also tried every username I could think of.

No luck.

Here's the funny thing: I was able to create a View on the database that did exactly what I was trying to do in code, so the DB is working.

If anyone has sucessfully ran the first example program in Chapter 16 of Beginning VB.NET 2nd edition, please respond. That's where I got this example.

Thanks for any help!

JasonWhat is the authentication mode used to connect?

Refer to books online for Troubleshooting the Transact-SQL Debugger topic.|||Originally posted by Satya
What is the authentication mode used to connect?

Refer to books online for Troubleshooting the Transact-SQL Debugger topic.

I'm not sure what you are asking. Remember that I'm using MSDE and I don't go through a lot of the setup that MS SQL uses.

I was forced to use the NT Integrated Security, since no usernames or password combinations that I knew would work for the SQL option, if that's what you mean.|||True, update the SQL Server Authentication mode back to SQL Server Authentification as referred in this KBA (http://support.microsoft.com/default.aspx?scid=kb;EN-US;285097).|||I have only one icon running in my system tray and it is set to SQL Server, not SQL Server Agent.

Do I need both running? If so, how can I get an instance of Agent to run as well as the server, as suggested in the KBA?

By the way, thanks for your response!

Jason|||Also, what username do I use? 'SA'?

Jason

Originally posted by jtimms
I have only one icon running in my system tray and it is set to SQL Server, not SQL Server Agent.

Do I need both running? If so, how can I get an instance of Agent to run as well as the server, as suggested in the KBA?

By the way, thanks for your response!

Jason|||We have the same issue. If you also have Enterprise Manager installed on the same machine, use it to be sure TCP/IP is an enabled protocol. We did that and were able to connect.

The 64 dollar question is how you do this if you DON'T have Enterprise manager. Anyone know how to do it programatically?

Jim M.
Orrtax Software|||Of course you can!

Search for this file:

svrnetcn.exe

usually in:

"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe"

which is the Server Network Configuration|||Manowar...thank you! I had the same problem as above, and it turned out that my server had not had TCP/IP enabled! Thank you so much!|||hi manomar - thanks a lot for your entry to this forum. i have had exactly the same problem and thru your entries - now it works!

regards,

Originally posted by manowar
Of course you can!

Search for this file:

svrnetcn.exe

usually in:

"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe"

which is the Server Network Configuration|||MSDE usually installs as a named instance, rather than the default instance (this way no two MSDE installs can interfere with each other...theoretically). Check in Administrative tools->services, and check the name of the MSSQL service. If it is MSSQLService, then it is amazingly the default instance. If it is MSSQL$blah, then you have a named instance. In order to address a named instance, you need to specify the name of the server, and the name of the instance as

server=servername\blah

You can also use IP addresses:

10.10.10.10\blah

Not sure if this works:

(local)\blah

Note that while the service is named with a '$', and all folders related to the instance are named with a '$', the service is addressed with '\'. Intuitive, right?|||I have another strange problem:

When I use SVRNETCN or click on the properties in enterprise manager, I see that TCP/IP is enabled for my msde Instance.
But when I look in the error.log of my instance, I see only the entry:
SQL server listening on Named Pipes

There is no entry that the server is listening on TCP/IP and I still get the error message "SQL Server does not exist or access denied" when I try to connect to my database over the network.
So I think my server is still not listening on TCP/IP.

Has anyone a workaround for this problem?

Thanks in advance

MSDE 2000 which version to use?

Hi,
I'm planning to develop a VB.NET application using MSDE but came across
these sites... so I'm sort of confused which version of MSDE 2000 to use.
http://www.microsoft.com/downloads/d...displaylang=en
http://www.microsoft.com/downloads/d...displaylang=en
After checking the above two sites, please try to answer the following
questions:
1. What's the difference between these two MSDE 2000?
2. Which one to use for development? (VB.NET)
3. Which one to re-distribute with my custom application?
I was thinking that I have to use the 70MB MSDE file. BUT after comparing
the dates, I'm a bit confused. The 70MB file is older.
Thank you for you time.
Sukhdev.
hi Sukhdev,
"Sukhdev" <Sukhdev@.discussions.microsoft.com> ha scritto nel messaggio
news:73B0850D-01E3-41C3-83D5-CF1ED3DAE36B@.microsoft.com
> Hi,
> I'm planning to develop a VB.NET application using MSDE but came
> across these sites... so I'm sort of confused which version of MSDE
> 2000 to use.
>
http://www.microsoft.com/downloads/d...displaylang=en
>
http://www.microsoft.com/downloads/d...displaylang=en
> After checking the above two sites, please try to answer the following
> questions:
> 1. What's the difference between these two MSDE 2000?
the final result, after installation, is actually the same... both install
MSDE at the 3a service pack level..
but there's both a technical and an EULA difference..
MSDE Web Release A can only install fresh instances of MSDE 2000, while the
other package can both install new fresh instances and upgrad existing
instance at the service pack 3a level
as regard the EULA, the second package must be licensed by an appropriate
license of Visual Studio, Fox Pro, MSDN, SQL Server and so on, while MSDE
release A is really free for download, and you only have to register for
redistribution rights if you want to at
http://www.microsoft.com/sql/msde/ho...tregister.asp, but not for
use...

> 2. Which one to use for development? (VB.NET)
I strongly suggest to buy the Developer edition of SQL Server (about $50),
which includes all the server tools like Enterprise Manager, Query Analyzer,
Profiler and all the wizards like Index Tuning to troubleshoot development
issues...

> 3. Which one to re-distribute with my custom application?
chose the one you prefer... redistribution, in this case, is not a
problem...(as long as you are entitled for both)
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

MSDE 2000 and merge modules

I have a vb.net desktop application that uses msde 2000 for its databasing. I am trying to create a setup file using the output of my desktop application and the msde 2000 merge modules in order to install my own build plus an instance of msde 2000.

The setup runs properly and then asks me to restart my machine. After the restart, however, there is no such instance running on my machine. I am adding the following internal properties to my msi file using ocra:

SQLMSDESelected 1
SqlInstanceName Midas
SqlSaPwd Password1
SqlSecurityMode SQL
SqlDataDir C:\Program Files\Microsoft SQL Server\MSSQL$Midas\Data
SqlProgramDir C:\Program Files\Microsoft SQL Server
This should create an instance of msde on my machine but when I try to connect using enterprize manager or query analizer (I connect to <<machinename>>\Midas), then I get the standard can not connect error.

I am at my witt's end and would really appreciate any help.

Thanks.

Hi,

maybe you could help me....

I'm trying to create a setup file using the VS2003 "Setup Project" and MSDE2000SP4 Merge Modules (editing properties with ORCA).

But when I run the installation file, it shows the following message:

"The Error Code is 2920".

Do you know how to fix that ?

Thanks,

Jo?o Paulo.

sql

MSDE 2000 and merge modules

I have a vb.net desktop application that uses msde 2000 for its databasing. I am trying to create a setup file using the output of my desktop application and the msde 2000 merge modules in order to install my own build plus an instance of msde 2000.

The setup runs properly and then asks me to restart my machine. After the restart, however, there is no such instance running on my machine. I am adding the following internal properties to my msi file using ocra:

SQLMSDESelected 1
SqlInstanceName Midas
SqlSaPwd Password1
SqlSecurityMode SQL
SqlDataDir C:\Program Files\Microsoft SQL Server\MSSQL$Midas\Data
SqlProgramDir C:\Program Files\Microsoft SQL Server
This should create an instance of msde on my machine but when I try to connect using enterprize manager or query analizer (I connect to <<machinename>>\Midas), then I get the standard can not connect error.

I am at my witt's end and would really appreciate any help.

Thanks.

Hi,

maybe you could help me....

I'm trying to create a setup file using the VS2003 "Setup Project" and MSDE2000SP4 Merge Modules (editing properties with ORCA).

But when I run the installation file, it shows the following message:

"The Error Code is 2920".

Do you know how to fix that ?

Thanks,

Jo?o Paulo.

MSDE + ASPX Web Provider

Can anyone tell me if there are Web Space Providers, who support MSDE and ASPX?
Thanks for Information!
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Do you mean they provide you with a server?
If so why msde?
see
http://www.webhost4life.com/hosting.asp
"SqlJunkies User" wrote:

> Can anyone tell me if there are Web Space Providers, who support MSDE and ASPX?
> Thanks for Information!
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
>

MSDE > SQL Express

We have a product on the market, with 100k or so installs that use MSDE as its database (desktop application in .net). Our number 1 complaint is massive installation problems with MSDE.

Now, we are stuck a bit - first, we need to release a Vista Compatible version - which means no MSDE. We also need to migrate users from MSDE to SQL Express, with no data loss (we deal with financial information, and people tend to have zero tolerance for data loss here).

So, I have large scale reservations for two reasons - first, Microsoft's track record in supporting and making MSDE in the past has not been stellar.

With that said - are the multiple installation failure issues fixed in SQL Express? Did MS make the effort to get SQL Express to install on Win2k/XP/Vista improved? Are their benchmark figures out there regarding SQL Express install failure rates?

Additionally, can I get some information regarding MSDE to SQL Express upgrades done during for existing customers?

jason

Hi Jason,

Great strides have been made in installation for SQL Express and it is much better than MSDE. This is not to say there are no issues, a quick search of this forum will confirm that there are, but I have not seen the kind of wholesale failures that were common with MSDE. I think SQL Express is way better for install than MSDE.

I don't know of anyone that tracks benchmarks such as you describe, sorry. I can point you to an article that we have that describes best practices for upgrading from MSDE to SQL Express, you can find it here. I have confidence that our upgrade procedure will not harm or lose our data since your database files are just left in place and then attached once the new server is installed, but I would be remise to not remind you that you should take responsibility for protecting your own important data.

I'd say that it's critical to backup your databases as a first step of any migration process. Additionally, you may want to consider doing a side by side upgrade in stead of in place to give you maximum control. During a side by side upgrade, you manually move your databases, so you can choose to use a copy (leaving the original safe) or even migrate your data by restoring a backup rather than using the original mdf. One thing to remember, once the database is converted to SQL 2005, it can't go back to 2000 format. If you are concerned that you might want to roll back the migration, you need to ensure that you keep a copy of the 2000 format database around until migration is complete.

Mike

MSDE & SQL Server 2000 on the same machine !

Hi all,

I started learning ASP .Net using the "Teach yourself ASP.Net in 24 hours". In that book, the applications use MSDE as the database tool.

Now i have started developing some big applications and have installled MS SQL Server 2000 on my machine.

I still have databases on the MSDE.

My question is 'How do i move the old databases from MSDE to SQL Server 2000' ?

Can i uninstall MSDE safely since i already installed SQL Server 2000 ?

Please let me know.

Thank You
:-)you can detach them all, then re-attach them to SQL Server 2k - then ditch the MSDE instance. though you don't actually need to...|||What is the exact step by step process to install SQL Server 2000 if you have a previously installed version of MSDE?

I want to start over, get rid of MSDE and install SQL Server 2000. I'm using Visual Studio 2003 and I have seen several discussion threads that indicate that re-installing MSDE can be EXTREMELY complicated. I'm not a hacker... just a newbie who wants to develop ASP.NET sites. Are there any gotchas I need to be aware of?

What EXACTLY is the process? Do I quite the server manager, uninstall MSDE and then install SQL Server 2000? Are there any clear install guides out there that people can suggest?

TIA

:-)

MSDE & database moving.

Hi,

How to copy database diagram (all data) to other server using only MSDE
server and VS.Net Proffesional? I have no Enterprice manager. I have to
move database (create on my machine) to my customer server. Is some
possibilities?
--
*Pozdrawiam,*
Klaudiusz Bryjahi,
"bryja_klaudiusz[at]poczta[dot]fm" <dla@.zmyly.pl> ha scritto nel messaggio
news:c67ou4$i2p$1@.atlantis.news.tpi.pl...
> Hi,
> How to copy database diagram (all data) to other server using only MSDE
> server and VS.Net Proffesional? I have no Enterprice manager. I have to
> move database (create on my machine) to my customer server. Is some
> possibilities?
> --
> *Pozdrawiam,*
> Klaudiusz Bryja
you actually have 3 possibilities..
1)
you can detach your database(s), copy all the physical files you database is
made of to you user's server and re-attach the database using the system
stored procedure
EXEC sp_detach_db 'database_name' -- for detaching
and
EXEC sp_attach_db @.dbname = 'dbname'
, @.filename1 = 'c:\...\physical_position_Datafile.Mdf'
, @.filenameN = 'c:\...\physical_position_Logfile.Ldf'

ah... you have to re-attach the database to your server to, after copying
the files to a distribution media...
up to 16 data and log files can be specified, but please have a look at
http://msdn.microsoft.com/library/d..._ae-az_52oy.asp
for sp_attch_db synopsis and syntax...

2)
you can (full) backup you database(s) and restore it to your user's server
using
RESTORE DATABASE database_name
FROM DISK = 'c:\...\backup.bck'
WITH MOVE 'logical_Datafile_name' TO 'c:\..\newDataFilePosition.Mdf'
MOVE 'logical_Logfile_name' TO 'c:\..\newLogFilePosition.Ldf'

the WITH MOVE option grants you the possibility to specify alternate
physical positions on user's server, other than your original locations on
your dev server
please have a look at
http://msdn.microsoft.com/library/d..._ra-rz_25rm.asp
for Transact SQL backup syntax.

both these 2 methods are easy to implement, they can be performed on user's
server using ADO/AdoNet commands as long as via oSql.exe or similar tools...
they suffer a common scenario... you will restoring your database, based on
your model database, with your server settings regarding collation/sort
order, database options (autogrowth, autoshrink, size, recovery model and so
on), and more, they miss the ability to inherits objects/users existing in
user's model database.. another issue is you can propagate "orphaned users"
troubles if you not correctly purge your distribution database before
distributing it (more about "orphaned users" at
http://www.sqlservercentral.com/col...rokenlogins.asp)

3)
another way is to script out your database structure using tools like
Enterprise Manager or ObjectScripter, provided for free by MVP OJ at
http://www.rac4sql.net/objectscriptr_main.asp...
once the structure is exported to file, you can easily script out table
contents creating INSERT INTO sql scripts to be run in order to reload
pre-poluated tables, using the well known procedure provided by MVP Narayana
Vyas Kondreddi at http://vyaskn.tripod.com/code.htm#inserts (there are
other variations of that available on the net)
personally I do prefer this method, which grant me greater and more granular
control, where I can provide T-SQL DDL scripts, INSERT INTO scripts as long
as BCP possibility for larger tables/views.. this comes in handy for
structure version sync to, becouse the tool you provide for database
distribution can be prepared for upgrading database structure too.. and all
user's server and database settings are respected...
this method grants greater flexibility at the cost of greater complexity...
hth
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--- remove DMO to reply|||Hi,

Thanks. It helped.

>hi,
>"bryja_klaudiusz[at]poczta[dot]fm" <dla@.zmyly.pl> ha scritto nel messaggio
>news:c67ou4$i2p$1@.atlantis.news.tpi.pl...
>
>>Hi,
>>
>>How to copy database diagram (all data) to other server using only MSDE
>>server and VS.Net Proffesional? I have no Enterprice manager. I have to
>>move database (create on my machine) to my customer server. Is some
>>possibilities?
>>--
>>*Pozdrawiam,*
>>Klaudiusz Bryja
>>
>>
>>
>you actually have 3 possibilities..
>1)
>you can detach your database(s), copy all the physical files you database is
>made of to you user's server and re-attach the database using the system
>stored procedure
>EXEC sp_detach_db 'database_name' -- for detaching
>and
>EXEC sp_attach_db @.dbname = 'dbname'
> , @.filename1 = 'c:\...\physical_position_Datafile.Mdf'
> , @.filenameN = 'c:\...\physical_position_Logfile.Ldf'
>ah... you have to re-attach the database to your server to, after copying
>the files to a distribution media...
>up to 16 data and log files can be specified, but please have a look at
>http://msdn.microsoft.com/library/d..._ae-az_52oy.asp
>for sp_attch_db synopsis and syntax...
>2)
>you can (full) backup you database(s) and restore it to your user's server
>using
>RESTORE DATABASE database_name
> FROM DISK = 'c:\...\backup.bck'
> WITH MOVE 'logical_Datafile_name' TO 'c:\..\newDataFilePosition.Mdf'
> MOVE 'logical_Logfile_name' TO 'c:\..\newLogFilePosition.Ldf'
>the WITH MOVE option grants you the possibility to specify alternate
>physical positions on user's server, other than your original locations on
>your dev server
>please have a look at
>http://msdn.microsoft.com/library/d..._ra-rz_25rm.asp
>for Transact SQL backup syntax.
>both these 2 methods are easy to implement, they can be performed on user's
>server using ADO/AdoNet commands as long as via oSql.exe or similar tools...
>they suffer a common scenario... you will restoring your database, based on
>your model database, with your server settings regarding collation/sort
>order, database options (autogrowth, autoshrink, size, recovery model and so
>on), and more, they miss the ability to inherits objects/users existing in
>user's model database.. another issue is you can propagate "orphaned users"
>troubles if you not correctly purge your distribution database before
>distributing it (more about "orphaned users" at
>http://www.sqlservercentral.com/col...rokenlogins.asp)
>3)
>another way is to script out your database structure using tools like
>Enterprise Manager or ObjectScripter, provided for free by MVP OJ at
>http://www.rac4sql.net/objectscriptr_main.asp...
>once the structure is exported to file, you can easily script out table
>contents creating INSERT INTO sql scripts to be run in order to reload
>pre-poluated tables, using the well known procedure provided by MVP Narayana
>Vyas Kondreddi at http://vyaskn.tripod.com/code.htm#inserts (there are
>other variations of that available on the net)
>personally I do prefer this method, which grant me greater and more granular
>control, where I can provide T-SQL DDL scripts, INSERT INTO scripts as long
>as BCP possibility for larger tables/views.. this comes in handy for
>structure version sync to, becouse the tool you provide for database
>distribution can be prepared for upgrading database structure too.. and all
>user's server and database settings are respected...
>this method grants greater flexibility at the cost of greater complexity...
>hth

MSDE - Failed to configure server

I've been looking into this all day and haven't gotten anywhere. I'm using
InstallShield to install a .Net application, the application uses MSDE as
its database. I've added InstallShield's MSDE object to the install, works
fine sometimes but most of the time I get the following error message when
the MSDE is almost installed.
"Setup failed to configure the server. Refer to the server error logs and
setup errors for more information."
I've scoured the internet looking into this error and nothing seems to
correct this issue. I've remove all files, registry keys and anything
related to MSDE and I still get the same error.
Thanks in advance,
Dave
Have you tried installing MSDE using the file available for download from
Microsoft?
Linda
"Dave" <dave.golightly@.stgutah.com> wrote in message
news:uDSjGMDzEHA.2568@.TK2MSFTNGP10.phx.gbl...
> I've been looking into this all day and haven't gotten anywhere. I'm
> using
> InstallShield to install a .Net application, the application uses MSDE as
> its database. I've added InstallShield's MSDE object to the install,
> works
> fine sometimes but most of the time I get the following error message when
> the MSDE is almost installed.
> "Setup failed to configure the server. Refer to the server error logs and
> setup errors for more information."
> I've scoured the internet looking into this error and nothing seems to
> correct this issue. I've remove all files, registry keys and anything
> related to MSDE and I still get the same error.
> Thanks in advance,
> Dave
>
>
|||Have you tried installing MSDE using the file available for download from
Microsoft?
Linda
"Dave" <dave.golightly@.stgutah.com> wrote in message
news:uDSjGMDzEHA.2568@.TK2MSFTNGP10.phx.gbl...
> I've been looking into this all day and haven't gotten anywhere. I'm
> using
> InstallShield to install a .Net application, the application uses MSDE as
> its database. I've added InstallShield's MSDE object to the install,
> works
> fine sometimes but most of the time I get the following error message when
> the MSDE is almost installed.
> "Setup failed to configure the server. Refer to the server error logs and
> setup errors for more information."
> I've scoured the internet looking into this error and nothing seems to
> correct this issue. I've remove all files, registry keys and anything
> related to MSDE and I still get the same error.
> Thanks in advance,
> Dave
>
>