MSDE to SQL Server Express

Hi - I have an MSDE database running on my server - I'd like to port my asp.net 1.1 app to asp.net2, and make use of SQL 2005 Express.

How do I transfer my data from an MSDE database to SQL Server Express, keeping intact all of my unique ID fields, indexes, and SPs (I don't have any functions or views)

Thanks for any help,

Mark

Your best bet is either to "detach" it on the MSDE side, and "attach" it or "restore from backup" on the SQL 2005 side, or use DTS (data transformation services).

|||Hi - it's just SQL Server 2005 Express I have available, so no management tools are there to allow me to 'restore from backup' - I'm not sure it supports DTS either.

Has anyone else been able to do this?

Thanks, Mark|||

Even with SQL Express you should have the ability to detach the database. You need the Management studio installed to work with the Express server engine though. You can download it here.

http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en

|||You don't have to detach from SQL Express if you are using a file based database (You are if you use the AttachDB attribute in your connect string). Just stop whatever application that uses it, and copy the mdb/ldb files to SQL Sever 2005 and attach.

MSDE to MS SQL restore

I have a MSDE database that I am trying to restore into MS SQL 7.

I am running the following restore from Query Analyzer;

RESTORE DATABASE name
FROM DISK = 'c:\mssql7\backup\name_backup'

I am getting the following error

Server: Msg 3624, Level 20, State 1, Line 1

Location: upgraddb.cpp:214
Expression: tableIndex < ARRAY_LEN (upgradeMap)
SPID: 7
Process ID: 748

Connection Broken

Is what I'm trying to do impossible or something I'm doing wrong. Any help would be much appreciatedI don't know if this will help.

I had the same problem where I wanted to resore a MSDE database to SQL Server 2000. There was just no way. So I then used DTS to just transfer the Database to the SQL Server 2000.|||Originally posted by machado
I don't know if this will help.

I had the same problem where I wanted to resore a MSDE database to SQL Server 2000. There was just no way. So I then used DTS to just transfer the Database to the SQL Server 2000.

I only have the backup file, I don't actually posess MSDE so as far as I know I can't actually connect to anything for a dts to work|||MSDE can be distributed free and is included on the MS Office Prof. 2000/XP CDs.
What I would suggest is installing MSDE on any other machine on your network and restoring the database to MSDE and then transfering the databse using DTS.|||Originally posted by machado
MSDE can be distributed free and is included on the MS Office Prof. 2000/XP CDs.
What I would suggest is installing MSDE on any other machine on your network and restoring the database to MSDE and then transfering the databse using DTS.

So it is :)

Thanks, I'm installing it nowsql

MSDE sql express on laptop, error 26

