I have recently set up MSDE through a SharePoint services
install. I added a database, but when I go to add a table
through Visual Studio or osql I get the error "ADO error:
DDL statement is not allowed." I have tried to modify the
DDL settings in my database through >> exec sp_dboption
mydatabase, "ddl in tran", true <<, but "ddl in tran" is
not a recognized option any longer. Anyone know a
workaround on this? THANKS>Check your MDAC version
Try to update it.
Regards
---
All information provided above AS IS.
"Stephen Haiman" <shaiman@.ctt-inc.com> wrote in message
news:115501c3a2ea$88b9a2a0$a301280a@.phx.gbl...
> I have recently set up MSDE through a SharePoint services
> install. I added a database, but when I go to add a table
> through Visual Studio or osql I get the error "ADO error:
> DDL statement is not allowed." I have tried to modify the
> DDL settings in my database through >> exec sp_dboption
> mydatabase, "ddl in tran", true <<, but "ddl in tran" is
> not a recognized option any longer. Anyone know a
> workaround on this? THANKS>
Showing posts with label error. Show all posts
Showing posts with label error. Show all posts
Friday, March 30, 2012
MSDE and Access 2000
Hi everyone,
In using the SQL Server Database Wizard in Access 2000 to create a new
access project, I get two consecutive error messages and then the wizard
shuts down. The first, which apprears immediately after starting the wizard
is a message box stating something like "the property value is too large".
After clicking through and filling out the values in the connection and
database dialog, I get a second dialog box with the message "Overflow" and
the wizard terminates.
My operating system is Windows 2000 Professional with Access 2000 and MSDE
2000.
Does anyone have any thoughts about what might be causing these errors?
Thanks in advance.Hi Stephen
Have a look at Microsoft Knowledge Base Article Q272384
http://support.microsoft.com/defaul...kb;EN-US;272384
It describes the overflow error when creating a MS Access project on MSDE
2000.
Apparently, installing MS Office Service Pack 3 should fix the problem.
Hope this helps!
Martin
"Stephen Bishop" <sbishop33@.comcast.net> wrote in message
news:5KednfNSnerNM-vdRVn-tw@.comcast.com...
> Hi everyone,
> In using the SQL Server Database Wizard in Access 2000 to create a new
> access project, I get two consecutive error messages and then the wizard
> shuts down. The first, which apprears immediately after starting the
wizard
> is a message box stating something like "the property value is too large".
> After clicking through and filling out the values in the connection and
> database dialog, I get a second dialog box with the message "Overflow" and
> the wizard terminates.
> My operating system is Windows 2000 Professional with Access 2000 and MSDE
> 2000.
> Does anyone have any thoughts about what might be causing these errors?
> Thanks in advance.|||Thanks, Martin. I'll take a look at the article and see if it helps. As
far as the office version, I'm using Access 2000 (9.0.2720) and Office
2000, but I don't know the service pack status.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Open Access -> Help -> About Microsoft Access
At the end of first line it should say e.g. SP-1, SP-2 etc depending
on what service pack is installed.
Stephen Bishop <sbishop33@.comcast.net> wrote in message news:<40784f48$0$206$75868355@.news.frii.net>...
> Thanks, Martin. I'll take a look at the article and see if it helps. As
> far as the office version, I'm using Access 2000 (9.0.2720) and Office
> 2000, but I don't know the service pack status.
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
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
Wednesday, March 28, 2012
MSDE 2K Is there a compatibility issue with Backupexe or Sharepoint
We have installed an application that usese MSDE as the database, no error m
essage during install process. When application is opened and attempts to c
onnect with the database we get the following message:
sql code = -1
sql db code = 10004
"SQL Error: unable to connect: SQL server is unavailable or does not
exist. unable to connect: sql server does not exist or network access
denied"
We can get to the database and view contents using ODBC and OSQL. The syste
m is Windows Server 2003 Small Business Server, and we are using MSDE releas
e A. Other software on the system that might create a problem (hints I've s
een on other forums) are Ba
ckupexe and Sharepoint.
We have checked all issues of access rights and security issues we can think
of but apparently have overlooked something. This is a pretty high priorit
y issue for us so if anyone can help we would certainly appreciate it!I know this may not help much, but if you have no problem connecting from
OSQL and other application, you might want to check with teh vendor of the
application and find out how the connection to SQL Server is made from the
application. This might help lead to you why the error is occurring.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql
essage during install process. When application is opened and attempts to c
onnect with the database we get the following message:
sql code = -1
sql db code = 10004
"SQL Error: unable to connect: SQL server is unavailable or does not
exist. unable to connect: sql server does not exist or network access
denied"
We can get to the database and view contents using ODBC and OSQL. The syste
m is Windows Server 2003 Small Business Server, and we are using MSDE releas
e A. Other software on the system that might create a problem (hints I've s
een on other forums) are Ba
ckupexe and Sharepoint.
We have checked all issues of access rights and security issues we can think
of but apparently have overlooked something. This is a pretty high priorit
y issue for us so if anyone can help we would certainly appreciate it!I know this may not help much, but if you have no problem connecting from
OSQL and other application, you might want to check with teh vendor of the
application and find out how the connection to SQL Server is made from the
application. This might help lead to you why the error is occurring.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql
MSDE 2000a
What is going on with this program?
When I try to install it I get the error message:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."
Runing Win2k server, logged in as Administration.
Readme file says nothing about this
As usual, you can't find anything on M$ KB site.
I also tried the MSDE SP3 version - got the same results.I finally got it to install...had to edit the setup.ini file.
The server is running, the service is running but...
there is no enterprise manager...how are you suppose to manage your databases?|||There are a few things to manage your database. First of all there's the command-line tool called osql.exe that can be used to execute commands on your database. The second option is to use Access projects (supported on Access 2000 and higher if I'm not mistaken). Projects are a way to connect to a SQL Server or MSDE instance from within the Access product (pretty powerful). Last but not least there is the Web Data Administrator that can be downloaded fromhttp://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en.
Hope this can help?|||Hi if anyone is still reading this thread this is very helpfull. I was trying to use MSDE via MATRIX but there seems to be only an option to create tables but not relationships between them so I am wondering how to actually access MSDE directly , which of above 3 ways do you suggest and where do I find more about command line and projects?sql
MSDE 2000 SP3a install failure
I am getting an error when installing SP3a of MSDE. I get the error message "The instance name specified is invalid." This is the first SQL database installed, so there is no instance name. I have tried "default" and "MSSQLSERVER" as instance names without success.
your help is appreciated.the instance name is "MSDE"
Why is this not in the setup documentation?
your help is appreciated.the instance name is "MSDE"
Why is this not in the setup documentation?
Friday, March 23, 2012
MSDE 2000 installation fails on Windows Vista 64-bit
Installation of MSDE 2000 fails on 64-bit Windows Vista (Build 5308).
The error message is "Setup failed to configure the server.Please refer the error logs for more information". No error log can be found on the machine at the time of installation. Please let me know if anyone else has encountered this problem?
Is it possible to install MSDE 2000 on 64-bit Windows Vista(Build 5308)?
Thanks in advance.
I don't believe any version of SQL Server or MSDE prior to SQL Server 2005 is supported on Vista. Someone else on the team who works on SQL Server 2000 should reply with a definitive answer...
Paul
|||Vista is still under development, so the right place to post your questions is Vista Newsgroups under "Application Compatibility" issues. I think the OS group has a AppCompat team that should be able to help you.|||"Earlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a MSDE), SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server "Longhorn" or Windows Vista."
from http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx
sqlMSDE 2000 installation fails on Windows Vista 64-bit
Installation of MSDE 2000 fails on 64-bit Windows Vista (Build 5308).
The error message is "Setup failed to configure the server.Please refer the error logs for more information". No error log can be found on the machine at the time of installation. Please let me know if anyone else has encountered this problem?
Is it possible to install MSDE 2000 on 64-bit Windows Vista(Build 5308)?
Thanks in advance.
I don't believe any version of SQL Server or MSDE prior to SQL Server 2005 is supported on Vista. Someone else on the team who works on SQL Server 2000 should reply with a definitive answer...
Paul
|||Vista is still under development, so the right place to post your questions is Vista Newsgroups under "Application Compatibility" issues. I think the OS group has a AppCompat team that should be able to help you.|||"Earlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a MSDE), SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server "Longhorn" or Windows Vista."
from http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx
MSDE 2000 error
1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine Release A are the same.
2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3.exe
3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from this site and followed the instructions given there:
http://www.microsoft.com/downloads/d...displaylang=en
3a. I know it is working because I see the green arrow light at the taskbar for start/stop and pausing the SQL Server
3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/d...displaylang=en
3c. But when I use the SQL web administrator to connet to SQL server it doesn't, but I still see the green light on the taskbar. Am I doing something wrong?
4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to install that also?
5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET? I do have the scripts for intallling Northwind database and when I use the OSQL utility I get the error as
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine
Release A are the same.
> 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
> 3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from
this site and followed the instructions given there:
>
http://www.microsoft.com/downloads/d...displaylang=en
> 3a. I know it is working because I see the green arrow light at the
taskbar for start/stop and pausing the SQL Server
>
> 3b. I also downloaded the MS SQL Web Administrator from this site:
>
http://www.microsoft.com/downloads/d...displaylang=en
> 3c. But when I use the SQL web administrator to connet to SQL server it
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
>
> 4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to
install that also?
> 5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3.exe
3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from this site and followed the instructions given there:
http://www.microsoft.com/downloads/d...displaylang=en
3a. I know it is working because I see the green arrow light at the taskbar for start/stop and pausing the SQL Server
3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/d...displaylang=en
3c. But when I use the SQL web administrator to connet to SQL server it doesn't, but I still see the green light on the taskbar. Am I doing something wrong?
4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to install that also?
5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET? I do have the scripts for intallling Northwind database and when I use the OSQL utility I get the error as
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine
Release A are the same.
> 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
> 3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from
this site and followed the instructions given there:
>
http://www.microsoft.com/downloads/d...displaylang=en
> 3a. I know it is working because I see the green arrow light at the
taskbar for start/stop and pausing the SQL Server
>
> 3b. I also downloaded the MS SQL Web Administrator from this site:
>
http://www.microsoft.com/downloads/d...displaylang=en
> 3c. But when I use the SQL web administrator to connet to SQL server it
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
>
> 4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to
install that also?
> 5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
MSDE 2000 error
1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine Rele
ase A are the same.
2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does th
at also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this
stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3
.exe
3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from th
is site and followed the instructions given there:
http://www.microsoft.com/downloads/...&displaylang=en
3a. I know it is working because I see the green arrow light at the taskbar
for start/stop and pausing the SQL Server
3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/...&displaylang=en
3c. But when I use the SQL web administrator to connet to SQL server it does
n't, but I still see the green light on the taskbar. Am I doing something w
rong?
4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to ins
tall that also?
5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET?
I do have the scripts for intallling Northwind database and when I use the O
SQL utility I get the error as
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine
Release A are the same.
> 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
> 3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from
this site and followed the instructions given there:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3a. I know it is working because I see the green arrow light at the
taskbar for start/stop and pausing the SQL Server
>
> 3b. I also downloaded the MS SQL Web Administrator from this site:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3c. But when I use the SQL web administrator to connet to SQL server it
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
>
> 4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to
install that also?
> 5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.sql
ase A are the same.
2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does th
at also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this
stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3
.exe
3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from th
is site and followed the instructions given there:
http://www.microsoft.com/downloads/...&displaylang=en
3a. I know it is working because I see the green arrow light at the taskbar
for start/stop and pausing the SQL Server
3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/...&displaylang=en
3c. But when I use the SQL web administrator to connet to SQL server it does
n't, but I still see the green light on the taskbar. Am I doing something w
rong?
4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to ins
tall that also?
5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET?
I do have the scripts for intallling Northwind database and when I use the O
SQL utility I get the error as
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine
Release A are the same.
> 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
> 3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from
this site and followed the instructions given there:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3a. I know it is working because I see the green arrow light at the
taskbar for start/stop and pausing the SQL Server
>
> 3b. I also downloaded the MS SQL Web Administrator from this site:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3c. But when I use the SQL web administrator to connet to SQL server it
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
>
> 4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to
install that also?
> 5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.sql
Wednesday, March 21, 2012
Msde 2000
Hi
I installed the MSDE that comes with Office 2000. When connecting to my mdf, I received an error saying that the header file is invalid. I understand that the MSDE shipped with Office 2000 uses the SQL 7 engine, therefore it does not recognize the my SQL 2000 database file format. Can someone tell me where can I get a copy of the correct version of MSDE that will work with my SQL 2000 mdf?
Thanks
SHKMSDE 2000 (http://www.microsoft.com/sql/msde/downloads/download.asp)|||Thank You
I installed the MSDE that comes with Office 2000. When connecting to my mdf, I received an error saying that the header file is invalid. I understand that the MSDE shipped with Office 2000 uses the SQL 7 engine, therefore it does not recognize the my SQL 2000 database file format. Can someone tell me where can I get a copy of the correct version of MSDE that will work with my SQL 2000 mdf?
Thanks
SHKMSDE 2000 (http://www.microsoft.com/sql/msde/downloads/download.asp)|||Thank You
MSDE 2000
I'm trying to install this application but i get an error
Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
I'm running Windows XP SP2.
Could my SP2 be causing me problems considering I successfully installed it previously.
Many thanksWhat do the error logs say? That will be the key to solving theproblem. You might consider using the verbose setup log fileswitch on your SETUP.EXE command:
sql
Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
I'm running Windows XP SP2.
Could my SP2 be causing me problems considering I successfully installed it previously.
Many thanksWhat do the error logs say? That will be the key to solving theproblem. You might consider using the verbose setup log fileswitch on your SETUP.EXE command:
/L*v [filename]
sql
Monday, March 19, 2012
MSDE (SQL Server does not exist or access denied.)
Hi all,
I'm getting this error message when I try to connect my MSDE database from other machine using enterprise manager application. Both of the machines are WinXP SP2. I found some solution such as using 'SQLServer Network Utility' but didn't work out for me. I even can not connect my database on my computer using TCP/IP. When I connect with name, it worked fine. I already enable both TCP/IP and Named pipe protocol on the MSDE machine.
If someone has solution on that please let me know.
Thanks,
MyoDid you open the ports on the computers ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||If you have SQL Server 2005 installed on the same box as the MSDE, you need make sure SQL Browser is running. Make sure the ports (UDP/1434 and your TCP Port) are open if firewall exists. Also try file sharing between machines and make it work, otherwise NP won't work. When you use cliconfg.exe, make TCP and NP are on the client protocol lists.|||
Yes,
There is also SQL 2000 and 2005Express running together with MSDE. I already changed the port no and try to connect it. But, still didn't work out. I tried at the other machine and it works. I don't know why it still doesn't work at this machine. May be I miss some configuration. I'll try again. Thanks for the message.
Regards,
Myo|||
I have exactly the same issue. I have installed MSDE2000 on a PC with Windows XP Professional and SP2. I have tried everything to connect to another remote server and still get the same error message
I have added ports 135 and ports 445 to the firewall but again without much success. Does anyone out there have any ideas on how to get this working?
|||You will first have to determine the port that MSDE is using by starting the application Srvnetcn.exe naviagte to TCP and note that number down. After this you will have to create an exclude filter for the firewall for the application sqlservr.exe using this number and the 1434 UDP for incoming request. That should egt you started for SQL Server.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
Hi Jens,
Many thanks for your prompt response. I have tried all your suggestions but still cannot gain access to a remote database. TCP/IP is running on port 1433, using Srvnetcn.exe to check, and I have added both the entries you have suggested to the firewall exclude lists. Any other ideas? Thanks in advance
Friday, March 9, 2012
MSDE - 17207, udopen: Operating system error 32(error not found) during the creation/openi
Hi there
I'm hoping somebody here can help with this problem. In the Application Event Viewer we're seeing a problem. The error message is below
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17207, udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
Its promptly followed by this error
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17204, FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
The machine is running MSDE as its SQL Server and has two DBs
DB on D: which is 148,628k
DB on C: which is 237,568k
I'm pretty stuck on this one, so if anybody knows what's causing this problem, and more importantly how I can go about fixing it, it'd be most appreciated - I'm no SQL Guru and haven't been able to find a huge amount on knowledgebase searches or google searches
Thanks in anticipation
Steve S
stevesdmREMOVETHIS@.hotmail.comI dont know if this will help anyone, but the sql log shows this
2004-05-26 12:33:58.27 spid7 Starting up database 'Genifax'
2004-05-26 12:34:56.71 spid52 Starting up database 'Genifax'
2004-05-26 12:34:58.60 spid7 Starting up database 'Genifax'
2004-05-26 12:35:06.49 spid52 Starting up database 'Genifax'
2004-05-26 12:35:28.27 spid7 Starting up database 'Genifax'
2004-05-26 12:35:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:35:58.68 spid7 Starting up database 'Genifax'
2004-05-26 12:36:00.65 spid52 Starting up database 'Genifax'
2004-05-26 12:36:28.43 spid7 Starting up database 'Genifax'
2004-05-26 12:36:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:37:52.49 spid52 Starting up database 'Genifax'
2004-05-26 12:38:01.08 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
2004-05-26 12:38:53.74 spid52 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
2004-05-26 13:23:09.55 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager
The bottom line is where MSDE is restarted (which cures the problem for a day or two upon which MSDE causes problems again)
Like I said in my last message, any help is very very much appreciated
Thanks
Stev
I'm hoping somebody here can help with this problem. In the Application Event Viewer we're seeing a problem. The error message is below
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17207, udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
Its promptly followed by this error
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17204, FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
The machine is running MSDE as its SQL Server and has two DBs
DB on D: which is 148,628k
DB on C: which is 237,568k
I'm pretty stuck on this one, so if anybody knows what's causing this problem, and more importantly how I can go about fixing it, it'd be most appreciated - I'm no SQL Guru and haven't been able to find a huge amount on knowledgebase searches or google searches
Thanks in anticipation
Steve S
stevesdmREMOVETHIS@.hotmail.comI dont know if this will help anyone, but the sql log shows this
2004-05-26 12:33:58.27 spid7 Starting up database 'Genifax'
2004-05-26 12:34:56.71 spid52 Starting up database 'Genifax'
2004-05-26 12:34:58.60 spid7 Starting up database 'Genifax'
2004-05-26 12:35:06.49 spid52 Starting up database 'Genifax'
2004-05-26 12:35:28.27 spid7 Starting up database 'Genifax'
2004-05-26 12:35:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:35:58.68 spid7 Starting up database 'Genifax'
2004-05-26 12:36:00.65 spid52 Starting up database 'Genifax'
2004-05-26 12:36:28.43 spid7 Starting up database 'Genifax'
2004-05-26 12:36:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:37:52.49 spid52 Starting up database 'Genifax'
2004-05-26 12:38:01.08 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
2004-05-26 12:38:53.74 spid52 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
2004-05-26 13:23:09.55 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager
The bottom line is where MSDE is restarted (which cures the problem for a day or two upon which MSDE causes problems again)
Like I said in my last message, any help is very very much appreciated
Thanks
Stev
Wednesday, March 7, 2012
MSDE
I trying install MSDE 2000 for the first time on XP Sp2
When I try run setup it give error Instance name is invaild
only choice click ok. When I click it just goes away.
I now how do fix I just double clicking setup icon
Thanks for the help
hi Frank,
frank wrote:
> I trying install MSDE 2000 for the first time on XP Sp2
> When I try run setup it give error Instance name is invaild
> only choice click ok. When I click it just goes away.
> I now how do fix I just double clicking setup icon
>
> Thanks for the help
can you please post your command line you used to install MSDE?
MSDE must be installed using it's setup.exe boostrap installer, which
accepts (and requires) some parameters...
all usable parameters for installing a (somehow) customized MSDE are
available at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
just for the case, I've just installed an MSDE named instance on a brand new
WinXP sp 2 machine...
I disabled the antivirus (it was Avast), checked "File & Printer Sharing"
was enabled, the "Server" service was running..
the LAN access was available through the subnetmask exception...
I installed a named instance like
setup.exe INSTANCENAME="MSDE" SAPWD=*** SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0 /L*v "C:\MsdeLog.txt"
and that installed a named instance named "MSDE", allowing SQL Server
authenticated connections (mixed authentication), with support for remote
connections and logging the install process to C:\MsdeLog.txt, a text file
of about 2mb you can inspect for toubleshooting problems, searching for
RETURN VALUE 3
entries that denotate errors, where 10/20 lines before and/or after some
(somteime criptic) description of the problem is recoded... thi installation
worked as a charm... :D
after that I configured the Windows firewall defining an exception allowing
acces to the MSDE instance used TCP port and another exception for UDP 1434
port for the SQL Server Service Listener...
in order to configure XP sp2 for SQL Server connectivity you can ahave a
look at http://support.microsoft.com/default.aspx?kbid=841249
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
When I try run setup it give error Instance name is invaild
only choice click ok. When I click it just goes away.
I now how do fix I just double clicking setup icon
Thanks for the help
hi Frank,
frank wrote:
> I trying install MSDE 2000 for the first time on XP Sp2
> When I try run setup it give error Instance name is invaild
> only choice click ok. When I click it just goes away.
> I now how do fix I just double clicking setup icon
>
> Thanks for the help
can you please post your command line you used to install MSDE?
MSDE must be installed using it's setup.exe boostrap installer, which
accepts (and requires) some parameters...
all usable parameters for installing a (somehow) customized MSDE are
available at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
just for the case, I've just installed an MSDE named instance on a brand new
WinXP sp 2 machine...
I disabled the antivirus (it was Avast), checked "File & Printer Sharing"
was enabled, the "Server" service was running..
the LAN access was available through the subnetmask exception...
I installed a named instance like
setup.exe INSTANCENAME="MSDE" SAPWD=*** SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0 /L*v "C:\MsdeLog.txt"
and that installed a named instance named "MSDE", allowing SQL Server
authenticated connections (mixed authentication), with support for remote
connections and logging the install process to C:\MsdeLog.txt, a text file
of about 2mb you can inspect for toubleshooting problems, searching for
RETURN VALUE 3
entries that denotate errors, where 10/20 lines before and/or after some
(somteime criptic) description of the problem is recoded... thi installation
worked as a charm... :D
after that I configured the Windows firewall defining an exception allowing
acces to the MSDE instance used TCP port and another exception for UDP 1434
port for the SQL Server Service Listener...
in order to configure XP sp2 for SQL Server connectivity you can ahave a
look at http://support.microsoft.com/default.aspx?kbid=841249
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
MSDE
I have MSDE Deployment Kit with my SQL2000 CD.
But while installing it is giving error the name alredy
exists. And also tell me the sourse where i will get
examples and information about MSDE-2000.
Hi Rahul,
The MSDE can be installed multiple times on a single system. These separate
installations are called 'instances'. Each (apart from the default initial
instance) has a name. It is possible the one you are trying to create
already exists.
For info on the MSDE, a very good place to start is
http://www.microsoft.com/sql/msde
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Rahul" <superrahul@.hotmail.com> wrote in message
news:be2001c43817$4443bdf0$a001280a@.phx.gbl...
> I have MSDE Deployment Kit with my SQL2000 CD.
> But while installing it is giving error the name alredy
> exists. And also tell me the sourse where i will get
> examples and information about MSDE-2000.
>
|||Can you explain or give a reference for what a XPE runtime image is?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nigel" <anonymous@.discussions.microsoft.com> wrote in message
news:6DEDC927-7B23-4C28-B0FA-FF3528190688@.microsoft.com...
> Does microsoft or anyone for that matter have a solution for including MSDE in a XPE runtime image?
|||Nigel,
Yes, we have working MSDE component. The component has all necessary dependencies specified and works stable with Minlogon/Winlogon
images.
Regards,
KM,
BSquare Corporation
> Does microsoft or anyone for that matter have a solution for including MSDE in a XPE runtime image?
|||KM,
I am looking at a "Courtesy Copy for Reference Purposes Only" of the "Additional Licensing Provisions for Microsoft Windows XP Embedded Runtime Licenses", Paragraph 12, which states:
"COMPANY may not distribute in any manner, nor include in the Image, (i) the Microsoft Data Engine or (ii) The 'setup.exe' file contained in the SQLMSDE folder."
How can I interepret this paragraph in ANY way that lets me use MSDE in my embedded product?
~Desi
"KM" wrote:
> Nigel,
> Yes, we have working MSDE component. The component has all necessary dependencies specified and works stable with Minlogon/Winlogon
> images.
> --
> Regards,
> KM,
> BSquare Corporation
>
>
>
|||Bump for an unanswered thread...
Microsoft? Anyone?
"Desi Richards" wrote:
[vbcol=seagreen]
> KM,
> I am looking at a "Courtesy Copy for Reference Purposes Only" of the "Additional Licensing Provisions for Microsoft Windows XP Embedded Runtime Licenses", Paragraph 12, which states:
> "COMPANY may not distribute in any manner, nor include in the Image, (i) the Microsoft Data Engine or (ii) The 'setup.exe' file contained in the SQLMSDE folder."
> How can I interepret this paragraph in ANY way that lets me use MSDE in my embedded product?
> ~Desi
>
> "KM" wrote:
But while installing it is giving error the name alredy
exists. And also tell me the sourse where i will get
examples and information about MSDE-2000.
Hi Rahul,
The MSDE can be installed multiple times on a single system. These separate
installations are called 'instances'. Each (apart from the default initial
instance) has a name. It is possible the one you are trying to create
already exists.
For info on the MSDE, a very good place to start is
http://www.microsoft.com/sql/msde
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Rahul" <superrahul@.hotmail.com> wrote in message
news:be2001c43817$4443bdf0$a001280a@.phx.gbl...
> I have MSDE Deployment Kit with my SQL2000 CD.
> But while installing it is giving error the name alredy
> exists. And also tell me the sourse where i will get
> examples and information about MSDE-2000.
>
|||Can you explain or give a reference for what a XPE runtime image is?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nigel" <anonymous@.discussions.microsoft.com> wrote in message
news:6DEDC927-7B23-4C28-B0FA-FF3528190688@.microsoft.com...
> Does microsoft or anyone for that matter have a solution for including MSDE in a XPE runtime image?
|||Nigel,
Yes, we have working MSDE component. The component has all necessary dependencies specified and works stable with Minlogon/Winlogon
images.
Regards,
KM,
BSquare Corporation
> Does microsoft or anyone for that matter have a solution for including MSDE in a XPE runtime image?
|||KM,
I am looking at a "Courtesy Copy for Reference Purposes Only" of the "Additional Licensing Provisions for Microsoft Windows XP Embedded Runtime Licenses", Paragraph 12, which states:
"COMPANY may not distribute in any manner, nor include in the Image, (i) the Microsoft Data Engine or (ii) The 'setup.exe' file contained in the SQLMSDE folder."
How can I interepret this paragraph in ANY way that lets me use MSDE in my embedded product?
~Desi
"KM" wrote:
> Nigel,
> Yes, we have working MSDE component. The component has all necessary dependencies specified and works stable with Minlogon/Winlogon
> images.
> --
> Regards,
> KM,
> BSquare Corporation
>
>
>
|||Bump for an unanswered thread...
Microsoft? Anyone?
"Desi Richards" wrote:
[vbcol=seagreen]
> KM,
> I am looking at a "Courtesy Copy for Reference Purposes Only" of the "Additional Licensing Provisions for Microsoft Windows XP Embedded Runtime Licenses", Paragraph 12, which states:
> "COMPANY may not distribute in any manner, nor include in the Image, (i) the Microsoft Data Engine or (ii) The 'setup.exe' file contained in the SQLMSDE folder."
> How can I interepret this paragraph in ANY way that lets me use MSDE in my embedded product?
> ~Desi
>
> "KM" wrote:
msdb.dbo.sp_send_dbmail error
I make PROCEDURE to send email useing db msdb and this PROCEDURE dbo.sp_send_dbmail like this
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'saly',
@.recipients = @.email,
@.subject = @.subject,
@.body = @.body;
Go
And when EXEC it gives me mail qeue
and mail don't arrive where it goes i don't know please tell me what error
thankx very much
Check the mail log.
Have you start the smtp service
|||
hi
have the same promlem
and I have tried so many solutions.If u foud how to do so please tell me .
thanks
|||Its very likely an error with your SMTP server setup. Check to make sure that the machine you are sending the message from (sql server) is allowed to send smtp messages on your smtp server.Tim
msdb.dbo.sp_send_dbmail error
I make PROCEDURE to send email useing db msdb and this PROCEDURE dbo.sp_send_dbmail like this
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'saly',
@.recipients = @.email,
@.subject = @.subject,
@.body = @.body;
Go
And when EXEC it gives me mail qeue
and mail don't arrive where it goes i don't know please tell me what error
thankx very much
Check the mail log.
Have you start the smtp service
|||
hi
have the same promlem
and I have tried so many solutions.If u foud how to do so please tell me .
thanks
|||Its very likely an error with your SMTP server setup. Check to make sure that the machine you are sending the message from (sql server) is allowed to send smtp messages on your smtp server.Tim
msdb.dbo.sp_send_dbmail error
I make PROCEDURE to send email useing db msdb and this PROCEDURE dbo.sp_send_dbmail like this
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'saly',
@.recipients = @.email,
@.subject = @.subject,
@.body = @.body;
Go
And when EXEC it gives me mail qeue
and mail don't arrive where it goes i don't know please tell me what error
thankx very much
Check the mail log.
Have you start the smtp service
|||hi
have the same promlem
and I have tried so many solutions.If u foud how to do so please tell me .
thanks
|||Its very likely an error with your SMTP server setup. Check to make sure that the machine you are sending the message from (sql server) is allowed to send smtp messages on your smtp server.Tim
Saturday, February 25, 2012
MSDB Permissions Error
Hi,
We've just upgraded a server to a new box and copied all of the settings
from the existing box. We are running a VB client front end, with COM+ as
middle tier and SQL Server 2000 as BE.
The COM+ account is running under a windows domain account (which is also in
the local server administrators group), but all connections to the SQL Serve
r
database are under an SQL login 'AppUser'.
We are just testing the new configuration but are getting all sorts of
errors in the VB client FE. First of all, the FE tries to submit a job and
received error
'SELECT permission denied on msdb.sysjobs'
Does anyone know the cause of this error. As far as I can see, all of the
permissions on our new server are the same as the previous server' The logi
n
AppUser seems to be in all the correct groups.
(Just for testing purposes, I've made 'AppUser' part of the db_owner
database role in both these databases which of course fixes the above errors
.
But I do not want to leave it like this!!)
Any advice appreciated
ThanksHas the guest account been disabled in the msdb database. In the msdb
database, in Query Analyzer run the following command :
Select * from sysusers where name = 'guest'
Check the hasdbaccess column. It should be 1. If not run the following in
the msdb database:
sp_grantdbaccess 'guest'
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Hi Rand,
Thanks for response, i ran the SQL & 'hasdbaccess' column is flagged as 1.
Any other possibilities to check...?
Thanks
Dylan|||Check the permissions of the public role in the database.
Rand
This posting is provided "as is" with no warranties and confers no rights.
We've just upgraded a server to a new box and copied all of the settings
from the existing box. We are running a VB client front end, with COM+ as
middle tier and SQL Server 2000 as BE.
The COM+ account is running under a windows domain account (which is also in
the local server administrators group), but all connections to the SQL Serve
r
database are under an SQL login 'AppUser'.
We are just testing the new configuration but are getting all sorts of
errors in the VB client FE. First of all, the FE tries to submit a job and
received error
'SELECT permission denied on msdb.sysjobs'
Does anyone know the cause of this error. As far as I can see, all of the
permissions on our new server are the same as the previous server' The logi
n
AppUser seems to be in all the correct groups.
(Just for testing purposes, I've made 'AppUser' part of the db_owner
database role in both these databases which of course fixes the above errors
.
But I do not want to leave it like this!!)
Any advice appreciated
ThanksHas the guest account been disabled in the msdb database. In the msdb
database, in Query Analyzer run the following command :
Select * from sysusers where name = 'guest'
Check the hasdbaccess column. It should be 1. If not run the following in
the msdb database:
sp_grantdbaccess 'guest'
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Hi Rand,
Thanks for response, i ran the SQL & 'hasdbaccess' column is flagged as 1.
Any other possibilities to check...?
Thanks
Dylan|||Check the permissions of the public role in the database.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Subscribe to:
Posts (Atom)