Connect To Sql Server Desktop Engine Over Internet

Apr 11, 2004

i have got to connect to sql server desktop engine over internet with the following connection string

conString = "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=" & dbName & ";Network Address=" & IPAddress & ";Data Source=" & DataSource & " ;User ID=" & UserId & " ; Password=" & Password

Plz also inform me about the restriction imposed in connectivity by any of the window operating system such as that win 98 wont work or work!

There is no firewall involved. The two computers are in the same room and connected directly to the internet.

Even the ping is not going to either computer.

So what could be the possible problem and the solution.

need urgent

View 1 Replies


ADVERTISEMENT

SQL Server 2000 Desktop Engine

Feb 28, 2003

I have a few questions about the SQL Server Desktop Engine (MSDE), sorry there are so many ..

1. Which software products does this come with ?
2. If I create a SQL Server Database and want to distribute it to clients, how do I actually do it with MDSE ?
3. If I need to "upgrade" my database at some point in the future (that may contain data at a client site) how would I go about getting all the data out - would I need to write an external app ?
4. What are it's pros and cons when compared to installing full SQL Server on a client site ?
5. I've heard that the preformance of an MSDE Database degrades severely after more than 5 concurrent connections, is this just due to the performance of the product or is it something to do with the licencing model ?
6. Is it possible to write applications in, say VB, to alter the database once it has been installed on client site e.g. modify/create tables, indexes, stored procedures ?

Thanks for any help in advance ..

Scott..

View 2 Replies View Related

MSDE SQL Server 2000 Desktop Engine

Jan 21, 2004

Can someone advise me if this is basically SQL server 2000 and will work effectively to simulate sql server on a stand alone development machine ? Is this what its meant for?

I'm just not clear on this, here is the link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en

Thanks in advance for any advice.

View 2 Replies View Related

Microsoft SQL Server Desktop Engine Question

Jan 23, 2004

Hello,
I'm trying to install Microsoft SQL Server Desktop Engine (MDSE) and it said that I require a SA Password. I can't figure out how to do this.
Can anybody help?
Thanks,
Shenra

View 1 Replies View Related

Microsoft SQL Server 2000 Desktop Engine

Jan 29, 2004

Trying to install Microsoft SQL Server 2000 Desktop Engine on my laptop. I downloaded the software and opened it to a folder on the C drive. Then from the command prompt I entered this:

C:msderela>setup sapwd = hillary instancename=mjh targetdir=c:mike

The program starts to install and seems to get near to the end of instal and then the progress bar starts going backwards and nothing gets installed....any ideas of what I'm doing wrong....I really don't know anything about this at all.

Thanks

View 14 Replies View Related

Problem Install SQL Server Desktop Engine

Feb 27, 2004

I'm in the process of attempting to install Microsoft SQL Server Desktop Engine on my computer in support of an email program call Mailloop6. I've tried going through their tech support but they haven't been able to figure it out.

I'm running Windows XP with SP1 upgrade on a DSL connection.

When I installed the program the first time, I got the following error:

"Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information."

The program obviously wouldn't install. I contacted the vendor and they sent a version with a batch file. Same result. I removed all the appropriate registry entries between installs and removed all the data files as well.

I've tried installing the program using the free MDSE download from the MS site with the following result:

"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."


Here's the error log that I got after attempting to install:

2004-02-25 19:31:42.55 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2004-02-25 19:31:42.55 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-02-25 19:31:42.55 server All rights reserved.
2004-02-25 19:31:42.55 server Server Process ID is 3404.
2004-02-25 19:31:42.55 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL$MAILLOOP6LOGERRORLOG'.
2004-02-25 19:31:42.56 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-02-25 19:31:42.60 server SQL Server configured for thread mode processing.
2004-02-25 19:31:42.60 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-02-25 19:31:42.63 spid3 Warning ******************
2004-02-25 19:31:42.63 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-02-25 19:31:42.63 spid3 Starting up database 'master'.
2004-02-25 19:31:42.91 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-02-25 19:31:42.94 spid5 Starting up database 'model'.
2004-02-25 19:31:43.24 server SQL server listening on 152.163.0.0: 4113.
2004-02-25 19:31:43.24 server SQL server listening on 172.16.1.33: 4113.
2004-02-25 19:31:43.24 server SQL server listening on 127.0.0.1: 4113.
2004-02-25 19:31:43.25 spid3 Server name is 'MONSTERMAILLOOP6'.
2004-02-25 19:31:43.25 spid3 Skipping startup of clean database id 5
2004-02-25 19:31:43.25 spid3 Skipping startup of clean database id 6
2004-02-25 19:31:43.25 spid3 Starting up database 'msdb'.
2004-02-25 19:31:43.56 spid5 Clearing tempdb database.
2004-02-25 19:31:44.13 spid5 Starting up database 'tempdb'.
2004-02-25 19:31:44.17 spid3 Recovery complete.
2004-02-25 19:31:44.17 spid3 SQL global counter collection task is created.
2004-02-25 19:31:44.19 spid3 Warning: override, autoexec procedures skipped.
2004-02-25 19:31:47.75 server SQL server listening on TCP, Shared Memory, Named Pipes.
2004-02-25 19:31:47.75 server SQL Server is ready for client connections
2004-02-25 19:31:57.97 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.