hi, I am running Visual Studio.net 2005 on my laptop, MSDE sql express was
installed during the installation, finally trying to get an sql database to
work, i am a newbie to both Visual studio and SQL, anyway i can see the
database inside server explorer and all its talbles, but when i try to run
the application i get an error has occured while establishing a connection
the 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 SQL network interfaces, error:26 error
locatiang server/instance Specified
i read similar posts in this forum and tried the following
enabled TCP/Ip on the server and client, do i need any of the other
protocols enabled: shared memory is enabled, named pipes is disabled, tcp/ip
is enablaed and VIA is disabled, this is for the server, for the client
shared memory, tcp/ip, named pipes are all enabled while via is disabled
i ran the SQL server surface area configuration and choose the Surface area
configuration for servcies and connections, under there, the radio buttion
for local and remote connection/Using TCP/IP only are selected. so i think
that is ok
i copi8ed a SQL database to a folder in the database and set the connection
using the wizard, i tested the connection and it is ok.
are there other things to do are other places to check,
Possibility 1:
Start the SQL Server Browser Service. SQL Server 2005 Express installs as a
named instance called sqlexpress. The SQL Server Browser Service resolves a
connection attempt of <computer_name>\sqlexpress to a port number. Without
SQL Server Browser, when connecting to a named instance you need to specify
the port number when you connect. And all named instances like SQL Server
2005 listen on dynamic ports, so the port may change when SQL Server is
started.
Possibility 2:
If you are running on a laptop, you may be running on Windows XP, service
pack 2 which automatically turns on the Windows firewall. If you are
connecting from the same server, you should be connecting using Shared
Memory so that won't matter. If you are connecting from another computer,
you may need to open a TCP port, or allow sqlservr.exe to communicate
through the firewall.
If this information is helpful, more information is available at
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Frank Bruhn" <FrankBruhn@.discussions.microsoft.com> wrote in message
news:E96EEA76-4277-4D80-8B75-79D945744E95@.microsoft.com...
> hi, I am running Visual Studio.net 2005 on my laptop, MSDE sql express was
> installed during the installation, finally trying to get an sql database
> to
> work, i am a newbie to both Visual studio and SQL, anyway i can see the
> database inside server explorer and all its talbles, but when i try to run
> the application i get an error has occured while establishing a connection
> the 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 SQL network interfaces, error:26 error
> locatiang server/instance Specified
> i read similar posts in this forum and tried the following
> enabled TCP/Ip on the server and client, do i need any of the other
> protocols enabled: shared memory is enabled, named pipes is disabled,
> tcp/ip
> is enablaed and VIA is disabled, this is for the server, for the client
> shared memory, tcp/ip, named pipes are all enabled while via is disabled
> i ran the SQL server surface area configuration and choose the Surface
> area
> configuration for servcies and connections, under there, the radio buttion
> for local and remote connection/Using TCP/IP only are selected. so i think
> that is ok
> i copi8ed a SQL database to a folder in the database and set the
> connection
> using the wizard, i tested the connection and it is ok.
> are there other things to do are other places to check,
>
>

MSDE sql express on laptop, error 26

hi, I am running Visual Studio.net 2005 on my laptop, MSDE sql express was
installed during the installation, finally trying to get an sql database to
work, i am a newbie to both Visual studio and SQL, anyway i can see the
database inside server explorer and all its talbles, but when i try to run
the application i get an error has occured while establishing a connection
the 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 SQL network interfaces, error:26 error
locatiang server/instance Specified
i read similar posts in this forum and tried the following
enabled TCP/Ip on the server and client, do i need any of the other
protocols enabled: shared memory is enabled, named pipes is disabled, tcp/i
p
is enablaed and VIA is disabled, this is for the server, for the client
shared memory, tcp/ip, named pipes are all enabled while via is disabled
i ran the SQL server surface area configuration and choose the Surface area
configuration for servcies and connections, under there, the radio buttion
for local and remote connection/Using TCP/IP only are selected. so i think
that is ok
i copi8ed a SQL database to a folder in the database and set the connection
using the wizard, i tested the connection and it is ok.
are there other things to do are other places to check,Possibility 1:
Start the SQL Server Browser Service. SQL Server 2005 Express installs as a
named instance called sqlexpress. The SQL Server Browser Service resolves a
connection attempt of <computer_name>\sqlexpress to a port number. Without
SQL Server Browser, when connecting to a named instance you need to specify
the port number when you connect. And all named instances like SQL Server
2005 listen on dynamic ports, so the port may change when SQL Server is
started.
Possibility 2:
If you are running on a laptop, you may be running on Windows XP, service
pack 2 which automatically turns on the Windows firewall. If you are
connecting from the same server, you should be connecting using Shared
Memory so that won't matter. If you are connecting from another computer,
you may need to open a TCP port, or allow sqlservr.exe to communicate
through the firewall.
If this information is helpful, more information is available at
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx
--
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Frank Bruhn" <FrankBruhn@.discussions.microsoft.com> wrote in message
news:E96EEA76-4277-4D80-8B75-79D945744E95@.microsoft.com...
> hi, I am running Visual Studio.net 2005 on my laptop, MSDE sql express was
> installed during the installation, finally trying to get an sql database
> to
> work, i am a newbie to both Visual studio and SQL, anyway i can see the
> database inside server explorer and all its talbles, but when i try to run
> the application i get an error has occured while establishing a connection
> the 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 SQL network interfaces, error:26 error
> locatiang server/instance Specified
> i read similar posts in this forum and tried the following
> enabled TCP/Ip on the server and client, do i need any of the other
> protocols enabled: shared memory is enabled, named pipes is disabled,
> tcp/ip
> is enablaed and VIA is disabled, this is for the server, for the client
> shared memory, tcp/ip, named pipes are all enabled while via is disabled
> i ran the SQL server surface area configuration and choose the Surface
> area
> configuration for servcies and connections, under there, the radio buttion
> for local and remote connection/Using TCP/IP only are selected. so i think
> that is ok
> i copi8ed a SQL database to a folder in the database and set the
> connection
> using the wizard, i tested the connection and it is ok.
> are there other things to do are other places to check,
>
>

msde speed issue

i have msde installed and running on my local pc. i have 2 db's which both reside on my loacl pc as well. both db's are the same. i have an app that access and retrives data for a db. when i run the app connected to db1 it takes abount 3 seconds to retrive and dispaly my data. when i connect to db2 with the same app, it takes about 35 seconds to retrive the same data. is there some sort of setting on db1 that needs to be set for db2 or can it be some sort of worm on db2 which has not effected db1. if you have any ideas please let me know.

Thank You,
ThomasHave you tried to rebuild index on both db ?|||how do you rebuild the index? can this be done using enterprise manager?

Thomas|||The simplest way to do it if you don't know much SQL is to execute the next command line tool:

sqlmaint -U login -P password -D dbname -RebldIdx 100
See SQL Server Books On Line (http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp) for more help|||when i try to run the following line:

sqlmaint -U sa -P eicon_dev -D belmont -RebldIdx 100

i get the following error

execution cannot continue as the language dependent resource file c:\resource\1033\sqlmaint.rll could not be loaded.|||Maybe sqlmaint is not installed (try to see if the file exists).

Otherwise, you should execute this T-SQL command on the tables called by your apps:

USE yourdb
GO
DBCC DBREINDEX (yourtable)
GO|||sorry i ran the command from the wrong location. i ran it from the proper p;ace and it update my indexes with out error and now my app runs perfectly. thak you very much. one question how often should i run this command? also is there any negative effects to running this comand?

Thanks,
Thomas|||Good ! :)

This frequency depends of the modification level of your data (insert / delete).

I've never had problem with this command. Maybe someone else have had here ?|||can i run this command on an sql database as well or does it only work on msde databases.|||No, you can run it on other edition of SQL Server (as Standard or Enterprise or Personal).

MSDE SP3a Upgrade problem

I just upgraded my desktop engine MSDE 1.0 to MSDE 2000 SP3a. Everything seemed to go well, MSSQLSERVER AND SQLSERVER Agent Services are running, problem is, I can no longer see the particular instance on the network from Enterprise Manager.

The installation instructions specified that if the Instance was to accept connections from applications on other computers not to specify the DISABLENETWORKPROTOCOLS parameter, so I didn't.

I'm a little green with this, can anyone suggest a place to start troubleshooting?Can you pull it up in Query Analyzer. Just type in (local) or whatever your instance name is for the connection server and see if it connects.

MSDE sharepoint databases how to import and export

Dear all,
I have a Intranet running the sharepoint version which
comes with Frontapage 2002 and MS desktop SQL 7.
My server have a problem and I have to upgrade it to MS
desktop SQL 2000A. Now my sharepoint databases don't work
anymore.
I was wondering if theere is a way to import them back
into the new MS DESKTOP SQL 2000A.
Thank you for any help
HI Renato,
ReadmeMSDE2000A.htm comes with your download of MS Desktop SQL 2000A. It
talks about the changes in this release. Your database doesn't work any
more probably due to the security change that requires strong password.
Empty sa passowrd is no longer accepted. If that is the case, you can
change your sa password by running this query: EXEC sp_password NULL,
'yourpassword', 'sa' and then replace in your code with the new password.
Hope this helps.
Amy
| Content-Class: urn:content-classes:message
| From: "Renato" <anonymous@.discussions.microsoft.com>
| Sender: "Renato" <anonymous@.discussions.microsoft.com>
| Subject: MSDE sharepoint databases how to import and export
| Date: Wed, 7 Apr 2004 07:34:13 -0700
| Lines: 13
| Message-ID: <19b6f01c41cad$65a1d0c0$a101280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQcrWWh/rvselubSzuv0Twjq4q0CQ==
| Newsgroups: microsoft.public.sqlserver.msde
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.msde:13479
| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| Dear all,
|
| I have a Intranet running the sharepoint version which
| comes with Frontapage 2002 and MS desktop SQL 7.
|
| My server have a problem and I have to upgrade it to MS
| desktop SQL 2000A. Now my sharepoint databases don't work
| anymore.
|
| I was wondering if theere is a way to import them back
| into the new MS DESKTOP SQL 2000A.
|
| Thank you for any help
|