Any thoughts on this would be very much appreciated!

View 2 Replies View Related

SQL Server 2000 Desktop Engine : SQL Agent

May 4, 2008

Did a SQL Server Desktop Engine 2000 (MSDE) having SQL Agent module?

View 2 Replies View Related

SQL Server 2005 Desktop Engine Distribution

Dec 31, 2007

Hi,
what is the distribution fee for SQL Server 2005 Desktop Engine distribution? Where can I find this information? I don't need it for development only for distribution.

Thanks,
LearningWPFnDotNet

View 7 Replies View Related

Sql Server 2000 Desktop Engine Installation

Jul 27, 2006

I have SQL Server 2000 installed on my laptop and am trying to install an instance of MSDE. I keep getting the error message: "The installation of SQL Server 2000 Desktop Engine has failed. Please see the Getting Started manual for further instructions."

I have done this installation before on other machines. Something must be corrupt on my machine (?). The error message is not very enlightening. Any ideas?

View 6 Replies View Related

Converting Desktop Engine To SQL Server 2005

Aug 3, 2006

I have got SQL Server Desktop Engine running with 2 database and I need
to install the evaluation version of SQL Server 2005 instead. A
straight upgrade does not seem to be possible. Does someone know if
backing up the databases, uninstalling the desktop engine, installing
SQL Server 2005 and then importing/restoring the databases would be an
option to look into?

View 1 Replies View Related

How To Create A Database On MS SQL Server Desktop Engine

Nov 30, 2005

Dear friends,

View 3 Replies View Related

Problem Microsoft SQL Server Desktop Engine (MSDE)

Sep 25, 2007



Hi

i'm chanaka my problem is i had a wsus 2.0 version server, last week my server disk was full, finaly i was move the Wsus data to new disk.with all the contens. when i try to move the datbase it's give the error.

when i open the wsus admin console it's give the error message. and it's add the event log error also. this thing is giving to me big problems.



Connection to database failed. Reason=Unknown error.. Connection string: Data Source=EMAIL-FILTERWSUS;Initial Catalog=SUSDB;Connection Timeout=60;Application Name=WSUS SQL Connection;Trusted_Connection=Yes;Pooling='true'; Max Pool Size = 100

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


if u can give me help. . please if u can give me help.


Best Regards,
shadow



Aucsna

View 1 Replies View Related

Installation Of Microsoft Sql Server Desktop Engine Hangs

May 16, 2008

During installation of MSDE the installation hangs at "please wait while Windows configures microsoft sql server desktop engine" I always end up killing the installation process. I am trying to install Windows XPe dev kit and this is the step I am getting stuck on. If I try to skip this step and setup the database the setup obviously tells me that i dont have sql 200 or MSDE installed.

The KB article http://support.microsoft.com/kb/811479 describes the syptoms perfectly, but fast user switching isnt even enabled for this machine and is not the source of the problem.

View 8 Replies View Related

SQL SERVER 2005 Desktop Engine Version Avaliable?

Nov 20, 2006



hi dear developers;

i just finished my program and i am making a setup for it but the db is MSSQL SERVER 2005. the home users how will they use sql server 2005? is there any thing like sql server 2000 desktop engine? something like that... shortly the user don't have to know sql server and settings of it so how will we do it???



thank you very much...

View 5 Replies View Related

How To Add Login User (ASPNET) To MS SQL 2000 Desktop Engine Server (MSDE2000)?

Sep 21, 2004

How do I add login user ASPNET to my SQL 2000 Desktop Engine Server?. I can not find the "Server Manager" in the Start - Programs. Is there any other way to get around adding ASPNET login to the SQL server so I can test my VB program. I got the error: Login failed for user 'com_nameASPNET'.

View 1 Replies View Related

How To Connect To Other M$ SQL Server Over Internet??(Help Me)

Oct 27, 2005

My English is not good.