MSDE Running on Two Computers in Workgroup Mode

I have two PC running Windows XP Pro in Workgroup Mode. They both in mixed
authentication mode with blank sa password.
The usernames on each machine are the same and they have no password.
The problem I have is with merge replication. The replication fails with the
message "Login failed for user 'sa'. Reason: Not associated with a trusted
SQL Server connection."
Both computers use the local system account to start the SQL server agent.
If we connect manually to the database via ADO using the sa with blank
password we have no difficulties.
Can someone please advise where I am going wrong.
Thank you in advance.
Colin
Hi ,
There are a number of reasons why this error may occur:
Try using these steps:
1) Most probably you may not be able to logon on to the sql server using
windows authentication.
2) Try using windows authentication over named pipes instead fo tcp/ip to
connect to the sql server.
Make sure that you make use of an alias to do the task
This should fix the problem.
Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.

MSDE running on same machine as SQL Sever 2000?

Hi,
I currently have 2 instances of MSDE running on a server to support two
different applications. We have decided to obtain the full SQL 2000 std for
another project. Can SQL Server 2000 run on the same machine as Server MSDE?
Will I need to migrate the existing databases that are currently using MSDE
to SQL Server 2000 once it is installed?
Thanks
You CAN run MSDE and another edition on the same machine.
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jedi Dave" <Jedi Dave@.discussions.microsoft.com> wrote in message
news:748798E1-F1A2-4F2B-8C81-30CD70B19F68@.microsoft.com...
> Hi,
> I currently have 2 instances of MSDE running on a server to support two
> different applications. We have decided to obtain the full SQL 2000 std
> for
> another project. Can SQL Server 2000 run on the same machine as Server
> MSDE?
> Will I need to migrate the existing databases that are currently using
> MSDE
> to SQL Server 2000 once it is installed?
> Thanks
sql

MSDE running from a CD!

I think I am trying to do the impossible.
We have a customer who would like to run an application and the MSDE
directly from a CD. Does anyone know how to get the tempdb to work as CD's
are read only?
Any advice would be appreciated.
"John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> I think I am trying to do the impossible.
> We have a customer who would like to run an application and the MSDE
> directly from a CD. Does anyone know how to get the tempdb to work as CD's
> are read only?
Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
physical drive or worse a RAM drive.
I can pretty much guarantee MS won't support this though if you call in with
problems.
What's their real goal?

> Any advice would be appreciated.
|||The aim is to be able to inset a CD into a machine and run an application
accessing data in the database. They do not want to have any installation
done. The data is read only but can be cut and diced in many ways and there
is a large quantity of it.
We are trying to see if they will let us run an install. The problem is not
all machines allow access to the C drive for writing with normal user
permissions and not all machines have a D drive. It all depends on how people
inmplement XP and user profiles.
Some machines will be still running older operating systems as old as
Windows 95.
Trying to make this universal is a bit of a headache.
In the past where I have known the target coinfiguration the install writes
the tempdb to to a known location on the hard drive configured into the
database.
This worked because we had control of the image ont the target machines.
"Greg D. Moore (Strider)" wrote:

> "John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
> news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
> physical drive or worse a RAM drive.
> I can pretty much guarantee MS won't support this though if you call in with
> problems.
> What's their real goal?
>
>
>
|||SQL Server cannot just be "executed", you need to install, get registry keys, errorlog files, tempdb
files and all that jazz. You might want to look at some other storage and retrieval product for
this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Kaye" <helpneeded@.mailinator.com> wrote in message
news:510D5C9C-187E-4E9B-A28F-094FD5AC14AD@.microsoft.com...[vbcol=seagreen]
> The aim is to be able to inset a CD into a machine and run an application
> accessing data in the database. They do not want to have any installation
> done. The data is read only but can be cut and diced in many ways and there
> is a large quantity of it.
> We are trying to see if they will let us run an install. The problem is not
> all machines allow access to the C drive for writing with normal user
> permissions and not all machines have a D drive. It all depends on how people
> inmplement XP and user profiles.
> Some machines will be still running older operating systems as old as
> Windows 95.
> Trying to make this universal is a bit of a headache.
> In the past where I have known the target coinfiguration the install writes
> the tempdb to to a known location on the hard drive configured into the
> database.
> This worked because we had control of the image ont the target machines.
>
>
> "Greg D. Moore (Strider)" wrote:

MSDE running from a CD!

I think I am trying to do the impossible.
We have a customer who would like to run an application and the MSDE
directly from a CD. Does anyone know how to get the tempdb to work as CD's
are read only?
Any advice would be appreciated."John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> I think I am trying to do the impossible.
> We have a customer who would like to run an application and the MSDE
> directly from a CD. Does anyone know how to get the tempdb to work as CD's
> are read only?
Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
physical drive or worse a RAM drive.
I can pretty much guarantee MS won't support this though if you call in with
problems.
What's their real goal?

> Any advice would be appreciated.|||The aim is to be able to inset a CD into a machine and run an application
accessing data in the database. They do not want to have any installation
done. The data is read only but can be cut and diced in many ways and there
is a large quantity of it.
We are trying to see if they will let us run an install. The problem is not
all machines allow access to the C drive for writing with normal user
permissions and not all machines have a D drive. It all depends on how peopl
e
inmplement XP and user profiles.
Some machines will be still running older operating systems as old as
Windows 95.
Trying to make this universal is a bit of a headache.
In the past where I have known the target coinfiguration the install writes
the tempdb to to a known location on the hard drive configured into the
database.
This worked because we had control of the image ont the target machines.
"Greg D. Moore (Strider)" wrote:

> "John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
> news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on
a
> physical drive or worse a RAM drive.
> I can pretty much guarantee MS won't support this though if you call in wi
th
> problems.
> What's their real goal?
>
>
>|||SQL Server cannot just be "executed", you need to install, get registry keys
, errorlog files, tempdb
files and all that jazz. You might want to look at some other storage and re
trieval product for
this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Kaye" <helpneeded@.mailinator.com> wrote in message
news:510D5C9C-187E-4E9B-A28F-094FD5AC14AD@.microsoft.com...[vbcol=seagreen]
> The aim is to be able to inset a CD into a machine and run an application
> accessing data in the database. They do not want to have any installation
> done. The data is read only but can be cut and diced in many ways and ther
e
> is a large quantity of it.
> We are trying to see if they will let us run an install. The problem is no
t
> all machines allow access to the C drive for writing with normal user
> permissions and not all machines have a D drive. It all depends on how peo
ple
> inmplement XP and user profiles.
> Some machines will be still running older operating systems as old as
> Windows 95.
> Trying to make this universal is a bit of a headache.
> In the past where I have known the target coinfiguration the install write
s
> the tempdb to to a known location on the hard drive configured into the
> database.
> This worked because we had control of the image ont the target machines.
>
>
> "Greg D. Moore (Strider)" wrote:
>

MSDE running from a CD!