I want to connect to other computer that installed M$ SQL Server2K over INTERNET. could you help me, plz.

I have used DNS (DOMAIN NAME SYSTEM) to forward to my computer( that connect to INTERNET) and my friend computer is the same. (because we have not static IP).

Thanks

:D

View 7 Replies View Related

Connect To Sql Server Through Internet

Mar 6, 2005

Hi,

Can someone please tell me how to do that?
I tried to connect to a sql server through internet by using sql query analyzer but it failed.

I searched for information in the internet but came to no avail.

Can someone please shed some light?

Thanks!

View 2 Replies View Related

Connect To SQL Server Via Internet

Sep 6, 2006

Hi there

We have the following problem. Our DB (MSDE 2000) is situated on remote server on which we

have
administrator privilege. The application which works on Local net connect to every machine in

the
net and see the database on one of the mashine as well.

The connection string is
data source=192.168.0.1XXXX;initial catalog=XXXX;integrated security=SSPI;persist security

info=True;workstation id=XXXX;packet size=4096"

but when we change IP in the connection string to our remote server(in internet with static IP) one we get

an exception says that
SQL server does not exist or access denied.
We opened ports on firewall but problem is still here. Then swithched off the firewall at all

but
same exception comes.
Thanks for answers

View 12 Replies View Related

Sql Server Does Not Exist When I Connect To Internet

Mar 18, 2004

Hi,

I am making a web application and it works fine. It uses Sql Server 2000 as the database. But when I connect to the Internet and compile or run my application it gives me this message :

" SQL SERVER DOES NOT EXIST OR ACCESS DENIED"

it works finewhen iam not connected to the internet

View 4 Replies View Related

Connect To Sql Server 2000 Via Internet

Jul 25, 2005

I'm Building a windows application which updates an internet site's database.Is it possible to connect directly to the sql server through the internet?If so is it the most efficient way ? perhaps a web service or streaming is a better solution?Thanks.

View 1 Replies View Related

Connect Throught Internet Between 2 Server.

Feb 27, 2004

Hi all,
I 'm in VietNam, i want to use SQL server 2000 to connect to SQL server in China throught the internet. I did it in many way but it did not work, please show me.
Best regards

View 2 Replies View Related

Connect To Sql Server 2005 Standard Thru Internet

Jul 12, 2007

Hi!I am trying to connect to my SqlServer 2005 thru internet, but it is notworking. I have a dyndns updater on my server which tells me an ip addressof the router. The router is configured to forward TCP port 1433 to LAN IPaddress of the computer on which is SQL Server installation.What is the connection string to connect to my server.I tried xxx.dyndns.org:1433, but it doesn't work. There is a defaultinstance installed on that machine.Please help.Zvonko

View 6 Replies View Related

Connect To SQL Server 2000 Trough Internet (adsl Connection )

Mar 29, 2007

Hi guys,



Can somebody tell me where i can find ( or explain me ) the steps to

connect to sql server using the internet. I am using VB6 (SP6) and SQL SERVER 2000

I want to set up asql server on a central location ( PC ) so that 4 different sites can access the data stored





Thanks for all help







grtz Robert

View 1 Replies View Related

Ssis Package Can't Connect To Pop Server Over The Internet From Sql Server Agent

Dec 20, 2007

Sql server agent is running under a domain account that is a member of administrators and domain users amongst others, and the package is executed as the service account. Connecting to servers on the same domain works and when I run it from the msdb package store in ssis (ssis runs under the network service account ...) it will connect to the pop server as well. Permissions, fiddly proxies .. the answer's out there somewhere

View 3 Replies View Related

Reporting Services :: Connect To Report Server From Client Through Internet Browser

Jun 11, 2015

after installing SQL Server 2008 R2 and the Reporting Services, I've managed to access the Report Manager URL....Reports through the web browser on the machine itself. But if i am trying to connect to on my client browser it does not find the Report Server.Do I need to configure the server in any way? Do I need to configure the firewall?

View 2 Replies View Related

Unable To Connect To SSIS Or SSRS On SQL Server 2005 Standard Edition Server Via Desktop Connection

Mar 8, 2008

Hi,

I€™ve developed a BI system using the SQL Server 2005 Developer€™s Edition.

SSAS, SSIS and SSRS have been added to a SQL Server 2005 Standard Edition Server in preparation for delivering the developed database to this live environment.

So I am able to connect directly to the Database Engine, SSAS, SSIS and SSRS successfully from the actual SQL Server 2005 Standard Edition box which is sat on a Windows 2003 Server operating system.