I think I am trying to do the impossible.
We have a customer who would like to run an application and the MSDE
directly from a CD. Does anyone know how to get the tempdb to work as CD's
are read only?
Any advice would be appreciated."John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> I think I am trying to do the impossible.
> We have a customer who would like to run an application and the MSDE
> directly from a CD. Does anyone know how to get the tempdb to work as CD's
> are read only?
Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
physical drive or worse a RAM drive.
I can pretty much guarantee MS won't support this though if you call in with
problems.
What's their real goal?
> Any advice would be appreciated.|||The aim is to be able to inset a CD into a machine and run an application
accessing data in the database. They do not want to have any installation
done. The data is read only but can be cut and diced in many ways and there
is a large quantity of it.
We are trying to see if they will let us run an install. The problem is not
all machines allow access to the C drive for writing with normal user
permissions and not all machines have a D drive. It all depends on how people
inmplement XP and user profiles.
Some machines will be still running older operating systems as old as
Windows 95.
Trying to make this universal is a bit of a headache.
In the past where I have known the target coinfiguration the install writes
the tempdb to to a known location on the hard drive configured into the
database.
This worked because we had control of the image ont the target machines.
"Greg D. Moore (Strider)" wrote:
> "John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
> news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> > I think I am trying to do the impossible.
> > We have a customer who would like to run an application and the MSDE
> > directly from a CD. Does anyone know how to get the tempdb to work as CD's
> > are read only?
> Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
> physical drive or worse a RAM drive.
> I can pretty much guarantee MS won't support this though if you call in with
> problems.
> What's their real goal?
>
> >
> > Any advice would be appreciated.
>
>|||SQL Server cannot just be "executed", you need to install, get registry keys, errorlog files, tempdb
files and all that jazz. You might want to look at some other storage and retrieval product for
this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Kaye" <helpneeded@.mailinator.com> wrote in message
news:510D5C9C-187E-4E9B-A28F-094FD5AC14AD@.microsoft.com...
> The aim is to be able to inset a CD into a machine and run an application
> accessing data in the database. They do not want to have any installation
> done. The data is read only but can be cut and diced in many ways and there
> is a large quantity of it.
> We are trying to see if they will let us run an install. The problem is not
> all machines allow access to the C drive for writing with normal user
> permissions and not all machines have a D drive. It all depends on how people
> inmplement XP and user profiles.
> Some machines will be still running older operating systems as old as
> Windows 95.
> Trying to make this universal is a bit of a headache.
> In the past where I have known the target coinfiguration the install writes
> the tempdb to to a known location on the hard drive configured into the
> database.
> This worked because we had control of the image ont the target machines.
>
>
> "Greg D. Moore (Strider)" wrote:
> >
> > "John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
> > news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> > > I think I am trying to do the impossible.
> > > We have a customer who would like to run an application and the MSDE
> > > directly from a CD. Does anyone know how to get the tempdb to work as CD's
> > > are read only?
> >
> > Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
> > physical drive or worse a RAM drive.
> >
> > I can pretty much guarantee MS won't support this though if you call in with
> > problems.
> >
> > What's their real goal?
> >
> >
> > >
> > > Any advice would be appreciated.
> >
> >
> >

MSDE Replication issue

I am trying merge replication between two instances of MSDE on two
different machines on LAN.
I have setup the snapshot agent . when I try running the agent using
sp_start_job @.job_name='MergeSnapshot'
I get an error message saying job name ('MergeSnapshot') does not exist
I am new to replication and trying this for the first time...
Any help is appreciated.
Hello,
Please check out this article:
http://support.microsoft.com/default...b;en-us;324992
regards,
Henk Steunenberg
<prabhusangeeta@.yahoo.com> wrote in message
news:1133288220.042242.206490@.g44g2000cwa.googlegr oups.com...
>I am trying merge replication between two instances of MSDE on two
> different machines on LAN.
> I have setup the snapshot agent . when I try running the agent using
> sp_start_job @.job_name='MergeSnapshot'
> I get an error message saying job name ('MergeSnapshot') does not exist
> I am new to replication and trying this for the first time...
> Any help is appreciated.
>

MSDE remote connection on Windows Home - Windows Authentication

I installed an MSDE on a PC running Windows Home Edition. I would like
to connect to this MSDE installation from an oher PC using Windows
Authentication.
What do I have to do (add account on Home Edition)
hi,
xavierdaull@.gmail.com wrote:
> I installed an MSDE on a PC running Windows Home Edition. I would like
> to connect to this MSDE installation from an oher PC using Windows
> Authentication.
> What do I have to do (add account on Home Edition)
without a Domain Controller, thought in a Workgroup environment, usually you
should rely on standard SQL Server authenticated connections for remote
ones, as all the authentication features are resolved and managed by the
Domain Controller it self..
you can however setup a local account to map the remote account of the other
machine... that's to say, on your local PC you have to add another account
with the very same "credentials" of other account(s) present on the remote
PCs...
all this (still) works becouse of the underlying OS gets somehow confused
and a sort of "embezzlement" where 2 differents accounts, YourPC\YourAccount
and OtherPC\YourAccount "share" a kind of uniqueness becouse of netbios
intrusion... a preventive netbios connection, even on a share or using NET
USE can help...
but this is not granted to work in future releases or even OS service
packs...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Question

Sorry if this is basic stuff but I'm new to MSDE and SQL.

I am running MSDE as the server.

I created a Microsoft Access Project and connected to the MSDE. Security is
set to Integrated Security.

When I try to open the database from an application I am writing I get a
login error stating the user doesn't have rights to the database. I am
logged in to the computer with administrator privledges but get the error.

I know that I have to tell the server that users have access to the database
but how do I do that if I can't gain access to the database?

Thanks,

EricI have hit this problem with sql server as well. I fixed it by
creating a server based login. that is one that requires a user name
and password. That way in the program all you need for permission is
those to fields in teh Connection String. Of course you still need to
grant that login access to the relevent dbs

MSDE Problem - SQL Server not found or access denied

I am running the MSDE 2000 Setup off the SQL Server 2000 Developer Edition CD.

After installation is complete, there is a service under the Control Panel -> Services window
called MSSQL$GregInstance. I then start that service.

But now when I try to connect to the database using

osql -E -S GregInstance

I get told that the SQL Server does not exist or access denied. Even though the server is running. I have also tried

osql -E -S localhost

but no luck. Why can it not find the instance of SQL Server?

Note : SQL Server 2000 is not installed on the machine, only this MSDE instance.

Thanks
GregNot to worry, I forgot to add in the name of the pc with a \ before the instance name...

i.e

osql -E -S GREG\GregInstance

MSDE Problem

I have installed MSDE and it seems to have installed okay. I just don't
know how to check to see if it is running.
I also have SQL Server 2000 developer running on this computer.
Any suggestions on how I determine if it is running and how to troubleshoot
if it isn't?
Thanks
LanceYou have multiple instances.
You'll see MSSQLServer and MSSQL$<name> in services. One is SQL developer,
one MSDE.
You need to know the name to connect, you can use SQL query analyzer to
connect to <servername>\instance name (the slash may be the other way) or
osql to connect (osql -E -S<servername>\instance name.
To find the instance name is tricky.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:DHPWb.15625$IF1.14838@.fed1read01...
> I have installed MSDE and it seems to have installed okay. I just don't
> know how to check to see if it is running.
> I also have SQL Server 2000 developer running on this computer.
> Any suggestions on how I determine if it is running and how to
troubleshoot
> if it isn't?
> Thanks
> Lance
>

MSDE Problem

I am running MSDE (SQL Agent) and I am having the following problem:

When I setup my connection string to my table, it says that the connection was succesful. I have a asp.net page that has a text box and a button (trying to learn how to add data to a SQL table), anyways, when I input data into the text box and hit the button for it to add the data to the table I get the following error:

Error:
Login failed for user 'Discovery3\ASPNET'
Exception Details: System.Data.SqlCLient.SqlException: Login failed for user 'Discovery3\ASPNET'.

The line that is highlighted is
myConnection.Open()

Here is the code that I am using:
<>
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myConnectionString As String

If myConnectionString = "" Then
myConnectionString = "server=Discovery3;database=dbDVD;trusted_Connection=true"
End If

Dim myConnection As New Data.SqlClient.SqlConnection(myConnectionString)
Dim myInsertQuery As String = "INSERT INTO tblMaster(TITLE) values('" & TextBox1.Text & "')"
Dim myCommand As New Data.SqlClient.SqlCommand(myInsertQuery)
myCommand.Connection = myConnection
myConnection.Open()
myCommand.ExecuteNonQuery()
myCommand.Connection.Close()
End Sub

I don't understand how the connection can be succesfull, yet it errors out at the myConnection.Open() code. My table contains one field TITLE with nothing special.

Any ideas?The ASPNet user must be a user/login on the database - -|||There are a couple of solutions.

1. Go the the SQL Server and grant the ASPNET user Windows Integrated access to the server and the database "dbDVD". More general info on ASP.NET with MSDE can be found onKB 872905.
2. Use SQL authentication instead (less secure): add a SQL account to the database server, grant that account (read/write) access to the database. Change the connection string by omitting the trusted_connection flag and add a uid and pwd flag containing the user name (SQL account) and the password. To do this, you'll have to tweak the MSDE installation to allow SQL auth (you can MSN for this to find more info). However, I don't recommend this second solution.

Make sure only to grant the required access to the database that is needed from the web app; in this case likely only read/write to the tables (lowest privileges access).|||Thanks, this worked...

I got passed the permission error, but now I am getting one for the tables.

Here is the error I get now:

INSERT permission denied on object 'tblMaster', database 'master', owner 'dbo'

how do I give read/write access?

Thanks|||As explained in the aforementioned KB article, you'll need to grant access for the ASPNET login to the database (in this case "master" - side tip: I recommend to put your own private data in another database than the master!).

osql -E -S COMPUTER_NAME\VSDOTNET -Q "sp_grantlogin 'COMPUTER_NAME\ASPNET'"
osql -E -S COMPUTER_NAME\VSDOTNET -d Pubs -Q "sp_grantdbaccess 'COMPUTER_NAME\ASPNET'"
osql -E -S COMPUTER_NAME\VSDOTNET -d Pubs -Q "sp_addrolemember 'db_owner' 'COMPUTER_NAME\ASPNET'"

In here, replace the COMPUTER_NAME with the name of your computer and VSDOTNET with the name of the MSDE instance. In the second command, replace Pubs with the tables where you want to grant the ASPNET account access to.|||Thanks, I got the first to perfect it was the 'db_owner' that corrected the issue.

I appreciate the help.

MSDE problem

i have msde up and running, i hover on the icon it says
RUNNING -\\THECONTROLS MSSQLSERVER
but when i attempt to install the forums, the configuration test fails everytime, is this a msde problem or an install problem? does it have to do with localhost?8:23:49 PM Tuesday, January 20, 2004: [Checking system requirements]
8:23:49 PM Tuesday, January 20, 2004: [Pass] Detected a local instance of SQL Server.
8:23:49 PM Tuesday, January 20, 2004: [Pass] Determined SQL Server version (8.00.194).
8:23:49 PM Tuesday, January 20, 2004: [Pass] Detected .NET Framework.
8:23:49 PM Tuesday, January 20, 2004: [Pass] Detected Internet Information Server (IIS).
8:23:51 PM Tuesday, January 20, 2004: [Begin Sample Configuration]
8:23:51 PM Tuesday, January 20, 2004: [Fail] Could not create IIS virtual directory.: AspNetForums
Unknown error (0x80005000)
8:23:51 PM Tuesday, January 20, 2004: [Done]|||anyone have any ideas?|||Since this is a question about installing the ASP.NET Forums, you should have better luck posting this question on this forum:view forum 66

Terrosql

MSDE Problem

I have installed MSDE and it seems to have installed okay. I just don't
know how to check to see if it is running.
I also have SQL Server 2000 developer running on this computer.
Any suggestions on how I determine if it is running and how to troubleshoot
if it isn't?
Thanks
LanceYou have multiple instances.
You'll see MSSQLServer and MSSQL$<name> in services. One is SQL developer,
one MSDE.
You need to know the name to connect, you can use SQL query analyzer to
connect to <servername>\instance name (the slash may be the other way) or
osql to connect (osql -E -S<servername>\instance name.
To find the instance name is tricky.
--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
*******************************************************************
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:DHPWb.15625$IF1.14838@.fed1read01...
> I have installed MSDE and it seems to have installed okay. I just don't
> know how to check to see if it is running.
> I also have SQL Server 2000 developer running on this computer.
> Any suggestions on how I determine if it is running and how to
troubleshoot
> if it isn't?
> Thanks
> Lance
>