However when I launch SQL Server Management Studio from a desk top PC which is connected to the SQL Server Standard Edition box I can€™t connect to either SSIS or SSRS, however I can connect to the Database Engine and it also seems that I can connect to SSAS OK.

I am using Windows Authentication where the I used a SQL Server account which exists with €œsysadmin€? permissions and this SQL Server account has the same login name as the Windows Server 2003 desktop login.

What do I do next please?

View 4 Replies View Related

Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A

Feb 17, 2004

My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer.

I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm).

When I try to run setup, I get that message that says:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."

Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up?

I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks!

Ron

View 3 Replies View Related

Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release

Feb 16, 2006

venu writes "Hi,

Am very new to MS SQL adminstration
Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.

The activity which am going to workout on MSDE is below.

How to install SQL(on XP)
How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other)
How to create/delete tables if so, how can we do it either by GUI or CUI

just i need a clarifications reg same

Thank you,
venu"

View 1 Replies View Related

Desktop Engine And Concurrentlimit Registry Key

Feb 28, 2003

I was looking at the registry key value "ConcurrentLimit" in
"HKEY_LOCAL_MACHINE'SOFTWAREMicrosoftMicrosoft SQL Server80MSSQLLicenseInfoMSSQL8.00"

and wondering if this the concurrency control of SQL Server. Can someone please verify??

One of our SQL Production Server I inherited was installed with this version by mistake. The value for this key was set to 2. Does this mean it only allows 2 concurrent access to the SQL Server??

Thanks...byyu :)

View 4 Replies View Related

A Question Regarding MSDE Desktop Engine

Feb 19, 2005

Dear all,

This week I was told to setup MSDE Desktop Engine on my pc bcz my Access back end db is getting bigger in size. And as a little advance step, I decided to put my Access back end on SQL server.

To be frank, I have no experience with SQL server but after reading the instructions, I have installed MSDE (latest version) on my pc successfully. A small icon of SQL server appeared nearby clock icon of my pc showing the SQL server is running on ASHFAQUEPC.

I shifted a Trial db onto this server in following way.

Considering the opened Trial db would be my BE, from the Tools---Database Utility---Upsize wizard, I followed below steps according to Upsize wizard.

1.I selected ‘Local’ server and check marked to ’Use Trusted Connection’.
2.And then I selected some tables to export
3.Kept all default attributes of db as it is
4.Selected ‘Let the wizard decide’ under data option to include.
5.At the next step ‘What application change do you want to make?
a.Create a new Access client/Server application.
b.Link SQL Server tables to existing application.
c.No application changes. (I selected this option)

Then it showed me the report of my db description of changes that were made after deploying it. The report I did not print bcz it was a trial db with one table (2 fields) and a simple query.

My idea was to connect my Trial BE with another one of another Access mdb file so FE would be Access and BE would be from MSDE.

1.Now I don’t know how to link my BE to my FE?
2.From where I can directly see my BE? Because SQL Server Service Manager does
not have any menu?
3.Where I was wrong in following steps?

Guidance in this regards is highly appreciated.

With kind regards,
Ashfaque

View 1 Replies View Related

Install Sql 2005 On A Machine That Has Desktop Engine

Aug 18, 2007

My coworker tried install SQL server 2005 on a server. The server already has a desktop engine running as "MSSQLServer". Because the new sql server 2005 need running as a default instance. So he still using "MSSQLServer" as the instance name.

After installation, the service's running file seems still point to the old location. When view the properties on Management studio, it still report as "desk top engine" and the version is 8.xx..xxxx.

My question is,
1. What has been done during the installation? Is current desktop engine was upgraded?
2. In current situation, what can we do to install the SQL server 2005 as a default instance. Is there way to rename the desktop engine to a named instance?

Thanks

View 4 Replies View Related

Microsoft SqlServer Desktop Engine Connection Problem

Mar 15, 2004

i installed the MSDE2000A on server and i tried to connect from client machine through vb Application using connection string. Server anad client are in LAN. but Some systems able to connect and some systems are unable to connect.

i am getting the error:

"SqlServer does not exist or access denied "

for non connected machines.

the server is listening from these machines. but not connecting to MSDE.

can anyone give me solution what may be the cause.

View 6 Replies View Related

HOW TO CONNECT SQL OVER INTERNET

Jun 17, 2008

Please help me connect sql server over internet. I tested the connection in Windows XP, SQL Sever 2000, Router (forwarding IP port 1433) and its is working properly.
But using the same process in Windows 2000 Advance Server, Microsoft SQL Server 2000, Router (forwarding IP port 1433) Im getting the error "Unable to connect to server" . Can any one help me to setup this network. Thank you in advance!

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved